Search Results
https://dev.mysql.com/doc/heatwave/en/mys-hw-insert-select.html
This topic describes how to run a SELECT query and insert the results into a target table using the INSERT ... The target table can be an InnoDB table and does not need to use a secondary engine. When the query is offloaded to MySQL HeatWave, it is ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-create-table-auto-parallel-load-task.html
You can use Auto Parallel Load to set up the automatic creation of an external table along with the loading of data from files in Object Storage. We recommend setting up Auto Parallel Load with an input_list variable, and then using the ...
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-result-par-redact.html
It also displays the latest query results from the query text from the performance_schema.rpd_query_stats table and retrieves all the MySQL statments currently being executed in all MySQL active connections on the network. The pre-authenticated ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-incremental-load.html
Available as of MySQL 9.0.0, Lakehouse Incremental Load allows you to refresh the data in an external table. This topic contains the following sections: Before You Begin Refresh Data Overview Perform Initial Load Refresh Data What's Next Before You ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-limitations-all.html
The following options for the CREATE TABLE statement: AUTOEXTEND_SIZE AVG_ROW_LENGTH CHECKSUM COMPRESS CONNECTION DATADIR DELAY_KEY_WRITE ENCRYPT INDEXDIR INSERT_METHOD KEY_BLOCK_SIZE MAX_ROWS MIN_ROWS PACK_KEYS PASSWORD ROW_FORMAT STATS_AUTO_RECALC ... MySQL HeatWave Lakehouse has the following limitations for all file ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-limitations-other.html
The function must use the same Connection Character Set and Collation System Variables variables setting as the current session. For a list of supported SQL modes, see Section 5.2, “Supported SQL Modes”. The WITH ROLLUP modifier in GROUP BY ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-materialized-views.html
This topic describes how to create materialized views on MySQL HeatWave, which is supported as of MySQL 9.5.0. A materialized view is a database object that stores the results of a query, rather than computing the result dynamically each time the ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-metadata-queries-query-history.html
CONNECTION_ID The connection ID of the client that issued the query. To view the MySQL HeatWave query history including query start time, end time, and wait time in the scheduling queue, as discussed in Section 5.4.11, “Auto Scheduling”.
https://dev.mysql.com/doc/heatwave/en/mys-hw-partitioning.html
When data is loaded into MySQL HeatWave, it is partitioned by the table primary key and sliced horizontally for distribution among MySQL HeatWave nodes by default. To use this feature, define data placement keys on the most frequently used JOIN ...