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 <[email protected]>
> Sent: Wednesday, September 13, 2017 11:26 AM
> To: [email protected]
> 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!
>
>
>
