cassandra-commits mailing list archives

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

    [ 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-unsubscribe@cassandra.apache.org
For additional commands, e-mail: commits-help@cassandra.apache.org


Mime
View raw message