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