Forum Discussion
Sql server 2019 polybase: 100001;Failed to generate query plan.
Hello all, I have enabled the polybase on my sql server. When i try to create external data source, below error throws. What is the cause of this error? Error: 100001;Failed to generate query plan...
Ariunbold_Chimeddorj Verify if the polybase services are enabled on the server and show us the statement you are using.
Yes, it is enabled on the server. I can query external tables but external table contains column with decimal type, it throws this error. Workaround is cast the decimal columns when execute the select statement.
Ex: select cast(a as float) from external_table;
Ex: select cast(a as float) from external_table;