> > On Fri, Dec 20, 2024 at 5:36 PM Caleb Rackliffe <calebrackli...@gmail.com> > wrote: > >> You mean like to control the tokenization/analysis of query terms? >> > Yes. Elastic for example lets you specify the query time analyzer in the query, over riding what is specified at the index level.
https://www.elastic.co/guide/en/elasticsearch/reference/current/specify-analyzer.html#specify-search-query-analyzer On Dec 20, 2024 at 5:37:58 PM, Caleb Rackliffe <calebrackli...@gmail.com> wrote: > So that would look something like... > > SELECT ... FROM ... WHERE ... WITH OPTIONS = { 'exclude_indexes' : > [<ks.idx1>, <ks.idx2>] } > Yeah something like that would work. On Dec 20, 2024 at 5:37:58 PM, Caleb Rackliffe <calebrackli...@gmail.com> wrote: > So that would look something like... > > SELECT ... FROM ... WHERE ... WITH OPTIONS = { 'exclude_indexes' : > [<ks.idx1>, <ks.idx2>] } > > On Fri, Dec 20, 2024 at 5:36 PM Caleb Rackliffe <calebrackli...@gmail.com> > wrote: > >> You mean like to control the tokenization/analysis of query terms? >> >> On Fri, Dec 20, 2024 at 4:38 PM Jeremiah Jordan < >> jeremiah.jor...@gmail.com> wrote: >> >>> Rather than WITH INDEX/WITHOUT INDEX what about WITH OPTIONS {}. If we >>> move into allowing analysis/tokenization on indexed items, then a more >>> general WITH OPTIONS would be useful for that too. That would let us add >>> any other new options to a SELECT without needing to modify the grammar >>> further. >>> >>> -Jeremiah >>> >>> On Dec 20, 2024 at 2:28:58 PM, Caleb Rackliffe <calebrackli...@gmail.com> >>> wrote: >>> >>>> Some of your are probably familiar with work in the DS fork to improve >>>> the selection of indexes for SAI queries in >>>> https://github.com/datastax/cassandra/commit/eeb33dd62b9b74ecf818a263fd73dbe6714b0df0#diff-2830028723b7f4af5ec7450fae2c206aeefa5a2c3455eff6f4a0734a85cb5424 >>>> . >>>> >>>> While I'm eagerly anticipating working on that in the new year, I'm >>>> also wondering whether we think some simple CQL extensions to manually >>>> control index selection would be helpful. Maxwell proposed this a while >>>> back in CASSANDRA-18112, and I'd like to propose a syntax: >>>> >>>> >>>> ex. Do not use the specified index during the query. >>>> >>>> SELECT ... FROM ... WHERE ... WITHOUT INDEX <ks.idx> >>>> >>>> This could be helpful for intersection queries where one of the >>>> provided clauses is not very selective and could simply be handled via >>>> post-filtering. >>>> >>>> ex. Require the specified index to be used. >>>> >>>> SELECT ... FROM ... WHERE ... WITH INDEX <ks.idx> >>>> >>>> This could be helpful in scenarios where multiple indexes exist on a >>>> column and was the primary motivation for CASSANDRA-18112. >>>> >>>> Thoughts? >>>> >>>
