Release 335 (14 Jun 2020)#
General#
- Fix failure when - reduce_agg()is used as a window function. (#3883)
- Fix incorrect cast from - TIMESTAMP(without time zone) to- TIMEtype. (#3848)
- Fix incorrect query results when converting very large - TIMESTAMPvalues into- TIMESTAMP WITH TIME ZONE, or when parsing very large- TIMESTAMP WITH TIME ZONEvalues. (#3956)
- Return - VARCHARtype when- substr()argument is- CHARtype. (#3599, #3456)
- Improve optimized local scheduling with regard to non-uniform data distribution. (#3922) 
- Add support for variable-precision - TIMESTAMP(without time zone) type. (#3783)
- Add a variant of - substring()that takes a- CHARargument. (#3949)
- Add - information_schema.role_authorization_descriptorstable that returns information about the roles granted to principals. (#3535)
Security#
- Add schema access rules to File-based access control. (#3766) 
Web UI#
- Fix the value displayed in the worker memory pools bar. (#3920) 
Accumulo connector#
- The server-side iterators are now in a JAR file named - presto-accumulo-iterators. (#3673)
Hive connector#
- Collect column statistics for inserts into empty tables. (#2469) 
- Add support for - information_schema.role_authorization_descriptorstable when using the- sql-standardsecurity mode. (#3535)
- Allow non-lowercase column names in system.sync_partition_metadata procedure. This can be enabled by passing - case_sensitive=falsewhen invoking the procedure. (#3431)
- Support caching with secured coordinator. (#3874) 
- Prevent caching from becoming disabled due to intermittent network failures. (#3874) 
- Ensure HDFS impersonation is not enabled when caching is enabled. (#3913) 
- Add - hive.cache.ttland- hive.cache.disk-usage-percentagecache properties. (#3840)
- Improve query performance when caching is enabled by scheduling work on nodes with cached data. (#3922) 
- Add support for - UNIONTYPE. This is mapped to- ROWcontaining a- tagfield and a field for each data type in the union. For example,- UNIONTYPE<INT, DOUBLE>is mapped to- ROW(tag INTEGER, field0 INTEGER, field1 DOUBLE). (#3483)
- Make - partition_valuesargument to- drop_statsprocedure optional. (#3937)
- Add support for dynamic partition pruning to improve performance of complex queries over partitioned data. (#1072) 
Phoenix connector#
- Allow configuring whether - DROP TABLEis allowed. This is controlled by the new- allow-drop-tablecatalog configuration property and defaults to- true, compatible with the previous behavior. (#3953)
SPI#
- Add support for aggregation pushdown into connectors via the - ConnectorMetadata.applyAggregation()method. (#3697)