Friday, February 02, 2018

MariaDB ColumnStore Distributed User-Defined Aggregate Functions

DZone Database Zone
MariaDB ColumnStore Distributed User-Defined Aggregate Functions
MariaDB ColumnStore Distributed User-Defined Aggregate Functions

MariaDB ColumnStore 1.1 introduces the distributed user-defined aggregate functions (UDAF) C++ API. MariaDB Server has supported UDAF (a C API) for a while, but now, we have extended it to the ColumnStore Engine. This new feature allows anyone to create aggregate functions of arbitrary complexity for distributed execution in the ColumnStore Engine. These functions can also be used as Analytic (Window) functions just like any built-in aggregate. You should have a working understanding of C++ to use this API.

For use as analytic functions, all calls are on the UM.

No comments:

Fun With SQL: Functions in Postgres

DZone Database Zone Fun With SQL: Functions in Postgres In our previous  Fun with SQL  post on the  Citus Data  blog, we covered w...