Torch Log Service
Torch Log Service
Torch Log Service
Document
Product News
Product Overview
Product Billing
User Guide
TLS Agent
AgentLoop
Resource management
Host group
Data collection
LogCollector collection
Introduction to LogCollector
Installation and upgrade
Collect host logs
Collect container logs
LogCollector plugins
Manage LogCollector
general reference
Data import
Cloud product log collection
TOS log collection
DBW log collection
VPN Log collection
VKE log collection
CLB log collection
CloudTrail log collection
CFW log collection
NTA log collection
ALB log collection
APMPlus log collection
veFaaS log collection
VPC log collection
veImageX log collection
TrafficRoute DNS log collection
DDoS log collection
WAF log collection
DCDN log collection
Multi-cloud security platform log collection
APIG log collection
Machine learning task log collection
CR log collection
Volcano Ark application lab log collection
FileNAS log collection
LLM Application Firewall Service log collection
vePFS log collection
Cloud security center log collection
EFS log collection
Data storage
Query and analysis
Configure log indexes
Query log
Analyze logs
Query and analyze logs using third-party tools
Associate external data source for log query
SQL function
SQL syntax
Visualization
Query and analysis charts
Summaries of query and analysis charts
Create dashboard
Use dashboard
Add dashboard filters and variables
Use other systems to analyze logs
Log application
Log applications for product observability
Log applications for large models observability
Coding Agent log app
ModelProvider log app
No-coding Agent log app
Log applications for basic service monitoring
Data processing
Data transformation
Syntax and functions
Global operation function
expression function
Data processing best practices
general reference
Data write processor
Data consumer processor
Data consumption and shipping
Ship logs to TOS
Ship logs to Kafka
Ship logs to Splunk
Alarm
Alarm policy
Alarm notification content
Alarm notification content template
alarm notification channel
Tracing service
Monitor Log Service
API reference
Project management API
Topic management API
Shard management API
Index management API
Log management API
Host group management API
Collection configuration management API
Data import API
Data processor API
Data transformation API
Data backflow API
SQL analysis API
Alarm management API
Consumer group management API
Kafka protocol consumption API
Tag management API
Trace storage API
Account management API
SDK reference
Go SDK
Java SDK
Python SDK
iOS SDK
C++ SDK
CLI reference
Best practices
Data collection
Query and analysis
permission management
Consumption and delivery
Visualization
Alarm
FAQs
Billing and cost FAQ
Data collection FAQ
Data storage FAQ
Index configuration FAQ
Query and analysis FAQ
Scheduled SQL tasks FAQ
Alarm FAQ
- Documentation
Torch Log ServiceUser GuideData processingTimed SQL AnalysisSQL time window syntax
Copy page
Download PDFTimed SQL Analysis
SQL time window syntax
Copy pageDownload PDFSQL time window syntax
When creating a scheduled SQL task, you need to specify the SQL time window in the SQL analysis rule configuration, which defines the time range for query and analysis of logs. The SQL time window must follow specific syntax rules. This topic describes these rules and provides examples of expressions for common scenarios.
Syntax format
The SQL time window syntax supports the following formats:
Format | Description |
Format | Description |
@{unit} | Round down from the original time. For example, @h means rounding time to the nearest hour. If the original time is 01:23:17, it becomes 01:00:00 after rounding. |
+{num}{unit} | Add the specified time interval to the original time. For example, +3h means postpone by 3 hours. |
-{num}{unit} | Subtract the specified time interval from the original time. For example, -30s means 30 seconds earlier. |
The parameters are described below:
Parameters | Description |
Parameters | Description |
{num} | Positive integer. Optional. If omitted, the default value is 1. For example, if the time expression is -h, it means subtracting 1 hour. |
{unit} | Time unit, such as s (seconds), m (minutes), h (hours), d (days), M (months). |
Time units
The SQL time window expression supports the following time units:
Time units | Description |
Time units | Description |
M | Month |
d | Day |
h | Hour |
m | Minute |
s | Second |
Expression examples
SQL time window expressions for common scenarios are shown as below:
Start time | End time | Description |
Start time | End time | Description |
@m-15m | @m | The previous 15 minutes. If the schedule starts at 10:00 and runs every 15 minutes, with an SQL time window of [@m-15m, @m) and an execution delay of 30 seconds, the instance will be scheduled at 10:00:00 and executed at 10:00:30. Data from the period [09:45~10:00) will be analyzed. |
@h-3h | @h | The past 3 hours. If: the scheduling start time is 10:00; scheduling interval is 3 hours; SQL time window is set to [@h-3h,@h); execution delay is 30 seconds; then: the instance scheduling time is 10:00:00; execution time is 10:00:30; and the data for the period [07:00~10:00) will be analyzed. |
@h-12h-30m | @h | The past 12 hours and 30 minutes. If: the scheduling start time is 22:30:00; scheduling interval is 12.5 hours (750 minutes); SQL time window is set to [@h-12-30m,@h); execution delay is 30 seconds; then: the instance scheduling time is 22:30:30; execution time is 22:30:30; and the data for the period [10:00~22:30) will be analyzed. |
Last updated: 2026.03.16 16:34:35
All rights reserved © Beijing Volcano Engine Technology Co., Ltd2024
