You gotta fix hive issue first. What is the error you get when trying to create tables and load data on to them?
Regards Bejoy KS Sent from handheld, please excuse typos. -----Original Message----- From: soham sardar <[email protected]> Date: Fri, 8 Jun 2012 14:00:05 To: <[email protected]>; <[email protected]> Subject: Re: sqoop import problem with hive yes bejoy i am deleting the output dir everytime i m importing the same table and yea my hive has some issue but i dint know what i would be greatful if someone could get me out of this .. and m not able to create any sample table in hive ... On Fri, Jun 8, 2012 at 1:44 PM, Bejoy KS <[email protected]> wrote: > ** > 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. > ------------------------------ > *From: * soham sardar <[email protected]> > *Date: *Fri, 8 Jun 2012 13:32:15 +0530 > *To: *user<[email protected]> > *ReplyTo: * [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??????????* >
