hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Devopam Mittra <>
Subject Hive UPDATE : query around usage
Date Fri, 16 Jan 2015 14:09:18 GMT
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
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

View raw message