[CASSANDRA-15042] cqlsh tracing output reports all secondary "Index mean cardinalities" are 1. SASI report as -9223372036854775808

• Type: Bug
• Status: Open
• Priority: Normal
• Resolution: Unresolved
• Component/s: Feature/SASI, Legacy/Tools, Observability/Tracing
• Severity: Normal
• Assignee: Unassigned
• Reporter: William Preston
• Created: 04/Mar/19 20:35
• Updated: 16/Apr/19 09:29

Description

Cassandra 3.11.4
Running a query in cqlsh with TRACING ON

Native 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.