The Built-In Functions page lists the built-in functions provided by MaxCompute. On this page, you can view their categories, descriptions, and examples.
Background
MaxCompute provides a rich set of built-in functions for data analysis and processing with MaxCompute SQL. You can call these functions directly without understanding their internal implementation. You can quickly find the functions that you need based on different criteria.
To find a function by type, see Overview of built-in functions (sorted by type).
To find a function in alphabetical order, see Overview of built-in functions (sorted by name).
In DataWorks, you can use the functions on the Built-In Functions page for task development and analysis.
Usage notes
For more information about the usage notes for built-in functions, see Usage Notes.
Limits
For the limits on built-in functions, see Limits on JSON functions and Overview of built-in functions.
View built-in functions
To view the built-in functions in the DataWorks console, follow these steps:
Log on to the DataWorks console. In the top navigation bar, select the desired region. In the left-side navigation pane, choose . 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, click Built-In Functions. You can then click a function to view its detailed description.
The Built-In Functions page includes the following categories of functions:
Alternatively, you can run the following command in an ODPS SQL node to view built-in functions.
show builtin functions [<function_name>]; --<function_name> specifies the name of a built-in function.If you run the show builtin functions; command on the MaxCompute client (odpscmd), the client version must be 0.43.0 or later.
What's next
For typical use cases of built-in functions, see the following topics:
To quickly troubleshoot issues with built-in functions, see the following topics: