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 >
