Search Results
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-limitations-joins.html
Antijoins, with the exception of supported IN and EXISTS antijoin variants listed below. EXISTS semijoins and antijoins are supported in the following variants only: SELECT ... NOT EXISTS (...) IS NOT TRUE Depending on transformations and ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-string-functions-operators.html
With the exception of the FORMAT() function, string functions and operators described in the following table are supported with variable-length encoded columns. FIELD() Index (position) of first argument in subsequent arguments FIND_IN_SET() Index ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-supported-data-types.html
Columns with unsupported data types must be excluded, and defined as NOT SECONDARY before loading a table. Numeric data types: BIGINT BOOL DECIMAL DOUBLE FLOAT INT INTEGER MEDIUMINT SMALLINT TINYINT Temporal data types: DATE DATETIME TIME TIMESTAMP ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-forecasting-model-types.html
This topic describes the types of forecasting models supported by AutoML. Univariate Models In a univariate model, you define one numeric column as an endogenous variable, specified as a JSON_ARRAY. For example, you forecast the rainfall for the ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-model-handles.html
When ML_TRAIN trains a model, you have the option to specify a name for the model, which is the model handle. If you do not specify a model handle name, a model handle is automatically generated that is based on the database name, input table name, ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-model-viewing.html
To view the details for the models in your model catalog, query the MODEL_CATALOG table. Before You Begin Review the following: Create a Machine Learning Model The Model Catalog View Details for Your Models The following example queries model_id, ...
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-hwaml-training-a-recommendation-model.html
After preparing the data for a recommendation model, you can train the model. Requirements for Recommendation Training Define the following as required to train a recommendation model. Set the task parameter to recommendation to train a ...
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 ...