You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@cassandra.apache.org by "Andres de la Peña (Jira)" <ji...@apache.org> on 2023/07/18 11:40:00 UTC
[jira] [Comment Edited] (CASSANDRA-18615) CREATE INDEX Modifications for Initial Release of SAI
[ https://issues.apache.org/jira/browse/CASSANDRA-18615?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17744184#comment-17744184 ]
Andres de la Peña edited comment on CASSANDRA-18615 at 7/18/23 11:39 AM:
-------------------------------------------------------------------------
The repeated CI run shows [a single failure of most of the methods of {{StorageAttachedIndexDDLTest}}|https://app.circleci.com/pipelines/github/maedhroz/cassandra/744/workflows/8efbf733-8007-4092-8c26-e349b7fd9576/jobs/10731] during the same run. The failure seems environmental, due to an issue while binding a port to an address already in use. The other test failures ({{{}VirtualTableFromInternodeTest{}}} and JDK 17 stuff) are known issues. So I think CI results are good, +1.
was (Author: adelapena):
The repeated CI run shows [a single failure of most of the methods of {{StorageAttachedIndexDDLTest}}|https://app.circleci.com/pipelines/github/maedhroz/cassandra/744/workflows/8efbf733-8007-4092-8c26-e349b7fd9576/jobs/10731]. The failure seems environmental, due to an issue while binding a port to an address already in use. The other test failures ({{{}VirtualTableFromInternodeTest{}}} and JDK 17 stuff) are known issues. So I think CI results are good, +1.
> 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: 5.x
>
> Time Spent: 5h 50m
> 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-unsubscribe@cassandra.apache.org
For additional commands, e-mail: commits-help@cassandra.apache.org