incubator-cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Wim Deblauwe <wim.debla...@gmail.com>
Subject Primary key question
Date Tue, 01 Jul 2014 06:37:45 GMT
Hi,

I have the following table:

CREATE TABLE integration_time (
message_source_id uuid,
traffic_data_type varchar,
integration_period varchar,
integration_time timestamp,
PRIMARY KEY ((message_source_id,traffic_data_type,integration_period))
);

I want the combination of (message_source_id, traffic_data_type,
integration_period) to be unique. Is this the correct way to do it (with
the double brackets) ?

This table will be relative small, it just stores the last time something
was done in the application for that unique combination of those 3
parameters. Worst case there will be 30000 rows in that table and they will
always be fetched by quering on the 3 parameters at the same time.

regards,

Wim

Mime
View raw message