Try to use the returned value as a map. select foo.field.`$date` from mongodb.table as foo;
If you can try, send a link to the attachments stored somewhere. The mailing list does not handle attachments. —Andries On Apr 13, 2015, at 3:50 PM, Vinay Bhat <[email protected]> wrote: > One of our customer is trying to query MongoDB with Drill and have issues > with reading date filed where data type shows up in the value. > > > > This is how lastModified data looks in MongoDB. > > > > > > > > > > > But when they query the data through sqlline or Drill Explorer, the output is > > > > > > > > > Is there a way we can parse or cast that column to just provide the value > itself rather than the data type as well. > > > > > Thanks > > Vinay Bhat > Solution Architect | MapR Technologies | [email protected] | 1-510-304-2990 > > > Now Available - Free Hadoop On-Demand Training > > >
