Release 423 (10 Aug 2023)#
General#
Add support for renaming nested fields in a column via
RENAME COLUMN
. (#16757)Add support for setting the type of a nested field in a column via
SET DATA TYPE
. (#16959)Add support for comments on materialized view columns. (#18016)
Add support for displaying all Unicode characters in string literals. (#5061)
Improve performance of
INSERT
andCREATE TABLE AS ... SELECT
queries. (#18212)Improve performance when planning queries involving multiple window functions. (#18491)
Improve performance of queries involving
BETWEEN
clauses. (#18501)Improve performance of queries containing redundant
ORDER BY
clauses in views orWITH
clauses. This may affect the semantics of queries that incorrectly rely on implementation-specific behavior. The old behavior can be restored via theskip_redundant_sort
session property or theoptimizer.skip-redundant-sort
configuration property. (#18159)Reduce default values for the
task.partitioned-writer-count
andtask.scale-writers.max-writer-count
configuration properties to reduce the memory requirements of queries that write data. (#18488)Remove the deprecated
optimizer.use-mark-distinct
configuration property, which has been replaced withoptimizer.mark-distinct-strategy
. (#18540)Fix query planning failure due to dynamic filters in fault tolerant execution mode. (#18383)
Fix
EXPLAIN
failure when a query containsWHERE ... IN (NULL)
. (#18328)
JDBC driver#
Add support for constrained delegation with Kerberos. (#17853)
CLI#
Add support for accepting a single Trino JDBC URL with parameters as an alternative to passing command line arguments. (#12587)
ClickHouse connector#
Add support for
CASCADE
option inDROP SCHEMA
statements. (#18305)
Blackhole connector#
Add support for the
COMMENT ON VIEW
statement. (#18516)
Delta Lake connector#
Add
$properties
system table which can be queried to inspect Delta Lake table properties. (#17294)Add support for reading the
timestamp_ntz
type. (#17502)Add support for writing the
timestamp with time zone
type on partitioned columns. (#16822)Add option to enforce that a filter on a partition key is present for query processing. This can be enabled by setting the
delta.query-partition-filter-required
configuration property or thequery_partition_filter_required
session property totrue
. (#18345)Improve performance of the
$history
system table. (#18427)Improve memory accounting of the Parquet writer. (#18564)
Allow metadata changes on Delta Lake tables with identity columns. (#18200)
Fix incorrectly creating files smaller than the configured
file_size_threshold
as part ofOPTIMIZE
. (#18388)Fix query failure when a table has a file with a location ending with whitespace. (#18206)
Hive connector#
Add support for
varchar
totimestamp
coercion in Hive tables. (#18014)Improve memory accounting of the Parquet writer. (#18564)
Remove the legacy Parquet writer, along with the
parquet.optimized-writer.enabled
configuration property and theparquet_optimized_writer_enabled
session property. Replace theparquet.optimized-writer.validation-percentage
configuration property withparquet.writer.validation-percentage
. (#18420)Disallow coercing Hive
timestamp
types tovarchar
for dates before 1900. (#18004)Fix loss of data precision when coercing Hive
timestamp
values. (#18003)Fix incorrectly creating files smaller than the configured
file_size_threshold
as part ofOPTIMIZE
. (#18388)Fix query failure when a table has a file with a location ending with whitespace. (#18206)
Fix incorrect results when using S3 Select and a query predicate includes a quote character (
"
) or a decimal column. (#17775)Add the
hive.s3select-pushdown.experimental-textfile-pushdown-enabled
configuration property to enable S3 Select pushdown forTEXTFILE
tables. (#17775)
Hudi connector#
Fix query failure when a table has a file with a location ending with whitespace. (#18206)
Iceberg connector#
Add support for renaming nested fields in a column via
RENAME COLUMN
. (#16757)Add support for setting the type of a nested field in a column via
SET DATA TYPE
. (#16959)Add support for comments on materialized view columns. (#18016)
Add support for
tinyint
andsmallint
types in themigrate
procedure. (#17946)Add support for reading Parquet files with time stored in millisecond precision. (#18535)
Improve performance of
information_schema.columns
queries for tables managed by Trino with AWS Glue as metastore. (#18315)Improve performance of
system.metadata.table_comments
when querying Iceberg tables backed by AWS Glue as metastore. (#18517)Improve performance of
information_schema.columns
when using the Glue catalog. (#18586)Improve memory accounting of the Parquet writer. (#18564)
Fix incorrectly creating files smaller than the configured
file_size_threshold
as part ofOPTIMIZE
. (#18388)Fix query failure when a table has a file with a location ending with whitespace. (#18206)
Fix failure when creating a materialized view on a table which has been rolled back. (#18205)
Fix query failure when reading ORC files with nullable
time
columns. (#15606)Fix failure to calculate query statistics when referring to
$path
as part of aWHERE
clause. (#18330)Fix write conflict detection for
UPDATE
,DELETE
, andMERGE
operations. In rare situations this issue may have resulted in duplicate rows when multiple operations were run at the same time, or at the same time as anoptimize
procedure. (#18533)
Kafka connector#
Rename the
ADD_DUMMY
value for thekafka.empty-field-strategy
configuration property and theempty_field_strategy
session property toMARK
(#18485).
Kudu connector#
Add support for optimized local scheduling of splits. (#18121)
MariaDB connector#
Add support for
CASCADE
option inDROP SCHEMA
statements. (#18305)
MongoDB connector#
Add support for predicate pushdown on
char
anddecimal
type. (#18382)
MySQL connector#
Oracle connector#
SingleStore connector#
Add support for
CASCADE
option inDROP SCHEMA
statements. (#18305)
SPI#
Deprecate the
ConnectorMetadata.getTableHandle(ConnectorSession, SchemaTableName)
method signature. Connectors should implementConnectorMetadata.getTableHandle(ConnectorSession, SchemaTableName, Optional, Optional)
instead. (#18596)Remove the deprecated
supportsReportingWrittenBytes
method from ConnectorMetadata. (#18617)