[
https://issues.apache.org/jira/browse/FLINK-24664?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Martijn Visser updated FLINK-24664:
-----------------------------------
Parent: (was: FLINK-9477)
Issue Type: New Feature (was: Sub-task)
> Support merge for JSON_ARRAYAGG
> -------------------------------
>
> Key: FLINK-24664
> URL: https://issues.apache.org/jira/browse/FLINK-24664
> Project: Flink
> Issue Type: New Feature
> Components: Table SQL / API
> Reporter: Ingo Bürk
> Priority: Major
>
> For JSON_ARRAYAGG we currently do not support merge (required e.g. for hop
> windows) because arrays are order-sensitive, and we cannot ensure the correct
> order.
> There are a few ways we could solve this:
> * Making use of WITHIN GROUP syntax, which is supported by Calcite, but not
> yet for JSON_ARRAYAGG in the parser.
> * Allowing incorrect behavior, but clearly documenting this case. In this
> case we should at least try to find a way to have a deterministic order of
> the accumulators to be merged as to not make the result non-deterministic.
> * Try to actually solve this somehow such that behavior is correct.
--
This message was sent by Atlassian Jira
(v8.20.1#820001)
