tencent cloud

Stream Compute Service

Releases Notes and Announcements
Release Notes
Product Introduction
Overview
Strengths
Use Cases
Purchase Guide
Billing Overview
Billing Mode
Refund
Configuration Adjustments
Getting Started
Preparations
Creating a Private Cluster
Creating a SQL Job
Creating a JAR Job
Creating an ETL Job
Creating a Python Job
Operation Guide
Managing Jobs
Developing Jobs
Monitoring Jobs
Job Logs
Events and Diagnosis
Managing Metadata
Managing Checkpoints
Tuning Jobs
Managing Dependencies
Managing Clusters
Managing Permissions
SQL Developer Guide
Overview
Glossary and Data Types
DDL Statements
DML Statements
Merging MySQL CDC Sources
Connectors
SET Statement
Operators and Built-in Functions
Identifiers and Reserved Words
Python Developer Guide
ETL Developer Guide
Overview
Glossary
Connectors
FAQ
Contact Us
DocumentationStream Compute ServiceSQL Developer GuideOperators and Built-in FunctionsOverview

Overview

PDF
Focus Mode
Font Size
Last updated: 2023-11-08 11:32:33
This section introduces the built-in operators and functions of Stream Compute Service. Based on open-source Flink functions, Stream Compute Service has supplemented and optimized some functions. For more information, see Comparison with Flink Built-in Functions.
Function naming conventions are described as follows:
{ } means an optional parameter and any option can be used. For example, {BOTH|LEADING|TRAILING} means that you can leave it blank (use the default behavior), or choose any one of BOTH, LEADING, or TRAILING. The feature varies depending on the option.
[ ] means an optional parameter, and * means it can be repeated zero or more times. For example, [, value]* means there can be zero or more value following it. This is often used to represent an uncertain number of parameters, such as value, value, value ... value.
A string consisting of lowercase letters represents a variable, for example, value1, value, boolean, or numeric.
Uppercase letters (such as IS NULL) or symbols (such as =, <) represent operators or built-in functions.
Categories of built-in functions:
Comparison Functions
Logical Functions
Arithmetic Functions
String Functions
Conditional Functions
Type Conversion Functions
Date and Time Functions
Aggregate Functions
Time Window Functions
Other Functions
Previous Topic: Flink Configuration ItemsNext Topic: Comparison with Flink Built-in Functions

Help and Support

Was this page helpful?

Help us improve! Rate your documentation experience in 5 mins.

Feedback