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 \

> --username obaw \

> --password oracle \


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