FIX: Query operation freezes when you insert data into a clustered columnstore index in parallel in SQL Server data warehousing

Applies to: SQL Server 2017 Enterprise CoreSQL Server 2017 Standard WindowsSQL Server 2016 Developer More

Symptoms


Assume that you use Microsoft SQL Server data warehousing. When you run parallel insert queries to insert data into a clustered columnstore index, the query operation freezes.

Resolution


This problem is fixed in the following updates for SQL Server:

Cumulative Update 12 for SQL Server 2017

Cumulative update 4 for SQL Server 2016 SP2

Status


Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

References


Learn about the standard terminology Microsoft uses to describe software updates.