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
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/99631.html
標籤：其他數據庫
上一篇：Access 比較資料表中的記錄