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.
Elastic Database queries are supported only on Azure SQL Database v12 or later, Not on local server.
well, on their website it says they support SQL Server 2016, I guess the documentation is wrong