Hi All,
I am running the following query in phoenix3.0 with HBase0.94.15 on a
phoenix view:
select count(*), Event_Date from Events where time>2698275600000 and
time<=2708812800000 and bucket in (0,1,2,3,4,5) group by Event_Date;
The rowkey is <bucket><time>. Bucket value range is only from 0-5. This
query will scan around 90 million rows and row size is less than 1KB. The
scan caching is set to 100.
I already increased the hbase leasing period and phoenixTimeout to 6
minutes. I can run this query when i limit the scan to around 30 million
rows with a response time of 2 minutes.
Here is the stack trace:
java.lang.RuntimeException: org.apache.phoenix.exception.PhoenixIOException
at sqlline.SqlLine$IncrementalRows.hasNext(SqlLine.java:2440)
at sqlline.SqlLine$TableOutputFormat.print(SqlLine.java:2074)
at sqlline.SqlLine.print(SqlLine.java:1735)
at sqlline.SqlLine$Commands.execute(SqlLine.java:3683)
at sqlline.SqlLine$Commands.sql(SqlLine.java:3584)
at sqlline.SqlLine.dispatch(SqlLine.java:821)
at sqlline.SqlLine.begin(SqlLine.java:699)
at sqlline.SqlLine.mainWithInputRedirection(SqlLine.java:441)
at sqlline.SqlLine.main(SqlLine.java:424)
I cannot understand why i am getting this IOException? Is there are way to
resolve this problem?
--
Thanks & Regards,
Anil Gupta
