cassandra-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "vincent royer (JIRA)" <>
Subject [jira] [Commented] (CASSANDRA-13499) Avoid duplicate calls to the same custom row index
Date Mon, 15 May 2017 14:34:04 GMT


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
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:
>             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

To unsubscribe, e-mail:
For additional commands, e-mail:

View raw message