Sqoop import with conditions

[#1 · Accepted solution]

@Gayathri Devi,

Can you put the query in quotes and check .

--query "select * hgj where date(starttime)=2017-08-08"

For incremental, if you provide --last-value it will import only the new or updated data after that date. Read more here

https://sqoop.apache.org/docs/1.4.1-incubating/SqoopUserGuide.html#_Incremental_Imports

Thanks,

Aditya

[#2]

@Gayathri Devi,

Please use the below query format

--query "select * hgj where date(starttime)=2017-08-08 AND \$CONDITIONS"

Thanks,

Aditya