hadoop-common-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Arun Pandian <arunpandiansum...@gmail.com>
Subject Sqoop import Mysql to hive import Partitions
Date Tue, 02 Feb 2016 13:28:24 GMT
How to create sqoop import  mysql to hive partition , this is my code



sqoop import --connect jdbc:mysql://localhost/arun  --table account
--username root --password hadoop -m 1  --hive-partition-key "name"
--hive-partition-value "arun" --hive-database company  --create-hive-table
--hive-table account5  --target-dir /user/sqooptest21

mysql database is arun,
table is account
select * from account;
+----+-------+------+------------+---------+
| id | name  | age  | joindate   | namess  |
+----+-------+------+------------+---------+
|  1 | Arun  |   23 | 29-01-2016 | super   |
|  2 | Mani  |   22 | 30-01-2016 | superb  |
|  3 | Sana  |   25 | 20-01-2016 | superbb |
|  4 | Vicky |   24 | 02-02-2016 | supervb |
|  5 | Vis   |   23 | 30-05-2016 | super   |
+----+-------+------+------------+---------+


i need clear explanation for sqoop import mysql to hive




*Thanks & Regards*

*Arunpandian.l*

*Associate Developer*

Mime
View raw message