创建“外部数据源"时出错；在SQL Server 2016版本中，尝试将本地SQL Server与Azure Data Lake连接. [英] Error while creating "EXTERNAL DATA SOURCE" in SQL Server 2016 version, trying to connect local SQL Server with Azure Data Lake.
问题描述
我正在尝试使用Polybase概念将SQL Server与Azure Data Lake连接起来.尝试创建外部数据源时，出现以下错误:
I am trying to connect SQL Server with Azure Data Lake using Polybase concept. While trying to create External Data Source below error is coming:
SQL命令:
创建外部数据源AzureDataLakeStore_4
WITH(
TYPE = HADOOP，
位置='adl://pesdatalake1.azuredatalakestore.net'，
凭据= [ADL_User3]
);
CREATE EXTERNAL DATA SOURCE AzureDataLakeStore_4
WITH (
TYPE = HADOOP,
LOCATION = 'adl://pesdatalake1.azuredatalakestore.net',
CREDENTIAL = [ADL_User3]
);
错误:
信息105007，第16级，状态1，第11行
不支持输入URI的方案.请修改以下方案，然后重试:'adl'
Msg 105007, Level 16, State 1, Line 11
Scheme of the input URI is not supported. Please revise the following scheme and try again: 'adl'
遵循的步骤:
1.在Azure门户中添加了Azure Data Lake.
1. Added Azure Data Lake in Azure portal.
2.将数据文件加载到Azure数据湖.
2. Loaded data file to Azure data lake.
3.进行了应用注册，并创建了APP密钥，Auth密钥和Oauth.
3. Did app registration, and created APP key, Auth Key and Oauth.
4.可以访问上面创建的App的数据文件.
4. Given access to data file for App created above.
5.在SQL中创建主密钥
5. Created master key in SQL
6. C 已确定范围数据库凭证.
7.创建外部数据源时出现问题.
推荐答案
你好，
我在这里看到示例:
The 'LOCATION' value is set like this:
LOCATION = 'adl://<AzureDataLake account_name>.azuredatalake.net',
您的样本中URL中有单词"store"，但示例中没有.
Your sample has the word 'store' in the URL, but the example does not.
这篇关于创建“外部数据源"时出错；在SQL Server 2016版本中，尝试将本地SQL Server与Azure Data Lake连接.的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
