Search Results
https://dev.mysql.com/doc/heatwave/en/mys-hw-about-analytics.html
Manually loading data into MySQL HeatWave involves preparing tables on the DB System and executing load statements. For MySQL HeatWave on AWS, load data into MySQL HeatWave using the MySQL HeatWave Console. Data loaded into MySQL HeatWave, including ... When a MySQL HeatWave Cluster is enabled, queries that meet certain prerequisites are automatically offloaded from the DB System to the MySQL HeatWave Cluster for accelerated ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-about-auto-parallel-load.html
Auto Parallel Load then automatically loads these tables into MySQL HeatWave. Therefore, within 24 hours of the first query that accesses a table, Auto Parallel Load automatically loads the table into MySQL HeatWave if there is sufficient memory.
https://dev.mysql.com/doc/heatwave/en/mys-hw-exclude-table-columns.html
Before loading a table into MySQL HeatWave, exclude the columns with unsupported data types. Excluding Table Columns The NOT SECONDARY column attribute prevents a column from being loaded into MySQL HeatWave when executing a table load operation.
https://dev.mysql.com/doc/heatwave/en/mys-hw-genai-troubleshoot.html
If you find unsupported format files, then try one of the following: Delete the files with unsupported formats from the folder, and run the VECTOR_STORE_LOAD command again to load the vector embeddings into the vector store table again. Move the ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-auto-loading-data-par.html
To specify multiple external files for one external table, you can create a folder in the Object Storage bucket and upload the required files into that folder. What's Next After successfully creating external tables and specifying the files to load ... Review the following examples to see the different ways to use pre-authenticated requests (PAR) and Auto Parallel Load to specify files when creating external ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-auto-parallel-load-overview.html
Lakehouse Auto Parallel Load, which extends the Auto Parallel Load feature of MySQL HeatWave, facilitates the process of loading data from Object Storage into MySQL HeatWave by automating many of the steps involved, including: Excluding schemas, ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-create-table-auto-parallel-load-task.html
Create a session variable with the characteristics of the input_list to create the external table and specify the file to use to load data into the table. Run the HEATWAVE_LOAD command with the characteristics of the input_list in normal mode to ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-export-query-result-par-redact.html
The pre-authenticated request (PAR) URL is hidden in the log file for security reasons. The following example exports the query results as a CSV file to the object storage location represented as a PAR URL. It also displays the latest query results ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-load-event-based.html
Once an event for an external file location is emitted due to a change to an object, Lakehouse automatically refreshes the data into the external table. If you create the table manually, you can use the CREATE EXTERNAL TABLE command to set it up ...
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. Tip For data placement key recommendations, use MySQL HeatWave Autopilot Advisor ...