Release 0.207

    • Remove support for legacy JOIN ... USING behavior.

    • Deprecate the reorder_joins session property and the reorder-joins configuration property. They are replaced by the join_reordering_strategy session property and the optimizer.join-reordering-strategy configuration property. NONE maintains the order of the joins as written and is equivalent to reorder_joins=false. ELIMINATE_CROSS_JOINS will eliminate any unnecessary cross joins from the plan and is equivalent to . AUTOMATIC will use the new cost-based optimizer to select the best join order. To simplify migration, setting the reorder_joins session property overrides the new session and configuration properties.

    • Deprecate the distributed_joins session property and the distributed-joins-enabled configuration property. They are replaced by the join_distribution_type session property and the join-distribution-type configuration property. PARTITIONED turns on hash partitioned joins and is equivalent to distributed_joins-enabled=true. BROADCAST changes the join strategy to broadcast and is equivalent to . AUTOMATIC will use the new cost-based optimizer to select the best join strategy. If no statistics are available, AUTOMATIC is the same as REPARTITIONED. To simplify migration, setting the distributed_joins session property overrides the new session and configuration properties.

    • Add support for column properties.

    • Add support for char type to approx_distinct().

    Security Changes

    • Fail on startup when configuration for file based system access control is invalid.

    • Add support for securing communication between cluster nodes with Kerberos authentication.

    • Add peak total (user + system) memory to query details UI.

    Hive Connector Changes

    • Fail on startup when configuration for file based access control is invalid.

    • Allow ORC files to have struct columns with missing fields. This allows the table schema to be changed without rewriting the ORC files.

    • Change collector for columns statistics to only consider a sample of partitions. The sample size can be changed by setting the hive.partition-statistics-sample-size property.

    • Add support for dropping schemas.

    SPI Changes

    • Remove deprecated table/view-level access control methods.

    • Change predicate in constraint for accessing table layout to be optional.

    • Change schema name in to be optional rather than nullable.