Memory exceed limit Hash join while getting next from the child 1 Backend 192168200249 fragment ac910b0e132944d4-8a7159971cd9f3a5 Used 2147520512 Limit 2147483648 You can change the limit by session v

This error message indicates that the memory used by a hash join operation has exceeded the limit. The backend server with IP address 192.168.200.249 is processing a fragment with ID ac910b0e132944d4-8a7159971cd9f3a5. The amount of memory used is 2147520512, which is greater than the limit of 2147483648.

To address this issue, you can try increasing the memory limit by setting the session variable exec_mem_limit to a higher value. This can be done using a query like:

SET exec_mem_limit = <new_limit>;

Replace <new_limit> with the desired memory limit in bytes.

Note that increasing the memory limit may have performance implications and could potentially lead to further memory-related issues. It's recommended to analyze the query and optimize it if possible to reduce memory usage instead of relying solely on increasing the memory limit