Error with Columnstore Index in SQL Server


Error message related to a columnstore index in SQL Server, suggesting to omit column ‘id’ due to data type compatibility issues.


Hi all, can someone help me with the following error please “(‘42000’, “[42000] [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]The statement failed. Column ‘id’ has a data type that cannot participate in a columnstore index. Omit column ‘id’. (35343) (SQLMoreResults)”)”

This topic has been created from a Slack thread to give it more visibility.
It will be on Read-Only mode here. Click here if you want to access the original thread.

Join the conversation on Slack

["error", "columnstore-index", "sql-server", "data-type", "id"]