Re: on duplicate update equivalent?

2016-09-23 Thread Vijay Ramachandran
On Fri, Sep 23, 2016 at 3:47 PM, Mich Talebzadeh wrote: > What is the use case for UPSERT in Hive. The functionality does not exist > but there are other solutions. > > Are we talking about a set of dimension tables with primary keys hat need > to be updated (existing

on duplicate update equivalent?

2016-09-23 Thread Vijay Ramachandran
Hello. Is there a way to write a query with a behaviour equivalent to mysql's "on duplicate update"? i.e., try to insert, and if key exists, update the row instead? thanks,

RE: on duplicate update equivalent?

2016-09-23 Thread Vijay Ramachandran
Dimensions change, and I'd rather do update than recreate a snapshot. On 23-Sep-2016 17:23, "Markovitz, Dudu" <dmarkov...@paypal.com> wrote: > If these are dimension tables, what do you need to update there? > > > > Dudu > > > > *From:* Vijay Ramac