Search Results
https://dev.mysql.com/doc/heatwave/en/mys-hw-encoding-string-columns.html
Columns with a high number of distinct values MySQL HeatWave nodes Dictionary (SORTED) Supports GROUP BY and ORDER BY operations on string columns Columns with a low number of distinct values DB System node For additional information about string ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-limitations-parquet.html
As of MySQL 9.1.2, you can load Parquet files with row groups that total up to 10GB with large MySQL HeatWave Cluster shapes. MySQL HeatWave Lakehouse has the following limitations for Parquet files. Consider the following limitations: To load ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-rpd-query-stats-table.html
Includes prepart data, which can be queried to determine if a JOIN or GROUP BY query used data placement partitions. The rpd_query_stats table stores query compilation and execution statistics produced by the MySQL HeatWave plugin in JSON format.
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-hwaml-anomaly-detection-logs.html
MySQL 9.2.2 introduces the ability to detect anomalies in log data. To perform anomaly detection on logs, log data is cleaned, segemented, and encoded before running anomaly detection. The input table can only have the following columns: The column ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-ml-metrics.html
The ML_TRAIN routine includes the optimization_metric option, and the ML_SCORE routine includes the metric option. Both of these options define a metric that must be compatible with the task type and the target data. precision_k: An Oracle ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-topic-modeling-train.html
The output is an array of word groups that best characterize the text. After preparing the data for topic modeling, you can train the model. Before You Begin Review and complete all the tasks to Prepare Data for Topic Modeling. Requirements for ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-topic-modeling.html
MySQL 9.0.1-u1 introduces topic modeling, which is an unsupervised machine learning technique that's capable of scanning a set of documents, detecting word and phrase patterns within them, and automatically clustering word groups and similar ...The ...
https://dev.mysql.com/doc/relnotes/heatwave/en/news-8-0-26-u1.html
(Bug #32865043, Bug #33007714, WL #14574) MySQL HeatWave now supports the WITH ROLLUP modifier in GROUP BY clauses. MySQL HeatWave Network Layer MySQL HeatWave Data Management Layer Functionality Added or Changed MySQL HeatWave Network Layer MySQL ...
https://dev.mysql.com/doc/relnotes/heatwave/en/news-8-0-30.html
(WL #15143) Optimizations were implemented to improve performance for JOIN and GROUP BY queries with execution plans involving multiple consecutive rounds of data partitioning. Advisor MySQL HeatWave AutoML Functionality Added or Changed Advisor ...