Given the CREATE TABLE GSG. Callback_queue (
The key blob,
Column1 bigint,
Column2 text,
The 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 the comment='
AND a compaction={' class ':' org.apache.cassandra.db.com paction. LeveledCompactionStrategy}
AND compression will={' sstable_compression ':' org.apache.cassandra.io.com press. 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';



Is above the table structure, I want is only the cloumn2 queries, but apparently, no need to add cloum1, but I don't have cloumn1 data... , official suggested that in a second index, but the Secondary indexes are not supported on PRIMARY KEY columns in the COMPACT STORAGE tables