SQL Issue

[#1]

Error processing query/statement : Error Code:0,cannot perform hash join at node with id 5,Repartioning did not reduce the size of a spilled partition

[#2]

Hi @jagad ,

I think you are facing the above error for an impala query am i right? If Yes please increase the memory limit for that query using set MEM_LIMIT=xg; parameter and try to rerun the query. This usually occurs if there is not enough memory for a query.

Regards,

Chethan YM