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