You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@drill.apache.org by Dana Jin <Da...@airg.com> on 2016/12/07 21:41:39 UTC

How could I get _id from MongoDB?

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

Re: How could I get _id from MongoDB?

Posted by AnilKumar B <ak...@gmail.com>.

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 <yo...@css.org.sa> 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
>>
>>
>

Re: How could I get _id from MongoDB?

Posted by yousuf <yo...@css.org.sa>.

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 Id 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
>