Support Questions
Find answers, ask questions, and share your expertise

SQL Issue

New Contributor

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

1 REPLY 1

Expert Contributor

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

; ;