Release 0.196#
General#
Fix behavior of
JOIN ... USING
to conform to standard SQL semantics. The old behavior can be restored by setting thedeprecated.legacy-join-using
configuration option or thelegacy_join_using
session property.Fix memory leak for queries with
ORDER BY
.Fix tracking of query peak memory usage.
Fix skew in dynamic writer scaling by eagerly freeing memory in the source output buffers. This can be disabled by setting
exchange.acknowledge-pages=false
.Fix planning failure for lambda with capture in rare cases.
Fix decimal precision of
round(x, d)
whenx
is aDECIMAL
.Fix returned value from
round(x, d)
whenx
is aDECIMAL
with scale0
andd
is a negative integer. Previously, no rounding was done in this case.Improve performance of the
array_join()
function.Improve performance of the
ST_Envelope()
function.Optimize
min_by()
andmax_by()
by avoiding unnecessary object creation in order to reduce GC overhead.Show join partitioning explicitly in
EXPLAIN
.Add
is_json_scalar()
function.Add
regexp_replace()
function variant that executes a lambda for each replacement.
Security#
Add rules to the
file
System access control to enforce a specific matching between authentication credentials and a executing username.
Hive#
Fix a correctness issue where non-null values can be treated as null values when writing dictionary-encoded strings to ORC files with the new ORC writer.
Fix invalid failure due to string statistics mismatch while validating ORC files after they have been written with the new ORC writer. This happens when the written strings contain invalid UTF-8 code points.
Add support for reading array, map, or row type columns from partitions where the partition schema is different from the table schema. This can occur when the table schema was updated after the partition was created. The changed column types must be compatible. For rows types, trailing fields may be added or dropped, but the corresponding fields (by ordinal) must have the same name.
Add
hive.non-managed-table-creates-enabled
configuration option that controls whether or not users may create non-managed (external) tables. The default value istrue
.