Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 Search Hadoop and all its subprojects:

Switch to Threaded View
Hive >> mail # user >> Need help with simple subquery


Copy link to this message
-
Re: Need help with simple subquery
Try replacing the comma with JOIN

igor
decide.com

On Mon, May 28, 2012 at 6:48 AM, shan s <[EMAIL PROTECTED]> wrote:

> I need help with a simple subquery. Given below data, I need counts and
> percentage counts per category. (Re-phrasing my earlier question )
> With the code below I get an error: *FAILED: Parse Error:* line 6:50 *mismatched
> input ','* *expecting EOF near 'a'*
>
> Looking at the documentation the syntax it is not clear to me.. In the
> form clause, can I have multiple selects and just alias them and use them
> in the top query?
> If so, what am I missing in the below code...
>
> select a.category, a.count, b.totalCount
> from
> (select category, count(*) as count from gt group by category) a,
> (select count(*) as totalCount from gt) b ;
>
> Many Thanks,
> Prashant.
>
> Id Category         Count Output   Percentage Output
> 1    A                    A      4             A     40 (4/10)*100
> 2    A                    B      3             B     30
> 3    B                    C      3             C     30
> 4    A
> 5    C
> 6    C
> 7    B
> 8    B
> 9    A
> 10  C
>
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB