Polybase：Mongodb的外部数据源问题 [英] Polybase : External Data Source Issue with Mongodb
问题描述
大家好，
我一直在尝试使用polybase功能从SQL Server访问mongodb（版本4.0）集合。 Mongodb启动并运行SQL Server的远程访问。我按照链接 配置
PolyBase访问MongoDB中的外部数据
I have been trying to access mongodb(version 4.0) collection from SQL Server using polybase feature. Mongodb is up and running with remote access from SQL Server. I am following the instruction as as described in the link Configure PolyBase to access external data in MongoDB
我收到创建外部数据源的错误，polybase日志没有记录任何与mongodb的连接问题。 Polybase服务启动并运行没有任何问题（此实例是独立的，未连接到AD）。
I am receiving error on creating External Data Source , polybase logs have not recorded any issue with the connection to mongodb. The Polybase services are up and running without any issue (This instance is standalone and not connected to AD).
任何一个人面临类似的问题，请帮助和建议
Any one faced similar issues , please help and advice
创建外部数据源eds_mongodb
WITH（
LOCATION ='mongodb：//10.0.2.15：27017'，
- PUSHDOWN = ON | OFF，
CREDENTIAL = Mongo_Polybase_credentials
）;
CREATE EXTERNAL DATA SOURCE eds_mongodb
WITH (
LOCATION = 'mongodb://10.0.2.15:27017',
-- PUSHDOWN = ON | OFF,
CREDENTIAL = Mongo_Polybase_credentials
);
CREATE EXTERNAL TABLE mongo_dfgd（
_id < span style ="white-space：pre"> nvarchar（2000），
name varchar（200），
地址 varchar（300），
street varchar（200）
）
WITH（
$
LOCATION ='mongosg.test1'，
DATA_SOURCE = eds_mongodb
）;
CREATE EXTERNAL TABLE mongo_dfgd(
_id nvarchar(2000),
name varchar(200),
address varchar(300),
street varchar(200)
)
WITH (
LOCATION='mongosg.test1',
DATA_SOURCE= eds_mongodb
);
错误执行创建外部表命令
Error on executing Create external table command
Msg 105082，Level 16，State 1，Line 36
105082;通用ODBC错误：[Microsoft] [MongoDBODBC]（110）错误来自MongoDB客户端：找不到合适的服务器（`serverSelectionTryOnce` set）：[套接字超时在'10 .0.2.15：27017上调用ismaster']（错误代码：13053）其他错误< 2>：ErrorMsg：[Microsoft] [MongoDBODBC]
（110）来自MongoDB客户端的错误：找不到合适的服务器（`serverSelectionTryOnce` set）：[套接字超时在'10 .0.2.15：27017上调用ismaster']（错误代码：13053），SqlState：HY000，NativeError： 110。
Msg 105082, Level 16, State 1, Line 36
105082;Generic ODBC error: [Microsoft][MongoDBODBC] (110) Error from MongoDB Client: No suitable servers found (`serverSelectionTryOnce` set): [socket timeout calling ismaster on '10.0.2.15:27017'] (Error Code: 13053) Additional error <2>: ErrorMsg: [Microsoft][MongoDBODBC]
(110) Error from MongoDB Client: No suitable servers found (`serverSelectionTryOnce` set): [socket timeout calling ismaster on '10.0.2.15:27017'] (Error Code: 13053), SqlState: HY000, NativeError: 110 .
问候
Sufian
推荐答案
不是我知道有关MongoDB的任何信息，但错误信息对我来说似乎很清楚。在端口27017上可以访问MongoDB，地址为10.0.2.15。这可能是因为根本没有MongoDB服务，或者有防火墙 - 传入或传出
- 顺便说一句。
Not that I know anything about MongoDB, but the error message seems clear to me. There is MongoDB to be reached on port 27017, address 10.0.2.15. This could be because there is no MongoDB service there at all, or there is a firewall - incoming or outgoing - in the way.
通过使用它来解决这个问题可能更简单特定于MongoDB的工具尝试连接，从而使SQL Server和Polybase脱离了等式。
It's probably simpler to troubleshoot this by using MongoDB-specific tools to attempt to connect, and thus take SQL Server and Polybase out of the equation.
这篇关于Polybase：Mongodb的外部数据源问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
