Comments (2)
Do you have any idea how to achieve it?
One brute force way could be to reorder the predicate and try to match, while identifying if that part of query is cached or not?
from trino.
One brute force way could be to reorder the predicate and try to match, while identifying if that part of query is cached or not?
This is actually already done.
If you look at #21888 then there is a concept of PlanSignature
that CacheManager
uses as a cache key. PlanSignatures
are computed in io.trino.cache.CommonSubqueriesExtractor#computePlanSignature
. Specifically:
signatureKey = combine(
signatureKey,
"filters=" + formatExpression(combineConjuncts(
// Order remaining expressions alphabetically to improve signature generalisation
Stream.of(remainingDomainExpression, extractionResult.getRemainingExpression())
.map(IrUtils::extractConjuncts)
.flatMap(Collection::stream)
.sorted(comparing(Expression::toString))
.collect(toImmutableList()))));
these are already ordered by their string representation
from trino.
Related Issues (20)
- OPA: Disable information_schema access control checks
- ConnectorPageSource.getNextPage should not be called if isFinished returns true
- JSON_PARSE to honor duplicate key check? HOT 2
- IcebergSplit Class Loader
- Add a product test for variant type in Delta Lake
- Iceberg query failure because of predicate pushdown with iceberg column id
- unable to Connect Hudi from Trino in GCS HOT 2
- Iceberg table partition creation fails due to column name conflict with Trino's generated partitioning column name
- give me a complete example of Redis HOT 2
- give redis hash json how to write (geographical reasons)
- unable to connect hudi from trino HOT 2
- Query taking longer time in the Planning Phase HOT 1
- Change length of `client_info` column in MySQL event listener HOT 2
- MethodTooLargeException When Aggregation Funcation Use More Than 6 Parameters HOT 1
- Failed to run the optimize command to merge small files in Iceberg after upgrading Trino to version 444 HOT 2
- approx_percentile inaccurate
- How to access data from multiple storage
- is it possible to query data on different s3 bucket?
- Deleted records returned when using equality deletes with Iceberg and filtering by non-partitioned columns HOT 1
- Username is visible in Trino UI in plaintext form
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from trino.