Hi Bejoy K S, Thanks for your reply. The overhead is, in select query I have near about 85 columns. Writing this in the file and again loading it may take some time. For that reason I am thinking that it will be inefficient.
-- Regards, Bhavesh Shah On Wed, Feb 15, 2012 at 2:51 PM, <bejoy...@yahoo.com> wrote: > ** > Hi Bhavesh > INSERT INTO is supported in hive 0.8 . An upgrade would get you things > rolling. > LOAD DATA inefficient? What was the performance overhead you were facing > here? > Regards > Bejoy K S > > From handheld, Please excuse typos. > ------------------------------ > *From: * Bhavesh Shah <bhavesh25s...@gmail.com> > *Date: *Wed, 15 Feb 2012 14:33:29 +0530 > *To: *<user@hive.apache.org>; <d...@hive.apache.org> > *ReplyTo: * user@hive.apache.org > *Subject: *Doubt in INSERT query in Hive? > > Hello, > Whenever we want to insert into table we use: > INSERT OVERWRITE TABLE TBL_NAME > (SELECT ....) > Due to this, table gets overwrites everytime. > > I don't want to overwrite table, I want append it everytime. > I thought about LOAD TABLE , but writing the file may take more time and I > don't think so that it will efficient. > > Does Hive Support INSERT INTO TABLE TAB_NAME? > (I am using hive-0.7.1) > Is there any patch for it? (But I don't know How to apply patch ?) > > Pls suggest me as soon as possible. > Thanks. > > > > -- > Regards, > Bhavesh Shah > >
