Thanks Kathleen.
SELECT camic.provenance.image.case_id caseid
from mongo.users.`contacts2` camic
where camic.provenance.image.case_id > 10;
works for me as well.
I have also resolved the bug report that I opened as "Invalid"
Regards,
Pradeeban.
On Thu, Aug 18, 2016 at 5:33 PM, Kathleen Li
Hi Prdedeeban,
Please check out the following doc:
http://drill.apache.org/docs/select-statements/
Column Aliases. You cannot reference column aliases in the following clauses:
* WHERE
* GROUP BY
* HAVING
http://drill.apache.org/docs/select-statements/
The following works for me without
Hi,
I have this simple data in a Mongo database.
{"_id":{"$oid":"56a784b76952647b7b51c562"},"provenance":{"image":{"case_id":100,"subject_id":"TCGA"}}}
When I run
*SELECT camic.provenance.image.case_id caseidFROM mongo.users.`contacts2`
camic*
I get the below.
+-+
| caseid |