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)

Reply via email to