You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@flink.apache.org by "Ingo Bürk (Jira)" <ji...@apache.org> on 2021/10/27 06:55:00 UTC

[jira] [Created] (FLINK-24664) Support merge for JSON_ARRAYAGG

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)