MySQL HeatWave User Guide
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.
The maximum column widths supported for different string and text data types are as follows:
Table 5.13 Supported Column Widths
| String/Text Datatype | Column Width Supported from MySQL 9.2.2 | Column Width Supported Prior to MySQL 9.2.2 |
|---|---|---|
MEDIUMTEXT |
4192192 bytes | 65532 bytes |
LONGTEXT |
4192192 bytes | 65532 bytes |
JSON |
4192192 bytes | 65532 bytes |
TEXT |
65535 bytes | 65532 bytes |
CHAR |
65532 bytes | 65532 bytes |
VARCHAR |
65532 bytes | 65532 bytes |
VECTOR |
65532 bytes | 65532 bytes |
The maximum row width is 4 MB. This includes the size of all the data and column metadata stored in the row. Any table with multiple columns wherein the aggregate data size is greater than 4 MB cannot be loaded to MySQL HeatWave.
This applies to intermediate relations and final query results as well.
The maximum column limit for base relations, tables as loaded into MySQL HeatWave, is 1017.
The column limit for intermediate relations (intermediate tables used by MySQL HeatWave when processing queries) is 1800.
The actual column limit when running queries depends on factors such as MySQL limits, protocol limits, the total number of columns, column types, and column widths.
Learn how to encode string columns.