drill-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From gus <g...@riseup.net>
Subject Re: How to query values in list
Date Thu, 14 Sep 2017 02:28:38 GMT
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 <ggus@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!
> 
> 
> 


Mime
View raw message