Where $CONDITIONS

#1

Hi Team,
I am trying to use --query while importing. But I wanted to write a simple query with a condition in it like where product_name = “abcd”. How can we give that as we must use where $CONDITIONS. I think we cant use --where along with --query. Correct me if I am wrong. I tried using --where also but failed.

I tried giving conditions along with $CONDITIONS but failed.

How can we achieve it in sqoop

0 Likes

#2

Sorry… My bad. We can add conditions to where clause. like below.

where a=2 AND $CONDITIONS will work.

0 Likes