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 - can Incremental import use filters/queries

Sqoop - can Incremental import use filters/queries

New Contributor

 

a) Can we filter the sqoop incremental import using --queries? 

https://sqoop.apache.org/docs/1.4.2/SqoopUserGuide.html#_incremental_imports

 

b) To setup the daily sqoop imports in oozie using incremental import, we need to use saved jobs. What would be the value for --last-value in the first run?

1 REPLY 1

Re: Sqoop - can Incremental import use filters/queries

New Contributor

Hey,

 

To answer your first question I have to try so will let you know, but for the second one, you can use 0 as last value in your sqoop job, so it will import the required data first and then it will update the last value in the same.

 

Thanks

Don't have an account?
Coming from Hortonworks? Activate your account here