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<mailto: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,