Presto 0.204 Documentation

11.12. Release 0.193

11.12. Release 0.193

General Changes

  • Fix an infinite loop during planning for queries containing non-trivial predicates.
  • Fix row_number() optimization that causes query failure or incorrect results for queries that constrain the result of row_number() to be less than one.
  • Fix failure during query planning when lambda expressions are used in UNNEST or VALUES clauses.
  • Fix Tried to free more revocable memory than is reserved error for queries that have spilling enabled and run in the reserved memory pool.
  • Improve the performance of the ST_Contains() function.
  • Add map_zip_with() lambda function.
  • Add normal_cdf() function.
  • Add SET_DIGEST type and related functions.
  • Add query stat that tracks peak total memory.
  • Improve performance of queries that filter all data from a table up-front (e.g., due to partition pruning).
  • Turn on new local scheduling algorithm by default (see Release 0.181).
  • Remove the information_schema.__internal_partitions__ table.

Security Changes

  • Apply the authentication methods in the order they are listed in the http-server.authentication.type configuration.

CLI Changes

  • Fix rendering of maps of Bing tiles.
  • Abort the query when the result pager exits.

JDBC Driver Changes

  • Use SSL by default for port 443.

Hive Changes

  • Allow dropping any column in a table. Previously, dropping columns other than the last one would fail with ConcurrentModificationException.
  • Correctly write files for text format tables that use non-default delimiters. Previously, they were written with the default delimiter.
  • Fix reading data from S3 if the data is in a region other than us-east-1. Previously, such queries would fail with "The authorization header is malformed; the region 'us-east-1' is wrong; expecting '<region_name>'", where <region_name> is the S3 region hosting the bucket that is queried.
  • Enable SHOW PARTITIONS FROM <table> WHERE <condition> to work for tables that have more than hive.max-partitions-per-scan partitions as long as the specified <condition> reduces the number of partitions to below this limit.

Blackhole Changes

  • Do not allow creating tables in a nonexistent schema.
  • Add support for CREATE SCHEMA.

Memory Connector Changes

  • Allow renaming tables across schemas. Previously, the target schema was ignored.
  • Do not allow creating tables in a nonexistent schema.

MongoDB Changes

  • Add INSERT support. It was previously removed in 0.155.