Search Results
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 ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-nl2ml.html
You may need to preprocess your data, for example, converting categorical variables like 'Name' and 'Citizenship' into numerical variables if necessary. MySQL 9.4.0 introduces the NL2ML (natural language to machine learning) routine, which provides ...
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 ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-importing-data-sample-data.html
Use the Import sample data feature in MySQL HeatWave Console to import the sample database into a DB System in any region by just a few clicks. An established connection from the MySQL HeatWave Console to the DB System into which you want to import ... Importing Sample Database 7.2.1.1 Importing Sample Database Oracle provides on AWS sample databases for you to test out MySQL HeatWave on ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-workspace-running-queries.html
Query Editor Limitations The Query Editor has the following limitations: It is not intended for loading data into a DB System. More efficient methods of loading data into a DB System are available. Running Queries 10 Running Queries The Workspace ...
https://dev.mysql.com/doc/mysql-cluster-manager/8.4/en/mcm-import-config.html
import config [--dryrun|-y] [--retry] cluster_name This command imports the configuration of an autonomous or “wild” cluster into the cluster named cluster_name. import config requires a single argument, cluster_name, which is the name of the ...The cluster named in the command must already exist in MySQL Cluster Manager; you are also strongly advised to use create cluster --import when creating ...