Ksql: Need SQL Average (AVG) Aggregation Function

[tomlinsonr]

Trying to figure out average of X within a given window for a BI visualization. KSQL supports MAX, MIN, .... but why not AVG?

Super common BI use case.

[rodesai]

Until an AVG is implemented you can use SUM and COUNT e.g. SELECT x, SUM(y) / COUNT(*) FROM foo GROUP BY x;

[tomlinsonr]

Thanks @rodesai, so this is on the roadmap?

[rodesai]

A richer set of built-in functions is in the works, though no concrete date for that yet.

[miguno]

Contributions are welcome, @tomlinsonr :)

[lssilva]

A richer set of built-in functions is in the works, though no concrete date for that yet.

That would be great. Looking forward!!

[holgerbrandl]

Is there a more specific date for the richer set of built-in functions @rodesai ?

Or is there maybe a third-party repo with custom UDFs that includes AVG and other functions to make SQL even more fun (such as LAST, FIRST, LAG, etc)?

[agavra]

@holgerbrandl - take a look at #3302! The next release should have average and the ability to build more complicated custom UDFs thanks to @vpapavas