SQL Server Columnstore Index Error

Slack Knowledge Base Q&A Connector Questions
, , , ,
1

Summary

User is encountering an error related to a columnstore index in SQL Server, indicating that the ‘id’ column’s data type is incompatible.


Question

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

['sql-server', 'odbc-driver', 'columnstore-index', 'data-type-error']