There is a regression in query execution times due to way we are processing HdfsConfiguration and the issue is fixed in 0.273.2 release.
There is a regression caused by airlift SSL changes that results in some queries failing with REMOTE_TASK_ERROR and the issue is fixed in 0.273.3.
Add new Presto connector for Clickhouse.
Fix disaggregated coordinator resource group aggregation issue related to
WAITING_FOR_PREREQUISITEqueries. When a query is moved to WAITING_FOR_PREREQUISITE, resource manager would end up counting them towards running queries. This gives a wrong impression to coordinator about running queries and it would end up running less queries than configured.
Fix a bug where
EXPLAIN (TYPE IO)did not include the index source from an index join.
Fix a memory over-counting issue for using varchar types that could cause queries to fail with exceeded memory limit errors.
Fix an off-by-one error during buffer size calculation in
Fix memory tagging for UnnestOperator and TableWriterMergeOperator.
Improve performance of :func: zip_with when used inside a
Add support for
TRUNCATE TABLEstatement and associated TRUNCATE.
Add support to set timeout on the query analyzer runtime to prevent long running query analysis like complex regular expressions. The timeout duration can be set by the configuration property
planner.query-analyzer-timeoutor session property
trim_array()function that can be called to delete elements from the end of an ordinary array.
Add a new optimization for showing results for (interactive) distinct limit N as they become available with no buffering. This can be enabled by setting the session property
Add support for casting timestamp with micro/nanosecond precision.
Add Read support for json & jsonb data types in postgresql.
Add support for local round robin shuffle to reduce the partial distinct limit output size.
Add support for column subfield access control checks in connectors. Connectors can specify subfield access control for row-type columns through
Add support for retrying queries that failed with max requests queued exception.
Update protoc and grpc version in presto-grpc-api module to adapt to linux aarch64.
Upgrade zstandard compression to version 188.8.131.52. This improves the cpu used for data compressed with zstandard by about 2%.
Upgrade postgresql driver to 42.3.3.
Add a Presto connector for Clickhouse with support of username/password authentication.
Add a limit that prevents caching partitions with column counts greater than a configured threshold. This threshold can be set using the
Add metastore configuration property
hive.metastore.thrift.delete-files-on-table-dropto delete files on drop table.
Add support for overwriting existing partitions with a Hive configuration property
hive.insert-existing-partitions-behavior. This configuration property supersedes the legacy one
hive.insert-overwrite-immutable-partitions-enabled. The new configuration property adds capability of overwriting new partitions for S3.
Add support for timely Parquet metadata cache invalidation.
Replace Hive session property
Replace Hive configuration property
$filestable in case of column dropping.
Add support for storing column comments for Iceberg tables.
Upgrade Iceberg to 0.13.1.
CAST(ObjectId() as STRING)().
Improve query performance by enabling pushdown of topn broker queries by default.
Add double-quotes to Pinot generated queries to ensure that reserved keywords are escaped.
Add TLS support in Pinot gRPC connection.
Upgrade Pinot connector to support Pinot 0.10.0.
Improve handling of scenario where a query fails due to broadcast table violating node memory limit or broadcast limit. Previously the query failed while workers tried to load broadcast table causing container out of memory.
Add a new configuration property
spark.retry-on-out-of-memory-broadcast-join-enabledto disable broadcast join on broadcast OOM and retry the query again within the same spark session. This can be overridden by
Add support to verifier for running control and test queries concurrently by setting
concurrent-control-and-testconfiguration property to true.
ConnectorSplitwhich returns a
Map<String, String>. This method should be preferred to the
getInfomethod which returns a raw object.
Ajay George, Amit Adhikari, Amit Dutta, Anuj Jamwal, Ariel Weisberg, Arjun Gupta, Arunachalam Thirupathi, Aryan, Asjad Syed, Beinan, Boris Verkhovskiy, Branimir Vujicic, Chen Li, Chunxu Tang, Derek Xia, Eduard Tudenhoefner, Fengpeng Yuan, Guy Moore, Harsha Rastogi, James Petty, James Sun, Jaromir Vanek, Jun, Ke Wang, Lin Liu, Maksim Dmitriyevich Podkorytov, Mandy Cho, Maria Basmanova, Michael Shang, Naveen Kumar Mahadevuni, Nikhil Collooru, Nirmit Shah, Ohm Patel, Pranjal Shankhdhar, Rebecca Schlussel, Reetika Agrawal, Rohit Jain, Rongrong Zhong, Ruslan Mardugalliamov, Sergey Pershin, Sergii Druzkin, Shashwat Arghode, Sreeni Viswanadha, Steve Chuck, Swapnil Tailor, Tim Meehan, Todd Gao, Valentin Touffet, Will Holen, Xiang Fu, Xiaoman Dong, Xinli shang, Yeikel, Zac, Zhenxiao Luo, abhiseksaikia, ellison840611, imjalpreet, shidayang, singcha, v-jizhang, xingmao.zheng, xyueji, yangyicheng, zhangbutao