New Contributor
Posts: 5
Registered: ‎09-03-2013
Re: Hive Imports

got the answer from Chris - Systems Engineer - Cloudera

 

"--table" will refer to the Oracle schema and tablename

"--hive-table" will be the name of the database and table you are creating in Hive.  

 

If you aren't using a database other than the default database, then this value will be just the name of the table you are trying to create in Hive.  

 

[cghosh@usmbg-lcldpoct1 ~]$ sqoop import \

> --connect jdbc:oracle:thin:@usmbg-lcpmdbt1.amer.exel-intra.net:1592:CPMDWDEV \

> --username obaw \

> --password oracle \

> --table EDW.XXOB_GL_ACCOUNT_HIER_WIDS -m 1 \

> --hive-import \

> --hive-table XXOB_GL_ACCOUNT_HIER_WIDS \

> --target-dir /user/cghosh/sqoopimport/DWDEV/TEST

 

View solution in original post

Who Me Too'd this solution