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.46k stars 3.01k forks source link

Release notes for 340 #4527

Closed martint closed 4 years ago

martint commented 4 years ago

Dain Sundstrom

findepi commented 4 years ago
Hive
* Improve performance when querying tables with ``skip.header.line.count`` property set to 1. (:issue:`4513`)

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

ebyhr commented 4 years ago
MongoDB
* Add ``mongodb.max-connection-idle-time`` properties to limit the maximum idle time of a pooled connection. ({issue}`4483`)

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

findepi commented 4 years ago
Hive
* Allow creating a table with ``external_location`` when schema's location is not valid. (:issue:`4069`)

https://github.com/prestosql/presto/issues/4069 https://github.com/prestosql/presto/pull/4279

losipiuk commented 4 years ago
Kafka
* Add INSERT support for Raw data format. (:issue:`4417`)

https://github.com/prestosql/presto/pull/4417 https://github.com/prestosql/presto/issues/3980

findepi commented 4 years ago
PostgreSQL
* Push down `count()` aggregation over constant expression (e.g. `count(1)`). {issue}`4362`

https://github.com/prestosql/presto/issues/4362 https://github.com/prestosql/presto/pull/4473

findepi commented 4 years ago
Hive
* Add read support for tables that were created as non-transactional and converted to be
  transactional later. ({issue}`2293`)

https://github.com/prestosql/presto/issues/2293 https://github.com/prestosql/presto/pull/2930

martint commented 4 years ago
* Add support for query parameters in `LIMIT`, `OFFSET` and `FETCH FIRST` clauses. ({issue}`4529`, {issue}`4601`)

4529

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

findepi commented 4 years ago
Hive
* Allow creation of transactional tables. Note: inserts to transactional tables
  are still not supported. ({issue}`4516`)

https://github.com/prestosql/presto/pull/4516 https://github.com/prestosql/presto/pull/4574

findepi commented 4 years ago
Hive
* Fix query failure when S3 data location contains `_$folder$` Hadoop s3n marker object. ({issue}`4552`)

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

sopel39 commented 4 years ago
General
* Improve dynamic partition pruning for short queries. ({issue}`4388`}

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

kokosing commented 4 years ago
General
* Expose information about query type in query Event Listener. ({issue}`4592`)

4592

ebyhr commented 4 years ago
Phoenix
* Fix ``NullPointerException`` when listing schemas. ({issue}`4560`)

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

martint commented 4 years ago
* Fix failure when duplicate expressions are referenced in the `GROUP BY` clause. ({issue}`4609`)

4609

findepi commented 4 years ago
JDBC
* Fix handling of dates and timestamps before the 20th century. ({issue}`4563`)

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

sopel39 commented 4 years ago
Hive
* Add feature toggle (`hive.metastore.glue.max-error-retries`) for configuring number of retries in Glue client. ({issue}`4611`)

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

sopel39 commented 4 years ago
General
* Reduce CPU load by cancelling query stages from which data is no longer required. ({issue}`4290`)

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

sopel39 commented 4 years ago
General
* Reduce query memory usage by improving retained size estimation for `VARCHAR` and `CHAR` types. ({issue}`4123`)

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

findepi commented 4 years ago
Kafka
* Add insert support for JSON. ({issue}`4477`)

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

martint commented 4 years ago
* Fix potential hang during query planning ({issue}`4635`).

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

ebyhr commented 4 years ago
Kafka
* Remove unused ``kafka.connect-timeout`` configuration properties. ({issue}`4664`)

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

dain commented 4 years ago
Hive
* Add support for Java Key Store (extending existing PEM support) to Thrift Hive meta store TLS configuration. ({issue}`4432`)

4432

sopel39 commented 4 years ago
General
* Improve query performance for queries containing ``starts_with`` predicates. ({issue}`4669`)

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

martint commented 4 years ago
SPI
* Add support for TopN pushdown via the `ConnectorMetadata.applyLimit()` method. ({issue}`4249`)

4249

kokosing commented 4 years ago
Security
* Verify access to referenced table in `CREATE TABLE LIKE`. ({issue}`4472)

4472

ebyhr commented 4 years ago
Hive
* Fix type coercion failure when the schema evolved without type changes. ({issue}`3967`)

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

martint commented 4 years ago
* Add bitwise shift functions. ({issue}`772`)

https://github.com/prestosql/presto/issues/722

martint commented 4 years ago
Elasticsearch
* Fix failure when index mapping is missing. ({issue}`4535`)

4535

kokosing commented 4 years ago
Hive
* Expose hit rate statistics for Hive metastore cache via JIMX. ({issue}`4458`)

4458

kokosing commented 4 years ago
General
 * Add `IF EXISTS `and `IF NOT EXISTS` syntax to `ALTER TABLE`. ({issue}`4651`)

4651

Praveen2112 commented 4 years ago
Phoenix
* Add table level property to specify data block encoding when creating Phoenix tables

4617

sopel39 commented 4 years ago
General
* Improve performance of queries that use decimal data type. ({issue}`4730`)

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

electrum commented 4 years ago
General
* Include remote host in error info for page transport errors. ({issue}`4511`)

4511

electrum commented 4 years ago
General
* Add {func}`luhn_check`. ({issue}`4011`)

4011

electrum commented 4 years ago
## SPI Changes

* Deprecate the older variants of `ConnectorSplitManager.getSplits()`. ({issue}`4508`)

4508

electrum commented 4 years ago
## Hive Changes

* Improve performance of reading JSON tables. ({issue}`4705`)

4705

electrum commented 4 years ago
## General Changes

* Enable HTTP/2 by default for internal communication. This can be disabled using the
  `internal-communication.http2.enabled` configuration property. ({issue}`4696`)

4696

martint commented 4 years ago
* Add experimental support for recursive queries. ({issue}`4250`)

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