[jira] Updated: (CASSANDRA-1157) add support for multiple indexexpressions
[ https://issues.apache.org/jira/browse/CASSANDRA-1157?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jonathan Ellis updated CASSANDRA-1157: -- Attachment: 1157.txt add support for multiple indexexpressions - Key: CASSANDRA-1157 URL: https://issues.apache.org/jira/browse/CASSANDRA-1157 Project: Cassandra Issue Type: Sub-task Reporter: Jonathan Ellis Fix For: 0.7 beta 1 Attachments: 1157.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.
[jira] Updated: (CASSANDRA-1157) add support for multiple indexexpressions
[ https://issues.apache.org/jira/browse/CASSANDRA-1157?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Nate McCall updated CASSANDRA-1157: --- Attachment: 1157_thrift_validation_fix_w_tests.txt modified thrift validation to allow for indexed and unindexed columns in the same expression as long as there are more than one valid one add support for multiple indexexpressions - Key: CASSANDRA-1157 URL: https://issues.apache.org/jira/browse/CASSANDRA-1157 Project: Cassandra Issue Type: Sub-task Reporter: Jonathan Ellis Assignee: Jonathan Ellis Fix For: 0.7 beta 1 Attachments: 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.
[jira] Updated: (CASSANDRA-1157) add support for multiple indexexpressions
[ https://issues.apache.org/jira/browse/CASSANDRA-1157?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] 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: https://issues.apache.org/jira/browse/CASSANDRA-1157 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.