This topic describes the syntax of the MAX_PT function in Hologres.

Description

MAX_PT: queries the name of the largest partitioned table for a MaxCompute foreign table of Hologres.

Note You can only call this function to query the name of the largest partitioned table for a foreign table of Hologres. Internal tables are not supported.

Synopsis

SELECT MAX_PT('table_name')

Parameter

table_name: the name of the foreign table of Hologres to query.

Example

SELECT MAX_PT('holo_table');