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

Sqoop Import question



0
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:@//10.164.75.122:1522/uisol --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:@//10.164.75.122:1522/uisol --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)


0

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.

Thanks

0

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.?

0

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)

Email
Password