The Built-In Functions tab in DataStudio lists all MaxCompute built-in functions available for node development. You can call any built-in function directly without understanding its internal implementation. For each function, you can view its type, description, and usage examples.
To find a function, browse by category or search alphabetically:
Usage notes
-
For precautions on using built-in functions, see Precautions.
-
For limits specific to JSON functions, see Limits on JSON functions.
-
For limits specific to string functions, see Limits on string functions.
Function types
The Built-In Functions tab organizes functions into the following categories:
| Category | Description |
|---|---|
| Date and time functions | Manipulate dates, times, and timestamps |
| Mathematical functions | Perform arithmetic, rounding, logarithmic, and trigonometric operations |
| Window functions | Compute values across a set of rows related to the current row |
| Aggregate functions | Summarize multiple rows into a single value |
| String functions | Manipulate and transform string values |
| Complex type functions | Work with arrays, maps, and structs |
| Encryption and decryption functions | Encrypt and decrypt VARCHAR or BINARY values |
| Other functions | Additional utility functions |
View built-in functions
From the DataWorks console
-
Log on to the DataWorks console. In the top navigation bar, select the desired region. In the left-side navigation pane, choose Data Development and Governance > Data Development. On the page that appears, select the desired workspace from the drop-down list and click Go to Data Development.
-
In the left-side navigation pane of the DataStudio page, click Built-In Functions.
-
Click any function to view its details.
From an ODPS SQL node
Run the following command in an ODPS SQL node to list built-in functions:
show builtin functions [<function_name>]; --<function_name> specifies the name of a desired built-in function.To run show builtin functions; on the MaxCompute client (odpscmd), make sure your odpscmd version is 0.43.0 or later.