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)