Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 Search Hadoop and all its subprojects:

Switch to Threaded View
Hive >> mail # user >> delete duplicate records in Hive table


Copy link to this message
-
Re: delete duplicate records in Hive table
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 <[EMAIL PROTECTED]> 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

 
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB