Open Table Format (OTF)
The following are not supported for OTF Write at this time:
OTF does not support rollback in a transaction. However, you can manually delete external data files.
- 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
For AWS, the catalog_location and the storage_location must be in the same region.
Iceberg
- Iceberg Read can handle data created with merge-on-read and copy-on-write.
- Iceberg Write only supports copy-on-write.
Delta Lake
- Delta Lake Read and Write only support copy-on-write mode.
- Partitioning on a BLOB column is not supported.