Release notes for 332

[martint]

Dain Sundstrom

• [x] all checked
• 03-18 11:29:26 540e14c7f1 Rubix integration
• 03-25 12:00:53 08cc9b08a8 Rename Hive caching configuration properties
• 03-25 12:00:53 bbdc22be7d Only bind Rubix config when caching is enabled
• 03-26 07:37:33 94057fad64 Add default implementation for Type object methods to slice methods
• 03-26 07:37:33 fca1b86976 Simplify aggregation compiler
• 04-05 22:32:57 3195d8a3bb Use platform classloader in Java 8 and 11 for plugins
• 04-05 22:32:57 af9f58a96c Fix warnings in PluginClassLoader

  David Phillips

• [x] all checked
• 03-17 09:09:50 27092e326c Allow public access to ParquetPageSourceFactory#createParquetPageSource
• 03-18 01:26:32 cbf0d04b76 Add support for Alluxio Hive metastore
• 03-20 12:40:30 b33f9000d4 Remove unnecessary exclusion
• 03-20 13:05:58 73c59fdbb5 Cleanup table of contents for select documentation
• 03-20 20:56:56 13c0c4b6b0 Fix formatting in hive-hadoop2 POM
• 03-21 11:00:47 801a67e64a Add anchor links for section headers
• 03-24 16:34:03 71ebbdcad9 Fix logger argument order for event listener
• 03-24 22:34:51 21b3efe933 Use Slice methods to access byte array
• 03-24 23:32:42 a7cbe8008b Bump aircompressor version to 0.16
• 03-24 23:46:18 28d7d20983 Add EmptyCredentialProvider
• 03-24 23:46:18 6a4a18892f Minor cleanup of KeyStoreUtils
• 03-24 23:46:18 aa9506c446 Split up BaseJdbcAuthenticationConfig
• 03-24 23:46:18 e6cddf029f Use explicit modules in CredentialProviderModule
• 03-24 23:47:45 41651aa23a Add clientInfo parameter to JDBC driver
• 03-24 23:47:45 67249458fc Add traceToken parameter to JDBC driver
• 03-24 23:48:00 65d719ecc2 Remove unused dependencyManagement entries
• 03-25 11:20:43 94472a5c21 Remove usage of String.format in HTTP client hot path
• 03-27 23:49:55 56990b55ce Fix SQL formatting for nested alias or sample
• 03-30 02:54:52 0970e62907 Allow custom projection and relation in QueryBuilder
• 03-30 15:38:43 275db6a8e0 Update Alluxio documentation in Hive connector docs
• 03-30 15:53:48 cb98a8ac67 Cleanup validation errors in HiveWriterFactory
• 03-31 15:35:48 1be444dc6d Update GitHub Actions checkout to v2
• 03-31 17:27:27 0c13d169dc Move engine-only tests
• 03-31 17:27:27 478d6f7357 Test concurrent scans in AbstractTestIntegrationSmokeTest
• 03-31 17:27:27 8bfc7f5f7e Remove unused method
• 04-01 11:15:18 9e6a3f7b77 Remove unused bindings from IcebergModule
• 04-01 11:18:00 021dda102c Optimize Slice Functions to avoid Slice.getBytes()
• 04-01 11:18:00 53c5dfcba1 Avoid Slice.getBytes() in parquet reader
• 04-01 11:18:00 f2bf370305 Remove copy from InMemoryRecordSet
• 04-01 11:18:00 f64f1b6a1a Use JSON generator Base64 conversion in BlockJsonSerde
• 04-01 14:38:02 69709fcf6a Remove config elasticsearch.aws.use-instance-credentials
• 04-01 14:38:02 6bf2649f48 Add S3 security mapping
• 04-01 14:38:02 7659848337 Remove config hive.s3.use-instance-credentials
• 04-01 14:38:02 ad7631cccf Remove config hive.metastore.glue.use-instance-credentials
• 04-01 14:38:02 ee91f737e9 Allow setting identity for TestingConnectorSession
• 04-02 13:04:17 6800e80aaa Capitalize title for Group Provider
• 04-02 16:24:28 0652e04e69 Add iceberg to product tests suite
• 04-02 16:24:28 80c1013de0 Temporarily exclude iceberg from Kerberos product tests
• 04-03 11:30:17 8e3cbbc613 Free disk space before running product tests
• 04-03 14:10:21 1d9cc7d64d Free disk space in checks workflow
• 04-04 16:33:18 7880787998 Handle empty and arbitrary slices in Parquet reader
• 04-05 12:57:20 c984f64ed9 Support exclusions in InterfaceTestUtils
• 04-05 12:57:21 5e466fb5e6 Ensure StatisticsAwareJdbcClient implements all methods
• 04-05 12:57:21 7e7bbc7f6a Move JdbcClientStats to upper level
• 04-05 12:57:21 bcea275371 Ensure CachingJdbcClient delegates all unhandled methods
• 04-05 14:06:19 317eb98f84 Add session token support to PrestoS3FileSystem
• 04-05 14:06:19 ab595fae7d Remove unnecessary test in TestPrestoS3FileSystem
• 04-05 23:34:59 588e502c2a Allow Hive on S3 to assume AWS role with External ID

  Grzegorz Kokosiński

