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
Get step-by-step solutions from verified subject matter experts
