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

["Gaopeng (JIRA)" <ji...@apache.org>]

Gaopeng created OPTIQ-342:
-----------------------------

             Summary: 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


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)