Untitled

CREATE TABLE my_table (
  hoscd_event_date date,
  hoscd_businessid text,
  hoscd_key text,
  hoscd_buid text,
  hoscd_createdtime timestamp,
  hoscd_opid text,
  hoscd_status text,
  hoscd_type text,
  hoscd_updatedtime timestamp,
  hoscd_username text,
  hoscd_value blob,
  hoscd_valuetype text,
  PRIMARY KEY ((hoscd_event_date, hoscd_opid, hoscd_buid, hoscd_key))
) WITH CLUSTERING ORDER BY (hoscd_opid ASC, hoscd_buid ASC, hoscd_key ASC);