This article explains one of the possible reasons that caused Impala query to fail with Out of Memory Exception. The following is the profile from failed query: This query was big, and used more than 60GB of memory, in theory with GROUP BY, Impala should trigger disk spilling when it …
If you get the following error when running Impala query through Impala JDBC Driver: it is caused by Impala Driver tried to transform queries that were already in the Impala native form, and caused syntax error. The solution here is to add UseNativeQuery=1 in the JDBC query string parameter, for …
This article explains how to fix the posix_fallocate error from Impala Daemon log when running an impala query. The following were what happened: 1) Impala query with GROUP BY clause failed 2) Check the profile to find out the host of the coordinator 3) Found the following in the coordinator …
Steps to re-produce the issue: 1) Create a Hive table using following command: 2) Load data into the table: 3) Get the output of table definition: and we get the following output: 4) Use the output from step 3. to create a new table: 5) Manually copy data from table …
This articles explains one of the possibilities that could have caused catalogd to crash constantly. The following are the symptoms when this issue happens: Impala Catalog server keeps crashing after restarting of Catalog server, query back to normal when impala is under heavy load, catalog server will crash again One …
My new Snowflake Blog is now live. I will not be updating this blog anymore but will continue with new contents in the Snowflake world!