Soham Can you send the log with --verbose enabled.
It looks like your hive is having some issue. Are you able to create sample tables and load data into from hive CLI? Once the import is done the output dir will be created. So when you try the second time you need to delete that dir in hdfs. Regards Bejoy KS Sent from handheld, please excuse typos. -----Original Message----- From: soham sardar <[email protected]> Date: Fri, 8 Jun 2012 13:32:15 To: user<[email protected]> Reply-To: [email protected] Subject: sqoop import problem with hive *when i try to sqoop import into my hive the following error : sqoop import --connect jdbc:mysql://localhost:3306/hue --table inters --direct-split-size 8 --hive-import --create-hive-table --username hues -P * ERROR tool.ImportTool: Encountered IOException running import job: java.io.IOException: Hive exited with status 9 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:395) at com.cloudera.sqoop.tool.ImportTool.run(ImportTool.java:456) 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) this is the error in import when i use --import-hive *and also when i try to import the same table twice it says directory already contains the name specified so how to tackle this situation??????????*
