Release 328 (10 Jan 2020)#
General#
Fix correctness issue for certain correlated join queries when the correlated subquery on the right produces no rows. (#1969)
Fix incorrect handling of multi-byte characters for Regular expression functions when the pattern is empty. (#2313)
Fix failure when join criteria contains columns of different types. (#2320)
Fix failure for complex outer join queries when dynamic filtering is enabled. (#2363)
Improve support for correlated queries. (#1969)
Allow inserting values of a larger type into as smaller type when the values fit. For example,
BIGINT
intoSMALLINT
, orVARCHAR(10)
intoVARCHAR(3)
. Values that don’t fit will cause an error at runtime. (#2061)Add
regexp_count()
andregexp_position()
functions. (#2136)Add support for interpolating Secrets in server and catalog configuration files. (#2370)
Security#
JDBC driver#
Hive connector#
Reduce query latency and Hive metastore load when using the
AUTOMATIC
join reordering strategy. (#2184)Allow configuring
hive.max-outstanding-splits-size
to values larger than 2GB. (#2395)Avoid redundant file system stat call when writing Parquet files. (#1746)
Avoid retrying permanent errors for S3-related services such as STS. (#2331)
Kafka connector#
Elasticsearch connector#
Phoenix connector#
Add support for mapping unsupported data types to
VARCHAR
. This can be enabled by setting theunsupported-type-handling
configuration property or theunsupported_type_handling
session property toCONVERT_TO_VARCHAR
. (#2427)
Other connectors#
These changes apply to the MySQL, PostgreSQL, Redshift and SQL Server connectors:
Add support for creating schemas. (#1874)
Add support for caching metadata. The configuration property
metadata.cache-ttl
controls how long to cache data (it defaults to0ms
which disables caching), andmetadata.cache-missing
controls whether or not missing tables are cached. (#2290)
This change applies to the MySQL and PostgreSQL connectors:
Add support for mapping
DECIMAL
types with precision larger than 38 to PrestoDECIMAL
. (#2088)