cassandra-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jonathan Ellis (JIRA)" <>
Subject [jira] Updated: (CASSANDRA-1157) add support for multiple indexexpressions
Date Sat, 24 Jul 2010 05:15:50 GMT


Jonathan Ellis updated CASSANDRA-1157:

    Attachment: 1157-v2.txt

I did correct TV to allow unindexed expressions as long as there was a single indexed one.
 The problem was a bug in the system test -- it wasn't actually rebuilding the RowPredicate,
so each call was using the original single-expressing clause.  v2 attached.

(Your TV change, btw, would allow queries with no indexed expressions, as long as there was
more than one undexed one.)

> add support for multiple indexexpressions
> -----------------------------------------
>                 Key: CASSANDRA-1157
>                 URL:
>             Project: Cassandra
>          Issue Type: Sub-task
>            Reporter: Jonathan Ellis
>            Assignee: Jonathan Ellis
>             Fix For: 0.7 beta 1
>         Attachments: 1157-v2.txt, 1157.txt, 1157_thrift_validation_fix_w_tests.txt
> we should:
>  - use the statistics from CASSANDRA-1155 to figure out which index has the highest selectivity,
and start with that
>  - if other indexes have high selectivity (average number of columns in an index row
is less than 1% of total in that CF), we should do a merge join
>  - otherwise, just loop the results from the first and reject un-satisfied expressions

This message is automatically generated by JIRA.
You can reply to this email to add a comment to the issue online.

View raw message