Search Results
https://dev.mysql.com/doc/heatwave/en/hw-lh-privileges.html
Review the following privileges required to use MySQL HeatWave Lakehouse. Object Storage Privileges To access object storage resources and files to load data, you require specific privileges. See the following to learn more: PAR Privileges Resource ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-advisor-auto-indexing-syntax.html
Autopilot Indexing uses the following syntax: mysql> CALL sys.autopilot_index_advisor ([options]); options: { JSON_OBJECT('key','value'[,'key','value'] ...) 'key','value': ['output',{'normal'|'silent'|'help'}] ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-aggregate-functions.html
The VARLEN Support column identifies functions that support variable-length encoded string columns. Table 5.1 Aggregate (GROUP BY) Functions Name VARLEN Support Description AVG() Return the average value of the argument COUNT() Yes Return a count of ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-async-add-task-log.html
The add_task_log routine add a log entry for the task with the specified ID. You can use this routine with an application-level task as well and it does not require an application-managed user ID. Syntax mysql> CALL mysql_tasks.add_task_log( IN ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-async-apptask-list.html
The app_task_list routine returns a paginated list of asynchronous tasks associated with an application user. This topic contains the following sections: Syntax Syntax Example See Also Syntax mysql> SELECT mysql_tasks.app_task_list( IN ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-async-apptask-logs.html
The app_task_logs routine returns a list of logs associated with an application-level task. This topic contains the following sections: Syntax Syntax Example See Also Syntax mysql> SELECT mysql_tasks.app_task_logs( IN 'app_user_id' VARCHAR(255), IN ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-async-apptask-status-brief.html
The app_task_status_brief routine returns the brief status of an application 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> ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-async-apptask-status-list.html
The app_task_status_list routine returns a paginated list of application task statuses. This topic contains the following sections: Syntax Syntax Example See Also Syntax mysql> SELECT mysql_tasks.app_task_status_list( IN 'app_user_id' VARCHAR(255), ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-async-apptask-status.html
This topic contains the following sections: Syntax Syntax Example See Also Syntax mysql> SELECT mysql_tasks.app_task_status( IN 'app_user_id' VARCHAR(255), IN 'task_id' VARCHAR (36); Following are app_task_status parameters: app_user_id ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-async-apptask.html
The app_task routine returns information about a single application task. This topic contains the following sections: Syntax Syntax Example See Also Syntax mysql> SELECT mysql_tasks.app_task( IN 'app_user_id' VARCHAR(255), IN 'task_id' ...