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 <zuo...@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!
