trinodb / trino

Official repository of Trino, the distributed SQL query engine for big data, formerly known as PrestoSQL (https://trino.io)
https://trino.io
Apache License 2.0
10.33k stars 2.97k forks source link

Release notes for 337 #4058

Closed electrum closed 4 years ago

electrum commented 4 years ago

Dain Sundstrom

findepi commented 4 years ago
Hive
* Fix reading CSV tables with ``separatorChar``, ``quoteChar`` or ``escapeChar`` table property
  containing more than one character. For compatibility with Hive, only first character is considered
  and remaining are ignored. (:issue:`3891`)

https://github.com/prestosql/presto/pull/3891 https://github.com/prestosql/presto/issues/3868

martint commented 4 years ago
* Add support for variable-precision ``TIMESTAMP WITH TIME ZONE`` type (:issue:`3947`)

https://github.com/prestosql/presto/pull/3947

losipiuk commented 4 years ago
Hive:
* Add add support for ``null_format`` table property for tables using TEXTFILE storage format (:issue:`4056`)

4056

findepi commented 4 years ago
* Add Druid connector. (:issue:`3522`)

https://github.com/prestosql/presto/pull/3522

findepi commented 4 years ago
Hive
* Improve performance of ``INSERT`` queries writing to bucketed tables, when some buckets to not receive 
  any data. (:issue:`1375`)

https://github.com/prestosql/presto/pull/1375

findepi commented 4 years ago
PostgreSQL Connector Changes
* Improve performance of aggregation queries, by computing aggregations within PostgreSQL database.
  Currently, following aggregate functions are eligible for pushdown: ``count``,  ``min``, ``max``, ``sum``
  and ``avg``. (:issue:`3881`, :issue:`18`)

Base-JDBC Connector Library Changes
* Implement framework for aggregation pushdown. `io.prestosql.plugin.jdbc.JdbcClient#implementAggregation`
  is the new extension point. (:issue:`3881`)

https://github.com/prestosql/presto/pull/3881

sopel39 commented 4 years ago
General
--------

* Add peak non-revocable memory metric to query stats. (:issue:`4096`)
* Fix peak non-revocable memory metric in event listener. (:issue:`4096`)

https://github.com/prestosql/presto/pull/4096

losipiuk commented 4 years ago
Hive:
* Add add support for ``null_format`` table property for tables using RCTEXT and SEQUENCEFILE 
  storage formats (:issue:`4143`)

4143

findepi commented 4 years ago
Hive
* Improve performance of queries reading Parquet data with predicates on ``timestamp`` columns. (:issue:`4104`)

https://github.com/prestosql/presto/pull/4104

sopel39 commented 4 years ago
General
-------

* Reduce worker graceful shutdown duration. (:issue:`4192`)

https://github.com/prestosql/presto/pull/4192

martint commented 4 years ago
* Fix incorrect results for inequality join involving ``NaN``. (:issue:`4120`)

https://github.com/prestosql/presto/pull/4120

martint commented 4 years ago
* Add support for ``IN`` predicate with subqueries in outer join condition. (:issue:`4151`)

https://github.com/prestosql/presto/pull/4151

martint commented 4 years ago
Hive
* Improve performance for join queries over partitioned tables. (:issue:`4156`)

https://github.com/prestosql/presto/pull/4156

martint commented 4 years ago
* Add support for quantified comparisons (e.g., ``> ALL (...)``) in aggregation queries. (:issue:`4128`)

https://github.com/prestosql/presto/pull/4128

martint commented 4 years ago
* Improve performance of queries involving comparisons between ``DOUBLE`` or ``REAL`` values and integer types. (:issue:`3533`)
dain commented 4 years ago
Hive
* Add optimized Parquet writer. The new writer is disabled by default, and can be enabled with the ``parquet_optimized_writer_enabled`` session property or the ``hive.parquet.optimized-writer.enabled`` configuration property. (:issue:`3400`)

3400

martint commented 4 years ago
Elasticsearch
* Add support for password authentication. (:issue:`4165`)

https://github.com/prestosql/presto/pull/4165

dain commented 4 years ago
* Disable user impersonation in ``default`` system security.  (:issue:`4082`)

4082

electrum commented 4 years ago
General
---
* Add :func:`translate` function. (:issue:`4080`)

4080

losipiuk commented 4 years ago
Hive
---
* Support ACID data files naming used when direct inserts are enabled in Hive (HIVE-21164). 
  Direct inserts is an upcoming feature in Hive 4. (:issue:`4049`)

4049

dain commented 4 years ago
* Fix queued query JMX stats. (:issue:`4129`)

4129

sopel39 commented 4 years ago
Hive
----

* Upgrade Rubix caching to 0.3.12. This version adds support for Azure Data Lake and AliyunOSS storage
  and fixes support for Google Cloud Storage. Please see Rubix release notes for more details
  about new features. (:issue:`4213`)

https://github.com/prestosql/presto/pull/4213