1-844-696-6465 (US)        +91 77600 44484        help@dezyre.com

Sqoop Import question

I was trying scoop with Oracle data base, I am getting the following error ... Connection with DB is happening well, but for some reason request is failing.... Would you please guide me here? Thanks ....

bin/sqoop import --connect jdbc:oracle:thin:@// --table t3techpopulation --username myuser -P --target-dir /user/cloudera/class-8/ev/sqoopOut1 -m 2

[cloudera@localhost sqoop]$ bin/sqoop import --connect jdbc:oracle:thin:@// --table t3techpopulation --username drms_registry -P --target-dir /user/cloudera/tests
Enter password:
15/10/05 14:06:49 INFO manager.SqlManager: Using default fetchSize of 1000
15/10/05 14:06:49 INFO tool.CodeGenTool: Beginning code generation
15/10/05 14:06:49 INFO manager.OracleManager: Time zone has been set to GMT
15/10/05 14:06:49 INFO manager.SqlManager: Executing SQL statement: SELECT t.* FROM t3techpopulation t WHERE 1=0
15/10/05 14:06:49 ERROR tool.ImportTool: Imported Failed: Attempted to generate class with no columns!
[cloudera@localhost sqoop]$

3 Answer(s)


Hi Karuna,

Please refer the link :http://archive.cloudera.com/cdh/3/sqoop/SqoopUserGuide.html#_troubleshooting
Look into section 23.2.2 and your problem should be resolved. Hope it helps.



hi Karuna,

I see this error " Imported Failed: Attempted to generate class with no columns!". Can you check what columns and primary key does the table have.?


Hello Abhijeet, Thanks for your help... Changing the schema name and table name to upper case did the trick :) ... Thank you ....

Your Answer

Click on this code-snippet-icon icon to add code snippet.

Upload Files (Maximum image file size - 1.5 MB, other file size - 10 MB, total size - not more than 50 MB)