Search Results
https://dev.mysql.com/doc/x-devapi-userguide-shell-python/en/working-with-metadata.html
For example, the following metadata is returned in response to the query SELECT 1+1 AS a, b FROM mydb.some_table_with_b AS b_table. Results contain metadata related to the origin and types of results from relational queries. This metadata can be ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-advisor-auto-indexing-examples.html
To evaluate all user defined schemas: mysql> CALL sys.autopilot_index_advisor(NULL); To evaluate selected schemas: mysql> CALL sys.autopilot_index_advisor(JSON_OBJECT('target_schema',JSON_ARRAY('schema1','schema2', ...))); An example of the output ...The reason, expected storage footprint, and performance impact of each ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-aggregate-functions.html
An example with precision set to 8 that uses 256 bytes of memory per GROUP: mysql> SELECT HLL(results, 8) FROM student; . The VARLEN Support column identifies functions that support variable-length encoded string columns. Table 5.1 Aggregate (GROUP ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-analyzing-tables.html
Check if you have the SELECT and INSERT privileges for the table that you want to analyze. As of MySQL 9.3.0, you can use the ANALYZE TABLE statement to analyze tables loaded into MySQL HeatWave and update table statistics. Before You Begin Ensure ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-async-exec-prepared-stmt.html
Syntax Example mysql> CALL mysql_tasks.execute_prepared_stmt_async('DO SLEEP(5); SELECT JSON_OBJECT("Async Task completed at", now()) into @task_result', NULL, 'DemoAsyncTask', NULL, @task_id); In this example, the first SQL statement DO SLEEP(5) ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-async-task-list.html
This topic contains the following sections: Syntax Syntax Example See Also Syntax mysql> SELECT mysql_tasks.task_list( IN 'task_type' VARCHAR(80), IN offset INT UNSIGNED, IN limit INT UNSIGNED); Following are task_list parameters: task_type ... The ...
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-load-prerequisites.html
Use the following criteria when selecting string columns for dictionary encoding: The column is not used as a key in JOIN queries. This topic describes how to prepare your data for loading into MySQL HeatWave. Prepare Data Before loading data, ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-genai-supported-models.html
This topic provides the list of languages that MySQL HeatWave GenAI supports and the embedding models as well as large language models (LLMs) that are available in MySQL HeatWave. This topic contains the following sections: Before You Begin View ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-auto-loading-data-par.html
If you create a folder with the files for the external table, create a PAR for that folder and do the following: For the Pre-Authenticated Request Target, select Objects with prefix. Review the following examples to see the different ways to use ...