PolyBase versus the March of Time

PolyBase is dead: Today, we are announcing the retirement of PolyBase scale-out groups in Microsoft SQL Server. Scale-out group functionality will be removed from the product in SQL Server 2022. In-market SQL Server 2019, 2017, and 2016 will continue to support the functionality to theĀ end of supportĀ for those products. Okay, not dead-dead. But let's talk…

PolyBase versus Flat Files

Wait, What? Today's post comes inspired by an Ed Pearson tweet that Chris Wood clued me into. https://twitter.com/ecpdata/status/1490496984544854016 Is there someone? Maybe! It took me a couple of weeks to get to this thanks to my crazy schedule but I have good news for you. PolyBase 12, Flat Files 8 I really like PolyBase's ability…

PolyBase and Postgres

Last month, I presented at year 4 of SQL Trail, a conference normally in Richmond, Virginia but entirely online this year due to obvious reasons. Before the conference, one of the attendees asked for a session on PolyBase, specifically around accessing Postgres data from SQL Server. I didn't have an example on that, so figured…

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 =…

SQL Server 2019 CU2: PolyBase and Cosmos DB Version Issue

After upgrading to SQL Server 2019 CU2, I noticed some issues when trying to connect to a Cosmos DB collection via PolyBase. Specifically, I started getting the following error message: Msg 105082, Level 16, State 1, Line 35105082;Generic ODBC error: [Microsoft][MongoDBODBC] (110) Error from MongoDB Client: Server at <<my Cosmos account name>>.documents.azure.com:10255 reports wire version 2, but this…

Update: PolyBase Revealed

I jumped the gun with the Cyber 5 sale, but PolyBase Revealed is available for pre-order. You can pre-order the paperback edition on Amazon for $27.99, get the Kindle edition on Amazon for $24.99, or buy the eBook directly from Apress for $19.99. When I originally spec'd out the book, I estimated that it would…

SQL Data Partners Episode: PolyBase

Back in August, Carlos L. Chacon, Eugene Meidinger, and I recorded an episode for the SQL Data Partners podcast on PolyBase. Episode 180 is now out for all to hear, so give it a listen. Since then, there have been a couple modifications to PolyBase functionality, but the episode stands up well. While you're at…