Re: select/limit hanging on large tables

2015-05-12 Thread Shahab Yunus
In addition to Talat's comment about more info, you can check out the following properties: phoenix.query.queueSize phoenix.query.timeoutMs http://phoenix.apache.org/tuning.html We have set these in the hbase-site-.xml on the client machine where the Squirrel was running in the cases where the ta

Re: select/limit hanging on large tables

2015-05-11 Thread Talat Uyarer
Hi Kiru, Can you give more information about your data. I can not understand what is exact problem. I have some question What is your table schema ? What is data size ? What is your heap size ? Avg row size ?. BTW To tell general something, You can read those sources for Hbase tuning [1] http://

select/limit hanging on large tables

2015-05-11 Thread Kiru Pakkirisamy
We are trying to benchmark/test Phoenix with large tables.A 'select * from table1 limit 10' hangs on a 1.4 billion row table (in sqlline.py or SQuirreL)The same select of 1million rows works on smaller table (300 million).Mainly we wanted to create a smaller version of the 1.4 billion table