Search Results
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-export-query-results.html
The capability to convert the output into different file formats and write it directly to object storage helps to seamlessly integrate MySQL HeatWave with various data pipelines, analytics workflows, and downstream applications. As of MySQL ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-load-unstructured-data.html
MySQL HeatWave Lakehouse lets you load unstructured data from Object Storage using a MySQL HeatWave Vector Store.
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-loading-data-uri.html
As of MySQL 9.3.1, and only on MySQL HeatWave on OCI, you can use uniform resource identifiers (URI) to specify files for loading data when creating external tables manually. Review the following examples for different ways to create external ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-table-syntax-json.html
CREATE TABLE table_name (col_name data_type [ENGINE_ATTRIBUTE='Col_Engine_Attribute_JSON'], ...) ENGINE=lakehouse SECONDARY_ENGINE=rapid ENGINE_ATTRIBUTE='Tbl_Engine_Attribute_JSON'; After creating a table, you can load data into the table in the ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-table-syntax-sql.html
After creating a table, you can load data into the table in the following ways: Load the data automatically with Lakehouse Auto Parallel Load by using the HEATWAVE_LOAD command. As of MySQL 9.4.0, you can set external table options using SQL syntax. The following options apply to CREATE TABLE and ALTER TABLE ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-loading-data-manually.html
You can manually load data from InnoDB tables in your DB System into MySQL HeatWave Cluster by using SQL data definition language (DDL) such as CREATE TABLE and ALTER TABLE statements. Perform the following steps sequentially for each table that ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-metadata-queries-load-progress.html
The time required to load a table into MySQL HeatWave depends on data size. You can monitor load progress by issuing the following query, which returns a percentage value indicating load progress. mysql> SELECT VARIABLE_VALUE FROM ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-performance-schema-tables.html
See Section 4.2, “Load Data from DB System into MySQL HeatWave Cluster”. MySQL HeatWave Performance Schema tables provide information about MySQL HeatWave nodes, and about tables and columns that are currently loaded in MySQL HeatWave.
https://dev.mysql.com/doc/heatwave/en/mys-hw-rpd-preload-stats-table.html
The statistics are used to estimate the number of MySQL HeatWave nodes required for a given dataset before loading the tables into the MySQL HeatWave Cluster. The rpd_preload_stats table stores column level statistics collected from InnoDB tables.
https://dev.mysql.com/doc/heatwave/en/mys-hw-secondary-load-partitions.html
Loading Partitions using Secondary _Load Clause To load partitions into MySQL HeatWave, specify the SECONDARY_LOAD clause in an ALTER TABLE statement with the PARTITION clause. As of MySQL 9.1.0, MySQL HeatWave supports partitions for DB System ...