Search Results
https://dev.mysql.com/doc/heatwave/en/mys-hw-cast-functions-operators.html
CAST() of ENUM columns to CHAR, DECIMAL, FLOAT, and to SIGNED and UNSIGNED numeric values. CAST() from and to all the MySQL HeatWave supported numeric, temporal, string and text data types. CAST() operates on the ENUM index rather than the ENUM ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-column-limits.html
MySQL HeatWave has the following column limits: As of MySQL 9.2.2, the maximum column width is 4192192 bytes. In previous versions of MySQL, the maximum column width is 65532 bytes. This includes the size of all the data and column metadata stored ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-defining-secondary-engine.html
Defining Secondary Engine For each table that you want to load into MySQL HeatWave Cluster, you must define the MySQL HeatWave query processing engine (RAPID) as the secondary engine for the table. Then, the MySQL HeatWave query processing engine ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-encoding-string-columns.html
The following table provides an overview of encoding type characteristics: Table 5.15 Column Encoding Type Characteristics Encoding Type Expression, Filter, Function, and Operator Support Best Suited To Space Required On Variable-length (VARLEN) ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-limitations-all.html
The lakehouse_filter_warning_codes_list session variable has a limit of 50 codes and 250 characters. MySQL HeatWave Lakehouse has the following limitations for all file formats. Unsupported Items MySQL HeatWave Lakehouse does not support the ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-supported-data-types.html
String and text data types: CHAR VARCHAR TEXT TINYTEXT MEDIUMTEXT LONGTEXT VECTOR For string and text data type limitations, see Section 11.2.1.1, “Data Type Limitations”. Columns with unsupported data types must be excluded, and defined as NOT ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-varlen-encoding.html
Variable-length (VARLEN) encoding has the following characteristics: Supports all character sets and collation types supported by the DB System, and expressions with non-boolean types. VARLEN Supported Relational Operators GROUP BY JOIN LIMIT ORDER ... Variable-length encoding is automatically applied when tables are loaded into MySQL HeatWave with the exception of string columns defined explicitly as dictionary-encoded ...
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/relnotes/heatwave/en/news-8-0-31.html
(WL #15243) Functionality Added or Changed MySQL HeatWave uses dictionary encoding to compress string columns (CHAR, VARCHAR, TEXT). MySQL HeatWave AutoML Functionality Added or Changed MySQL HeatWave AutoML MySQL HeatWave AutoML queries are now ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-importing-data-bulk-ingesting.html
Importing Data Using the Bulk Ingest Feature 7.2.2.2 Importing Data Using the Bulk Ingest Feature Connect to a DB System and bulk ingest data from an Amazon S3 bucket to a DB System in the same region. This task requires the following: A client ...