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

Fix ser / de for sys and information_schema tables

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 1.16.0
    • Fix Version/s: 1.17.0
    • Component/s: None
    • Labels:

      Description

      Run query on INFORMATION_SCHEMA:

      select * from information_schema.`tables` where TABLE_NAME='lineitem' order by TABLE_NAME;
      

      It will fail with the following exception:

      Error: SYSTEM ERROR: InvalidDefinitionException: Cannot construct instance of `org.apache.drill.exec.store.ischema.InfoSchemaFilter$ExprNode` (no Creators, like default construct, exist): cannot deserialize from Object value (no delegate- or property-based Creator)
       at [Source: (String)"{
        "pop" : "hash-partition-sender",
        "@id" : 0,
        "receiver-major-fragment" : 2,
        "child" : {
          "pop" : "InfoSchemaSubScan",
          "@id" : 1,
          "table" : "TABLES",
          "filter" : {
            "exprRoot" : {
              "type" : "FUNCTION",
              "function" : "equal",
              "args" : [ {
                "type" : "FIELD",
                "field" : "TABLE_NAME"
              }, {
                "type" : "CONSTANT",
                "value" : "lineitem"
              } ]
            }
          },
          "initialAllocation" : 1000000,
          "maxAllocat"[truncated 681 chars]; line: 11, column: 9] (through reference chain: org.apache.drill.exec.physical.config.HashPartitionSender["child"]->org.apache.drill.exec.store.ischema.InfoSchemaSubScan["filter"]->org.apache.drill.exec.store.ischema.InfoSchemaFilter["exprRoot"])
      
      

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                arina Arina Ielchiieva
                Reporter:
                volodymyr Vova Vysotskyi
                Reviewer:
                Vova Vysotskyi
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: