MySQL HeatWave expands to include HeatWave Lakehouse, letting organizations process and query hundreds of terabytes of data residing in Object Storage—in a variety of file formats, such as CSV and Parquet.
The Lakehouse feature of MySQL HeatWave enables query processing on Object Storage-resident data. The source data is read from Object Storage, transformed to the HeatWave format, stored in the HeatWave persistence storage layer in OCI Object Storage, and then loaded to HeatWave Cluster memory.
Provides in-memory query processing on Object Storage-resident data.
Data is not loaded into the MySQL InnoDB storage layer.
Supports structured and relational data in CSV and Parquet formats.
With this feature, users can now analyse data in both MySQL InnoDB and an object store using familiar SQL syntax in the same query.
See HeatWave Lakehouse. (WL #15526)