Re: [Hawkular-dev] C* schema design
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.