Search Results
https://dev.mysql.com/doc/heatwave/en/mys-hw-excluded-columns.html
In MySQL HeatWave, you can explicitly exclude certain table columns from being loaded into the MySQL HeatWave Cluster, by defining them with the NOT SECONDARY attribute. Check if you have the SELECT and INSERT privileges for the table that you want ...These columns are typically not needed for analytic queries and are therefore omitted to optimize memory usage and ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-genai-quickstart.html
This creates an asynchronous task in the background which loads the vector embeddings into the specified vector store table quickstart_embeddings. Grant the necessary privileges to the new user for the ML_SCHEMA_user_name schema and the ... This ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-limitations-parquet.html
Consider the following limitations: To load Parquet files with the VECTOR data type (from Parquet strings or from Parquet (numeric) Lists), you must load the table manually with is_strict_mode set to false. To learn more, see Vector Data Type and ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-model-catalog.html
The MODEL_CATALOG table is created in a schema named ML_SCHEMA_user_name, where the user_name is the name of the owning user. The fully qualified name of the model catalog table is ML_SCHEMA_user_name.MODEL_CATALOG. When a user creates a model, the ... MySQL HeatWave AutoML stores machine learning models in a model ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-models-delete.html
Users that create models or have the required privileges to a model on the MODEL_CATALOG table can delete them. Delete a Model To delete a model from the model catalog table: Query the model catalog table for the model_id, model_owner, and ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-prepare-a-forecasting-model.html
mysql> CREATE DATABASE forecasting_data; mysql> USE forecasting_data; Create the table that is the sample dataset. mysql> CREATE TABLE electricity_demand ( date DATE PRIMARY KEY, demand FLOAT NOT NULL, temperature FLOAT NOT NULL ); Insert the sample ... This topic describes how to prepare the data to use for a forecasting machine learning ...
https://dev.mysql.com/doc/relnotes/heatwave/en/news-8-0-23-u1.html
A ROWS column that shows the total number of rows in a table was added to the performance_schema.rpd_tables table. A MEMORY_USAGE column that shows node memory usage was added to the performance_schema.rpd_columns table. Functionality Added or ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-groups.html
The predefined groups and associated permissions are described in the following tables. Table 20-1 Table 20-2 Table 20-3 Note: The OCI user account that registered for the MySQL HeatWave on AWS service is added to the ... Groups and Permissions 20.1 ...
https://dev.mysql.com/doc/connector-j/en/connector-j-usagenotes-troubleshooting.html
16.6: Updating a table that contains a primary key that is either FLOAT or compound primary key that uses FLOAT fails to update the table and raises an exception. The security manager on the MySQL server uses its grant tables to determine whether a ... This section explains the symptoms and resolutions for the most commonly encountered issues with applications using MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/char.html
The length of a CHAR column is fixed to the length that you declare when you create the table. See Section 10.4.7, “Limits on Table Column Count and Row Size”. The following table illustrates the differences between CHAR and VARCHAR by showing ... The CHAR and VARCHAR types are similar, but differ in the way they are stored and ...