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

Reply via email to