• [x] all checked
• 03-17 00:50:01 7dd3d18952 Use catalog name in S3 statistics name
• 03-17 01:42:44 0039dd8b29 Add execute function access control
• 03-17 01:42:44 05cd9d13d4 Use static import
• 03-17 01:42:44 42b234ecc0 Rename testViewAccessControl to emphasis focus on columns
• 03-17 01:42:44 44a36898ce Improve robustness of InitializeSystemAccessControl
• 03-17 01:42:44 6855c46068 Move createExpression to ExpressionTestUtils
• 03-17 01:42:44 a0f113cc11 Wrap expression test utilities with transaction
• 03-17 01:42:44 f618b3aa5c Match error message with access control check method
• 03-17 03:23:42 cb9673a679 Make assertion to be connector agnostic
• 03-17 03:25:02 0b09aef1d2 Allow to pass additional modules to DistributedQueryRunner
• 03-17 03:25:02 33853c60cb Fallback to delegate for masks and filters
• 03-17 03:25:02 6c51143263 Allow to set custom system access control for tests
• 03-17 03:25:02 a4d3c21c08 Use Optional for nullable variables
• 03-17 03:25:02 c5012cca2d Introduce builder for TestingPrestoServer
• 03-17 03:25:02 d06e9dd094 Fix formatting
• 03-17 03:25:02 e70e47d5df Remove unused parserOptions parameter
• 03-17 05:59:16 7382569979 Quiet fast install mvn
• 03-17 06:00:50 c15d00e720 Refactor memory connector
• 03-17 07:33:59 c37226b92f Add default access-control.properties file
• 03-17 09:40:57 646ed33c21 Extract hdp3 tests to separate suite
• 03-18 06:38:21 1f9088dc57 Make access denied messages consistent for SHOW STATS
• 03-18 06:38:21 8167b73f2f Check SELECT permissions for SHOW STATS FOR
• 03-18 06:38:21 c2e37a4db6 Allow subsets of columns in SHOW STATS FOR (SELECT)
• 03-19 01:42:29 72a7511a53 Support multiple event listener plugins
• 03-19 02:17:14 ce59c62ce2 Use testcontainers for kudu unit tests
• 03-19 04:59:58 13fa220356 Prefer variable over its value
• 03-19 14:04:18 52e19be2a2 Extract common configuration for Kerberos KMS
• 03-20 00:48:58 c9cd1df878 Remove unused profiles in kudu's maven
• 03-20 11:23:29 3c7ceec231 Add TEMPTO_CONFIG_FILES support to the test container
• 03-22 14:44:17 aafe4797c3 Return table metadata for translated Hive views
• 03-22 14:44:17 ee4cf9369b Use existing method
• 03-23 02:09:58 d3b5711fa8 Remove unused TEMPTO_EXTRA_CONFIG_FILE
• 03-23 02:15:32 9b0bf150a6 Ensure kafka splits do not overlap
• 03-23 12:13:46 bbf40d6db1 Upgrade tempto to 174
• 03-23 14:27:19 48909a79a4 Cleanup in ShowStatsRewrite
• 03-23 14:27:19 9e77535bed Disallow SHOW STATS for tables with filters and masking
• 03-23 14:27:19 ac1a20aad4 Factor out getting query for SHOW STATS
• 03-25 04:03:51 dc7ee78799 Use unique table names in tests
• 03-26 01:32:13 9316dabab6 Update maven to 3.6.3
• 03-26 01:55:52 385d826b15 Support schema evolution in partition schema for Parquet
• 03-26 01:55:52 5790ed02c0 Extract getTableToPartitionMapping method
• 03-26 01:55:52 a93b3b849a Support partition schema evolution for ORC
• 03-26 01:55:52 d30260f88d Introduce TableToPartitionMapping
• 03-26 05:20:08 c62673c113 Add support for CREATE SCHEMA name AUTHORIZATION
• 03-26 07:31:15 7096b7e8e4 Fix 'build.plugins.plugin.version missing' warning for provisio plugin
• 03-26 07:31:15 873a025d84 Remove unused throws Exception clauses
• 03-26 07:31:15 9ee1b27186 Update comments and messages to include JDK 11 support
• 03-26 07:31:15 f1e6348dbb Fix names of packages in install/remove commands
• 03-27 02:43:27 3346df3b81 Extract EventsAwaitingQueries
• 03-27 02:43:27 e38de1b0ae Allow Connector to provide EventListener
• 03-27 07:27:26 64a0a6be98 Use unique table names in tests
• 03-27 07:27:26 a038349449 Fix failure message
• 03-27 07:27:26 dd3b63d7cb Fix formatting
• 03-27 08:33:25 d7f2694214 Use caching metastore in tests
• 03-30 12:08:08 d19365e9d0 Allow JDBC connectors to provide system tables
• 03-30 12:13:37 789a3056ea Extract createTableSql
• 03-30 12:13:37 a6dc7fd931 Fix formatting
• 04-01 06:53:47 f922c85873 Add access control check while listing views
• 04-03 05:45:51 1a08b547ac Remove unused method
• 04-03 05:45:51 614eb50b74 Remove unused tableHandles field
• 04-03 05:45:51 f12c107d14 Add updateType to query event
• 04-05 10:59:26 7138dcecfd Use unique table name in test
• 04-06 02:28:19 a2b30a92c2 Use unique table names in distributed tests

  Karol Sobczak

