-
Notifications
You must be signed in to change notification settings - Fork 140
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
CREATE CLUSTERED COLUMNSTORE INDEX - Not working #117
Comments
Thanks for reporting. I think this is fixed, but I'm not able to test as Column Store indexes are only supported in Enterprise Edition. Please test using the latest version and let me know if this is fixed. Thanks. |
Hi @sethreno , The fix must:
I'm available and please let me know if you need help on this. Thank you in advance, such a great script:+1: excellent new features loved it |
This should be fixed in the latest version https:/sethreno/schemazen/releases/tag/1.3.51 Again, I'm not able to test so please verify and let me know if it works. Thanks! |
hi @sethreno still not working |
I'm using msdn as a reference and I don't see anything wrong. Can you give more detail on what's not working? If you could post the script produced by the latest schemazen exe compared to a working script that would be great. |
The issue is in the syntax. The program is creating the following : but it needs to be CREATE CLUSTERED COLUMNSTORE INDEX [IndexName] ON [schema].[TableName] The clustered columnstore index includes all columns as this is how it is designed. |
Hi,
When extracting and creating CCI index the structure is different and it doesn't create the table or index.
Example:
Source:
CREATE CLUSTERED COLUMNSTORE INDEX [CCI_SCHEMAZEN_ROX] ON [dbo].[SchemaZen]
Trying to create a normal index:
CREATE NONCLUSTERED INDEX [CCI_SCHEMAZEN_ROX] ON [dbo].[SchemaZen] () INCLUDE (columns....)
Error giving: Incorrect syntax near ')'.
Thank you in Advance,
Mário Mineiro
The text was updated successfully, but these errors were encountered: