Details
-
Improvement
-
Status: Open
-
Minor
-
Resolution: Unresolved
-
Impala 2.10.0
-
None
-
None
-
ghx-label-6
Description
[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
This is valid SQL so it would be good to allow it.