Search Results
https://dev.mysql.com/doc/heatwave/en/mys-hw-genai-generate-content.html
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 to 0. The following sections in this topic describe how to generate new text-based ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-insert-select.html
row *************************** id: 1 select_type: NONE table: NULL partitions: NULL type: NULL possible_keys: NULL key: NULL key_len: NULL ref: NULL rows: NULL filtered: NULL Extra: Using secondary engine RAPID. This topic describes how to run a ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-limitations-data-types.html
CAST() COALESCE() CASE IF() NULLIF() ABS() CEILING() FLOOR() ROUND() TRUNCATE() GREATEST() LEAST() The following ENUM type columns are unsupported: ENUM type columns as part of a UNION, EXCEPT, EXCEPT ALL, INTERSECT, or INTERSECT ALL SELECT list or ...The following string and text data types are unsupported: BINARY VARBINARY Decimal values with a precision greater than 18 in expression operators are unsupported, with the exception of the following: Arithmetic operators, see: Section 5.3.2, “Arithmetic ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-loading-data.html
MySQL HeatWave partitions data by the table primary key, unless the table definition includes data placement keys. MySQL HeatWave provides the following methods to load data to MySQL HeatWave: Automatic loading: loads tables and partitions based on ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-workload-optimization-olap.html
Workload optimization for online analytical processing, OLAP, includes using dictionary encoding for certain string columns and defining data placement keys to optimize for JOIN and GROUP BY query performance. Auto Data Placement recommends data ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-classification-overview.html
This topic describes how to prepare the data to use for a classification machine learning model. The classification use-case is to approve or reject loan applications for clients based on their personal and socioeconomic status, assets, ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-explanations-ml-explain-table.html
Some of these columns include: Prediction ml_results [input_column_name]_attribution The input table does not have a primary key, and it does not have a column named _4aad19ca6e_pk_id. This is because ML_EXPLAIN_TABLE adds a column as the primary ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-ml-model-export.html
ML_MODEL_EXPORT Overview After you run ML_MODEL_EXPORT, the output table has these columns and formats: chunk_id: INT AUTO_INCREMENT PRIMARY KEY model_object: LONGTEXT DEFAULT NULL model_metadata: JSON See Model Metadata. Use this routine to export ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-ml-model-metadata.html
If you import a model object, model_metadata stores a JSON_OBJECT that contains key-value pairs of the metadata See Section 10.2.4, “ML_MODEL_IMPORT” to learn more. Model Metadata Details Query Model Metadata See Also Model Metadata Details The ... The model_metadata column in the model catalog allows you to view detailed information on trained ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-model-sharing.html
JSON_OBJECT sets key-value pairs for the database and table of the exported table to import. This topic describes how to grant other users access to a model you create. Before You Begin Share Your Models Export the Model to Share Set Up Other User ...