Hi Soham, what sqoop version are you using? Also could you please send us entire execution stack executed with --verbose option?
The issue with repeated HIVE import and exception "FileAlreadyExistsException" is known and was fixed in SQOOP-443 that will be included in next version. Workaround for older versions is to manually remove empty staging directory left in the default location. For example by calling: hadoop dfs -rmr $tableName # Remove directory $tableName from your home directory Jarcec On Thu, Jun 07, 2012 at 01:21:31PM +0530, soham sardar wrote: > no there isint any change if i specify my command as > > > *sqoop import --connect jdbc:mysql://localhost:3306/hue --table hue.users > --username hues -P --hive-import --hive-table Audit_logs > * > can u gimme some other alternative ...... > On Thu, Jun 7, 2012 at 12:45 PM, Kathleen Ting <[email protected]> wrote: > > > Hi Soham, > > > > Can you try doing a sqoop import while specifying your table as > > database.table (i.e. with dot notation)? > > > > Regards, Kathleen > > > > > > On Wed, Jun 6, 2012 at 11:47 PM, soham sardar > > <[email protected]>wrote: > > > >> *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??????????* > > > > > >
signature.asc
Description: Digital signature
