search

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.3k stars 2.97k forks source link

Release notes for 331 #2880

Closed electrum closed 4 years ago

electrum commented 4 years ago

Dain Sundstrom

Grzegorz Kokosiński

sopel39 commented 4 years ago 
UI
--

* Display physical input read rate in UI. (:issue:`2873`)

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

dain commented 4 years ago 
Security
--------
* Remove unused `internal-communication.jwt.enabled` configuration property. (:issue:`2709`)

2709

dain commented 4 years ago 
Hive
----
* Add support for Hive full ACID tables. (:issue:`2068`, :issue:`1591`)

2068 https://github.com/prestosql/presto/pull/1591

https://github.com/prestosql/presto/issues/2790 https://github.com/prestosql/presto/pull/2989

dain commented 4 years ago 
UI
--
* Add simple form based authentication. Users can be authenticated with either the LDAP or the file based authentication services. (:issue:`2755`)
* Add support for disabling the web ui.  The UI can be disabled with the ``web-ui.enabled`` configuration property. (:issue:`2755`)

2755

martint commented 4 years ago 
* Improve performance of inequality joins involving ``BETWEEN``. (:issue:`2859`)

2859

dain commented 4 years ago 
General
-------
* Ensure query completed event is fired when there is an error during analysis or planning. (:issue:`2842`)

2842

dain commented 4 years ago 
SPI
---
* Remove deprecated ``Identity`` constructors. (:issue:`2877`)
* Introduce a builder for ``ConnectorIdentity`` and deprecate its public constructors. (:issue:`2877`)

2877

dain commented 4 years ago 
Security
--------
* Rename JWT configuration properties from ``http.authentication.jwt.*`` to ``http-server.authentication.jwt``. (:issue:`2712`)

2712

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

* Prevent queries to fail when worker is being shut down gracefully. (:issue:`2648`)

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

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

* Improve engine performance in joins. (:issue:`2862`)

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

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

* Fix query memory accounting for ``ORDER BY`` queries. (:issue:`2612`)

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

findepi commented 4 years ago 
UI
* Fix copying worker address to clipboard. (:issue:`2865`)

https://github.com/prestosql/presto/pull/2869 https://github.com/prestosql/presto/issues/2865

sopel39 commented 4 years ago 
UI
--

* Fix copying of query ID to clipboard. (:issue:`2872`)

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

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

* Improve query performance by removing redundant data reshuffling. (:issue:`2853`)

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

findepi commented 4 years ago 
General
* Fix :func:`last_day_of_month` for ``timestamp with time zone`` values. (:issue:`2851`)

https://github.com/prestosql/presto/issues/2851 https://github.com/prestosql/presto/pull/2852

dain commented 4 years ago 
Security
--------
* Add access control checks for query execution, view query, and kill query. This can be configured using :ref:`query_rules` in the file based system access control. (:issue:`2213`)

2213

findepi commented 4 years ago 
Hive
* Fix query failure when using Glue metastore and table's storage descriptor has no properties. (:issue:`2905`)
* Respect ``bucketing_version`` table property when using Glue metastore. (:issue:`2905`)

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

sopel39 commented 4 years ago 
Hive
----

* Add support for bucket sort order in Glue when creating or updating table or partition. (:issue:`1870`)

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

findepi commented 4 years ago 
UI
* Fix display of data size values. (:issue:`2810`)

https://github.com/prestosql/presto/issues/2810 https://github.com/prestosql/presto/pull/2867

findepi commented 4 years ago 
UI
* Fix redirect from ``/`` to ``/ui/`` when Presto is run behind a proxy. (:issue:`2908`)

https://github.com/prestosql/presto/issues/2908 https://github.com/prestosql/presto/pull/2916

martint commented 4 years ago 
SPI
* Add support for row filtering and column masking via the ``getRowFilter()`` and ``getColumnMask()`` APIs in ``SystemAccessControl`` and ``ConnectorAccessControl``. (:issue:`1480`)

1480

findepi commented 4 years ago 
UI
* Fix ``Prepared Query`` section for :doc:`/sql/prepare` queries. (issue:`2784`)

https://github.com/prestosql/presto/issues/2784 https://github.com/prestosql/presto/pull/2871

