question Re: Sqoop import with --direct is not working for Oracle DB in Archives of Support Questions (Read Only)

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

reddy_gayathri — Wed, 23 Nov 2016 15:06:46 GMT

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!

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

ssahi — Thu, 24 Nov 2016 01:31:36 GMT

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

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

reddy_gayathri — Fri, 25 Nov 2016 13:26:18 GMT

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