Hi All, Does hive support subquery in select statement? Given below data, I need counts and percentage counts per category. The divisor in my case is not the total count, but something that is stored in another table.. In T-SQL, I can do subquery in select statement to get my divisor.
Select id, count(*), count(*)/ (select val from tableY where name like ‘xyzdivisor’) >From data Group by category What am I missing? This looks like a simple case.. 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 Thanks, Prashant
