Search Results
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-auto-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. Review the following examples for different ways to create external tables. These ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-create-table-manually-task.html
If you choose not to Create an External Table Using Lakehouse Auto Parallel Load, you can create the table manually. Create External Table Manually Example To demonstrate how to create an external table manually, the following example specifies a ...
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
CREATE EXTERNAL TABLE table_name (col_name data_type ['Col_Options_SQL'], ...) Tbl_Options_SQL; 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 ...
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.