Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded View
Hive >> mail # user >> How to get percentage of each group?


Copy link to this message
-
How to get percentage of each group?
I have a table, containing userId and userType.
userId    userType
1    A
2    B
3    C
4    A
5    B
6    B

I want to get percentage of each userType.
My current solution:
1. Get count of each group via THRIFT
select
      userType
    , count(1)
from
    some_table
group by
    userType

2. Calculate each userType using other programming language like PHP.

This solution is fine, but I'm just curious, is there a way to do it
in one query?
I know this query works in mysql, but not hive.
select
      userType
    , count(1)/(select count(1) from some_table)
from
    some_table
group by
    userType