Welcome to the Simplilearn Community

Want to join the rest of our members? Sign up right away!

Sign Up

PG DE - Big Data Hadoop Spark Developer - Cohort 1 | Amit Singh | nov28th-jan23

In the self learning for PGP DE - Big Data Hadoop Spark Developer; section 6.27 is a non-gradable practice project.

Are there step-by-step instructions for going through this project? Having a set of step-by-step instructions would help me out a lot with how to use this tool (namely, Hive). In addition, this goes similarly for other practice projects.
 
How are we supposed to log in to MySql? Are we supposed to use the log in credentials provided on the webconsole page? If so, I am having issues:

How to proceed?
 

Attachments

  • Screen Shot 2020-12-15 at 5.16.34 PM.png
    Screen Shot 2020-12-15 at 5.16.34 PM.png
    49.2 KB · Views: 11
  • Screen Shot 2020-12-15 at 5.16.54 PM.png
    Screen Shot 2020-12-15 at 5.16.54 PM.png
    17.1 KB · Views: 10
Last edited:
For Project #3 in the Assessment with the Stock Exchange Data Analysis. Steps to perform include: 1) Create a data pipeline using sqoop to pull the data from the table below from MYSQL server into Hive.

My questions is, are we supposed to sqoop the data from MySql into HDFS, and then into Hive? or sqoop the data directly from MySql into Hive?

Thank you,
Sam
 
Last edited:
How are we supposed to log in to MySql? Are we supposed to use the log in credentials provided on the webconsole page? If so, I am having issues:

How to proceed?
Hello Sam,
Below command should work, repalce your username and password
mysql -h sqoopdb.slbdh.cloudlabs.com -u <username> -p<password>
 
Top