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.
Sent from handheld, please excuse typos.
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.