Uploaded image for project: 'Cassandra'
  1. Cassandra
  2. CASSANDRA-15042

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

    XMLWordPrintableJSON

Details

    • Normal

    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.

       

       

      Attachments

        Activity

          People

            Unassigned Unassigned
            wbp William Preston
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated: