[DRILL-5269] SYSTEM ERROR: JsonMappingException: No suitable constructor found for type [simple type, class org.apache.drill.exec.store.direct.DirectSubScan]

• Type: Bug
• Status: Resolved
• Priority: Critical
• Resolution: Fixed
• Affects Version/s: 1.9.0
• Fix Version/s: 1.12.0
• Assignee: Vlad Rozov
• Reporter: Anas
• Reviewer: Aman Sinha
• Created: 16/Feb/17 13:09
• Updated: 15/Sep/17 05:45
• Resolved: 15/Sep/17 05:45

Description

I am a query that has nested joins. The query fails with the following exception.

SYSTEM ERROR: JsonMappingException: No suitable constructor found for type [simple type, class org.apache.drill.exec.store.direct.DirectSubScan]: can not instantiate from JSON object (missing default constructor or creator, or perhaps need to add/enable type information?)
 at [Source: {
  "pop" : "broadcast-sender",
  "@id" : 0,
  "receiver-major-fragment" : 1,
  "child" : {
    "pop" : "selection-vector-remover",
    "@id" : 1,
    "child" : {
      "pop" : "filter",
      "@id" : 2,
      "child" : {
        "pop" : "project",
        "@id" : 3,
        "exprs" : [ {
          "ref" : "`__measure__10`",
          "expr" : "`count`"
        } ],
        "child" : {
          "pop" : "DirectSubScan",
          "@id" : 4,
          "initialAllocation" : 1000000,
          "maxAllocation" : 10000000000,
          "reader" : [ {
            "count" : 633
          } ],
          "cost" : 0.0
        },
        "initialAllocation" : 1000000,
        "maxAllocation" : 10000000000,
        "cost" : 20.0
      },
      "expr" : "greater_than(`__measure__10`, 0) ",
      "initialAllocation" : 1000000,
      "maxAllocation" : 10000000000,
      "cost" : 10.0
    },
    "initialAllocation" : 1000000,
    "maxAllocation" : 10000000000,
    "cost" : 10.0
  },
  "destinations" : [ {
    "minorFragmentId" : 0,
    "endpoint" : "Cg0xOTIuMTY4LjAuMTAwEKLyARij8gEgpPIB"
  }, {
    "minorFragmentId" : 1,
    "endpoint" : "Cg0xOTIuMTY4LjAuMTAwEKLyARij8gEgpPIB"
  } ],
  "initialAllocation" : 1000000,
  "maxAllocation" : 10000000000,
  "cost" : 10.0
}; line: 20, column: 11] (through reference chain: org.apache.drill.exec.physical.config.BroadcastSender["child"]->org.apache.drill.exec.physical.config.SelectionVectorRemover["child"]->org.apache.drill.exec.physical.config.Filter["child"]->org.apache.drill.exec.physical.config.Project["child"])

Fragment 3:0

