获取错误“'HADOOP'附近的语法不正确”在创建外部数据源时 [英] Getting error "Incorrect syntax near 'HADOOP'" while creating an external data source

问题描述

 我收到 " 'HADOOP'附近的语法不正确"在尝试为多边形数据加载创建外部数据源时。

  I am getting "Incorrect syntax near 'HADOOP'" while trying to create an external data source for polybase data loads.

查询：

CREATE DATABASE SCOPED CREDENTIAL AzureStoragecred

WITH¥b $ b    IDENTITY ='abcdblobstorage'，

    SECRET ='******'

;



创建外部数据源abcdblobstorageprimary

WITH（

   TYPE = HADOOP，

   LOCATION ='wasb：//[e-mail]'，

   CREDENTIAL = AzureStoragecred

）;

CREATE DATABASE SCOPED CREDENTIAL AzureStoragecred
WITH
    IDENTITY = 'abcdblobstorage',
    SECRET = '******'
;

CREATE EXTERNAL DATA SOURCE abcdblobstorageprimary
WITH (
    TYPE = HADOOP,
    LOCATION = 'wasb://[e-mail]',
    CREDENTIAL = AzureStoragecred
);

Raj

推荐答案

Hey Raj，

Hey Raj,

你确定你是针对SQL DW运行的吗？
$
当我针对SQL DB或MASTER运行脚本时，我得到了一个repro。当我在我的数据仓库中运行它时，对象已成功创建。

Are you sure that you are running this against the SQL DW?
When I ran your script against a SQL DB or MASTER I got a repro. when I ran it against my data warehouse the objects were created successfully.

这篇关于获取错误“'HADOOP'附近的语法不正确”在创建外部数据源时的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！