FIX: Query may fail when you join a storage pool table with a data pool table in SQL Server 2019

Gilt für: SQL Server 2019 on LinuxSQL Server 2019 on Windows

Symptoms


Assume that you query external Active Directory (AD) data in SQL Server 2019. When you try to join a storage pool tablewith a data pool table, you may notice that the query may fail because the HDFS Delegation Tokenis invalidated. In addition, you may receive an error message as follows:
"Message Cannot bulk load because the file  "[your file path]" could not be opened. "

Status


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

Resolution


This issue is fixed in the following cumulative update for SQLServer:
About cumulative updates for SQL Server:
Each new cumulative update for SQL Server contains all thehotfixes and all the security fixes that were included with the previouscumulative update. Check out the latest cumulative updates for SQL Server:

References


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