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

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

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

Shang Yuanchun (Jira)
Dian Fu created FLINK-20788:
-------------------------------

             Summary: 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
             Fix For: 1.13.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.3.4#803005)