Uploaded image for project: 'Calcite'
  1. Calcite
  2. CALCITE-342

optiq-mongodb examples can't display latitude and longitude

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Duplicate
    • Affects Version/s: None
    • Fix Version/s: 0.9.0-incubating
    • Component/s: None
    • Labels:
      None
    • Environment:

      linux x64
      mongodb-linux-x86_64-2.2.0

      Description

      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)

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                julianhyde Julian Hyde
                Reporter:
                gpstrive Gaopeng
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: