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, - BIGINTinto- SMALLINT, or- VARCHAR(10)into- VARCHAR(3). Values that don’t fit will cause an error at runtime. (#2061)
- Add - regexp_count()and- regexp_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 - AUTOMATICjoin reordering strategy. (#2184)
- Allow configuring - hive.max-outstanding-splits-sizeto 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 the- unsupported-type-handlingconfiguration property or the- unsupported_type_handlingsession property to- CONVERT_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-ttlcontrols how long to cache data (it defaults to- 0mswhich disables caching), and- metadata.cache-missingcontrols whether or not missing tables are cached. (#2290)
This change applies to the MySQL and PostgreSQL connectors:
- Add support for mapping - DECIMALtypes with precision larger than 38 to Presto- DECIMAL. (#2088)