Simple User/Password authentication for HiveServer2 (without Kerberos/LDAP)

Hi, how to provide a simple propertyfile or database user/password authentication for HiveServer2? Since it is a small research project, we don't have Kerberos or LDAP. I already found this [0] presentation about it, but it's not in English :(. On the Cloudera reference manual [1] I found smth. a

Re: Fetching Results from Hive Select (JDBC ResultSet.next() vs HiveClient.fetchN())

me = "bigdata"; sql = "select * from " + tableName + " limit 15"; System.out.println("Running: " + sql); res = stmt.executeQuery(sql); // enlarge the FetchSize (default is just 50!) ((HiveQueryResultSet) res).setFetchSize(1); Best Regards, Christi

Convenience methods .execute(String query) and fetchX(x) on TCLIService.thrift

Hi, I compared the HiveServer 1 and HiverServer 2 Thrift implementation. I'm asking myself why the straight forward methodes like .execute(String Query) and the three fetchX(x) methods defined in org.apache.hadoop.hive.service.ThriftHive.Client doesn't in the TCLIService.thrift? Now we have to h

Thrift ITL for Hive Server 2

Hi, i try to access HiveServer2 through thrift with java. But where is the ITL to generate a the HiveServer2 client? The only thrift ITL I find is located here: * https://github.com/apache/hive/tree/HIVE-4115/service/if / hive_service.thrift (i don't know what TCLIService.thrift is) I tried to fi

Re: Fetching Results from Hive Select (JDBC ResultSet.next() vs HiveClient.fetchN())

I just test the same statement with beeline and got the same bad performance. Any ideas? Best Regards, Chrisitan. 2013/6/26 Christian Schneider > Hi, > currently we are using HiveSever1 with the native HiveClient interface. > Our application design looks horrible because (for whatev

Re: How to connect to HiveServer 2? (Only through JDBC?)

start a thread, use Jsch to execute "mv result.csv result.c" every 3 mins, > you can know if the mv successful by call Jsch API > if success, then the query ends > > 2013-06-26 > ------ > kentkong_work > -- > *发

How to connect to HiveServer 2? (Only through JDBC?)

Hi, is JDBC the only way to connect to HiveServer 2? I can't find any documentation how to do it with java? There is a Thrift port open, but how to use that? Best Regards, Christian.

Fetching Results from Hive Select (JDBC ResultSet.next() vs HiveClient.fetchN())

Hi, currently we are using HiveSever1 with the native HiveClient interface. Our application design looks horrible because (for whatever reason) it spawns a dedicated HiveServer for every query. We thought it is a good idea to switch to HiveServer2 (because the MetaStore get used by many different

Re: How to terminate a running HIve Query? (Executed with JDBC, Hive Server 2)

racker to find your job id. > 2. use hadoop job -kill to nuke it. > > you're saying there's no way to interrupt/kill the query from the client? > That very well may be the case. > > > On Tue, Jun 25, 2013 at 10:22 AM, Christian Schneider < > cschneiderpub...@gmai

Re: How to terminate a running HIve Query? (Executed with JDBC, Hive Server 2)

. Any suggestions? 2013/6/25 Christian Schneider > Hi, > is it possible to kill a running query (including all the hadoop jobs > behind)? > > I think it's not, because the Hive JDBC Driver doesn't implement .close() > and .cancel() on the (prepared) statement. >

How to terminate a running HIve Query? (Executed with JDBC, Hive Server 2)

Hi, is it possible to kill a running query (including all the hadoop jobs behind)? I think it's not, because the Hive JDBC Driver doesn't implement .close() and .cancel() on the (prepared) statement. This attached code shows the problem. Bevor the statement gets executed, it will spawn a Thread