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.36k stars 2.98k forks source link

Release notes for 338 #4246

Closed findepi closed 4 years ago

findepi commented 4 years ago

Dain Sundstrom

findepi commented 4 years ago
Kafka
* Fix query failure when a column is projected and also referenced in a query predicate
  when reading from Kafka topic using ``RAW`` decoder. (:issue:`4183`)

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

ebyhr commented 4 years ago
Hive
* Add hidden ``$partition`` column to partitioned table. (:issue:`3582`)

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

ebyhr commented 4 years ago
General
* Add support for setting column comments via the ``COMMENT ON COLUMN`` syntax. (:issue:`2516`)

Hive
* Add support for setting column comments via the ``COMMENT ON COLUMN`` syntax. (:issue:`2516`)

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

losipiuk commented 4 years ago
Mysql
* Fix type mapping for unsigned integer types in MySQL connector. (:issue:`4187 `)

4187, #4146

sopel39 commented 4 years ago
Main
* Fix memory leak while using dynamic filtering. (:issue:`4228`)

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

sopel39 commented 4 years ago
Hive
* Fix Azure ADL caching support. (:issue:`4240`)

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

findepi commented 4 years ago
Hive
* Fix incorrect query results when Parquet file has no min/max statistics for an integer column. (:issue:`4200`)

https://github.com/prestosql/presto/issues/4200 https://github.com/prestosql/presto/pull/4255

sopel39 commented 4 years ago
Hive
* Do not require caching directories to be configured on coordinator. (:issue:`3987,4280`)

https://github.com/prestosql/presto/pull/3987, https://github.com/prestosql/presto/pull/4280

findepi commented 4 years ago
JDBC Driver Changes
* Fix excessive CPU usage when reading query results. (:issue:`3928`)

https://github.com/prestosql/presto/issues/3928 https://github.com/prestosql/presto/pull/4100

findepi commented 4 years ago
General
* Fix query failure when using ``VALUES`` with a ``real`` or ``double`` ``NaN`` value. (:issue:`4119`)
* Fix query failure when joining tables on a ``real`` or ``double`` column and one of the joined tables
  contains ``NaN`` value. (:issue:`4272`)

Hive
* Fix query failure when reading from a table partitioned on a ``real`` or ``double`` column containing
  a ``NaN`` value. (:issue:`4266`)

https://github.com/prestosql/presto/issues/4119 https://github.com/prestosql/presto/issues/4272 https://github.com/prestosql/presto/pull/4266

sopel39 commented 4 years ago
Benchto
* Fix Benchto driver JAR to work with Java 8. Bechto driver doesn't work with Java 11 currently. (:issue:`4299`)

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

dain commented 4 years ago
General
* Fix unauthorized error for internal requests to management endpoints. (:issue:`4304`)

4304

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

* Improve dynamic partition pruning for broadcast joins. (:issue:`4262`)

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

martint commented 4 years ago
* Fix incorrect comparison for ``TIMESTAMP WITH TIME ZONE`` values with precision larger than 3. (:issue:`4305`)

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

martint commented 4 years ago
* Fix planning failure when multiple columns have a mask. (:issue:`4322`)

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

martint commented 4 years ago
* Fix incorrect results when joining tables on a masked column. (:issue:`4251`)

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

martint commented 4 years ago
Elasticsearch
* Add support for reading numeric values encoded as strings. (:issue:`4341`)

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

ebyhr commented 4 years ago
Base-JDBC Connector Library Changes
* Filter objects on hidden schemas when listing tables. (:issue:`3834`)

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

ebyhr commented 4 years ago
Oracle
* Filter internal objects (e.g. ``sys``) when listing schemas. (:issue:`3784`)

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

losipiuk commented 4 years ago
Oracle
* Add support for connection pooling. (:issue:`3770`)

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

martint commented 4 years ago
* Fix incorrect rounding for timestamps before 1970-01-01. (:issue:`4370`)

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

martint commented 4 years ago
* Add compatibility mode for non-compliant clients when rendering datetime type names with default precision in ``information_schema`` tables. 
  This can be enabled via the `deprecated.omit-datetime-type-precision` configuration property or `omit_datetime_type_precision` session property. (:issue:`4349`)

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

electrum commented 4 years ago
General
---
* Enforce ``NOT NULL`` column declarations when writing data. (:issue:`4144`)

4144

electrum commented 4 years ago
Hive
---
* Fix sporadic failure when writing to bucketed sorted tables on S3. (:issue:`2296`)

2296

electrum commented 4 years ago
Hive
---
* Fix handling of strings when translating Hive views. (:issue:`3266`)

3266