Reply
Highlighted
Contributor
Posts: 55
Registered: ‎09-17-2013

can we pass Sqoop where clause parameters from oozie variables.?

Hi, 

 

I want to run sqoop command from oozie. I want to pass where clause parameters manually.

 

Is there a way to pass that arguments manually.?

 

I choose using oozie varibales. So, 

 

the command i have given in sqoop action is as below. 

 

import --connect jdbc:mysql://localhost:3306/oozie --username=root --password=cloudera --table=OOZIE_SYS --target-dir=/user/cloudera/sqoop6 --m ${MAPPER} --where ${WHERE}

 

and added where as below in oozie varables. 

 

WHERE = "name='db.version'"

 

But, it does not seems to be working. I got error saying, 

 

unrecognized command. 

 

Is there a way to pause where cluase like this using variables.?