Uploaded image for project: 'EXASOL Roadmap'
  1. EXASOL Roadmap
  2. EXASOL-2830

Virtual Schemas: Simplified Function API

    Details

    • Type: Improvement
    • Status: Resolved
    • Priority: Normal
    • Resolution: Fixed
    • Fix Version/s: Exasol 7.1.0
    • Component/s: None
    • Labels:
      None
    • Changed Behavior:
      Hide
      The Virtual Schema API no longer contains the following fields for scalar functions: numArgs, variableInputArgs, infix. The GROUP_CONCAT separator changed from string to a literal_string expression. Two aggregate function and capability names changed from geo_intersection_aggregate and geo_union_aggregate to ST_INTERSECTION and ST_UNION.
      Show
      The Virtual Schema API no longer contains the following fields for scalar functions: numArgs, variableInputArgs, infix. The GROUP_CONCAT separator changed from string to a literal_string expression. Two aggregate function and capability names changed from geo_intersection_aggregate and geo_union_aggregate to ST_INTERSECTION and ST_UNION.

      Description

      Overview

      We simplified the Virtual Schema API for functions. Users of virtual schemas must update their virtual schema adapters to the latest version.

      Changes

      The changes are mostly relevant for virtual schema adapter developers. The capability name changes are relevant for users, if those capabilities are used in the adapter parameter EXCLUDED_CAPABILITIES which would then have to be updated.

      Scalar Functions

      The Virtual Schema API for scalar functions ("type": "function_scalar") no longer contains the following fields:

      • numArgs
      • variableInputArgs
      • infix

      Virtual schema adapter developers should use the size of the arguments array instead of numArgs, and detect arithmetic operators based on the name field.

      GROUP_CONCAT

      The type of the separator field in "type": "function_aggregate_group_concat" changed from a string to a literal_string expression.

      Geospatial Aggregate Functions

      The naming of two aggregate functions changed:

      • Capability name changes:
        • FN_AGG_GEO_INTERSECTION_AGGREGATE changed to FN_AGG_ST_INTERSECTION
        • FN_AGG_GEO_UNION_AGGREGATE changed to FN_AGG_ST_UNION
      • Aggregate function name changes in "type": "function_aggregate":
        • geo_intersection_aggregate changed to ST_INTERSECTION
        • geo_union_aggregate changed to ST_UNION

        Attachments

          Activity

            People

            • Assignee:
              CaptainEXA Captain EXASOL
              Reporter:
              CaptainEXA Captain EXASOL
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: