Hi Adam,
Are you trying apply filter using _id?. If so, Mongo storage plugin
supports it.
0: jdbc:drill:zk=localhost:2181> select * from mongo.usda.`zips` where _id
= '01077';
+------------+
| * |
+------------+
| { "city" : "SOUTHWICK" , "loc" : [ -72.770588 , 42.051099] , "pop" : 7667
, "state" : "MA"} |
+------------+
1 row selected (4.792 seconds)
On Mon, Jan 5, 2015 at 1:45 PM, Adam Gilmore <[email protected]> wrote:
> Hi all,
>
> I'm trying to work out how to filter by an objectId field using the Mongo
> plugin. I've tried many combinations of = '{$oid: ''id''}' etc. but
> nothing seems to work.
>
> Is this implemented yet? If not, is there a JIRA item for it already?
>
--
Kamesh.
