Search Results
https://dev.mysql.com/doc/heatwave/en/mys-hw-genai-summarize-content.html
MySQL also supports ', 'a wide range of data types, including integers, floating-point numbers, dates, and strings. The following sections in this topic describe how to summarize exiting content using MySQL HeatWave GenAI: Before You Begin ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-table-syntax-json.html
External tables use table-level and column-level ENGINE_ATTRIBUTE options of the CREATE TABLE statement to specify the parameters needed to process data stored externally in Object Storage. CREATE EXTERNAL TABLE table_name (col_name data_type ...
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-predict-row.html
topk: Specify the number of recommendations to provide as a positive integer. 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 ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-scoring-an-anomaly-detection-model.html
To generate a score, the target_column_name column must only contain the anomaly scores as an integer: 1 for an anomaly, or 0 for normal. After generating predictions, you can score the model to assess its reliability. For a list of scoring metrics ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-topic-modeling-prediction.html
This option must be an integer greater or equal to one. 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 ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-using-an-anomaly-detection-model.html
The ML_PREDICT_TABLE and ML_SCORE routines include the topk option, which is an integer between 1 and the table length. To generate predictions, use the sample data from the two anomaly detection datasets: credit_card_train and training_data. Both ...
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
(WL #15637) MySQL HeatWave now enables the internal conversion of values from one data type to another, including all combinations of these different encodings: Numeric values INTEGER, FLOAT, and DECIMAL. Functionality Added or Changed MySQL ...