The following table summarizes the differences between analytic functions on Advanced SQL Engine and Aster Database.
Advanced SQL Engine Analytic Function | Aster Database Analytic Function |
---|---|
PARTITION BY clause lets you specify a column by its position, an integer. PARTITION BY 1 partitions rows by column 1. | PARTITION BY clause accepts only column names. PARTITION BY 1 causes the function to process all rows on a single worker node. |
For table operator output, an alias is required. | For function output, an alias is optional. |
To specify function syntax elements, you must use a USING clause. | Function syntax does not include USING clause. |
Function syntax elements do not support column ranges. | Function syntax elements support column ranges. |