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.
-----Original Message-----
From: Bhavesh Shah <bhavesh25s...@gmail.com>
Date: Wed, 15 Feb 2012 14:33:29
To: <u...@hive.apache.org>; <dev@hive.apache.org>
Reply-To: u...@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
