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.