Fix correctness issue for
array_distinct()when input contains both zeros and nulls.
count(*)aggregation on empty relation when
Improve table scan performance for structural types.
Improve performance for
Add an optimizer rule to filter the window partitions before executing the window operators.
ONkeyword for SHOW STATS.
WHEREclause in SHOW STATS to filters that can be pushed down to the connectors.
Return final results to clients immediately for failed queries.
Fix rendering of live plan view for queries involving index joins.
Hive Connector Changes#
Fix accounting of time spent reading Parquet data.
Fix a corner case where the ORC writer fails with integer overflow when writing highly compressible data using dictionary encoding (#11930).
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-statisticsor session property
Add support for S3 select pushdown, which enables pushing down projections and predicates into S3 for text files.
Kudu Connector Changes#
number_of_replicastable property to
SHOW CREATE TABLEoutput.
Cassandra Connector Changes#
cassandra.protocol-versionconfiguration 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
run-teardown-on-result-mismatchconfiguration property to facilitate debugging. When set to false, temporary tables will not be dropped after checksum failures.
ConnectorBucketNodeMapa top level class.
Use list instead of map for bucket-to-node mapping.
This is a backwards incompatible change with the previous connector SPI. If you have written a connector that uses bucketing, you will need to update your code before deploying this release.