General Limitations - 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

Iceberg

  • Iceberg Read can handle data created with merge-on-read and copy-on-write.
  • Iceberg Write only supports copy-on-write.
  • The following are not supported for Iceberg Write at this time:
    • DELETE DATABASE SQL syntax to delete all the tables in an OTF database
    • MODIFY DATABASE SQL syntax to modify the properties for an OTF database
    • RENAME TABLE SQL syntax to rename an OTF table
    • SHOW TABLE SQL syntax to display the definition of an OTF table. HELP TABLE is supported as an alternative
    • UPSERT SQL syntax to insert and update data in an OTF table
    • MERGE SQL syntax for an OTF table
    • Using a Stored Procedure to create, insert into, delete from, update and drop an OTF table
    • Using a Macro to update an OTF table
    • Multi-statement requests
    • No support for merge-on-read mode
    • Delta Lake
    • Delta Lake Read and Write only support copy-on-write mode

Delta Lake

Delta Lake Read and Write only support copy-on-write mode.