[HIVE-17345] Invalid error message for absent function

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 1.2.1
• Component/s: Diagnosability, Hive, Parser, Query Planning, UDF

Environment

hive --version
Hive 1.2.1000.2.6.1.0-129
Subversion git://c66-slave-38a0b1a6-3/grid/0/jenkins/workspace/HDP-parallel-centos6/SOURCES/hive -r 4c6995c87f30906625e01c28e5e111a53c2e582f
Compiled by jenkins on Wed May 31 03:19:31 UTC 2017
From source with checksum e3ee749ba0a797bb10a7e12265daa82d

• Assignee: Unassigned
• Reporter: Alexey Bedrintsev
• Created: 17/Aug/17 11:43
• Updated: 17/Aug/17 11:43

Description

For test purposes let have any table, e.g. like this one with two columns:

create table test (x int, y int);
insert into test values (0, 0), (1, 0), (2, 0), (0, 1), (1, 1), (1, 2);

If we try to query using not existent aggregate function QQQ, then get descriptive error message:

SELECT QQQ(y)
FROM test;

FAILED: SemanticException [Error 10011]: Line 1:7 Invalid function 'QQQ'

But if I use this function with group by clause, I get confusing message about wrong query structure:

SELECT x,
       QQQ(y)
FROM test
GROUP BY x;

FAILED: SemanticException [Error 10025]: Line 1:10 Expression not in GROUP BY key 'y'

For queries with having clauses error message is more confusing. It is regarding to zero value which is absolutely correct:

SELECT x,
       QQQ(y) AS q
FROM test
GROUP BY x HAVING q > 0;

FAILED: SemanticException [Error 10025]: Line 4:7 Expression not in GROUP BY key '0'

Expected result: the same error message

 "FAILED: SemanticException [Error 10011]: Line 1:7 Invalid function 'QQQ'"

for all listed queries.