[jira] [Comment Edited] (FLINK-4565) Support for SQL IN operator

["Timo Walther (JIRA)" <ji...@apache.org>]

    [ 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)