You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@hive.apache.org by Raj hadoop <ra...@gmail.com> on 2014/01/30 10:49:18 UTC

delete duplicate records in Hive table

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.

Re: delete duplicate records in Hive table

Posted by Raj hadoop <ra...@gmail.com>.

Hi Nitin,

Thanks a ton for quick response,

Could you please share if any sql syntax for this

Thanks,
Raj.


On Thu, Jan 30, 2014 at 3:29 PM, Nitin Pawar <ni...@gmail.com>wrote:

> 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 <ra...@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
>

Re: delete duplicate records in Hive table

Posted by Nitin Pawar <ni...@gmail.com>.

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 <ra...@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