HADOOP ICP 5 - Apoorvag2597/BDP_Revised GitHub Wiki

Name - Apoorva Geetanjali Avadhanula

Class ID - 34

Aim :

Install Sqoop. Use Sqoop to import and export mySQL tables to HDFS. Create Hive Tables through HQL Script , Use Sqoop to import and export tables to Relational Databases. Perform three queries from databases. Part 1-

We have to first create a database with a name BDP

Create a table ICP and insert values into it.

Output of the table

Importing table into HDFS

Listing the files on Hadoop System

Importing into target directory

Creating a table icp

Exporting the table employee from Hadoop file system to mySQL.

Result

Display the table in hue

Part 2 Open Hive Create table icps in mySQL.

Import the icps table from mySQL to hive.

Show and describe tables

Display the table icps.

Create a table 'new' in hive, and load the data from bdp table.

Use the hadoop ls command to find the location of the emp table.

Export the table from hive to mySQL using sqoop to New.

I have performed two queries:

1.

2.