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
- Scalar functions
- ARRAY_ITEM
- ARRAY_LENGTH
- ARRAY_LOWER
- ARRAY_NDIMS
- ARRAY_TO_STRING
- ARRAY_UPPER
- STRING_TO_ARRAY
- Aggregate functions
- ARRAY_AGG
- Table functions
- UNNEST_JSON_ARRAY
- Scalar functions
- 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
- Scalar functions
- 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
- Column functions
- 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.