incubator-cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jens Rantil <jens.ran...@tink.se>
Subject Re: Primary key question
Date Tue, 01 Jul 2014 09:57:34 GMT
Hi Wim,

Yes, that is looks correct to me.

Cheers,
Jens


On Tue, Jul 1, 2014 at 8:37 AM, Wim Deblauwe <wim.deblauwe@gmail.com> wrote:

> 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