Distinct on Multiple columns in Hive

Question

Hi does Hive support distinct on multiple columns. like select distinct(a, b, c, d) from table. If not is there a way to achieve this?

Answer 1

Yes, Hive does support distinct on multiple columns. You can do that by following

SELECT distinct col1, col2, col3 from TABLE

If you want to select distinct rows, you can use * instead

SELECT DISTINCT * FROM TABLE