[jira] [Created] (HIVE-21394) Do not use PTF in case of select distinct having all the non aggregate column in over

["Miklos Gergely (JIRA)" <ji...@apache.org>]

Miklos Gergely created HIVE-21394:
-------------------------------------

             Summary: Do not use PTF in case of select distinct having all the non aggregate column in over
                 Key: HIVE-21394
                 URL: https://issues.apache.org/jira/browse/HIVE-21394
             Project: Hive
          Issue Type: Improvement
            Reporter: Miklos Gergely


Having a select distinct query where all the non aggregate columns are enumerated in the over clause makes the over clause unnecessary. Yet the CalciltePlanner leaves it in the query after optimization.

So for example in the query

SELECT DISTINCT count(x) OVER () FROM t

the over clause is meaningless. Still it remains there after Calcite optimization.

 



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)