Uploaded image for project: 'Apache Drill'
  1. Apache Drill
  2. DRILL-4258 Create New SYS tables: cpu, queries, fragments, threads, threadtraces, connections
  3. DRILL-3988

Create a sys.functions table to expose available Drill functions

    XMLWordPrintableJSON

Details

    • Sub-task
    • Status: Resolved
    • Major
    • Resolution: Fixed
    • None
    • 1.15.0
    • Metadata

    Description

      Create a new sys.functions table that returns a list of all available functions.

      Key considerations:

      • one row per name or one per argument set. I'm inclined to latter so people can use queries to get to data.
      • we need to create a delineation between user functions and internal functions and only show user functions. 'CastInt' isn't something the user should be able to see (or run).
      • should we add a description annotation that could be included in the sys.functions table?

      Attachments

        Issue Links

          is broken by

          Bug - A problem which impairs or prevents the functions of the product. DRILL-6762 Dynamic UDFs registered on one Drillbit are not visible on other Drillbits

          • Critical - Crashes, loss of data, severe memory leak.
          • Resolved
          is duplicated by

          New Feature - A new feature of the product, which has yet to be developed. DRILL-1124 Expose the list of functions (including udf/udaf) in another system or metadata table (including signature)

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Closed
          is required by

          Improvement - An improvement or enhancement to an existing feature or task. DRILL-6084 Expose list of Drill functions for consumption by JavaScript libraries

          • Major - Major loss of function.
          • Resolved
          relates to

          Improvement - An improvement or enhancement to an existing feature or task. DRILL-6684 Swap sys.options and sys.options_val tables

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Resolved
          links to

          Web Link GitHub Pull Request #1483

          Activity

            People

              kkhatua Kunal Khatua
              jnadeau Jacques Nadeau
              Arina Ielchiieva Arina Ielchiieva
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: