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

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 1.4.2
• Component/s: hive-integration
• Assignee: Unassigned
• Reporter: Guido Serra aka Zeph
• Created: 10/Dec/12 17:25
• Updated: 10/Dec/12 17:25

Description

I got a clean install on OsX via:

brew install sqoop

• 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

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)