Search Results
https://dev.mysql.com/doc/heatwave/en/mys-hw-genai-update-vector-store.html
The following sections in this topic describe how to update a vector store: Before You Begin Load Data Incrementally into the Vector Store Table Delete and Recreate the Vector Store What's Next Before You Begin Complete the steps to set up a vector ... To keep up with the changes and updates in the documents in your Object Storage, you must update the vector embeddings loaded in the vector store table on a regular ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-auto-loading-data-rp.html
Create file items as needed to identify the files to load into the table. What's Next After successfully creating external tables and specifying the files to load data into the table, learn how to Load Structured Data Using Auto Parallel Load.
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-auto-loading-data.html
After setting up an external table with the files to load into the table, you run HEATWAVE_LOAD command to automatically create the table and load the data. Create a session variable with the characteristics of the input_list to create the external ...This topic contains the following sections: Before You Begin Load External Data Using Lakehouse Auto Parallel Load with a New Table Load External Data Using Lakehouse Auto Parallel Load with an Existing Table What's Next Before You Begin Complete the steps to Create an External Table before running the HEATWAVE_LOAD ...
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. Loading Tables Statement To load an ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-loading-data-par.html
To specify multiple external files into one external table, you can create a folder in the Object Storage bucket and upload the required files into that folder. See the following to learn more: Regular Expression Syntax Modified ECMAScript regular ... Review the following examples to see the different ways to use pre-authenticated requests (PAR) to specify files when creating external tables ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-loading-data-resource-principal.html
Create file items as needed to specify the files to load into the table. See the following to learn more: Regular Expression Syntax Modified ECMAScript regular expression grammar The following example specifies all files in the data_files folder ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-classification-overview.html
mysql> CREATE DATABASE classification_data; mysql> USE classification_data; Create the table to insert the sample data into. This topic describes how to prepare the data to use for a classification machine learning model. The classification ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-preparing-a-recommendation-model.html
mysql> CREATE DATABASE recommendation_data; mysql> USE recommendation_data; Create the table to insert the sample data into. mysql> CREATE TABLE training_dataset ( user_id VARCHAR(3), item_id VARCHAR(3), rating DECIMAL(3, 1), PRIMARY KEY (user_id, ... This topic describes how to prepare the data to use for a recommendation machine learning model using explicit ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-regression-prepare.html
mysql> CREATE DATABASE regression_data; mysql> USE regression_data; Create the table to insert the sample data into. mysql> CREATE TABLE house_price_training ( id INT PRIMARY KEY, house_size INT, address TEXT, state TEXT, price INT ); Insert the ...
https://dev.mysql.com/doc/refman/8.4/en/alter-table-partition-operations.html
In this case, partitions 4 and 5 are merged into the first 4 partitions (the partitions numbered 0, 1, 2, and 3). This statement can be used in several ways: To merge a set of partitions into a single partition. Partitioning-related clauses for ...