Based on the Neeraj Sabharwal reply , $Condition with where condition is working fine as expected . But that condition should be int comparision . Example Where id is integer field sqoop import --connect jdbc:mysql://localhost/test --username sat --query 'select id,name from employee where $CONDITIONS and id = 323437 ' --split-by id --target-dir taget-dir-name this is working fine as expected . but sqoop import --connect jdbc:mysql://localhost/test --username sat --query " select id,name from employee where $CONDITIONS and name = 'sathish' " --split-by id --target-dir taget-dir-name name = 'sathish' is not working . Could you please let us know how to handle string in where condition ... View more