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 thanUnsupportedOperationException
.
- 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 orMAP
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
toRecordSink
. - Add which is a more efficient interface for column-oriented sources.