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-partitioning.html
mysql> CREATE TABLE airline_discount( id INT PRIMARY KEY, date DATE COMMENT 'RAPID_COLUMN=DATA_PLACEMENT_KEY=1', discount FLOAT COMMENT 'RAPID_COLUMN=DATA_PLACEMENT_KEY=2'); Query OK, 0 rows affected (0.2448 sec) When defining multiple columns as ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-supported-data-types.html
Numeric data types: BIGINT BOOL DECIMAL DOUBLE FLOAT INT INTEGER MEDIUMINT SMALLINT TINYINT Temporal data types: DATE DATETIME TIME TIMESTAMP YEAR Temporal types are only supported with strict SQL mode. Columns with unsupported data types must be ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-temporal-functions.html
As of MySQL 8.4.0, MySQL HeatWave supports named time zones such as MET or Europe/Amsterdam for CONVERT_TZ(). For a workaround before MySQL 8.4.0, see Section 11.2.1.4, “Functions and Operator Limitations”. Table 5.11 Temporal Functions Name ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-ml-model-metadata.html
The default value is: JSON_OBJECT("tensor(int64)": "int64", "tensor(float)": "float32", "tensor(string)": "str_") onnx_outputs_info: JSON object literal Information about the format of the ONNX model outputs. The model_metadata column in the model ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-ml-predict-row.html
ML_PREDICT_ROW generates predictions for one or more rows of unlabeled data specified in JSON format. A call to ML_PREDICT_ROW can include columns that were not present during ML_TRAIN. A table can include extra columns, and still use the MySQL ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-prediction-intervals.html
This feature specifies upper and lower bounds on predictions for forecasting based on level of confidence. For example, for a prediction interval of 0.95 with a lower bound of 25 units and an upper bound of 65 units, you are 95% confident that ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-supported-data-types.html
MySQL HeatWave AutoML has the following limitations for text usage: The ML_PREDICT_TABLE ml_results column contains the prediction results and the data. MySQL HeatWave AutoML does not support text columns with NULL values. MySQL HeatWave AutoML does ...
https://dev.mysql.com/doc/heatwave/en/mys-hwgenai-ml-embed-row.html
The ML_EMBED_ROW routine uses the specified embedding model to encode the specified text or query into a vector embedding. The routine returns a VECTOR that contains a numerical representation of the specified text. This topic contains the ...