cassandra 中对不能建立索引 的primarykey中第三个值的查询怎么搞啊,要炸了。
CREATE TABLE gsg.callback_queue (
key blob,
column1 bigint,
column2 text,
value blob,
PRIMARY KEY (key, column1, column2)
) WITH COMPACT STORAGE
AND CLUSTERING ORDER BY (column1 ASC, column2 ASC)
AND caching = '{"keys":"ALL", "rows_per_partition":"NONE"}'
AND comment = ''
AND compaction = {'class': 'org.apache.cassandra.db.compaction.LeveledCompactionStrategy'}
AND compression = {'sstable_compression': 'org.apache.cassandra.io.compress.LZ4Compressor'}
AND dclocal_read_repair_chance = 0.1
AND default_time_to_live = 0
AND gc_grace_seconds = 43200
AND max_index_interval = 2048
AND memtable_flush_period_in_ms = 0
AND min_index_interval = 128
AND read_repair_chance = 0.0
AND speculative_retry = 'NONE';
上面是表结构,咱想要的是只按cloumn2查询,但是很显然,不行,需要加cloum1,但是我没有cloumn1的数据啊……,官方建议用第二索引,但是 报这个 Secondary indexes are not supported on PRIMARY KEY columns in COMPACT STORAGE tables