Uploaded image for project: 'Flink'
  1. Flink
  2. FLINK-7594 Add a SQL client
  3. FLINK-8863

Add user-defined function support in SQL Client

    XMLWordPrintableJSON

Details

    Description

      This issue is a subtask of part two "Full Embedded SQL Client" of the implementation plan mentioned in FLIP-24.

      It should be possible to declare user-defined functions in the SQL client. For now, we limit the registration to classes that implement ScalarFunction, TableFunction, AggregateFunction. Functions that are implemented in SQL are not part of this issue.

      I would suggest to introduce a functions top-level property. The declaration could look similar to:

       
      functions: 
        - name: testFunction 
          from: class <-- optional, default: class 
          class: org.my.MyScalarFunction 
          constructor: <-- optional, needed for certain types of functions 
            - 42.0 
            - class: org.my.Class <-- possibility to create objects via properties 
              constructor: 
                - 1 
                - true 
                - false 
                - "whatever" 
                - type: INT 
                  value: 1 
      

      Attachments

        Issue Links

          Activity

            People

              xccui Xingcan Cui
              twalthr Timo Walther
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: