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 GuideQuery and analysisSQL functionPhone number function
Copy page
Download PDFSQL function
Phone number function
Copy pageDownload PDFPhone number function
This article introduces the syntax of phone number functions supported by TLS and usage examples for common scenarios.
Function list
Notice
- In TLS analysis statements (SQL statements), string values must be enclosed in single quotes (''). Identifiers, such as field names or column names, are either not enclosed in quotes or are enclosed in double quotes (""). For example, 'time' represents a string, time or "time" represents a field name or column name.
- The phone number function is used to query information about mainland China phone numbers, such as location, carrier, and other details.
Function name | Syntax | Notice |
Function name | Syntax | Notice |
MOBILE_CARRIER(KEY) | Query the operator of the phone number. | |
MOBILE_CITY(KEY) | Query the city to which the phone number belongs. | |
MOBILE_PROVINCE(KEY) | Query the province associated with the phone number. |
MOBILE_CARRIER function
The MOBILE_CARRIER function is used to query the carrier of a phone number.
Function syntax
- Syntax format
- MOBILE_CARRIER(KEY)
- Parameters description
- ParameterNoticeParameterNoticeKEYLog fields and expressions whose values are phone numbers in numeric format.The data type of the value must be Bigint.
- Description of return value
- The return value is of the Varchar type.
Function examples
- Scenarios
- mobile field value is a phone number, and you can use the MOBILE_CARRIER function to query which carrier these phone numbers belong to.
- Query statements and analysis statements
- * | SELECT MOBILE_CARRIER(mobile)
MOBILE_CITY function
The MOBILE_CITY function is used to analyze the city associated with a phone number.
Functionsyntax
- Syntax format
- MOBILE_CITY(KEY)
- Parameters description
- ParameterNoticeParameterNoticeKEYLog fields and expressions whose values are phone numbers in numeric form.The data type of the value must be Bigint.
- Description of return values
- The return value is of the Varchar type.
Function examples
- Scenarios
- The value of the mobile field is a phone number; you can use the MOBILE_CITY function to query the city associated with this phone number.
- Query and analysis statements
- * | SELECT MOBILE_CITY(mobile)
MOBILE_PROVINCE function
The MOBILE_PROVINCE function is used to analyze the province of a phone number.
Function syntax
- Syntax format
- MOBILE_PROVINCE(KEY)
- Parameters description
- ParameterNoticeParameterNoticeKEYLog fields and expressions whose values are phone numbers in numeric form.The data type of the value must be Bigint.
- Return value
- The return value is of Varchar type.
Function examples
- Scenarios
- mobile field values are phone numbers, and you can use the MOBILE_PROVINCE function to query the provinces to which these phone numbers belong.
- Statements for querying and analysis
- * | SELECT MOBILE_PROVINCE(mobile)
Last updated: 2026.07.30 17:29:25
All rights reserved © Beijing Volcano Engine Technology Co., Ltd2024