• [x] all checked
• 03-18 06:10:56 b343cc96d6 Use updatable page source when effectivePredicate is None due to dynamic filters
• 03-18 06:12:23 c683e77e53 Refactor toCompactTupleDomain to reuse Domain#simplify
• 03-24 04:24:26 eeccf995dd Bump aws-sdk version
• 03-25 03:13:59 3d65a87e00 Update benchto version to 0.9
• 03-26 03:01:30 98e243372b Fix message
• 03-26 03:01:30 ef358a28db Stop at first LDAP match when distinguished name is not required
• 03-26 08:08:27 047d75056b Make push-aggregation-through-join name consistent with it's function
• 03-26 08:08:27 0d8b11e8ce Add optimizer.push-partial-aggregation-through-join feature config
• 03-26 08:08:27 b68f54444b Fix method name
• 03-27 03:23:45 ca1a69a40f Add dynamicFilterSplitsProcessed to OperatorStats
• 04-01 08:48:16 728be1ac24 Add support for Glue endpoint URL
• 04-02 03:02:58 20f15139d5 Fix Glue config null check
• 04-02 03:02:58 6c9adf57de Static import newOptionalBinder
• 04-02 03:02:58 e70158597a Add support for custom Glue request handlers

  Martin Traverso

• [x] all checked
• 03-16 15:25:19 b11397fe6c Support column reordering in cross join
• 03-17 14:16:44 073e62745c Add Project-off rule for ApplyNode
• 03-17 14:16:44 810f704434 Add rule for pruning ApplyNode's subquery columns
• 03-17 14:16:44 8dc234b5cb Pass Context to Project-off rules
• 03-19 10:52:34 6a590dcea5 Fix reading from large Parquet files
• 03-20 11:09:10 31b2ed6257 Optimize parquet gzip decompression
• 03-23 14:25:14 0962e3a9d5 Include filtered columns in EXPLAIN (TYPE IO)
• 03-24 11:02:41 171de47b57 Fix formatting
• 03-24 11:02:41 60736fead7 Use left and right output symbol lists for JoinNode execution planning
• 03-24 11:02:41 c25c42f2f6 Refactor output symbols list in JoinNode
• 03-24 12:08:29 a828cec06e Add Project-off rule for CorrelatedJoinNode
• 03-27 09:50:08 1aeffe5044 Use optional to represent missing node
• 03-27 09:50:08 1b55b866f3 Record filter and mask information in query event
• 03-27 09:50:08 282475a0b3 Unwrap catalog name
• 03-27 09:50:08 4939b99ee1 Derive target table from analysis
• 03-27 09:50:08 83e9fa1d04 Factor out common filter/mask code
• 03-27 09:50:08 9aae4eb572 Move Output to analyzer package
• 03-27 15:17:58 9ba45102d3 Take the credentials project id before the environment one
• 03-30 07:51:46 4f9846f240 Record referenced routines in query event
• 03-30 16:31:47 135fad233d Add SqlBaseParser initializer hook and refreshable ATN caches
• 03-31 08:00:04 3ec9ee726d Move check for symbol pruning in cross join
• 03-31 08:00:04 54946a1822 Support cross join outputs pruning in PruneUnreferencedOutputs
• 03-31 08:00:04 ee6b6eeb90 Support cross join in join pruning columns rules
• 03-31 08:00:04 fbf4064a5d Remove dedicated rule for pruning cross join columns
• 03-31 17:11:42 27af6fb128 Add Project-off rule for EnforceSingleRowNode
• 03-31 17:12:52 617f5854ff Add Project-off rule for AssignUniqueId
• 03-31 17:25:36 0c8668b2cd Fix symbol pruning in set operation nodes
• 04-04 20:14:39 13a3c523f2 Report field name when decoding Elasticsearch value fails
• 04-04 20:16:22 fb69cc4dd3 Add instructions on how to start Elasticsearch
• 04-04 20:16:52 44438f2366 Call applyProjection during table scan column pruning
• 04-04 20:22:20 8fad160288 Add Project-off rule for UnionNode
• 04-04 20:22:20 b99da44f7e Add column-pruning rules for set operation nodes
• 04-04 20:22:52 2fd1c54a8c Fix formatting
• 04-04 20:22:52 6496319429 Add column-pruning rule for DistinctLimitNode

  Piotr Findeisen

