summaryrefslogtreecommitdiff
path: root/src/main/resources/dsl-sql-template.sql
diff options
context:
space:
mode:
Diffstat (limited to 'src/main/resources/dsl-sql-template.sql')
-rw-r--r--src/main/resources/dsl-sql-template.sql6
1 files changed, 6 insertions, 0 deletions
diff --git a/src/main/resources/dsl-sql-template.sql b/src/main/resources/dsl-sql-template.sql
index e94ba6c6..19d31808 100644
--- a/src/main/resources/dsl-sql-template.sql
+++ b/src/main/resources/dsl-sql-template.sql
@@ -54,4 +54,10 @@ SELECT %s FROM $table WHERE $intervals_and_filter %s %s %s $limit
#end
#sql("CUSTOMIZED_STATISTICS_SUBQUERY_TOPK")
(%s) IN (SELECT %s FROM $table WHERE $intervals_and_filter %s %s $limit)
+#end
+#sql("LOG_QUERY_TIMELINE")
+SELECT FROM_UNIXTIME(TIME_FLOOR_WITH_FILL(%s, '$granularity', 'zero')) AS stat_time, COUNT(1) AS count %s FROM $table WHERE $intervals_and_filter GROUP BY stat_time %s
+#end
+#sql("LOG_QUERY_LIST")
+SELECT %s FROM $table WHERE $intervals_and_filter ORDER BY %s $limit
#end \ No newline at end of file