[jira] [Created] (CALCITE-4867) Updates DDL to support create a polymorphic table function

["JING ZHANG (Jira)" <ji...@apache.org>]

JING ZHANG created CALCITE-4867:
-----------------------------------

             Summary: Updates DDL to support create a polymorphic table function 
                 Key: CALCITE-4867
                 URL: https://issues.apache.org/jira/browse/CALCITE-4867
             Project: Calcite
          Issue Type: Sub-task
          Components: server
            Reporter: JING ZHANG


After deciding on the parameter list, the PTF author is ready to write the first skeleton CREATE FUNCTION statement. At this stage we have an incomplete CREATE FUNCTION because it only lists the input parameters (there is more DDL to come later). The parameters are declared with the following types:
 * —  Input tables have parameter type TABLE.

 * —  Input scalars have their usual parameter types (VARCHAR, INTEGER, etc.).

 * —  Input PTF descriptor areas have parameter type DESCRIPTOR. Thus, at this stage, the function declaration looks something like this:
{code:java}
CREATE FUNCTION TopNplus (    
    Input TABLE NO PASS THROUGH WITH SET SEMANTICS PRUNE WHEN EMPTY,    
    Howmany INTEGER  
) RETURNS TABLE
NOT DETERMINISTIC 
READS SQL DATA
{code}



--
This message was sent by Atlassian Jira
(v8.3.4#803005)