question SQOOP - Connecting to ORACLE with direct option gives error in Support Questions

SQOOP - Connecting to ORACLE with direct option gives error

shishir_saxena4 — Fri, 19 Feb 2016 23:29:19 GMT

While connecting to an ORACLE database with --direct option, gives error

sqoop import --options-file db.config --table table1 --direct -m 4

ORA-00942: table or view does not exist

Same sqoop command works fine without --direct option.

sqoop import --options-file db.config --table table1 -m 4

Re: SQOOP - Connecting to ORACLE with direct option gives error

aervits — Fri, 19 Feb 2016 23:30:46 GMT

@Shishir Saxena

Re: SQOOP - Connecting to ORACLE with direct option gives error

shishir_saxena4 — Fri, 19 Feb 2016 23:31:22 GMT

userid that is used to login to ORACLE should have SELECT_CATALOG_ROLE to use --direct option.

Re: SQOOP - Connecting to ORACLE with direct option gives error

nsabharwal — Fri, 19 Feb 2016 23:33:47 GMT

@Shishir Saxena

Table does not exist in oracle database .

Make sure the case sensitivity too in case table exists

Re: SQOOP - Connecting to ORACLE with direct option gives error

nsabharwal — Fri, 19 Feb 2016 23:35:15 GMT

https://sqoop.apache.org/docs/1.4.2/SqoopUserGuide.html#_specific_troubleshooting_tips @Shishir Saxena

Re: SQOOP - Connecting to ORACLE with direct option gives error

shishir_saxena4 — Fri, 19 Feb 2016 23:36:49 GMT

@Neeraj Sabharwal @Artem Ervits Table exists in ORACLE database and user had access to table because I was able to use same sqoop command without --direct option. It had to do with SELECT_CATALOG_ROLE not granted to user. --direct option requires access to ORACLE catalog tables in addition to actual table.

Re: SQOOP - Connecting to ORACLE with direct option gives error

nsabharwal — Fri, 19 Feb 2016 23:40:34 GMT

@Shishir Saxena

Catalog role makes sense.

I need to check on why no direct did not work.

It's like sqlldr ...skip checks

Re: SQOOP - Connecting to ORACLE with direct option gives error

nsabharwal — Fri, 19 Feb 2016 23:41:21 GMT

I have accepted this as solution

Re: SQOOP - Connecting to ORACLE with direct option gives error

shishir_saxena4 — Sun, 21 Feb 2016 04:32:02 GMT

Thanks Neeraj.

Re: SQOOP - Connecting to ORACLE with direct option gives error

fnu_rasool — Tue, 26 Apr 2016 23:46:36 GMT

mapreduce-import-failed.txtHi,

I am getting sqoop import error using oracle tables:

sqoop error tool.importtool error during import import job failed

Can you please advise. I have attached the log for your reference. Thank you.

Re: SQOOP - Connecting to ORACLE with direct option gives error

fnu_rasool — Tue, 26 Apr 2016 23:47:10 GMT

Hi,

I am getting sqoop import error using oracle tables:

sqoop error tool.importtool error during import import job failed

Can you please advise. I have attached the log for your reference. Thank you.mapreduce-import-failed.txt

Re: SQOOP - Connecting to ORACLE with direct option gives error

hariprasanthmad — Mon, 20 May 2019 18:01:48 GMT

@fnu rasool

1.Try to run the Sqoop job as a non-root user.

2.Check if your JDK is properly installed on the host and your JAVA_HOME is set properly.

3.Check if you have granted the right permissions to the Databases you're using.

i think there must be a configuration error !