trino
trino copied to clipboard
trinodb
Official repository of Trino, the distributed SQL query engine for big data, formerly known as PrestoSQL (https://trino.io)
## Description For queries like ``` select sum(sales) from fact, date_dim where fact.date_id = date_dim.date_id group by date_dim.year ``` partial aggregation on date_dim.year can be pushed below join with grouping...
## Description Add support for `WITH SESSION` clause: ```sql WITH SESSION session_key = 'property', catalog.catalog_session_key = 'catalog_property' SELECT 1 ``` The syntax with both sessions and SQL functions: ```sql WITH...
## Description When set to true, updating tables in Glue does not create an archived version of the table. Glue tables are updated during INSERT operations, so this option can...
## Description https://github.com/trinodb/trino/commit/677b52d8b06f4fe983e41e2fcd1e470f79930a30 removed the following condition ``` if (prefixes.size() > MAX_PREFIXES_COUNT) { // in case of high number of prefixes it is better to populate all data and then...
## Description Don't attempt to read Delta Lake table metadata when performing table redirect to a different catalog. This allows redirecting from incomplete or invalid Delta Lake tables. Without the...
## Description Add partitioning push down to table scan which a connector can use to activate optional partitioning, or choose between multiple partitioning strategies. This replaces the existing `Metadata` `makeCompatiblePartitioning`...
## Description ## Additional context and related issues ## Release notes (x) This is not user-visible or is docs only, and no release notes are required. ( ) Release notes...
A partitioned table can have multiple partitions as seen in the example below. ``` Partitioned table: partition_table partitions: partition_table_part1, partition_table_part2, and so on ``` But it's enough to display only...
Spark returns the expected results: ``` CREATE TABLE default.test_delta (col1 STRING, updated_column INT) USING DELTA LOCATION 's3://test-bucket/test_delta' TBLPROPERTIES ('delta.enableChangeDataFeed'=true, 'delta.enableDeletionVectors'=true); INSERT INTO default.test_delta VALUES ('testValue1', 1), ('testValue2', 2), ('testValue3', 3);...
EWKB is a common binary representation for geometries. PostGIS and Apache Sedona supports reading both WKB and EWKB formats in their ST_GeomFromBinary/WKB functions transparently. https://en.wikipedia.org/wiki/Well-known_text_representation_of_geometry#Format_variations https://sedona.apache.org/latest/api/sql/Constructor/#st_geomfromwkb
