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.*
