Hi, I'm in the process of converting a tableau report that previously used the MongoDB BI Connector to use Apache Drill instead. One gotcha that I'm working to overcome is that the report utilizes virtual tables flattened from embedded array columns in the Mongo collection. I did some googling, to my dismay I didn't find anywhere that Apache Drill had this functionality.
I had the idea of using views (https://drill.apache.org/docs/create-view/) to mimic this behavior in drill using the flatten (https://drill.apache.org/docs/flatten/) function where appropriate. When I tried to create the view I get the following error message: org.apache.drill.common.exceptions.UserRemoteException: VALIDATION ERROR: Unable to create or drop objects. Schema [mongo.grounds] is immutable. I read online at; https://drill.apache.org/docs/mongodb-storage-plugin/, that the MongoDB storage plugin is read-only. Does that also include DDL? Is there a better approach that I should be taking with this?
