Without changing memory limit and without affecting query performance. Is there anyway to improve Impala memory issue?

I would like to know –

1. without affecting SQL query performance
2. without lowering the memory limit is there any way to improve the impala memory error issue?

I got a few suggestions like changing my join statements in my SQL queries