hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Suhas Gogate <>
Subject Re: Java api for connecting to hiveserver2
Date Sat, 11 Oct 2014 19:43:26 GMT
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.


On Sat, Oct 11, 2014 at 12:38 PM, Suhas Gogate <> 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 <
>> 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

View raw message