2.14.3 Column Limits

HeatWave has the following column limits:

• As of MySQL 9.2.2, the maximum column width is 4192192 bytes.

  The maximum column widths supported for different string and text data types are as follows:

  • MEDIUMTEXT, LONGTEXT, and JSON: 4192192 bytes

  • TEXT: 65335 bytes

  • CHAR, VARCHAR, and VECTOR: 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 HeatWave.

  This applies to intermediate relations and final query results as well.

  In previous versions of MySQL, the maximum column width is 65532 bytes.

• The maximum column limit for base relations, tables as loaded into HeatWave, is 1017.

• The column limit for intermediate relations (intermediate tables used by 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.