Cassandra Table design for Historical state information -
my requirement design table historical state information (not time-series). ex: have devices connecting , disconnecting management platform. want know details such (name, mac address, os, image, etc.) devices connected management platform in given interval (start , end time).
any on table design use-case?
if want know if connected during interval, should work in traditional time series approach:
create table device_state( deviceid, timeofevent, state, details, primary key (deviceid, timeofevent, state) select details device_state timeofevent > '2001-01-01 12:01:01.000' , timeofevent < '2001-01-01 12:15:59.000' , state = 'connected';
if want know if device connected entire time, need implement client side logic.
Comments
Post a Comment