Hi what is the most efficient way to get a distinct key list from a big table (aprox 20 mil inserts per minute) ?
equivalent to *select distinct key from my_table *for this table *CREATE TABLE my_table (* * key text,* * timestamp bigint,* * value double,* * PRIMARY KEY (key, timestamp) )* I need to execute this query quite often ( every couple of minutes ) I can of course maintain a table to hold only unique set of keys but this is of course error prone so I rather avoid it. but it's an option. Cheers Avi