trino
trino copied to clipboard
Official repository of Trino, the distributed SQL query engine for big data, formerly known as PrestoSQL (https://trino.io)
The parser is throwing `ParsingException` for valid `DROP VIEW IF EXISTS` query. Although properly quoted, it seems the quotes aren't being considered. For example: - This statement throws `ParsingException` ```...
## Description The generate aggregations loops have specialized paths for dictionary or run length encoded data, and for masked or unmasked data. This change requires that aggregation function using the...
## Description Previously trino-cli didn't display plans for EXPLAIN ANALYZe > Is this change a fix, improvement, new feature, refactoring, or other? a fix > Is this a change to...
## Description Make `flush_metadata_cache` with schema and table arguments clear table-related caches ## Non-technical explanation Make `flush_metadata_cache` with schema and table arguments clear table-related caches ## Release notes ( )...
``` Error: Failures: Error: TestHiveConnectorTest>BaseHiveConnectorTest.testScaleWriters:3853->BaseHiveConnectorTest.testWithAllStorageFormats:8360->BaseHiveConnectorTest.testWithStorageFormat:8373 Failure for format PARQUET with properties {hive={experimental_parquet_optimized_writer_enabled=false}} Error: TestHiveConnectorTest>BaseHiveConnectorTest.testSelectWithNoColumns:7621->BaseHiveConnectorTest.testWithAllStorageFormats:8360->BaseHiveConnectorTest.testWithStorageFormat:8373 Failure for format PARQUET with properties {hive={experimental_parquet_optimized_writer_enabled=false}} Error: TestHiveConnectorTest>BaseHiveConnectorTest.testSubfieldReordering:5210->AbstractTestQueryFramework.assertUpdate:318->AbstractTestQueryFramework.assertUpdate:323 » QueryFailed Error: TestHiveConnectorTest>BaseHiveConnectorTest.testTimestampPrecisionCtas:7992->BaseHiveConnectorTest.testWithAllStorageFormats:8360->BaseHiveConnectorTest.testWithStorageFormat:8373 Failure for format...
## Description This PR adds File-based access control support for table functions. Before this PR with File-based access control enabled every table functions was denied. By default every rule kind...
## Description Provide a jdbc driver property `ignoreBrokenCatalogs` to avoid metadata queries to error out on a broken catalog (eg. not working Hive Metastore). > Is this change a fix,...
Currently, rollup on x, y, z will translate into plan: ``` FinalAggregregation[$id, x, y, z](aggr) RemoteExchange PartialAggregation[$id, x, y, z](aggr) GroupId ``` `GroupId` operator will multiply unaggregated input data 4...
Use distinct aggregations by default (instead of MarkDistinctNode) for single distinct aggregation
https://github.com/prestodb/presto/pull/10224 adds distinct aggregation support to aggregation operator. However, it's still not enabled by default: https://github.com/prestodb/presto/pull/10224/files#r176341005. There are few issues with (build-in) distinct aggregations. Consider query: ``` SELECT group, count(a)...
Currently, `HashGenerationOptimizer.Rewriter#visitExchange` has a constraint: ``` // Currently, precomputed hash values are only supported for system hash distributions without constants ``` It would be beneficial to precompute hash values for...