Search Results
https://dev.mysql.com/doc/heatwave/en/mys-hw-async-task-status-brief.html
This topic contains the following sections: Syntax Syntax Example See Also Syntax mysql> SELECT mysql_tasks.task_status_brief(IN 'task_id' VARCHAR(36)); The task_id (VARCHAR(36)) parameter specifies the unique task ID (UUID) of the task whose log ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-async-task-status-list.html
This topic contains the following sections: Syntax Syntax Example See Also Syntax mysql> SELECT mysql_tasks.task_status_list( IN 'task_type' VARCHAR(80), IN offset INT UNSIGNED, IN limit INT UNSIGNGED); Following are task_status_list parameters: ...
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-change-propagation.html
After tables are loaded into MySQL HeatWave, data changes are automatically propagated from DB System tables to their counterpart tables in the MySQL HeatWave Cluster. DML operations, INSERT, UPDATE, and DELETE, on the DB System do not wait for ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-excluded-columns.html
Check if you have the SELECT and INSERT privileges for the table that you want to analyze. mysql> SELECT COLUMN_NAME, EXTRA FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME LIKE 't1' AND EXTRA LIKE '%NOT SECONDARY%'; +-------------+---------------+ ... In MySQL HeatWave, you can explicitly exclude certain table columns from being loaded into the MySQL HeatWave Cluster, by defining them with the NOT SECONDARY ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-genai-quickstart.html
To track the progress of the task, run the task query displayed on the screen: SELECT mysql_tasks.task_status_brief("TaskID"); Replace TaskID with the displayed task ID. This quickstart shows how to set up a GenAI-powered Help Chat that uses the ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-genai-troubleshoot.html
This section describes some commonly encountered issues and errors for MySQL HeatWave GenAI and their workarounds. The folder you are trying to load might contain unsupported format files or the file that you are trying to load might be of an ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-get-privileges.html
To grant privileges on all schemas: mysql> GRANT List_Of_Privileges ON *.* TO 'Username'; For example: mysql> GRANT SELECT, ALTER ON *.* TO 'appuser1'; This grants the specified privileges, SELECT and ALTER, on all schemas to the user account ... By ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-auto-parallel-load-overview.html
mysql> GRANT SELECT ON performance_schema.* TO 'user_name'@'%'; About Lakehouse Auto Parallel Load Schema Inference Lakehouse Auto Parallel Load includes schema inference, and uses it in one of two ways: Lakehouse Auto Parallel Load analyzes the ...