Presto 0.141t Documentation

17.36. Release 0.108

17.36. Release 0.108

General Changes

  • Fix incorrect query results when a window function follows a row_number() function and both are partitioned on the same column(s).
  • Fix planning issue where queries that apply a false predicate to the result of a non-grouped aggregation produce incorrect results.
  • Fix exception when ORDER BY clause contains duplicate columns.
  • Fix issue where a query (read or write) that should fail can instead complete successfully with zero rows.
  • Add normalize(), from_iso8601_timestamp(), from_iso8601_date() and to_iso8601() functions.
  • Add support for position() syntax.
  • Add Teradata compatibility functions: index(), char2hexint(), to_char(), to_date() and to_timestamp().
  • Make ctrl-C in CLI cancel the query (rather than a partial cancel).
  • Allow calling Connection.setReadOnly(false) in the JDBC driver. The read-only status for the connection is currently ignored.
  • Add missing CAST from VARCHAR to TIMESTAMP WITH TIME ZONE.
  • Allow optional time zone in CAST from VARCHAR to TIMESTAMP and TIMESTAMP WITH TIME ZONE.
  • Trim values when converting from VARCHAR to date/time types.
  • Add support for fixed time zones +00:00 and -00:00.
  • Properly account for query memory when using the row_number() function.
  • Skip execution of inner join when the join target is empty.
  • Improve query detail UI page.
  • Fix printing of table layouts in EXPLAIN.
  • Add Black Hole Connector.

Cassandra Changes

  • Randomly select Cassandra node for split generation.
  • Fix handling of UUID partition keys.