martint commented 3 years ago

Ashhar Hasan

[x] all checked
10-20 05:47:28 2948709c9b Fix flaky Docker image pulls in tests
10-22 04:54:49 29f808cf80 Move trino-testing.properties to trino-testing-services
10-22 04:54:49 5670d15097 Use consistent docker image version for accumulo
Dain Sundstrom
[x] all checked
10-07 23:39:00 bd5527627e Fix Hive target max file size for partitioned tables
10-08 21:43:13 2e963045c4 Split comparison into unordered first and last
10-08 21:43:13 f382a17676 Remove unused BlockPositionComparison.reversed()
10-08 21:43:13 f76a556956 Convert min/max N aggregation to MinMaxCompare helper
10-08 21:43:13 fc3af014a9 Convert min/max by N aggregation to MinMaxCompare helper
10-09 00:19:10 01584b5e16 Change FunctionMetadata signature to be the actual caller signature
10-09 00:19:10 270e880564 Move legacy approx_percentile to separate classes
10-09 00:19:10 5f3966f9f5 Simplify parametric aggregation
10-09 00:19:10 7045d109d5 Move boolean approx_distinct to separate class
10-09 00:19:10 8016601072 Add generic aggregation state holders
10-09 00:19:10 aec7351483 Require aggregation metadata at construction
10-12 10:54:43 41fcd1e0d8 Fix intermediate type declaration for multimap_agg
10-12 10:54:43 c9e8aa6f2a Test aggregation metadata types matches function implementation
10-12 10:54:43 da2f8718cf Fix intermediate type ordering for min_max_by
10-14 23:09:03 4826d05103 Require session for coercion resolution
10-14 23:09:03 86fd8f6d5a Require session for operator resolution
10-14 23:09:03 efcddf4eca Require session for function resolution
David Phillips
[x] all checked
10-15 11:55:52 1f098d92a0 Update errorprone-in-IDEA note in DEVELOPMENT.md
10-15 11:55:52 60e357f350 Enable all Error Prone checks (almost)
10-15 12:44:27 569ff5fa7c Remove JWK support for legacy SunEC curve
10-15 12:44:27 85c74735cc Configure Error Prone for newer JDKs
10-15 12:44:27 a398b4c8d4 Remove unused class ShardNodeId
10-15 12:44:27 f8e6a6f8f4 Update raptor-legacy to Jdbi 3
10-18 12:56:55 f82286463b Update legacy JWT config in test
10-22 10:37:54 1b4a378ddb Add resource links to JWT page
GitHub
[ ] all checked
10-06 22:44:13 9fbbef0d1c Adjust width of Iceberg config properties documentation
10-13 10:07:48 4949bdc206 Add auto_purge to Hive table properties
10-13 18:36:34 cbd1027327 Use Flyway for DB-based resource groups migrations
Grzegorz Kokosiński
[x] all checked
10-07 03:27:52 456403c505 Get rid of usage of deprecated ConfigurationModule.installModules
10-07 05:27:21 bcb81f2302 Fix SingletonIdentityCacheKey#equals
10-08 01:24:33 3fce1617c5 Reduce batch write tests run time
10-08 07:41:21 81bdf7c444 Replace RaptorConnectorId with CatalogName
10-08 07:41:21 a0070519a6 Make catalog name be available in guice
10-15 02:14:19 292a7aec88 Enable ErrorProne check: CheckReturnValue
10-15 02:14:19 4d35eace3b Add @CanIgnoreReturnValue to some methods in MatchAssert
10-20 03:40:03 6711f68bb9 Bump org.ow2.asm:asm version to 9.1
10-20 07:18:22 2663e9f75e Refactor callback uri hardcode
Karol Sobczak
[x] all checked
10-07 03:51:41 357102116d Add support for dictionaries to BigintGroupByHash
10-07 14:52:41 9705655be9 Use comparator for expressions canonical ordering
10-08 03:00:47 329c402a7c Support materialized view rename in iceberg connector
10-08 03:00:47 e129273e4e Add support for renaming materialized views
10-08 03:00:47 f4caa4eafb Use containsAll for metadata.materialized_views asserts
10-08 04:23:54 1e587f09f8 Do not create new DictionaryBlock when all positions are selected
10-08 04:23:54 359d2e70df Avoid creating new block instance when all positions are selected
10-08 04:23:54 56f6f283a9 Add a test that DictionaryAwarePage projection preserves dictionary
10-08 04:23:54 a2bc080d7f Rename getGroupId to registerGroupId
10-11 03:06:12 be4ce1494e Make sure that output dictionary is same as input dictionary
10-12 04:53:50 51279b7195 Fail rename materialized view across schema in iceberg
10-18 02:19:27 a13baee458 Fix RangeView#formatRange for single value
10-18 06:43:22 18cb242927 Flatten decimal accumulator
10-18 06:43:22 550587f947 Fix SingleLongDecimalWithOverflowAndLongState#getEstimatedSize
10-18 06:43:22 85daec7a8d Extract TestUnscaledDecimal128Arithmetic#assertAdd method
10-18 06:43:22 99721b8a9a Report per-row time for benchmarkEvaluateIntermediate
10-18 06:43:22 c151c3e5d4 Fix formatting
10-18 06:43:22 f87b20a68a Increase benchmark position count
10-18 07:36:41 4c2df7a89a Implement mv rename in test connectors
10-20 01:27:06 b1adda2702 Add debug info in flaky testDynamicFilters
10-20 07:51:38 90b43c39bb Fix divideRoundUp in negative fraction case
10-21 02:36:54 90184fe8c1 Implement HivePageSource#getMetrics
Martin Traverso
[x] all checked
10-07 17:54:55 94dd9165d8 Remove unused deprecated method
10-07 23:18:41 e90f87f47b Ignore Elasticsearch fields with unsupported types
10-12 10:49:26 2a7f356971 Remove unwrap casts configuration and session property
10-14 19:18:09 13a11c6324 Change Test annotation with exceptions to assertThatThrownBy
10-15 02:11:43 9d09ac7ba8 Avoid unnecessary creation of lists from columnIndex
10-15 10:45:52 e2fafde6be Hoist computation of ConnectorSession
10-16 12:18:01 390afa3368 Properly match benchmark class name
10-16 12:18:01 eadea392af Use correct type in page processor benchmark
10-22 08:32:26 22272e28d6 Fix iteration logic over RowRanges iterator in PrimitiveColumnReader
10-22 08:32:26 2e6018462a Fix incorrect results with parquet page filtering
Piotr Findeisen
[ ] all checked
10-07 01:00:33 5bb9420461 Avoid constant hashcode
10-07 07:24:41 2840b38fc5 Identity table handle by its attributes in test
10-08 00:19:31 a0347c6ec1 Provide STRING Parquet logical type annotation for char, varchar
10-08 02:22:16 f4cada14a8 Use count_big instead of count for SQL Server agg pushdown
10-09 11:18:26 c8cfaa80ac Remove deprecated Constraint constructors
10-09 11:18:26 df8a9edcaf Remove use of deprecated Constraint constructor
10-11 03:52:58 b141d614a1 Make field available in test class
10-11 05:22:58 6ac27336c5 Expose all plugin attributes in TestingIcebergPlugin
10-11 05:22:58 b369322f53 Make metastore optional in TestingIcebergPlugin
10-11 05:22:58 cddc7823db Remove constructor overload from TestingIcebergPlugin
10-11 07:26:10 1f31516ef4 Fix reading invalid Avro schema written by Avro 1.8.2
10-12 02:26:06 c34ff67fbf Flatten Iceberg catalog/metastore configuration
10-12 02:49:41 68d35f0839 Make Hive expression pushdown future-proof
10-12 02:51:01 ca20ca32c4 Update TODO comment
10-12 02:56:55 c5ac103ede Load plugins concurrently
10-12 03:16:13 85338068e4 Fix testSplittableNotCheckedOnSmallFiles flakiness
10-12 04:37:38 7aa4e8d3b6 Remove unnecessary writer-sort-buffer-size config override
10-12 04:37:38 a199125632 Remove unnecessary ORDER BY in testPageSkipping
10-12 05:32:27 5457a522b8 fixed comment typos
10-12 06:04:43 059f8f0b2c Use correct identity when talking to metastore in Iceberg
10-12 06:04:43 4218327c06 Unlock HMS lock on timeout of failure
10-12 06:04:43 655d65d417 Delete temp dir explicitly
10-12 12:46:29 037122740f Update PostgreSQL JDBC driver to 42.2.14
10-12 12:48:56 e0d2f2b072 Consolidate transactional SQL support info
10-13 01:52:28 8fd28be8dd Update AWS SDK version to 1.12.85
10-13 01:54:56 c8b861c7ca Support writing Parquet encoding stats
10-13 04:10:07 4893b5ca04 Update issue links to correct project location
10-13 04:15:24 62bd60f8fb Update outdated comment in PostgreSQL connector
10-13 06:58:01 715729d51d Do not assume ColumnIdentity#getChildren is constant time
10-13 06:59:55 8d0cb51058 Expand @Flaky annotation pattern
10-13 10:36:01 3300267198 Update hadoop-apache to 3.2.0-14
10-13 10:36:01 bbdf5b6a53 Run suite-2 on HDP3 with JDK 17
10-14 12:00:50 0ff73f3c6a Local dynamic filter support for Iceberg
10-14 13:41:58 faa8b5e0d1 Update Jdbi3 to 3.23.0
10-14 13:46:54 fee400a549 Fix: Typo in docs - functions/aggregate.rst
10-15 12:41:33 67562fa71c Report columns covered by a Dynamic Filter
10-15 12:41:33 fc9b19879a Add TestingColumnHandle.toString
10-15 12:42:54 44569a432c Pass session to HiveTableOperations
10-15 12:42:54 63d4340a54 Split HiveTableOperations into two copies
10-15 12:42:54 79a6f11722 Expose thrift API to lock table exclusively
10-15 12:42:54 803aebac95 Copy commitToExistingTable into subclasses
10-15 12:42:54 8a59a45952 Manage catalog and metastore together in Iceberg modules
10-15 12:42:54 912dde085b Split Iceberg commit for new and existing table
10-15 12:42:54 bff0931fb7 Fix durability of INSERT in Iceberg
10-15 12:46:30 1b447ee7a0 Change IcebergTableHandle.toString to return snapshotId correctly
10-15 12:50:23 3f0b9b1a15 Flatten SortedRangeSet.Builder into a single method
10-15 12:50:23 aec5384ca9 Benchmark creation of 1-range ValueSet
10-15 13:27:45 6c4b5ef4c0 Change Test annotation with exceptions to assertThatThrownBy
10-15 23:58:10 55b5b9daea Split out suite-ldap from suite-6
10-16 00:07:20 3dff0a502f Remove redundant parameters from IcebergTableOperationsProvider
10-18 07:45:27 39d6d0b2da Add benchmarks for intersect to BenchmarkSortedRangeSet
10-18 07:45:27 ede66af53c Refactor TestTupleDomain#testOverlaps
10-18 07:45:27 f54ab9f8f1 Optimize TupleDomain#overlaps using Domain#overlaps
10-19 08:15:31 598c2f8f77 Remove obsolete property override
10-19 11:44:22 ff6a25e855 Upgrade docker-images to version 50
10-20 00:11:14 bfb417d841 Store connector name when registering catalogs
10-20 00:11:14 ef2a66f48d Add connector name to system.metadata.catalogs table
10-20 00:11:14 f9a3975e3e Check for specific rows in system catalog product test
10-20 08:19:24 cd52526c6b Change native parquet writer to write v1 parquet files
10-20 13:00:47 6a24cf491d Add Iceberg type mapping
10-20 13:06:41 2b8468c677 Improve Domain#contains
10-20 13:06:41 e1490823be Optimize TupleDomain#contains using Domain#contains
10-20 13:07:12 6f4e4c2a84 Fix flaky TestIcebergOrcConnectorTest.testSplitPruningFromDataFileStatistics
10-22 01:05:10 3cfb1881f1 Use computeScalar for brevity
10-22 01:05:10 730b75087f Create table with right file format
10-22 01:05:10 955b7c1bc5 Test clearing Iceberg table comment
10-22 01:05:10 9619b0f5ba Remove duplication from test
10-22 01:05:10 c4368dde8d Simplify all types test
10-22 01:05:10 f2fb78b9a9 Fix indentation
10-22 08:34:41 ad8663794f Respect allow_pushdown_into_connectors in split and page sources
Pratham
[ ] all checked
10-10 08:42:38 73ad47245a Remove usage of @test with exceptions in planner tests
10-13 07:01:44 15c0419af7 Make getRedirectedTableName robust against empty object names
10-13 07:01:44 611b46811e Clarify comments around listing redirected tables
10-13 07:01:44 9b29c5b46f Fix failure with table listing for redirected tables
Praveen Krishna
[ ] all checked
10-08 03:49:46 204a95389a Specify stream partitioning for AssignUniqueId in PropertyDerivations
10-08 03:49:46 29cb82030a Ensure delete/update is applied on actual table specified in query
10-08 03:49:46 33bb270bb0 Assert plan for correlated subqueries with automatic join distribution
10-08 03:49:46 45eb2472d5 Specify if a query is of Explain/Explain Analyze during Analysis
10-08 03:49:46 85b641909a Set updateType once for Materialized views refresh
10-08 03:49:46 a72a739861 Support correlated subquery in UPDATE assignments (SET)
10-08 03:49:46 abb23d6e30 Introduce QueryType enum for Analysis
10-08 03:49:46 b539167cfc Use static import for TestingColumnHandle
10-08 03:49:46 d39544ebe2 Fix tracking of update target for EXPLAIN ANALYZE queries
10-20 04:25:12 13d98074e9 Add delegated Kerberos support for JDBC driver
10-20 04:25:12 4f63e10493 Introduce SubjectProvider
10-20 04:25:12 82bfa66d26 Move SpnegoHandler to different package
Yuya Ebihara
[x] all checked
10-06 21:31:11 3203ec2702 Remove usage of @test with exceptions in operator tests
10-06 23:23:22 b61542c6ff Remove usage of @Test with exceptions in main module tests
10-07 01:12:50 81e90cebf7 Remove compiler warning for reserved identifier in future JDKs
10-08 04:24:44 6c7d4d857f Remove usage of @test with exceptions in metadata tests
10-09 05:23:51 fae324fc9b Add anchor for Iceberg SQL support
10-11 06:19:39 3b1df075a9 Remove usage of @test with exceptions in sanity tests
10-13 01:28:33 91fd056469 Pin testing Accumulo image to version 47
10-13 06:50:29 6f62a188a0 Change Test annotation with exceptions to assertThatThrownBy
10-13 17:52:55 12210d50db Add ALTER TABLE SET PROPERTIES statement
10-13 17:52:55 2f25d78ff0 Check SET PROPERTIES permission in CREATE TABLE task
10-13 17:52:55 a50f16e3d1 Implement ALTER TABLE SET PROPERTIES in ClickHouse
10-13 18:14:40 9fb477f7d9 Add documentation for ALTER MATERIALIZED VIEW RENAME
10-14 01:05:33 084164adff Add language annotation to assertInvalidFunction
10-14 01:05:33 a0626d1206 Remove redundant usage of INVALID_FUNCTION_ARGUMENT
10-16 23:10:05 ede9164795 Remove usage of @test with exceptions in plugin tests
10-18 00:27:04 a92a72a8dc Add more types to BigQuery type mapping test
10-18 02:46:45 7faf567bc7 Make method and class public in BigQuery
10-18 02:46:45 e6b84f4603 Return optional type in BigQueryClient.getTable method
Łukasz Osipiuk
[x] all checked
10-06 23:04:42 c6a80cc9f9 Remove redundant container setup in BaseTestContainer
10-07 10:28:21 65f5980893 Update docker images to version 46
10-11 16:14:03 60eb47409c Use consistent parameter name
10-11 16:17:00 9f35ffefb5 Disable ProgressLoggingListener for product tests
10-11 16:17:00 f16508ea3a Add test progress logging on CI
10-11 16:17:48 3dc90ce4c8 Add parameter comment
10-12 08:55:57 6ee30f00e9 Update docker images to version 47
10-12 13:19:30 c994b1516b Bump Coral to 1.0.120
10-13 23:24:26 ca48ae4091 Print current plan when dynamic filters invalid
10-19 12:45:48 4f5c9e6be2 Force usage of JDK 8 for Hadoop Hive 3 container
10-19 12:45:48 5aa64a69d7 Use docker-images version 49 and switch to ldap-oj11 images
10-19 12:45:48 5dae2e2f96 Use consistent docker-images version across modules
10-20 11:17:50 cf8a5f8f44 Remove obsolete comment
10-21 16:47:49 610a87adb4 Fix SHOW STATS for boolean
10-22 14:16:49 0f640f3010 Check for Hive system schema earlier
10-22 14:16:49 e43496ba23 Implement streamTableColumns in HiveMetadata
10-22 14:16:49 f60f356e14 Add redirections support to Hive streamTableColumns
10-22 15:28:35 ce7b0341aa Pass transaction auto commit context to ConnectorSession
10-22 15:28:35 efcef566d7 Restrict insert overwrite only to auto commit context
10-25 12:37:11 19296de317 Prefer toImmutableList in HiveMetadata
10-25 12:37:11 2fe7084f76 Add Hive OPTIMIZE table procedure
10-25 12:37:11 30c25e1b4a Use descriptive argument name
10-25 12:37:11 36ff8b5a3d Add SPI, syntax and execution for table procedures
10-25 12:37:11 6c6fa2b8be Simplfy table scan handle update in BeginTableWrite
10-25 12:37:11 741a512d43 Short-circuit empty table execute plan
10-25 12:37:11 c558ba67f4 Generalize AbstractPropertyManager
10-25 12:37:11 deec503c92 Rename method
10-25 22:09:03 7b727c9105 Guard Hive's OPTIMIZE table procedure with session property

