[
https://issues.apache.org/jira/browse/FLINK-4565?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15467059#comment-15467059
]
Timo Walther edited comment on FLINK-4565 at 9/6/16 10:22 AM:
--------------------------------------------------------------
Hi [~chobeat], yes I think this issue is good for a beginner. Flink SQL already
supports things like "SELECT x FROM myTable WHERE x IN (SELECT y FROM
myOtherTable)". Nonetheless, we should add tests for it. The question is if we
could make this functionality also available to the Table API. The Table API
has Expressions (expressionDsl.scala for Scala and ExpressionParser for Java)
and LogicalNodes (operators.scala). This issue would combine both.
{{expr.in(table)}}
was (Author: twalthr):
Hi [~chobeat], yes I think this issue is good for a beginner. Flink SQL already
supports things like "SELECT x FROM myTable WHERE x IN (SELECT y FROM
myOtherTable)". Nonetheless, we should add tests for it. The question is if we
could make this functionality also available to the Table API. The Table API
has Expressions (expressionDsl.scala for Scala and ExpressionParser for Java)
and LogicalNodes (operators.scala). This type would combine both.
{{expr.in(table)}}
> Support for SQL IN operator
> ---------------------------
>
> Key: FLINK-4565
> URL: https://issues.apache.org/jira/browse/FLINK-4565
> Project: Flink
> Issue Type: Improvement
> Components: Table API & SQL
> Reporter: Timo Walther
>
> It seems that Flink SQL supports the uncorrelated sub-query IN operator. But
> it should also be available in the Table API and tested.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
