question Re: Sqoop import with conditions in Archives of Support Questions (Read Only)

Sqoop import with conditions

Gayathridevi — Wed, 08 Nov 2017 18:21:14 GMT

asirna — Wed, 08 Nov 2017 19:24:53 GMT

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

Thanks,

Aditya

asirna — Thu, 09 Nov 2017 10:35:10 GMT

Please use the below query format

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

Thanks,

Aditya