hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
Subject Re: Sqoop Oracle Import to Hive Table - Error in metadata: InvalidObjectException
Date Sun, 26 May 2013 04:19:22 GMT

Can you try doing the import again after assigning 'DS12' the default schema for the user
doing the import. Your DB admin should be able to do this in oracle .

Bejoy KS

Sent from remote device, Please excuse typos

-----Original Message-----
From: Raj Hadoop <>
Date: Sat, 25 May 2013 14:54:50 
To: Hive<>
Subject: Sqoop Oracle Import to Hive Table - Error in metadata: InvalidObjectException


I am trying to run the following to load an Oracle table to Hive table using Sqoop,

sqoop import --connect jdbc:oracle:thin:@// --table DS12.CREDITS
--username UPX1 --password piiwer --hive-import

Note: DS12 is a schema and UPX1 is the user through which the schema and the table in the
schema is accessed. I was able to access the table through sqlplus client tool.

I am getting the following error. Can any one identify the issue and let me know please?

ERROR exec.Task ( - FAILED: Error in metadata: InvalidObjectException(message:There
is no database named ds12)
org.apache.hadoop.hive.ql.metadata.HiveException: InvalidObjectException(message:There is
no database named ds12)
        at org.apache.hadoop.hive.ql.metadata.Hive.createTable(
        at org.apache.hadoop.hive.ql.exec.DDLTask.createTable(
        at org.apache.hadoop.hive.ql.exec.DDLTask.execute(
        at org.apache.hadoop.hive.ql.exec.Task.executeTask(
        at org.apache.hadoop.hive.ql.exec.TaskRunner.runSequential(
        at org.apache.hadoop.hive.ql.Driver.launchTask(
        at org.apache.hadoop.hive.ql.Driver.execute(
        at org.apache.hadoop.hive.cli.CliDriver.processLocalCmd(
        at org.apache.hadoop.hive.cli.CliDriver.processCmd(
        at org.apache.hadoop.hive.cli.CliDriver.processLine(
        at org.apache.hadoop.hive.cli.CliDriver.processLine(
        at org.apache.hadoop.hive.cli.CliDriver.processReader(
        at org.apache.hadoop.hive.cli.CliDriver.processFile(
        at org.apache.hadoop.hive.cli.CliDriver.main(
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(
        at java.lang.reflect.Method.invoke(
        at org.apache.hadoop.util.RunJar.main(
Caused by: InvalidObjectException(message:There is no database named dw)
        at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.create_table(
        at org.apache.hadoop.hive.metastore.HiveMetaStoreClient.createTable(
        at org.apache.hadoop.hive.ql.metadata.Hive.createTable(
        ... 20 more

2013-05-25 17:37:14,276 ERROR ql.Driver ( - FAILED: Execution
Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask

View raw message