Danny Chen created CALCITE-4337:
-----------------------------------
Summary: Supports PARTITION BY clause for table function table
argument
Key: CALCITE-4337
URL: https://issues.apache.org/jira/browse/CALCITE-4337
Project: Calcite
Issue Type: New Feature
Components: core
Affects Versions: 1.26.0
Reporter: Danny Chen
Assignee: Danny Chen
Fix For: 1.27.0
An example from the SQL standard 2016 Polymorphic Table Functions:
{code:sql}
SELECT W.wstart, W.wend, OI.customer, SUM(OI.price)
FROM TABLE(SESSION(
data => TABLE(order_item) AS OI PARTITION BY customer,
timecol => DESCRIPTOR(order_time),
timeout => INTERVAL '10' MINUTE)) W
GROUP BY 1, 2, 3
{code}
--
This message was sent by Atlassian Jira
(v8.3.4#803005)