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