Search Results
https://dev.mysql.com/doc/heatwave/en/mys-hw-about-heatwave.html
Any changes made to the data in the DB System are automatically propagated to MySQL HeatWave Cluster, ensuring that queries always access the most up-to-date information. The hybrid approach achieves the benefits of columnar format for query ...
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-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-genai-summarize-content.html
MySQL also supports ', 'a wide range of data types, including integers, floating-point numbers, dates, and strings. The following sections in this topic describe how to summarize exiting content using MySQL HeatWave GenAI: Before You Begin ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-genai-update-vector-store.html
To keep up with the changes and updates in the documents in your Object Storage, you must update the vector embeddings loaded in the vector store table on a regular basis. This ensures that the responses generated by MySQL HeatWave GenAI are ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-auto-loading-data-par.html
Set a short expiration date for the PAR URL that matches the data loading plan. Note If you are on MySQL 9.1.2 and earlier, you need to update dialect with the field delimiter and record delimiter parameters. mysql> SET @input_list = '[{ "db_name": ... Review the following examples to see the different ways to use pre-authenticated requests (PAR) and Auto Parallel Load to specify files when creating external ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-export-query-results-csv-non-json.html
Update this table with new data loaded to the same bucket for new aggregates by using the incremental load feature. Therefore, instead of having queries compute results by scanning all the rows for a given range of dates, you can run queries against ... This topic shows the different ways to export query results as a CSV file with SQL ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-loading-data-par.html
Set a short expiration date for the PAR URL that matches the data loading plan. Note If you are on MySQL 9.1.2 and earlier, you need to update dialect with the field delimiter and record delimiter parameters. Review the following examples to see ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-limitations-functions.html
Rewrite queries that use named time zones with equivalent datetime values. For example: mysql> SELECT CONVERT_TZ(O_ORDERDATE, 'UTC','EST') FROM tpch.orders; Rewrite as: mysql> SELECT CONVERT_TZ(O_ORDERDATE, '+00:00','-05:00') FROM tpch.orders; Only ... As of MySQL 9.2.2, the maximum output width of the following functions is 65,332 bytes: JSON_ARRAYAGG() JSON_OBJECTAGG() JSON_ARRAY() JSON_OBJECT() JSON_EXTRACT() Bit functions and ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-materialized-views.html
You cannot directly update a materialized view, so INSERT, UPDATE, and DELETE statements do not work with materialized views. This topic describes how to create materialized views on MySQL HeatWave, which is supported as of MySQL 9.5.0. A ...