Module 1: ICP #5

OBJECTIVE:

• Importing and exporting tables through Sqoop

• Create Hive Tables through HQL Script , Use Sqoop to import and export tables to Relational Databases.

• Perform three queries from databases.

PROCEDURE:

PART-1

Open My SQL by typing the following command.

Export the table from HDFS to Mysql using following command and display the results.

In the database create a table called studentexport and put in some values.

Import the table from Mysql to HDFS using the following command and Display the contents in HDFS.

PART-2

Create a table and insert some values into the table and display the contents.

Create a table in Hive.

Export the table from Mysql to Hive using the following commands and Display contents of exported table from hive.

PART-3

Create a table and load the downloaded data into the table.

Running the word count for the table.

Identifying patterns in the table and Performing statistics for the table

MY LEARNING OUTCOME:

Sqoop is one of the more fascinating tool that I have learning from this ICP.

Another thing that I have learnt and understood more was the HQL (Hive Quer Language).