Excellent! Do you think we should update the Drill docs for this? Sent from my iPhone
> On May 3, 2023, at 19:37, Pinaki Ghosh <pgh...@oncentrl.com> wrote: > > Charles, > > It worked with Drill 1.21.1 and 1.20.3, after connection url was modified > thus: > > mongodb+srv://userid:p...@clustername.mongodb.net/ > > Thanks > Pinaki > >> On 2023/05/03 02:45:42 Charles Givre wrote: >> Pinaki, >> Can you please try with Drill 1.21.1? I believe this issue was resolved. >> Best, >> -- C >> >>>> On May 2, 2023, at 9:10 PM, Pinaki Ghosh <pg...@oncentrl.com> wrote: >>> >>> Hi, >>> >>> I am receiving the error below when querying a collection in a MongoDB >>> cluster from Drill UI (Drill version 1.20.3). >>> >>> select * from mongo.dbname.`collectionname` >>> >>> org.apache.drill.common.exceptions.UserRemoteException: VALIDATION > ERROR: >>> org.apache.drill.common.exceptions.DrillRuntimeException: databaseName > can >>> not be null >>> >>> Drill storage for remote MongoDB (Atlas) cluster is configured - type >>> 'mongo', connection url thus: >>> mongodb://userid:p...@node0.mongodb.net:27017,node1.mongodb.net:27017, >>> node2.mongodb.net:27017/?ssl=true&authSource=admin >>> >>> Same query works for drill storage configured to my local MongoDB. >>> >>> Is there some configuration or query formatting that I'm missing? >>> >>> Regards >>> Pinaki >>> >>> >>> *This email and any attachments thereto may contain private and >>> confidential material for the sole use of the intended recipient. Any >>> review, copying, or distribution of this email (or any attachments > thereto) >>> by others is strictly prohibited. If you are not the intended > recipient, >>> please contact the sender immediately and permanently delete the > original >>> and any copies of this email and any attachments thereto.* >> >>
