13.164. Release 0.90

    • Initial support for partition and placement awareness in the query planner. This can result in better plans for queries involving and GROUP BY over the same key columns.
    • Improve planning of UNION queries.
    • Add presto version to query creation and completion events.
    • Add property task.writer-count to configure the number of writers per task.
    • Fix a bug when optimizing constant expressions involving binary types.
    • Fix a bug when unnesting an array of doubles containing NaN or Infinity.
    • Fix failure when accessing elements in an empty array.
    • Fix “Remote page is too large” errors.
    • Improve error message when attempting to cast a value to UNKNOWN.
    • Update the approx_distinct() documentation with correct standard error bounds.
    • Disable falling back to the interpreter when expressions fail to be compiled to bytecode. To enable this option, add compiler.interpreter-enabled=true to the coordinator and worker config properties. Enabling this option will allow certain queries to run slowly rather than failing.
    • Improve conformance. In particular, all unimplemented methods now throw SQLException rather than UnsupportedOperationException.
    • Add and aggregation functions.
    • Add standard SQL function every() as an alias for .
    • Add regexp_extract_all() function.
    • Add aggregation function.
    • Add support for casting JSON to or MAP types.
    • Add support for unparenthesized expressions in VALUES clause.
    • Added SET SESSION, and SHOW SESSION.
    • Improve formatting of EXPLAIN (TYPE DISTRIBUTED) output and include additional information such as output layout, task placement policy and partitioning functions.
    • Disable optimized metastore partition fetching for non-string partition keys. This fixes an issue were Presto might silently ignore data with non-canonical partition values. To enable this option, add hive.assume-canonical-partition-keys=true to the coordinator and worker config properties.
    • Don’t retry operations against S3 that fail due to lack of permissions.
    • Add getColumnTypes to RecordSink.
    • Add which is a more efficient interface for column-oriented sources.