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)
