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 <raj.hiv...@gmail.com> wrote: > 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=something > else > insert into tablename values ... > > Can any one help me how to do it in Hive? > > Thanks > Raj >
