Sqoop : Import with default partitioning using db2 database

[#1]

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

[#2]

please find attachments

[#3]

@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

[#4]

@dnyanesh kulkarnni

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

[#5]

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