Support Questions
Find answers, ask questions, and share your expertise
Announcements
Check out our newest addition to the community, the Cloudera Innovation Accelerator group hub.

Sqoop : Import with default partitioning using db2 database

Hello,

I am trying to import data from DB2 database table with the partition column name. But I am facing below error message.

Please find below screenshot for command and error :-

4 REPLIES 4

please find attachments

19505-sqoop-error.png

19506-sqoop-command.png

@dnyanesh kulkarnni

Add --columns clause in your sqoop statement and mention all columns from the db2 table with the exception of the column which is used for partitioning.

That would fix this issue.

Thanks

@dnyanesh kulkarnni

Please let us know if this fixed the issue and you can close this thread by accepting the correct answer.

Cloudera Employee

@dnyanesh kulkarni

The issue seems to be due to no permission to execute the query as end-user on hive server side.

Please change the 'Run as end user instead of Hive user' and set it to 'true' the 'hive-site.xml' (hive.server2.enable.doAs=true)