Sqoop import with --direct is not working for Oracle DB

[#1]

Hi I am getting error when trying to import the table from Oracle database to Hadoop using Sqoop with --direct utility. The error is, "ERROR manager.SqlManager: Error executing statement: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist"

When I take off --direct from sqoop statement, then started importing data.

Is there any other property to be added to the Sqoop statement when using --direct utility?

Thanks!

[#2 · Accepted solution]

Hi,

There can be some ORACLE permissions that need to be looked at, as well as ensuring that case-sensitivity are not issues. I recall seeing a similar post in the past that may be a good reference for you: https://community.hortonworks.com/questions/18245/sqoop-connecting-to-oracle-with-direct-option-give...

[#3]

Yes, that worked. after giving SELECT_CATALOG_ROLE privileges, direct option is working.