I tried to execute the following: EXEC sp_polybase_join_group but the following error occured: This stored procedure is not available because Polybase feature is not enabled

Try to enable it by running below query exec sp_configure @configname = 'polybase enabled', @configvalue = 1; RECONFIGURE; Please don't forget to Accept Answer and Up-vote if the response helped -- Vaibhav

Polybase feature is not enabled

Accepted answer

Vaibhav Chaudhari 38,606 Reputation points

2021-03-19T09:03:09.307+00:00
Try to enable it by running below query

exec sp_configure @configname = 'polybase enabled', @configvalue = 1; RECONFIGURE;

Please don't forget to Accept Answer and Up-vote if the response helped -- Vaibhav
Please sign in to rate this answer.

1 person found this answer helpful.
Surendra Adhikari 21 Reputation points

2021-03-19T10:14:54.213+00:00

Thanks, it solved the problem.
Now I am trying to create polybase for mongodb in SQL Server.
I created the following.
CREATE DATABASE SCOPED CREDENTIAL mongocred WITH IDENTITY = 'user', Secret = 'password';

CREATE EXTERNAL DATA SOURCE mongosource
WITH (LOCATION = 'mongodb://10.15.1.24:27017',
CREDENTIAL = mongocred);

But could not create the external table. The following error is encountered.
105082;Generic ODBC error: [Microsoft][MongoDBODBC] (110) Error from MongoDB Client: No suitable servers found (serverSelectionTryOnce set): [connection closed calling ismaster on '10.15.1.24:27017'] (Error Code: 13053) Additional error <2>: ErrorMsg: [Microsoft][MongoDBODBC] (110) Error from MongoDB Client: No suitable servers found (serverSelectionTryOnce set): [connection closed calling ismaster on '10.15.1.24:27017'] (Error Code: 13053), SqlState: HY000, NativeError: 110 .

Vaibhav Chaudhari 38,606 Reputation points

2021-03-19T10:39:19.057+00:00

Check if suggestions here help: https://social.msdn.microsoft.com/Forums/azure/en-US/97bbbcad-a7d1-4ef1-ac30-f0aa11665290/polybase-external-data-source-issue-with-mongodb?forum=sqldatabaseengine

else you can also post question on MongoDB forum separately as issue looks more on Mongo DB side

Surendra Adhikari 21 Reputation points

2021-03-19T11:01:22.32+00:00

Thanks. It worked for me.
Sign in to comment

Polybase feature is not enabled

0 additional answers