Based on the official PostgreSQL function, MaxCompute Lightning adds the following built-in functions.
The MaxCompute Lightning query engine is based on PostgreSQL 8.2 and currently only supports SELECT queries for existing MaxCompute tables. For more information about the query syntax, see PostgreSQL documentation.
The MaxCompute Lightning query engine is based on PostgreSQL 8.2 supports builtin funtion, for more information, see PostgreSQL documentation.
Based on the official PostgreSQL function, MaxCompute Lightning adds the following builtin functions.
For partitioned tables, this function returns the maximum value of the level-one partition of the partitioned table, sorted alphabetically, and there is a corresponding data file under the partition.
table_full_name: String type, used to specify the table name (must carry the project name, such as prj.src), you must have read access to this table.
Returns the value of the largest level-one partition.
Suppose tbl is a partition table, the corresponding partition is as follows, and both contain data files:
pt =‘20120901’ pt =‘20120902’
Then the partition max_pt returns the value of '20120902' in the following statement, and the MaxCompute SQL statement reads the data under the pt=‘20120902’ partition.
select * from tbl where pt=max_pt('myproject.tbl');