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 import with conditions

Solved Go to solution
Highlighted

Sqoop import with conditions

New Contributor
 
1 ACCEPTED SOLUTION

Accepted Solutions

Re: Sqoop import with conditions

@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 REPLIES 2

Re: Sqoop import with conditions

@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

Re: Sqoop import with conditions

@Gayathri Devi,

Please use the below query format

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

Thanks,

Aditya

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