Release 312 (29 May 2019)#
General#
- Fix incorrect results for queries using - IS [NOT] DISTINCT FROM. (#795)
- Fix - array_distinct,- array_intersectsemantics with respect to indeterminate values (i.e.,- NULLor structural types containing- NULL). (#559)
- Fix failure when the largest negative - BIGINTvalue (- -9223372036854775808) is used as a constant in a query. (#805)
- Improve reliability for network errors when using Kerberos with Secure internal communication. (#838) 
- Improve performance of - JOINqueries involving inline tables (- VALUES). (#743)
- Improve performance of queries containing duplicate expressions. (#730) 
- Improve performance of queries involving comparisons between values of different types. (#731) 
- Improve performance of queries containing redundant - ORDER BYclauses in subqueries. This may affect the semantics of queries that incorrectly rely on implementation-specific behavior. The old behavior can be restored via the- skip_redundant_sortsession property or the- optimizer.skip-redundant-sortconfiguration property. (#818)
- Improve performance of - INpredicates that contain subqueries. (#767)
- Improve support for correlated subqueries containing redundant - LIMITclauses. (#441)
- Add Phoenix connector. (#672) 
- Make semantic error name available in client protocol. (#790) 
- Report operator statistics when - experimental.work-processor-pipelinesis enabled. (#788)
Server#
- Raise required Java version to 8u161. This version allows unlimited strength crypto. (#779) 
- Show JVM configuration hint when JMX agent fails to start on Java 9+. (#838) 
- Skip starting JMX agent on Java 9+ if it is already configured via JVM properties. (#838) 
- Support configuring TrustStore for Secure internal communication using the - internal-communication.https.truststore.pathand- internal-communication.https.truststore.keyconfiguration properties. The path can point at a Java KeyStore or a PEM file. (#785)
- Remove deprecated check for minimum number of workers before starting a coordinator. Use the - query-manager.required-workersand- query-manager.required-workers-max-waitconfiguration properties instead. (#95)
Hive connector#
- Fix - SHOW GRANTSfailure when metastore contains few tables. (#791)
- Fix failure reading from - information_schema.table_privilegestable when metastore contains few tables. (#791)
- Use Hive naming convention for file names when writing to bucketed tables. (#822) 
- Support new Hive bucketing conventions by allowing any number of files per bucket. This allows reading from partitions that were inserted into multiple times by Hive, or were written to by Hive on Tez (which does not create files for empty buckets). 
- Allow disabling the creation of files for empty buckets when writing data. This behavior is enabled by default for compatibility with previous versions of Presto, but can be disabled using the - hive.create-empty-bucket-filesconfiguration property or the- create_empty_bucket_filessession property. (#822)
MySQL connector#
- Map MySQL - jsontype to Presto- jsontype. (#824)
PostgreSQL connector#
- Add support for PostgreSQL’s - TIMESTAMP WITH TIME ZONEdata type. (#640)
SPI#
- Add support for pushing - TABLESAMPLEinto connectors via the- ConnectorMetadata.applySample()method. (#753)