You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@calcite.apache.org by "Julian Hyde (JIRA)" <ji...@apache.org> on 2014/08/25 21:11:00 UTC

[jira] [Closed] (OPTIQ-342) optiq-mongodb examples can't display latitude and longitude

     [ https://issues.apache.org/jira/browse/OPTIQ-342?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Julian Hyde closed OPTIQ-342.
-----------------------------


Close issues resolved in release 0.9.0-incubating (2014-08-25).

> optiq-mongodb examples can't display latitude and longitude 
> ------------------------------------------------------------
>
>                 Key: OPTIQ-342
>                 URL: https://issues.apache.org/jira/browse/OPTIQ-342
>             Project: Optiq
>          Issue Type: Bug
>         Environment: linux x64
> mongodb-linux-x86_64-2.2.0
>            Reporter: Gaopeng
>            Assignee: Julian Hyde
>             Fix For: 0.9.0-incubating
>
>
> I followed the instructions on https://github.com/julianhyde/optiq/blob/master/HOWTO.md. Everything is fine , but when i try to show all columns in zips , the result of latitude and longitude are NULL as below
> sqlline> !connect jdbc:optiq:model=mongodb/target/test-classes/mongo-zips-model.json admin admin
> 0: jdbc:optiq:model=mongodb/target/test-class> 
> 0: jdbc:optiq:model=mongodb/target/test-class> select * from zips limit 3;
> +----------------------+----------------------+-----------------+------------+-------+-------+
> |         CITY         |      LONGITUDE       |    LATITUDE     |    POP     | STATE |  ID   |
> +----------------------+----------------------+-----------------+------------+-------+-------+
> | AGAWAM               | null                 | null            | 15338      | MA    | 01001 |
> | CUSHMAN              | null                 | null            | 36963      | MA    | 01002 |
> | BARRE                | null                 | null            | 4546       | MA    | 01005 |
> +----------------------+----------------------+-----------------+------------+-------+-------+
> 3 rows selected (0.768 seconds)



--
This message was sent by Atlassian JIRA
(v6.2#6252)