Uploaded image for project: 'Calcite'
  1. Calcite
  2. CALCITE-4864 Supports Polymorphic Table function
  3. CALCITE-4867

Updates DDL to support create a polymorphic table function

Log workAgile BoardRank to TopRank to BottomAttach filesAttach ScreenshotBulk Copy AttachmentsBulk Move AttachmentsAdd voteVotersWatch issueWatchersConvert to IssueLinkCloneLabelsUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

Details

    • Sub-task
    • Status: Open
    • Major
    • Resolution: Unresolved
    • None
    • None
    • server
    • None

    Description

      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:
        CREATE FUNCTION TopNplus (    
            Input TABLE NO PASS THROUGH WITH SET SEMANTICS PRUNE WHEN EMPTY,    
            Howmany INTEGER  
        ) RETURNS TABLE
        NOT DETERMINISTIC 
        READS SQL DATA
        

      Attachments

        Activity

          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          People

            Unassigned Unassigned Assign to me
            jingzhang Jing Zhang

            Dates

              Created:
              Updated:

              Slack

                Issue deployment