You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@drill.apache.org by "mathieuruellan (via GitHub)" <gi...@apache.org> on 2024/09/16 07:59:20 UTC
[I] Can't configure Mongo UL with query parameter (drill)
mathieuruellan opened a new issue, #2942:
URL: https://github.com/apache/drill/issues/2942
Before submitting a bug report, please verify that you are using the most current version of Drill.
**Describe the bug**
I'm configuring the mongo connector with an url containing query parameters. The JSON is rejected because "invalid"
**To Reproduce**
Steps to reproduce the behavior:
1. Go to Drill UI/Storage/Mongo/Update
2. edit the json and enter a valid mongo url with query parameter
for instance: "connection": mongodb+srv://admin:XXXXXX@localhost:4117/myDB?readPreference=secondaryPreferred",
4. See error
Please retry: Invalid JSON: Failure when decoding plugin JSON

--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: dev-unsubscribe@drill.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] Can't configure Mongo UL with query parameter (drill)
Posted by "cgivre (via GitHub)" <gi...@apache.org>.
cgivre commented on issue #2942:
URL: https://github.com/apache/drill/issues/2942#issuecomment-2353103517
@mathieuruellan I think the `batchSize` is not a valid parameter. Try removing that and see if it works. The problem that you're having is that you've added some parameter that doesn't exist in the Mongo config.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: dev-unsubscribe@drill.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] Can't configure Mongo UL with query parameter (drill)
Posted by "mathieuruellan (via GitHub)" <gi...@apache.org>.
mathieuruellan commented on issue #2942:
URL: https://github.com/apache/drill/issues/2942#issuecomment-2353155330

The same without query parameters is ok:

--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: dev-unsubscribe@drill.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] Can't configure Mongo UL with query parameter (drill)
Posted by "mathieuruellan (via GitHub)" <gi...@apache.org>.
mathieuruellan commented on issue #2942:
URL: https://github.com/apache/drill/issues/2942#issuecomment-2352303815
(the screenshot has a typo with a missing quote), but the issue is still valid
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: dev-unsubscribe@drill.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] Can't configure Mongo UL with query parameter (drill)
Posted by "mathieuruellan (via GitHub)" <gi...@apache.org>.
mathieuruellan closed issue #2942: Can't configure Mongo UL with query parameter
URL: https://github.com/apache/drill/issues/2942
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: dev-unsubscribe@drill.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] Can't configure Mongo UL with query parameter (drill)
Posted by "cgivre (via GitHub)" <gi...@apache.org>.
cgivre commented on issue #2942:
URL: https://github.com/apache/drill/issues/2942#issuecomment-2353278916
@mathieuruellan Sorry.. I haven't worked with Drill and Mongo in some time. Let's try a few things:
1. Execute the command `!verbose` in Drill's command line and see what kind of errors we're getting.
2. It looks like the issue is in the connection string and that Drill or Mongo isn't liking one of the arguments. Can you try adding the arguments one by one to see if it is a specific argument that Drill isn't liking or whether Drill isn't liking the options at all. Ideally, what I'm hoping we can get is a stack trace in the CLI that is more helpful than the crappy error message in the user interface.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: dev-unsubscribe@drill.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] Can't configure Mongo UL with query parameter (drill)
Posted by "mathieuruellan (via GitHub)" <gi...@apache.org>.
mathieuruellan commented on issue #2942:
URL: https://github.com/apache/drill/issues/2942#issuecomment-2354869087
Actually, it was a specific parameter "authMechanism=DEFAULT" not supported because the driver and its mongo url parser is old.
Problem solved.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: dev-unsubscribe@drill.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org