[ https://issues.apache.org/jira/browse/CASSANDRA-15042?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
William Preston updated CASSANDRA-15042: ---------------------------------------- Description: Cassandra 3.11.4 Running a query in cqlsh with TRACING ON Secondary indexes all report cardinalities as *1*. trace output: {code:java} Index mean cardinalities are country_idx:1,company_idx:1,source_idx:1,domain_idx:1. Scanning with country_idx. {code} Cassandra 2.2.x and its' predecessors reported cardinalities > 1 in cqlsh tracing output: "Candidate index mean cardinalities are CompositesIndexOnRegular{columnDefs=[ColumnDefinition {name=country, type=org.apache.cassandra.db.marshal.UTF8Type, kind=REGULAR, componentIndex=0, indexName=country_idx, indexType=COMPOSITES} ]}:*+2+*, CompositesIndexOnRegular{columnDefs=[ColumnDefinition {name=company, type=org.apache.cassandra.db.marshal.UTF8Type, kind=REGULAR, componentIndex=0, indexName=company_idx, indexType=COMPOSITES} ]}:*+1210+*, CompositesIndexOnRegular{columnDefs=[ColumnDefinition {name=source, type=org.apache.cassandra.db.marshal.UTF8Type, kind=REGULAR, componentIndex=0, indexName=source_idx, indexType=COMPOSITES} ]}:*+501804+*, CompositesIndexOnRegular{columnDefs=[ColumnDefinition {name=domain, type=org.apache.cassandra.db.marshal.UTF8Type, kind=REGULAR, componentIndex=0, indexName=domain, indexType=COMPOSITES} ]}:*+325801+*. Scanning with country_idx." was: Cassandra 3.11.4 Running a query in cqlsh with TRACING ON Secondary indexes all report cardinalities as *1*. trace output: "Index mean cardinalities are country_idx:+*1*+,company_idx:_*1*_,source_idx:+*1*+,domain_idx:+*1*+. Scanning with country_idx." Cassandra 2.2.x and its' predecessors reported cardinalities > 1 in cqlsh tracing output: "Candidate index mean cardinalities are CompositesIndexOnRegular\{columnDefs=[ColumnDefinition{name=country, type=org.apache.cassandra.db.marshal.UTF8Type, kind=REGULAR, componentIndex=0, indexName=country_idx, indexType=COMPOSITES}]}:*+2+*, CompositesIndexOnRegular\{columnDefs=[ColumnDefinition{name=company, type=org.apache.cassandra.db.marshal.UTF8Type, kind=REGULAR, componentIndex=0, indexName=company_idx, indexType=COMPOSITES}]}:*+1210+*, CompositesIndexOnRegular\{columnDefs=[ColumnDefinition{name=source, type=org.apache.cassandra.db.marshal.UTF8Type, kind=REGULAR, componentIndex=0, indexName=source_idx, indexType=COMPOSITES}]}:*+501804+*, CompositesIndexOnRegular\{columnDefs=[ColumnDefinition{name=domain, type=org.apache.cassandra.db.marshal.UTF8Type, kind=REGULAR, componentIndex=0, indexName=domain, indexType=COMPOSITES}]}:*+325801+*. Scanning with country_idx." > cqlsh tracing output reports all secondary "Index mean cardinalities" are 1. > ----------------------------------------------------------------------------- > > Key: CASSANDRA-15042 > URL: https://issues.apache.org/jira/browse/CASSANDRA-15042 > Project: Cassandra > Issue Type: Bug > Components: Legacy/Tools > Reporter: William Preston > Priority: Minor > > Cassandra 3.11.4 > Running a query in cqlsh with TRACING ON > Secondary indexes all report cardinalities as *1*. > trace output: > {code:java} > Index mean cardinalities are > country_idx:1,company_idx:1,source_idx:1,domain_idx:1. Scanning with > country_idx. > {code} > Cassandra 2.2.x and its' predecessors reported cardinalities > 1 in cqlsh > tracing output: > "Candidate index mean cardinalities are > CompositesIndexOnRegular{columnDefs=[ColumnDefinition > {name=country, type=org.apache.cassandra.db.marshal.UTF8Type, kind=REGULAR, > componentIndex=0, indexName=country_idx, indexType=COMPOSITES} > ]}:*+2+*, CompositesIndexOnRegular{columnDefs=[ColumnDefinition > {name=company, type=org.apache.cassandra.db.marshal.UTF8Type, kind=REGULAR, > componentIndex=0, indexName=company_idx, indexType=COMPOSITES} > ]}:*+1210+*, CompositesIndexOnRegular{columnDefs=[ColumnDefinition > {name=source, type=org.apache.cassandra.db.marshal.UTF8Type, kind=REGULAR, > componentIndex=0, indexName=source_idx, indexType=COMPOSITES} > ]}:*+501804+*, CompositesIndexOnRegular{columnDefs=[ColumnDefinition > {name=domain, type=org.apache.cassandra.db.marshal.UTF8Type, kind=REGULAR, > componentIndex=0, indexName=domain, indexType=COMPOSITES} > ]}:*+325801+*. > Scanning with country_idx." > -- This message was sent by Atlassian JIRA (v7.6.3#76005) --------------------------------------------------------------------- To unsubscribe, e-mail: commits-unsubscr...@cassandra.apache.org For additional commands, e-mail: commits-h...@cassandra.apache.org