From 207df6fc406e81bfeebdff7f404bd242ff3f099f Mon Sep 17 00:00:00 2001 From: Daniel Baumann Date: Tue, 7 May 2024 06:48:35 +0200 Subject: Merging upstream version 0.12.2. Signed-off-by: Daniel Baumann --- example-scripts/report-demo.lnav | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) (limited to 'example-scripts') diff --git a/example-scripts/report-demo.lnav b/example-scripts/report-demo.lnav index aeb0040..aa80d4c 100644 --- a/example-scripts/report-demo.lnav +++ b/example-scripts/report-demo.lnav @@ -17,7 +17,7 @@ ;SELECT printf('\n%d total requests', count(1)) AS msg FROM access_log :echo $msg -;WITH top_paths AS ( +;WITH top_paths AS MATERIALIZED ( SELECT cs_uri_stem, count(1) AS total_hits, @@ -28,7 +28,7 @@ GROUP BY cs_uri_stem ORDER BY total_hits DESC LIMIT 50), - weekly_hits_with_gaps AS ( + weekly_hits_with_gaps AS MATERIALIZED ( SELECT timeslice(log_time_msecs, '1w') AS week, cs_uri_stem, count(1) AS weekly_hits -- cgit v1.2.3