title: Column has a data type that cannot participate in a columnstore index
body: <p>I want to create a clustered columnstore index in a table using the following query:</p>
  <pre><code>CREATE CLUSTERED COLUMNSTORE INDEX cci
  ON agl_20180319_bck
  </code></pre>
  <p>And I am getting this error:</p>
  <blockquote>
  <p>Msg 35343, Level 16, State 1, Line 6<br />
  The statement failed. Column 'memberOf' has a data type that cannot participate in a columnstore index. Omit column 'memberOf'.</p>
  </blockquote>
  <p>The 'memberOf' is in this type: <code>memberOf nvarchar(max)</code>.</p>
  <p>How to overcome/ignore this error and what does it mean?</p>