13.136. Release 0.137

    • Fix to return correct results for all time zones.
    • Fix invalid plans when scalar subqueries use GROUP BY, DISTINCT or JOIN.
    • Do not allow creating views with a column type of UNKNOWN.
    • Add bit_count(), , bitwise_and(), , and bitwise_xor() functions.
    • Add aggregation support for VARBINARY input.
    • Add create time to query detail page in UI.
    • Add support for type.
    • Track per-stage peak memory usage.
    • Add API to JDBC driver to track query progress.

    Hive Changes

    • Do not allow inserting into tables when the Hive type does not match the Presto type. Previously, Presto would insert data that did not match the table or partition type and that data could not be read by Hive. For example, Presto would write files containing BIGINT data for a Hive column type of INT.
    • Add validation to and CREATE TABLE AS to check that partition keys are the last columns in the table and in the same order as the table properties.
    • Remove retention_days table property. This property is not used by Hive.
    • Fix Parquet decoding of MAP containing a null value.