13.19. Release 0.238
Warning
There is a bug in this release that will cause certain queries with lambda expressions to fail. There is a reliability issue in ZSTD compression that causes frequent excessive GC events in this release.
Warning
There is a bug in LambdaDefinitionExpression canonicalization introduced in this release. For more details, go to #15424.
Highlights
- Fix SQL function parameters to be case-insensitive.
- Add support to create external function. (#13254)
- Add support for exchange materialization of table bucketed by non-hive types. This can be enabled by setting the
bucket_function_type_for_exchange
session property orhive.bucket-function-type-for-exchange `` configuration property to ``PRESTO_NATIVE
. - Add predicate pushdown support for
DATE
,TIMESTAMP
, andTIMESTAMP_WITH_TIME_ZONE
literals for Pinot connector.
General Changes
- Fix SQL function parameters to be case-insensitive.
- Add
target_result_size
session property to customize data batch sizes being streamed from coordinator. - Add optimization to push null filters to the INNER side of equijoins. The optimization can be enabled with
optimize-nulls-in-joins
. - Add
sessionProperty
override to Presto JDBC URI. - Add support to create external function. (#13254)
- Add session property
query_max_broadcast_memory
to limit the memory a query can use for broadcast join. - Remove max buffer count configuration property
driver.max-page-partitioning-buffer-count
for optimized repartitioning.
Geospatial Changes
- Fix error in
geometry_invalid_reason()
. - Fix integer overflow in certain cases with Bing Tiles.
Hive Changes
- Fix a bug in Parquet reader which manifests when there are nested column schema changes.
- Add support for exchange materialization of table bucketed by non-hive types. This can be enabled by setting the
bucket_function_type_for_exchange
session property orhive.bucket-function-type-for-exchange `` configuration property to ``PRESTO_NATIVE
.
Pinot Changes
- Add support to retry data fetch exception. This can be enabled by setting the configuration property
pinot.mark-data-fetch-exceptions-as-retriable
. - Add predicate pushdown support for
DATE
,TIMESTAMP
, andTIMESTAMP_WITH_TIME_ZONE
literals.
Verifier Changes
- Fix an issue where session properties of control and test queries also affects checksum queries.
- Add support to report peak task memory usage for control and test queries.