Baahu, We're having a difficult time reproducing the StackOverflowError you encountered over on PHOENIX-2074. Do you think you could help us reproduce it? Maybe you can upload a test case and/or a CSV file with some sample data that reproduces it? Thanks, James
On Tue, Jun 23, 2015 at 12:24 AM, Bahubali Jain <[email protected]> wrote: > Hi Maryann, > > 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 ; > > Thanks, > Baahu > > On Tue, Jun 23, 2015 at 7:43 AM, Maryann Xue <[email protected]> > wrote: > >> Hi Bahubali, >> >> Could you please share your query? >> >> >> Thanks, >> Maryann >> >> On Mon, Jun 22, 2015 at 12:51 PM, Bahubali Jain <[email protected]> >> wrote: >> >>> Hi, >>> I am running into below error when I execute a query which has a >>> join,group by and order by. >>> But when I run the same query with hint /*+ USE_SORT_MERGE_JOIN*/ , it >>> runs well. >>> Can anybody please shed some light on this. >>> >>> 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) >>> >>> >> > > > -- > Twitter:http://twitter.com/Baahu > >
