Search Results
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-create-table-auto-parallel-load-task.html
Select the method to specify the files that will load the data in the external table: uniform resource identifier (URI), resource principals, or PAR. You can use Auto Parallel Load to set up the automatic creation of an external table along with ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-create-table-manually-task.html
Select the method to specify the files for the external table: uniform resource identifier (URI), resource principal, or PAR. If you choose not to Create an External Table Using Lakehouse Auto Parallel Load, you can create the table manually.
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-limitations-all.html
MySQL HeatWave Lakehouse has the following limitations for all file formats. Unsupported Items MySQL HeatWave Lakehouse does not support the following: DML statements: INSERT UPDATE DELETE REPLACE The CREATE TABLESPACE statement. The following ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-loading-data-manually.html
After creating an external table manaully and specifying the files to load into the table, you specify the SECONDARY_UNLOAD clause in an ALTER TABLE statement to load the data from the files into the table. This topic contains the following ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-loading-data-par.html
If you create a folder with the files to load, create a PAR for that folder and do the following: For the Pre-Authenticated Request Target, select Objects with prefix. Review the following examples to see the different ways to use pre-authenticated ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-update-loaded-data.html
To edit the list of files comprising an external table without altering the directories in the Object Storage bucket, you can add or remove files using Selective Load. You can update loaded external tables by using one of the following methods: To ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-limitations-index-optimizer-hints.html
However, MySQL may still select the DUPSWEEDOUT semijoin strategy during JOIN order optimization, even if an equivalent plan could be offered using the FIRSTMATCH strategy. MySQL attempts to enforce the FIRSTMATCH strategy and ignores all other ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-loading-data.html
This GUI-based and MySQL HeatWave Autopilot enabled method loads selected schemas and tables using an optimized number of parallel load threads for a faster load. MySQL HeatWave provides the following methods to load data to MySQL HeatWave: ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-metadata-queries-memory-usage.html
To view the memory usage for each MySQL HeatWave node: mysql> SELECT ID, MEMORY_USAGE, MEMORY_TOTAL, BASEREL_MEMORY_USAGE FROM performance_schema.rpd_nodes; +----+--------------+--------------+----------------------+ | ID | MEMORY_USAGE | ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-metadata-queries-node-status.html
To view the status of each MySQL HeatWave node: mysql> SELECT ID, STATUS FROM performance_schema.rpd_nodes; +----+---------------+ | ID | STATUS | +----+---------------+ | 0 | AVAIL_RNSTATE | | 1 | AVAIL_RNSTATE | +----+---------------+ For column ...