[CALCITE-342] optiq-mongodb examples can't display latitude and longitude

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Duplicate
• Fix Version/s: 0.9.0-incubating

Environment

linux x64
mongodb-linux-x86_64-2.2.0

• Assignee: Julian Hyde
• Reporter: Gaopeng
• Created: 11/Jul/14 10:41
• Updated: 25/Aug/14 19:10
• Resolved: 11/Jul/14 19:50

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)

Issue Links

• duplicates: CALCITE-194 Array items in MongoDB adapter