Thank you for your assessment, which is spot-on. I think that the adjustments to MEMORY_LIMIT plus previously setting the idle session and query limits to 10m helped with the prior OOM problem, especially when multiple users are active. We are relatively new to Hadoop/Impala and so we are still learning a lot about how to configure and work with the data within the environment, in tuning the performance, and tailoring the configuration to work well within the limits of the available hardware. In general, I wish there were documentation that specifically address errors and performance tuning. It would provide more insights into troubleshooting problems and interpreting the errors received. Maybe there is a book already published that's good for this? It would be a huge help!
... View more
