Uploaded image for project: 'Apache Drill'
  1. Apache Drill
  2. DRILL-5269

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

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Critical
    • Resolution: Fixed
    • Affects Version/s: 1.9.0
    • Fix Version/s: 1.12.0
    • Component/s: None
    • Labels:
      None

      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
      

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                vrozov Vlad Rozov
                Reporter:
                amosaad Anas
                Reviewer:
                Aman Sinha
              • Votes:
                1 Vote for this issue
                Watchers:
                5 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: