Query with join hangs on ignite thick client

[harinath <ha...@gmail.com>]

Hi,

I have a below query to run using joins

SELECT income_summarytest.workclass, income_summarytest.education,
income_summarytest.marital_status, income_summarytest.occupation,
income_summarytest.race, income_summarytest.gender,
income_summarytest.capital_gain, income_summarytest.capital_loss,
income_summarytest.age, income_summarytest.native_country,
income_summarytest.income FROM income_summarytest JOIN (SELECT
max(hours_per_week) AS max_hours FROM income_summarytest) ON
income_summarytest.hours_per_week = max_hours ORDER BY income_summarytest.id
OFFSET 0 FETCH NEXT 500 ROWS ONLY

When i try to run the query using thin client, everything looks fine and
results are obtained as expected. However, when i try to run the same query
using thick client it hangs.

Is there anything that is missing? Or is there any workaround to achieve
this?


Thanks,
Harinath



--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: Query with join hangs on ignite thick client

[Ilya Kasnacheev <il...@gmail.com>]

Hello!

Are you sure that your thick client has enough memory for reduce phase? It
may boil down to the fact that servers have more RAM doing join/aggregation.

Can you collect heap/thread dumps during the hanging and check it to see
what happens?

Regards,
-- 
Ilya Kasnacheev


ср, 5 мая 2021 г. в 20:20, harinath <ha...@gmail.com>:

> Hi,
>
> I have a below query to run using joins
>
> SELECT income_summarytest.workclass, income_summarytest.education,
> income_summarytest.marital_status, income_summarytest.occupation,
> income_summarytest.race, income_summarytest.gender,
> income_summarytest.capital_gain, income_summarytest.capital_loss,
> income_summarytest.age, income_summarytest.native_country,
> income_summarytest.income FROM income_summarytest JOIN (SELECT
> max(hours_per_week) AS max_hours FROM income_summarytest) ON
> income_summarytest.hours_per_week = max_hours ORDER BY
> income_summarytest.id
> OFFSET 0 FETCH NEXT 500 ROWS ONLY
>
> When i try to run the query using thin client, everything looks fine and
> results are obtained as expected. However, when i try to run the same query
> using thick client it hangs.
>
> Is there anything that is missing? Or is there any workaround to achieve
> this?
>
>
> Thanks,
> Harinath
>
>
>
> --
> Sent from: http://apache-ignite-users.70518.x6.nabble.com/
>