{
  "calcite_plan": {
    "error_view": {
      "rels": [
        {
          "id": 0,
          "inputs": [],
          "relOp": "LogicalTableScan",
          "table": [
            "schema",
            "error_table"
          ]
        }
      ]
    },
    "example_count": {
      "rels": [
        {
          "id": 1,
          "inputs": [],
          "relOp": "LogicalTableScan",
          "table": [
            "schema",
            "example"
          ]
        },
        {
          "aggs": [
            {
              "agg": {
                "kind": "COUNT",
                "name": "COUNT",
                "syntax": "FUNCTION_STAR"
              },
              "distinct": false,
              "name": "num_rows2",
              "operands": [],
              "type": {
                "nullable": false,
                "type": "BIGINT"
              }
            }
          ],
          "group": [],
          "id": 2,
          "inputs": [
            1
          ],
          "relOp": "LogicalAggregate"
        },
        {
          "exprs": [
            {
              "input": 0,
              "name": "$0"
            },
            {
              "input": 0,
              "name": "$0"
            }
          ],
          "fields": [
            "num_rows",
            "num_rows2"
          ],
          "id": 3,
          "inputs": [
            2
          ],
          "relOp": "LogicalProject"
        }
      ]
    }
  },
  "mir": {
    "s0": {
      "calcite": {
        "partial": 0
      },
      "inputs": [],
      "operation": "constant",
      "persistent_id": "8b384059bdb44ad811ab341cc5e2a59697f39aac7b463cab027b185db8105e73",
      "positions": []
    },
    "s1": {
      "calcite": {
        "partial": 2
      },
      "inputs": [],
      "operation": "constant",
      "persistent_id": "0e1f0010d6ada346e808391a5a145ece6de3c96126dcbf4689e8ad2b23bf17de",
      "positions": []
    },
    "s10": {
      "calcite": {
        "partial": 2
      },
      "inputs": [
        {
          "node": "s9",
          "output": 0
        }
      ],
      "operation": "neg",
      "persistent_id": "9621310c52048b0585b4923a5b1559ecd1cee511e1a77e2bfee5547c38a8c1ea",
      "positions": []
    },
    "s11": {
      "calcite": {
        "partial": 2
      },
      "inputs": [
        {
          "node": "s3",
          "output": 0
        },
        {
          "node": "s10",
          "output": 0
        },
        {
          "node": "s8",
          "output": 0
        }
      ],
      "operation": "sum",
      "persistent_id": "3a7521c2ef22fb57b423c46abcb1ebf63e9e6d1a265ec89fa6f9742063435726",
      "positions": []
    },
    "s12": {
      "calcite": {
        "final": 3
      },
      "inputs": [
        {
          "node": "s11",
          "output": 0
        }
      ],
      "operation": "inspect",
      "persistent_id": "f991b4f48d5cae5139580f62560561dbb52b3918a7932974e5b641e77c74ee8f",
      "positions": []
    },
    "s13": {
      "calcite": {
        "final": 0
      },
      "inputs": [
        {
          "node": "s0",
          "output": 0
        }
      ],
      "operation": "inspect",
      "persistent_id": "933ebf782e1fe804fe85c4d0f3688bdb5234b386c2834892776e692acd9781d9",
      "positions": []
    },
    "s2": {
      "calcite": {
        "final": 3
      },
      "inputs": [
        {
          "node": "s1",
          "output": 0
        }
      ],
      "operation": "map",
      "persistent_id": "5092aef4c6d747ac4f2695dccf17ec9f8123d57b384baeda898ff4baf9b36d3d",
      "positions": []
    },
    "s3": {
      "calcite": {
        "partial": 2
      },
      "inputs": [
        {
          "node": "s2",
          "output": 0
        }
      ],
      "operation": "differentiate",
      "persistent_id": "b845bafa9786e8c09528e433734d53fcba0188a2bc1b402bdc657eda963d3049",
      "positions": []
    },
    "s4": {
      "calcite": {
        "final": 1
      },
      "inputs": [],
      "operation": "source_map",
      "persistent_id": "d094b3bf2096aedf4f7298a0d9bb7bcacd40dbe5183a78d7a21dbabbeb46bd17",
      "positions": [],
      "table": "example"
    },
    "s5": {
      "calcite": {
        "partial": 2
      },
      "inputs": [
        {
          "node": "s4",
          "output": 0
        }
      ],
      "operation": "flat_map_index",
      "persistent_id": "f76cdcfb10a6e1490bfeee45484a0c78998e5519c4e80f499a04b3c009310a9b",
      "positions": [
        {
          "end_column": 170,
          "end_line_number": 1,
          "start_column": 1,
          "start_line_number": 1
        }
      ]
    },
    "s6": {
      "calcite": {
        "partial": 2
      },
      "inputs": [
        {
          "node": "s5",
          "output": 0
        }
      ],
      "operation": "aggregate_linear_postprocess",
      "persistent_id": "d164bba37faaa89df19859b6f7e5355c758f265b6c5db8b4f400c671f664d895",
      "positions": []
    },
    "s7": {
      "calcite": {
        "partial": 2
      },
      "inputs": [
        {
          "node": "s6",
          "output": 0
        }
      ],
      "operation": "map",
      "persistent_id": "a92066ef32a213ddba420eebacb12b3bef34de39a4cc4affb06eb7f480f67f4a",
      "positions": []
    },
    "s8": {
      "calcite": {
        "final": 3
      },
      "inputs": [
        {
          "node": "s7",
          "output": 0
        }
      ],
      "operation": "map",
      "persistent_id": "8d1a6e92c7741adf0876a56dec393f8ae5f2fc941882e99dff7dc30dac46849a",
      "positions": []
    },
    "s9": {
      "calcite": {
        "partial": 2
      },
      "inputs": [
        {
          "node": "s7",
          "output": 0
        }
      ],
      "operation": "map",
      "persistent_id": "2e1f19e57378fa08757c3ede2e5da64450fdf68acc952ccb263d68cb71ad62cc",
      "positions": []
    }
  }
}
