Incremental data reduction: SQL-defined view
Example: log_entries_per_process_per_minute transform query
SELECT date_bin('1 minute', time) as time_bin,
min(time) as min_time,
max(time) as max_time,
process_id,
sum(fatal) as nb_fatal,
sum(err) as nb_err,
sum(warn) as nb_warn,
sum(info) as nb_info,
sum(debug) as nb_debug,
sum(trace) as nb_trace
FROM (SELECT process_id,
time,
CAST(level==1 as INT) as fatal,
CAST(level==2 as INT) as err,
CAST(level==3 as INT) as warn,
CAST(level==4 as INT) as info,
CAST(level==5 as INT) as debug,
CAST(level==6 as INT) as trace
FROM log_entries
WHERE insert_time >= '{begin}'
AND insert_time < '{end}' )
GROUP BY process_id, time_bin
ORDER BY time_bin, process_id;