Search Results
https://dev.mysql.com/doc/heatwave/en/mys-hw-limitations-functions.html
The following aggregate functions with the enumeration data type: STD() STDDEV() STDDEV_POP() STDDEV_SAMP() SUM() VARIANCE() VAR_POP() VAR_SAMP() With the exception of SUM(), the same aggregate functions within a semi-join predicate due to the ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-mathematical-functions.html
Table 5.9 Mathematical Functions Name Description ABS() Return the absolute value. ATAN2(), ATAN() Return the arc tangent of the two arguments CEIL() Return the smallest integer value not less than the argument. CEILING() Return the smallest integer ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-rpd-query-stats-table.html
OFFLOAD_FAIL_QUERY_SUBSTR_START Points to the start of the query substring that is responsible for the offload failure in the original query. The rpd_query_stats table stores query compilation and execution statistics produced by the MySQL HeatWave ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-rpd-tables-table.html
The SCN is an internal number that represents a point in time according to the system logical clock that the table snapshot was transactionally consistent with the source table. The rpd_tables table provides the system change number (SCN) and load ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-secondary-load.html
mysql> ALTER TABLE airport_geo SECONDARY_LOAD; Warning (code 3877): Command executed during preprocessing: 'ALTER TABLE `airportdb`.`airport_geo` MODIFY `geolocation` point NOT NULL COMMENT '' NOT SECONDARY'. You can load tables into HeatWave using ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-using-an-anomaly-detection-model.html
Anomaly detection models produce anomaly scores, which represent the degree to which a data point deviates from the expected normal behavior. To generate predictions, use the sample data from the two anomaly detection datasets: credit_card_train and ...
https://dev.mysql.com/doc/relnotes/heatwave/en/news-8-0-31.html
MySQL HeatWave then uses the zone maps for range and point queries to only scan data chunks that are relevant for the query, and accelerates these queries by an order of magnitude. MySQL HeatWave AutoML Functionality Added or Changed MySQL HeatWave ...
https://dev.mysql.com/doc/relnotes/heatwave/en/news-8-3-0-u2.html
MySQL HeatWave AutoML MySQL HeatWave Lakehouse Functionality Added or Changed MySQL HeatWave AutoML MySQL HeatWave AutoML adds prediction intervals to the forecasting task. (WL #16072) MySQL HeatWave AutoML adds the PCA and GLOF algorithms to the ...
https://dev.mysql.com/doc/relnotes/heatwave/en/news-9-0-0.html
GEOMETRY, GEOMETRYCOLLECTION, POINT, MULTIPOINT, LINESTRING, MULTILINESTRING, POLYGON, and MULTIPOLYGON, See: Bulk Ingest Data. MySQL HeatWave AutoML MySQL HeatWave Autopilot MySQL HeatWave GenAI MySQL HeatWave Lakehouse MySQL HeatWave ...
https://dev.mysql.com/doc/relnotes/heatwave/en/news-9-1-0.html
It then uses the zone maps for range and point queries to only scan data chunks that are relevant for the query, and accelerates these queries by an order of magnitude. MySQL HeatWave GenAI MySQL HeatWave Lakehouse MySQL HeatWave MySQL HeatWave ...