Скачать или смотреть Sqoop - importing data from MySQL to Hive homework using Cloudera VM, Sqoop मार्गदर्शक

Sqoop - importing data from MySQL to Hive homework using Cloudera VM

In the video there is a detailed wolk-through based on the tasks given below. Every step is shown and explained in details.

You are given the following tasks which should be completed:

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

Please import data in existing table created above from retail_db.departments into hive table sqoop_task.departments.

Please import data in a non-existing table, means while importing create hive table named sqoop_task.departments_new

Do not forget to subscribe to this channel and also register on our web-site, where you can find detailed theoretical posts related to BigData technologies - http://blog.dataguru.guide

Twitter -   / f_dmitrijs  
Instagram -   / dmitrijs.f  
Linkedin -   / dmitrijs-finaskins-a69598a5  
Facebook -   / dmitry.finashkin