Hello all, I need to create a Cassandra column family with following attributes.
id bigint, content varchar, year int, frequency int, I want to get the content with highest frequency in a given year using this column family. Also when inserting data to table, for given content and year, I need to check if an id already exist or not. How can I achieve this with Cassandra? I tried creating CF using CREATE TABLE sinmin.word_time_inv_frequency ( id bigint, content varchar, year int, frequency int, PRIMARY KEY((year), frequency) ); and then retrieved data using SELECT id FROM word_time_inv_frequency WHERE year = 2010 ORDER BY frequency ; But when using this, I can't check if entry is already existing for the (content,year) pair in the CF. Thank You! -- *Chamila Dilshan Wijayarathna,* SMIEEE, SMIESL, Undergraduate, Department of Computer Science and Engineering, University of Moratuwa.
