[META] [Star Tree] [Search] Supported Queries to resolve via star tree

[sandeshkr419]

Please describe the end goal of this project

This issue keeps a tracker of supported aggregations & query shapes which can be resolved via star-tree composite indices.
This will basically keep a track of supported and planned query shapes which can utilize star-tree aggregation for faster computation.

As for 2.17 release, only numeric fields are supported in star-tree composite indices. The list will be updated as we identify more query shapes that we can pick up.
Community - Please do share/comment on what all you think should be prioritized.

1. Metric aggregations (no query, no sub-aggregations) [IN-PROGRESS - target 2.18]
   Metric aggregations - include sum, min, max, count, avg

2. Metric aggregations (terms query, no sub-aggregations) [IN-PROGRESS - target 2.18]

3. Metric aggregations (range query, no sub-aggregations) [TO-DO - target 2.18]

4. Metric aggregations (date-histograms) [TO-DO - target 2.18]

5. Metric aggregations (combination of queries in 1-4, no sub-aggregations) [TO-DO - target 2.18]

6. Metric aggregations (query shapes as in 1-5, with sub-aggregations) [TO-DO - target 2.18]

7. Terms aggregation [TO-DO - target 2.19]

Supporting References

#13875

Issues

Terms Query with no sub-aggregation: #14871

Related component

Search:Aggregations