Re: Hive Query Timeout in hive-jdbc

2016-02-02 Thread Loïc Chanel
Then indeed Tez and MR timeout won't be any help, sorry. I would be very interested in your solution though. Regards, Loïc Loïc CHANEL System & virtualization engineer TO - XaaS Ind - Worldline (Villeurbanne, France) 2016-02-02 11:27 GMT+01:00 Satya Harish Appana : > Queries I am running over H

Re: Hive Query Timeout in hive-jdbc

2016-02-02 Thread Satya Harish Appana
Queries I am running over Hive JDBC are ddl statements(none of the queries are select or insert. which will result in an execution engine(tez/mr) job to be launched.. all the queries are create external table .. and drop table .. and alter table add partitions). On Tue, Feb 2, 2016 at 3:54 PM, Lo

Re: Hive Query Timeout in hive-jdbc

2016-02-02 Thread Loïc Chanel
Actually, Hive doesn't support timeout, but Tez and MapReduce does. Therefore, you can set a timeout on these tools to kill failed queries. Hope this helps, Loïc Loïc CHANEL System & virtualization engineer TO - XaaS Ind - Worldline (Villeurbanne, France) 2016-02-02 11:10 GMT+01:00 董亚军 : > hive

Re: Hive Query Timeout in hive-jdbc

2016-02-02 Thread 董亚军
hive does not support timeout on the client side. and I think it is not recommended that if the client exit with timeout exception, the hiveserver side may also running the job. this will result in inconsistent state. On Tue, Feb 2, 2016 at 4:49 PM, Satya Harish Appana < satyaharish.app...@gmail.

Hive Query Timeout in hive-jdbc

2016-02-02 Thread Satya Harish Appana
Hi Team, I am trying to connect to hiveServer via hive-jdbc. Can we configure client side timeout at each query executed inside each jdbc connection. (When I looked at HiveStatement.setQueryTimeout method it says operation unsupported). Is there any other way of timing out and cancelling the con

Re: Query Timeout

2015-06-22 Thread @Sanjiv Singh
Hi Ibrar What is the value given for --hiveconf *hbase.master*=# OR --hiveconf *hbase.zookeeper.quorum*= It seems from the error that HBase Server configuration are not correct. Regards Sanjiv Singh Mob : +091 9990-447-339 On Wed, Jun 17, 2015 at 4:31 PM, Ibrar Ahmed w

Re: Query Timeout

2015-06-17 Thread Ibrar Ahmed
I am able to fix that issue, but got another error [127.0.0.1:1] hive> CREATE TABLE IF NOT EXISTS pagecounts_hbase (rowkey STRING, pageviews STRING, bytes STRING) STORED BY 'org.apache.hadoop.hive.hbase.HBaseStorageHandler' WITH SERDEPROPERTIES ('hbase.columns.mapping' = ':key,f:c1,f:c2') TBL

Query Timeout

2015-06-17 Thread Ibrar Ahmed
Hi, Whats wrong with my settings? [127.0.0.1:1] hive> CREATE TABLE IF NOT EXISTS pagecounts_hbase (rowkey STRING, pageviews STRING, bytes STRING) STORED BY 'org.apache.hadoop.hive.hbase.HBaseStorageHandler' WITH SERDEPROPERTIES ('hbase.columns.mapping' = ':key,f:c1,f:c2') TBLPROPERTIES (' hba