trino: Release notes for 359

Ashhar Hasan

  • all checked
  • 06-02 06:42:40 4bd272cb9a Add product test launcher ‘env describe’ command
  • 06-04 13:36:34 9ad26b4a49 Provide session timezone information in Query UI
  • 06-07 07:59:50 67b8afc1ab Re-enable testLargeIn tests on MemSQL
  • 06-07 07:59:50 efec16ffec Lower MemSQL disk usage in tests
  • 06-07 08:01:44 11bcc0f8ad Extract regr_intercept, regr_slope pushdown tests to BaseJdbcConnectorTest
  • 06-07 08:01:44 7299a6137c Extract corr pushdown tests to BaseJdbcConnectorTest
  • 06-07 08:01:44 996d8c1d53 Extract stddev_samp, stddev_pop pushdown tests to BaseJdbcConnectorTest
  • 06-07 08:01:44 c0b2feb08a Extract var_samp, var_pop pushdown tests to BaseJdbcConnectorTest
  • 06-07 08:01:44 e877ff0266 Extract covar_samp, covar_pop pushdown tests to BaseJdbcConnectorTest
  • 06-07 08:01:44 eb2539224d Extract basic aggregation pushdown tests into BaseJdbcConnectorTest
  • 06-07 22:23:44 f392a55b6f Add bing_tile_quadkey() to list.rst
  • 06-09 03:41:00 16395a112f Convert oracle timestamp with time zone test to SqlDataTypeTest
  • 06-09 03:41:00 4af5702c70 Convert oracle date test to SqlDataTypeTest
  • 06-09 03:41:00 94cac3c5a9 Remove oracle legacy timestamp test
  • 06-09 03:41:00 dc83efc6e8 Convert oracle timestamp test to SqlDataTypeTest
  • 06-10 04:46:17 3ea7afab86 Remove obsolete Cli class
  • 06-15 06:00:02 9bbb9918b0 Document the oauth2 callback/redirect URL
  • 06-17 22:17:55 07f726972d Add Redshift requirements
  • 06-22 03:39:48 323105fe6a Add new cli argument ‘option’ to test run and env up
  • 06-22 03:39:48 3bd411f755 Add singlenode-compatibility PT environment
  • 06-22 03:39:48 5f17fc3c22 Pass extra options to test runs from suite run
  • 06-22 03:39:48 ad66e2a893 Create suite-compatibility and add Hive view compatibility tests
  • 06-22 03:39:48 eb8e7f4934 Clarify comments
  • 06-22 12:36:36 e817259673 Add requirements to Accumulo connector
  • 06-22 12:58:22 bc4d864f8c Add requirements to MemSQL connector
  • 06-23 07:27:04 2a685cc380 Rename arrayToPrestoType method to arrayToTrinoType
  • 06-23 11:18:44 97af1beea5 Fix handling of multiple LDAP user bind patterns
  • 06-24 13:17:12 c7c47c8e2a Add requirements for Kudu connector
  • 06-28 08:40:06 f2b6d09525 Push topN to Phoenix unconditionally
  • 06-28 08:41:57 48519ff925 Support TIMESTAMPS with precisions higher than 3 in MySQL

Dain Sundstrom

  • all checked
  • 06-14 21:15:15 7c1a277327 Migrate ListenableFuture<?> to ListenableFuture<Void>
  • 06-22 11:33:40 bcf6c581de Fix user mapping with password authenticator
  • 06-22 11:33:40 bd01de0030 Fix web UI support for user mapping in form login
  • 06-23 09:59:46 daffd0e7d6 Add automatic internal communications HTTPS configuration
  • 06-25 11:06:44 06c98df1d0 Improve DistinctLimitOperator

