Mailing-List: contact user-help@hive.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@hive.apache.org
Received-SPF: pass (nike.apache.org: local policy)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws;
  s=s1024; d=yahoo.com;
  h=DKIM-Signature:X-Yahoo-Newman-Property:X-YMail-OSG:X-Yahoo-SMTP:Received:X-rim-org-msg-ref-id:Message-ID:Reply-To:X-Priority:References:In-Reply-To:Sensitivity:Importance:Subject:To:From:Date:Content-Type:MIME-Version;
  b=UzCfcKjxOJo9Vpj/mYasnyiFgQJ0SHu0wrN4UvFj+iGL6dUYZqVkoIIagjufbnj0wkFP8XCAKf+KJ12uqkw4806M4RBWs8pqi8qMg4CNzSro83RgDa3vSzqeI7jkjf+QXVlTPJPl0CogwOxpOOyKmDfxi+tlQTZ6VC3sQJ8/9w4=
  ;
Message-ID: 
 <176434608-1347480368-cardhu_decombobulator_blackberry.rim.net-1838632827-@b25.c15.bise7.blackberry>
Reply-To: bejoy_ks@yahoo.com
References: 
 <CAC9gcE7NPC1v=P_2iRMKOJPCA1Q+84CTw3=n=LxGUanRDpqzcA@mail.gmail.com>
In-Reply-To: 
 <CAC9gcE7NPC1v=P_2iRMKOJPCA1Q+84CTw3=n=LxGUanRDpqzcA@mail.gmail.com>
Sensitivity: Normal
Importance: Normal
Subject: Re: most efficient way to concatenate 3 tables into one?
To: user@hive.apache.org
From: "Bejoy KS" <bejoy_ks@yahoo.com>
Date: Wed, 12 Sep 2012 20:06:13 +0000
Content-Type: multipart/alternative;
 boundary="part35-boundary-436370583-1284005141"
MIME-Version: 1.0


--part35-boundary-436370583-1284005141
Content-Type: text/plain; charset="Windows-1252"

Hi

If all the 3 tables have the same. Schema, Create an external table and move the data from all the 3 tables to this new table's location. Just a hdfs copy or move is not that expensive.

Regards
Bejoy KS

Sent from handheld, please excuse typos.

-----Original Message-----
From: zuohua zhang <zuohua@gmail.com>
Date: Wed, 12 Sep 2012 13:02:42 
To: <user@hive.apache.org>
Reply-To: user@hive.apache.org
Subject: most efficient way to concatenate 3 tables into one?

I have 3 tables, each contains monthly data, I would like to make a table
to concatenate all 3 months into 1 table.
What is the most efficient way to do that?
I am using insert into which takes a long time.

Thanks!


--part35-boundary-436370583-1284005141
Content-Transfer-Encoding: base64
Content-Type: text/html; charset="Windows-1252"

PCFET0NUWVBFIGh0bWwgUFVCTElDICItLy9XM0MvL0RURCBIVE1MIDQuMCBUcmFuc2l0aW9uYWwv
L0VOIj48aHRtbD48aGVhZD48bWV0YSBjb250ZW50PSJ0ZXh0L2h0bWw7IGNoYXJzZXQ9dXRmLTgi
IGh0dHAtZXF1aXY9IkNvbnRlbnQtVHlwZSI+PC9oZWFkPjxib2R5PkhpPGJyLz48YnIvPklmIGFs
bCB0aGUgMyB0YWJsZXMgaGF2ZSB0aGUgc2FtZS4gU2NoZW1hLCBDcmVhdGUgYW4gZXh0ZXJuYWwg
dGFibGUgYW5kIG1vdmUgdGhlIGRhdGEgZnJvbSBhbGwgdGhlIDMgdGFibGVzIHRvIHRoaXMgbmV3
IHRhYmxlJ3MgbG9jYXRpb24uIEp1c3QgYSBoZGZzIGNvcHkgb3IgbW92ZSBpcyBub3QgdGhhdCBl
eHBlbnNpdmUuPGJyLz48ZGl2PlJlZ2FyZHM8YnIvPkJlam95IEtTPGJyLz48YnIvPlNlbnQgZnJv
bSBoYW5kaGVsZCwgcGxlYXNlIGV4Y3VzZSB0eXBvcy48L2Rpdj48aHIvPjxkaXY+PGI+RnJvbTog
PC9iPiB6dW9odWEgemhhbmcgJmx0O3p1b2h1YUBnbWFpbC5jb20mZ3Q7DQo8L2Rpdj48ZGl2Pjxi
PkRhdGU6IDwvYj5XZWQsIDEyIFNlcCAyMDEyIDEzOjAyOjQyIC0wNzAwPC9kaXY+PGRpdj48Yj5U
bzogPC9iPiZsdDt1c2VyQGhpdmUuYXBhY2hlLm9yZyZndDs8L2Rpdj48ZGl2PjxiPlJlcGx5VG86
IDwvYj4gdXNlckBoaXZlLmFwYWNoZS5vcmcNCjwvZGl2PjxkaXY+PGI+U3ViamVjdDogPC9iPm1v
c3QgZWZmaWNpZW50IHdheSB0byBjb25jYXRlbmF0ZSAzIHRhYmxlcyBpbnRvIG9uZT88L2Rpdj48
ZGl2Pjxici8+PC9kaXY+SSBoYXZlIDMgdGFibGVzLCBlYWNoIGNvbnRhaW5zIG1vbnRobHkgZGF0
YSwgSSB3b3VsZCBsaWtlIHRvIG1ha2UgYSB0YWJsZSB0byBjb25jYXRlbmF0ZSBhbGwgMyBtb250
aHMgaW50byAxIHRhYmxlLqA8ZGl2PldoYXQgaXMgdGhlIG1vc3QgZWZmaWNpZW50IHdheSB0byBk
byB0aGF0PzwvZGl2PjxkaXY+SSBhbSB1c2luZyBpbnNlcnQgaW50byB3aGljaCB0YWtlcyBhIGxv
bmcgdGltZS48L2Rpdj4NCjxkaXY+PGJyPjwvZGl2PjxkaXY+VGhhbmtzITwvZGl2Pg0KDQo8L2Jv
ZHk+PC9odG1sPg==

--part35-boundary-436370583-1284005141--