[IMPALA-2225] Poor error message when group by missing on select t.*

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: Impala 2.2.4
• Fix Version/s: Impala 2.5.0, Impala 2.3.2
• Target Version: Impala 2.3.2
• Assignee: Chris Channing
• Reporter: Philip Martin
• Created: 19/Aug/15 03:16
• Updated: 23/Feb/16 04:36
• Resolved: 19/Oct/15 15:51

Description

The error message below (NullPointerException: null) leaves much to be desired. I've reproduced this on the Impala currently built from a153aabec4f0fd1911af219f8c221f01b609c82d and the Impala in CDH 5.4.x.

[nightly-2:21000] > select version(); create table t1 (a string); create table t2 (b string); select t1.*, max(b) from t1 join t2 on a=b;
Query: select version()
+----------------------------------------------------------------------------------------------+
| version()                                                                                    |
+----------------------------------------------------------------------------------------------+
| impalad version 2.3.0-cdh5-INTERNAL RELEASE (build a153aabec4f0fd1911af219f8c221f01b609c82d) |
| Built on Mon, 17 Aug 2015 21:18:38 PST                                                       |
+----------------------------------------------------------------------------------------------+
Fetched 1 row(s) in 0.18s
Query: create table t1 (a string)

Query: create table t2 (b string)

Query: select t1.*, max(b) from t1 join t2 on a=b
ERROR: AnalysisException: null
CAUSED BY: NullPointerException: null