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 Ramachandran [mailto:vi...@linkedin.com] > *Sent:* Friday, September 23, 2016 1:46 PM > *To:* user@hive.apache.org > *Subject:* Re: on duplicate update equivalent? > > > > > > On Fri, Sep 23, 2016 at 3:47 PM, Mich Talebzadeh < > mich.talebza...@gmail.com> 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 rows) or inserted (new rows)? > > > > Hi Mich. > > Exactly, I'm looking at dimension tables. > > thanks, > > >