Hi All,

I am trying to have a table that I can have a key for one CQL to get a row based on a key and another CQL to where I have a list of keys using the "IN" keyword and have an ORDER BY clause. The data I am getting is from the Column value not the Column Name. The issue I am having is trying to setup the column family to achieve this. I have this cli command to create the column family but when I go do an insert I get a odd exception about the Primary key. Below is the cli and the error when doing the insert of column values after the column family was created.

The cli command used to create the column family:

create column family video_item_details
with key_validation_class = 'CompositeType(IntegerType,UTF8Type)'
and comparator = 'UTF8Type'
and column_metadata = [
{column_name : key, validation_class: IntegerType, index_type: KEYS}
{column_name : name, validation_class : 'UTF8Type', index_type: KEYS}
{column_name : description, validation_class :'UTF8Type'}
{column_name : url, validation_class : 'UTF8Type'}
{column_name : play_time, validation_class : 'UTF8Type'}
{column_name : type, validation_class : 'UTF8Type'}
]
with caching='ALL';

the error during insert is:

Error while inserting com.datastax.driver.core.exceptions.InvalidQueryException: Missing mandatory PRIMARY KEY part key2

The insert statement that was being attempted to be executed was:

INSERT INTO video.video_item_details(key, name, description, url, play_time, type) values(1,'Gettysburg','Gettysburg Movie Trailer','http://localhost/test.avi','2:53','Streaming')

From the links sent to me and the examples googling I have found only cli comands using CompositeType for comparitor and not validator and also for only one Primary Key and not a Compound Primary key using CompositeType. Thus I am stuck on something I feel should be a standard thing to do with a column family but no working examples.

Thanks for any advice on how to get Cassandra to do this type of query.

Best Regards,
-Tony