java.lang.RuntimeException: org.apache.phoenix.exception.PhoenixIOException for long running Queries

[anil gupta <an...@gmail.com>]

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