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 <harinathmadd...@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/ >
