Hi Dana, Please take look into following JIRA for _id issue which you have asked.
https://issues.apache.org/jira/browse/DRILL-4307 Thanks & Regards, B Anil Kumar. On Wed, Dec 7, 2016 at 11:15 PM, yousuf <[email protected]> wrote: > try this > > set store.mongo.bson.record.reader = false; > > > > On 12/08/2016 12:41 AM, Dana Jin wrote: > >> Hello guys, >> >> I have a trouble to query to MongoDB using Drill, so I’d like to ask for >> some help. :) >> >> When I queried to drill like: >> SELECT _id >> FROM ……mongodb…… >> LIMIT 1; >> >> The result looks like: >> [cid:AF8CBBA2-744E-44C9-807A-D752D5461BEF] >> >> The value should be like ‘540f9b7eee6da146f690166c’ >> Could anyone help me to get the proper _id? >> >> Thank you, >> >> Regards, >> Dana >> >> >
