Re: Hive append support

2012-08-09 Thread Sandeep Reddy P
HI, Can we consider using HBASE for the same? On Thu, Aug 9, 2012 at 1:19 PM, Sandeep Reddy P wrote: > Thank you all for the info. > > > On Thu, Aug 9, 2012 at 12:30 PM, Bob Gause wrote: > >> Hive has no update & delete statements. >> >> You can drop a table, and that is as closes to a delete a

Re: Hive append support

2012-08-09 Thread Sandeep Reddy P
Thank you all for the info. On Thu, Aug 9, 2012 at 12:30 PM, Bob Gause wrote: > Hive has no update & delete statements. > > You can drop a table, and that is as closes to a delete as you get. > > The only "update" you get is to append more data to a table. There is > INSERT OVERWRITE & INSERT. T

Re: Hive append support

2012-08-09 Thread Bob Gause
Hive has no update & delete statements. You can drop a table, and that is as closes to a delete as you get. The only "update" you get is to append more data to a table. There is INSERT OVERWRITE & INSERT. The first will create the first set of rows in the table, the second will append more data

Re: Hive append support

2012-08-09 Thread Bejoy Ks
P To: user@hive.apache.org; Bejoy Ks Sent: Thursday, August 9, 2012 9:19 PM Subject: Re: Hive append support Hi Bejoy, Thanks for the link. When you say updates are not supported directly is there any other way we can update data in HDFS/Hive? On Thu, Aug 9, 2012 at 10:30 AM, Bejoy Ks

Re: Hive append support

2012-08-09 Thread Sandeep Reddy P
Hi Bejoy, Thanks for the link. When you say updates are not supported directly is there any other way we can update data in HDFS/Hive? On Thu, Aug 9, 2012 at 10:30 AM, Bejoy Ks wrote: > Hi Sandeep > > If you are looking at inserting more data into existing tables that has > data, the yes it is

Re: Hive append support

2012-08-09 Thread Bejoy Ks
Hi Sandeep If you are looking at inserting more data into existing tables that has data, the yes it is supported in hive from 0.8 (i guess). You cn see the INSERT INTO documentation here https://cwiki.apache.org/Hive/languagemanual-dml.html#LanguageManualDML-InsertingdataintoHiveTablesfromquerie