Hi Jarcec, Firstly i checked the same, but there was no empp directory. Sqoop imports first to HDFS and then from HDFS to Hive, and it creates directory say empp and when it goes to Hive this error comes. If I am Right? There is some issue regarding it, I goggled a lot.but didn't find the solution. Please suggest and help. Thanks & RegardsYogesh Kumar
> Date: Fri, 22 Jun 2012 14:45:24 +0200 > From: [email protected] > To: [email protected] > Subject: Re: Encountered IOException running import job: > org.apache.hadoop.mapred.FileAlreadyExistsException: Output directory emp > already exists > > 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 > >
