Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded View
Hive >> mail # user >> most efficient way to concatenate 3 tables into one?


Copy link to this message
-
Re: most efficient way to concatenate 3 tables into one?
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 <[EMAIL PROTECTED]>
Date: Wed, 12 Sep 2012 13:02:42
To: <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
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!