{
    "Plan" : {
        "Plans" : [
            {
                "PlanNodeId" : 14,
                "Plans" : [
                    {
                        "PlanNodeId" : 13,
                        "Plans" : [
                            {
                                "PlanNodeId" : 12,
                                "Plans" : [
                                    {
                                        "PlanNodeId" : 11,
                                        "Plans" : [
                                            {
                                                "PlanNodeId" : 10,
                                                "Plans" : [
                                                    {
                                                        "PlanNodeId" : 9,
                                                        "Plans" : [
                                                            {
                                                                "PlanNodeId" : 8,
                                                                "Plans" : [
                                                                    {
                                                                        "Tables" : [
                                                                            "olap_yatests/tpch/s1/lineitem"
                                                                        ],
                                                                        "PlanNodeId" : 7,
                                                                        "Operators" : [
                                                                            {
                                                                                "Inputs" : [
                                                                                    {
                                                                                        "InternalOperatorId" : 1
                                                                                    }
                                                                                ],
                                                                                "E-Rows" : "3000607.5",
                                                                                "Predicate" : "l_shipdate > \"9204\"",
                                                                                "Pushdown" : "True",
                                                                                "Name" : "Filter",
                                                                                "E-Size" : "55408398",
                                                                                "E-Cost" : "0"
                                                                            },
                                                                            {
                                                                                "Scan" : "Parallel",
                                                                                "E-Size" : "110816796",
                                                                                "ReadRanges" : [
                                                                                    "l_orderkey (-∞, +∞)",
                                                                                    "l_linenumber (-∞, +∞)"
                                                                                ],
                                                                                "Name" : "TableFullScan",
                                                                                "Inputs" : [ ],
                                                                                "Path" : "/local/test_db/olap_yatests/tpch/s1/lineitem",
                                                                                "E-Rows" : "6001215",
                                                                                "Table" : "olap_yatests/tpch/s1/lineitem",
                                                                                "ReadColumns" : [
                                                                                    "l_discount",
                                                                                    "l_extendedprice",
                                                                                    "l_orderkey",
                                                                                    "l_shipdate"
                                                                                ],
                                                                                "SsaProgram" : {
                                                                                    "Command" : [
                                                                                        {
                                                                                            "Assign" : {
                                                                                                "Function" : {
                                                                                                    "KernelName" : "",
                                                                                                    "KernelIdx" : 0,
                                                                                                    "FunctionType" : 2,
                                                                                                    "Arguments" : [
                                                                                                        {
                                                                                                            "Id" : 12
                                                                                                        }
                                                                                                    ]
                                                                                                },
                                                                                                "Column" : {
                                                                                                    "Id" : 17
                                                                                                }
                                                                                            }
                                                                                        },
                                                                                        {
                                                                                            "Filter" : {
                                                                                                "Predicate" : {
                                                                                                    "Id" : 17
                                                                                                }
                                                                                            }
                                                                                        },
                                                                                        {
                                                                                            "Projection" : {
                                                                                                "Columns" : [
                                                                                                    {
                                                                                                        "Id" : 3
                                                                                                    },
                                                                                                    {
                                                                                                        "Id" : 4
                                                                                                    },
                                                                                                    {
                                                                                                        "Id" : 7
                                                                                                    }
                                                                                                ]
                                                                                            }
                                                                                        }
                                                                                    ]
                                                                                },
                                                                                "E-Cost" : "0"
                                                                            }
                                                                        ],
                                                                        "Node Type" : "Filter-TableFullScan"
                                                                    }
                                                                ],
                                                                "HashFunc" : "HashV1",
                                                                "Node Type" : "HashShuffle",
                                                                "KeyColumns" : [
                                                                    "l_orderkey"
                                                                ],
                                                                "PlanNodeType" : "Connection"
                                                            },
                                                            {
                                                                "PlanNodeId" : 6,
                                                                "Plans" : [
                                                                    {
                                                                        "Tables" : [
                                                                            "olap_yatests/tpch/s1/orders"
                                                                        ],
                                                                        "PlanNodeId" : 5,
                                                                        "Operators" : [
                                                                            {
                                                                                "Inputs" : [
                                                                                    {
                                                                                        "InternalOperatorId" : 1
                                                                                    }
                                                                                ],
                                                                                "E-Rows" : "750000",
                                                                                "Predicate" : "o_orderdate < \"9204\"",
                                                                                "Pushdown" : "True",
                                                                                "Name" : "Filter",
                                                                                "E-Size" : "20167804.44",
                                                                                "E-Cost" : "0"
                                                                            },
                                                                            {
                                                                                "Scan" : "Parallel",
                                                                                "E-Size" : "40335608.89",
                                                                                "ReadRanges" : [
                                                                                    "o_orderkey (-∞, +∞)"
                                                                                ],
                                                                                "Name" : "TableFullScan",
                                                                                "Inputs" : [ ],
                                                                                "Path" : "/local/test_db/olap_yatests/tpch/s1/orders",
                                                                                "E-Rows" : "1500000",
                                                                                "Table" : "olap_yatests/tpch/s1/orders",
                                                                                "ReadColumns" : [
                                                                                    "o_custkey",
                                                                                    "o_orderdate",
                                                                                    "o_orderkey",
                                                                                    "o_shippriority"
                                                                                ],
                                                                                "SsaProgram" : {
                                                                                    "Command" : [
                                                                                        {
                                                                                            "Assign" : {
                                                                                                "Function" : {
                                                                                                    "KernelName" : "",
                                                                                                    "KernelIdx" : 0,
                                                                                                    "FunctionType" : 2,
                                                                                                    "Arguments" : [
                                                                                                        {
                                                                                                            "Id" : 4
                                                                                                        }
                                                                                                    ]
                                                                                                },
                                                                                                "Column" : {
                                                                                                    "Id" : 10
                                                                                                }
                                                                                            }
                                                                                        },
                                                                                        {
                                                                                            "Filter" : {
                                                                                                "Predicate" : {
                                                                                                    "Id" : 10
                                                                                                }
                                                                                            }
                                                                                        },
                                                                                        {
                                                                                            "Projection" : {
                                                                                                "Columns" : [
                                                                                                    {
                                                                                                        "Id" : 3
                                                                                                    },
                                                                                                    {
                                                                                                        "Id" : 4
                                                                                                    },
                                                                                                    {
                                                                                                        "Id" : 5
                                                                                                    },
                                                                                                    {
                                                                                                        "Id" : 8
                                                                                                    }
                                                                                                ]
                                                                                            }
                                                                                        }
                                                                                    ]
                                                                                },
                                                                                "E-Cost" : "0"
                                                                            }
                                                                        ],
                                                                        "Node Type" : "Filter-TableFullScan"
                                                                    }
                                                                ],
                                                                "HashFunc" : "HashV1",
                                                                "Node Type" : "HashShuffle",
                                                                "KeyColumns" : [
                                                                    "o_orderkey"
                                                                ],
                                                                "PlanNodeType" : "Connection"
                                                            },
                                                            {
                                                                "PlanNodeId" : 4,
                                                                "Plans" : [
                                                                    {
                                                                        "PlanNodeId" : 3,
                                                                        "Plans" : [
                                                                            {
                                                                                "PlanNodeId" : 2,
                                                                                "Plans" : [
                                                                                    {
                                                                                        "Tables" : [
                                                                                            "olap_yatests/tpch/s1/customer"
                                                                                        ],
                                                                                        "PlanNodeId" : 1,
                                                                                        "Operators" : [
                                                                                            {
                                                                                                "Inputs" : [
                                                                                                    {
                                                                                                        "InternalOperatorId" : 1
                                                                                                    }
                                                                                                ],
                                                                                                "E-Rows" : "15000",
                                                                                                "Predicate" : "c_mktsegment == \"BUILDING\"",
                                                                                                "Pushdown" : "True",
                                                                                                "Name" : "Filter",
                                                                                                "E-Size" : "422615.4",
                                                                                                "E-Cost" : "0"
                                                                                            },
                                                                                            {
                                                                                                "Scan" : "Parallel",
                                                                                                "E-Size" : "4226154",
                                                                                                "ReadRanges" : [
                                                                                                    "c_custkey (-∞, +∞)"
                                                                                                ],
                                                                                                "Name" : "TableFullScan",
                                                                                                "Inputs" : [ ],
                                                                                                "Path" : "/local/test_db/olap_yatests/tpch/s1/customer",
                                                                                                "E-Rows" : "150000",
                                                                                                "Table" : "olap_yatests/tpch/s1/customer",
                                                                                                "ReadColumns" : [
                                                                                                    "c_custkey",
                                                                                                    "c_mktsegment"
                                                                                                ],
                                                                                                "SsaProgram" : {
                                                                                                    "Command" : [
                                                                                                        {
                                                                                                            "Assign" : {
                                                                                                                "Constant" : {
                                                                                                                    "Bytes" : "BUILDING"
                                                                                                                },
                                                                                                                "Column" : {
                                                                                                                    "Id" : 9
                                                                                                                }
                                                                                                            }
                                                                                                        },
                                                                                                        {
                                                                                                            "Assign" : {
                                                                                                                "Function" : {
                                                                                                                    "YqlOperationId" : 11,
                                                                                                                    "KernelIdx" : 0,
                                                                                                                    "FunctionType" : 2,
                                                                                                                    "Arguments" : [
                                                                                                                        {
                                                                                                                            "Id" : 5
                                                                                                                        },
                                                                                                                        {
                                                                                                                            "Id" : 9
                                                                                                                        }
                                                                                                                    ]
                                                                                                                },
                                                                                                                "Column" : {
                                                                                                                    "Id" : 10
                                                                                                                }
                                                                                                            }
                                                                                                        },
                                                                                                        {
                                                                                                            "Filter" : {
                                                                                                                "Predicate" : {
                                                                                                                    "Id" : 10
                                                                                                                }
                                                                                                            }
                                                                                                        },
                                                                                                        {
                                                                                                            "Projection" : {
                                                                                                                "Columns" : [
                                                                                                                    {
                                                                                                                        "Id" : 4
                                                                                                                    }
                                                                                                                ]
                                                                                                            }
                                                                                                        }
                                                                                                    ]
                                                                                                },
                                                                                                "E-Cost" : "0"
                                                                                            }
                                                                                        ],
                                                                                        "Node Type" : "Filter-TableFullScan"
                                                                                    }
                                                                                ],
                                                                                "Node Type" : "UnionAll",
                                                                                "PlanNodeType" : "Connection"
                                                                            }
                                                                        ],
                                                                        "Node Type" : "Stage"
                                                                    }
                                                                ],
                                                                "Node Type" : "Broadcast",
                                                                "PlanNodeType" : "Connection"
                                                            }
                                                        ],
                                                        "Operators" : [
                                                            {
                                                                "Inputs" : [
                                                                    {
                                                                        "InternalOperatorId" : 1
                                                                    },
                                                                    {
                                                                        "InternalOperatorId" : 1
                                                                    },
                                                                    {
                                                                        "InternalOperatorId" : 1
                                                                    },
                                                                    {
                                                                        "InternalOperatorId" : 1
                                                                    },
                                                                    {
                                                                        "InternalOperatorId" : 1
                                                                    }
                                                                ],
                                                                "GroupBy" : "[0,1,2]",
                                                                "Aggregation" : "SUM",
                                                                "Name" : "Aggregate",
                                                                "Phase" : "Intermediate"
                                                            },
                                                            {
                                                                "Inputs" : [
                                                                    {
                                                                        "InternalOperatorId" : 2
                                                                    },
                                                                    {
                                                                        "ExternalPlanNodeId" : 4
                                                                    }
                                                                ],
                                                                "E-Rows" : "1500303.75",
                                                                "Condition" : "o_1.o_custkey = c.c_custkey",
                                                                "Name" : "LeftSemiJoin (MapJoin)",
                                                                "E-Size" : "110318073.8",
                                                                "E-Cost" : "13542778.13"
                                                            },
                                                            {
                                                                "Inputs" : [
                                                                    {
                                                                        "ExternalPlanNodeId" : 8
                                                                    },
                                                                    {
                                                                        "ExternalPlanNodeId" : 6
                                                                    }
                                                                ],
                                                                "E-Rows" : "1500303.75",
                                                                "Condition" : "l.l_orderkey = o_1.o_orderkey",
                                                                "Name" : "InnerJoin (Grace)",
                                                                "E-Size" : "68047975.85",
                                                                "E-Cost" : "9001366.875"
                                                            }
                                                        ],
                                                        "Node Type" : "Aggregate-LeftSemiJoin (MapJoin)-InnerJoin (Grace)"
                                                    }
                                                ],
                                                "HashFunc" : "HashV1",
                                                "Node Type" : "HashShuffle",
                                                "KeyColumns" : [
                                                    "l_orderkey",
                                                    "o_orderdate",
                                                    "o_shippriority"
                                                ],
                                                "PlanNodeType" : "Connection"
                                            }
                                        ],
                                        "Operators" : [
                                            {
                                                "Inputs" : [
                                                    {
                                                        "ExternalPlanNodeId" : 10
                                                    }
                                                ],
                                                "TopBy" : "[Arg.Sum0,Arg.o_orderdate]",
                                                "Name" : "Top",
                                                "Limit" : "10"
                                            }
                                        ],
                                        "Node Type" : "Top"
                                    }
                                ],
                                "Node Type" : "UnionAll",
                                "PlanNodeType" : "Connection"
                            }
                        ],
                        "Operators" : [
                            {
                                "Inputs" : [
                                    {
                                        "ExternalPlanNodeId" : 12
                                    }
                                ],
                                "Name" : "TopSort",
                                "Limit" : "10",
                                "TopSortBy" : "[Arg.Sum0,Arg.o_orderdate]"
                            }
                        ],
                        "Node Type" : "TopSort"
                    }
                ],
                "Node Type" : "ResultSet",
                "PlanNodeType" : "ResultSet"
            }
        ],
        "Node Type" : "Query",
        "Stats" : {
            "ResourcePoolId" : "default"
        },
        "PlanNodeType" : "Query"
    },
    "meta" : {
        "version" : "0.2",
        "type" : "query"
    },
    "tables" : [
        {
            "name" : "/local/test_db/olap_yatests/tpch/s1/customer",
            "reads" : [
                {
                    "columns" : [
                        "c_custkey",
                        "c_mktsegment"
                    ],
                    "scan_by" : [
                        "c_custkey (-∞, +∞)"
                    ],
                    "type" : "FullScan"
                }
            ]
        },
        {
            "name" : "/local/test_db/olap_yatests/tpch/s1/lineitem",
            "reads" : [
                {
                    "columns" : [
                        "l_discount",
                        "l_extendedprice",
                        "l_orderkey",
                        "l_shipdate"
                    ],
                    "scan_by" : [
                        "l_orderkey (-∞, +∞)",
                        "l_linenumber (-∞, +∞)"
                    ],
                    "type" : "FullScan"
                }
            ]
        },
        {
            "name" : "/local/test_db/olap_yatests/tpch/s1/orders",
            "reads" : [
                {
                    "columns" : [
                        "o_custkey",
                        "o_orderdate",
                        "o_orderkey",
                        "o_shippriority"
                    ],
                    "scan_by" : [
                        "o_orderkey (-∞, +∞)"
                    ],
                    "type" : "FullScan"
                }
            ]
        }
    ],
    "SimplifiedPlan" : {
        "PlanNodeId" : 0,
        "Plans" : [
            {
                "PlanNodeId" : 1,
                "Plans" : [
                    {
                        "PlanNodeId" : 2,
                        "Plans" : [
                            {
                                "PlanNodeId" : 4,
                                "Plans" : [
                                    {
                                        "PlanNodeId" : 5,
                                        "Plans" : [
                                            {
                                                "PlanNodeId" : 6,
                                                "Plans" : [
                                                    {
                                                        "PlanNodeId" : 7,
                                                        "Plans" : [
                                                            {
                                                                "PlanNodeId" : 8,
                                                                "Plans" : [
                                                                    {
                                                                        "PlanNodeId" : 9,
                                                                        "Plans" : [
                                                                            {
                                                                                "PlanNodeId" : 10,
                                                                                "Plans" : [
                                                                                    {
                                                                                        "PlanNodeId" : 11,
                                                                                        "Operators" : [
                                                                                            {
                                                                                                "Scan" : "Parallel",
                                                                                                "E-Size" : "110816796",
                                                                                                "ReadRanges" : [
                                                                                                    "l_orderkey (-∞, +∞)",
                                                                                                    "l_linenumber (-∞, +∞)"
                                                                                                ],
                                                                                                "Name" : "TableFullScan",
                                                                                                "Path" : "/local/test_db/olap_yatests/tpch/s1/lineitem",
                                                                                                "E-Rows" : "6001215",
                                                                                                "Table" : "olap_yatests/tpch/s1/lineitem",
                                                                                                "ReadColumns" : [
                                                                                                    "l_discount",
                                                                                                    "l_extendedprice",
                                                                                                    "l_orderkey",
                                                                                                    "l_shipdate"
                                                                                                ],
                                                                                                "SsaProgram" : {
                                                                                                    "Command" : [
                                                                                                        {
                                                                                                            "Assign" : {
                                                                                                                "Function" : {
                                                                                                                    "KernelName" : "",
                                                                                                                    "KernelIdx" : 0,
                                                                                                                    "FunctionType" : 2,
                                                                                                                    "Arguments" : [
                                                                                                                        {
                                                                                                                            "Id" : 12
                                                                                                                        }
                                                                                                                    ]
                                                                                                                },
                                                                                                                "Column" : {
                                                                                                                    "Id" : 17
                                                                                                                }
                                                                                                            }
                                                                                                        },
                                                                                                        {
                                                                                                            "Filter" : {
                                                                                                                "Predicate" : {
                                                                                                                    "Id" : 17
                                                                                                                }
                                                                                                            }
                                                                                                        },
                                                                                                        {
                                                                                                            "Projection" : {
                                                                                                                "Columns" : [
                                                                                                                    {
                                                                                                                        "Id" : 3
                                                                                                                    },
                                                                                                                    {
                                                                                                                        "Id" : 4
                                                                                                                    },
                                                                                                                    {
                                                                                                                        "Id" : 7
                                                                                                                    }
                                                                                                                ]
                                                                                                            }
                                                                                                        }
                                                                                                    ]
                                                                                                },
                                                                                                "E-Cost" : "0"
                                                                                            }
                                                                                        ],
                                                                                        "Node Type" : "TableFullScan"
                                                                                    }
                                                                                ],
                                                                                "Operators" : [
                                                                                    {
                                                                                        "E-Rows" : "3000607.5",
                                                                                        "Predicate" : "l_shipdate > \"9204\"",
                                                                                        "Pushdown" : "True",
                                                                                        "Name" : "Filter",
                                                                                        "E-Size" : "55408398",
                                                                                        "E-Cost" : "0"
                                                                                    }
                                                                                ],
                                                                                "Node Type" : "Filter"
                                                                            }
                                                                        ],
                                                                        "Node Type" : "HashShuffle (KeyColumns: [\"l_orderkey\"], HashFunc: \"HashV1\")",
                                                                        "PlanNodeType" : "Connection"
                                                                    },
                                                                    {
                                                                        "PlanNodeId" : 12,
                                                                        "Plans" : [
                                                                            {
                                                                                "PlanNodeId" : 13,
                                                                                "Plans" : [
                                                                                    {
                                                                                        "PlanNodeId" : 14,
                                                                                        "Operators" : [
                                                                                            {
                                                                                                "Scan" : "Parallel",
                                                                                                "E-Size" : "40335608.89",
                                                                                                "ReadRanges" : [
                                                                                                    "o_orderkey (-∞, +∞)"
                                                                                                ],
                                                                                                "Name" : "TableFullScan",
                                                                                                "Path" : "/local/test_db/olap_yatests/tpch/s1/orders",
                                                                                                "E-Rows" : "1500000",
                                                                                                "Table" : "olap_yatests/tpch/s1/orders",
                                                                                                "ReadColumns" : [
                                                                                                    "o_custkey",
                                                                                                    "o_orderdate",
                                                                                                    "o_orderkey",
                                                                                                    "o_shippriority"
                                                                                                ],
                                                                                                "SsaProgram" : {
                                                                                                    "Command" : [
                                                                                                        {
                                                                                                            "Assign" : {
                                                                                                                "Function" : {
                                                                                                                    "KernelName" : "",
                                                                                                                    "KernelIdx" : 0,
                                                                                                                    "FunctionType" : 2,
                                                                                                                    "Arguments" : [
                                                                                                                        {
                                                                                                                            "Id" : 4
                                                                                                                        }
                                                                                                                    ]
                                                                                                                },
                                                                                                                "Column" : {
                                                                                                                    "Id" : 10
                                                                                                                }
                                                                                                            }
                                                                                                        },
                                                                                                        {
                                                                                                            "Filter" : {
                                                                                                                "Predicate" : {
                                                                                                                    "Id" : 10
                                                                                                                }
                                                                                                            }
                                                                                                        },
                                                                                                        {
                                                                                                            "Projection" : {
                                                                                                                "Columns" : [
                                                                                                                    {
                                                                                                                        "Id" : 3
                                                                                                                    },
                                                                                                                    {
                                                                                                                        "Id" : 4
                                                                                                                    },
                                                                                                                    {
                                                                                                                        "Id" : 5
                                                                                                                    },
                                                                                                                    {
                                                                                                                        "Id" : 8
                                                                                                                    }
                                                                                                                ]
                                                                                                            }
                                                                                                        }
                                                                                                    ]
                                                                                                },
                                                                                                "E-Cost" : "0"
                                                                                            }
                                                                                        ],
                                                                                        "Node Type" : "TableFullScan"
                                                                                    }
                                                                                ],
                                                                                "Operators" : [
                                                                                    {
                                                                                        "E-Rows" : "750000",
                                                                                        "Predicate" : "o_orderdate < \"9204\"",
                                                                                        "Pushdown" : "True",
                                                                                        "Name" : "Filter",
                                                                                        "E-Size" : "20167804.44",
                                                                                        "E-Cost" : "0"
                                                                                    }
                                                                                ],
                                                                                "Node Type" : "Filter"
                                                                            }
                                                                        ],
                                                                        "Node Type" : "HashShuffle (KeyColumns: [\"o_orderkey\"], HashFunc: \"HashV1\")",
                                                                        "PlanNodeType" : "Connection"
                                                                    }
                                                                ],
                                                                "Operators" : [
                                                                    {
                                                                        "E-Rows" : "1500303.75",
                                                                        "Condition" : "l.l_orderkey = o_1.o_orderkey",
                                                                        "Name" : "InnerJoin (Grace)",
                                                                        "E-Size" : "68047975.85",
                                                                        "E-Cost" : "9001366.875"
                                                                    }
                                                                ],
                                                                "Node Type" : "InnerJoin (Grace)"
                                                            },
                                                            {
                                                                "PlanNodeId" : 18,
                                                                "Plans" : [
                                                                    {
                                                                        "PlanNodeId" : 19,
                                                                        "Operators" : [
                                                                            {
                                                                                "Scan" : "Parallel",
                                                                                "E-Size" : "4226154",
                                                                                "ReadRanges" : [
                                                                                    "c_custkey (-∞, +∞)"
                                                                                ],
                                                                                "Name" : "TableFullScan",
                                                                                "Path" : "/local/test_db/olap_yatests/tpch/s1/customer",
                                                                                "E-Rows" : "150000",
                                                                                "Table" : "olap_yatests/tpch/s1/customer",
                                                                                "ReadColumns" : [
                                                                                    "c_custkey",
                                                                                    "c_mktsegment"
                                                                                ],
                                                                                "SsaProgram" : {
                                                                                    "Command" : [
                                                                                        {
                                                                                            "Assign" : {
                                                                                                "Constant" : {
                                                                                                    "Bytes" : "BUILDING"
                                                                                                },
                                                                                                "Column" : {
                                                                                                    "Id" : 9
                                                                                                }
                                                                                            }
                                                                                        },
                                                                                        {
                                                                                            "Assign" : {
                                                                                                "Function" : {
                                                                                                    "YqlOperationId" : 11,
                                                                                                    "KernelIdx" : 0,
                                                                                                    "FunctionType" : 2,
                                                                                                    "Arguments" : [
                                                                                                        {
                                                                                                            "Id" : 5
                                                                                                        },
                                                                                                        {
                                                                                                            "Id" : 9
                                                                                                        }
                                                                                                    ]
                                                                                                },
                                                                                                "Column" : {
                                                                                                    "Id" : 10
                                                                                                }
                                                                                            }
                                                                                        },
                                                                                        {
                                                                                            "Filter" : {
                                                                                                "Predicate" : {
                                                                                                    "Id" : 10
                                                                                                }
                                                                                            }
                                                                                        },
                                                                                        {
                                                                                            "Projection" : {
                                                                                                "Columns" : [
                                                                                                    {
                                                                                                        "Id" : 4
                                                                                                    }
                                                                                                ]
                                                                                            }
                                                                                        }
                                                                                    ]
                                                                                },
                                                                                "E-Cost" : "0"
                                                                            }
                                                                        ],
                                                                        "Node Type" : "TableFullScan"
                                                                    }
                                                                ],
                                                                "Operators" : [
                                                                    {
                                                                        "E-Rows" : "15000",
                                                                        "Predicate" : "c_mktsegment == \"BUILDING\"",
                                                                        "Pushdown" : "True",
                                                                        "Name" : "Filter",
                                                                        "E-Size" : "422615.4",
                                                                        "E-Cost" : "0"
                                                                    }
                                                                ],
                                                                "Node Type" : "Filter"
                                                            }
                                                        ],
                                                        "Operators" : [
                                                            {
                                                                "E-Rows" : "1500303.75",
                                                                "Condition" : "o_1.o_custkey = c.c_custkey",
                                                                "Name" : "LeftSemiJoin (MapJoin)",
                                                                "E-Size" : "110318073.8",
                                                                "E-Cost" : "13542778.13"
                                                            }
                                                        ],
                                                        "Node Type" : "LeftSemiJoin (MapJoin)"
                                                    }
                                                ],
                                                "Operators" : [
                                                    {
                                                        "GroupBy" : "[0,1,2]",
                                                        "Aggregation" : "SUM",
                                                        "Name" : "Aggregate",
                                                        "Phase" : "Intermediate"
                                                    }
                                                ],
                                                "Node Type" : "Aggregate"
                                            }
                                        ],
                                        "Node Type" : "HashShuffle (KeyColumns: [\"l_orderkey\",\"o_orderdate\",\"o_shippriority\"], HashFunc: \"HashV1\")",
                                        "PlanNodeType" : "Connection"
                                    }
                                ],
                                "Operators" : [
                                    {
                                        "TopBy" : "[Arg.Sum0,Arg.o_orderdate]",
                                        "Name" : "Top",
                                        "Limit" : "10"
                                    }
                                ],
                                "Node Type" : "Top"
                            }
                        ],
                        "Operators" : [
                            {
                                "Name" : "TopSort",
                                "Limit" : "10",
                                "TopSortBy" : "[Arg.Sum0,Arg.o_orderdate]"
                            }
                        ],
                        "Node Type" : "TopSort"
                    }
                ],
                "Node Type" : "ResultSet",
                "PlanNodeType" : "ResultSet"
            }
        ],
        "Node Type" : "Query",
        "OptimizerStats" : {
            "EquiJoinsCount" : 1,
            "JoinsCount" : 3
        },
        "PlanNodeType" : "Query"
    }
}
