Glad to know the patch worked. It should be part of our 4.5.2 patch release
which we hopefully will be releasing soon.
Out of curiosity - did your order by query ever finish? How much time did
it take? Also how much time did the original query take with the patch that
I provided?
On Wed, Aug 26,
Hi Samarth,
The patch definitely solves the issue. The query select * from
table retrieves all the records. Thanks for the patch.
Thanks,
Sunil
On Tue, Aug 25, 2015 at 1:21 PM, Samarth Jain samarth.j...@gmail.com wrote:
Thanks for the debugging info Sunil.
I have uploaded a possible
Sunil,
Can you tells us a little bit more about the table -
1) How many regions are there?
2) Do you have phoenix stats enabled?
http://phoenix.apache.org/update_statistics.html
3) Is the table salted?
4) Do you have any overrides for scanner caching (
hbase.client.scanner.caching) or result
Hi Samarth,
Answers to your questions:
1) How many regions are there?
Ans: Total regions: 21. Each region is 5GB uncompressed (1.7GB
compressed). Total region servers: 7
2) Do you have phoenix stats enabled?
http://phoenix.apache.org/update_statistics.html
Ans: The configuration is at
Hi,
Phoenix Version: 4.5.0-Hbase-1.0
Client: slqline/JDBC driver
I have a large table which has around 100GB of data. I am trying to
execute a simple query select * from TABLE, which times out with
scanner timeout exception. Please let me know if there is a way to
avoid this timeout