Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Sqoop Import direct connector : FreeForm Query

Highlighted

Sqoop Import direct connector : FreeForm Query

New Contributor

Is Sqoop Import in direct mode using a freeform query supported . I found --direct is supported for table import but with free form. Is this true or there any wayaround ?

 

We are using Oracle DB as source and HDP 3.1 with Sqoop 1.4.6.

1 REPLY 1

Re: Sqoop Import direct connector : FreeForm Query

Guru
@Dexter,

The doc here:
http://sqoop.apache.org/docs/1.4.6/SqoopUserGuide.html#_free_form_query_imports

does not mention about the limitation, i have tested using MySQL, looks like it is working for me. You should also test on your Oracle DB to confirm.

Cheers
Eric