[MCOL-624] MariaDB 10.2 WF create MEDIAN, PERCENTILE_CONT and PERCENTILE_DISC Window functions Created: 2017-03-14 Updated: 2022-11-05 Resolved: 2022-11-05 |
|
| Status: | Closed |
| Project: | MariaDB ColumnStore |
| Component/s: | N/A |
| Affects Version/s: | None |
| Fix Version/s: | Icebox |
| Type: | New Feature | Priority: | Major |
| Reporter: | David Hall (Inactive) | Assignee: | Todd Stoffel (Inactive) |
| Resolution: | Won't Do | Votes: | 3 |
| Labels: | 10.2, relnote | ||
| Issue Links: |
|
||||||||||||||||
| Description |
|
These are not implemented in MariaDB 10.2 but exist in columnstore 1.0 |
| Comments |
| Comment by David Hall (Inactive) [ 2017-03-15 ] |
|
MEDIAN is also not supported by MariaDB 10.2. MEDIAN is a short cut for PERCENTILE_CONT(0.5) |
| Comment by Dipti Joshi (Inactive) [ 2017-04-19 ] |
|
For definition of these three functions see For supported syntax of MariaDB ColumnStore window functions see https://mariadb.com/kb/en/mariadb/columnstore-window-functions/ |
| Comment by Ján Regeš [ 2017-11-30 ] |
|
Hi, will be these functions in MariaDB 10.3 and usable also for other engines like an InnoDB, MYISAM, ...? |
| Comment by Juan Telleria [ 2017-11-30 ] |
|
Could we see these (MEDIAN, PERCENTILE_CONT and PERCENTILE_DISC) also as aggregate functions (GROUP BY Functions)? Thank you, |
| Comment by David Hall (Inactive) [ 2017-11-30 ] |
|
When created, these will be Window and aggregate capable. MEDIAN is currently available for columnstore 1.2. It is not currently available for other engines. MEDIAN is not automatically included. You must run: CREATE AGGREGATE FUNCTION median returns REAL soname 'libudf_mysql.so'; from the mcsmysql prompt. |
| Comment by Todd Stoffel (Inactive) [ 2022-11-05 ] |
|
Item is out of date. Closing due to inactivity. If you feel this was done in error please open a new ticket. |