hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Devopam Mittra <>
Subject Re: Hive UPDATE : query around usage
Date Mon, 19 Jan 2015 03:31:44 GMT
hi Lefty,
Thanks again for the crisp response.
After going through it all over again , and brooding over the weekend I
understood that my ask is yet not there and I was trying to do things in a
(yet) impractical way.

I am sure it will be the need in future , if we were to use and promote
Hive as The 'SQL' engine for Hadoop in the longer run.

Till then I will rather stick to my old technique of handling UPDATE as
DELETE+INSERT and leveraging dynamic partitions to achieve the objective.

warm regards

On Sat, Jan 17, 2015 at 1:48 PM, Lefty Leverenz <>

> I can't answer your question, but here are some links to documentation in
> the Hive wiki:
>    - DML -- Update
>    <>
>    - Hive Transactions
>    <>
> -- Lefty Leverenz
> On Fri, Jan 16, 2015 at 6:09 AM, Devopam Mittra <> wrote:
>> hi All,
>> I wanted to UPDATE multiple rows in a table by joining it with another
>> table for identification of matching records (otherwise in the RDBMS world
>> also commonly known as SET based UPDATE).
>> The idea is to update multiple records in one go , to downsize the lead
>> time for each MR job to kick off.
>> Is it supported or I am being greedy here with my wishlist ?
>> Also, at an atomic level update as well, is there a way I can update a
>> table without providing explicit variables (aka expression)  in the WHERE
>> clause.
>> e.g.: I want to update one row in a table and in the where clause i wish
>> to use a SELECT with other table to identify / match the record.
>> Kindly drop a pointer to the syntax manual to look it up.
>> Happy weekend !
>> --
>> Devopam Mittra
>> Life and Relations are not binary

Devopam Mittra
Life and Relations are not binary

View raw message