Clustered Columnstore Index Gives "Unable to find index entry" Error

Question

Clustered Columnstore Index Gives "Unable to find index entry" Error

ramya.sqlservr

Ten Centuries

Points: 1068
More actions
September 1, 2014 at 11:46 pm

#289571

Comments posted to this topic are about the item Clustered Columnstore Index Gives "Unable to find index entry" Error

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

rschoenborn 38340 SSC Enthusiast Points: 128 More actions · Answer 1

This is the same problem SQL Server has with having Materialized Views on tables. I am haven't tried it yet, but I am hoping a true Column Store physical table structure will mitigate this issue. But a note of warning. Doing ETL into a physical Column Store database structure takes careful planning of Horizontal partitioning as it drastically impacts the vertical partitioning gain of the Column Store structure. It boils down to I/O, and how much I/O you need to reed through to get the result.

DBA_Freddie Right there with Babe Points: 750 More actions · Answer 2

Hello, Ramya.

Thanks for putting up this post!

Did Microsoft say they would be working on a fix for this issue and is there an issue open on Microsoft Connect?

ramya.sqlservr Ten Centuries Points: 1068 More actions · Answer 3

Microsoft updated us that a hotfix for this issue will be released soon probably by the end of october.

I will post a reply on this forum once I get the details.

Thanks,

Ramya

marunte SSC Rookie Points: 45 More actions · Answer 4

hello Ramya,

Thanks for your article. I suppose no new data is inserted? if so, then the columnstore index should be removedbefore the load and added again after the load.

Columnstore Indexes was introducedin SQL Server 2012

ramya.sqlservr Ten Centuries Points: 1068 More actions · Answer 5

You are absolutely right when it comes to non-clustered columnstore indexes which were introduced in SQL Server 2012. But SQL Server 2014 came up with clustered columnstore indexes which are updateable. These indexes can be used for our DML operations. Its a good concept to try.

You can find more info on this here.

http://msdn.microsoft.com/en-us/library/gg492088.aspx

Thanks,

Ramya

ramya.sqlservr Ten Centuries Points: 1068 More actions · Answer 6

This issue is resolved in CU6 for SQL Server 2014.

http://support.microsoft.com/kb/3031047/en-us

Thanks,

Ramya Makam

v.sierra SSC Enthusiast Points: 142 More actions · Answer 7

I has the same error but is not over a clustered columnstore index. I drop, rebuild and reindex the index and the error still apear, then i try copy the entire table and the error still apear, only without the index "corrupted" works, for last i modify the index structure included another column, and finally de error off ... 😀