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...
I'm receiving the same error with the same version of sql. I'm attempting to create a SQL external data source though. I have an open support ticket with Microsoft. I'll update this thread if we discover a resolution.
I'm having this error when my source table have decimal columns. My workaround is cast the decimal to float, it works for me.
Ex: select cast(a as float) from external_table