Release notes for 310

[electrum]

Dain Sundstrom

• all checked
• 04-30 11:01:29 14feea5 Reduce the identifier length in generated code for nested columns
• 04-30 12:11:42 0736c51 Add decimal coercions for table/partition mismatch in Hive connector
• 04-30 12:11:42 4a456a8 Adding double to float coercer
• 04-30 12:11:42 ab70612 refactor Hive Coercion code structure to make it more clear
• 04-30 12:11:42 f0eb4f3 cast between floating-point value and fixed precision decimal
• 04-30 12:48:54 e34b134 Consolidate decimal cast code into DecimalConversions
• 04-30 15:35:24 e1dffc2 Add totalAvailableProcessors to ClusterStatsResource

David Phillips

• all checked
• 04-29 12:25:42 c7cc72d Skip Hive boolean column stats when false count is -1
• 04-29 13:00:42 572a337 Fix information_schema failure for Hive bad storage format
• 04-29 15:57:28 d90167c Move HDFS wire encryption docs to correct section
• 04-29 15:58:38 a3809f4 Remove bogus enabled check for PushPredicateIntoTableScan
• 04-29 16:48:06 b910eab Update Hadoop Linux-amd64 libraries to use glibc 2.5
• 05-01 23:29:07 ab5702f Make query time in cli consistent with QueryStats
• 05-02 14:09:01 ecf231c Update to Airlift 0.181
• 05-02 14:11:10 69cb7ef Simplify Jackson handle module creation
• 05-02 17:14:13 7df0eec Hide support for PostgreSQL arrays behind a config switch

Grzegorz Kokosiński

• all checked
• 04-26 00:58:40 f6a3651 Log node host name resolution exception
• 04-26 12:40:05 a1698e5 Fix formattiong in presto-server-rpm/pom.xml
• 05-01 06:15:48 207665e Minor bug fix in BlackHoleConnector
• 05-01 06:19:25 790b4ab Move RebindSafeMBeanServer to presto-plugin-toolkit
• 05-01 06:19:25 eaa177f Extract MBeanServerModule

Karol Sobczak

• all checked
• 04-30 09:07:50 0342e6a Allow PrestoS3FileSystem and GlueHiveMetastore to assume an aws role
• 05-01 10:29:59 17ead04 Add methods for creating user and revocable memory contexts
• 05-01 10:29:59 1f8c556 Do not take into account negative allocations for reporting
• 05-01 10:29:59 706def2 Implement TableScanWorkProcessorOperator
• 05-01 10:29:59 9459241 Assure new page is loaded when it's stored in GroupedTopNBuilder
• 05-01 10:29:59 afd93f2 Extract TopNProcessor
• 05-01 10:29:59 b30c856 Implement TopNWorkProcessorOperator
• 05-01 10:29:59 b3acfe7 Add initial WorkProcessor operator pipelines support
• 05-01 10:29:59 c92bf50 Run selected test queries with work processor pipelines enabled
• 05-01 10:29:59 cdcfd98 Add WorkProcessor#finishWhen method
• 05-01 10:29:59 f6a3b24 Move test WorkProcessor methods to WorkProcessorAssertion
• 05-02 06:20:44 c69f214 Set default Metastore recording duration to 10m
• 05-02 09:20:33 6743549 Fix typo in config property
• 05-02 10:36:24 0d15511 Improve Hive assume role config properties description

Martin Traverso

• all checked
• 04-25 20:29:43 69a6bf9 Tighten equality inference for expressions involving casts
• 04-29 12:52:34 ac69d48 Render output layout in a separate line
• 05-01 17:51:42 ebcebd0 Make expression matcher symmetric for comparison expressions

Piotr Findeisen

• all checked
• 04-25 23:09:10 05a812b Use proper APIs when getting array element type in PostgreSQL
• 04-30 03:01:09 8123d11 Reduce product tests' memory footprint
• 04-30 03:01:09 d800900 Code cleanup

[sopel39]

Hive
----
* Add support for assuming AWS role when accessing S3 or Glue. (:issue:`698`)

#698

[dain]

Hive
----
* Add support for coercions between ``DECIMAL``, ``DOUBLE``, and ``REAL`` for partition and table schema mismatch. (:issue:`352`)

#352

[kokosing]

Blackhole
---
* Support having tables with same name in different Blackhole schemas. (:issue:`550`)

#550

[sopel39]

General
-------

* Add initial and experimental support for late materialization.
  This feature can be enabled via `experimental.work-processor-pipelines`
  feature config or via `work_processor_pipelines` session config.
  Simple select queries of type `SELECT ... FROM table ORDER BY cols LIMIT n` can
  experience significant CPU and performance improvement. (:issue:`602`)

#602

[sopel39]

Hive
----
* Fix typo in Metastore recorder duration property name. (:issue:`711`)

#711

[martint]

* Add support for ``FETCH FIRST`` syntax. (:issue:`666`)

#666

[martint]

* Improve performance of ``JOIN`` queries involving join keys of different types. (:issue:`665`)

#665

[dain]

General
----
* Reduce compilation failures for expressions over types containing a extremely large number of nested types. (:issue:`537`)

#537

[electrum]

CLI Changes
---
* Make the final query time consistent with query stats. (:issue:`692`)

#692

[electrum]

Hive Connector Changes
---
* Ignore boolean column statistics when the count is ``-1``. (:issue:`241`)

#241

[electrum]

Hive Connector Changes
---
* Prevent failures for ``information_schema`` queries when a table has an invalid storage format. (:issue:`568`)

#568

[sopel39]

General
-------

* Fix error reporting when query fails with due to running out of memory. (:issue:`696`)

#696

[electrum]

PostgreSQL Connector Changes
---
* Support for the ``ARRAY`` type has been disabled by default.  (:issue:`687`)

#687

We might want to expand on this