Duplicates In Hive

[#1]

How can we find Duplicate rows in Hive? 

Can write the query same way we do in SQL instead of using Distributed By at the place of Group by. 

Please suggest

[#2]

Yes you can do it in multiple ways. For example you can use Group by or Distinct. If you want to find duplicities on the subset of the columns (i.e. find all rows where customer_id is duplicate) I would recommend to use a Group by.