Blog Post

SQL Server Support Blog
5 MIN READ

PolyBase error - 100001;Failed to generate query plan.

NathanMSFT's avatar
NathanMSFT
Icon for Microsoft rankMicrosoft
Mar 01, 2021
Problem We've seen several cases come in lately where customers have been trying to use PolyBase feature and encountering "Failed to generate query plan" error. Depending on which command you run, ...
Published Mar 01, 2021
Version 1.0
eriund's avatar
eriund
Copper Contributor
Mar 17, 2021

 

Spoiler

I have done all this, but still have the same issue. 100001;Failed to generate query plan. The Polybase feature and the database has the same level.

I've got:

 

 

Microsoft SQL Server 2019 (RTM-CU9) (KB5000642) - 15.0.4102.2 (X64) Jan 25 2021 20:16:12 Copyright (C) 2019 Microsoft Corporation Enterprise Edition: Core-based Licensing (64-bit) on Windows Server 2016 Standard 10.0 <X64> (Build 14393: ) (Hypervisor) 

 

ProductVersion FileVersion FileName
-------------- ----------- --------
15.0.4102.2 2019.0150.4102.02 ((SQL19_RTM_QFE-CU).210126-0356) C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\Binn\Polybase\mpdwsvc.exe
15.0.4102.2 2019.0150.4102.02 ((SQL19_RTM_QFE-CU).210126-0356) C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\Binn\Polybase\mpdwsvc.exe