easiest way to do is .. write it in a temp table and then select uniq of each column and writing to real table
On Thu, Jan 30, 2014 at 3:19 PM, Raj hadoop <raj.had...@gmail.com> wrote: > 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. > -- Nitin Pawar