[
https://issues.apache.org/jira/browse/FLINK-4565?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16116471#comment-16116471
]
ASF GitHub Bot commented on FLINK-4565:
---------------------------------------
Github user twalthr commented on a diff in the pull request:
https://github.com/apache/flink/pull/4404#discussion_r131633926
--- Diff: docs/dev/table/sql.md ---
@@ -497,6 +497,23 @@ FROM (
{% endhighlight %}
</td>
</tr>
+
+ <tr>
+ <td>
+ <strong>In</strong><br>
+ <span class="label label-primary">Batch</span>
+ </td>
+ <td>
+ Returns true if an expression exists in a given table sub-query. The
sub-query table must consist of one column. This column must have the same data
type as the expression.
--- End diff --
What do you mean with "enhanced"? We cannot change the SQL standard. The
user can nest another query and reduce the table to one column.
> 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: Timo Walther
> Fix For: 1.4.0
>
>
> 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.4.14#64029)
