Reply
New Contributor
Posts: 1
Registered: ‎02-07-2019

Sqoop - can Incremental import use filters/queries

 

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?

New Contributor
Posts: 2
Registered: ‎02-18-2019

Re: Sqoop - can Incremental import use filters/queries

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

Announcements
New solutions