Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded View
Sqoop >> mail # user >> Composite Key


Copy link to this message
-
Re: Composite Key
Nick,

No problem. Glad you got things going!

-Abe
On Tue, Dec 10, 2013 at 11:28 AM, Martin, Nick <[EMAIL PROTECTED]> wrote:

>  Sorry Abe that was a bit confusing on my part.
>
>
>
> However, I solved what I was looking to do using a free form import w/
> concat of the two fields comprising the composite PK.
>
>
>
> Appreciate the help!
>
>
>
> *From:* Abraham Elmahrek [mailto:[EMAIL PROTECTED]]
> *Sent:* Monday, December 09, 2013 1:41 PM
> *To:* [EMAIL PROTECTED]
> *Subject:* Re: Composite Key
>
>
>
> Hey Nick,
>
>
>
> I'm not sure I understand what you're asking... are you asking if you can
> split by composite key? I don't think that's currently possible. Splitting
> occurs on a single column. Are you asking if data can make its way into
> HDFS (or Hive) via the composite key? You might have to use free-form
> queries. You should be able to use an oracle function to concat the two
> columns together. See
> http://sqoop.apache.org/docs/1.4.4/SqoopUserGuide.html#_free_form_query_importsfor more details on that. You should be able to use to_char (
> http://docs.oracle.com/cd/B19306_01/server.102/b14200/functions181.htm)
> and concat (
> http://docs.oracle.com/cd/B19306_01/server.102/b14200/functions026.htm)
> functions.
>
>
>
> -Abe
>
>
>
> On Mon, Dec 9, 2013 at 9:17 AM, Martin, Nick <[EMAIL PROTECTED]> wrote:
>
> I’m doing an import/export with an Oracle table that has a composite key
> as the PK (so PRIMARY KEY(col1,col2))
>
>
>
> I dug through the Sqoop documentation and I see that I can set a composite
> key for HBase imports (--hbase-row-key) but I’m wondering how/if I can use
> the composite key from my source Oracle table without HBase?
>
>
>
> Hope that makes sense…
>
>
>
>
>