[CASSANDRA-13228] SASI index on partition key part doesn't match

• Type: Bug
• Status: Resolved
• Priority: Normal
• Resolution: Fixed
• Fix Version/s: 3.11.0
• Component/s: Feature/SASI
• Labels: sasi
• Severity: Normal
• Assignee: Andres de la Peña
• Reporter: Hannu Kröger

Authors

Andres de la Peña

Reviewers

Alex Petrov

• Created: 16/Feb/17 01:24
• Updated: 16/Apr/19 09:30
• Resolved: 10/May/17 09:22

Description

I created a SASI index on first part of multi-part partition key. Running query using that index doesn't seem to work.

I have here a log of queries that should indicate the issue:

cqlsh:test> CREATE TABLE test1(name text, event_date date, data_type text, bytes int, PRIMARY KEY ((name, event_date), data_type));
cqlsh:test> CREATE CUSTOM INDEX test_index ON test1(name) USING 'org.apache.cassandra.index.sasi.SASIIndex';
cqlsh:test> INSERT INTO test1(name, event_date, data_type, bytes) values('1234', '2010-01-01', 'sensor', 128);
cqlsh:test> INSERT INTO test1(name, event_date, data_type, bytes) values('abcd', '2010-01-02', 'sensor', 500);
cqlsh:test> select * from test1 where NAME = '1234';

 name | event_date | data_type | bytes
------+------------+-----------+-------

(0 rows)
cqlsh:test> CONSISTENCY ALL;
Consistency level set to ALL.
cqlsh:test> select * from test1 where NAME = '1234';

 name | event_date | data_type | bytes
------+------------+-----------+-------

(0 rows)

Note! Creating a SASI index on single part partition key, SASI index creation fails. Apparently this should not work at all, so is it about missing validation on index creation?

Issue Links

• is related to: CASSANDRA-11734 Enable partition component index for SASI