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

  • ramya.sqlservr

    Ten Centuries

    Points: 1068

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

  • rschoenborn 38340

    SSC Enthusiast

    Points: 128

    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

    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

    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

    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

    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

    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

    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 ... 😀

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

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