You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@calcite.apache.org by "Danny Chen (Jira)" <ji...@apache.org> on 2020/10/14 10:14:00 UTC

[jira] [Created] (CALCITE-4337) Supports PARTITION BY clause for table function table argument

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)