Search Results
https://dev.mysql.com/doc/heatwave/en/mys-hw-async-task-kill.html
The kill_task routine terminates an active or scheduled task using its task ID. This topic contains the following sections: Syntax Syntax Example See Also Syntax mysql> CALL mysql_tasks.kill_task(IN 'task_id' VARCHAR(36)); The task_id (VARCHAR(36)) ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-async-task-logs.html
The task_logs routine returns a list of logs associated with a task. This topic contains the following sections: Syntax Syntax Example See Also Syntax mysql> SELECT mysql_tasks.task_logs( IN 'task_id' VARCHAR(36), IN 'newer_than_log_time' ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-async-task-status-brief.html
The task_status_brief routine returns the brief status of a task, including a subset of information about the task and its last log entry. This topic contains the following sections: Syntax Syntax Example See Also Syntax mysql> SELECT ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-async-task-status.html
This topic contains the following sections: Syntax Syntax Example See Also Syntax mysql> SELECT mysql_tasks.task_status(IN 'task_id' VARCHAR(36)); The task_id (VARCHAR 36) parameter specifies the unique task ID (UUID) of the task whose information ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-async-task.html
This topic contains the following sections: Syntax Syntax Example See Also Syntax mysql> SELECT mysql_tasks.task(IN 'task_id' VARCHAR(36)); The task_id (VARCHAR(36)) parameter specifies the unique task ID (UUID) of the task whose information is ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-auto-query-plan-improvement.html
The Auto Query Plan Improvement feature collects and stores query plan statistics in a statistics cache when a query is executed in MySQL HeatWave. When a new query shares query execution plan nodes with previously executed queries, the statistics ...
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 ...