Search Results
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
Syntax Example mysql> SELECT JSON_PRETTY(mysql_tasks.task_status(@task_id)); This example returns the status of the asynchronous task with task ID stored in the session variable @task_id. This topic contains the following sections: Syntax Syntax ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-async-task.html
Syntax Example mysql> SELECT JSON_PRETTY(mysql_tasks.task(@task_id)); This example retrieves all the task information associated with the task ID that is stored in the session variable @task_id. This topic contains the following sections: Syntax ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-comparison-functions-operators.html
The VARLEN Support column identifies functions and operators that support variable-length encoded string columns. Table 5.3 Comparison Functions and Operators Name VARLEN Support Description BETWEEN ... Yes Check whether a value is within a range of ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-data-compression.html
If data storage size is not a concern, disable data compression by setting the rapid_compression session variable to OFF before loading data: mysql> SET SESSION rapid_compression=OFF; As of MySQL version 8.3.0, the default option is AUTO which ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-data-scanned.html
To view a cumulative total of data scanned (in MB) by all successfully executed MySQL HeatWave queries from the time the MySQL HeatWave Cluster was last started, query the hw_data_scanned global status variable. For example: mysql> SHOW GLOBAL ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-encryption-compression-functions.html
Table 5.6 Encryption and Compression Functions Name Description COMPRESS() Return the result as a binary string. Note Deprecated as of MySQL 9.4.0, and removed as of MySQL 9.6.0. Note Deprecated as of MySQL 9.4.0, and removed as of MySQL 9.6.0.
https://dev.mysql.com/doc/heatwave/en/mys-hw-flow-control-functions-operators.html
The VARLEN Support column identifies functions and operators that support variable-length encoded string columns.
https://dev.mysql.com/doc/heatwave/en/mys-hw-genai-chat-details.html
View Details To view the chat session details, inspect the @chat_options variable: mysql> SELECT JSON_PRETTY(@chat_options); The output includes the following details about a chat session: Vector store tables: in the database which were referenced ... This topic describes how to view a chat session ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-auto-load.html
Note Do not use the external_tables option as of MySQL 8.4.0. The Auto Parallel Load external_tables option is a JSON array that includes one or more db_object items. It allows you to set the details for schemas and tables to load. Syntax Examples ...