[
https://issues.apache.org/jira/browse/FLINK-4565?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15467059#comment-15467059
]
Timo Walther commented on FLINK-4565:
-------------------------------------
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)
