Support Questions
Find answers, ask questions, and share your expertise

Sqoop job fails for password

Explorer

Hi,

I am using hortonwork sandbox and using the below sqoop command created a job.

1. sqoop job --create customerInfoJob -- import --connect jdbc:mysql://sandbox.hortonworks.com:3306/test --username root --table cust omerInfo --map-column-java mtts=String,startdte=String --null-string "" --null-non-string "" --incremental append --check-column 'mtts' --last-value '16-04-05 03:51:18' --driver com.mysql.jdbc.Driver --warehouse-dir /user/output --m 1 --as-textfile

2. sqoop job --list List the jobname. 3. when I try to execute the job it prompts for password. sqoop job --exec customerInfoJob I entered password for root user to ssh client. but it has denied. Error : java.sql.SQLException: Access denied for user 'root'@'sandbox.hortonworks.com' (using password: YES)

I also tried admin. What password is it? Thank you.

0 REPLIES 0