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

Sqoop : Import with default partitioning using db2 database


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 :-


please find attachments



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


@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)