Tim Armstrong created IMPALA-5822:
-------------------------------------
Summary: Support combining * in select list with grouping or
aggregation
Key: IMPALA-5822
URL: https://issues.apache.org/jira/browse/IMPALA-5822
Project: IMPALA
Issue Type: Improvement
Components: Frontend
Affects Versions: Impala 2.10.0
Reporter: Tim Armstrong
Priority: Minor
{code}
[hostname:21000] > explain select * from (select deptno, avg(sal) over
(partition by deptno) as avg_dept_sal from emp) t group by 1,2;
ERROR: AnalysisException: cannot combine '*' in select list with grouping or
aggregation
{code}
This is valid SQL so it would be good to allow it.
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
