delete duplicate records in Hive table

[Raj hadoop]

Hi,

Can someone help me how to delete duplicate records in Hive table,

I know that delete and update are not supported by hive but still,

if some know's some alternative can help me in this

Thanks,
Raj.