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