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

Highlighted

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