Ingo Bürk created FLINK-24664:
---------------------------------
Summary: Support merge for JSON_ARRAYAGG
Key: FLINK-24664
URL: https://issues.apache.org/jira/browse/FLINK-24664
Project: Flink
Issue Type: Sub-task
Components: Table SQL / API
Reporter: Ingo Bürk
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.3.4#803005)
