Hi,
I am having an issue dealing with the DB->Schema->Table hierarchy of
Postgresql with --hive-import option in sqoop. I am able to successfully
import data to HDFS by mentioning --table as schema_name.table_name and
--split-by as schema_name.table_name.id (I have mentioned the DB in the
--connect option), But when doing --hive-import I get the error:
13/06/20 17:59:56 *INFO hive.HiveImport: FAILED: Error in metadata:
InvalidObjectException(message:There is no database named schema_namel)*
13/06/20 17:59:56 INFO hive.HiveImport: FAILED: Execution Error, return
code 1 from org.apache.hadoop.hive.ql.exec.DDLTask
13/06/20 17:59:56 ERROR tool.ImportTool: Encountered IOException running
import job: java.io.IOException: Hive exited with status 1
at
org.apache.sqoop.hive.HiveImport.executeExternalHiveScript(HiveImport.java:364)
at org.apache.sqoop.hive.HiveImport.executeScript(HiveImport.java:314)
at org.apache.sqoop.hive.HiveImport.importTable(HiveImport.java:226)
at org.apache.sqoop.tool.ImportTool.importTable(ImportTool.java:415)
at org.apache.sqoop.tool.ImportTool.run(ImportTool.java:476)
at org.apache.sqoop.Sqoop.run(Sqoop.java:145)
at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:65)
at org.apache.sqoop.Sqoop.runSqoop(Sqoop.java:181)
at org.apache.sqoop.Sqoop.runTool(Sqoop.java:220)
at org.apache.sqoop.Sqoop.runTool(Sqoop.java:229)
at org.apache.sqoop.Sqoop.main(Sqoop.java:238)
--
Regards
Kartik Rustagi
