[ https://issues.apache.org/jira/browse/FLINK-4565?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15897002#comment-15897002 ]
ASF GitHub Bot commented on FLINK-4565: --------------------------------------- Github user twalthr commented on a diff in the pull request: https://github.com/apache/flink/pull/2870#discussion_r104377221 --- Diff: flink-libraries/flink-table/src/main/scala/org/apache/flink/api/table/table.scala --- @@ -150,7 +150,35 @@ class Table( * }}} */ def filter(predicate: Expression): Table = { - new Table(tableEnv, Filter(predicate, logicalPlan).validate(tableEnv)) + + predicate match { --- End diff -- As far as I know `IN` is a general expression, so it can be used where ever expressions are allowed. I quickly checked it in MySQL and `SELECT field1 IN ( 22, 23 ) FROM Table1` is not a problem. > 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 > Assignee: Dmytro Shkvyra > > 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.15#6346)