findepi commented 4 years ago 
Hive
* Allow data conversion when reading decimal data from Parquet files and precision or scale in the file schema 
  is different from the precision or scale in partition (table) schema. (:issue:`2823`)

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

martint commented 4 years ago 
Hive
* Add option to enforce that a filter on a partition key be present in the query. This can be enabled by setting the 
  ``hive.query-partition-filter-required`` config property or the ``query_partition_filter_required`` session property 
  to ``true``. (:issue:`2334`)

2334

findepi commented 4 years ago 
General
* Correctly reject ``date`` literals that cannot be represented in Presto. (:issue:`2888`)

https://github.com/prestosql/presto/issues/2888 https://github.com/prestosql/presto/pull/2949

martint commented 4 years ago 
* Fix excessive runtime when parsing deeply nested expressions with unmatched parenthesis. (:issue:`2968`)

2968

Praveen2112 commented 4 years ago 
General 
 * Fix join failures for queries involving OR predicate with non comparable functions

2861

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

* Enable dynamic filtering by default. (:issue:`2793`)

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

sopel39 commented 4 years ago 
Hive
----

* Fix Hive connector deadlock when Hive caching is enabled with refresh TTL. (:issue:`2984`)

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

kokosing commented 4 years ago 
Security
—-
 - Prevent displaying columns of tables that user has no privilege granted in file based access control. (:issue:`2925`)

2925

findepi commented 4 years ago 
CLI
* Fix formatting of ``varbinary`` in nested data types. (:issue:`2858`)

https://github.com/prestosql/presto/issues/2858 https://github.com/prestosql/presto/pull/2870

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

* Show reorder join cost in ``EXPLAIN ANALYZE VERBOSE`` (:issue:`2725`)

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

kokosing commented 4 years ago 
SPI
----
- Add access control check for executing procedure. (:issue:`2924`)

2924

findepi commented 4 years ago 
Hive
* Allow selecting ``Intelligent-Tiering`` S3 storage class when writing data to S3. This can be enabled using
  ``hive.s3.storage-class=INTELLIGENT_TIERING`` catalog configuration property. (:issue:`3032`)

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

kokosing commented 4 years ago 
Security:
---
 - Add ``ALTER SCHEMA ... SET AUTHORIZATION`` syntax that allows to change the owner of the schema. (:issue:`2673`)

Hive:
 - Add  support for``ALTER SCHEMA ... SET AUTHORIZATION`` statement. (:issue:`2673`)

Iceberg:
 - Add  support for``ALTER SCHEMA ... SET AUTHORIZATION`` statement. (:issue:`2673`)

2673

findepi commented 4 years ago 
Hive
* Fix incorrect results of metadata queries and reads from ``information_schema`` tables
  where connecting to Hive 3 metastore. (:issue:`3008`)
* Hide ``sys`` Hive system schema. It is hidden for security reasons. (:issue:`3008`)

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

findepi commented 4 years ago 
General
* Allow configuring resource groups selection based on user's groups. (:issue:`3023`)

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

sopel39 commented 4 years ago 
Hive
----

* Improve performance of partition fetching from Glue. (:issue:`3024`)

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

electrum commented 4 years ago 
General Changes
----

* Add support for large prepared statements. (:issue:`2719`)

2719

electrum commented 4 years ago 
JDBC Driver Changes
---

* Implement ``PreparedStatement.getMetaData()``. (:issue:`2770`)

2770

electrum commented 4 years ago 
General Changes
---

* Add :doc:`/connector/bigquery`. (:issue:`2532`)

2532

electrum commented 4 years ago 
Other Connector Changes
-----------------------

These changes apply to the MemSQL, MySQL, PostgreSQL, Redshift, Phoenix, and SQL Server connectors.

* Add support for dropping schemas. (:issue:`2956`)

2956

findepi commented 4 years ago 
CLI
* Add ``--timezone`` parameter. (:issue:`2961`)

https://github.com/prestosql/presto/pull/2977 https://github.com/prestosql/presto/issues/2961

findepi commented 4 years ago 
MongoDB
* Fix incorrect pushdown. Previously, the connector would return incorrect results for pushdown on certain types. (:issue:`1781`)

https://github.com/prestosql/presto/issues/1781 https://github.com/prestosql/presto/pull/3053