flink-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "ASF GitHub Bot (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (FLINK-4565) Support for SQL IN operator
Date Mon, 06 Mar 2017 09:54:33 GMT

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

Mime
View raw message