Sqoop – homework to be completed

Let’s now put everything together we learned so far about Sqoop and try to accomplish the following task:

You have been given following mysql database details as well as other info.
user=root
password=cloudera
database=retail_db
jdbc URL = jdbc:mysql://quickstart/retail_db

Please accomplish following.

  1. Create a Hive database named sqoop_task and then create a table named departments in it, with
    following fields. department_id int, department_name string e.g. location should be
    hdfs:///user/hive/warehouse/sqoop_task.db/departments
  2. Please import data in existing table created above from retail_db.departments into hive table
    sqoop_task.departments.
  3. Please import data in a non-existing table, means while importing create hive table named
    sqoop_task.departments_new

Try to complete this task by yourself. You are given 2 days for that until Saturday, 4th of May. On 4th of May a solution will be posted on our YouTube channel as well as a separate post in this blog.

If you face any problems, feel free to ask your questions here or review video guides related to Sqoop on our channel

Sqoop video guides

As a reminder, do not forget to subscribe to our channel, so you do not miss any new videos! ->>> https://www.youtube.com/channel/UCcF1PvBiU9REm1XmcDO_6QQ

DataGuru Team

Leave a Reply