Getting Started with Polybase—Incorrect Syntax near ‘EXTERNAL’ Error

I was playing around with configuring Polybase this morning. Nothing to exotic, just installing the feature getting started. I got everything installed and was about ready to created my data source. The command to that is as follows:

CREATE EXTERNAL DATA SOURCE AzureStorage
WITH (           
TYPE = Hadoop,        
LOCATION = ‘wasb://polybase@mystorageaccountnamehere.blob.core.windows.net’,
CREDENTIAL = AzureStorageCredential);

Unfortunately, it returned the following error:

Msg 102, Level 15, State 1, Line 1

Incorrect syntax near ‘EXTERNAL’.

So what was the fix? A reboot after installing Polybase. The official documentation refers to restarting SQL Server, which I did. Nothing warned me to reboot, but rebooting fixed the error.

About jdanton1
A DBA, cyclist, cook (who likes to play chef occasionally)

2 Responses to Getting Started with Polybase—Incorrect Syntax near ‘EXTERNAL’ Error

  1. pituach says:

    Elastic Database queries are supported only on Azure SQL Database v12 or later, Not on local server.

  2. saul says:

    well, on their website it says they support SQL Server 2016, I guess the documentation is wrong

Leave a Reply to pituach Cancel reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d bloggers like this: