Encountered IOException running import job: org.apache.hadoop.mapred.FileAlreadyExistsException: Output directory emp already exists

Fri, 22 Jun 2012 05:39:54 -0700 

Hi,
I am trying to import tables from RDBMS to Hive using sqoop,I used this command

sqoop import --connect jdbc:mysql://localhost:3306/Demo --username sqoop1 
--password SQOOP1 --table emp --hive-table empp --create-hive-table 
--hive-import --hive-home path/to/HIVE_HOME -m 1


and this error message comes...


Encountered IOException running import job: 
org.apache.hadoop.mapred.FileAlreadyExistsException: Output directory emp 
already exists
    at 
org.apache.hadoop.mapreduce.lib.output.FileOutputFormat.checkOutputSpecs(FileOutputFormat.java:123)
    at org.apache.hadoop.mapred.JobClient.submitJobInternal(JobClient.java:770)
    at org.apache.hadoop.mapreduce.Job.submit(Job.java:432)
    at org.apache.hadoop.mapreduce.Job.waitForCompletion(Job.java:447)
    at org.apache.sqoop.mapreduce.ImportJobBase.runJob(ImportJobBase.java:141)
    at 
org.apache.sqoop.mapreduce.ImportJobBase.runImport(ImportJobBase.java:201)
    at org.apache.sqoop.manager.SqlManager.importTable(SqlManager.java:413)
    at org.apache.sqoop.manager.MySQLManager.importTable(MySQLManager.java:97)
    at org.apache.sqoop.tool.ImportTool.importTable(ImportTool.java:380)
    at org.apache.sqoop.tool.ImportTool.run(ImportTool.java:453)
    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)





Please help and do suggest
Thanks & RegardsYogesh Kumar08147912904

Reply via email to