The TD_PARTITIONS table operator returns the following attributes of the partitions of a Datalake table:
| Attribute | Description |
|---|---|
| id | Unique identifier of partition field. |
| name | Partition field name. |
Syntax
[TD_SYSFNLIB.]TD_PARTITIONS ( ON ( datalake_name.database_name.table_name ) ) alias_name
Syntax Elements
- datalake_name
- Name of the DATALAKE object where the table is.
- database_name
- Name of the database where the table is.
- table_name
- Name of the table.
- alias_name
- Alias name of derived table.
Example
SELECT * FROM TD_PARTITIONS (ON (Iceberg1.db1.t1)) d1;
*** Query completed. 2 rows found. 2 columns returned. *** Total elapsed time was 1 second. id 1000 name dt id 1001 name country