phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From anil gupta <>
Subject java.lang.RuntimeException: org.apache.phoenix.exception.PhoenixIOException for long running Queries
Date Thu, 03 Jul 2014 04:26:06 GMT
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(
        at sqlline.SqlLine$TableOutputFormat.print(
        at sqlline.SqlLine.print(
        at sqlline.SqlLine$Commands.execute(
        at sqlline.SqlLine$Commands.sql(
        at sqlline.SqlLine.dispatch(
        at sqlline.SqlLine.begin(
        at sqlline.SqlLine.mainWithInputRedirection(
        at sqlline.SqlLine.main(

I cannot understand why i am getting this IOException? Is there are way to
resolve this problem?

Thanks & Regards,
Anil Gupta

View raw message