Paul Rogers created IMPALA-7785:
-----------------------------------
Summary: Analyzer cannot handle GROUP BY clause rewrites
Key: IMPALA-7785
URL: https://issues.apache.org/jira/browse/IMPALA-7785
Project: IMPALA
Issue Type: Bug
Components: Frontend
Affects Versions: Impala 3.0
Reporter: Paul Rogers
The FE analyzer has a stage that rewrites expressions to make them simpler. The
analyzer also has a stage that matches up {{GROUP BY}} expressions with
{{SELECT}} clause expressions. Apparently, the two don't work together:
{code:sql}
SELECT coalesce(string_col, 'foo')
FROM functional.alltypes
GROUP BY coalesce(string_col, 'foo')
{code}
The above is rewritten using the new conditional function rewrite rules. Result:
{noformat}
org.apache.impala.common.AnalysisException:
select list expression not produced by aggregation output
(missing from GROUP BY clause?):
CASE WHEN string_col IS NOT NULL THEN string_col ELSE 'foo' END
{noformat}
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-all-unsubscr...@impala.apache.org
For additional commands, e-mail: issues-all-h...@impala.apache.org
