[ https://issues.apache.org/jira/browse/FLINK-4542?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16517283#comment-16517283 ]
Timo Walther commented on FLINK-4542: ------------------------------------- Hi [~Sergey Nuyanzin], I thought Calcite has support (at least parsing and validation) for the operations mentioned in the issue, because they are listed in {{org.apache.calcite.sql.fun.SqlStdOperatorTable}}. The multiset type is supported in Flink SQL (this as been introduced as part of FLINK-7491). However, creating literals using {{SELECT MULTISET(...)}} is not. For this we need to implement the value constructor call {{SqlStdOperatorTable.MULTISET_VALUE}}. I hope Calcite is releasing 1.17 soon that we are not blocked on this. Feel free to split this issue in multiple subtasks and open PRs for functions that we can already support and functions that are blocked. > Add MULTISET operations > ----------------------- > > Key: FLINK-4542 > URL: https://issues.apache.org/jira/browse/FLINK-4542 > Project: Flink > Issue Type: Improvement > Components: Table API & SQL > Reporter: Timo Walther > Assignee: Sergey Nuyanzin > Priority: Minor > > Umbrella issue for MULTISET operations like: > MULTISET UNION, MULTISET UNION ALL, MULTISET EXCEPT, MULTISET EXCEPT ALL, > MULTISET INTERSECT, MULTISET INTERSECT ALL, CARDINALITY, ELEMENT, MEMBER OF, > SUBMULTISET OF, IS A SET, FUSION > At the moment we only support COLLECT. -- This message was sent by Atlassian JIRA (v7.6.3#76005)