[
https://issues.apache.org/jira/browse/FLINK-5441?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15821880#comment-15821880
]
ASF GitHub Bot commented on FLINK-5441:
---------------------------------------
Github user wuchong commented on the issue:
https://github.com/apache/flink/pull/3107
Hi @KurtYoung , thank your for reviewing. I'm not sure about that. Do you
mean omitting the "FROM" syntax ? But it will be hard to validate SQL syntax.
Because the query can follow a WHERE clause or JOIN/UNION with other tables.
For example, it's wired and hard to validate the query like this:
```
mytable.sql("SELECT * WHERE a > 13 UNION SELECT * FROM TABLE_B")
```
I think allowing query on other tables is fine here. What do you think ?
> Directly allow SQL queries on a Table
> -------------------------------------
>
> Key: FLINK-5441
> URL: https://issues.apache.org/jira/browse/FLINK-5441
> Project: Flink
> Issue Type: New Feature
> Components: Table API & SQL
> Reporter: Timo Walther
> Assignee: Jark Wu
>
> Right now a user has to register a table before it can be used in SQL
> queries. In order to allow more fluent programming we propose calling SQL
> directly on a table. An underscore can be used to reference the current table:
> {code}
> myTable.sql("SELECT a, b, c FROM _ WHERE d = 12")
> {code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
