外部表:Azure Blob存储:CREATE EXTERNAL TABLE连接问题 [英] External Table : Azure Blob Storage : CREATE EXTERNAL TABLE Connectivity Issue
问题描述
在创建外部表时,我一直在低于错误
创建外部数据源sql2016ds
WITH
(
TYPE = HADOOP,
LOCATION ='wasbs://dbproxsqlcontainer@dbproxazurestorage.blob.core.windows.net/',
CREDENTIAL = cred_azstorage);
$
GO
创建外部文件格式CSV
WITH(
FORMAT_TYPE = DELIMITEDTEXT,
FORMAT_OPTIONS(
FIELD_TERMINATOR =','
)
);
创建外部表Test20126
(
Name VARCHAR(255),
Country VARCHAR(255),
MobileNumber VARCHAR(255)
)
WITH
(
  ; LOCATION ='/ dbproxsqlcontainer',
DATA_SOURCE = sql2016ds,
FILE_FORMAT = CSV,
REJECT_TYPE = value,
REJECT_VALUE = 1
)
错误:
-
Msg
102 ,
Level 15 ,
State 1 ,
行 31 -
附近的语法错误 'CREDENTIAL' 。
Mohd Sufian www.sqlship.wordpress.com如果有帮助,请将帖子标记为已回复。
你有misspelt wasb。请尝试以下语句并查看它是否有效:
LOCATION ='wasb:/ /dbproxsqlcontainer@dbproxazurestorage.blob.core.windows.net /'
While creating External Table i am continuously getting below error
CREATE EXTERNAL DATA SOURCE sql2016ds
WITH
(
TYPE = HADOOP,
LOCATION = 'wasbs://dbproxsqlcontainer@dbproxazurestorage.blob.core.windows.net/',
CREDENTIAL = cred_azstorage);
GO
WITH (
FORMAT_TYPE = DELIMITEDTEXT,
FORMAT_OPTIONS (
FIELD_TERMINATOR = ','
)
);
CREATE EXTERNAL TABLE Test20126
(
Name VARCHAR(255),
Country VARCHAR(255),
MobileNumber VARCHAR(255)
)
WITH
(
LOCATION = '/dbproxsqlcontainer',
DATA_SOURCE = sql2016ds,
FILE_FORMAT = CSV,
REJECT_TYPE = value,
REJECT_VALUE=1
)
ERROR:
- Msg 102, Level 15, State 1, Line 31
- Incorrect syntax near 'CREDENTIAL'.
Mohd Sufian www.sqlship.wordpress.com Please mark the post as Answered if it helped.
You have misspelt wasb. Try the following statement and see if it works:
LOCATION = 'wasb://dbproxsqlcontainer@dbproxazurestorage.blob.core.windows.net/'
这篇关于外部表:Azure Blob存储:CREATE EXTERNAL TABLE连接问题的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!