MAX_PT returns the name of the largest partition in a Hologres partitioned table.
Syntax
SELECT MAX_PT('<table_name>');Parameter
| Parameter | Description |
|---|---|
table_name |
The name of the Hologres partitioned table. |
Examples
Get the latest partition
The following example returns data from the largest partition of holo_table:
SELECT * FROM holo_table WHERE pt = MAX_PT('holo_table');