drill-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Robert Hou <r...@mapr.com>
Subject Re: How to query values in list
Date Thu, 14 Sep 2017 00:47:31 GMT
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
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message