timeouts for long queries

2015-09-15 Thread James Heather
I'm a bit lost as to what I need to change, and where I need to change it, to bump up timeouts for this kind of error: Caused by: org.apache.phoenix.exception.PhoenixIOException: org.apache.phoenix.exception.PhoenixIOException: Failed after attempts=36, exceptions: Tue Sep 15 18:48:13 U

phoenix : timeouts for long queries

2016-05-13 Thread ????
When I query from a very big table It get errors as follow: java.lang.RuntimeException: org.apache.phoenix.exception.PhoenixIOException: org.apache.phoenix.exception.PhoenixIOException: Failed after attempts=36, exceptions: Fri May 13 16:15:29 CST 2016, null, java.net.SocketTimeoutException:

Re: timeouts for long queries

2015-09-15 Thread Ravi Kiran
Hi James, You need to increase the value of hbase.rpc.timeout in hbase-site.xml on your client end. http://hbase.apache.org/book.html#trouble.client.lease.exception Ravi On Tue, Sep 15, 2015 at 12:56 PM, James Heather wrote: > I'm a bit lost as to what I need to change, and where I need to c

Re: timeouts for long queries

2015-09-15 Thread James Taylor
The other important timeout is Phoenix specific: phoenix.query.timeoutMs. Set this in your hbase-site.xml on the client side to the value in milliseconds for the amount of time you're willing to wait before the query finishes. I might be wrong, but I believe the hbase.rpc.timeout config parameter n

Re: timeouts for long queries

2015-09-15 Thread Gaurav Kanade
I am facing the same problem - it seems that my newly applied settings are not being picked up correctly. I have put the rpc.timeout as well as phoenix.query.timeout to appropriate values; in addition I changed the client retries to 50 instead of 36 (I see the number 36 in your message too) and yet

Re: timeouts for long queries

2015-09-16 Thread James Heather
Can you tell me how to set these client-side properties programmatically? I'm using JDBI, which uses JDBC; I'm building the whole application into an executable jar. It's not clear to me where I would put a hbase-site.xml; but I suspect that it is easier in any case to set the Phoenix properti

Re: timeouts for long queries

2015-09-17 Thread Nick Dimiduk
I really recommend managing hbase-site.xml outside of your uberjar. You should already be doing this anyway with other resources, such as log4j.properties. If you are intent on setting them programmatically, you'll need to pass them into the PhoenixConnection's HBaseConfiguration object. I believe

Re: phoenix : timeouts for long queries

2016-05-13 Thread Ankit Singhal
You can try increasing phoenix.query.timeoutMs (and hbase.client.scanner.timeout.period) on the client . https://phoenix.apache.org/tuning.html On Fri, May 13, 2016 at 1:51 PM, 景涛 <844300...@qq.com> wrote: > When I query from a very big table > It get errors as follow: > > java.lang.RuntimeExcep

答复: timeouts for long queries

2015-09-15 Thread 谭自强
@phoenix.apache.org 主题: Re: timeouts for long queries I am facing the same problem - it seems that my newly applied settings are not being picked up correctly. I have put the rpc.timeout as well as phoenix.query.timeout to appropriate values; in addition I changed the client retries to 50 instead of 36 (I