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
Sqoop >> mail # user >> sqoop merge on primary key with multiple columns


Copy link to this message
-
Re: sqoop merge on primary key with multiple columns
Hi Wayne,
please do not spam multiple lists with the same question.

Sqoop currently do not support composite primary keys, so merge won't work correctly in this case.

Jarcec

On Mon, Sep 09, 2013 at 02:56:37PM -0500, Zhu Wayne wrote:
> Could sqoop merge on a primary key having multiple columns?
> ALTER TABLE "MYSCHEMA"."CATENTDESC"
>
>         ADD PRIMARY KEY
>
>                 ("CATENTRY_ID",
>
>                  "LANGUAGE_ID");
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