{ "operator": "distribute-result", "expressions": [ "$$44" ], "operatorId": "1.1", "runtime-id": "ODID:8", "physical-operator": "DISTRIBUTE_RESULT", "execution-mode": "UNPARTITIONED", "optimizer-estimates": { "cardinality": 112.71, "op-cost": 0, "total-cost": 488.82 }, "inputs": [ { "operator": "exchange", "operatorId": "1.2", "runtime-id": "CDID:13", "physical-operator": "ONE_TO_ONE_EXCHANGE", "execution-mode": "UNPARTITIONED", "optimizer-estimates": { "cardinality": 112.71, "op-cost": 0, "total-cost": 488.82 }, "inputs": [ { "operator": "project", "variables": [ "$$44" ], "operatorId": "1.3", "runtime-id": "ODID:12", "physical-operator": "STREAM_PROJECT", "execution-mode": "UNPARTITIONED", "optimizer-estimates": { "cardinality": 112.71, "op-cost": 0, "total-cost": 488.82 }, "inputs": [ { "operator": "assign", "variables": [ "$$44" ], "expressions": [ "{\"$1\": $$48}" ], "operatorId": "1.4", "runtime-id": "ODID:12", "physical-operator": "ASSIGN", "execution-mode": "UNPARTITIONED", "optimizer-estimates": { "cardinality": 112.71, "op-cost": 0, "total-cost": 488.82 }, "inputs": [ { "operator": "aggregate", "variables": [ "$$48" ], "expressions": [ "agg-sql-count($$42)" ], "operatorId": "1.5", "runtime-id": "ODID:12", "physical-operator": "AGGREGATE", "execution-mode": "UNPARTITIONED", "optimizer-estimates": { "cardinality": 112.71, "op-cost": 0, "total-cost": 488.82 }, "inputs": [ { "operator": "exchange", "operatorId": "1.6", "runtime-id": "CDID:12", "physical-operator": "SORT_MERGE_EXCHANGE [$$42(ASC) ]", "execution-mode": "PARTITIONED", "optimizer-estimates": { "cardinality": 112.71, "op-cost": 0, "total-cost": 488.82 }, "inputs": [ { "operator": "distinct", "expressions": [ "$$42" ], "operatorId": "1.7", "runtime-id": "ODID:7", "physical-operator": "PRE_SORTED_DISTINCT_BY", "execution-mode": "PARTITIONED", "optimizer-estimates": { "cardinality": 112.71, "op-cost": 0, "total-cost": 488.82 }, "inputs": [ { "operator": "exchange", "operatorId": "1.8", "runtime-id": "CDID:11", "physical-operator": "ONE_TO_ONE_EXCHANGE", "execution-mode": "PARTITIONED", "optimizer-estimates": { "cardinality": 112.71, "op-cost": 0, "total-cost": 488.82 }, "inputs": [ { "operator": "order", "order-by-list": [ { "order": "ASC", "expression": "$$42" } ], "operatorId": "1.9", "runtime-id": "ODID:6", "physical-operator": "STABLE_SORT [$$42(ASC)]", "execution-mode": "PARTITIONED", "optimizer-estimates": { "cardinality": 112.71, "op-cost": 0, "total-cost": 488.82 }, "inputs": [ { "operator": "exchange", "operatorId": "1.10", "runtime-id": "CDID:10", "physical-operator": "HASH_PARTITION_EXCHANGE [$$42]", "execution-mode": "PARTITIONED", "optimizer-estimates": { "cardinality": 112.71, "op-cost": 0, "total-cost": 488.82 }, "inputs": [ { "operator": "project", "variables": [ "$$42" ], "operatorId": "1.11", "runtime-id": "ODID:11", "physical-operator": "STREAM_PROJECT", "execution-mode": "PARTITIONED", "optimizer-estimates": { "cardinality": 112.71, "op-cost": 0, "total-cost": 488.82 }, "inputs": [ { "operator": "select", "condition": "and(eq($$c.getField(\"a\"), 1), le($$45, 200), ge($$45, 100))", "operatorId": "1.12", "runtime-id": "ODID:11", "physical-operator": "STREAM_SELECT", "execution-mode": "PARTITIONED", "optimizer-estimates": { "cardinality": 112.71, "op-cost": 0, "total-cost": 488.82 }, "inputs": [ { "operator": "assign", "variables": [ "$$45", "$$42" ], "expressions": [ "$$c.getField(\"b\")", "$$c.getField(\"uuid\")" ], "operatorId": "1.13", "runtime-id": "ODID:11", "physical-operator": "ASSIGN", "execution-mode": "PARTITIONED", "optimizer-estimates": { "cardinality": 112.71, "op-cost": 0, "total-cost": 488.82 }, "inputs": [ { "operator": "project", "variables": [ "$$c" ], "operatorId": "1.14", "runtime-id": "ODID:11", "physical-operator": "STREAM_PROJECT", "execution-mode": "PARTITIONED", "optimizer-estimates": { "cardinality": 112.71, "op-cost": 0, "total-cost": 488.82 }, "inputs": [ { "operator": "exchange", "operatorId": "1.15", "runtime-id": "CDID:9", "physical-operator": "ONE_TO_ONE_EXCHANGE", "execution-mode": "PARTITIONED", "optimizer-estimates": { "cardinality": 112.71, "op-cost": 0, "total-cost": 488.82 }, "inputs": [ { "operator": "unnest-map", "variables": [ "$$46", "$$c", "$$47" ], "expressions": [ "index-search(\"c\", 0, \"b1/s\", \"c\", false, false, 1, $$62, 1, $$62, true, true, true)" ], "operatorId": "1.16", "runtime-id": "ODID:5", "physical-operator": "BTREE_SEARCH", "execution-mode": "PARTITIONED", "optimizer-estimates": { "cardinality": 112.71, "op-cost": 488.82, "total-cost": 488.82 }, "inputs": [ { "operator": "exchange", "operatorId": "1.17", "runtime-id": "CDID:8", "physical-operator": "ONE_TO_ONE_EXCHANGE", "execution-mode": "PARTITIONED", "optimizer-estimates": { "cardinality": 0, "op-cost": 0, "total-cost": 0 }, "inputs": [ { "operator": "intersect", "output-compare-variables": [ "$$62" ], "input-compare-variables": [ "$$54", "$$61" ], "operatorId": "1.18", "runtime-id": "ODID:4", "physical-operator": "INTERSECT", "execution-mode": "PARTITIONED", "optimizer-estimates": { "cardinality": 0, "op-cost": 0, "total-cost": 0 }, "inputs": [ { "operator": "exchange", "operatorId": "1.19", "runtime-id": "CDID:3", "physical-operator": "ONE_TO_ONE_EXCHANGE", "execution-mode": "PARTITIONED", "optimizer-estimates": { "cardinality": 0, "op-cost": 0, "total-cost": 0 }, "inputs": [ { "operator": "order", "order-by-list": [ { "order": "ASC", "expression": "$$54" } ], "operatorId": "1.20", "runtime-id": "ODID:1", "physical-operator": "STABLE_SORT [$$54(ASC)]", "execution-mode": "PARTITIONED", "optimizer-estimates": { "cardinality": 0, "op-cost": 0, "total-cost": 0 }, "inputs": [ { "operator": "exchange", "operatorId": "1.21", "runtime-id": "CDID:2", "physical-operator": "ONE_TO_ONE_EXCHANGE", "execution-mode": "PARTITIONED", "optimizer-estimates": { "cardinality": 0, "op-cost": 0, "total-cost": 0 }, "inputs": [ { "operator": "project", "variables": [ "$$54" ], "operatorId": "1.22", "runtime-id": "ODID:14", "physical-operator": "STREAM_PROJECT", "execution-mode": "PARTITIONED", "optimizer-estimates": { "cardinality": 0, "op-cost": 0, "total-cost": 0 }, "inputs": [ { "operator": "exchange", "operatorId": "1.23", "runtime-id": "CDID:1", "physical-operator": "ONE_TO_ONE_EXCHANGE", "execution-mode": "PARTITIONED", "optimizer-estimates": { "cardinality": 0, "op-cost": 0, "total-cost": 0 }, "inputs": [ { "operator": "unnest-map", "variables": [ "$$53", "$$54" ], "expressions": [ "index-search(\"ic1a\", 0, \"b1/s\", \"c\", false, false, 1, $$51, 1, $$52, true, true, true)" ], "operatorId": "1.24", "runtime-id": "ODID:0", "physical-operator": "BTREE_SEARCH", "execution-mode": "PARTITIONED", "optimizer-estimates": { "cardinality": 0, "op-cost": 0, "total-cost": 0 }, "inputs": [ { "operator": "exchange", "operatorId": "1.25", "runtime-id": "CDID:0", "physical-operator": "ONE_TO_ONE_EXCHANGE", "execution-mode": "PARTITIONED", "optimizer-estimates": { "cardinality": 0, "op-cost": 0, "total-cost": 0 }, "inputs": [ { "operator": "assign", "variables": [ "$$51", "$$52" ], "expressions": [ "1", "1" ], "operatorId": "1.26", "runtime-id": "ODID:10", "physical-operator": "ASSIGN", "execution-mode": "PARTITIONED", "optimizer-estimates": { "cardinality": 0, "op-cost": 0, "total-cost": 0 }, "inputs": [ { "operator": "empty-tuple-source", "operatorId": "1.27", "runtime-id": "ODID:10", "physical-operator": "EMPTY_TUPLE_SOURCE", "execution-mode": "PARTITIONED", "optimizer-estimates": { "cardinality": 0, "op-cost": 0, "total-cost": 0 } } ] } ] } ] } ] } ] } ] } ] } ] }, { "operator": "exchange", "operatorId": "1.28", "runtime-id": "CDID:7", "physical-operator": "ONE_TO_ONE_EXCHANGE", "execution-mode": "PARTITIONED", "optimizer-estimates": { "cardinality": 0, "op-cost": 0, "total-cost": 0 }, "inputs": [ { "operator": "order", "order-by-list": [ { "order": "ASC", "expression": "$$61" } ], "operatorId": "1.29", "runtime-id": "ODID:3", "physical-operator": "STABLE_SORT [$$61(ASC)]", "execution-mode": "PARTITIONED", "optimizer-estimates": { "cardinality": 0, "op-cost": 0, "total-cost": 0 }, "inputs": [ { "operator": "exchange", "operatorId": "1.30", "runtime-id": "CDID:6", "physical-operator": "ONE_TO_ONE_EXCHANGE", "execution-mode": "PARTITIONED", "optimizer-estimates": { "cardinality": 0, "op-cost": 0, "total-cost": 0 }, "inputs": [ { "operator": "project", "variables": [ "$$61" ], "operatorId": "1.31", "runtime-id": "ODID:9", "physical-operator": "STREAM_PROJECT", "execution-mode": "PARTITIONED", "optimizer-estimates": { "cardinality": 0, "op-cost": 0, "total-cost": 0 }, "inputs": [ { "operator": "exchange", "operatorId": "1.32", "runtime-id": "CDID:5", "physical-operator": "ONE_TO_ONE_EXCHANGE", "execution-mode": "PARTITIONED", "optimizer-estimates": { "cardinality": 0, "op-cost": 0, "total-cost": 0 }, "inputs": [ { "operator": "unnest-map", "variables": [ "$$59", "$$60", "$$61" ], "expressions": [ "index-search(\"ic1b\", 0, \"b1/s\", \"c\", false, false, 2, $$55, $$56, 2, $$57, $$58, true, true, true)" ], "operatorId": "1.33", "runtime-id": "ODID:2", "physical-operator": "BTREE_SEARCH", "execution-mode": "PARTITIONED", "optimizer-estimates": { "cardinality": 0, "op-cost": 0, "total-cost": 0 }, "inputs": [ { "operator": "exchange", "operatorId": "1.34", "runtime-id": "CDID:4", "physical-operator": "ONE_TO_ONE_EXCHANGE", "execution-mode": "PARTITIONED", "optimizer-estimates": { "cardinality": 0, "op-cost": 0, "total-cost": 0 }, "inputs": [ { "operator": "assign", "variables": [ "$$55", "$$56", "$$57", "$$58" ], "expressions": [ "1", "100", "1", "200" ], "operatorId": "1.35", "runtime-id": "ODID:13", "physical-operator": "ASSIGN", "execution-mode": "PARTITIONED", "optimizer-estimates": { "cardinality": 0, "op-cost": 0, "total-cost": 0 }, "inputs": [ { "operator": "empty-tuple-source", "operatorId": "1.36", "runtime-id": "ODID:13", "physical-operator": "EMPTY_TUPLE_SOURCE", "execution-mode": "PARTITIONED", "optimizer-estimates": { "cardinality": 0, "op-cost": 0, "total-cost": 0 } } ] } ] } ] } ] } ] } ] } ] } ] } ] } ] } ] } ] } ] } ] } ] } ] } ] } ] } ] } ] } ] } ] } ] } ] } ] } ] }