Hi, when I execute a query , there is an error shows below. Error while executing SQL "select t.hotel_id_m,t.live_dt, d.day_of_week,sum(rns) from tableT t join tableB d on t.live_dt = d.daY_no group by t.hotel_id_m,t.live_dt, d.day_of_week LIMIT 50000": <sub-thread for Query 553d8027-b97f-4e86-9aad-47bb0053b6ee GTScanRequest 1c96c729>The coprocessor thread stopped itself due to scan timeout or scan threshold(check region server log), failing current query..
I try to set kylin.query.coprocessor.mem.gb, kylin.query.mem.budget as bigger as it can be. but it did not work. If I set a small LIMIT number like 20000 ,it work well. Coulld you tell me what I can do if I want to using limit 50000 or Is there any other way to let me get final result. Best regards, [email protected]
