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?
Distinct on Multiple columns in Hive
Asked Answered
Yes, Please refer to following link on how to use distinct cwiki.apache.org/confluence/display/Hive/… –
Colville
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
© 2022 - 2024 — McMap. All rights reserved.