hadoop-mapreduce-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Ted Yu <yuzhih...@gmail.com>
Subject Re: Sqoop import Mysql to hive import Partitions
Date Tue, 02 Feb 2016 14:37:58 GMT
The question is better suited for sqoop mailing list. 

Meanwhile, you can search for past threads / JIRAs on this subject. 
e.g.
http://search-hadoop.com/m/C63T91ojE6B14UByZ&subj=sqoop+1+4+4+hive+import+error

> On Feb 2, 2016, at 5:28 AM, Arun Pandian <arunpandiansumtwo@gmail.com> wrote:
> 
> 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