DataWorks:Use built-in functions

Background information

MaxCompute provides a wide range of built-in functions that allow you to use MaxCompute SQL for data analytics and processing. MaxCompute built-in functions help you perform routine development and analytics. You can directly call built-in functions, without the need to focus on the implementation logic of the built-in functions. You can search for and learn about MaxCompute built-in functions by function type or in alphabetical order in the following topics:

• Overview of built-in functions (sorted by function type)

• Overview of built-in functions (in alphabetical order)

In DataWorks, you can use the built-in functions that are displayed on the Built-In Functions tab for node development and analytics.

Precautions

For information about the precautions on the use of built-in functions, see Precautions.

Limits

For information about the limits on built-in functions, see Limits on JSON functions and Limits on string functions.

View built-in functions

To view built-in functions in the DataWorks console, perform the following steps:

1. 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.

2. In the left-side navigation pane of the DataStudio page, click Built-In Functions to view the functions. You can click a function to view its details.

   The Built-In Functions tab displays the following types of functions:

   • Date and time functions

   • Mathematical functions

   • Window functions

   • Aggregate functions

   • String functions

   • Complex type functions

   • Encryption and decryption functions

   • Other functions

You can also 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 desired built-in function.

References

• For information about typical cases of built-in functions, see the following topics:

  • Fix the precision issue of the ROUND function

  • Implement capabilities provided by the GROUP_CONCAT function

• For information about how to quickly identify the issues encountered in the use of built-in functions, see the following topics:

  • Common errors for built-in functions

  • FAQ about built-in functions