Re: StackOverflowError

[James Taylor <ja...@apache.org>]

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 <ba...@gmail.com> 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 <ma...@gmail.com>
> wrote:
>
>> Hi Bahubali,
>>
>> Could you please share your query?
>>
>>
>> Thanks,
>> Maryann
>>
>> On Mon, Jun 22, 2015 at 12:51 PM, Bahubali Jain <ba...@gmail.com>
>> 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
>
>