light-apiengine/middleware/logger_cassandra.cql

/**
 * 创建轨迹表
 */
CREATE TABLE log_info (
    req_date text,
    req_time 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(req_date, req_time)
) WITH CLUSTERING ORDER BY (req_time DESC)
       AND COMPACTION = {'class': 'TimeWindowCompactionStrategy',
                     'compaction_window_unit': 'DAYS',
                     'compaction_window_size': 1};