• [x] all checked
• 03-17 09:30:12 1fadfa7ce7 Get timestamp from ObjectId
• 03-17 09:30:12 3895d6fa4e Simplify function declaration
• 03-18 05:04:43 ca99a3fa6e Quote table and partition name in error messages
• 03-18 05:20:48 2fde0f1168 Remove some ambiguous static imports
• 03-18 05:20:48 47b26c20cf Prefer JDK method where applicable
• 03-18 07:08:20 f638ff5e34 Fix expected error messages
• 03-18 09:23:30 ff2ee77a60 Allow setting permissions for new directories
• 03-18 09:46:45 80fdb38082 Update to airbase 98
• 03-19 03:55:37 87c1a806d4 Validate configuration in noop connector
• 03-19 04:49:53 574f5fe927 Fix documentation for presto-server-rpm
• 03-19 06:08:36 10855a02fb Add TupleDomain#simplify overload accepting threshold
• 03-19 06:08:54 e59b82dad9 Remove redundant Guice annotation
• 03-19 07:58:39 7300158a48 Introduce common CatalogName
• 03-19 09:55:35 5b546ba00d Use simpler always-false expression
• 03-19 09:55:35 fc2d08e0ae Perform cheap check first
• 03-19 10:35:06 7d2086098e Create group provider configuration for product tests
• 03-20 07:31:30 4dfc89c05a Short-circuit TupleDomain#simplify for 'all'
• 03-23 01:50:05 2ed560969a Embed version once
• 03-23 09:27:08 6432ceeb1d Extract Field constant
• 03-23 09:27:08 91e5d5a993 Fix reflective field access
• 03-24 00:03:05 471c7b7256 Run product tests with hive.fs.new-directory-permissions
• 03-24 05:17:37 4d668978a8 Run predicate pushdown test without dynamic filtering too
• 03-24 05:17:37 975edb7571 Rename test class
• 03-24 08:50:44 4ac2fd48cb Remove redundant setup
• 03-24 08:50:44 61084fd545 Run Join tests with dynamic filtering disabled too
• 03-24 08:50:44 7bb27ac73b Remove obsolete TODO
• 03-24 08:50:44 7c9f9f285e Remove obsolete comment
• 03-24 08:50:44 b303009e70 Run Join test queries for Hive with dynamic filtering disabled too
• 03-25 08:31:00 3cdd64fc36 Add --debug option for Launcher
• 03-25 08:31:00 4574aa158c Fix variable name
• 03-25 08:31:00 cf20750bfd Fix formatting
• 03-25 08:31:00 f17762c47e Fix method name
• 03-25 08:31:57 64a529301a Trim whitespace when loading configuration
• 03-26 03:26:27 22a062cca0 Remove redundant method argument
• 03-26 03:27:25 1650d074ef Run selected PPD tests with dynamic filtering too
• 03-27 04:48:34 eaa04c33e4 Fix predicate push-down accuracy
• 03-27 07:37:48 f1e43e60ef Show meaningful error when connector returns invalid table property
• 03-28 11:58:08 e7fcdc240e Add column-pruning rule for DeleteNode
• 03-28 11:58:44 49a1a21c74 Remove unused field
• 03-28 15:31:59 7928dfc563 Run multinode product tests' worker on Java 11
• 03-28 15:32:28 15bad291e5 Log Java version during startup
• 03-29 00:59:50 d3eb25b15a Report formatted SQL when does not parse
• 03-29 05:25:13 7ecf2382a5 Ensure tests are run with appropriate QueryRunner
• 03-29 08:22:42 5aa29ae775 Avoid File.toString for getting file's path
• 03-30 07:05:38 2dc5691dae Use meaningful identifier in test
• 03-30 07:06:06 f6ad3e5cbd Deprecate createPageSource overload
• 03-30 07:07:57 8384c18a95 Fix condition
• 03-30 07:07:57 99223aba9c Remove redundant condition
• 03-30 07:07:57 b2140097d6 Remove return value from addConstraintPredicates method
• 03-30 14:53:58 6176de11ec Fix to documentation of BigQuery connector.
• 03-30 22:54:00 9521cf3330 Remove result set from google sheets SplitInfo
• 03-30 23:03:50 c5a10414f7 Remove JoinNode constraint
• 03-31 05:38:46 4e1393d493 Extract charReadFunction
• 03-31 05:38:46 51d1eb0a11 Reject impossible rename
• 03-31 05:38:46 a15aac2548 Report actual query when DDL fails
• 03-31 05:38:46 ba3bb4fb40 Extract short-hand execute() method
• 03-31 05:38:46 ebb87a2b62 Simplify test
• 03-31 05:39:01 fa80b8d985 Test OUTER to INNER join normalization
• 03-31 15:32:44 603b7b8455 Prune cross joins more
• 04-02 09:08:57 ed282b32f5 Avoid calling toIntExact on int
• 04-02 09:10:53 acc95522d7 Use type adequate to payload
• 04-02 22:54:50 a311584a28 Add ref anchors
• 04-03 08:00:11 89fc425a0a Make sure containers output is flushed
• 04-03 08:00:11 bc41898ca1 Synchronize containers output
• 04-03 09:45:10 af99ba9ed5 Add legacy config
• 04-03 09:45:10 ecc4dbc00a Reorder arguments in the method
• 04-04 08:51:23 8f8427b4fb Test configuration cleanup

  Praveen Krishna

