/** * 创建轨迹表 */ CREATE TABLE log_info ( app_name text, req_date text, req_time text, login_id text, req_method text, req_url text, req_proto text, req_ua text, req_referer text, req_post_data text, resp_time text, resp_body text, resp_code text, resp_msg text, resp_data text, cost_time double, primary key((app_name, req_date), req_time, login_id) ) WITH CLUSTERING ORDER BY (req_time DESC) AND COMPACTION = {'class': 'TimeWindowCompactionStrategy', 'compaction_window_unit': 'DAYS', 'compaction_window_size': 1};