Release 0.198

    • Add support for selective aggregates () with DISTINCT argument qualifiers.

    • Support ESCAPE for LIKE predicate in SHOW SCHEMAS and SHOW TABLES queries.

    • Parse decimal literals (e.g. 42.0) as DECIMAL by default. Previously, they were parsed as DOUBLE. This behavior can be turned off via the parse-decimal-literals-as-double config option or the parse_decimal_literals_as_double session property.

    • Add variant of sequence() function for DATE with an implicit one-day step increment.

    • Increase the maximum number of arguments for the function from 4 to 5.

    • Add ST_IsValid(), , simplify_geometry(), and functions.

    • Support min() and aggregation functions when the input type is unknown at query analysis time. In particular, this allows using the functions with NULL literals.

    • Add trace token support to the scheduler and exchange HTTP clients. Each HTTP request sent by the scheduler and exchange HTTP clients will have a “trace token” (a unique ID) in their headers, which will be logged in the HTTP request logs. This information can be used to correlate the requests and responses during debugging.

    • Improve query performance when dynamic writer scaling is enabled.

    • Improve performance of ST_Intersects().

    • Improve query latency when tables are known to be empty during query planning.

    • Optimize array_agg() to avoid excessive object overhead and native memory usage with G1 GC.

    • Improve parallelism of queries that have an empty grouping set.

    • Improve performance of join queries involving the ST_Distance() function.

    Resource Groups Changes

    • Change WEIGHTED_FAIR scheduling policy to select oldest eligible sub group of groups where utilization and share are identical.

    • The --enable-authentication option has been removed. Kerberos authentication is automatically enabled when is specified.

    • Kerberos authentication now requires HTTPS.

    Hive Changes

    • Add support for using as the metastore. Enable it by setting the hive.metastore config property to glue.

    • Fix a bug in the ORC writer that will write incorrect data of type VARCHAR or VARBINARY into files.

    • Add wildcard character * which allows querying several MBeans with a single query.

    SPI Changes

    • Add performance statistics to query plan in QueryCompletedEvent.

    • Improve validation of ArrayBlock, MapBlock, and during construction.