What do I do if the "Unsupported operation: Unsupported alter non-mapping table" error message is returned when I update the attribute columns of a mapping table?

Error message

Message: Unsupported operation: 'Unsupported alter non-mapping table'.

Cause

When you run a SQL statement such as DESCRIBE or SELECT against a data table that has no mapping table, Tablestore automatically creates one. This auto-created mapping table includes only the primary key columns and predefined columns of the data table — it does not include attribute columns, and you cannot add them later with ALTER TABLE. This is a system constraint, not a bug.

Solution

Delete the auto-created mapping table and create a user-defined mapping table for the data table. For more information, see Delete mapping tables and Create a mapping table for a table.