Uploaded image for project: 'Teiid'
  1. Teiid
  2. TEIID-3348

MongoDB: Teiid 8.10 CR are not compatible with MongoDB 2.4.8

    XMLWordPrintable

Details

    • Bug
    • Resolution: Done
    • Major
    • 8.10
    • 8.10
    • Misc. Connectors
    • Hide

      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.

      Show
      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.

    Description

      I am not able to run any query with with Teiid 8.10 CR1 against MongoDB version 2.4.8. But it works for MongoDB version 2.6.6

      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)

      Attachments

        Activity

          People

            rhn-engineering-rareddy Ramesh Reddy
            mchantibco Ivan Chan (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: