SQOOP - MYSQL - Practice test instance

[#1]

I am working on HDPCD practice test instance. Can anybody let me know -

a) Is there anything I should do before issue sqoop command on AWS practice instance.

b) what is the parameter I should use for --connect jdbc:?????

[#2]

@Artem Ervits

During the HDPCD exam, do we have to do this initial set up like - set up user, grant access etc. before we use sqoop commands? Or are these already taken care and we just run sqoop commands? If some access is not working can we ask the proctor to stop the clock and set up the required environment?

[#3]

@rich can help with HDPCD related questions

[#4]

@rich

During the HDPCD exam, do we have to do this initial set up like - set up user, grant access etc. before we use sqoop commands? Or are these already taken care and we just run sqoop commands? If some access is not working can we ask the proctor to stop the clock and set up the required environment?

[#5 · Accepted solution]

Everything is configured perfectly fine on the real exam for Sqoop to work. It's also configured correctly on the practice exam. If you are having trouble getting the command to work, the solution is in the /home/horton/solutions folder on the Ubuntu instance. Try running the solution. If that fails, please share the error and I can help you from there.

[#6]

@rich I have accepted this as best answer.

[#7]

@rich

I ran the sqoop command. I get the following error msg. Please look at the screen shot. Thanks.

sqoop.png

[#8]

You spelled "input-fields-terminated-by" incorrectly. I would bet that it will work once you fix that.

[#9]

@rich

Thanks rich. your solution worked out. I accept this answer.