2.16.2 Excluded Columns

To identify table columns defined as NOT SECONDARY on the MySQL DB System, query the EXTRA column of the INFORMATION_SCHEMA.COLUMNS table. Columns defined with the NOT SECONDARY column attribute are not loaded into HeatWave when executing a table load operation.

Press CTRL+C to copy
 
mysql> SELECT COLUMN_NAME, EXTRA 
          FROM INFORMATION_SCHEMA.COLUMNS
          WHERE TABLE_NAME LIKE 't1' AND EXTRA LIKE '%NOT SECONDARY%';
+-------------+---------------+
| COLUMN_NAME | EXTRA         |
+-------------+---------------+
| O_COMMENT   | NOT SECONDARY |
+-------------+---------------+

You can also view columns defined as NOT SECONDARY for an individual table using SHOW CREATE TABLE.