Forum Discussion
Ariunbold_Chimeddorj
Jan 05, 2021Copper Contributor
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...
stephanesql
Jan 25, 2021Copper Contributor
Hi
I got the same error when creating the external data source while trying Polybase on my laptop.
The external data source is a local PostgreSQL 13 (running on WSL).
I installed the Postgresql ODBC driver and using a DSN named PostgreSQL35W_ro (tested ok, and I could connect it with for example Power BI in ODBC). I have no problem to connect using Azure Data Studio also.
I'm using the following statement (after creating a key in the database and credentials):
CREATE EXTERNAL DATA SOURCE my_postgresql_source
WITH (
LOCATION = 'odbc://localhost:5432',
CONNECTION_OPTIONS = 'DSN=PostgreSQL35W_ro',
CREDENTIAL = postgresql_creds
);I tried also :
CREATE EXTERNAL DATA SOURCE my_postgresql_source WITH
(
LOCATION = 'odbc://localhost:5432',
CONNECTION_OPTIONS = 'Driver={PostgreSQL Unicode(x64)}; Database=mabase',
CREDENTIAL = postgresql_creds,
PUSHDOWN = ON
);It gives the same error.
My SQL Server version is Developper Edition Microsoft SQL Server 2019 (RTM-CU8) (KB4577194) - 15.0.4073.23 (X64) running on Windows 10.
It there something wrong in my configuration ?
Thanks.
Ariunbold_Chimeddorj
Feb 03, 2021Copper Contributor
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
Ex: select cast(a as float) from external_table