drill-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From yousuf <yousufud...@css.org.sa>
Subject Re: How could I get _id from MongoDB?
Date Thu, 08 Dec 2016 07:15:44 GMT
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
>


Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message