phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "James Taylor (JIRA)" <j...@apache.org>
Subject [jira] [Created] (PHOENIX-2074) StackOverflowError for hash join with round robin
Date Thu, 25 Jun 2015 04:54:05 GMT
James Taylor created PHOENIX-2074:
-------------------------------------

             Summary: StackOverflowError for hash join with round robin
                 Key: PHOENIX-2074
                 URL: https://issues.apache.org/jira/browse/PHOENIX-2074
             Project: Phoenix
          Issue Type: Bug
            Reporter: James Taylor


EVENTS Table has id,article, and more columns. Id is the primay key
MAPPING Table has id,article,category columns. Id is the primay key
There is index on article column of both the tables.

Below is the query. 

select count(MAPPING.article) as cnt,MAPPING.category from EVENTS
join
MAPPING on MAPPING.article = EVENTS.article
group by category order by cnt ;

Here's the stack trace:
{code}
Error: Encountered exception in sub plan [0] execution. (state=,code=0)
java.sql.SQLException: Encountered exception in sub plan [0] execution.
        at org.apache.phoenix.execute.HashJoinPlan.iterator(HashJoinPlan.java:156)
        at org.apache.phoenix.jdbc.PhoenixStatement$1.call(PhoenixStatement.java:251)
        at org.apache.phoenix.jdbc.PhoenixStatement$1.call(PhoenixStatement.java:241)
        at org.apache.phoenix.call.CallRunner.run(CallRunner.java:53)
        at org.apache.phoenix.jdbc.PhoenixStatement.executeQuery(PhoenixStatement.java:240)
        at org.apache.phoenix.jdbc.PhoenixStatement.execute(PhoenixStatement.java:1250)
        at sqlline.Commands.execute(Commands.java:822)
        at sqlline.Commands.sql(Commands.java:732)
        at sqlline.SqlLine.dispatch(SqlLine.java:808)
        at sqlline.SqlLine.begin(SqlLine.java:681)
        at sqlline.SqlLine.start(SqlLine.java:398)
        at sqlline.SqlLine.main(SqlLine.java:292)
Caused by: java.lang.StackOverflowError
        at org.apache.phoenix.iterate.RoundRobinResultIterator$RoundRobinIterator.close(RoundRobinResultIterator.java:298)
        at org.apache.phoenix.iterate.RoundRobinResultIterator$RoundRobinIterator.close(RoundRobinResultIterator.java:298)
{code}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message