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 >> 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…
>
>
>
>
>
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