flink-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Timo Walther (JIRA)" <j...@apache.org>
Subject [jira] [Comment Edited] (FLINK-4565) Support for SQL IN operator
Date Tue, 06 Sep 2016 10:23:21 GMT

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

Mime
View raw message