Presto 318 Documentation

12.3. Release 316

12.3. Release 316

General Changes

  • Fix date_format function failure when format string contains non-ASCII characters. (#1056)
  • Improve performance of queries using UNNEST. (#901)
  • Improve error message when statement parsing fails. (#1042)

CLI Changes

  • Fix refresh of completion cache when catalog or schema is changed. (#1016)
  • Allow reading password from console when stdout is a pipe. (#982)

Hive Connector Changes

  • Acquire S3 credentials from the default AWS locations if not configured explicitly. (#741)
  • Only allow using roles and grants with SQL standard based authorization. (#972)
  • Add support for CSV file format. (#920)
  • Support reading from and writing to Hadoop encryption zones (Hadoop KMS). (#997)
  • Collect column statistics on write by default. This can be disabled using the hive.collect-column-statistics-on-write configuration property or the collect_column_statistics_on_write session property. (#981)
  • Eliminate unused idle threads when using the metastore cache. (#1061)

PostgreSQL Connector Changes

  • Add support for columns of type UUID. (#1011)
  • Export JMX statistics for various JDBC and connector operations. (#906).

MySQL Connector Changes

  • Export JMX statistics for various JDBC and connector operations. (#906).

Redshift Connector Changes

  • Export JMX statistics for various JDBC and connector operations. (#906).

SQL Server Connector Changes

  • Export JMX statistics for various JDBC and connector operations. (#906).

TPC-H Connector Changes

  • Fix SHOW TABLES failure when used with a hidden schema. (#1005)

TPC-DS Connector Changes

  • Fix SHOW TABLES failure when used with a hidden schema. (#1005)

SPI Changes

  • Add support for pushing simple column and row field reference expressions into connectors via the ConnectorMetadata.applyProjection() method. (#676)