You've already forked mariadb-columnstore-engine
mirror of
https://github.com/mariadb-corporation/mariadb-columnstore-engine.git
synced 2025-10-31 18:30:33 +03:00
34 lines
1.9 KiB
Plaintext
34 lines
1.9 KiB
Plaintext
USE tpch1;
|
|
DROP TABLE IF EXISTS query_class_metrics_float;
|
|
CREATE TABLE `query_class_metrics_float` (
|
|
`agent_id` bigint(20) DEFAULT NULL,
|
|
`start_ts` datetime DEFAULT NULL,
|
|
`query_class` int(11) DEFAULT NULL,
|
|
`query_time_sum` float DEFAULT NULL)
|
|
ENGINE=Columnstore;
|
|
INSERT INTO query_class_metrics_float VALUES (1, '2013-06-18 22:55:00', 1563, 0.281992);
|
|
INSERT INTO query_class_metrics_float VALUES (1, '2013-06-18 23:00:00', 1563, 0.292305);
|
|
INSERT INTO query_class_metrics_float VALUES (1, '2013-06-18 23:05:00', 1563, 0.215658);
|
|
INSERT INTO query_class_metrics_float VALUES (1, '2013-06-18 23:10:00', 1563, 0.243597);
|
|
INSERT INTO query_class_metrics_float VALUES (1, '2013-06-18 23:15:00', 1563, 0.35189);
|
|
INSERT INTO query_class_metrics_float VALUES (1, '2013-06-18 23:20:00', 1563, 0.543079);
|
|
INSERT INTO query_class_metrics_float VALUES (1, '2013-06-18 23:25:00', 1563, 0.495779);
|
|
INSERT INTO query_class_metrics_float VALUES (1, '2013-06-18 23:30:00', 1563, 0.589326);
|
|
INSERT INTO query_class_metrics_float VALUES (1, '2013-06-18 23:35:00', 1563, 0.210907);
|
|
INSERT INTO query_class_metrics_float VALUES (1, '2013-06-18 23:40:00', 1563, 0.167944);
|
|
INSERT INTO query_class_metrics_float VALUES (1, '2013-06-18 23:45:00', 1563, 0.202401);
|
|
SELECT start_ts, Query_time_sum,round(avg(Query_time_sum) OVER(order by start_ts), 8) prev_sum from query_class_metrics_float where agent_id=1 and query_class=1563 limit 50;
|
|
start_ts Query_time_sum prev_sum
|
|
2013-06-18 22:55:00 0.281992 0.28199199
|
|
2013-06-18 23:00:00 0.292305 0.28714849
|
|
2013-06-18 23:05:00 0.215658 0.26331833
|
|
2013-06-18 23:10:00 0.243597 0.25838799
|
|
2013-06-18 23:15:00 0.35189 0.27708839
|
|
2013-06-18 23:20:00 0.543079 0.32142017
|
|
2013-06-18 23:25:00 0.495779 0.34632857
|
|
2013-06-18 23:30:00 0.589326 0.37670325
|
|
2013-06-18 23:35:00 0.210907 0.35828145
|
|
2013-06-18 23:40:00 0.167944 0.33924770
|
|
2013-06-18 23:45:00 0.202401 0.32680709
|
|
DROP TABLE query_class_metrics_float;
|