Presto: Release notes for 310

[electrum]

Dain Sundstrom

• [x] all checked
• 04-30 11:01:29 14feea590c Reduce the identifier length in generated code for nested columns
• 04-30 12:11:42 0736c51e36 Add decimal coercions for table/partition mismatch in Hive connector
• 04-30 12:11:42 4a456a88b5 Adding double to float coercer
• 04-30 12:11:42 ab70612eb6 refactor Hive Coercion code structure to make it more clear
• 04-30 12:11:42 f0eb4f32f3 cast between floating-point value and fixed precision decimal
• 04-30 12:48:54 e34b134ea6 Consolidate decimal cast code into DecimalConversions

• 04-30 15:35:24 e1dffc25a6 Add totalAvailableProcessors to ClusterStatsResource

  David Phillips

• [x] all checked

• 04-29 12:25:42 c7cc72d7ed Skip Hive boolean column stats when false count is -1
• 04-29 13:00:42 572a33740e Fix information_schema failure for Hive bad storage format
• 04-29 15:57:28 d90167ca1f Move HDFS wire encryption docs to correct section
• 04-29 15:58:38 a3809f4f8d Remove bogus enabled check for PushPredicateIntoTableScan
• 04-29 16:48:06 b910eab41c Update Hadoop Linux-amd64 libraries to use glibc 2.5
• 05-01 23:29:07 ab5702fc5e Make query time in cli consistent with QueryStats
• 05-02 14:09:01 ecf231c791 Update to Airlift 0.181
• 05-02 14:11:10 69cb7ef138 Simplify Jackson handle module creation

• 05-02 17:14:13 7df0eecf3a Hide support for PostgreSQL arrays behind a config switch

  Grzegorz Kokosiński

• [x] all checked

• 04-26 00:58:40 f6a3651a86 Log node host name resolution exception
• 04-26 12:40:05 a1698e5b4e Fix formattiong in presto-server-rpm/pom.xml
• 05-01 06:15:48 207665e34d Minor bug fix in BlackHoleConnector
• 05-01 06:19:25 790b4ab1d7 Move RebindSafeMBeanServer to presto-plugin-toolkit

• 05-01 06:19:25 eaa177f9c9 Extract MBeanServerModule

  Karol Sobczak

• [x] all checked

• 04-30 09:07:50 0342e6a397 Allow PrestoS3FileSystem and GlueHiveMetastore to assume an aws role
• 05-01 10:29:59 17ead04503 Add methods for creating user and revocable memory contexts
• 05-01 10:29:59 1f8c556abc Do not take into account negative allocations for reporting
• 05-01 10:29:59 706def2e1d Implement TableScanWorkProcessorOperator
• 05-01 10:29:59 9459241458 Assure new page is loaded when it's stored in GroupedTopNBuilder
• 05-01 10:29:59 afd93f24a1 Extract TopNProcessor
• 05-01 10:29:59 b30c856b65 Implement TopNWorkProcessorOperator
• 05-01 10:29:59 b3acfe7da7 Add initial WorkProcessor operator pipelines support
• 05-01 10:29:59 c92bf50c61 Run selected test queries with work processor pipelines enabled
• 05-01 10:29:59 cdcfd98173 Add WorkProcessor#finishWhen method
• 05-01 10:29:59 f6a3b24d0f Move test WorkProcessor methods to WorkProcessorAssertion
• 05-02 06:20:44 c69f21473c Set default Metastore recording duration to 10m
• 05-02 09:20:33 6743549f05 Fix typo in config property

• 05-02 10:36:24 0d155116f5 Improve Hive assume role config properties description

  Martin Traverso

• [x] all checked

• 04-25 20:29:43 69a6bf9d20 Tighten equality inference for expressions involving casts
• 04-29 12:52:34 ac69d48935 Render output layout in a separate line

• 05-01 17:51:42 ebcebd09a7 Make expression matcher symmetric for comparison expressions

  Piotr Findeisen

• [x] all checked

• 04-25 23:09:10 05a812bd14 Use proper APIs when getting array element type in PostgreSQL
• 04-30 03:01:09 8123d116a6 Reduce product tests' memory footprint
• 04-30 03:01:09 d800900d01 Code cleanup

[sopel39]

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

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

[dain]

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

352

[kokosing]

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

550

[sopel39]

-------

* 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`)

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

[sopel39]

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

https://github.com/prestosql/presto/pull/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]

----
* 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]

-------

* 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