Impala query failed with error “IllegalStateException”

This article examples ONE of the possible causes for the issue that Impala query failed with IllegalStateException error. Recently I was dealing with an Impala issue that when runnnig a simple SELECT query against a table failed with IllegalStateException error: SELECT * FROM <table_name>; Query: SELECT * FROM <table_name> ERROR: IllegalStateException: …

How to confirm Dynamic Partition Pruning works in Impala

This article explains how to confirm Impala’s new Dynamic Partition Pruning feature is effective in CDH5.7.x. Dynamic Partition Pruning is a new feature introduced from CDH5.7.x / Impala 2.5, where information about the partition is collected during run time and impala prunes unnecessary partitions in the ways that were impractical …

Impala query failed with error “IllegalArgumentException: Value cannot be empty”

This article explains what to do to fix the issue that when running “SHOW DATABASES” or other simply Impala queries, Impala complains “ERROR: IllegalArgumentException: Value cannot be empty”. The full stack trace showing in the Impala Daemon log as follows: I0620 10:46:08.436385 47131 Frontend.java:818] analyze query show databases I0620 10:46:08.437651 …

Impala nested inline view produces incorrect result when referencing the same column implicitly

This article explains how to workaround the impala bug: IMPALA-2643. To see what the issue is, have a look at the test case below: CREATE TABLE t (a int); INSERT INTO TABLE t VALUES(NULL), (1); SELECT COUNT(*) FROM t; Query: SELECT COUNT(*) FROM t +———-+ | COUNT(*) | +———-+ | …

Impala query memory estimates are wrong for a SELECT query with LIMIT clause

This article explains the workarounds to by pass the Impala memory estimation issue when doing a simple “SELECT * FROM table LIMIT 10” query. A request memory estimate error is being thrown if the Impala query has ‘LIMIT’ clause. SELECT * FROM rating LIMIT 1; ERROR: Rejected query from pool …