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)
