Hi Nitin, existing records should remain same and the new records should get inserted into the table
On Thu, Mar 6, 2014 at 2:11 PM, Nitin Pawar <nitinpawar...@gmail.com> wrote: > are you talking about adding new records to tables or updating records in > already existing table? > > > On Thu, Mar 6, 2014 at 1:59 PM, Raj hadoop <raj.had...@gmail.com> wrote: > >> Query in HIVE >> >> >> >> I tried merge kind of operation in Hive to retain the existing records >> and append the new records instead of dropping the table and populating it >> again. >> >> >> >> If anyone can come help with any other approach other than this or the >> approach to perform merge operation >> >> >> >> will be great help >> > > > > -- > Nitin Pawar >