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/