question Re: sqoop incremental import using composite primary key as merge-key in Support Questions

sqoop incremental import using composite primary key as merge-key

klksrinivas — Thu, 05 Jan 2017 18:04:09 GMT

sqoop incremental import using composite primary key as merge-key

Re: sqoop incremental import using composite primary key as merge-key

klksrinivas — Fri, 06 Jan 2017 13:05:09 GMT

Currently sqoop incremental does not support composite primary key as per the design,but an alternative would be to concatenate the composite primary key concat(PK1,PK2) as UniqueId while importing and using the UniqueId as --merger-key instead of a single primary key.

Re: sqoop incremental import using composite primary key as merge-key

jyothireddy119 — Thu, 21 Dec 2017 03:58:06 GMT

Hi @Krishna Srinivas

I am facing the same issue, where in I have to specify the composite primary key in merge-key. But it is giving me the error. Can you please explain me on how can I achieve the above mentioned answer by taking an example. That will help me understand more clearly.

Thanks in Advance !!