Support Questions

Find answers, ask questions, and share your expertise

SQOOP - MySQL - AWS Practice Instance

avatar
Rising Star

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:?????

1 ACCEPTED SOLUTION

avatar
Guru
@Vidya SK

The connection URL for the practice exam is:

--connect jdbc:mysql://namenode/flightinfo

There is nothing special you need to do prior to running the Sqoop command. The environment is configured properly for Sqoop to connect to MySQL. The entire working Sqoop command can be found in the /home/horton/solutions/ folder.

View solution in original post

12 REPLIES 12

avatar
Contributor

Please ignore. i think i know what your saying. if i need to run mysql i have to be in root and if i need to run sqoop i have to be horton.

avatar
Guru

Please share your Sqoop command. Have you tried comparing your Sqoop command to the solution in the /home/horton/solutions folder?

avatar
Guru

The tasks for the practice exam are a part of the Amazon AMI image. The details are here:

http://hortonworks.com/wp-content/uploads/2015/02/HDPCD-PracticeExamGuide1.pdf