ZCYkzzRs

1create table if not exists my_system.my_system_log_dated(
2  id uuid,
3  client_request_id text,
4  tenant_id text,
5  vertical_id text,
6  channel text,
7  event text,
8  event_type text,
9  created_date date,
10  primary key((created_date, tenant_id, vertical_id, channel, event), 
11  event_type, client_request_id, id)
12) with clustering order by (created_date desc);
13	
14create table if not exists my_system.my_system_log_dated(
15  id uuid,
16  client_request_id text,
17  tenant_id text,
18  vertical_id text,
19  channel text,
20  event text,
21  bucket_id int,
22  event_type text,
23  created_date date,
24  primary key((created_date, tenant_id, vertical_id, channel, event, 
25  bucket_id), event_type, client_request_id, id)
26) with clustering order by (created_date desc);