[MCOL-645] MariaDB WF Add DISTINCT to Window Functions SUM, AVG, COUNT Created: 2017-03-28  Updated: 2022-11-05  Resolved: 2022-11-05

Status: Closed
Project: MariaDB ColumnStore
Component/s: MariaDB Server
Affects Version/s: 1.1.0
Fix Version/s: Icebox

Type: New Feature Priority: Major
Reporter: David Hall (Inactive) Assignee: Todd Stoffel (Inactive)
Resolution: Won't Do Votes: 2
Labels: Compatibility

Issue Links:
Blocks
is blocked by MDEV-9525 Window functions: Support for aggrega... Open
Epic Link: ColumnStore Compatibility Improvements

 Description   

The Columnstore engine supports the DISTINCT keyword for Window Functions SUM, AVG, and COUNT. The MariaDB 10.2 front end does not.



 Comments   
Comment by Dipti Joshi (Inactive) [ 2017-04-19 ]

David.HallPlease provide example of this syntax

Comment by David Hall (Inactive) [ 2017-04-19 ]

Examples:
SELECT COUNT(DISTINCT salary) OVER (PARTITION BY depname ORDER BY salary), salary, empno, depname from empsalary where empno < 10000;

SELECT AVG(DISTINCT salary) OVER (PARTITION BY depname), salary, empno, depname from empsalary where empno < 10000;

SELECT SUM(DISTINCT salary) OVER (PARTITION BY depname), salary, empno, depname from empsalary where empno < 10000;

There were no tests that I could find for SUM(DISTINCT) in the InfiniDB test suite, so some need to be made.

Comment by David Hill (Inactive) [ 2019-09-24 ]

Customer is requesting this feature.. Any chance it will be put in a roadmap sooner that 1.6?

Comment by David Hill (Inactive) [ 2019-09-26 ]

From customer request this fix ASAP

In that case may we escalate the issue and request a support for this functionality to be added at least to 1.4? It is quite important feature for us.

Engineering informed me that this requires a code change in the Server side. Can we get this assigned to them or in the loop somehow?

Comment by Todd Stoffel (Inactive) [ 2022-11-05 ]

This item is being closed because it was well passed the expiration date with no activity. If you suspect this was done in error please create a new ticket.

Generated at Thu Feb 08 02:22:38 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.