RE: Thrift Server

2012-06-29 Thread Hezhiqiang (Ransom)
Hi Van In my test, JDBC supported about 25 connections in the same time without delay. If more connections , it will line up and timeout exception will happen. Regards Ransom -Original Message- From: VanHuy Pham [mailto:huy.pham...@gmail.com] Sent: Saturday, June 30, 2012 8:59 AM To:

Re: Thrift Server

2012-06-29 Thread VanHuy Pham
Thanks for the response. I see. Would JDBC then be a better option for concurrent connections? I am not aware of the implementation of hive-JDBC so wonder if it support multiple connections? Any idea? On 6/29/12, Hezhiqiang (Ransom) wrote: > Hi Van > Hive doesn’t supported multiple conne

RE: Thrift Server

2012-06-29 Thread Hezhiqiang (Ransom)
Hi Van Hive doesn’t supported multiple connections now. it's impossible for HiveServer to support concurrent connections using the current Thrift API you can see: https://issues.apache.org/jira/browse/HIVE-2935 https://cwiki.apache.org/confluence/download/attachments/27362054/Hiv

Thrift Server

2012-06-29 Thread VanHuy Pham
Hi hive folks, Does hive thrift server support multiple requests from clients at the same time? It looks like the server serves the request sequentially, which means it processes each request one by one. Am I wrong here? I make two clients, which make two requests (select data) to two d

RE: Obvious and not so obvious query optimzations in Hive

2012-06-29 Thread richin.jain
Thanks Bejoy, that is really helpful. From: ext Bejoy KS [mailto:bejoy...@yahoo.com] Sent: Thursday, June 28, 2012 4:12 PM To: Jain Richin (Nokia-HR/Boston); user@hive.apache.org Subject: Re: Obvious and not so obvious query optimzations in Hive Hi Richin The Keys vary based on your queries on t

INSERT OVERWRITE with empty data

2012-06-29 Thread Aleksei Udatšnõi
I have a Hive query like: INSERT OVERWRITE TABLE a SELECT * FROM b WHERE ..; Table A is not partitioned, table B is. If the SELECT from B contains some data, it is replaced in table A as expected. However if the result of the SELECT is empty, the data in table A does not get truncated. The orig