TD_PARTITIONS() Function - Teradata Vantage

Apache Iceberg and Delta Lake Open Table Format on VantageCloud Lake Getting Started

Deployment
VantageCloud
Edition
Lake
Product
Teradata Vantage
Published
December 2024
ft:locale
en-US
ft:lastEdition
2025-01-03
dita:mapPath
bsr1702324250454.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
bsr1702324250454

TD_PARTITIONS() function returns the partition information for a table.

Columns Returned

  • id
  • name

Syntax

[TD_SYSFNLIB.]TD_PARTITIONS( ON ( <datalake_name>.<database_name>.<table_name> ) ) <alias_name>;

Example: Iceberg

The following example shows that the datalake_iceberg_glue.db1.t1 table has two partition columns: country & city.

SELECT * FROM TD_PARTITIONS(ON (deltalake_glue.db1.t1)) D;
 *** Query completed. 2 rows found. 2 columns returned.
 *** Total elapsed time was 2 seconds.
         id  name
-----------  --------------------------------------------------------------------
       1000  country
       1001  city

Example: Delta Lake

The following example shows that the datalake_deltalake_unity.db1.t1 table has one partition columns: c1.

select * from td_partitions(on (datalake_deltalake_unity.db1.t1)) D;
 *** Query completed. One row found. 2 columns returned.
 *** Total elapsed time was 2 seconds.
         id  name
-----------  --------------------------------------------------------------------
          0  c1