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

Reply via email to