Support Questions

Find answers, ask questions, and share your expertise

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

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
Take a Tour of the Community
Don't have an account?
Your experience may be limited. Sign in to explore more.