[ 
https://issues.apache.org/jira/browse/CASSANDRA-13499?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16010614#comment-16010614
 ] 

vincent royer commented on CASSANDRA-13499:
-------------------------------------------

Yes, it is like DSE Search or Stratio Lucene, but if i'm not missing the point, 
these implementations does not allow to mix various index implementations, when 
you have for a regular index for column A and custom row-based index for column 
B+C, like in the following elassandra exemple. Moreover, with this row-based 
index, the custom index is notified for all updates, even those not related to 
indexed columns. And unfortunately, the alternative syntax CREATE INDEX ... 
<table>(col1,col2....) cannot be updated (no ALTER INDEX statement....). 

CREATE TABLE twitter.tweet (
    "_id" text PRIMARY KEY,
    message list<text>,
    "postDate" list<timestamp>,
    size int,
    user list<text>
) ...
CREATE INDEX tweet_size_idx ON twitter.tweet (size);
CREATE CUSTOM INDEX elastic_tweet_postDate_idx ON twitter.tweet 
(values("postDate")) USING 'org.elassandra.index.ExtendedElasticSecondaryIndex';
CREATE CUSTOM INDEX elastic_tweet_user_idx ON twitter.tweet (values(user)) 
USING 'org.elassandra.index.ExtendedElasticSecondaryIndex';
CREATE CUSTOM INDEX elastic_tweet_message_idx ON twitter.tweet 
(values(message)) USING 'org.elassandra.index.ExtendedElasticSecondaryIndex';



> Avoid duplicate calls to the same custom row index
> --------------------------------------------------
>
>                 Key: CASSANDRA-13499
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-13499
>             Project: Cassandra
>          Issue Type: Improvement
>          Components: Core
>            Reporter: vincent royer
>            Priority: Minor
>             Fix For: 3.0.14, 3.11.0, 4.x
>
>         Attachments: 0006-Avoid-duplicate-calls-to-the-same-custom-index.patch
>
>   Original Estimate: 2h
>  Remaining Estimate: 2h
>
> Avoid duplicate calls to the same custom row index by using a dedicated 
> Set<Index> rather than the collection indexes.values().



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)

---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@cassandra.apache.org
For additional commands, e-mail: commits-h...@cassandra.apache.org

Reply via email to