PolyBase and Excel: TOP Now Works

Back with SQL Server 2019 CU2, I reported an error with PolyBase connecting to Excel when trying to select TOP(10) from the table. I'm using the Microsoft Access Database Engine 2016 Redistributable's Excel driver. Here's a sample external data source and table statement: CREATE EXTERNAL DATA SOURCE VolcanoType WITH ( LOCATION = 'odbc://noplace', CONNECTION_OPTIONS =…

Advertisement