Search Results
https://dev.mysql.com/doc/heatwave/en/mys-hw-limitations-index-optimizer-hints.html
However, MySQL may still select the DUPSWEEDOUT semijoin strategy during JOIN order optimization, even if an equivalent plan could be offered using the FIRSTMATCH strategy. MySQL attempts to enforce the FIRSTMATCH strategy and ignores all other ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-limitations-joins.html
The plan evaluation limit is required because the DUPSWEEDOUT join strategy, which is not supported by MySQL HeatWave, may be used as a fallback strategy by MySQL during join order optimization (for related information, see FIRSTMATCH). Antijoins, ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-metadata-queries-change-propagation.html
As of MySQL 9.2.1, TRANSACTIONAL indicates that change propagation is enabled for the table. In previous versions of MySQL, RAPID_LOAD_POOL_TRANSACTIONAL indicates that change propagation is enabled for the table.
https://dev.mysql.com/doc/heatwave/en/mys-hw-partitioning.html
Define a Data Placement Key Defining a data placement key requires adding a column comment with the data placement keyword string: RAPID_COLUMN=DATA_PLACEMENT_KEY=N where N is an index value that defines the priority order of data placement keys.
https://dev.mysql.com/doc/heatwave/en/mys-hw-supported-file-formats.html
You can map columns by column order or by column name (case sensitive or case insensitive). Review the various file formats supported for loading structured, semi-structured, and unstructured data in MySQL HeatWave from different sources. Parquet ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-varlen-encoding.html
VARLEN Supported Relational Operators GROUP BY JOIN LIMIT ORDER BY VARLEN Encoding and Performance The presence of VARLEN encoded VARCHAR or CHAR columns does not affect table load performance. Variable-length encoding is automatically applied when ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-window-functions.html
MySQL HeatWave window function support includes support for: WINDOW and OVER clauses in conjunction with PARTITION BY, ORDER BY, and WINDOW frame specifications. For optimal performance, window functions in MySQL HeatWave utilize a massively ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-anomaly-detection-logs.html
As of MySQL 9.4.1, at least one column must act as the primary key to establish the temporal order of logs. MySQL 9.2.2 introduces the ability to detect anomalies in log data. To perform anomaly detection on logs, log data is cleaned, segemented, ...
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 ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-ml-predict-table.html
Requirements and Options for Anomaly Detection Models As of MySQL 9.4.1, if you run ML_PREDICT_TABLE with the log_anomaly_detection task, at least one column must act as the primary key to establish the temporal order of logs. ML_PREDICT_TABLE ...