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