Release 318 (26 Aug 2019)#
General#
- Fix query failure when using - DISTINCT FROMwith the- UUIDor- IPADDRESStypes. (#1180)
- Improve query performance when - optimize_hash_generationis enabled. (#1071)
- Improve performance of information schema tables. (#999, #1306) 
- Rename - http.server.authentication.*configuration options to- http-server.authentication.*. (#1270)
- Change query CPU tracking for resource groups to update periodically while the query is running. Previously, CPU usage would only update at query completion. This improves resource management fairness when using CPU-limited resource groups. (#1128) 
- Remove - distributed_planning_time_mscolumn from- system.runtime.queries. (#1084)
- Add support for - Asia/Qostanaytime zone. (#1221)
- Add session properties that allow overriding the query per-node memory limits: - query_max_memory_per_nodeand- query_max_total_memory_per_node. These properties can be used to decrease limits for a query, but not to increase them. (#1212)
- Add Google Sheets connector. (#1030) 
- Add - planning_time_mscolumn to the- system.runtime.queriestable that shows the time spent on query planning. This is the same value that used to be in the- analysis_time_mscolumn, which was a misnomer. (#1084)
- Add - last_day_of_month()function. (#1295)
- Add support for cancelling queries via the - system.runtime.kill_queryprocedure when they are in the queue or in the semantic analysis stage. (#1079)
- Add queries that are in the queue or in the semantic analysis stage to the - system.runtime.queriestable. (#1079)
Web UI#
Hive connector#
- Fix query failure due to missing credentials while writing empty bucket files. (#1298) 
- Fix bucketing of - NaNvalues of- realtype. Previously- NaNvalues could be assigned a wrong bucket. (#1336)
- Fix reading - RCFilecollection delimiter set by Hive version earlier than 3.0. (#1321)
- Return proper error when selecting - "$bucket"column from a table using Hive bucketing v2. (#1336)
- Improve performance of S3 object listing. (#1232) 
- Improve performance when reading data from GCS. (#1200) 
- Add support for reading data from S3 Requester Pays buckets. This can be enabled using the - hive.s3.requester-pays.enabledconfiguration property. (#1241)
- Allow inserting into bucketed, unpartitioned tables. (#1127) 
- Allow inserting into existing partitions of bucketed, partitioned tables. (#1347) 
PostgreSQL connector#
- Add support for providing JDBC credential in a separate file. This can be enabled by setting the - credential-provider.type=FILEand- connection-credential-fileconfig options in the catalog properties file. (#1124)
- Allow logging all calls to - JdbcClient. This can be enabled by turning on- DEBUGlogging for- io.prestosql.plugin.jdbc.JdbcClient. (#1274)
- Add possibility to force mapping of certain types to - varchar. This can be enabled by setting- jdbc-types-mapped-to-varcharto comma-separated list of type names. (#186)
- Add support for PostgreSQL - timestamp[]type. (#1023, #1262, #1328)
MySQL connector#
- Add support for providing JDBC credential in a separate file. This can be enabled by setting the - credential-provider.type=FILEand- connection-credential-fileconfig options in the catalog properties file. (#1124)
- Allow logging all calls to - JdbcClient. This can be enabled by turning on- DEBUGlogging for- io.prestosql.plugin.jdbc.JdbcClient. (#1274)
- Add possibility to force mapping of certain types to - varchar. This can be enabled by setting- jdbc-types-mapped-to-varcharto comma-separated list of type names. (#186)
Redshift connector#
- Add support for providing JDBC credential in a separate file. This can be enabled by setting the - credential-provider.type=FILEand- connection-credential-fileconfig options in the catalog properties file. (#1124)
- Allow logging all calls to - JdbcClient. This can be enabled by turning on- DEBUGlogging for- io.prestosql.plugin.jdbc.JdbcClient. (#1274)
- Add possibility to force mapping of certain types to - varchar. This can be enabled by setting- jdbc-types-mapped-to-varcharto comma-separated list of type names. (#186)
SQL Server connector#
- Add support for providing JDBC credential in a separate file. This can be enabled by setting the - credential-provider.type=FILEand- connection-credential-fileconfig options in the catalog properties file. (#1124)
- Allow logging all calls to - JdbcClient. This can be enabled by turning on- DEBUGlogging for- io.prestosql.plugin.jdbc.JdbcClient. (#1274)
- Add possibility to force mapping of certain types to - varchar. This can be enabled by setting- jdbc-types-mapped-to-varcharto comma-separated list of type names. (#186)