[Hawkular-dev] C* schema design

[Lucas Ponce]

> CREATE TABLE alerts (
> tenantid text,
> triggerid text,
> date timestamp,
> alertid text,
> payload text,
> PRIMARY KEY ((tenantid, triggerid, date), alertid)
> )
> 

Hey John,

Thanks for the tip, I had exactly this approach in my todo-list for adding triggerid in the partition key.
Also the date is interesting.

The main idea is to locate all info related on an specific trigger close, to avoid stress the full partition.