Coming soon: We’re working on a brand new, revamped Community experience. Want to receive updates? Sign up now!

0 votes

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

Thank you

1 Answer

0 votes

Here is an example using Postgres


For a complete reference see or the reference of the database you use.

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

Is it normal ?
You are probably using MySQL, in that case the answer is yes.
See this SO question:
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,337 questions
1,362 answers
11,912 users

©Dataiku 2012-2018 - Privacy Policy