-
Notifications
You must be signed in to change notification settings - Fork 8.3k
Allow to query projection directly. #35017
Copy link
Copy link
Closed
Labels
comp-projectionsProjections: precomputed layouts for accelerating queries (projection parts, maintenance).Projections: precomputed layouts for accelerating queries (projection parts, maintenance).featurenot plannedKnown issue, no plans to fix it currenltyKnown issue, no plans to fix it currenlty
Description
Use case
Manually run query against specific projection.
For https://kb.altinity.com/altinity-kb-queries-and-syntax/partial-projection-optimization/ it will allow to remove double GROUP BY from query.
Also it will allow to not run index scan against source table, which could take some time.
Describe the solution you'd like
SELECT key, sum(value) FROM database.table.projection_name GROUP BY key
Reactions are currently unavailable
Metadata
Metadata
Assignees
Labels
comp-projectionsProjections: precomputed layouts for accelerating queries (projection parts, maintenance).Projections: precomputed layouts for accelerating queries (projection parts, maintenance).featurenot plannedKnown issue, no plans to fix it currenltyKnown issue, no plans to fix it currenlty