11.92. Release 0.126
General Changes
- Add error location information (line and column number) for semantic errors.
- Fix a CLI crash during tab-completion when no schema is currently selected.
- Fix reset of session properties in CLI when running USE.
- Fix occasional query planning failure due to a bug in the projectionpush down optimizer.
- Fix a parsing issue when expressions contain the form POSITION(x in (y)).
- Add a new version of approx_percentile() that takes an accuracyparameter.
- Allow specifying columns names in INSERT queries.
- Add field_length table property to blackhole connector to control thesize of generated VARCHAR and VARBINARY fields.
- Bundle Teradata functions plugin in server package.
- Improve handling of physical properties which can increase performance forqueries involving window functions.
- Add ability to control whether index join lookups and caching are sharedwithin a task. This allows us to optimize for index cache hits or for moreCPU parallelism. This option is toggled by the task.share-index-loadingconfig property or the task_share_index_loading session property.
- Add Tableau web connector.
- Improve performance of queries that use an IN expression with a largelist of constant values.
- Enable connector predicate push down for all comparable and equatable types.
- Fix query planning failure when using certain operations such as GROUP BY,DISTINCT, etc. on the output columns of UNNEST.
- In ExchangeClient set maxResponseSize to be slightly smaller thanthe configured value. This reduces the possibility of encounteringPageTooLargeException.
- Fix memory leak in coordinator.
- Add validation for names of table properties.
Hive Changes
- Fix reading structural types containing nulls in Parquet.
- Fix writing DATE type when timezone offset is negative. Previous versionswould write the wrong date (off by one day).
- Fix an issue where VARCHAR columns added to an existing table could not bequeried.
- Fix over-creation of initial splits.
- Fix hive.immutable-partitions config property to also apply tounpartitioned tables.
- Allow non-VARCHAR columns in DELETE query.
- Support DATE columns as partition columns in parquet tables.
- Improve error message for cases where partition columns are also table columns.
原文: https://prestodb.io/docs/current/release/release-0.126.html