Created on
12-28-2019
07:21 AM
- last edited on
12-28-2019
09:54 AM
by
ask_bill_brooks
I am trying this solution but for some reason it is not working for me. please tell me where I am going wrong
sqoop-import -Dmapreduce.job.user.classpath.first=true -Dhadoop.security.credential.provider.path=jceks://x.jceks \
--connect="jdbc:mysql://quickstart.cloudera:3306/retail_db" \
--username retail_dba \
--password cloudera \
--table=departments \
--hive-import \
--as-avrodatafile
Created 12-28-2019 07:26 AM
for some reason this is not working for me. please help me with where I am going wrong
sqoop-import -Dmapreduce.job.user.classpath.first=true -Dhadoop.security.credential.provider.path=jceks://x.jceks \
--connect="jdbc:mysql://quickstart.cloudera:3306/retail_db" \
--username retail_dba \
--password cloudera \
--table=departments \
--hive-import \
--as-avrodatafile
Created on 12-28-2019 10:14 AM - edited 12-28-2019 10:15 AM
@saskan the two questions above were moved into this newly-created thread because you posted both of them12-28-2019 to a thread with an accepted solution posted 10-10-2016.
You will be much more likely to obtain a response from other members of this community if you provide some additional context here, such as:
You also might try posting a screen shot of the error message you're receiving.
Created 01-05-2020 07:02 AM
No I am not using this form a tutorial. I got it from the community.
I am using the sqoop version Sqoop 1.4.6-cdh5.13.0
Created on 01-05-2020 07:48 AM - edited 01-05-2020 07:49 AM
Did you try the new line escape char (\) on end of first line?
In the OP sample, his is all one line (no new line escape chars):
Dmapreduce.job.user.classpath.first=true Example: sqoop import -Dmapreduce.job.user.classpath.first=true -Dhadoop.security.credential.provider.path=jceks://x.jceks --connect jdbc:db2://xxx:60000/VKTXAP02 --username xx -password-alias xx --as-avrodatafile --target-dir xx/data/test --fields-terminated-by '\001' --table xx -m 1
Your sample has new line escape chars....