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

    • Severity:
      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

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

              Dates

              • Created:
                Updated: