[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: |
|
||||||||
| 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 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. |