Support Questions
Find answers, ask questions, and share your expertise

Sqoop : Import with default partitioning using db2 database

Highlighted

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
Highlighted

Re: Sqoop : Import with default partitioning using db2 database

please find attachments

19505-sqoop-error.png

19506-sqoop-command.png

Highlighted

Re: Sqoop : Import with default partitioning using db2 database

@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

Highlighted

Re: Sqoop : Import with default partitioning using db2 database

@dnyanesh kulkarnni

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

Re: Sqoop : Import with default partitioning using db2 database

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)

Don't have an account?