You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@hive.apache.org by Raj Hadoop <ha...@yahoo.com> on 2013/05/25 23:54:50 UTC
Sqoop Oracle Import to Hive Table - Error in metadata: InvalidObjectException
Hi,
I am trying to run the following to load an Oracle table to Hive table using Sqoop,
sqoop import --connect jdbc:oracle:thin:@//inferri.dm.com:1521/DBRM25 --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 (SessionState.java:printError(400)) - 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(Hive.java:544)
at org.apache.hadoop.hive.ql.exec.DDLTask.createTable(DDLTask.java:3305)
at org.apache.hadoop.hive.ql.exec.DDLTask.execute(DDLTask.java:242)
at org.apache.hadoop.hive.ql.exec.Task.executeTask(Task.java:134)
at org.apache.hadoop.hive.ql.exec.TaskRunner.runSequential(TaskRunner.java:57)
at org.apache.hadoop.hive.ql.Driver.launchTask(Driver.java:1326)
at org.apache.hadoop.hive.ql.Driver.execute(Driver.java:1118)
at org.apache.hadoop.hive.ql.Driver.run(Driver.java:951)
at org.apache.hadoop.hive.cli.CliDriver.processLocalCmd(CliDriver.java:258)
at org.apache.hadoop.hive.cli.CliDriver.processCmd(CliDriver.java:215)
at org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:406)
at org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:341)
at org.apache.hadoop.hive.cli.CliDriver.processReader(CliDriver.java:439)
at org.apache.hadoop.hive.cli.CliDriver.processFile(CliDriver.java:449)
at org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:647)
at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:557)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:601)
at org.apache.hadoop.util.RunJar.main(RunJar.java:156)
Caused by: InvalidObjectException(message:There is no database named dw)
at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.create_table(HiveMetaStore.java:852)
at org.apache.hadoop.hive.metastore.HiveMetaStoreClient.createTable(HiveMetaStoreClient.java:402)
at org.apache.hadoop.hive.ql.metadata.Hive.createTable(Hive.java:538)
... 20 more
2013-05-25 17:37:14,276 ERROR ql.Driver (SessionState.java:printError(400)) - FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask
Thanks,
Raj
Re: Sqoop Oracle Import to Hive Table - Error in metadata: InvalidObjectException
Posted by Edward Capriolo <ed...@gmail.com>.
I think the problem is that hive is trying to import into a database named
ds12
validObjectException(
message:There is no database named ds12)
try this:
hive > create database ds12;
Also be careful you just send the entire internet your oracle PW and
username,
On Sun, May 26, 2013 at 12:19 AM, <be...@yahoo.com> wrote:
> Hi
>
> 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 .
> Regards
> Bejoy KS
>
> Sent from remote device, Please excuse typos
> ------------------------------
> *From: * Raj Hadoop <ha...@yahoo.com>
> *Date: *Sat, 25 May 2013 14:54:50 -0700 (PDT)
> *To: *Hive<us...@hive.apache.org>
> *ReplyTo: * user@hive.apache.org
> *Subject: *Sqoop Oracle Import to Hive Table - Error in metadata:
> InvalidObjectException
>
> Hi,
>
> I am trying to run the following to load an Oracle table to Hive table
> using Sqoop,
>
> sqoop import --connect jdbc:oracle:thin:@//inferri.dm.com:1521/DBRM25--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 (SessionState.java:printError(400)) - 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(Hive.java:544)
> at
> org.apache.hadoop.hive.ql.exec.DDLTask.createTable(DDLTask.java:3305)
> at org.apache.hadoop.hive.ql.exec.DDLTask.execute(DDLTask.java:242)
> at org.apache.hadoop.hive.ql.exec.Task.executeTask(Task.java:134)
> at
> org.apache.hadoop.hive.ql.exec.TaskRunner.runSequential(TaskRunner.java:57)
> at org.apache.hadoop.hive.ql.Driver.launchTask(Driver.java:1326)
> at org.apache.hadoop.hive.ql.Driver.execute(Driver.java:1118)
> at org.apache.hadoop.hive.ql.Driver.run(Driver.java:951)
> at
> org.apache.hadoop.hive.cli.CliDriver.processLocalCmd(CliDriver.java:258)
> at
> org.apache.hadoop.hive.cli.CliDriver.processCmd(CliDriver.java:215)
> at
> org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:406)
> at
> org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:341)
> at
> org.apache.hadoop.hive.cli.CliDriver.processReader(CliDriver.java:439)
> at
> org.apache.hadoop.hive.cli.CliDriver.processFile(CliDriver.java:449)
> at org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:647)
> at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:557)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> at java.lang.reflect.Method.invoke(Method.java:601)
> at org.apache.hadoop.util.RunJar.main(RunJar.java:156)
> Caused by: InvalidObjectException(message:There is no database named dw)
> at
> org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.create_table(HiveMetaStore.java:852)
> at
> org.apache.hadoop.hive.metastore.HiveMetaStoreClient.createTable(HiveMetaStoreClient.java:402)
> at
> org.apache.hadoop.hive.ql.metadata.Hive.createTable(Hive.java:538)
> ... 20 more
>
> 2013-05-25 17:37:14,276 ERROR ql.Driver
> (SessionState.java:printError(400)) - FAILED: Execution Error, return code
> 1 from org.apache.hadoop.hive.ql.exec.DDLTask
>
>
> Thanks,
> Raj
>
>
>
Re: Sqoop Oracle Import to Hive Table - Error in metadata: InvalidObjectException
Posted by be...@yahoo.com.
Hi
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 .
Regards
Bejoy KS
Sent from remote device, Please excuse typos
-----Original Message-----
From: Raj Hadoop <ha...@yahoo.com>
Date: Sat, 25 May 2013 14:54:50
To: Hive<us...@hive.apache.org>
Reply-To: user@hive.apache.org
Subject: Sqoop Oracle Import to Hive Table - Error in metadata: InvalidObjectException
Hi,
I am trying to run the following to load an Oracle table to Hive table using Sqoop,
sqoop import --connect jdbc:oracle:thin:@//inferri.dm.com:1521/DBRM25 --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 (SessionState.java:printError(400)) - 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(Hive.java:544)
at org.apache.hadoop.hive.ql.exec.DDLTask.createTable(DDLTask.java:3305)
at org.apache.hadoop.hive.ql.exec.DDLTask.execute(DDLTask.java:242)
at org.apache.hadoop.hive.ql.exec.Task.executeTask(Task.java:134)
at org.apache.hadoop.hive.ql.exec.TaskRunner.runSequential(TaskRunner.java:57)
at org.apache.hadoop.hive.ql.Driver.launchTask(Driver.java:1326)
at org.apache.hadoop.hive.ql.Driver.execute(Driver.java:1118)
at org.apache.hadoop.hive.ql.Driver.run(Driver.java:951)
at org.apache.hadoop.hive.cli.CliDriver.processLocalCmd(CliDriver.java:258)
at org.apache.hadoop.hive.cli.CliDriver.processCmd(CliDriver.java:215)
at org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:406)
at org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:341)
at org.apache.hadoop.hive.cli.CliDriver.processReader(CliDriver.java:439)
at org.apache.hadoop.hive.cli.CliDriver.processFile(CliDriver.java:449)
at org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:647)
at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:557)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:601)
at org.apache.hadoop.util.RunJar.main(RunJar.java:156)
Caused by: InvalidObjectException(message:There is no database named dw)
at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.create_table(HiveMetaStore.java:852)
at org.apache.hadoop.hive.metastore.HiveMetaStoreClient.createTable(HiveMetaStoreClient.java:402)
at org.apache.hadoop.hive.ql.metadata.Hive.createTable(Hive.java:538)
... 20 more
2013-05-25 17:37:14,276 ERROR ql.Driver (SessionState.java:printError(400)) - FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask
Thanks,
Raj