Release 329 (23 Jan 2020)#
General#
- Fix incorrect result for - last_day_of_month()function for first day of month. (#2452)
- Fix incorrect results when handling - DOUBLEor- REALtypes with- NaNvalues. (#2582)
- Fix query failure when coordinator hostname contains underscores. (#2571) 
- Fix - SHOW CREATE TABLEfailure when row types contain a field named after a reserved SQL keyword. (#2130)
- Handle common disk failures during spill. When one disk fails but multiple spill locations are configured, the healthy disks will be used for future queries. (#2444) 
- Improve performance and reduce load on external systems when querying - information_schema. (#2488)
- Improve performance of queries containing redundant scalar subqueries. (#2456) 
- Limit broadcasted table size to - 100MBby default when using the- AUTOMATICjoin type selection strategy. This avoids query failures or excessive memory usage when joining two or more very large tables. (#2527)
- Enable cost based join reordering and join type selection optimizations by default. The previous behavior can be restored by setting - optimizer.join-reordering-strategyconfiguration property to- ELIMINATE_CROSS_JOINSand- join-distribution-typeto- PARTITIONED. (#2528)
- Hide non-standard columns - commentand- extra_infoin the standard- information_schema.columnstable. These columns can still be selected, but will no longer appear when describing the table. (#2306)
Security#
- Add - ldap.bind-dnand- ldap.bind-passwordLDAP properties to allow LDAP authentication access LDAP server using service account. (#1917)
Hive connector#
- Fix incorrect data returned when using S3 Select on uncompressed files. In our testing, S3 Select was apparently returning incorrect results when reading uncompressed files, so S3 Select is disabled for uncompressed files. (#2399) 
- Fix incorrect data returned when using S3 Select on a table with - skip.header.line.countor- skip.footer.line.countproperty. S3 Select API does not support skipping footers or more than one line of a header. In our testing, S3 Select was apparently sometimes returning incorrect results when reading a compressed file with header skipping, so S3 Select is disabled when any of these table properties is set to non-zero value. (#2399)
- Fix query failure for writes when one of the inserted - REALor- DOUBLEvalues is infinite or- NaN. (#2471)
- Fix performance degradation reading from S3 when the Kinesis connector is installed. (#2496) 
- Allow reading data from Parquet files when the column type is declared as - INTEGERin the table or partition, but is a- DECIMALtype in the file. (#2451)
- Validate the scale of decimal types when reading Parquet files. This prevents incorrect results when the decimal scale in the file does not match the declared type for the table or partition. (#2451) 
- Delete storage location when dropping an empty schema. (#2463) 
- Improve performance when deleting multiple partitions by executing these actions concurrently. (#1812) 
- Improve performance for queries containing - INpredicates over bucketing columns. (#2277)
- Add procedure - system.drop_stats()to remove the column statistics for a table or selected partitions. (#2538)
Elasticsearch connector#
- Add support for Array types. (#2441) 
- Reduce load on Elasticsearch cluster and improve query performance. (#2561) 
PostgreSQL connector#
- Fix mapping between PostgreSQL’s - TIMEand Presto’s- TIMEdata types. Previously the mapping was incorrect, shifting it by the relative offset between the session time zone and the Presto server’s JVM time zone. (#2549)