Charles, It worked with Drill 1.21.1 and 1.20.3, after connection url was modified thus:
mongodb+srv://userid:[email protected]/ 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 <[email protected]> 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:[email protected]: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.* > >
