Hi guys, I was having a look at the MongoDB provider and was wondering if this is normal.
If I issue a basic: select * from mongo.db.collection; I end up with a single column coming back (named *) with the entire document in it. Of course, if I select individual fields, then this works fine, but means I have to be explicit about the fields I'm creating. If I wanted to do a simple CREATE TABLE AS (SELECT * FROM mongo) to convert to Parquet, for example, it won't work nicely as the Parquet document will just have a single map column in it. Any thoughts on how to get the actual fields?