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 <g...@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!