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


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…