Hi All, I have a table in Hive as below:
dummy { col1 STRING, col2 INT, col3 INT } And in that there is some sample data as : *col1 col2 col3 * ABC 4 5 XYZ 1 2 ABC 1 3 ABC 5 1 XYZ 3 1 What should be my query so as to get the below result: *ABC 4 XYZ 3* Basically I'm trying to get a count of distinct elements from *col2 and col3 combined* and group them against col1. I tried with a query as: select col1, count(distinct col2, col3) from dummy group by col1 But didn't get the expected output. Can anybody point me in the correct direction and suggest a correct query. Thanks.