[HIVE-14959] Fix DISTINCT with windowing when CBO is enabled/disabled

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 2.1.0
• Fix Version/s: 2.1.1, 2.2.0
• Target Version/s: 2.1.1, 2.2.0
• Assignee: Jesús Camacho Rodríguez
• Reporter: Jesús Camacho Rodríguez
• Created: 14/Oct/16 07:13
• Updated: 27/Feb/24 22:23
• Resolved: 17/Oct/16 19:41

Description

For instance, the following query with CBO off:

select distinct last_value(i) over ( partition by si order by i ),
  first_value(t)  over ( partition by si order by i )
from over10k limit 50;

will fail, with the following message:

SELECT DISTINCT not allowed in the presence of windowing functions when CBO is off

Issue Links

• relates to: HIVE-13242 DISTINCT keyword is dropped by the parser for windowing
• links to: RB link