Eric,   i am connecting as a user user1 and have select privillage on a table from a user id user2 in hive not sure how it will find the table under the user2 id while i am connecting as user1   Oracle Database name “CPMDWDEV” , Table owner user id - “edw” and Connected id –“obaw” [cghosh@usmbg-lcldpoct1 ~]$ sqoop import \ > --connect jdbc:oracle:thin:@usmbg-lcpmdbt1.amer.exel-intra.net:1592:CPMDWDEV \ > --username obaw \ > --password xxxxxx \ > --table EDW.XXOB_GL_ACCOUNT_HIER_WIDS -m 1 \ > --hive-import \ > --hive-table EDW.XXOB_GL_ACCOUNT_HIER_WIDS \ > --target-dir /user/cghosh/sqoopimport/DWDEV/TEST   Error 13/09/03 14:45:46 INFO hive.HiveImport: FAILED: Error in metadata: Invalid table name: CPMDWDEV.EDW.XXOB_GL_ACCOUNT_HIER_WIDS 13/09/03 14:45:46 INFO hive.HiveImport: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask 13/09/03 14:45:46 ERROR tool.ImportTool: Encountered IOException running import job: java.io.IOException: Hive exited with status 1   ... View more