• [x] all checked
• 03-26 07:33:33 00038d571b Fix incorrect column mapping in KuduRecordCursor
• 03-26 07:33:33 4427fdfbd0 Add distributed tests for Kudu
• 03-26 07:33:33 749a0c5162 Minor cleanup in KuduRecordCursor
• 04-03 09:10:08 c20edd7169 Remove redundant Kudu tests
• 04-03 23:05:36 a3ee83fb70 Add null check for HashStrategy of CustomObjects
• 04-03 23:05:36 b0be04faab Add support for reading decimal in InMemoryRecordSet

  Yuya Ebihara

• [x] all checked
• 03-23 02:25:23 b66262b87d Remove unused method
• 03-23 16:57:08 81fa4ac2b2 Properly list all tables in memory connector
• 03-25 21:56:39 17e9c976ed Fix display error of datetime function document
• 03-25 21:56:39 36db1cadf2 Fix current_user display error of document
• 03-26 03:21:25 3366910fb9 Delete MongoDB document if exists in schema collection

[findepi]

MongoDB
* Add ``objectid_timestamp`` function for getting ``timestamp with time zone`` from ``ObjectId``. (:issues:`3089`)

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

[kokosing]

Security
---
- Verify access to table columns when running ``SHOW STATS``. (:issue:`2665`)
Show stats for permissions

