Help Center/ Data Warehouse Service / SQL Syntax Reference (9.1.0.x)/ Functions and Operators

Updated on 2025-09-18 GMT+08:00

View PDF

Functions and Operators

Character Processing Functions and Operators

Binary String Functions and Operators

Bit String Functions and Operators

Numeric Functions and Operators

Date and Time Processing Functions and Operators

SEQUENCE Functions

Array Functions and Operators

Logical Operators

Comparison Operators

Pattern Matching Operators

Aggregate Functions

Window Functions

Type Conversion Functions

JSON/JSONB Functions and Operators

Security Functions

Conditional Expression Functions

Range Functions and Operators

Data Redaction Functions

Bitmap Functions and Operators

UUID Functions

Text Search Functions and Operators

HLL Functions and Operators

Set Returning Functions

Geometric Functions and Operators

Network Address Functions and Operators

System Information Functions

System Management Functions

Backup and Restoration Control Functions

Database Object Functions

Residual File Management Functions

Statistics Information Functions

Trigger Functions

XML Functions

Call Stack Recording Functions

Hudi System Functions

Funnel and Retention Functions

EXTERNAL SCHEMA System Functions

Storage-Compute Decoupling Functions

Previous topic: Constant and Macro

Next topic: Character Processing Functions and Operators

Feedback

Was this page helpful?

Helpful Not helpful

Provide feedback

Thank you very much for your feedback. We will continue working to improve the documentation.

The system is busy. Please try again later.

Which of the following issues have you encountered?

Content is inconsistent with the product UI

Unclear descriptions

Lack of examples or code

Incorrect steps

Can't find what I need

Lack of best practices

Feedback (optional)

0/500

Select at least one type of issue, and enter your comments or suggestions.

Enter a maximum of 500 characters.

Submit Cancel