David Phillips

  • all checked
  • 06-01 18:21:51 022a266cf6 Rename Hive connector "hive-hadoop2 to “hive”
  • 06-02 10:29:09 0ef47d9e37 Update to Error Prone 2.7.1
  • 06-02 10:29:09 386b5ea864 Validate result of Iterator.hasNext() in test
  • 06-02 10:29:09 47243c75b7 Update to Jdbi 3.20.0
  • 06-02 10:29:09 9d81c32017 Fix usage of Optional.orElseThrow() for side effects
  • 06-02 11:12:30 b9813d9862 Remove dash as allowed character for environment
  • 06-02 11:29:14 9fb818ae97 Remove outdated compatible substitute for TrinoContainer
  • 06-02 11:29:14 c6373462de Simplify version code in JDBC compatibility test
  • 06-02 13:44:05 ff4a1e31fb Remove unused Hive allow-corrupt-writes config
  • 06-04 10:42:43 a6c376d188 Update multiple event listeners to add config property
  • 06-04 10:43:12 1a4672b970 Fix from_iso8601_timestamp_nanos examples
  • 06-07 18:38:27 3112e04d75 Cleanup JsonCodec bindings in server module
  • 06-07 22:58:24 d95eafe397 Clarify metastore filtering and remove unnecessary code
  • 06-07 23:01:29 7e44c84098 Deprecate embedded discovery service config property
  • 06-07 23:43:48 9e7c04719f Move Hadoop file system cache into Trino
  • 06-18 13:21:23 9950ff31d2 Remove usage of /v1/info for JDBC driver
  • 06-21 22:06:43 475a0487ec Remove Airlift JSON from clients
  • 06-21 22:06:43 cf7e9b8698 Remove Airlift logging from clients
  • 06-21 22:06:43 d13e7f30d4 Remove Airlift security from clients
  • 06-21 22:06:43 d7bc504613 Remove Airlift concurrent from clients
  • 06-21 22:06:43 dabd7fe45f Remove log levels option from CLI
  • 06-21 22:16:57 26c9058fcf Allow specifying CLI output formats in lowercase
  • 06-21 22:18:16 1e832c73f6 Add network debug logging option to CLI
  • 06-23 07:07:56 78fcd468a9 Update to Parquet 1.12.0
  • 06-25 10:52:17 1432d6b282 Add requirements for ClickHouse connector
  • 06-25 10:52:39 f9f6844bb0 Add requirements for Druid connector
  • 06-25 10:59:51 5288cbbc37 Clarify metastore cache property
  • 06-25 11:19:49 52f5e7dd01 Add page for JWT authentication
  • 06-25 14:12:23 6bc2594094 Reorder functions and operators list alphabetically

