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 more