Search Results
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.
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 ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-supported-file-formats.html
To load unstructured data, see Ingest Files into a Vector Store. Review the various file formats supported for loading structured, semi-structured, and unstructured data in MySQL HeatWave from different sources. Parquet Delta lake tables (as of ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-uniform-resource-identifiers.html
As of MySQL 9.3.1, (supported in MySQL HeatWave on OCI only) MySQL HeatWave Lakehouse lets you use Uniform Resource Identifiers (URI) in a unified way to specify Object Storage resources for loading data into MySQL HeatWave Lakehouse. Before You ...