Guido Serra aka Zeph created SQOOP-748:
------------------------------------------
Summary: HIVE_CONF_DIR is not being considered by the CLI
"create-hive-table" command
Key: SQOOP-748
URL: https://issues.apache.org/jira/browse/SQOOP-748
Project: Sqoop
Issue Type: Bug
Components: hive-integration
Affects Versions: 1.4.2
Reporter: Guido Serra aka Zeph
I got a clean install on OsX via:
{code}
brew install sqoop
{code}
- sqoop: stable 1.4.2
- hive: stable 0.9.0
- hadoop: stable 1.1.1
I can easily pass to hive's CLI the proper env variable HIVE_CONF_DIR
in order to feed it with a crafted hive-default.xml where the key:
- hive.metastore.warehouse.dir
gets set via "sed" with what I need, and not the default:
- /user/hive/warehouse
...instead, running via sqoop's CLI, I always get the default
I digged down into the bin/sqoop shell script, and the env variable get's
properly propagated... at this stage I have only the option of digging at java
level
{noformat}
12/12/10 18:24:40 INFO hive.HiveImport: FAILED: Error in metadata:
MetaException(message:file:/user/hive/warehouse/sales_order is not a directory
or unable to create one)
12/12/10 18:24:40 INFO hive.HiveImport: FAILED: Execution Error, return code 1
from org.apache.hadoop.hive.ql.exec.DDLTask
12/12/10 18:24:40 ERROR tool.CreateHiveTableTool: Encountered IOException
running create table job: java.io.IOException: Hive exited with status 9
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.CreateHiveTableTool.run(CreateHiveTableTool.java:58)
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)
at com.cloudera.sqoop.Sqoop.main(Sqoop.java:57)
{noformat}
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
