RE: if else condition in hive

From: raj hive [mailto:raj.hiv...@gmail.com] Sent: Tuesday, June 21, 2016 2:22 PM To: user@hive.apache.org Subject: if else condition in hive Hi friends, INSERT,UPDATE,DELETE commands are working fine in my Hive environment after changing the configuration and all. Now, I have to execute a query

Re: if else condition in hive

I recommend you to rethink it as part of a bulk transfer potentially even using separate partitions. Will be much faster. > On 21 Jun 2016, at 13:22, raj hive wrote: > > Hi friends, > > INSERT,UPDATE,DELETE commands are working fine in my Hive environment after > changing the configuration an

Re: if else condition in hive

Hi Raj, Hive hpl/sql component can be used to achieve such functionality (see www.hplsql.org for docs), now you can run it as a separate tool, and I hope some day it will be available from Hive or Beeline CLI. Thanks, Dmitry On Tue, Jun 21, 2016 at 2:22 PM, raj hive wrote: > Hi friends, > > IN

if else condition in hive

Hi friends, INSERT,UPDATE,DELETE commands are working fine in my Hive environment after changing the configuration and all. Now, I have to execute a query like below sql in hive. If exists(select * from tablename where columnname=something) update table set column1=something where columnname=s