Search Results
https://dev.mysql.com/doc/heatwave/en/mys-hw-data-load-prerequisites.html
This topic describes how to prepare your data for loading into MySQL HeatWave. Prepare Data Before loading data, ensure that you meet the following requirements: The tables you intend to load must be set to ENGINE=InnoDB tables. You can manually ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-export-query-results-csv-non-json.html
This topic shows the different ways to export query results as a CSV file with SQL syntax. INTO OUTFILE {URL | URI} 'uri' [FORMAT csv] [CHARACTER SET 'charset_name'] [HEADER {ON | OFF}] [{FIELDS | COLUMNS} [NULL AS 'null_char'] [TERMINATED BY ...
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. To use this feature, define data placement keys on the most frequently used JOIN ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-pre-authenticated-requests.html
Pre-authenticated requests (PAR) allow you to access a bucket or an object in Oracle Cloud Infrastructure (OCI) Object Storage without having your own credentials. A pre-authenticated request is a unique URL, and anyone who has this URL can access ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-rpd-column-id-table.html
The rpd_column_id table provides information about columns of tables that are loaded in MySQL HeatWave. The rpd_column_id table has these columns: ID A unique identifier for the column. TABLE_ID The ID of the table to which the column belongs.
https://dev.mysql.com/doc/heatwave/en/mys-hw-rpd-nodes-table.html
The rpd_nodes read-only table provides information about MySQL HeatWave nodes. The table may not show the current status for a new node or newly configured node immediately. The rpd_nodes table is updated after the node has successfully joined the ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-rpd-table-id-table.html
The rpd_table_id table provides the ID, name, and schema of the tables loaded in MySQL HeatWave. The rpd_table_id table has these columns: ID A unique identifier for the table. The column contains the query used to create the MySQL HeatWave ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-rpd-tables-table.html
The rpd_tables table provides the system change number (SCN) and load pool type for tables loaded in MySQL HeatWave. The rpd_tables table has these columns: ID A unique identifier for the table. The SCN is an internal number that represents a point ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-explanations-ml-explain-table.html
ML_EXPLAIN_TABLE explains predictions for an entire table of unlabeled data. Depending on your MySQL version, we recommend the following: Before MySQL 9.4.1, use the batch_size option to limit operations to batches of 10 to 100 rows by splitting ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-ml-metrics.html
The ML_TRAIN routine includes the optimization_metric option, and the ML_SCORE routine includes the metric option. Both of these options define a metric that must be compatible with the task type and the target data. precision_k: An Oracle ...