[Error Id: 9fb4ef4a-f118-4625-94f5-56c96dc7bdb4 on 192.168.0.100:31010]

  (com.fasterxml.jackson.databind.JsonMappingException) No suitable constructor found for type [simple type, class org.apache.drill.exec.store.direct.DirectSubScan]: can not instantiate from JSON object (missing default constructor or creator, or perhaps need to add/enable type information?)
 at [Source: {
  "pop" : "broadcast-sender",
  "@id" : 0,
  "receiver-major-fragment" : 1,
  "child" : {
    "pop" : "selection-vector-remover",
    "@id" : 1,
    "child" : {
      "pop" : "filter",
      "@id" : 2,
      "child" : {
        "pop" : "project",
        "@id" : 3,
        "exprs" : [ {
          "ref" : "`__measure__10`",
          "expr" : "`count`"
        } ],
        "child" : {
          "pop" : "DirectSubScan",
          "@id" : 4,
          "initialAllocation" : 1000000,
          "maxAllocation" : 10000000000,
          "reader" : [ {
            "count" : 633
          } ],
          "cost" : 0.0
        },
        "initialAllocation" : 1000000,
        "maxAllocation" : 10000000000,
        "cost" : 20.0
      },
      "expr" : "greater_than(`__measure__10`, 0) ",
      "initialAllocation" : 1000000,
      "maxAllocation" : 10000000000,
      "cost" : 10.0
    },
    "initialAllocation" : 1000000,
    "maxAllocation" : 10000000000,
    "cost" : 10.0
  },
  "destinations" : [ {
    "minorFragmentId" : 0,
    "endpoint" : "Cg0xOTIuMTY4LjAuMTAwEKLyARij8gEgpPIB"
  }, {
    "minorFragmentId" : 1,
    "endpoint" : "Cg0xOTIuMTY4LjAuMTAwEKLyARij8gEgpPIB"
  } ],
  "initialAllocation" : 1000000,
  "maxAllocation" : 10000000000,
  "cost" : 10.0
}; line: 20, column: 11] (through reference chain: org.apache.drill.exec.physical.config.BroadcastSender["child"]->org.apache.drill.exec.physical.config.SelectionVectorRemover["child"]->org.apache.drill.exec.physical.config.Filter["child"]->org.apache.drill.exec.physical.config.Project["child"])
    com.fasterxml.jackson.databind.JsonMappingException.from():216
    com.fasterxml.jackson.databind.deser.BeanDeserializerBase.deserializeFromObjectUsingNonDefault():1130
    com.fasterxml.jackson.databind.deser.BeanDeserializer.deserializeFromObject():298
    com.fasterxml.jackson.databind.deser.BeanDeserializerBase.deserializeWithObjectId():1094
    com.fasterxml.jackson.databind.deser.BeanDeserializer._deserializeOther():166
    com.fasterxml.jackson.databind.deser.BeanDeserializer.deserialize():135
    com.fasterxml.jackson.databind.jsontype.impl.AsPropertyTypeDeserializer._deserializeTypedForId():120
    com.fasterxml.jackson.databind.jsontype.impl.AsPropertyTypeDeserializer.deserializeTypedFromObject():91
    com.fasterxml.jackson.databind.deser.AbstractDeserializer.deserializeWithType():142
    com.fasterxml.jackson.databind.deser.SettableBeanProperty.deserialize():488
    com.fasterxml.jackson.databind.deser.BeanDeserializer._deserializeWithErrorWrapping():465
    com.fasterxml.jackson.databind.deser.BeanDeserializer._deserializeUsingPropertyBased():380
    com.fasterxml.jackson.databind.deser.BeanDeserializerBase.deserializeFromObjectUsingNonDefault():1123
    com.fasterxml.jackson.databind.deser.BeanDeserializer.deserializeFromObject():298
    com.fasterxml.jackson.databind.deser.BeanDeserializerBase.deserializeWithObjectId():1094
    com.fasterxml.jackson.databind.deser.BeanDeserializer._deserializeOther():166
    com.fasterxml.jackson.databind.deser.BeanDeserializer.deserialize():135
    com.fasterxml.jackson.databind.jsontype.impl.AsPropertyTypeDeserializer._deserializeTypedForId():120
    com.fasterxml.jackson.databind.jsontype.impl.AsPropertyTypeDeserializer.deserializeTypedFromObject():91
    com.fasterxml.jackson.databind.deser.AbstractDeserializer.deserializeWithType():142
    com.fasterxml.jackson.databind.deser.SettableBeanProperty.deserialize():488
    com.fasterxml.jackson.databind.deser.BeanDeserializer._deserializeWithErrorWrapping():465
    com.fasterxml.jackson.databind.deser.BeanDeserializer._deserializeUsingPropertyBased():380
    com.fasterxml.jackson.databind.deser.BeanDeserializerBase.deserializeFromObjectUsingNonDefault():1123
    com.fasterxml.jackson.databind.deser.BeanDeserializer.deserializeFromObject():298
    com.fasterxml.jackson.databind.deser.BeanDeserializerBase.deserializeWithObjectId():1094
    com.fasterxml.jackson.databind.deser.BeanDeserializer._deserializeOther():166
    com.fasterxml.jackson.databind.deser.BeanDeserializer.deserialize():135
    com.fasterxml.jackson.databind.jsontype.impl.AsPropertyTypeDeserializer._deserializeTypedForId():120
    com.fasterxml.jackson.databind.jsontype.impl.AsPropertyTypeDeserializer.deserializeTypedFromObject():91
    com.fasterxml.jackson.databind.deser.AbstractDeserializer.deserializeWithType():142
    com.fasterxml.jackson.databind.deser.SettableBeanProperty.deserialize():488
    com.fasterxml.jackson.databind.deser.BeanDeserializer._deserializeWithErrorWrapping():465
    com.fasterxml.jackson.databind.deser.BeanDeserializer._deserializeUsingPropertyBased():380
    com.fasterxml.jackson.databind.deser.BeanDeserializerBase.deserializeFromObjectUsingNonDefault():1123
    com.fasterxml.jackson.databind.deser.BeanDeserializer.deserializeFromObject():298
    com.fasterxml.jackson.databind.deser.BeanDeserializerBase.deserializeWithObjectId():1094
    com.fasterxml.jackson.databind.deser.BeanDeserializer._deserializeOther():166
    com.fasterxml.jackson.databind.deser.BeanDeserializer.deserialize():135
    com.fasterxml.jackson.databind.jsontype.impl.AsPropertyTypeDeserializer._deserializeTypedForId():120
    com.fasterxml.jackson.databind.jsontype.impl.AsPropertyTypeDeserializer.deserializeTypedFromObject():91
    com.fasterxml.jackson.databind.deser.AbstractDeserializer.deserializeWithType():142
    com.fasterxml.jackson.databind.deser.SettableBeanProperty.deserialize():488
    com.fasterxml.jackson.databind.deser.BeanDeserializer._deserializeWithErrorWrapping():465
    com.fasterxml.jackson.databind.deser.BeanDeserializer._deserializeUsingPropertyBased():380
    com.fasterxml.jackson.databind.deser.BeanDeserializerBase.deserializeFromObjectUsingNonDefault():1123
    com.fasterxml.jackson.databind.deser.BeanDeserializer.deserializeFromObject():298
    com.fasterxml.jackson.databind.deser.BeanDeserializerBase.deserializeWithObjectId():1094
    com.fasterxml.jackson.databind.deser.BeanDeserializer._deserializeOther():166
    com.fasterxml.jackson.databind.deser.BeanDeserializer.deserialize():135
    com.fasterxml.jackson.databind.jsontype.impl.AsPropertyTypeDeserializer._deserializeTypedForId():120
    com.fasterxml.jackson.databind.jsontype.impl.AsPropertyTypeDeserializer.deserializeTypedFromObject():91
    com.fasterxml.jackson.databind.deser.AbstractDeserializer.deserializeWithType():142
    com.fasterxml.jackson.databind.deser.impl.TypeWrappedDeserializer.deserialize():42
    com.fasterxml.jackson.databind.ObjectReader._bindAndClose():1575
    com.fasterxml.jackson.databind.ObjectReader.readValue():1200
    org.apache.drill.exec.planner.PhysicalPlanReader.readFragmentOperator():94
    org.apache.drill.exec.work.fragment.FragmentExecutor.run():203
    org.apache.drill.common.SelfCleaningRunnable.run():38
    java.util.concurrent.ThreadPoolExecutor.runWorker():1142
    java.util.concurrent.ThreadPoolExecutor$Worker.run():617
    java.lang.Thread.run():745

Issue Links

• relates to: DRILL-5784 SYSTEM ERROR: IndexOutOfBoundsException: index: 512, length: 4 (expected: range(0, 512))
• links to: GitHub Pull Request #926