+1. Nice feature to have. On Mon, Aug 17, 2026 at 2:27 PM Mike Carey <[email protected]> wrote:
> +1 as well! > > It has been carefully designed to be as much like GROUP BY as possible > to avoid setting any unnecessary new precedents in terms of SQL++ > expressions and their semantics. It will be interesting to get this in > the hands of some first users! > > On 8/17/26 12:54 PM, Glenn Galvizo wrote: > > +1 (really really cool idea, esp. the CLUSTER AS to really leverage what > > SQL++ can do) > > > > On Mon, Aug 17, 2026 at 11:39 AM Ian Maxon<[email protected]> wrote: > > > >> +1 to adding this. It's a really awesome idea. It really fits well > >> into the approximate search support that AsterixDB has featured and > >> integrated deeply, ever since the first open source release > >> (pre-apache). Being able to express something that is usually a giant > >> imperative pipeline as a simple declarative expression is very unique. > >> > >> On Mon, Aug 17, 2026 at 11:35 AM Hongyu Shi<[email protected]> wrote: > >>> Hi all, Initiating discussion to add cluster-by clause in AsterixDB. > >>> Feature: Cluster-By Clause > >>> > >>> While GROUP BY is the canonical clause for analytic queries to further > >>> understand the trend and nature of the underlying data, our proposed > >>> Cluster-By clause is for users to find the patterns and trends of > vector > >>> embeddings by putting similar vector embeddings into some number of > >>> clusters. > >>> > >>> Clustering (CLUSTER BY) functionality for vector embeddings is similar > to > >>> grouping (GROUP BY) for structured fields with the difference that > >>> clustering for vector embeddings is a fuzzy and similarity-based > >> clustering > >>> while grouping of structured fields is exact value grouping. Due to the > >>> similarities between the two approaches, clustering functionality is > >>> proposed here to be added to SQL++ syntax using CLUSTER BY and CLUSTER > >> AS, > >>> following the design and syntax of existing GROUP BY and GROUP AS > clauses > >>> in SQL++. > >>> APE: > >>> > >> > https://cwiki.apache.org/confluence/spaces/ASTERIXDB/pages/406621607/APE+33+CLUSTER+BY > >>> Thanks, Hongyu Shi -- Regards,
