When you execute a query that includes an INSERT INTO...SELECT statement that inserts values into a partitioned clustered columnstore index in SQL Server 2014 or 2016, an intra-query deadlock occurs.
This issue is fixed in the following cumulative updates for SQL Server:
Cumulative Update 3 for SQL Server 2014 Service Pack 2
Note After you install this update, you must set trace flag 2469 to enable the fix. To set trace flag 2469, see the Trace Flags (Transact-SQL) topic on the Microsoft Developer Network (MSDN) website.
To work around this issue, use one of the following methods:
Store the intermediate results of the SELECT statement in a temporary table, and then insert the results into the clustered columnstore index from the temporary table.
Run the query by using DOP=1.
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
Learn about the terminology that Microsoft uses to describe software updates.