sqoop import --connect jdbc:mysql://localhost/test --username sat -P --query 'select emp_no, salary from salaries where $CONDITIONS' --split-by emp_no --target-dir /user/cloudera/tmp/ there is no need of \ that you have add into your mysql query and if you want use query in double quotes --query "select emp_no, salary from salaries where \$CONDITIONS" add backslash before $CONDITIONS like above 🙂 ... View more