Sqoop import failing importing a simple table from mysql using where clause

[#1]

Please find the attached for the error screen grabscreen-shot-2016-04-27-at-082448.png

Sqoop Query :

sqoop import --driver com.mysql.jdbc.Driver --connect jdbc:mysql://sandbox.hortonworks.com/test --username root -P --m 1 --query "select empid, ename from emp WHERE '$CONDITIONS' AND eid > '200' " --target-dir /user/maria_dev

[#2 · Accepted solution]

hi, correct syntax is:

select empid, ename from emp WHERE eid > '200' and $CONDITIONS (no ' ' on $CONDITIONS)

[#3]

@Alessio Ubaldi : Thanks the query has started but its still failing. I guess I am still missing something. screen-shot-2016-04-27-at-092033.png

[#4]

Can you attach all log?

By the way I think the problem is --target-dir:

use /user/root/test

For 2 reason:

1) Have permission to write with root user on /user/maria_dev? Default no.

2) target-dir must not exist, or job have this error: ERROR tool.ImportTool: Encountered IOException running import job: org.apache.hadoop.mapred.FileAlreadyExistsException: Output directory hdfs://sandbox.hortonworks.com:8020/user/root/test already exists

[#5]

It worked Thanks

[#6]

you are welcome