sqoop-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Kartik Rustagi <kartikrust...@gmail.com>
Subject Dealing with Postgresql schema when doing Hive import using Sqoop1.4.3
Date Thu, 20 Jun 2013 12:31:55 GMT
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

Mime
View raw message