GitHub

  • all checked
  • 06-02 06:44:07 57b3155dd5 Add example of murmur3 function usage
  • 06-03 14:23:24 e326ab97c9 Avoid including hive views in iceberg SHOW TABLES
  • 06-04 10:58:44 1c63f5b28a Add documentation for CURRENT_CATALOG and CURRENT_SCHEMA
  • 06-04 11:04:20 00080c83b9 Add description for timezone for TIME types
  • 06-07 15:35:20 ab8095dafa Fix formatting errors in role documentation (#8205)
  • 06-15 05:59:23 ea01a506a7 Fix order_by ClickHouse table property example
  • 06-20 00:12:41 89bde4f926 Update esri-geometry-api to 2.2.4

Grzegorz Kokosiński

  • all checked
  • 06-02 06:31:07 ee0bdb2207 Add javadocs to ColumnHandle and ConnectorTableHandle
  • 06-21 06:01:38 dbf5d4027f Configure SSL for Hydra IdP in product tests
  • 06-22 03:55:33 2734d84245 Fix flaky TestJdbcConnection
  • 06-22 12:46:22 96502ac5b0 Add INSERT and DELETE to GRANT/REVOKE tests
  • 06-22 12:46:22 9edca85175 Add support for GRANT UPDATE statement
  • 06-24 03:57:52 0b0e41134e Fix BaseConnectorSmokeTest#testDelete
  • 06-24 03:57:52 13c3a7288b Move abstract onRemoteDatabase() to the top
  • 06-24 03:57:52 8f8b3e580f Remove repeating defaults in BaseJdbcConnectorTest
  • 06-24 03:57:52 b3ac41a6e7 Use BaseJdbcConnectorTest for BaseDruidConnectorTest
  • 06-28 09:13:40 2ff6be7715 Remove extra @Test annotation on class
  • 06-28 09:13:40 d4bfb2655b Do not inject JwkService in guice manually

Karol Sobczak

  • all checked
  • 06-02 05:40:14 a49939839c Introduce PageJoiner interface
  • 06-02 05:40:14 f2f7ace7d9 Rename PageJoiner to DefaultPageJoiner
  • 06-07 01:54:42 0c08dd6c69 Avoid referencing WindowOperator directly from its info supplier
  • 06-07 01:54:42 285a23cc2b Declare OperatorContext#infoSupplier to be a covariant Supplier
  • 06-07 01:54:42 4ab192e047 Reduce retained references in TableFinishOperator info supplier
  • 06-07 01:54:42 7870948055 Reduce retained references in PartitionedOutputOperator info supplier
  • 06-07 01:54:42 d1d0bbd8a6 Reduce retained references in TableWriterOperator info supplier
  • 06-07 01:54:42 e28ac8c42f Clear live references to info suppliers in OperatorContext#destroy()
  • 06-07 01:54:42 f522956b45 Use instance supplier for scan operator info
  • 06-07 02:13:13 36919a4784 Fix ValidateLimitWithPresortedInput for multiple sorted inputs
  • 06-07 08:04:51 5681d4465f Enhance join tests
  • 06-07 08:05:36 7ff9a668b4 Format javadocs
  • 06-07 08:05:36 ce5173ac3c Fix typo
  • 06-07 08:06:31 42a6456a08 Fix columns listing for materialized views
  • 06-07 08:06:31 55767398e7 Implement listMaterializedViews in iceberg
  • 06-07 08:06:31 6eb763c835 Inline fixed implementations in BaseConnectorTest
  • 06-07 08:06:31 85f395a07e Add listMaterializedViews SPI
  • 06-07 08:06:31 d1417dc5f2 Add getMaterializedViews SPI
  • 06-07 08:06:31 e4cae791c0 Add MV listing APIs to HiveMaterializedViewMetadata
  • 06-07 08:39:26 856aaf5624 Fix warnings in benchmark class
  • 06-07 08:39:26 ab961d96b9 Extract method
  • 06-07 08:39:26 cf52219c7d Extract methods to BenchmarkFileFormatsUtils
  • 06-07 12:44:20 79830cd7a9 Extract JoinTestUtils
  • 06-08 01:07:02 557ff7b3bc Move assignment above validation
  • 06-08 01:07:02 869a5b22a1 Add HiveMaterializedViewMetadata#refreshMaterializedView
  • 06-08 01:07:02 d8787a5ae0 Enable connector to perform materialized view refresh itself
  • 06-08 01:14:31 94d5904e70 Update table type validation in FileHiveMetastore
  • 06-08 13:18:17 a374404296 Fix typo in method name
  • 06-08 13:42:47 5cec3fd3f8 Remove unused assignment
  • 06-09 06:49:22 760fce85ef Use HiveMetastoreClosure in HiveMaterializedViewMetadataFactory
  • 06-10 04:20:01 c99dd0f8ff Pass filter information to OperatorFactories
  • 06-11 01:28:51 43fe897e38 Fix flaky test
  • 06-11 07:21:55 8d6e1139ea Allow MATERIALIZED_VIEW in FileHiveMetastore
  • 06-18 02:37:12 0528e8b9b5 Add assertEventually overload with retryFrequency
  • 06-28 05:46:04 39b0af8655 Remove unused parameters

Martin Traverso

  • all checked
  • 06-11 11:33:16 a06b50781c Remove illegal overload version for hash_counts function
  • 06-11 11:33:16 f4cc1fb6a8 Add test for setdigest functions
  • 06-16 08:02:25 ca5426e610 Set default time zone for the current session
  • 06-18 12:39:01 b41d388e44 Add support for generic parameters in make_set_digest function
  • 06-18 12:59:12 6b453eaf0c Ignore VSCode config folder
  • 06-18 14:35:20 3fe0bc2ab4 Fix incorrect pushdown if IS NULL predicate in Elasticsearch
  • 06-18 16:26:00 3aef9d7d35 Document luhn_check function
  • 06-18 16:26:00 9624dec383 Remove trailing spaces
  • 06-21 09:40:20 f225b18b95 Fix failure when indexes share same alias

Piotr Findeisen

  • all checked
  • 06-07 04:52:02 c64d7ed1bc Remove unused deprecated methods
  • 06-07 07:05:31 02eb24bbdf Print full thread dump when tests hang
  • 06-08 02:32:47 37e560b031 Update Phoenix 5 client to 5.1.2
  • 06-08 07:33:53 b6802bd0f6 Enable maven --strict-checksums on CI
  • 06-08 13:13:52 5342d7a02c Fix exception message
  • 06-08 13:18:09 2922630d59 Fix getPartitionNamesByFilter for Glue metastore
  • 06-09 04:01:31 1ffe39138a Rename isTopNLimitGuaranteed to isTopNGuaranteed
  • 06-09 15:00:37 e24a3a6957 Remove redunant limitation
  • 06-11 01:56:22 25295d08d2 Keep Ldap product tests together
  • 06-11 02:41:47 79b34c53db Build AcidInfo only for ORC-ACID tables
  • 06-14 03:07:19 2530a439b6 Increase testShowSchemasLikeWithEscape robustness
  • 06-14 03:30:20 0d5ae907e3 Guarantee limit for broker queries
  • 06-14 03:30:20 2cd0addb10 Remove enforced filter for Pinot segment queries
  • 06-14 03:30:20 3c1ee4e08b Fix mixed case column handling
  • 06-14 03:30:20 92ec2289d9 Refactor PinotQueryBuilder.getFilterClause
  • 06-14 03:30:20 adf0fe2d5e Extract pinot catalog name
  • 06-14 03:30:20 f0d49a70e0 Remove TestMinimalFunctionality
  • 06-14 03:43:47 8270d00da7 Test UPDATE with subquery predicate
  • 06-14 03:43:47 cab762031d Support uncorrelated subquery in UPDATE assignments (SET)
  • 06-14 03:43:47 fec1539a45 Fix typo
  • 06-14 05:48:27 54935cb124 Validate no delete deltas for a non full ACID table
  • 06-14 05:48:27 f214021bb0 Avoid variable reassignment
  • 06-14 10:39:48 0a239c9ced Move method above helpers
  • 06-14 10:39:48 726b865a20 Retain more cached information upon insert
  • 06-14 10:39:48 8a3aa9121c Provide better onDataChanged overload
  • 06-14 10:40:11 bebc1a7053 Update Tempto to 185
  • 06-16 04:46:13 f91e14463f Use shorter form of VARCHAR literal
  • 06-16 06:27:35 8ed1f44073 Expose Hive metastore debug port in Launcher
  • 06-16 06:27:35 f2837d6728 Remove unused method
  • 06-17 00:45:48 50a6c69bfc Test MySQL JDBC URL verification
  • 06-18 02:18:23 800e711f92 Exclude snakeyaml from the build
  • 06-21 01:33:04 081860c131 Remove redundant else
  • 06-21 01:33:04 dda757f1f1 Simplify assignment
  • 06-21 01:33:36 18a3da386d Propagate runtime errors in ExpressionInterpreter
  • 06-21 03:26:27 2602248f36 Encode unbounded varchar value without a CAST
  • 06-21 03:26:27 d0037b39cc Simplify code
  • 06-21 05:10:36 01670f3ffc Bump mysql-connector-java to 8.0.22
  • 06-22 00:51:53 3e3235429f Reset glue partition fetcher use getGetPartitionThreads
  • 06-22 03:31:29 472eae580c Fix system.metadata.table_comments for views and MVs
  • 06-23 06:24:54 f39b4d8ef4 Refactor HiveMetadataFactory
  • 06-24 08:05:14 37813cd348 Make several static methods public for table redirection
  • 06-24 08:05:14 ea5d9889b0 Move isIcebergTable to HiveUtils
  • 06-24 12:56:06 7458520cca Add test for hive views with unions

Pratham

  • all checked
  • 06-10 16:25:12 41ff64c3d4 Validate ordinal based grouping expressions during analysis
  • 06-17 09:00:51 e38bfbb414 Fix typo in Iceberg connector documentation

Praveen Krishna

  • all checked
  • 06-24 07:13:37 56def9128a Capture column level dependency for Set Operators

Yuya Ebihara

  • all checked
  • 06-05 19:00:46 1fc5895f17 Fix wrong result due to column position mismatch in BigQuery
  • 06-26 17:49:38 0a15dd87d9 Create MongoDB index for _schema collection only if absent

kasiafi

  • all checked
  • 06-06 01:18:31 89fd2ec09e Handle row ambiguous dereference as semantic error
  • 06-21 09:47:59 181eaf1bce Plan row pattern matching in window
  • 06-21 09:47:59 285a8b5097 Fix printing rowsPerMatch option in PlanPrinter
  • 06-21 09:47:59 34d8485bc6 Fix planning of pattern navigation offset
  • 06-21 09:47:59 378ab0d385 Add builders and matchers for testing plans with PatternRecognitionNode
  • 06-21 09:47:59 53deff6e87 Fix window frame check
  • 06-21 09:47:59 731ecac9d7 Add rule to prune PatternRecognitionNode’s source columns
  • 06-21 09:47:59 768f1c1821 Add rule for merging PatternRecognitionNodes
  • 06-21 09:47:59 8d64c90794 Do not use grouped execution for PatternRecognitionNode
  • 06-21 09:47:59 96567d8ee2 Analyze pattern recognition clauses in window and window measures
  • 06-21 09:47:59 9c20aa09c8 Extract method for planning window specification
  • 06-21 09:47:59 9d97193243 Analyze components of window frame with pattern recognition
  • 06-21 09:47:59 a4e75b7901 Support window functions in PatternRecognitionNode
  • 06-21 09:47:59 a58d03172b Extract frameExtent from windowFrame in grammar
  • 06-21 09:47:59 baa266ea5f Add project-off rule for PatternRecognitionNode
  • 06-21 09:47:59 c1b3a9e558 Skip window function’s FrameInfo in pattern recognition context
  • 06-21 09:47:59 c92ec68b82 Support pattern matching in area reduced to window frame
  • 06-21 09:47:59 d10354bb4e Test window with row pattern recognition in queries
  • 06-21 09:47:59 dc84283eca Support row pattern matching in window: grammmar and AST
  • 06-21 09:47:59 e07bc55761 Add constructor checks for PatternRecognitionNode
  • 06-21 09:47:59 f1f558eda3 Move CorrelationSupport to Visitor’s context in ExpressionAnalyzer
  • 06-21 09:47:59 f304a342cb Add tests for pruning unused calls over window with pattern matching
  • 06-21 09:47:59 f98fe48361 Support row pattern measures over window: grammmar and AST

Łukasz Osipiuk

  • all checked
  • 06-08 02:39:40 5d2d7e752d Take BUCKET_ID column into account when applying delete_delta
  • 06-08 02:39:40 af40c877c5 Change ORC ACID row_id columns order
  • 06-10 05:53:05 0593a8e722 Add missing test groups
  • 06-10 05:53:05 ba99e688b1 Bump version of coral to 1.0.60
  • 06-14 05:27:47 35386241f8 Use Trino instead of Presto in TestHiveTransactionalTable
  • 06-23 03:27:05 41cc0873d7 Introduce hidden $approx_set aggregation
  • 06-23 03:27:05 55cba82c4f Support $approx_set as a column statistics aggregation
  • 06-24 11:41:27 2ee7c94601 Restore non-cancellable DispatchQueryCreationFuture
  • 06-24 23:15:36 045a130d2c Use actual pattern type when compiling LIKE pattern
  • 06-24 23:15:36 04bf254e2b Inlike getVarcharType
  • 06-24 23:15:36 522a48fa80 Fix LIKE with char
  • 06-24 23:15:36 53bc5152c5 Fix typo
  • 06-24 23:15:36 ddea70ad46 Remove unused method
  • 06-25 06:40:07 adfe91ea6c Revert “Add test for hive views with unions”
  • 06-25 10:08:22 aee5058b78 Basic result stability tests for $approx_set
  • 06-28 02:25:04 55320ba4f8 Run ElasticSearch tests
  • 06-28 02:25:04 86a5984627 Fix flaky test testSelectInformationSchemaForMultiIndexAlias in elastic

About this issue

  • Original URL
  • State: closed
  • Created 3 years ago
  • Comments: 33 (33 by maintainers)

Most upvoted comments

Hive
* Add support for inserting data into CSV and TEXT tables with skip_header_line_count table property set to 1.
  The same applies to creating tables with data using `CREATE TABLE ... AS SELECT` syntax. ({issue}`8390`)
* Add validation so creating CSV and TEXT tables with data is not allowed if skip_header_line_count is set to a value 
  greater than 1. ({issue}`8373`)

#8390, #8373

cc: @homar

Security
* Add automatic configuration of HTTPS for internal Trino communications.  Simply, set `internal-communication.https.required` and set an `internal-communication.shared-secret`, and Trino will automatically configure TLS between all Trino processes. ({issue}`7954`) 

#7954