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
