Search Results
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 storge 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 ...
https://dev.mysql.com/doc/heatwave/en/mys-hwgenai-ml-embed-row.html
The ML_EMBED_ROW routine uses the specified embedding model to encode the specified text or query into a vector embedding. The routine returns a VECTOR that contains a numerical representation of the specified text. This topic contains the ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-creating-channel.html
If the source server contains data, import existing data into the DB System: Export the data from the MySQL source server (see Exporting Data Using MySQL Shell for instructions) and: If using GTID-based replication: Capture the value of the source ... Creating a Channel 8.5 Creating a Channel Note:In MySQL replication, a replica is a MySQL server that receives changes from another MySQL server (source) and applies the ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-hw-cluster-failure-and-recovery.html
To facilitate recovery, data is persisted to Storage Layer when data is loaded into the MySQL HeatWave Cluster and when data changes are propagated from the DB system to the MySQL HeatWave Cluster. However, if the MySQL Server is in the ... MySQL ...