MaxCompute - Supports Five New Built-in Functions
Mar 17 2020
MaxComputeMaxCompute supports five new built-in functions, which include aggregate functions and mathematical functions. This facilitates SQL development and applies to more computing scenarios.
Content
Target customers: Alibaba Cloud MaxCompute customers. Feature released: MaxCompute supports five new built-in functions. 1. The TABLE_EXISTS() function checks whether a table exists. 2. The PARTITION_EXISTS() function checks whether a partition exists. 3. The NUMERIC_HISTOGRAM() function returns the approximate histogram of a specific column. 4. The PERCENTILE_APPROX() function returns the approximate percentile value of numeric column col under the given percentage. 5. The FORMAT_NUMBER() function formats a number as a string in the format of '#,###,###.##'.
