Search Results
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-csv-non-json.html
This topic shows the different ways to export query results as a CSV file with SQL syntax. INTO OUTFILE {URL | URI} 'uri' [FORMAT csv] [CHARACTER SET 'charset_name'] [HEADER {ON | OFF}] [{FIELDS | COLUMNS} [NULL AS 'null_char'] [TERMINATED BY ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-export-query-results.html
As of MySQL 9.1.1-u1, you can export your query results on DB System tables and external Lakehouse tables to Object Storage. This feature is available for MySQL HeatWave on OCI and MySQL HeatWave on AWS. The capability to convert the output into ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-overview.html
While Lakehouse provides in-memory query processing on data in Object Storage, it does not load data into a DB System table. The Lakehouse feature of MySQL HeatWave enables query processing on data in Object Storage. MySQL HeatWave Lakehouse reads ...
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-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-query-runtimes.html
This topic describes how you can view MySQL HeatWave query runtimes and runtime estimates using the MySQL HeatWave Autopilot Advisor Auto Query Time Estimation feature, or by querying the performance_schema.rpd_query_stats table. Runtime data is ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-reload-mysql-tables.html
As of MySQL 8.4.0, MySQL HeatWave lets you reload all tables using the HEATWAVE_RELOAD routine. Before You Begin Complete the steps to load data using Auto Parallel Load or manually. Learn how to use the Machine Learning capabilities of MySQL ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-rpd-ml-stats-table.html
Note The Performance Schema table described here is available as of MySQL 9.0.0. Support for MySQL HeatWave GenAI routines is available as of MySQL 9.0.1-u1. The rpd_ml_stats table tracks the usage of successful MySQL HeatWave routines. The ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-secondary-load-partitions.html
As of MySQL 9.1.0, MySQL HeatWave supports partitions for DB System tables. 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 ...