Hi Adam, There is a Jira ticket for this issue DRILL-1692 <https://issues.apache.org/jira/browse/DRILL-1692>. I recently provided patch for this. I think it will be committed in the upcoming release.
On Tue, Feb 17, 2015 at 12:17 PM, Adam Gilmore <dragoncu...@gmail.com> wrote: > 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? > -- Kamesh.