Import data from MySQL to Hive with the help of SQOOP.

Import data from MySQL to Hive with the help of SCOOP.

$ mysql -uroot -pcloudera -hlocalhost

mysql> describe retail_db.customers;

+-------------------+--------------+------+-----+---------+----------------+

| Field             | Type         | Null | Key | Default | Extra          |

+-------------------+--------------+------+-----+---------+----------------+

| customer_id       | int(11)      | NO   | PRI | NULL    | auto_increment |

| customer_fname    | varchar(45)  | NO   |     | NULL    |                |

| customer_lname    | varchar(45)  | NO   |     | NULL    |                |

| customer_email    | varchar(45)  | NO   |     | NULL    |                |

| customer_password | varchar(45)  | NO   |     | NULL    |                |

| customer_street   | varchar(255) | NO   |     | NULL    |                |

| customer_city     | varchar(45)  | NO   |     | NULL    |                |

| customer_state    | varchar(45)  | NO   |     | NULL    |                |

| customer_zipcode  | varchar(45)  | NO   |     | NULL    |                |

+-------------------+--------------+------+-----+---------+----------------+

sqoop import \

-connect "jdbc:mysql://localhost:3306/retail_db" \

-username root \

-password cloudera \

-table customers \

-target-dir /user/cloudera/cust_from_mysql \

-delete-target-dir \

-hive-import \

-create-hive-table \

-hive-database ohm \

-hive-table cust_from_mysql

// ohm.cust_from_mysql table will be created after import success.

hive> select * from ohm.cust_from_mysql limit 5;

OK

1 Richard Hernandez XXXXXXXXX XXXXXXXXX 6303 Heather Plaza Brownsville TX 78521

2 Mary Barrett XXXXXXXXX XXXXXXXXX 9526 Noble Embers RidgeLittleton CO 80126

3 Ann Smith XXXXXXXXX XXXXXXXXX 3422 Blue Pioneer Bend Caguas PR 00725

4 Mary Jones XXXXXXXXX XXXXXXXXX 8324 Little Common San Marcos CA 92069

5 Robert Hudson XXXXXXXXX XXXXXXXXX 10 Crystal River Mall Caguas PR 00725