hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Devopam Mittra <devo...@gmail.com>
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
Devopam


On Sat, Jan 17, 2015 at 1:48 PM, Lefty Leverenz <leftyleverenz@gmail.com>
wrote:

> I can't answer your question, but here are some links to documentation in
> the Hive wiki:
>
>    - DML -- Update
>    <https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DML#LanguageManualDML-Update>
>    - Hive Transactions
>    <https://cwiki.apache.org/confluence/display/Hive/Hive+Transactions>
>
>
> -- Lefty Leverenz
>
>
> On Fri, Jan 16, 2015 at 6:09 AM, Devopam Mittra <devopam@gmail.com> 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

Mime
View raw message