[jira] [Created] (IMPALA-5822) Support combining * in select list with grouping or aggregation

["Tim Armstrong (JIRA)" <ji...@apache.org>]

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)