Hi Yogesh, it appears that you already have directory "empp" created in your home directory on HDFS. It's possible that this directory was created by previous sqoop import. Please remove this directory and it should work:
hadoop dfs -rmr empp Jarcec On Fri, Jun 22, 2012 at 06:09:22PM +0530, yogesh dhari wrote: > > 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 >
signature.asc
Description: Digital signature
