PolyBase error – 100001;Failed to generate query plan.

 dans Sites Microsoft par

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, the error will display differently.

 

CREATE EXTERNAL TABLE or CREATE EXTERNAL DATA SOURCE command fails with:

 

Msg 110813, Level 16, State 1, Line 21

100001;Failed to generate query plan.

 

SELECT from an existing external table fails with:

 

Msg 7320, Level 16, State 110, Line 1

Cannot execute the query « Remote Query » against OLE DB provider « MSOLEDBSQL » for linked server « (null) ». 100001;Failed to generate query plan.