The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Hello Everyone,
I have a report which is connected to Impala using an ODBC connection. The data set is also huge.
While refreshing the preview on Power Query I get the below error
Could someone kindly guide me how to resolve this please..
Thank you in advance.
Swathi
Hi @Anonymous ,
The “Memory limit exceeded” error in Impala usually indicates that the SQL query you’re running is consuming a large amount of memory to process the data. This could be due to the size of the dataset being processed or the complexity of the query itself.
You can increase the memory limit of the Impala daemon. If you’re not the administrator, you might want to check with them to see if they can allocate more memory to your user.
hadoop - Memory limit exceeded - Apache Impala
Solved: Impala - Memory limit exceeded - Cloudera Community - 80407
Solved: Backend 6:Memory Limit Exceeded" in impala 2
If possible, try to optimize your query. This could involve reducing the amount of data being processed, using filters to limit the data, or breaking the query into smaller parts
hadoop - Cloudera Apache impala query: Memory limit exceeded
Best Regards,
Gao
Community Support Team
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data in the Power BI Forum -- China Power BI User Group