5.8.1.3 Column Limits

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.14 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

  
  
  Note

  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.

What's Next

Learn how to encode string columns.