Forcing External Pushdown

In the last post, we dug into how the MapReduce process works.  Today, I want to spend a little bit of time talking about forcing MapReduce operations and disabling external pushdown. What Can We Force? Before we get into the mechanics behind forcing pushdown, it's important to note that predicate pushdown is somewhat limited in…

Running MapReduce Polybase Queries

Previously, we looked at basic querie which do not perform MapReduce operations.  Today's post is going to look at queries which do perform MapReduce operations and we'll see how they differ. MapReduce Queries In order for us to be able to perform a MapReduce operation, we need the external data source to be set up…

Curated SQL At One Year

Curated SQL is just over a year old now.  I started work on it during PASS Summit 2015, and I'm happy with the results so far. By The Numbers I'm up to 2026 posts on Curated SQL.  My three largest categories are Administration, Cloud, and Hadoop.  I used to call "Cloud" Azure, but kept running…

Creating External Tables

At this point, we've got Polybase configured and have created external data sources and file formats (and by the way, if you haven't been keeping up, I am tracking my entire Polybase series there).  Now we want to create an external table to do something with all of this.  As usual, my first stop is MSDN, which…