Java api for connecting to hiveserver2

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 thr

Re: Variable set via query

This is more like macro than variable. Refer to https://github.com/myui/hivemall/blob/master/scripts/ddl/define-macros.hive for some examples/usage. --Xuefu On Fri, Oct 10, 2014 at 6:21 PM, Martin, Nick wrote: > Hi all, > > Wondering of its possible for me to set a variable via a query. Somethi

multiple insert clauses for the same table

I am using Hive 0.12.0. And when putting multiple inserts for the same table in one SQL, looks like hive queries plan analyzer fails to synthesis the right plan. Here is the issue. create table T1(i int, j int); create table T2(m int) partitioned by (n int); explain from T1 insert into table T2 p

Variable set via query

Hi all, Wondering of its possible for me to set a variable via a query. Something like: Set V1= select max(V1) from sometable And then use V1 in my query. Thx! Sent from my iPhone

Re: mapreduce.job.queuename doesn't work with hiveserver2

Thanks for the reply. I am using Hue so I may need to find a way to hack this into Hue. On Fri, Oct 10, 2014 at 7:39 AM, Navdeep Agrawal < navdeep_agra...@symantec.com> wrote: > You can change the mapreduce.job.queuename by appending it to connection > string after ‘?’ like jdbc:hive2//url:1/

Re: HIveserver jdbc set configurations

You can execute a 'set property=value' statements using Statement.execute(). Such change will only be visible in the current session. thanks Prasad On Fri, Oct 10, 2014 at 4:11 AM, Navdeep Agrawal < navdeep_agra...@symantec.com> wrote: > Hi, > > I am connecting to hive server2 through jdbc an

RE: mapreduce.job.queuename doesn't work with hiveserver2

You can change the mapreduce.job.queuename by appending it to connection string after ‘?’ like jdbc:hive2//url:1/db?mapreduce.job.queuename=q1 From: Chen Song [mailto:chen.song...@gmail.com] Sent: Friday, October 10, 2014 2:38 AM To: user Subject: mapreduce.job.queuename doesn't work with hiv

HIveserver jdbc set configurations

Hi, I am connecting to hive server2 through jdbc and want to set some properties like mapreduce.queuename;hive.compute.query.using.stats; how can I achieve that through java . Thanks, Navdeep