Search Results
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-group-by-modifiers.html
In the MySQL HeatWave secondary engine, the GROUP BY clause permits the following modifiers: A CUBE modifier in addition to the WITH ROLLUP modifier. (Available in MySQL HeatWave only.) A ROLLUP modifier as a preferred alternative to the WITH ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-auto-loading-data.html
After setting up an external table with the files to load into the table, you run HEATWAVE_LOAD command to automatically create the table and load the data. This topic contains the following sections: Before You Begin Load External Data Using ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-export-query-result-outputfile.html
Exported query results are in CSV, Parquet, or JSON (As of MySQL 9.3.1) format. The number of output files and size of individual files depends on the amount of data generated by the query. The names for the output files are auto-generated and ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-export-query-results-Parquet-non-json.html
This topic shows the different ways to export query results as a Parquet file with SQL syntax. Before You Begin Review the following: Overview of Exporting Query Results Requirements to Export Query Results Syntax Use the following SQL SELECT INTO ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-limitations-functions.html
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 operators. Rewrite queries that use named time zones with ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-run-query.html
This topic describes how to use the EXPLAIN statement to analyze query execution and verify whether a query is offloaded to MySQL HeatWave for accelerated processing. To learn how to download the sample database, see AirportDB Analytics Quickstart.
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-automl.html
The MySQL HeatWave AutoML ML_TRAIN routine leverages Oracle AutoML technology to automate the process of training a machine learning model. Oracle AutoML replaces the laborious and time consuming tasks of the data analyst, whose workflow is as ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-explanations-ml-explain-table.html
ML_EXPLAIN_TABLE explains predictions for an entire table of unlabeled data. Depending on your MySQL version, we recommend the following: Before MySQL 9.4.1, use the batch_size option to limit operations to batches of 10 to 100 rows by splitting ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-lakehouse.html
If you have external data that you want to use with MySQL HeatWave AutoML, you can load it directly from Object Storage with Lakehouse. MySQL HeatWave AutoML and Lakehouse Overview For MySQL HeatWave on OCI, you have three options to access ...