Search Results
https://dev.mysql.com/doc/heatwave/en/mys-hw-autopilot-index-advisor-report-table.html
When Autopilot Indexing runs, it sends detailed output to the autopilot_index_advisor_report table in the sys schema. The autopilot_index_advisor_report table is a temporary table that contains data from the last execution of Autopilot Indexing.
https://dev.mysql.com/doc/heatwave/en/mys-hw-bulk-load-mysql-server.html
MySQL includes a bulk load extension to the LOAD DATA statement that is only available in MySQL HeatWave on AWS. It can do the following: Optimize the loading of data sorted by primary key. Monitor bulk load progress with the Performance Schema (As ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-data-scanned.html
mysql> SELECT query_id, JSON_EXTRACT(JSON_UNQUOTE(qexec_text->'$**.error'),'$[0]') AS error_message FROM performance_schema.rpd_query_stats; +----------+------------+--------------+---------------+ | query_id | session_id | data_scanned | ... MySQL ...
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-genai-generate-content.html
For example: mysql> SET @query="Write an article on Artificial intelligence in 200 words."; To generate text-based content, pass the query to the LLM using the ML_GENERATE routine with the task parameter set to generation: mysql> SELECT ... The ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-genai-nl-sql.html
As of MySQL 9.4.1, MySQL HeatWave GenAI lets you generate SQL queries from natural-language statements, making it easier for you to interact with your databases. This feature collects information on the schemas, tables, and columns that you have ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-genai-summarize-content.html
For example: mysql> SELECT sys.ML_GENERATE(@text, JSON_OBJECT("task", "summarization", "model_id", "mistral-7b-instruct-v3", "language", "en")); A text summary generated by the LLM in response to your query is printed as output. For example: mysql> ... The following sections in this topic describe how to summarize exiting content using MySQL HeatWave GenAI: Before You Begin Summarize Text Run Batch Queries What's Next Before You Begin Review the MySQL HeatWave GenAI requirements and ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-export-query-permissions.html
Pre-Authenticated Request Requirements When you create pre-authenticated requests (PAR) to export query results, do the following: For Pre-Authenticated Request Target, select Bucket or Objects with prefix. Required Privileges to Export Query ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-limitations-parquet.html
For example, if col_1 in table_1 is a VECTOR column that you want to convert to JSON, you can do the following: SELECT CAST(VECTOR_TO_STRING(col_1) as JSON) FROM table_1; To convert JSON to VECTOR, first convert JSON to a STRING data type, and then ... MySQL HeatWave Lakehouse has the following limitations for Parquet ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-overview.html
Use the following methods to refresh data: Refresh Data Using Event-Based Incremental Load Refresh Data Using Incremental Load Add or Remove Files Using Selective Load The workflow to use Resource Principals: Prepare the files to load in the proper ... The Lakehouse feature of MySQL HeatWave enables query processing on data in Object ...