Support Questions
Find answers, ask questions, and share your expertise
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Who agreed with this solution

Re: Hive Imports

New Contributor

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


Who agreed with this solution