Kai Voigt created SQOOP-543:
-------------------------------
Summary: -hive-import not working with uppercase hostname
Key: SQOOP-543
URL: https://issues.apache.org/jira/browse/SQOOP-543
Project: Sqoop
Issue Type: Bug
Components: hive-integration
Affects Versions: 1.3.0
Environment: CDH3
Reporter: Kai Voigt
When running the following command, the import fails:
$ sqoop import --username training --password training --connect
jdbc:mysql://Localhost/training --hive-import --fields-terminated-by '\001'
--table Movies
The error message towards the end reads like this:
12/08/08 07:12:32 INFO hive.HiveImport: OK
12/08/08 07:12:32 INFO hive.HiveImport: Time taken: 4.098 seconds
12/08/08 07:12:32 INFO hive.HiveImport: FAILED: Error in semantic analysis:
Line 2:17 Path is not legal 'hdfs://Localhost/user/training/Movies': Move from:
hdfs://Localhost/user/training/Movies to:
hdfs://localhost/user/hive/warehouse/movies is not valid. Please check that
values for params "default.fs.name" and "hive.metastore.warehouse.dir" do not
conflict.
12/08/08 07:12:32 ERROR tool.ImportTool: Encountered IOException running import
job: java.io.IOException: Hive exited with status 10
at
com.cloudera.sqoop.hive.HiveImport.executeExternalHiveScript(HiveImport.java:349)
at com.cloudera.sqoop.hive.HiveImport.executeScript(HiveImport.java:299)
at com.cloudera.sqoop.hive.HiveImport.importTable(HiveImport.java:241)
at com.cloudera.sqoop.tool.ImportTool.importTable(ImportTool.java:394)
at com.cloudera.sqoop.tool.ImportTool.run(ImportTool.java:455)
at com.cloudera.sqoop.Sqoop.run(Sqoop.java:146)
at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:65)
at com.cloudera.sqoop.Sqoop.runSqoop(Sqoop.java:182)
at com.cloudera.sqoop.Sqoop.runTool(Sqoop.java:221)
at com.cloudera.sqoop.Sqoop.runTool(Sqoop.java:230)
at com.cloudera.sqoop.Sqoop.main(Sqoop.java:239)
Using "localhost" instead of "Localhost" in the command completes the import.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira