[DRILL-7472] Fix ser / de for sys and information_schema tables

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.16.0
• Fix Version/s: 1.17.0
• Labels: ready-to-commit
• Assignee: Arina Ielchiieva
• Reporter: Vova Vysotskyi
• Reviewer: Vova Vysotskyi
• Created: 06/Dec/19 20:18
• Updated: 17/Dec/19 12:54
• Resolved: 17/Dec/19 12:54

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"])

Issue Links

• links to: GitHub Pull Request #1925