Release 0.216

    • Improve table scan performance for structural types.

    • Improve performance for array_intersect().

    • Add aggregate function.

    • Add millisecond() function.

    • Remove ON keyword for .

    • Restrict WHERE clause in SHOW STATS to filters that can be pushed down to the connectors.

    • Remove node_id column from table.

    • Return final results to clients immediately for failed queries.

    Web UI

    • Fix accounting of time spent reading Parquet data.

    • Fail queries reading Parquet files if statistics in those Parquet files are corrupt (e.g., min > max). To disable this behavior, set the configuration property hive.parquet.fail-on-corrupted-statistics or session property parquet_fail_with_corrupted_statistics to false.

    • Add support for S3 select pushdown, which enables pushing down projections and predicates into S3 for text files.

    Kudu Connector Changes

    • Add number_of_replicas table property to SHOW CREATE TABLE output.
    • Add and cassandra.protocol-version configuration properties to allow connecting to Cassandra servers older than 2.1.5.

    MySQL, PostgreSQL, Redshift, and SQL Server Changes

    • Add support for predicate pushdown for columns of char(x) type.
    • Add run-teardown-on-result-mismatch configuration property to facilitate debugging. When set to false, temporary tables will not be dropped after checksum failures.

    SPI Changes

    • Make ConnectorBucketNodeMap a top level class.

    Note