Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Sqoop job fails for password

Sqoop job fails for password

New Contributor

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.