0 votes
Hello,

Could you provide some examples of custom aggregations involving an array or a map?

Thank you
by

1 Answer

0 votes

Here is an example using Postgres

 

For a complete reference see https://www.postgresql.org/docs/9.5/static/functions-aggregate.html or the reference of the database you use.

by
Hey thanks for the answer, that helped me. However, I can't seem to use any of PG aggregate functions except group_concat:

https://pasteboard.co/GAjh6rZ.png

Is it normal ?
You are probably using MySQL, in that case the answer is yes.
See this SO question:
https://stackoverflow.com/questions/39030090/mysql-array-aggregate-function-like-postgresql-array-agg
I'm actually using PostgreSQL 9.6.3 :/
Do you have any idea why I can't access PostgreSQL aggregate functions from that dashboard? Thx
Ok my bad, the output database was PG but the input was filebased... Works like a charm thanks
1,195 questions
1,226 answers
1,380 comments
11,754 users

┬ęDataiku 2012-2018 - Privacy Policy