Search Results
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-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-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-scoring-a-recommendation-model.html
After generating predicted ratings/rankings and recommendations, you can score the model to assess its reliability. For a list of scoring metrics you can use with recommendation models, see Recommendation Model Metrics. For this use case, you use ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-scoring-an-anomaly-detection-model.html
After generating predictions, you can score the model to assess its reliability. For a list of scoring metrics you can use with anomaly detection models, see Anomaly Detection Metrics. For this use case, you use the test dataset for validation. In ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-topic-modeling-prediction.html
After training the model, you can run topic modeling on the trained text. To run topic modeling, use the sample data from the movies dataset. When the output table generates, you can review the generated word groups and expressions for the trained ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-using-an-anomaly-detection-model.html
To generate predictions, use the sample data from the two anomaly detection datasets: credit_card_train and training_data. Both datasets have labeled and unlabeled rows, but only the dataset for semi-supervised learning uses this for training. The ...
https://dev.mysql.com/doc/heatwave/en/mys-hwgenai-ml-embed-table.html
The ML_EMBED_TABLE routine runs multiple embedding generations in a batch, in parallel. Note In versions older than MySQL 9.2.1, to alter an existing table or create a new table, MySQL requires you to set the sql-require-primary-key system variable ...
https://dev.mysql.com/doc/relnotes/heatwave/en/news-8-2-0.html
Functionality Added or Changed MySQL HeatWave Guided Load reduces the number of steps to manually load data, see Load Data Manually. (WL #15811) MySQL HeatWave now supports the following string functions: BIN() BIT_LENGTH() ELT() EXPORT_SET() ...
https://dev.mysql.com/doc/connector-j/en/connector-j-query-attributes.html
Connector/J supports Query Attributes when it has been enabled on the server by installing the query_attributes component (see Prerequisites for Using Query Attributes for details). Attributes are set for a query by using the setAttribute() method ...