CREATETABLEgsg.callback_queue(
keyblob,
column1bigint,
column2text,
valueblob,
PRIMARYKEY(key,column1,column2)
)WITHCOMPACTSTORAGE
ANDCLUSTERINGORDERBY(column1ASC,column2ASC)
ANDcaching='{"keys":"ALL","rows_per_partition":"NONE"}'
ANDcomment=''
ANDcompaction={'class':'org.apache.cassandra.db.compaction.LeveledCompactionStrategy'}
ANDcompression={'sstable_compression':'org.apache.cassandra.io.compress.LZ4Compressor'}
ANDdclocal_read_repair_chance=0.1
ANDdefault_time_to_live=0
ANDgc_grace_seconds=43200
ANDmax_index_interval=2048
ANDmemtable_flush_period_in_ms=0
ANDmin_index_interval=128
ANDread_repair_chance=0.0
ANDspeculative_retry='NONE';
上面是表结构,咱想要的是只按cloumn2查询,但是很显然,不行,需要加cloum1,但是我没有cloumn1的数据啊……,官方建议用第二索引,但是报这个SecondaryindexesarenotsupportedonPRIMARYKEYcolumnsinCOMPACTSTORAGEtables
分 --> |