[
https://issues.apache.org/jira/browse/FLINK-9617?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Flink Jira Bot updated FLINK-9617:
----------------------------------
Labels: auto-unassigned stale-major (was: auto-unassigned)
I am the [Flink Jira Bot|https://github.com/apache/flink-jira-bot/] and I help
the community manage its development. I see this issues has been marked as
Major but is unassigned and neither itself nor its Sub-Tasks have been updated
for 30 days. I have gone ahead and added a "stale-major" to the issue". If this
ticket is a Major, please either assign yourself or give an update. Afterwards,
please remove the label or in 7 days the issue will be deprioritized.
> Provide alias for whole records in Table API
> --------------------------------------------
>
> Key: FLINK-9617
> URL: https://issues.apache.org/jira/browse/FLINK-9617
> Project: Flink
> Issue Type: Improvement
> Components: Table SQL / API
> Affects Versions: 1.5.0
> Reporter: Piotr Nowojski
> Priority: Major
> Labels: auto-unassigned, stale-major
>
> In SQL we can provide an alias for whole table to avoid column name
> collisions between two tables. For example:
> {code:java}
> SELECT
> SUM(o.amount * r.rate)
> FROM
> Orders AS o,
> Rates AS r
> WHERE r.currency = o.currency{code}
> However that's not possible in table API. In Table API user have to provide
> aliases for all of the columns, which can be annoying especially if table
> consists of tens or even hundred of columns
> For example I would expect some feature like this:
> {code:java}
> val result = orders.as('o)
> .join(rates(`o.rowtime).as('r), "o.currency = r.currency")
> .select("SUM(o.amount * r.rate) AS amount")
> {code}
> where \{{rates}} is a TableFunction.
>
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
