Question: Hello, Im taking this course about hadoop for beginners, Im having problems with my assignment which is supposed to be easy but I cannot figure

Hello, Im taking this course about hadoop for beginners, Im having problems with my assignment which is supposed to be easy but I cannot figure it out, im using the clouderaquickstart Virtual box, my assignment is :

list tables and validate that you can connect to database using Sqoop with JDBC URL.

" Quickstart mysql jdburl to connect with Sqoop : jdbc:mysql://quickstart:3306/retail_db "

-Im stucked in this part im using:

sqoop list-tables \

--connect jdbc:mysql://quickstart:3306/retail_db \

--username cloudera \

--password cloudera

(I think the username and password is cloudera and cloudera) the computer says something like:

error manager.catalogquerymanager: failed to list tables java.sql.sqlexception :access denied for user 'cloudera@quickstart.cloudera' (using password : yes)

Part b is

Create a HR_db Database in MySql and creat an Employee table (feel free to add fields, populate some sample data with a good amount of records)

C

Eval connection with Sqoop command

D

Importing HR_db tables to HDFS i- avro data file format to Hive

E

Use 8 parallel threads (mappers)

please make it simple this is supposed to be for beginners, will give thumbs up if your answer helps

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!