Mailing-List: contact user-help@hadoop.apache.org; run by ezmlm
Precedence: bulk
Content-Type: multipart/alternative;
	boundary=Apple-Mail-CCF363C5-920F-4596-BF27-A0B32C341848
Mime-Version: 1.0 (1.0)
Subject: Re: Sqoop import Mysql to hive import Partitions
From: Ted Yu <yuzhihong@gmail.com>
In-Reply-To: 
 <CAOfEKKxTCfT--dObcAt2XL1=__EkRmz+wZGqScb82gQbLu+68g@mail.gmail.com>
Date: Tue, 2 Feb 2016 06:37:58 -0800
Cc: user@hadoop.apache.org
Content-Transfer-Encoding: 7bit
Message-Id: <08588909-82C4-47D0-8C57-049031D9D265@gmail.com>
References: 
 <CAOfEKKxTCfT--dObcAt2XL1=__EkRmz+wZGqScb82gQbLu+68g@mail.gmail.com>
To: Arun Pandian <arunpandiansumtwo@gmail.com>

--Apple-Mail-CCF363C5-920F-4596-BF27-A0B32C341848
Content-Type: text/plain;
	charset=us-ascii
Content-Transfer-Encoding: quoted-printable

The question is better suited for sqoop mailing list.=20

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

> On Feb 2, 2016, at 5:28 AM, Arun Pandian <arunpandiansumtwo@gmail.com> wro=
te:
>=20
> How to create sqoop import  mysql to hive partition , this is my code
>=20
>=20
>=20
> sqoop import --connect jdbc:mysql://localhost/arun  --table account --user=
name root --password hadoop -m 1  --hive-partition-key "name" --hive-partiti=
on-value "arun" --hive-database company  --create-hive-table  --hive-table a=
ccount5  --target-dir /user/sqooptest21
>=20
> 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   |
> +----+-------+------+------------+---------+
>=20
>=20
> i need clear explanation for sqoop import mysql to hive
>=20
>=20
>=20
> Thanks & Regards
> Arunpandian.l
> Associate Developer

--Apple-Mail-CCF363C5-920F-4596-BF27-A0B32C341848
Content-Type: text/html;
	charset=utf-8
Content-Transfer-Encoding: quoted-printable

<html><head><meta http-equiv=3D"content-type" content=3D"text/html; charset=3D=
utf-8"></head><body dir=3D"auto"><div></div><div>The question is better suit=
ed for sqoop mailing list.&nbsp;</div><div><br></div><div>Meanwhile, you can=
 search for past threads / JIRAs on this subject.&nbsp;</div><div>e.g.</div>=
<div><a href=3D"http://search-hadoop.com/m/C63T91ojE6B14UByZ&amp;subj=3Dsqoo=
p+1+4+4+hive+import+error">http://search-hadoop.com/m/C63T91ojE6B14UByZ&amp;=
subj=3Dsqoop+1+4+4+hive+import+error</a></div><div><br>On Feb 2, 2016, at 5:=
28 AM, Arun Pandian &lt;<a href=3D"mailto:arunpandiansumtwo@gmail.com">arunp=
andiansumtwo@gmail.com</a>&gt; wrote:<br><br></div><blockquote type=3D"cite"=
><div><div dir=3D"ltr"><div>How to create sqoop import&nbsp; mysql to hive p=
artition , this is my code<br><br></div><div><br><br><div>sqoop import --con=
nect jdbc:mysql://localhost/arun&nbsp; --table account --username root --pas=
sword hadoop -m 1&nbsp; --hive-partition-key "name" --hive-partition-value "=
arun" --hive-database company&nbsp; --create-hive-table&nbsp; --hive-table a=
ccount5&nbsp; --target-dir /user/sqooptest21<br><br></div><div>mysql databas=
e is arun,<br></div><div>table is account<br>select * from account;<br>+----=
+-------+------+------------+---------+<br>| id | name&nbsp; | age&nbsp; | j=
oindate&nbsp;&nbsp; | namess&nbsp; |<br>+----+-------+------+------------+--=
-------+<br>|&nbsp; 1 | Arun&nbsp; |&nbsp;&nbsp; 23 | 29-01-2016 | super&nbs=
p;&nbsp; |<br>|&nbsp; 2 | Mani&nbsp; |&nbsp;&nbsp; 22 | 30-01-2016 | superb&=
nbsp; |<br>|&nbsp; 3 | Sana&nbsp; |&nbsp;&nbsp; 25 | 20-01-2016 | superbb |<=
br>|&nbsp; 4 | Vicky |&nbsp;&nbsp; 24 | 02-02-2016 | supervb |<br>|&nbsp; 5 |=
 Vis&nbsp;&nbsp; |&nbsp;&nbsp; 23 | 30-05-2016 | super&nbsp;&nbsp; |<br>+---=
-+-------+------+------------+---------+<br><br><br></div><div>i need clear e=
xplanation for sqoop import mysql to hive<br></div><div><br><br><br clear=3D=
"all"></div><div><div><div class=3D"gmail_signature"><div dir=3D"ltr"><div><=
div dir=3D"ltr"><div><div><div><span style=3D"color:rgb(255,0,0)"><span styl=
e=3D"background-color:rgb(255,255,255)"><i><b>Thanks &amp; Regards<br></b></=
i></span></span></div><span style=3D"color:rgb(255,0,0)"><span style=3D"back=
ground-color:rgb(255,255,255)"><i><b>Arunpandian.l<br></b></i></span></span>=
</div><div><span style=3D"color:rgb(255,0,0)"><span style=3D"background-colo=
r:rgb(255,255,255)"><i><b></b></i></span></span></div><span style=3D"color:r=
gb(255,0,0)"><span style=3D"background-color:rgb(255,255,255)"><i><b>Associa=
te Developer<br></b></i></span></span></div></div></div></div></div></div>
</div></div></div>
</div></blockquote></body></html>=

--Apple-Mail-CCF363C5-920F-4596-BF27-A0B32C341848--