Supported SQL commands
With 11.2.2.9 release, the following SQL commands and functionalities are supported with lakehouse database/tables. For more information, see:
- CREATE DATABASE
- CREATE SCHEMA
- CREATE TABLE
- DESCRIBE
- SELECT QUERIES
- Backup and restore is only supported for the login and reference information, not the data itself.
- AWS S3, IBM COS, minIO data sources are available as storage options or a data lake database.
The following functionalities are not supported:
- Creation of lakehouse native objects (for example materialized views and sequences) in schemas other than NETEZZA_SCHEMA
- Queries which update the contents of tables (Insert, Update, Merge, Truncate)
- Queries which create, alter or drop tables and schemas
- Accessing data lake tables that were created by using LZ4 compression format
- Multi-table transactions
- Time travel on Iceberg tables
timestamptz
andUUID
data types