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, <bejoy...@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 <hadoop...@yahoo.com> > *Date: *Sat, 25 May 2013 14:54:50 -0700 (PDT) > *To: *Hive<user@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 > > >
