Sorry Anish, but being database programmer in the past, I always used embedded SQL interface... I was wondering should we really need direct Java interface w/ HiveServer2? May be I am wrong, but would like to know your view on what are the limitations of using embedded SQL vs direct Java API.
--Suhas On Sat, Oct 11, 2014 at 12:38 PM, Suhas Gogate <vgog...@pivotal.io> wrote: > Hanish, this is interesting question and I also faced similar limitation > lately. Although as Hive getting more closer to relational model with > richer SQL interface (DDL/Authorization, DML) and HiveServer2 as a way to > invoke embedded SQL in Java, the real question is should Hive Metastore > Client (java) API should at all be used by user, rather all the existing > Hive Client interfaces be talking to Hive Metastore internally? > > --Suhas > > > > On Fri, Oct 10, 2014 at 9:21 PM, Hanish Bansal < > hanish.bansal.agar...@gmail.com> wrote: > >> Hi All, >> >> I am planning to use sql based authorization that is recently introduced >> in hive 0.13.0. >> >> I was using hive metastore client java api early which has direct apis >> for all operations like grant, revoke etc. >> But for using new authorization I ll have to use hiveserver2 and pass all >> requests through hiveserver2. I came up with JDBC client which can be used >> to connect hiveserver2. The restriction there is we must have to write SQL >> statements. >> >> I want to know is there any java api to connect hiveserver2, that have >> direct java methods to perform operations and we don't need to write SQL >> statements ?? >> >> Thanks, >> Hanish >> > >
