Mailing-List: contact user-help@hive.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@hive.apache.org
Received-SPF: pass (nike.apache.org: local policy)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws;
  s=s1024; d=yahoo.com;
  h=X-YMail-OSG:Received:X-Mailer:References:Message-ID:Date:From:Reply-To:Subject:To:In-Reply-To:MIME-Version:Content-Type;
  b=m4zDkAwbufK/sXiQ/PnQ+NqeD0TS+77z29L5bWbTIbRJNkByDS0HfOWW0GCy0IvQqEE41wOX/nRrchQLYGLiza5PNynPoQjNHg3XYxedxNzKNcglYhPRHapii9ZPHVlKvL8hd7dOGT1xxDhFybGl9YtaQG1dQWpfA6/qqMcmTts=;
References: 
 <CAP8D2NaKBkLGZ_2vAv_diYbN4edNJ-wXYHyZk_hrzuco19L7yA@mail.gmail.com>
Message-ID: <1344522646.18101.YahooMailNeo@web121203.mail.ne1.yahoo.com>
Date: Thu, 9 Aug 2012 07:30:46 -0700 (PDT)
From: Bejoy Ks <bejoy_ks@yahoo.com>
Reply-To: Bejoy Ks <bejoy_ks@yahoo.com>
Subject: Re: Hive append support
To: "user@hive.apache.org" <user@hive.apache.org>
In-Reply-To: 
 <CAP8D2NaKBkLGZ_2vAv_diYbN4edNJ-wXYHyZk_hrzuco19L7yA@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/alternative;
 boundary="1087320363-614231830-1344522646=:18101"

--1087320363-614231830-1344522646=:18101
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable

Hi Sandeep=0A=0AIf you are looking at inserting more data into existing tab=
les that has data, the yes it is supported in hive from 0.8 (i guess). You =
cn see the INSERT INTO documentation here=0Ahttps://cwiki.apache.org/Hive/l=
anguagemanual-dml.html#LanguageManualDML-InsertingdataintoHiveTablesfromque=
ries=0A=0AUpdates are not supported by hive directly.=0A=0A=A0=0ARegards,=
=0ABejoy KS=0A=0A=0A________________________________=0A From: Sandeep Reddy=
 P <sandeepreddy.3647@gmail.com>=0ATo: user@hadoop.apache.org =0ACc: user@h=
ive.apache.org; cdh-user@cloudera.org =0ASent: Thursday, August 9, 2012 7:5=
6 PM=0ASubject: Hive append support=0A =0A=0AHi,=0AIs there any version of =
Hive for append operations (Insert or=0AUpdate) via HiveQL? Ifsoplease poin=
t me at any HiveQL documentation that=0Aexplains how the append operations =
work?=0A=0A-- =0AThanks,=0Asandeep
--1087320363-614231830-1344522646=:18101
Content-Type: text/html; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable

<html><body><div style=3D"color:#000; background-color:#fff; font-family:ve=
rdana, helvetica, sans-serif;font-size:10pt"><div><span>Hi Sandeep</span></=
div><div><br><span></span></div><div><span>If you are looking at inserting =
more data into existing tables that has data, the yes it is supported in hi=
ve from 0.8 (i guess). You cn see the INSERT INTO documentation here</span>=
</div><div><span>https://cwiki.apache.org/Hive/languagemanual-dml.html#Lang=
uageManualDML-InsertingdataintoHiveTablesfromqueries</span></div><div><br><=
span></span></div><div><span>Updates are not supported by hive directly.<br=
></span></div><div>&nbsp;</div><div><div style=3D"font-weight:bold;"><span =
style=3D"font-family:arial, helvetica, sans-serif;">Regards,</span></div><d=
iv style=3D"font-weight:bold;"><span style=3D"font-family:arial, helvetica,=
 sans-serif;">Bejoy KS</span></div></div><div><br></div>  <div style=3D"fon=
t-family: verdana, helvetica, sans-serif; font-size: 10pt;"> <div
 style=3D"font-family: times new roman, new york, times, serif; font-size: =
12pt;"> <div dir=3D"ltr"> <font face=3D"Arial" size=3D"2"> <hr size=3D"1"> =
 <b><span style=3D"font-weight:bold;">From:</span></b> Sandeep Reddy P &lt;=
sandeepreddy.3647@gmail.com&gt;<br> <b><span style=3D"font-weight: bold;">T=
o:</span></b> user@hadoop.apache.org <br><b><span style=3D"font-weight: bol=
d;">Cc:</span></b> user@hive.apache.org; cdh-user@cloudera.org <br> <b><spa=
n style=3D"font-weight: bold;">Sent:</span></b> Thursday, August 9, 2012 7:=
56 PM<br> <b><span style=3D"font-weight: bold;">Subject:</span></b> Hive ap=
pend support<br> </font> </div> <br>=0A<meta http-equiv=3D"x-dns-prefetch-c=
ontrol" content=3D"off"><div id=3D"yiv1918415498">Hi,<br><span style=3D"col=
or:rgb(51,51,51);">Is there any </span><span style=3D"font-size:11pt;color:=
rgb(51,51,51);" lang=3D"EN-GB">version of Hive for append operations (Inser=
t or=0AUpdate) via HiveQL?</span> If<span style=3D"color:rgb(51,51,51);"> s=
o</span><span style=3D"font-size:11pt;color:rgb(51,51,51);" lang=3D"EN-GB">=
 please point me at any HiveQL documentation that=0Aexplains how the append=
 operations work?</span><br clear=3D"all"><br>-- <br>Thanks,<br>sandeep<br>=
<br>=0A</div><meta http-equiv=3D"x-dns-prefetch-control" content=3D"on"><br=
><br> </div> </div>  </div></body></html>
--1087320363-614231830-1344522646=:18101--