7.2 Release Notes

Publish Date: 2024.02.11

Features

  • Unlimited String Support removes the limitations with unlimited-width strings that were present in prior versions; now, full support for:
    • Scalar column functions
    • Aggregate column functions
    • Subqueries requiring a temporary view to be created
    • SQL operations:
      • JOIN
      • WHERE
      • GROUP BY
      • ORDER BY
      • EXCEPT
      • INTERSECT
      • UNION
      • CREATE TABLE ... AS
  • Array Type
  • JSON Type
    • Scalar functions
      • JSON_ARRAY
      • JSON_ARRAY_APPEND
      • JSON_ARRAY_CONTAINS
      • JSON_CARDINALITY
      • JSON_EXISTS
      • JSON_KEYS
      • JSON_LENGTH
      • JSON_MAKE_ARRAY
      • JSON_OBJECT
      • JSON_PRETTY
      • JSON_QUERY
      • JSON_REPLACE
      • JSON_TYPE
      • JSON_VALUE
    • Aggregate functions
      • JSON_ARRAYAGG
    • Table functions
      • UNNEST_JSON_ARRAY
  • Vector Type
    • Column functions
      • L1_NORM
      • L2_NORM
      • LINF_NORM
      • LP_NORM
      • NTH
      • SIZE
    • Search functions
      • COSINE_DISTANCE
      • DOT_PRODUCT
      • EUCLIDEAN_DISTANCE
      • L1_DISTANCE
      • L2_DISTANCE
      • L2_SQUAREDISTANCE
      • L2_DISTSQ
      • LINF_DISTANCE
      • LP_DISTANCE
  • Storage Optimization reduces size of data on disk by 50%
  • Improved Performance in TPC-DS benchmarks versus previous versions
  • Store-only column type is no longer supported, as it is no longer needed; VARCHAR columns marked as store-only in 7.1 instances will be automatically supported as unrestricted-width strings after upgrade to 7.2.