342 was closed in 0.9.0 because we realized it was a duplicate, not because it was fixed.
Since 194 is still open it is fair to say that Calcite does not at this point support MongoDB array items. It would be great if someone fixed that bug. Julian > On May 11, 2016, at 1:22 PM, Hemant Saxena <[email protected]> wrote: > > Hello, > > Are MongoDB array items supported by Calcite? > > I see two duplicate issues related to it: > https://issues.apache.org/jira/browse/CALCITE-194 > https://issues.apache.org/jira/browse/CALCITE-342 > > 194 is open and 342 is closed saying "resolved in release > 0.9.0-incubating", I am a bit confused here. > > Also, when I used the test VM from calcite-test-dataset and issued the > following query on sqline (using > mongodb/target/test-classes/mongo-zips-model.json) > >> select * from zips limit 3; > > I see Longitude and Latitude values as null: > > +----------------------+-----------------+-----------------+------------+-------+-------+ > | CITY | LONGITUDE | LATITUDE | POP | > STATE | ID | > +----------------------+-----------------+-----------------+------------+-------+-------+ > | AGAWAM | null | null | 15338 | > MA | 01001 | > | CUSHMAN | null | null | 36963 | > MA | 01002 | > | BARRE | null | null | 4546 | > MA | 01005 | > +----------------------+-----------------+-----------------+------------+-------+-------+ > > Can someone confirm if the MongoDB array items are supported? > > Thanks, > Hemant
