JSON Data : { "_id": { "$oid" : "52d7945f4acacbbae9c86304" } , "id": "fDxEleBZwLDLmIQH", "store_sales": 7.44, "product_category": "Jams and Jellies", "product_department": "Baking Goods", "product_family": "Food", "product_subcategory": "Jam", "store_city": "Los Angeles", "store_cost": 2.976, "store_country": "USA", "store_state": "CA", "the_date": "09/09/2012 0:00 -07:00", "unit_sales": 4 } Schema: CREATE FOREIGN TABLE sales ( saleID integer PRIMARY KEY, product_category varchar(255), product_family varchar(255), store_city varchar(255)) OPTIONS(UPDATABLE 'TRUE'); SQL: select "store_city" from "MongoDB_26"."sales" limit 1000 Result for MongoDB 2.4.8: Caused by: java.lang.NullPointerException at org.teiid.translator.mongodb.MongoDBQueryExecution.close(MongoDBQueryExecution.java:144) at org.teiid.translator.mongodb.MongoDBQueryExecution.cancel(MongoDBQueryExecution.java:150) at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.cancel(ConnectorWorkItem.java:191) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:601) at org.teiid.dqp.internal.datamgr.ConnectorManager$1.invoke(ConnectorManager.java:209) at $Proxy183.cancel(Unknown Source) at org.teiid.dqp.internal.process.DataTierTupleSource.fullyCloseSource(DataTierTupleSource.java:323) at org.teiid.dqp.internal.process.DataTierTupleSource.exceptionOccurred(DataTierTupleSource.java:378) at org.teiid.dqp.internal.process.DataTierTupleSource.nextTuple(DataTierTupleSource.java:154) at org.teiid.query.processor.relational.AccessNode.nextBatchDirect(AccessNode.java:369) at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:278) at org.teiid.query.processor.relational.RelationalPlan.nextBatch(RelationalPlan.java:145) at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:151) at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:114) at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:164) Result for MongoDB 2.6.6: works OK.