Tablestore: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?

Problem description

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

Cause

If you do not create a mapping table for a data table and execute an SQL statement, such as DESCRIBE or SELECT to query data in the data table, Tablestore automatically creates a mapping table for the data table. The mapping table that is automatically created by Tablestore contains only the primary key columns and predefined columns of the data table. The attribute columns of the mapping table cannot be updated.

Solution

Delete the mapping table that is automatically created by Tablestore and create a mapping table for the data table. For more information, see Delete mapping tables and Create a mapping table for a table.