General
--- 
- Support passing subset of columns to ``SHOW STATS``. (:issue:`2665`)

2665

[kokosing]

General 
----
- Support multiple event listener plugins. They can be specified with ``event-listener.config-files`` configuration property. (:issue:`3128`)

3128

[findepi]

Hive
* Add ``hive.fs.new-directory-permissions`` configuration property for setting the permissions of new directories
  created by Presto. Default value is ``0777``. (:issue:`3126`)

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

[ebyhr]

Memory
* List missing views in ``system.jdbc.tables`` table. (:issues:`3208`)

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

[kokosing]

Hive
---
 - Add ``hive.partition-use-column-names`` configuration property and matching ``partition_use_column_names`` catalog session property that allows to match columns between table and partition schemas by names. By default they are mapped by index. (:issue:2933`)

2933

[sopel39]

General
-------

* Fix LDAP authentication not working if user belongs to multiple groups. (:issue:`3206`)

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

[ebyhr]

MongoDB
* Delete document from ``_schema`` collection when DROP TABLE is executed for the table that exists only in ``_schema``. (:issues:`3234`)

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

[kokosing]

General
----
- Add ``CREATE SCHEMA ... AUTHORIZATION`` syntax to create a schema with specified owner. (:issue:`3066`).

Hive
--- 
- Add support for ``CREATE SCHEMA ... AUTHORIZATION`` to create a schema with specified owner. (:issue:`3066`).

3066

[sopel39]

General
-------

* Add ``optimizer.push-partial-aggregation-through-join`` feature toggle for pushing partial
  aggregation through inner join. (:issue:`3205`)
* Rename ``optimizer.push-aggregation-through-join`` feature toggle to
  ``optimizer.push-aggregation-through-outer-join``. (:issue:`3205`)

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

[sopel39]

General
-------

* Expose operator stats of how many splits were processed with dynamic filter applied. (:issue:`3217`)

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

[kokosing]

SPI
--- 
 - Allow ``Connector`` to provide ``EventListener`` registration. (:issue:`3166`)

3166

[Praveen2112]

Kudu
----

* Fix incorrect column mapping in Kudu connector (:issue `3170`, :issue `2963`)

3212

[findepi]

General
* Fix query failure during planing phase for certain queries involving multiple joins. (:issue:`3149`)

https://github.com/prestosql/presto/issues/3149 https://github.com/prestosql/presto/pull/3245

[kokosing]

Security
---
 - Return only accessible to user views from ``<catalog>.information_schema.views`` table. (:issue:`3290`)

3290

[sopel39]

Hive
----

* Add support for endpoint URL for Glue. (:issue:`3239`)

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

[Praveen2112]

General
----
* Fix execution failure for queries involving huge IN on long decimal columns. (:issue: `3191`)

3196

[dain]

Hive
----
* Add experimental file system caching.  This can be enabled with the `hive.cache.enabled` catalog property. (:issue:`2679`)

2679

[martint]

Hive

* Fix failure reading certain Parquet files larger than 2GB. (:issue:`2730`)

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

[martint]

Hive

* Improve performance when reading gzip-compressed Parquet data. (:issue:`3175`)

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

[martint]

* Include filters over all table columns in output of ``EXPLAIN (TYPE IO)``. (:issue:`2743`)

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

[martint]

SPI

* Expose row filters and column masks in ``QueryCompletedEvent``. (:issue:`3183`)

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

[martint]

BigQuery

* Extract parent project ID from service account before looking at the environment. (:issue:`3131`)

3131

[martint]

SPI

* Expose referenced functions and procedures in ``QueryCompletedEvent``. (:issue:`3246`)

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

[findepi]

General
* Ignore trailing whitespace when loading configuration files such as ``etc/event-listener.properties``, ``etc/group-provider.properties``, etc.
  Trailing whitespace in main and catalog configuration files was already ignored.

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

[findepi]

SPI
* Deprecate ``ConnectorPageSourceProvider#createPageSource(ConnectorTransactionHandle, ConnectorSession, ConnectorSplit, ConnectorTableHandle, List<ColumnHandle>)`` (``createPageSource`` variant not taking ``dynamicFilter``). The method will be removed in a future release.

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

[findepi]

SQL Server
* Reject ``ALTER TABLE ... RENAME TO`` between schemas. Previously such rename was accepted but
  renamed was accepted but performed incorrectly.

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

[martint]

Elasticsearch

* Add support for ``ip`` type. (:issue:`3347`)

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

[findepi]

Kudu
* Fix incorrect query result for certain queries involving ``IS NULL`` predicates with ``OR``. (:issue:`3274`)

https://github.com/prestosql/presto/issues/3274 https://github.com/prestosql/presto/pull/3288

[martint]

Elasticsearch

* Add support for `keyword` fields with numeric values. (:issue:`3381`)

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

[electrum]

Hive

* Support reading files compressed with newer versions of LZO. (:issue:`3209`)

3209

[electrum]

JDBC Driver

* Add ``clientInfo `` property to set extra information about the client. (:issue:`3188`)
* Add ``traceToken`` property to set a trace token for correlating requests across systems. (:issue:`3188`)

3188

[electrum]

General

* Reduce overhead for internal communication requests. (:issue:`3215`)

3215

[electrum]

Hive

* Add support for :ref:`alluxio_catalog_service`. (:issue:`2116`)

2116

This will require adding an anchor before "Alluxio Catalog Service" in connector/hive.rst

[electrum]

General

* Fix prepared statements or view creation for queries containing certain nested aliases or ``TABLESAMPLE`` clauses. (:issue:`3250`)

3250

[electrum]

Elasticsearch

* Remove unnecessary ``elasticsearch.aws.use-instance-credentials`` configuration property. (:issue:`3265`)

3265

[electrum]

Hive

* Remove unnecessary ``hive.metastore.glue.use-instance-credentials`` configuration property. (:issue:`3265`)

3265

[electrum]

Hive

* Remove unnecessary ``hive.s3.use-instance-credentials`` configuration property. (:issue:`3265`)

3265

[electrum]

Hive

* Add flexible :ref:`s3_security_mapping`, allowing for separate credentials
  or IAM roles for specific users or buckets/paths. (:issue:`3265`)

3265

[electrum]

Hive

* Add support for specifying an External ID for an IAM role trust policy using
  the ``hive.metastore.glue.external-id`` configuration property (:issue:`3144`)

3144

[electrum]

Hive

* Explicitly disallow reading from Delta Lake tables. Previously, reading
  from partitioned tables would return zero rows, and reading from
  unpartitioned tables would fail with a cryptic error. (:issue:`3366`)

3366

[electrum]

Hive

* Allow using configured S3 credentials with IAM role. Previously,
  the configured IAM role was silently ignored. (:issue:`3351`)

3351