Release 325 (14 Nov 2019)#
Warning
There is a performance regression in this release.
General#
- Fix incorrect results for certain queries involving - FULLor- RIGHTjoins and- LATERAL. (#1952)
- Fix incorrect results when using - IS DISTINCT FROMon columns of- DECIMALtype with precision larger than 18. (#1985)
- Fix query failure when row types contain a field named after a reserved SQL keyword. (#1963) 
- Add support for - LIKEpredicate to- SHOW SESSIONand- SHOW FUNCTIONS. (#1688, #1692)
- Add support for late materialization to join operations. (#1256) 
- Reduce number of metadata queries during planning. This change disables stats collection for non- - EXPLAINqueries. If you want to have access to such stats and cost in query completion events, you need to re-enable stats collection using the- collect-plan-statistics-for-all-queriesconfiguration property. (#1866)
- Add variant of - strpos()that returns the Nth occurrence of a substring. (#1811)
- Add - to_encoded_polyline()and- from_encoded_polyline()geospatial functions. (#1827)
Web UI#
- Show actual query for an - EXECUTEstatement. (#1980)
Hive#
- Fix incorrect behavior of - CREATE TABLEwhen Hive metastore is configured with- metastore.create.as.acidset to- true. (#1958)
- Fix query failure when reading Parquet files that contain character data without statistics. (#1955) 
- Allow analyzing a subset of table columns (rather than all columns). (#1907) 
- Support overwriting unpartitioned tables for insert queries when using AWS Glue. (#1243) 
- Add support for reading Parquet files where the declared precision of decimal columns does not match the precision in the table or partition schema. (#1949) 
- Improve performance when reading Parquet files with small row groups. (#1925) 
Other connectors#
These changes apply to the MySQL, PostgreSQL, Redshift, and SQL Server connectors.
- Fix incorrect insertion of data when the target table has an unsupported type. (#1930)