[ https://issues.apache.org/jira/browse/CASSANDRA-18615?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17737270#comment-17737270 ]
Caleb Rackliffe edited comment on CASSANDRA-18615 at 6/26/23 4:56 PM: ---------------------------------------------------------------------- SASI is already experimental, and the release SAI should allow us to deprecate it, then eventually remove it (although I would say after 5.0). Existing SASI tests that use {{CREATE CUSTOM INDEX}} haven't been touched of course, but we do not need to support or document it around the changes in this patch. was (Author: maedhroz): SASI is already experimental, and the release SAI should allow us to deprecate it, then eventually remove it. Existing SASI tests that use {{CREATE CUSTOM INDEX}} haven't been touched of course, but we do not need to support or document it around the changes in this patch. > CREATE INDEX Modifications for Initial Release of SAI > ----------------------------------------------------- > > Key: CASSANDRA-18615 > URL: https://issues.apache.org/jira/browse/CASSANDRA-18615 > Project: Cassandra > Issue Type: Improvement > Components: CQL/Syntax, Feature/SAI > Reporter: Caleb Rackliffe > Assignee: Caleb Rackliffe > Priority: Normal > Fix For: NA > > Time Spent: 3h 10m > Remaining Estimate: 0h > > After a lengthy discussion on the dev list, the community seems to have > arrived at the following list of TODOs before we release SAI in 5.0: > 1.) CREATE INDEX should be expanded to support {{USING … WITH OPTIONS…}} > Essentially, we should be able to do something like {{CREATE INDEX ON tbl(v) > USING ’sai’ WITH OPTIONS = ...}} and {{CREATE INDEX ON tbl(v) USING > ‘cassandra’}} as a more specific/complete way to emulate the current behavior > of {{CREATE INDEX}}. > 2.) Allow operators to configure, in the YAML, a.) whether an index > implementation must be specified w/ USING and {{CREATE INDEX}} and b.) what > the default implementation will be, if {{USING}} isn’t required. > 3.) The defaults we ship w/ will avoid breaking existing {{CREATE INDEX}} > usage. (i.e. A default is allowed, and that default will remain ‘cassandra’, > or the legacy 2i) > With all this in place, users should be able create SAI indexes w/ the > simplest possible syntax, no defaults will change, and operators will have > the ability to change defaults to favor SAI whenever they like. -- This message was sent by Atlassian Jira (v8.20.10#820010) --------------------------------------------------------------------- To unsubscribe, e-mail: commits-unsubscr...@cassandra.apache.org For additional commands, e-mail: commits-h...@cassandra.apache.org