Forum Discussion

Tenagra's avatar
Tenagra
Copper Contributor
May 14, 2021

Polybase TSQL Compare Issues

Hello all.  Polybase newbie here, so hoping that I'm just missing something simple.    I've configured Polybase between SQL Server 2019 CU9 and MySQL (5.7.12) via a generic ODBC driver.  Able to cr...
pabechevb's avatar
pabechevb
Copper Contributor
May 17, 2021

Tenagra how did you generate the T-SQL for creating the external table? I've found issues when there's anything different, so a trick I use is to let Polybase tell me what data types it is seeing, for example "create external table p.Account (dummy int) with (location='account', data_source=[DataSource]);", then the error returned will tell me exactly what are the columns and collations I must use when creating the external table, so I just replace the dummy T-SQL with the one returned.

I'm guessing between the NUMERIC(20,0) and the INT, Polybase is trying to do a conversion within the SQL statement being sent to MySQL, which the ODBC is catching up and failing before sending the request to MySQL.

You can also try doing the conversion from NUMERIC(20,0) to INT before the table join and see what happens.

Resources