Hadoop – SQOOP cannot be imported into form

sqoop import --connect jdbc:mysql://localhost/hadoopguide - table widgets

14/02/06 14:02:17 WARN mapred.LocalJobRunner: job_local177721176_0001< br />java.lang.Exception: java.lang.RuntimeException: java.lang.ClassNotFoundException: Class widgets not found
 at org.apache.hadoop.mapred.LocalJobRunner$Job.run(LocalJobRunner.java:403) 
Caused by: java.lang.RuntimeException: java.lang.ClassNotFoundException: Class widgets not found
 at org.apache.hadoop.conf.Configuration.getClass(Configuration.java:1720)
 at org.apache.sqoop.mapreduce.db.DBConfiguration.getInputClass(DBConfiguration.java:394)
 at org.apache.sqoop.mapreduce.db.DataDrivenDBInputFormat.createDBRecordReader(DataDrivenDBInputFormat.java:233)
 at org.apache.sqoop.mapreduce.db.DBInputFormat.createRecordReader(DBInputFormat.java:236)
 at org.apache.hadoop.mapred.MapTask$NewTrackingRecordReader.(MapTask.java:491)
 at org.apache.hadoop.mapred.MapTask.runNewMapper(MapTask.java:734)
 at org.apache.hadoop.mapred.MapTask.run(MapTask.java:339)
 at org.apache.hadoop.mapred.LocalJobRunner$Job$MapTaskRunnable.run(LocalJobRunner.java:235)
 at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:439)
 at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
 at java. util.concurrent.FutureTask.run(FutureTask.java:138)
 at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:895)
 at java.util.concurrent.ThreadPoolExecutor$ Worker.run(ThreadPoolE xecutor.java:918)
 at java.lang.Thread.run(Thread.java:662)
Caused by: java.lang.ClassNotFoundException: Class widgets not found
 at org.apache .hadoop.conf.Configuration.getClassByName(Configuration.java:1626)
 at org.apache.hadoop.conf.Configuration.getClass(Configuration.java:1718)
 ... 13 more

specify the –bindir where the compiled code and .jar file are located.

If Without these parameters, Sqoop will place the generated Java source files in the current working directory, and place the compiled .class files and .jar files in /tmp/sqoop-/compile.

< /div>

I am running a command on sqoop

sqoop import --connect jdbc:mysql://localhost/hadoopguide --table widgets

My sqoop version: Sqoop 1.4.4.2.0.6.1-101
Hadoop – Hadoop 2.2.0.2.0.6.0-101

Both are taken from hortonworks distribution. All paths such as HADOOP_HOME, HCAT_HOME, SQOOP_HOME, etc. have been set up correctly. By running the list-database, list-tables commands in sqoop, I can get the database list, table list from the mysql database. Even able to select from –query’ * from widgets’ to get data; but when I use –table option below error.

14/02/06 14:02:17 WARN mapre d.LocalJobRunner: job_local177721176_0001
java.lang.Exception: java.lang.RuntimeException: java.lang.ClassNotFoundException: Class widgets not found
 at org.apache.hadoop.mapred.LocalJobRunner$Job.run( LocalJobRunner.java:403)
Caused by: java.lang.RuntimeException: java.lang.ClassNotFoundException: Class widgets not found
 at org.apache.hadoop.conf.Configuration.getClass(Configuration.java: 1720)
 at org.apache.sqoop.mapreduce.db.DBConfiguration.getInputClass(DBConfiguration.java:394)
 at org.apache.sqoop.mapreduce.db.DataDrivenDBInputFormat.createDBRecordReader(DataDrivenDBInputFormat.java: 233)
 at org.apache.sqoop.mapreduce.db.DBInputFormat.createRecordReader(DBInputFormat.java:236)
 at org.apache.hadoop.mapred.MapTask$NewTrackingRecordReader.(MapTask. java:491)
 at org.apache.hadoop.mapred.MapTask.runNewMapper(MapTask.java:734)
 at org.apache.hadoop.mapred.MapTask.run(MapTask .java:339)
 at org.apache.hadoop.mapred.LocalJobRunner$Job$MapTaskRunnable.run(LocalJobRunner.java:235)
 at java.util.concurrent.Executors$RunnableAdapter.call(Executors .java:439)
 at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
 at java.util.concurrent.FutureTask.run(FutureTask.java:138)< br /> at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:895)
 at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:918)
 at java.lang.Thread.run(Thread.java:662)
Caused by: java.lang.ClassNotFoundException: Class widgets not found
 at org.apache.hadoop.conf.Configuration.getClassByName(Configuration. java:1626)
 at org.apache.hadoop.conf.Configuration.getClass(Configuration.java:1718)
 ... 13 more

Specify the –bindir where the compiled code and .jar file are located.

If there is no such parameter, Sqoop will place the generated Java source file in the current working directory, and will compile it .Class file and .jar file The files are placed in /tmp/sqoop-/compile.