sopel39 commented 3 years ago

General:
* Improve performance of `GROUP BY` with single grouping column. ({issue}`9514`)

https://github.com/trinodb/trino/pull/9514

dain commented 3 years ago

Hive:
* Fix `ArrayIndexOutOfBoundsException` when inserting into a partition table with `hive.target-max-file-size` set.  ({issue}`9557`)

9557

findepi commented 3 years ago

Hive
* Fix Hive incompatibility with Parquet files containing `char` or `varchar` data produced by the experimental Parquet writer.
   Hive 2 or newer should now read such files correctly, while Hive 1.x is still known not to read them. ({issue}`9515`)

This change might affect Iceberg too. However, we don't have Iceberg connector tests with Hive, so i don't know.

9515

findepi commented 3 years ago

SQL Server
* Fix query failure when `count(*)` aggregation is delegated to SQL Server database and table has more than 2147483647 rows. ({issue}`9549`)

9549

sopel39 commented 3 years ago

General:
* Add support for `ALTER MATERIALIZED VIEW ... RENAME TO ...`. ({issue}`9492`)

Iceberg:
* Add support for renaming materialized views. ({issue}`9492`)

https://github.com/trinodb/trino/pull/9492

findepi commented 3 years ago

Hive
* Fix reading semi-invalid Avro schema written by Avro 1.8.2. ({issue}`9243)

9243

findepi commented 2 years ago

Iceberg
* Create Parquet files that can be read more efficiently. ({issue}`9569`)

https://github.com/trinodb/trino/pull/9569

ebyhr commented 2 years ago

## General
* Add support for `ALTER TABLE ... SET PROPERTIES` statement. ({issue}`9401`)

## SPI
* Introduce `ConnectorMetadata#setTableProperties` for altering table properties. ({issue}`9401`)

## ClickHouse
* Support changing `sample_by` table properties using `ALTER TABLE ... SET PROPERTIES` statement. ({issue}`9401`)

9401

#

This should not be documented if we couldn't fix the implementation before release.

findepi commented 2 years ago

Iceberg 
* Improve query performance when dynamic filtering can be leveraged. ({issue}`4115`)

9538 #4115 #9193

findepi commented 2 years ago

SPI
* Expose which columns are covered by dynamic filters. ({issue}`9644`)

9644

findepi commented 2 years ago

Iceberg
* Fix data loss in case of concurrent inserts to a table. ({issue}`9583`)

9583 #9584

sopel39 commented 2 years ago

General
* Fix displaying character type dynamic filter values in ``EXPLAIN ANALYZE``. ({issue}`9673`)

https://github.com/trinodb/trino/pull/9673

Praveen2112 commented 2 years ago

General 
* Fix query failure for update operation if it has a correlated subquery.

8286

sopel39 commented 2 years ago

General
* Improve performance of decimal aggregations. ({issue}`9640`)

https://github.com/trinodb/trino/pull/9640

sopel39 commented 2 years ago

General
* Fix decimal division when result is between `-1` and `0`. ({issue}`9696`)

https://github.com/trinodb/trino/pull/9696

findepi commented 2 years ago

Hive
* Write files compatible with Hive 1 and Hive 3 in experimental Parquet writer. ({issue}`6377`)

6377 #9611

findepi commented 2 years ago

General
* Fix SHOW STATS failure for a query projecting a boolean column. ({issue}`9710`)

9710 #9711

aczajkowski commented 2 years ago

# Hive
* Restrict partition overwrite on insert to auto commit context only ({issue}`9559`)

https://github.com/trinodb/trino/issues/9559 https://github.com/trinodb/trino/pull/9675

Praveen2112 commented 2 years ago

JDBC
* Allow using token from existing Kerberos context. This allows us to perform Kerberos authentication without 
passing the Keytab or credential cache to the driver ({issue}`4826`)

9606

findepi commented 2 years ago

Iceberg
* Return value with UTC zone for table partitioned on `timestamp with time zone`. ({issue}`9704)
* Fix query failure when reading from `$partitions` table for a table partitioned on `timestamp with time zone` or `uuid` ({issue}`9703`, {issue}`9757)

9757 #9703 #9704

findepi commented 2 years ago

Iceberg
* Fix query failure when reading Iceberg table statistics. ({issue}`9714`)

9714 #9719

ebyhr commented 2 years ago

## MemSQL
* Support reading MemSQL `datetime(6)` and `timestamp(6)` types as Trino `timestamp(6)`. ({issue}`9725`)

9725

kokosing commented 2 years ago

# Hive
* Allow to skip setting permissions on new directories by setting `hive.fs.new-directory-permissions=skip` in connector properties file. ({issue}`9539`)

9539

losipiuk commented 2 years ago

# Hive
* Allow translating Hive views which cast `timestamp` columns to `decimal`. ({issue}`9530`)

9530

losipiuk commented 2 years ago

# Hive
* Add `OPTIMIZE` table procedure for merging small files in non-transactional Hive table. 
  Procedure can be executed using `ALTER TABLE <table> EXECUTE OPTIMIZE(file_size_threshold => ...)` syntax. ({issue}`9665`)

9665 #9761

losipiuk commented 2 years ago

# SPI
* Add SPI for table procedures that can process table data in a distributed manner. Table procedures can be run via `ALTER TABLE ... EXECUTE ...` syntax. ({issue}`9665 `)

9665

ebyhr commented 2 years ago

## Cassandra
* Map Cassandra `uuid` type to Trino `uuid`. ({issue}`5231`)

5231

dain commented 2 years ago

# Hive
* Fix query failure when writing to a partitioned table with target max file size set. ({issue}`9557`)

9557

sopel39 commented 2 years ago

General:
* Fix invalid query results for queries with nested joins and ``IS NOT DISTINCT FROM`` join clauses. ({issue}`9805`)

https://github.com/trinodb/trino/pull/9805

kokosing commented 2 years ago

General
* Improve CPU coordinator utilization. ({issue}`8650`)

8650

losipiuk commented 2 years ago

# Hive
* Reject execution of `CREATE TABLE` when bucketing is requested on columns with unsupported column types. Previously `CREATE` was allowed but it was not possible to insert data to such a table. ({issue}`9793`)

9793

findepi commented 2 years ago

General / UI
* Improve responsiveness of Web UI when query history contains queries with long query text. ({issue}`8892`)

trinodb / trino

Release notes for 364 #9534

Ashhar Hasan

Dain Sundstrom

David Phillips

GitHub

Grzegorz Kokosiński

Karol Sobczak

Martin Traverso

Piotr Findeisen

Pratham

Praveen Krishna

Yuya Ebihara

Łukasz Osipiuk

9557

9515

9549

9243

9401

9538 #4115 #9193

9644

9583 #9584

8286

6377 #9611

9710 #9711

9606

9757 #9703 #9704

9714 #9719

9725

9539

9530

9665 #9761

9665

5231

9557

8650

9793

8892