[
https://issues.apache.org/jira/browse/FLINK-13218?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16883619#comment-16883619
]
Jing Zhang edited comment on FLINK-13218 at 7/12/19 8:29 AM:
-------------------------------------------------------------
[~twalthr] Hi, Timo, I want to express a TableApi query which is equals to the
following sql query:
{code:java}
SELECT COUNT(*) FROM T
{code}
was (Author: jinyu.zj):
[~twalthr] Hi, Timo, I want to express a TableApi query which is equals to the
following sql query:
SELECT COUNT(*) FROM T
> '*.count not supported in TableApi query
> ----------------------------------------
>
> Key: FLINK-13218
> URL: https://issues.apache.org/jira/browse/FLINK-13218
> Project: Flink
> Issue Type: Task
> Components: Table SQL / Planner
> Reporter: Jing Zhang
> Assignee: Jing Zhang
> Priority: Major
>
> The following query is not supported yet:
> {code:java}
> val t = StreamTestData.get3TupleDataStream(env).toTable(tEnv, 'a, 'b, 'c)
> .groupBy('b)
> .select('b, 'a.sum, '*.count)
> {code}
> The following exception will be thrown.
> {code:java}
> org.apache.flink.table.api.ValidationException: Cannot resolve field [*],
> input field list:[a, b, c].
> at
> org.apache.flink.table.expressions.resolver.rules.ReferenceResolverRule$ExpressionResolverVisitor.failForField(ReferenceResolverRule.java:80)
> at
> org.apache.flink.table.expressions.resolver.rules.ReferenceResolverRule$ExpressionResolverVisitor.lambda$null$4(ReferenceResolverRule.java:75)
> at java.util.Optional.orElseThrow(Optional.java:290)
> at
> org.apache.flink.table.expressions.resolver.rules.ReferenceResolverRule$ExpressionResolverVisitor.lambda$null$5(ReferenceResolverRule.java:75)
> at java.util.Optional.orElseGet(Optional.java:267)
> at
> org.apache.flink.table.expressions.resolver.rules.ReferenceResolverRule$ExpressionResolverVisitor.lambda$visit$6(ReferenceResolverRule.java:74)
> at java.util.Optional.orElseGet(Optional.java:267)
> at
> org.apache.flink.table.expressions.resolver.rules.ReferenceResolverRule$ExpressionResolverVisitor.visit(ReferenceResolverRule.java:71)
> at
> org.apache.flink.table.expressions.resolver.rules.ReferenceResolverRule$ExpressionResolverVisitor.visit(ReferenceResolverRule.java:51)
> at
> ...
> {code}
--
This message was sent by Atlassian JIRA
(v7.6.14#76016)