Uploaded image for project: 'Couchbase Server'
  1. Couchbase Server
  2. MB-22035

[CX] specifying scalar functions that take arrays as input

    XMLWordPrintable

Details

    • Task
    • Resolution: Fixed
    • Major
    • techdebt-backlog
    • CBAS DP2
    • analytics
    • None

    Description

      There are a number of functions (not public in CBAS though, https://ci.apache.org/projects/asterixdb/sqlpp/builtins.html) that take an array as one of their input parameters.

      For example:
      string_concat
      string_join
      codepoint_to_string
      binary_concat
      create_polygon
      similarity_jaccard
      similarity_jaccard_check
      object_remove_fields
      object_add_fields
      len
      deep_equal

      We need to review those functions carefully:
      1. Are those functions also aggregate functions (in principle they are)? Should they work in group-by/aggregations (need testing and verifying)?
      2. How should null/missing be handled when they appear in an input array parameter?

      Attachments

        No reviews matched the request. Check your Options in the drop-down menu of this sections header.

        Activity

          People

            mike.carey Mike Carey
            yingyi Yingyi Bu (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Gerrit Reviews

                There are no open Gerrit changes

                PagerDuty