You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@drill.apache.org by gus <gg...@riseup.net> on 2017/09/13 18:26:09 UTC

How to query values in list

Hi, in this example[1], what's the syntax in apache drill to query "v11._" with the value of "0070"?
I'm using MongoDB.

thanks!,
gus

[1] example:
https://share.riseup.net/#PgfEnTO7jEXPbpA5QOgcRg

Re: How to query values in list

Posted by Robert Hou <rh...@mapr.com>.
Good to know!


Thanks.


--Robert


________________________________
From: gus <gg...@riseup.net>
Sent: Wednesday, September 13, 2017 7:28 PM
To: user@drill.apache.org
Subject: Re: How to query values in list

Dear Robert, it worked!

I also needed to change this:

    store.mongo.all_text_mode = true

thanks!,
gus

Em Thu, Sep 14, 2017 at 12:47:31AM +0000, Robert Hou escreveu:
> Try:
>
>
>    select t.v11._ from dfs.`<path to table>`  t where t.v11._ = '0070';
>
>
> This works for json.  Try it with MongoDB.
>
>
> Thanks.
>
>
> --Robert
>
> ________________________________
> From: gus <gg...@riseup.net>
> Sent: Wednesday, September 13, 2017 11:26 AM
> To: user@drill.apache.org
> Subject: How to query values in list
>
> Hi, in this example[1], what's the syntax in apache drill to query "v11._" with the value of "0070"?
> I'm using MongoDB.
>
> thanks!,
> gus
>
> [1] example:
> https://share.riseup.net/#PgfEnTO7jEXPbpA5QOgcRg
share.riseup.net<https://share.riseup.net/#PgfEnTO7jEXPbpA5QOgcRg>
share.riseup.net
CLI - Contact - Up1 Upload is currently limited to 50mb and files are stored no longer than a week!



> share.riseup.net<https://share.riseup.net/#PgfEnTO7jEXPbpA5QOgcRg>
share.riseup.net<https://share.riseup.net/#PgfEnTO7jEXPbpA5QOgcRg>
share.riseup.net
CLI - Contact - Up1 Upload is currently limited to 50mb and files are stored no longer than a week!



> share.riseup.net
> CLI - Contact - Up1 Upload is currently limited to 50mb and files are stored no longer than a week!
>
>
>

Re: How to query values in list

Posted by gus <gg...@riseup.net>.
Dear Robert, it worked! 

I also needed to change this:

    store.mongo.all_text_mode = true

thanks!,
gus

Em Thu, Sep 14, 2017 at 12:47:31AM +0000, Robert Hou escreveu:
> Try:
> 
> 
>    select t.v11._ from dfs.`<path to table>`  t where t.v11._ = '0070';
> 
> 
> This works for json.  Try it with MongoDB.
> 
> 
> Thanks.
> 
> 
> --Robert
> 
> ________________________________
> From: gus <gg...@riseup.net>
> Sent: Wednesday, September 13, 2017 11:26 AM
> To: user@drill.apache.org
> Subject: How to query values in list
> 
> Hi, in this example[1], what's the syntax in apache drill to query "v11._" with the value of "0070"?
> I'm using MongoDB.
> 
> thanks!,
> gus
> 
> [1] example:
> https://share.riseup.net/#PgfEnTO7jEXPbpA5QOgcRg
> share.riseup.net<https://share.riseup.net/#PgfEnTO7jEXPbpA5QOgcRg>
> share.riseup.net
> CLI - Contact - Up1 Upload is currently limited to 50mb and files are stored no longer than a week!
> 
> 
>

Re: How to query values in list

Posted by Robert Hou <rh...@mapr.com>.
Try:


   select t.v11._ from dfs.`<path to table>`  t where t.v11._ = '0070';


This works for json.  Try it with MongoDB.


Thanks.


--Robert

________________________________
From: gus <gg...@riseup.net>
Sent: Wednesday, September 13, 2017 11:26 AM
To: user@drill.apache.org
Subject: How to query values in list

Hi, in this example[1], what's the syntax in apache drill to query "v11._" with the value of "0070"?
I'm using MongoDB.

thanks!,
gus

[1] example:
https://share.riseup.net/#PgfEnTO7jEXPbpA5QOgcRg
share.riseup.net<https://share.riseup.net/#PgfEnTO7jEXPbpA5QOgcRg>
share.riseup.net
CLI - Contact - Up1 Upload is currently limited to 50mb and files are stored no longer than a week!