[jira] [Created] (SQOOP-748) HIVE_CONF_DIR is not being considered by the CLI "create-hive-table" command

["Guido Serra aka Zeph (JIRA)" <ji...@apache.org>]

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