Home | About | Sematext search-lucene.com search-hadoop.com
 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
Igor Tatarinov 2012-05-28, 22:28
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
>