You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@flink.apache.org by "Yun Gao (Jira)" <ji...@apache.org> on 2022/04/13 06:28:06 UTC

[jira] [Updated] (FLINK-20788) It doesn't support to use cube/rollup/grouping sets in the Table API

     [ https://issues.apache.org/jira/browse/FLINK-20788?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Yun Gao updated FLINK-20788:
----------------------------
    Fix Version/s: 1.16.0

> It doesn't support to use cube/rollup/grouping sets in the Table API
> --------------------------------------------------------------------
>
>                 Key: FLINK-20788
>                 URL: https://issues.apache.org/jira/browse/FLINK-20788
>             Project: Flink
>          Issue Type: Sub-task
>          Components: Table SQL / API
>            Reporter: Dian Fu
>            Priority: Major
>             Fix For: 1.15.0, 1.16.0
>
>
> Currently, it doesn't support to use cube/rollup/grouping sets in the Table API. For the following job:
> {code}
> table.groupBy("cube(a, b)")
> {code}
> It will throw the following exception:
> {code}
> org.apache.flink.table.api.ValidationException: Undefined function: cube
> 	at org.apache.flink.table.expressions.resolver.LookupCallResolver.lambda$visit$0(LookupCallResolver.java:49)
> 	at java.util.Optional.orElseThrow(Optional.java:290)
> 	at org.apache.flink.table.expressions.resolver.LookupCallResolver.visit(LookupCallResolver.java:49)
> 	at org.apache.flink.table.expressions.resolver.LookupCallResolver.visit(LookupCallResolver.java:38)
> 	at org.apache.flink.table.expressions.ApiExpressionVisitor.visit(ApiExpressionVisitor.java:37)
> 	at org.apache.flink.table.expressions.LookupCallExpression.accept(LookupCallExpression.java:65)
> 	at org.apache.flink.table.expressions.resolver.rules.LookupCallByNameRule.lambda$apply$0(LookupCallByNameRule.java:38)
> 	at java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:193)
> 	at java.util.ArrayList$ArrayListSpliterator.forEachRemaining(ArrayList.java:1374)
> 	at java.util.stream.AbstractPipeline.copyInto(AbstractPipeline.java:481)
> 	at java.util.stream.AbstractPipeline.wrapAndCopyInto(AbstractPipeline.java:471)
> 	at java.util.stream.ReduceOps$ReduceOp.evaluateSequential(ReduceOps.java:708)
> 	at java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:234)
> 	at java.util.stream.ReferencePipeline.collect(ReferencePipeline.java:499)
> 	at org.apache.flink.table.expressions.resolver.rules.LookupCallByNameRule.apply(LookupCallByNameRule.java:38)
> 	at org.apache.flink.table.expressions.resolver.ExpressionResolver.lambda$null$1(ExpressionResolver.java:211)
> 	at java.util.function.Function.lambda$andThen$1(Function.java:88)
> 	at java.util.function.Function.lambda$andThen$1(Function.java:88)
> 	at java.util.function.Function.lambda$andThen$1(Function.java:88)
> 	at java.util.function.Function.lambda$andThen$1(Function.java:88)
> 	at java.util.function.Function.lambda$andThen$1(Function.java:88)
> 	at java.util.function.Function.lambda$andThen$1(Function.java:88)
> 	at java.util.function.Function.lambda$andThen$1(Function.java:88)
> 	at org.apache.flink.table.expressions.resolver.ExpressionResolver.resolve(ExpressionResolver.java:178)
> 	at org.apache.flink.table.operations.utils.OperationTreeBuilder.aggregate(OperationTreeBuilder.java:236)
> 	at org.apache.flink.table.api.internal.TableImpl$GroupedTableImpl.select(TableImpl.java:632)
> 	at org.apache.flink.table.api.internal.TableImpl$GroupedTableImpl.select(TableImpl.java:615)
> {code}



--
This message was sent by Atlassian Jira
(v8.20.1#820001)