{
    "Plan" : {
        "Plans" : [
            {
                "PlanNodeId" : 42,
                "Plans" : [
                    {
                        "PlanNodeId" : 41,
                        "Plans" : [
                            {
                                "PlanNodeId" : 40,
                                "Plans" : [
                                    {
                                        "PlanNodeId" : 39,
                                        "Plans" : [
                                            {
                                                "PlanNodeId" : 38,
                                                "Plans" : [
                                                    {
                                                        "PlanNodeId" : 37,
                                                        "Plans" : [
                                                            {
                                                                "PlanNodeId" : 36,
                                                                "Plans" : [
                                                                    {
                                                                        "PlanNodeId" : 35,
                                                                        "Plans" : [
                                                                            {
                                                                                "PlanNodeId" : 34,
                                                                                "Plans" : [
                                                                                    {
                                                                                        "Tables" : [
                                                                                            "olap_yatests/tpch/s1/partsupp"
                                                                                        ],
                                                                                        "PlanNodeId" : 33,
                                                                                        "Operators" : [
                                                                                            {
                                                                                                "Scan" : "Parallel",
                                                                                                "E-Size" : "32712192",
                                                                                                "ReadRanges" : [
                                                                                                    "ps_partkey (-∞, +∞)",
                                                                                                    "ps_suppkey (-∞, +∞)"
                                                                                                ],
                                                                                                "Name" : "TableFullScan",
                                                                                                "Inputs" : [ ],
                                                                                                "Path" : "/local/test_db/olap_yatests/tpch/s1/partsupp",
                                                                                                "E-Rows" : "800000",
                                                                                                "Table" : "olap_yatests/tpch/s1/partsupp",
                                                                                                "ReadColumns" : [
                                                                                                    "ps_partkey",
                                                                                                    "ps_suppkey",
                                                                                                    "ps_supplycost"
                                                                                                ],
                                                                                                "SsaProgram" : {
                                                                                                    "Command" : [
                                                                                                        {
                                                                                                            "Projection" : {
                                                                                                                "Columns" : [
                                                                                                                    {
                                                                                                                        "Id" : 3
                                                                                                                    },
                                                                                                                    {
                                                                                                                        "Id" : 4
                                                                                                                    },
                                                                                                                    {
                                                                                                                        "Id" : 5
                                                                                                                    }
                                                                                                                ]
                                                                                                            }
                                                                                                        }
                                                                                                    ]
                                                                                                },
                                                                                                "E-Cost" : "0"
                                                                                            }
                                                                                        ],
                                                                                        "Node Type" : "TableFullScan"
                                                                                    }
                                                                                ],
                                                                                "HashFunc" : "HashV1",
                                                                                "Node Type" : "HashShuffle",
                                                                                "KeyColumns" : [
                                                                                    "ps_suppkey"
                                                                                ],
                                                                                "PlanNodeType" : "Connection"
                                                                            },
                                                                            {
                                                                                "PlanNodeId" : 32,
                                                                                "Plans" : [
                                                                                    {
                                                                                        "PlanNodeId" : 31,
                                                                                        "Plans" : [
                                                                                            {
                                                                                                "PlanNodeId" : 30,
                                                                                                "Plans" : [
                                                                                                    {
                                                                                                        "Tables" : [
                                                                                                            "olap_yatests/tpch/s1/supplier"
                                                                                                        ],
                                                                                                        "PlanNodeId" : 29,
                                                                                                        "Operators" : [
                                                                                                            {
                                                                                                                "Scan" : "Parallel",
                                                                                                                "E-Size" : "1106680",
                                                                                                                "ReadRanges" : [
                                                                                                                    "s_suppkey (-∞, +∞)"
                                                                                                                ],
                                                                                                                "Name" : "TableFullScan",
                                                                                                                "Inputs" : [ ],
                                                                                                                "Path" : "/local/test_db/olap_yatests/tpch/s1/supplier",
                                                                                                                "E-Rows" : "10000",
                                                                                                                "Table" : "olap_yatests/tpch/s1/supplier",
                                                                                                                "ReadColumns" : [
                                                                                                                    "s_acctbal",
                                                                                                                    "s_address",
                                                                                                                    "s_comment",
                                                                                                                    "s_name",
                                                                                                                    "s_nationkey",
                                                                                                                    "s_phone",
                                                                                                                    "s_suppkey"
                                                                                                                ],
                                                                                                                "SsaProgram" : {
                                                                                                                    "Command" : [
                                                                                                                        {
                                                                                                                            "Projection" : {
                                                                                                                                "Columns" : [
                                                                                                                                    {
                                                                                                                                        "Id" : 1
                                                                                                                                    },
                                                                                                                                    {
                                                                                                                                        "Id" : 2
                                                                                                                                    },
                                                                                                                                    {
                                                                                                                                        "Id" : 3
                                                                                                                                    },
                                                                                                                                    {
                                                                                                                                        "Id" : 4
                                                                                                                                    },
                                                                                                                                    {
                                                                                                                                        "Id" : 5
                                                                                                                                    },
                                                                                                                                    {
                                                                                                                                        "Id" : 6
                                                                                                                                    },
                                                                                                                                    {
                                                                                                                                        "Id" : 7
                                                                                                                                    }
                                                                                                                                ]
                                                                                                                            }
                                                                                                                        }
                                                                                                                    ]
                                                                                                                },
                                                                                                                "E-Cost" : "0"
                                                                                                            }
                                                                                                        ],
                                                                                                        "Node Type" : "TableFullScan"
                                                                                                    }
                                                                                                ],
                                                                                                "Node Type" : "Map",
                                                                                                "PlanNodeType" : "Connection"
                                                                                            },
                                                                                            {
                                                                                                "PlanNodeId" : 28,
                                                                                                "Plans" : [
                                                                                                    {
                                                                                                        "PlanNodeId" : 27,
                                                                                                        "Plans" : [
                                                                                                            {
                                                                                                                "PlanNodeId" : 26,
                                                                                                                "Plans" : [
                                                                                                                    {
                                                                                                                        "Tables" : [
                                                                                                                            "olap_yatests/tpch/s1/nation"
                                                                                                                        ],
                                                                                                                        "PlanNodeId" : 25,
                                                                                                                        "Plans" : [
                                                                                                                            {
                                                                                                                                "PlanNodeId" : 24,
                                                                                                                                "Plans" : [
                                                                                                                                    {
                                                                                                                                        "PlanNodeId" : 23,
                                                                                                                                        "Plans" : [
                                                                                                                                            {
                                                                                                                                                "PlanNodeId" : 22,
                                                                                                                                                "Plans" : [
                                                                                                                                                    {
                                                                                                                                                        "Tables" : [
                                                                                                                                                            "olap_yatests/tpch/s1/region"
                                                                                                                                                        ],
                                                                                                                                                        "PlanNodeId" : 21,
                                                                                                                                                        "Operators" : [
                                                                                                                                                            {
                                                                                                                                                                "Inputs" : [
                                                                                                                                                                    {
                                                                                                                                                                        "InternalOperatorId" : 1
                                                                                                                                                                    }
                                                                                                                                                                ],
                                                                                                                                                                "E-Rows" : "0.5",
                                                                                                                                                                "Predicate" : "r_name == \"EUROPE\"",
                                                                                                                                                                "Pushdown" : "True",
                                                                                                                                                                "Name" : "Filter",
                                                                                                                                                                "E-Size" : "67.2",
                                                                                                                                                                "E-Cost" : "0"
                                                                                                                                                            },
                                                                                                                                                            {
                                                                                                                                                                "Scan" : "Parallel",
                                                                                                                                                                "E-Size" : "672",
                                                                                                                                                                "ReadRanges" : [
                                                                                                                                                                    "r_regionkey (-∞, +∞)"
                                                                                                                                                                ],
                                                                                                                                                                "Name" : "TableFullScan",
                                                                                                                                                                "Inputs" : [ ],
                                                                                                                                                                "Path" : "/local/test_db/olap_yatests/tpch/s1/region",
                                                                                                                                                                "E-Rows" : "5",
                                                                                                                                                                "Table" : "olap_yatests/tpch/s1/region",
                                                                                                                                                                "ReadColumns" : [
                                                                                                                                                                    "r_name",
                                                                                                                                                                    "r_regionkey"
                                                                                                                                                                ],
                                                                                                                                                                "SsaProgram" : {
                                                                                                                                                                    "Command" : [
                                                                                                                                                                        {
                                                                                                                                                                            "Assign" : {
                                                                                                                                                                                "Constant" : {
                                                                                                                                                                                    "Bytes" : "EUROPE"
                                                                                                                                                                                },
                                                                                                                                                                                "Column" : {
                                                                                                                                                                                    "Id" : 4
                                                                                                                                                                                }
                                                                                                                                                                            }
                                                                                                                                                                        },
                                                                                                                                                                        {
                                                                                                                                                                            "Assign" : {
                                                                                                                                                                                "Function" : {
                                                                                                                                                                                    "YqlOperationId" : 11,
                                                                                                                                                                                    "KernelIdx" : 0,
                                                                                                                                                                                    "FunctionType" : 2,
                                                                                                                                                                                    "Arguments" : [
                                                                                                                                                                                        {
                                                                                                                                                                                            "Id" : 2
                                                                                                                                                                                        },
                                                                                                                                                                                        {
                                                                                                                                                                                            "Id" : 4
                                                                                                                                                                                        }
                                                                                                                                                                                    ]
                                                                                                                                                                                },
                                                                                                                                                                                "Column" : {
                                                                                                                                                                                    "Id" : 5
                                                                                                                                                                                }
                                                                                                                                                                            }
                                                                                                                                                                        },
                                                                                                                                                                        {
                                                                                                                                                                            "Filter" : {
                                                                                                                                                                                "Predicate" : {
                                                                                                                                                                                    "Id" : 5
                                                                                                                                                                                }
                                                                                                                                                                            }
                                                                                                                                                                        },
                                                                                                                                                                        {
                                                                                                                                                                            "Projection" : {
                                                                                                                                                                                "Columns" : [
                                                                                                                                                                                    {
                                                                                                                                                                                        "Id" : 3
                                                                                                                                                                                    }
                                                                                                                                                                                ]
                                                                                                                                                                            }
                                                                                                                                                                        }
                                                                                                                                                                    ]
                                                                                                                                                                },
                                                                                                                                                                "E-Cost" : "0"
                                                                                                                                                            }
                                                                                                                                                        ],
                                                                                                                                                        "Node Type" : "Filter-TableFullScan"
                                                                                                                                                    }
                                                                                                                                                ],
                                                                                                                                                "Node Type" : "UnionAll",
                                                                                                                                                "PlanNodeType" : "Connection"
                                                                                                                                            }
                                                                                                                                        ],
                                                                                                                                        "Node Type" : "Stage"
                                                                                                                                    }
                                                                                                                                ],
                                                                                                                                "Node Type" : "Broadcast",
                                                                                                                                "PlanNodeType" : "Connection"
                                                                                                                            }
                                                                                                                        ],
                                                                                                                        "Operators" : [
                                                                                                                            {
                                                                                                                                "Inputs" : [
                                                                                                                                    {
                                                                                                                                        "InternalOperatorId" : 1
                                                                                                                                    },
                                                                                                                                    {
                                                                                                                                        "ExternalPlanNodeId" : 24
                                                                                                                                    }
                                                                                                                                ],
                                                                                                                                "E-Rows" : "25",
                                                                                                                                "Condition" : "n.n_regionkey = r.r_regionkey",
                                                                                                                                "Name" : "LeftSemiJoin (MapJoin)",
                                                                                                                                "E-Size" : "5178",
                                                                                                                                "E-Cost" : "76.35"
                                                                                                                            },
                                                                                                                            {
                                                                                                                                "Scan" : "Parallel",
                                                                                                                                "E-Size" : "1818",
                                                                                                                                "ReadRanges" : [
                                                                                                                                    "n_nationkey (-∞, +∞)"
                                                                                                                                ],
                                                                                                                                "Name" : "TableFullScan",
                                                                                                                                "Inputs" : [ ],
                                                                                                                                "Path" : "/local/test_db/olap_yatests/tpch/s1/nation",
                                                                                                                                "E-Rows" : "25",
                                                                                                                                "Table" : "olap_yatests/tpch/s1/nation",
                                                                                                                                "ReadColumns" : [
                                                                                                                                    "n_name",
                                                                                                                                    "n_nationkey",
                                                                                                                                    "n_regionkey"
                                                                                                                                ],
                                                                                                                                "SsaProgram" : {
                                                                                                                                    "Command" : [
                                                                                                                                        {
                                                                                                                                            "Projection" : {
                                                                                                                                                "Columns" : [
                                                                                                                                                    {
                                                                                                                                                        "Id" : 2
                                                                                                                                                    },
                                                                                                                                                    {
                                                                                                                                                        "Id" : 3
                                                                                                                                                    },
                                                                                                                                                    {
                                                                                                                                                        "Id" : 4
                                                                                                                                                    }
                                                                                                                                                ]
                                                                                                                                            }
                                                                                                                                        }
                                                                                                                                    ]
                                                                                                                                },
                                                                                                                                "E-Cost" : "0"
                                                                                                                            }
                                                                                                                        ],
                                                                                                                        "Node Type" : "LeftSemiJoin (MapJoin)-TableFullScan"
                                                                                                                    }
                                                                                                                ],
                                                                                                                "Node Type" : "UnionAll",
                                                                                                                "PlanNodeType" : "Connection"
                                                                                                            }
                                                                                                        ],
                                                                                                        "Node Type" : "Stage"
                                                                                                    }
                                                                                                ],
                                                                                                "Node Type" : "Broadcast",
                                                                                                "PlanNodeType" : "Connection"
                                                                                            }
                                                                                        ],
                                                                                        "Operators" : [
                                                                                            {
                                                                                                "Inputs" : [
                                                                                                    {
                                                                                                        "ExternalPlanNodeId" : 30
                                                                                                    },
                                                                                                    {
                                                                                                        "ExternalPlanNodeId" : 28
                                                                                                    }
                                                                                                ],
                                                                                                "E-Rows" : "10000",
                                                                                                "Condition" : "s_1.s_nationkey = n.n_nationkey",
                                                                                                "Name" : "LeftSemiJoin (MapJoin)",
                                                                                                "E-Size" : "3177880",
                                                                                                "E-Cost" : "30143.85"
                                                                                            }
                                                                                        ],
                                                                                        "Node Type" : "LeftSemiJoin (MapJoin)"
                                                                                    }
                                                                                ],
                                                                                "HashFunc" : "HashV1",
                                                                                "Node Type" : "HashShuffle",
                                                                                "KeyColumns" : [
                                                                                    "s_1.s_suppkey"
                                                                                ],
                                                                                "PlanNodeType" : "Connection"
                                                                            }
                                                                        ],
                                                                        "Operators" : [
                                                                            {
                                                                                "Inputs" : [
                                                                                    {
                                                                                        "InternalOperatorId" : 1
                                                                                    }
                                                                                ],
                                                                                "GroupBy" : "[0]",
                                                                                "Aggregation" : "MIN",
                                                                                "Name" : "Aggregate",
                                                                                "Phase" : "Intermediate"
                                                                            },
                                                                            {
                                                                                "Inputs" : [
                                                                                    {
                                                                                        "ExternalPlanNodeId" : 34
                                                                                    },
                                                                                    {
                                                                                        "ExternalPlanNodeId" : 32
                                                                                    }
                                                                                ],
                                                                                "E-Rows" : "800000",
                                                                                "Condition" : "ps.ps_suppkey = s_1.s_suppkey",
                                                                                "Name" : "LeftSemiJoin (Grace)",
                                                                                "E-Size" : "286942592",
                                                                                "E-Cost" : "2460143.85"
                                                                            }
                                                                        ],
                                                                        "Node Type" : "Aggregate-LeftSemiJoin (Grace)"
                                                                    }
                                                                ],
                                                                "HashFunc" : "HashV1",
                                                                "Node Type" : "HashShuffle",
                                                                "KeyColumns" : [
                                                                    "ps.ps_partkey"
                                                                ],
                                                                "PlanNodeType" : "Connection"
                                                            }
                                                        ],
                                                        "Node Type" : "Stage"
                                                    }
                                                ],
                                                "HashFunc" : "HashV1",
                                                "Node Type" : "HashShuffle",
                                                "KeyColumns" : [
                                                    "ps.ps_partkey",
                                                    "Min0"
                                                ],
                                                "PlanNodeType" : "Connection"
                                            },
                                            {
                                                "PlanNodeId" : 20,
                                                "Plans" : [
                                                    {
                                                        "PlanNodeId" : 19,
                                                        "Plans" : [
                                                            {
                                                                "PlanNodeId" : 18,
                                                                "Plans" : [
                                                                    {
                                                                        "PlanNodeId" : 17,
                                                                        "Plans" : [
                                                                            {
                                                                                "PlanNodeId" : 16,
                                                                                "Plans" : [
                                                                                    {
                                                                                        "Tables" : [
                                                                                            "olap_yatests/tpch/s1/partsupp"
                                                                                        ],
                                                                                        "PlanNodeId" : 15,
                                                                                        "Operators" : [
                                                                                            {
                                                                                                "Scan" : "Parallel",
                                                                                                "E-Size" : "32712192",
                                                                                                "ReadRanges" : [
                                                                                                    "ps_partkey (-∞, +∞)",
                                                                                                    "ps_suppkey (-∞, +∞)"
                                                                                                ],
                                                                                                "Name" : "TableFullScan",
                                                                                                "Inputs" : [ ],
                                                                                                "Path" : "/local/test_db/olap_yatests/tpch/s1/partsupp",
                                                                                                "E-Rows" : "800000",
                                                                                                "Table" : "olap_yatests/tpch/s1/partsupp",
                                                                                                "ReadColumns" : [
                                                                                                    "ps_partkey",
                                                                                                    "ps_suppkey",
                                                                                                    "ps_supplycost"
                                                                                                ],
                                                                                                "SsaProgram" : {
                                                                                                    "Command" : [
                                                                                                        {
                                                                                                            "Projection" : {
                                                                                                                "Columns" : [
                                                                                                                    {
                                                                                                                        "Id" : 3
                                                                                                                    },
                                                                                                                    {
                                                                                                                        "Id" : 4
                                                                                                                    },
                                                                                                                    {
                                                                                                                        "Id" : 5
                                                                                                                    }
                                                                                                                ]
                                                                                                            }
                                                                                                        }
                                                                                                    ]
                                                                                                },
                                                                                                "E-Cost" : "0"
                                                                                            }
                                                                                        ],
                                                                                        "Node Type" : "TableFullScan"
                                                                                    }
                                                                                ],
                                                                                "Node Type" : "Map",
                                                                                "PlanNodeType" : "Connection"
                                                                            },
                                                                            {
                                                                                "PlanNodeId" : 14,
                                                                                "Plans" : [
                                                                                    {
                                                                                        "PlanNodeId" : 13,
                                                                                        "Plans" : [
                                                                                            {
                                                                                                "PlanNodeId" : 12,
                                                                                                "Plans" : [
                                                                                                    {
                                                                                                        "Tables" : [
                                                                                                            "olap_yatests/tpch/s1/part"
                                                                                                        ],
                                                                                                        "PlanNodeId" : 11,
                                                                                                        "Operators" : [
                                                                                                            {
                                                                                                                "Inputs" : [
                                                                                                                    {
                                                                                                                        "InternalOperatorId" : 1
                                                                                                                    }
                                                                                                                ],
                                                                                                                "E-Rows" : "10000",
                                                                                                                "Predicate" : "(p_size == 15) AND (p_type LIKE \"%BRASS\")",
                                                                                                                "Pushdown" : "True",
                                                                                                                "Name" : "Filter",
                                                                                                                "E-Size" : "411678.0444",
                                                                                                                "E-Cost" : "0"
                                                                                                            },
                                                                                                            {
                                                                                                                "Scan" : "Parallel",
                                                                                                                "E-Size" : "8233560.889",
                                                                                                                "ReadRanges" : [
                                                                                                                    "p_partkey (-∞, +∞)"
                                                                                                                ],
                                                                                                                "Name" : "TableFullScan",
                                                                                                                "Inputs" : [ ],
                                                                                                                "Path" : "/local/test_db/olap_yatests/tpch/s1/part",
                                                                                                                "E-Rows" : "200000",
                                                                                                                "Table" : "olap_yatests/tpch/s1/part",
                                                                                                                "ReadColumns" : [
                                                                                                                    "p_mfgr",
                                                                                                                    "p_partkey",
                                                                                                                    "p_size",
                                                                                                                    "p_type"
                                                                                                                ],
                                                                                                                "SsaProgram" : {
                                                                                                                    "Command" : [
                                                                                                                        {
                                                                                                                            "Assign" : {
                                                                                                                                "Constant" : {
                                                                                                                                    "Int32" : 15
                                                                                                                                },
                                                                                                                                "Column" : {
                                                                                                                                    "Id" : 10
                                                                                                                                }
                                                                                                                            }
                                                                                                                        },
                                                                                                                        {
                                                                                                                            "Assign" : {
                                                                                                                                "Function" : {
                                                                                                                                    "YqlOperationId" : 11,
                                                                                                                                    "KernelIdx" : 0,
                                                                                                                                    "FunctionType" : 2,
                                                                                                                                    "Arguments" : [
                                                                                                                                        {
                                                                                                                                            "Id" : 8
                                                                                                                                        },
                                                                                                                                        {
                                                                                                                                            "Id" : 10
                                                                                                                                        }
                                                                                                                                    ]
                                                                                                                                },
                                                                                                                                "Column" : {
                                                                                                                                    "Id" : 11
                                                                                                                                }
                                                                                                                            }
                                                                                                                        },
                                                                                                                        {
                                                                                                                            "Filter" : {
                                                                                                                                "Predicate" : {
                                                                                                                                    "Id" : 11
                                                                                                                                }
                                                                                                                            }
                                                                                                                        },
                                                                                                                        {
                                                                                                                            "Projection" : { }
                                                                                                                        },
                                                                                                                        {
                                                                                                                            "Assign" : {
                                                                                                                                "Constant" : {
                                                                                                                                    "Bytes" : "BRASS"
                                                                                                                                },
                                                                                                                                "Column" : {
                                                                                                                                    "Id" : 12
                                                                                                                                }
                                                                                                                            }
                                                                                                                        },
                                                                                                                        {
                                                                                                                            "Assign" : {
                                                                                                                                "Function" : {
                                                                                                                                    "YqlOperationId" : 9,
                                                                                                                                    "KernelIdx" : 1,
                                                                                                                                    "FunctionType" : 2,
                                                                                                                                    "Arguments" : [
                                                                                                                                        {
                                                                                                                                            "Id" : 9
                                                                                                                                        },
                                                                                                                                        {
                                                                                                                                            "Id" : 12
                                                                                                                                        }
                                                                                                                                    ]
                                                                                                                                },
                                                                                                                                "Column" : {
                                                                                                                                    "Id" : 13
                                                                                                                                }
                                                                                                                            }
                                                                                                                        },
                                                                                                                        {
                                                                                                                            "Filter" : {
                                                                                                                                "Predicate" : {
                                                                                                                                    "Id" : 13
                                                                                                                                }
                                                                                                                            }
                                                                                                                        },
                                                                                                                        {
                                                                                                                            "Projection" : {
                                                                                                                                "Columns" : [
                                                                                                                                    {
                                                                                                                                        "Id" : 4
                                                                                                                                    },
                                                                                                                                    {
                                                                                                                                        "Id" : 6
                                                                                                                                    }
                                                                                                                                ]
                                                                                                                            }
                                                                                                                        }
                                                                                                                    ]
                                                                                                                },
                                                                                                                "E-Cost" : "0"
                                                                                                            }
                                                                                                        ],
                                                                                                        "Node Type" : "Filter-TableFullScan"
                                                                                                    }
                                                                                                ],
                                                                                                "Node Type" : "UnionAll",
                                                                                                "PlanNodeType" : "Connection"
                                                                                            }
                                                                                        ],
                                                                                        "Node Type" : "Stage"
                                                                                    }
                                                                                ],
                                                                                "Node Type" : "Broadcast",
                                                                                "PlanNodeType" : "Connection"
                                                                            }
                                                                        ],
                                                                        "Operators" : [
                                                                            {
                                                                                "Inputs" : [
                                                                                    {
                                                                                        "ExternalPlanNodeId" : 16
                                                                                    },
                                                                                    {
                                                                                        "ExternalPlanNodeId" : 14
                                                                                    }
                                                                                ],
                                                                                "E-Rows" : "400000",
                                                                                "Condition" : "ps_1.ps_partkey = p.p_partkey",
                                                                                "Name" : "InnerJoin (MapJoin)",
                                                                                "E-Size" : "32823217.78",
                                                                                "E-Cost" : "1827000"
                                                                            }
                                                                        ],
                                                                        "Node Type" : "InnerJoin (MapJoin)"
                                                                    }
                                                                ],
                                                                "HashFunc" : "HashV1",
                                                                "Node Type" : "HashShuffle",
                                                                "KeyColumns" : [
                                                                    "ps_1.ps_suppkey"
                                                                ],
                                                                "PlanNodeType" : "Connection"
                                                            },
                                                            {
                                                                "PlanNodeId" : 10,
                                                                "Plans" : [
                                                                    {
                                                                        "Tables" : [
                                                                            "olap_yatests/tpch/s1/supplier"
                                                                        ],
                                                                        "PlanNodeId" : 9,
                                                                        "Operators" : [
                                                                            {
                                                                                "Scan" : "Parallel",
                                                                                "E-Size" : "1106680",
                                                                                "ReadRanges" : [
                                                                                    "s_suppkey (-∞, +∞)"
                                                                                ],
                                                                                "Name" : "TableFullScan",
                                                                                "Inputs" : [ ],
                                                                                "Path" : "/local/test_db/olap_yatests/tpch/s1/supplier",
                                                                                "E-Rows" : "10000",
                                                                                "Table" : "olap_yatests/tpch/s1/supplier",
                                                                                "ReadColumns" : [
                                                                                    "s_acctbal",
                                                                                    "s_address",
                                                                                    "s_comment",
                                                                                    "s_name",
                                                                                    "s_nationkey",
                                                                                    "s_phone",
                                                                                    "s_suppkey"
                                                                                ],
                                                                                "SsaProgram" : {
                                                                                    "Command" : [
                                                                                        {
                                                                                            "Projection" : {
                                                                                                "Columns" : [
                                                                                                    {
                                                                                                        "Id" : 1
                                                                                                    },
                                                                                                    {
                                                                                                        "Id" : 2
                                                                                                    },
                                                                                                    {
                                                                                                        "Id" : 3
                                                                                                    },
                                                                                                    {
                                                                                                        "Id" : 4
                                                                                                    },
                                                                                                    {
                                                                                                        "Id" : 5
                                                                                                    },
                                                                                                    {
                                                                                                        "Id" : 6
                                                                                                    },
                                                                                                    {
                                                                                                        "Id" : 7
                                                                                                    }
                                                                                                ]
                                                                                            }
                                                                                        }
                                                                                    ]
                                                                                },
                                                                                "E-Cost" : "0"
                                                                            }
                                                                        ],
                                                                        "Node Type" : "TableFullScan"
                                                                    }
                                                                ],
                                                                "HashFunc" : "HashV1",
                                                                "Node Type" : "HashShuffle",
                                                                "KeyColumns" : [
                                                                    "s_suppkey"
                                                                ],
                                                                "PlanNodeType" : "Connection"
                                                            },
                                                            {
                                                                "PlanNodeId" : 8,
                                                                "Plans" : [
                                                                    {
                                                                        "PlanNodeId" : 7,
                                                                        "Plans" : [
                                                                            {
                                                                                "PlanNodeId" : 6,
                                                                                "Plans" : [
                                                                                    {
                                                                                        "Tables" : [
                                                                                            "olap_yatests/tpch/s1/nation"
                                                                                        ],
                                                                                        "PlanNodeId" : 5,
                                                                                        "Plans" : [
                                                                                            {
                                                                                                "PlanNodeId" : 4,
                                                                                                "Plans" : [
                                                                                                    {
                                                                                                        "PlanNodeId" : 3,
                                                                                                        "Plans" : [
                                                                                                            {
                                                                                                                "PlanNodeId" : 2,
                                                                                                                "Plans" : [
                                                                                                                    {
                                                                                                                        "Tables" : [
                                                                                                                            "olap_yatests/tpch/s1/region"
                                                                                                                        ],
                                                                                                                        "PlanNodeId" : 1,
                                                                                                                        "Operators" : [
                                                                                                                            {
                                                                                                                                "Inputs" : [
                                                                                                                                    {
                                                                                                                                        "InternalOperatorId" : 1
                                                                                                                                    }
                                                                                                                                ],
                                                                                                                                "E-Rows" : "0.5",
                                                                                                                                "Predicate" : "r_name == \"EUROPE\"",
                                                                                                                                "Pushdown" : "True",
                                                                                                                                "Name" : "Filter",
                                                                                                                                "E-Size" : "67.2",
                                                                                                                                "E-Cost" : "0"
                                                                                                                            },
                                                                                                                            {
                                                                                                                                "Scan" : "Parallel",
                                                                                                                                "E-Size" : "672",
                                                                                                                                "ReadRanges" : [
                                                                                                                                    "r_regionkey (-∞, +∞)"
                                                                                                                                ],
                                                                                                                                "Name" : "TableFullScan",
                                                                                                                                "Inputs" : [ ],
                                                                                                                                "Path" : "/local/test_db/olap_yatests/tpch/s1/region",
                                                                                                                                "E-Rows" : "5",
                                                                                                                                "Table" : "olap_yatests/tpch/s1/region",
                                                                                                                                "ReadColumns" : [
                                                                                                                                    "r_name",
                                                                                                                                    "r_regionkey"
                                                                                                                                ],
                                                                                                                                "SsaProgram" : {
                                                                                                                                    "Command" : [
                                                                                                                                        {
                                                                                                                                            "Assign" : {
                                                                                                                                                "Constant" : {
                                                                                                                                                    "Bytes" : "EUROPE"
                                                                                                                                                },
                                                                                                                                                "Column" : {
                                                                                                                                                    "Id" : 4
                                                                                                                                                }
                                                                                                                                            }
                                                                                                                                        },
                                                                                                                                        {
                                                                                                                                            "Assign" : {
                                                                                                                                                "Function" : {
                                                                                                                                                    "YqlOperationId" : 11,
                                                                                                                                                    "KernelIdx" : 0,
                                                                                                                                                    "FunctionType" : 2,
                                                                                                                                                    "Arguments" : [
                                                                                                                                                        {
                                                                                                                                                            "Id" : 2
                                                                                                                                                        },
                                                                                                                                                        {
                                                                                                                                                            "Id" : 4
                                                                                                                                                        }
                                                                                                                                                    ]
                                                                                                                                                },
                                                                                                                                                "Column" : {
                                                                                                                                                    "Id" : 5
                                                                                                                                                }
                                                                                                                                            }
                                                                                                                                        },
                                                                                                                                        {
                                                                                                                                            "Filter" : {
                                                                                                                                                "Predicate" : {
                                                                                                                                                    "Id" : 5
                                                                                                                                                }
                                                                                                                                            }
                                                                                                                                        },
                                                                                                                                        {
                                                                                                                                            "Projection" : {
                                                                                                                                                "Columns" : [
                                                                                                                                                    {
                                                                                                                                                        "Id" : 3
                                                                                                                                                    }
                                                                                                                                                ]
                                                                                                                                            }
                                                                                                                                        }
                                                                                                                                    ]
                                                                                                                                },
                                                                                                                                "E-Cost" : "0"
                                                                                                                            }
                                                                                                                        ],
                                                                                                                        "Node Type" : "Filter-TableFullScan"
                                                                                                                    }
                                                                                                                ],
                                                                                                                "Node Type" : "UnionAll",
                                                                                                                "PlanNodeType" : "Connection"
                                                                                                            }
                                                                                                        ],
                                                                                                        "Node Type" : "Stage"
                                                                                                    }
                                                                                                ],
                                                                                                "Node Type" : "Broadcast",
                                                                                                "PlanNodeType" : "Connection"
                                                                                            }
                                                                                        ],
                                                                                        "Operators" : [
                                                                                            {
                                                                                                "Inputs" : [
                                                                                                    {
                                                                                                        "InternalOperatorId" : 1
                                                                                                    },
                                                                                                    {
                                                                                                        "ExternalPlanNodeId" : 4
                                                                                                    }
                                                                                                ],
                                                                                                "E-Rows" : "25",
                                                                                                "Condition" : "n.n_regionkey = r.r_regionkey",
                                                                                                "Name" : "LeftSemiJoin (MapJoin)",
                                                                                                "E-Size" : "5178",
                                                                                                "E-Cost" : "76.35"
                                                                                            },
                                                                                            {
                                                                                                "Scan" : "Parallel",
                                                                                                "E-Size" : "1818",
                                                                                                "ReadRanges" : [
                                                                                                    "n_nationkey (-∞, +∞)"
                                                                                                ],
                                                                                                "Name" : "TableFullScan",
                                                                                                "Inputs" : [ ],
                                                                                                "Path" : "/local/test_db/olap_yatests/tpch/s1/nation",
                                                                                                "E-Rows" : "25",
                                                                                                "Table" : "olap_yatests/tpch/s1/nation",
                                                                                                "ReadColumns" : [
                                                                                                    "n_name",
                                                                                                    "n_nationkey",
                                                                                                    "n_regionkey"
                                                                                                ],
                                                                                                "SsaProgram" : {
                                                                                                    "Command" : [
                                                                                                        {
                                                                                                            "Projection" : {
                                                                                                                "Columns" : [
                                                                                                                    {
                                                                                                                        "Id" : 2
                                                                                                                    },
                                                                                                                    {
                                                                                                                        "Id" : 3
                                                                                                                    },
                                                                                                                    {
                                                                                                                        "Id" : 4
                                                                                                                    }
                                                                                                                ]
                                                                                                            }
                                                                                                        }
                                                                                                    ]
                                                                                                },
                                                                                                "E-Cost" : "0"
                                                                                            }
                                                                                        ],
                                                                                        "Node Type" : "LeftSemiJoin (MapJoin)-TableFullScan"
                                                                                    }
                                                                                ],
                                                                                "Node Type" : "UnionAll",
                                                                                "PlanNodeType" : "Connection"
                                                                            }
                                                                        ],
                                                                        "Node Type" : "Stage"
                                                                    }
                                                                ],
                                                                "Node Type" : "Broadcast",
                                                                "PlanNodeType" : "Connection"
                                                            }
                                                        ],
                                                        "Operators" : [
                                                            {
                                                                "Inputs" : [
                                                                    {
                                                                        "InternalOperatorId" : 1
                                                                    },
                                                                    {
                                                                        "ExternalPlanNodeId" : 8
                                                                    }
                                                                ],
                                                                "E-Rows" : "2000000",
                                                                "Condition" : "s_1.s_nationkey = n.n_nationkey",
                                                                "Name" : "InnerJoin (MapJoin)",
                                                                "E-Size" : "799692088.9",
                                                                "E-Cost" : "6657143.85"
                                                            },
                                                            {
                                                                "Inputs" : [
                                                                    {
                                                                        "ExternalPlanNodeId" : 18
                                                                    },
                                                                    {
                                                                        "ExternalPlanNodeId" : 10
                                                                    }
                                                                ],
                                                                "E-Rows" : "400000",
                                                                "Condition" : "ps_1.ps_suppkey = s_1.s_suppkey",
                                                                "Name" : "InnerJoin (Grace)",
                                                                "E-Size" : "77090417.78",
                                                                "E-Cost" : "3057000"
                                                            }
                                                        ],
                                                        "Node Type" : "InnerJoin (MapJoin)-InnerJoin (Grace)"
                                                    }
                                                ],
                                                "HashFunc" : "HashV1",
                                                "Node Type" : "HashShuffle",
                                                "KeyColumns" : [
                                                    "ps_1.ps_partkey",
                                                    "ps_1.ps_supplycost"
                                                ],
                                                "PlanNodeType" : "Connection"
                                            }
                                        ],
                                        "Operators" : [
                                            {
                                                "Inputs" : [
                                                    {
                                                        "InternalOperatorId" : 1
                                                    }
                                                ],
                                                "Name" : "TopSort",
                                                "Limit" : "100",
                                                "TopSortBy" : "[Arg.s_1.s_acctbal,Arg.n.n_name,Arg.s_1.s_name,Arg.ps_1.ps_partkey]"
                                            },
                                            {
                                                "Inputs" : [
                                                    {
                                                        "ExternalPlanNodeId" : 38
                                                    },
                                                    {
                                                        "ExternalPlanNodeId" : 20
                                                    }
                                                ],
                                                "E-Rows" : "3.2e+11",
                                                "Condition" : "m.Min0,m.ps.ps_partkey = ps_1.ps_partkey,ps_1.ps_supplycost",
                                                "Name" : "InnerJoin (Grace)",
                                                "E-Size" : "2.42727771e+14",
                                                "E-Cost" : "4.800163173e+11"
                                            }
                                        ],
                                        "Node Type" : "TopSort-InnerJoin (Grace)"
                                    }
                                ],
                                "Node Type" : "Merge",
                                "SortColumns" : [
                                    "s_1.s_acctbal (Desc)",
                                    "n.n_name (Asc)",
                                    "s_1.s_name (Asc)",
                                    "ps_1.ps_partkey (Asc)"
                                ],
                                "PlanNodeType" : "Connection"
                            }
                        ],
                        "Operators" : [
                            {
                                "Inputs" : [
                                    {
                                        "ExternalPlanNodeId" : 40
                                    }
                                ],
                                "Name" : "Limit",
                                "Limit" : "100"
                            }
                        ],
                        "Node Type" : "Limit"
                    }
                ],
                "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/nation",
            "reads" : [
                {
                    "columns" : [
                        "n_name",
                        "n_nationkey",
                        "n_regionkey"
                    ],
                    "scan_by" : [
                        "n_nationkey (-∞, +∞)"
                    ],
                    "type" : "FullScan"
                },
                {
                    "columns" : [
                        "n_name",
                        "n_nationkey",
                        "n_regionkey"
                    ],
                    "scan_by" : [
                        "n_nationkey (-∞, +∞)"
                    ],
                    "type" : "FullScan"
                }
            ]
        },
        {
            "name" : "/local/test_db/olap_yatests/tpch/s1/part",
            "reads" : [
                {
                    "columns" : [
                        "p_mfgr",
                        "p_partkey",
                        "p_size",
                        "p_type"
                    ],
                    "scan_by" : [
                        "p_partkey (-∞, +∞)"
                    ],
                    "type" : "FullScan"
                }
            ]
        },
        {
            "name" : "/local/test_db/olap_yatests/tpch/s1/partsupp",
            "reads" : [
                {
                    "columns" : [
                        "ps_partkey",
                        "ps_suppkey",
                        "ps_supplycost"
                    ],
                    "scan_by" : [
                        "ps_partkey (-∞, +∞)",
                        "ps_suppkey (-∞, +∞)"
                    ],
                    "type" : "FullScan"
                },
                {
                    "columns" : [
                        "ps_partkey",
                        "ps_suppkey",
                        "ps_supplycost"
                    ],
                    "scan_by" : [
                        "ps_partkey (-∞, +∞)",
                        "ps_suppkey (-∞, +∞)"
                    ],
                    "type" : "FullScan"
                }
            ]
        },
        {
            "name" : "/local/test_db/olap_yatests/tpch/s1/region",
            "reads" : [
                {
                    "columns" : [
                        "r_name",
                        "r_regionkey"
                    ],
                    "scan_by" : [
                        "r_regionkey (-∞, +∞)"
                    ],
                    "type" : "FullScan"
                },
                {
                    "columns" : [
                        "r_name",
                        "r_regionkey"
                    ],
                    "scan_by" : [
                        "r_regionkey (-∞, +∞)"
                    ],
                    "type" : "FullScan"
                }
            ]
        },
        {
            "name" : "/local/test_db/olap_yatests/tpch/s1/supplier",
            "reads" : [
                {
                    "columns" : [
                        "s_acctbal",
                        "s_address",
                        "s_comment",
                        "s_name",
                        "s_nationkey",
                        "s_phone",
                        "s_suppkey"
                    ],
                    "scan_by" : [
                        "s_suppkey (-∞, +∞)"
                    ],
                    "type" : "FullScan"
                },
                {
                    "columns" : [
                        "s_acctbal",
                        "s_address",
                        "s_comment",
                        "s_name",
                        "s_nationkey",
                        "s_phone",
                        "s_suppkey"
                    ],
                    "scan_by" : [
                        "s_suppkey (-∞, +∞)"
                    ],
                    "type" : "FullScan"
                }
            ]
        }
    ],
    "SimplifiedPlan" : {
        "PlanNodeId" : 0,
        "Plans" : [
            {
                "PlanNodeId" : 1,
                "Plans" : [
                    {
                        "PlanNodeId" : 2,
                        "Plans" : [
                            {
                                "PlanNodeId" : 4,
                                "Plans" : [
                                    {
                                        "PlanNodeId" : 5,
                                        "Plans" : [
                                            {
                                                "PlanNodeId" : 6,
                                                "Plans" : [
                                                    {
                                                        "PlanNodeId" : 8,
                                                        "Plans" : [
                                                            {
                                                                "PlanNodeId" : 9,
                                                                "Plans" : [
                                                                    {
                                                                        "PlanNodeId" : 10,
                                                                        "Plans" : [
                                                                            {
                                                                                "PlanNodeId" : 11,
                                                                                "Plans" : [
                                                                                    {
                                                                                        "PlanNodeId" : 12,
                                                                                        "Operators" : [
                                                                                            {
                                                                                                "Scan" : "Parallel",
                                                                                                "E-Size" : "32712192",
                                                                                                "ReadRanges" : [
                                                                                                    "ps_partkey (-∞, +∞)",
                                                                                                    "ps_suppkey (-∞, +∞)"
                                                                                                ],
                                                                                                "Name" : "TableFullScan",
                                                                                                "Path" : "/local/test_db/olap_yatests/tpch/s1/partsupp",
                                                                                                "E-Rows" : "800000",
                                                                                                "Table" : "olap_yatests/tpch/s1/partsupp",
                                                                                                "ReadColumns" : [
                                                                                                    "ps_partkey",
                                                                                                    "ps_suppkey",
                                                                                                    "ps_supplycost"
                                                                                                ],
                                                                                                "SsaProgram" : {
                                                                                                    "Command" : [
                                                                                                        {
                                                                                                            "Projection" : {
                                                                                                                "Columns" : [
                                                                                                                    {
                                                                                                                        "Id" : 3
                                                                                                                    },
                                                                                                                    {
                                                                                                                        "Id" : 4
                                                                                                                    },
                                                                                                                    {
                                                                                                                        "Id" : 5
                                                                                                                    }
                                                                                                                ]
                                                                                                            }
                                                                                                        }
                                                                                                    ]
                                                                                                },
                                                                                                "E-Cost" : "0"
                                                                                            }
                                                                                        ],
                                                                                        "Node Type" : "TableFullScan"
                                                                                    }
                                                                                ],
                                                                                "Node Type" : "HashShuffle (KeyColumns: [\"ps_suppkey\"], HashFunc: \"HashV1\")",
                                                                                "PlanNodeType" : "Connection"
                                                                            },
                                                                            {
                                                                                "PlanNodeId" : 13,
                                                                                "Plans" : [
                                                                                    {
                                                                                        "PlanNodeId" : 14,
                                                                                        "Plans" : [
                                                                                            {
                                                                                                "PlanNodeId" : 16,
                                                                                                "Operators" : [
                                                                                                    {
                                                                                                        "Scan" : "Parallel",
                                                                                                        "E-Size" : "1106680",
                                                                                                        "ReadRanges" : [
                                                                                                            "s_suppkey (-∞, +∞)"
                                                                                                        ],
                                                                                                        "Name" : "TableFullScan",
                                                                                                        "Path" : "/local/test_db/olap_yatests/tpch/s1/supplier",
                                                                                                        "E-Rows" : "10000",
                                                                                                        "Table" : "olap_yatests/tpch/s1/supplier",
                                                                                                        "ReadColumns" : [
                                                                                                            "s_acctbal",
                                                                                                            "s_address",
                                                                                                            "s_comment",
                                                                                                            "s_name",
                                                                                                            "s_nationkey",
                                                                                                            "s_phone",
                                                                                                            "s_suppkey"
                                                                                                        ],
                                                                                                        "SsaProgram" : {
                                                                                                            "Command" : [
                                                                                                                {
                                                                                                                    "Projection" : {
                                                                                                                        "Columns" : [
                                                                                                                            {
                                                                                                                                "Id" : 1
                                                                                                                            },
                                                                                                                            {
                                                                                                                                "Id" : 2
                                                                                                                            },
                                                                                                                            {
                                                                                                                                "Id" : 3
                                                                                                                            },
                                                                                                                            {
                                                                                                                                "Id" : 4
                                                                                                                            },
                                                                                                                            {
                                                                                                                                "Id" : 5
                                                                                                                            },
                                                                                                                            {
                                                                                                                                "Id" : 6
                                                                                                                            },
                                                                                                                            {
                                                                                                                                "Id" : 7
                                                                                                                            }
                                                                                                                        ]
                                                                                                                    }
                                                                                                                }
                                                                                                            ]
                                                                                                        },
                                                                                                        "E-Cost" : "0"
                                                                                                    }
                                                                                                ],
                                                                                                "Node Type" : "TableFullScan"
                                                                                            },
                                                                                            {
                                                                                                "PlanNodeId" : 20,
                                                                                                "Plans" : [
                                                                                                    {
                                                                                                        "PlanNodeId" : 21,
                                                                                                        "Operators" : [
                                                                                                            {
                                                                                                                "Scan" : "Parallel",
                                                                                                                "E-Size" : "1818",
                                                                                                                "ReadRanges" : [
                                                                                                                    "n_nationkey (-∞, +∞)"
                                                                                                                ],
                                                                                                                "Name" : "TableFullScan",
                                                                                                                "Path" : "/local/test_db/olap_yatests/tpch/s1/nation",
                                                                                                                "E-Rows" : "25",
                                                                                                                "Table" : "olap_yatests/tpch/s1/nation",
                                                                                                                "ReadColumns" : [
                                                                                                                    "n_name",
                                                                                                                    "n_nationkey",
                                                                                                                    "n_regionkey"
                                                                                                                ],
                                                                                                                "SsaProgram" : {
                                                                                                                    "Command" : [
                                                                                                                        {
                                                                                                                            "Projection" : {
                                                                                                                                "Columns" : [
                                                                                                                                    {
                                                                                                                                        "Id" : 2
                                                                                                                                    },
                                                                                                                                    {
                                                                                                                                        "Id" : 3
                                                                                                                                    },
                                                                                                                                    {
                                                                                                                                        "Id" : 4
                                                                                                                                    }
                                                                                                                                ]
                                                                                                                            }
                                                                                                                        }
                                                                                                                    ]
                                                                                                                },
                                                                                                                "E-Cost" : "0"
                                                                                                            }
                                                                                                        ],
                                                                                                        "Node Type" : "TableFullScan"
                                                                                                    },
                                                                                                    {
                                                                                                        "PlanNodeId" : 25,
                                                                                                        "Plans" : [
                                                                                                            {
                                                                                                                "PlanNodeId" : 26,
                                                                                                                "Operators" : [
                                                                                                                    {
                                                                                                                        "Scan" : "Parallel",
                                                                                                                        "E-Size" : "672",
                                                                                                                        "ReadRanges" : [
                                                                                                                            "r_regionkey (-∞, +∞)"
                                                                                                                        ],
                                                                                                                        "Name" : "TableFullScan",
                                                                                                                        "Path" : "/local/test_db/olap_yatests/tpch/s1/region",
                                                                                                                        "E-Rows" : "5",
                                                                                                                        "Table" : "olap_yatests/tpch/s1/region",
                                                                                                                        "ReadColumns" : [
                                                                                                                            "r_name",
                                                                                                                            "r_regionkey"
                                                                                                                        ],
                                                                                                                        "SsaProgram" : {
                                                                                                                            "Command" : [
                                                                                                                                {
                                                                                                                                    "Assign" : {
                                                                                                                                        "Constant" : {
                                                                                                                                            "Bytes" : "EUROPE"
                                                                                                                                        },
                                                                                                                                        "Column" : {
                                                                                                                                            "Id" : 4
                                                                                                                                        }
                                                                                                                                    }
                                                                                                                                },
                                                                                                                                {
                                                                                                                                    "Assign" : {
                                                                                                                                        "Function" : {
                                                                                                                                            "YqlOperationId" : 11,
                                                                                                                                            "KernelIdx" : 0,
                                                                                                                                            "FunctionType" : 2,
                                                                                                                                            "Arguments" : [
                                                                                                                                                {
                                                                                                                                                    "Id" : 2
                                                                                                                                                },
                                                                                                                                                {
                                                                                                                                                    "Id" : 4
                                                                                                                                                }
                                                                                                                                            ]
                                                                                                                                        },
                                                                                                                                        "Column" : {
                                                                                                                                            "Id" : 5
                                                                                                                                        }
                                                                                                                                    }
                                                                                                                                },
                                                                                                                                {
                                                                                                                                    "Filter" : {
                                                                                                                                        "Predicate" : {
                                                                                                                                            "Id" : 5
                                                                                                                                        }
                                                                                                                                    }
                                                                                                                                },
                                                                                                                                {
                                                                                                                                    "Projection" : {
                                                                                                                                        "Columns" : [
                                                                                                                                            {
                                                                                                                                                "Id" : 3
                                                                                                                                            }
                                                                                                                                        ]
                                                                                                                                    }
                                                                                                                                }
                                                                                                                            ]
                                                                                                                        },
                                                                                                                        "E-Cost" : "0"
                                                                                                                    }
                                                                                                                ],
                                                                                                                "Node Type" : "TableFullScan"
                                                                                                            }
                                                                                                        ],
                                                                                                        "Operators" : [
                                                                                                            {
                                                                                                                "E-Rows" : "0.5",
                                                                                                                "Predicate" : "r_name == \"EUROPE\"",
                                                                                                                "Pushdown" : "True",
                                                                                                                "Name" : "Filter",
                                                                                                                "E-Size" : "67.2",
                                                                                                                "E-Cost" : "0"
                                                                                                            }
                                                                                                        ],
                                                                                                        "Node Type" : "Filter"
                                                                                                    }
                                                                                                ],
                                                                                                "Operators" : [
                                                                                                    {
                                                                                                        "E-Rows" : "25",
                                                                                                        "Condition" : "n.n_regionkey = r.r_regionkey",
                                                                                                        "Name" : "LeftSemiJoin (MapJoin)",
                                                                                                        "E-Size" : "5178",
                                                                                                        "E-Cost" : "76.35"
                                                                                                    }
                                                                                                ],
                                                                                                "Node Type" : "LeftSemiJoin (MapJoin)"
                                                                                            }
                                                                                        ],
                                                                                        "Operators" : [
                                                                                            {
                                                                                                "E-Rows" : "10000",
                                                                                                "Condition" : "s_1.s_nationkey = n.n_nationkey",
                                                                                                "Name" : "LeftSemiJoin (MapJoin)",
                                                                                                "E-Size" : "3177880",
                                                                                                "E-Cost" : "30143.85"
                                                                                            }
                                                                                        ],
                                                                                        "Node Type" : "LeftSemiJoin (MapJoin)"
                                                                                    }
                                                                                ],
                                                                                "Node Type" : "HashShuffle (KeyColumns: [\"s_1.s_suppkey\"], HashFunc: \"HashV1\")",
                                                                                "PlanNodeType" : "Connection"
                                                                            }
                                                                        ],
                                                                        "Operators" : [
                                                                            {
                                                                                "E-Rows" : "800000",
                                                                                "Condition" : "ps.ps_suppkey = s_1.s_suppkey",
                                                                                "Name" : "LeftSemiJoin (Grace)",
                                                                                "E-Size" : "286942592",
                                                                                "E-Cost" : "2460143.85"
                                                                            }
                                                                        ],
                                                                        "Node Type" : "LeftSemiJoin (Grace)"
                                                                    }
                                                                ],
                                                                "Operators" : [
                                                                    {
                                                                        "GroupBy" : "[0]",
                                                                        "Aggregation" : "MIN",
                                                                        "Name" : "Aggregate",
                                                                        "Phase" : "Intermediate"
                                                                    }
                                                                ],
                                                                "Node Type" : "Aggregate"
                                                            }
                                                        ],
                                                        "Node Type" : "HashShuffle (KeyColumns: [\"ps.ps_partkey\"], HashFunc: \"HashV1\")",
                                                        "PlanNodeType" : "Connection"
                                                    }
                                                ],
                                                "Node Type" : "HashShuffle (KeyColumns: [\"ps.ps_partkey\",\"Min0\"], HashFunc: \"HashV1\")",
                                                "PlanNodeType" : "Connection"
                                            },
                                            {
                                                "PlanNodeId" : 27,
                                                "Plans" : [
                                                    {
                                                        "PlanNodeId" : 28,
                                                        "Plans" : [
                                                            {
                                                                "PlanNodeId" : 29,
                                                                "Plans" : [
                                                                    {
                                                                        "PlanNodeId" : 30,
                                                                        "Plans" : [
                                                                            {
                                                                                "PlanNodeId" : 31,
                                                                                "Plans" : [
                                                                                    {
                                                                                        "PlanNodeId" : 33,
                                                                                        "Operators" : [
                                                                                            {
                                                                                                "Scan" : "Parallel",
                                                                                                "E-Size" : "32712192",
                                                                                                "ReadRanges" : [
                                                                                                    "ps_partkey (-∞, +∞)",
                                                                                                    "ps_suppkey (-∞, +∞)"
                                                                                                ],
                                                                                                "Name" : "TableFullScan",
                                                                                                "Path" : "/local/test_db/olap_yatests/tpch/s1/partsupp",
                                                                                                "E-Rows" : "800000",
                                                                                                "Table" : "olap_yatests/tpch/s1/partsupp",
                                                                                                "ReadColumns" : [
                                                                                                    "ps_partkey",
                                                                                                    "ps_suppkey",
                                                                                                    "ps_supplycost"
                                                                                                ],
                                                                                                "SsaProgram" : {
                                                                                                    "Command" : [
                                                                                                        {
                                                                                                            "Projection" : {
                                                                                                                "Columns" : [
                                                                                                                    {
                                                                                                                        "Id" : 3
                                                                                                                    },
                                                                                                                    {
                                                                                                                        "Id" : 4
                                                                                                                    },
                                                                                                                    {
                                                                                                                        "Id" : 5
                                                                                                                    }
                                                                                                                ]
                                                                                                            }
                                                                                                        }
                                                                                                    ]
                                                                                                },
                                                                                                "E-Cost" : "0"
                                                                                            }
                                                                                        ],
                                                                                        "Node Type" : "TableFullScan"
                                                                                    },
                                                                                    {
                                                                                        "PlanNodeId" : 37,
                                                                                        "Plans" : [
                                                                                            {
                                                                                                "PlanNodeId" : 38,
                                                                                                "Operators" : [
                                                                                                    {
                                                                                                        "Scan" : "Parallel",
                                                                                                        "E-Size" : "8233560.889",
                                                                                                        "ReadRanges" : [
                                                                                                            "p_partkey (-∞, +∞)"
                                                                                                        ],
                                                                                                        "Name" : "TableFullScan",
                                                                                                        "Path" : "/local/test_db/olap_yatests/tpch/s1/part",
                                                                                                        "E-Rows" : "200000",
                                                                                                        "Table" : "olap_yatests/tpch/s1/part",
                                                                                                        "ReadColumns" : [
                                                                                                            "p_mfgr",
                                                                                                            "p_partkey",
                                                                                                            "p_size",
                                                                                                            "p_type"
                                                                                                        ],
                                                                                                        "SsaProgram" : {
                                                                                                            "Command" : [
                                                                                                                {
                                                                                                                    "Assign" : {
                                                                                                                        "Constant" : {
                                                                                                                            "Int32" : 15
                                                                                                                        },
                                                                                                                        "Column" : {
                                                                                                                            "Id" : 10
                                                                                                                        }
                                                                                                                    }
                                                                                                                },
                                                                                                                {
                                                                                                                    "Assign" : {
                                                                                                                        "Function" : {
                                                                                                                            "YqlOperationId" : 11,
                                                                                                                            "KernelIdx" : 0,
                                                                                                                            "FunctionType" : 2,
                                                                                                                            "Arguments" : [
                                                                                                                                {
                                                                                                                                    "Id" : 8
                                                                                                                                },
                                                                                                                                {
                                                                                                                                    "Id" : 10
                                                                                                                                }
                                                                                                                            ]
                                                                                                                        },
                                                                                                                        "Column" : {
                                                                                                                            "Id" : 11
                                                                                                                        }
                                                                                                                    }
                                                                                                                },
                                                                                                                {
                                                                                                                    "Filter" : {
                                                                                                                        "Predicate" : {
                                                                                                                            "Id" : 11
                                                                                                                        }
                                                                                                                    }
                                                                                                                },
                                                                                                                {
                                                                                                                    "Projection" : { }
                                                                                                                },
                                                                                                                {
                                                                                                                    "Assign" : {
                                                                                                                        "Constant" : {
                                                                                                                            "Bytes" : "BRASS"
                                                                                                                        },
                                                                                                                        "Column" : {
                                                                                                                            "Id" : 12
                                                                                                                        }
                                                                                                                    }
                                                                                                                },
                                                                                                                {
                                                                                                                    "Assign" : {
                                                                                                                        "Function" : {
                                                                                                                            "YqlOperationId" : 9,
                                                                                                                            "KernelIdx" : 1,
                                                                                                                            "FunctionType" : 2,
                                                                                                                            "Arguments" : [
                                                                                                                                {
                                                                                                                                    "Id" : 9
                                                                                                                                },
                                                                                                                                {
                                                                                                                                    "Id" : 12
                                                                                                                                }
                                                                                                                            ]
                                                                                                                        },
                                                                                                                        "Column" : {
                                                                                                                            "Id" : 13
                                                                                                                        }
                                                                                                                    }
                                                                                                                },
                                                                                                                {
                                                                                                                    "Filter" : {
                                                                                                                        "Predicate" : {
                                                                                                                            "Id" : 13
                                                                                                                        }
                                                                                                                    }
                                                                                                                },
                                                                                                                {
                                                                                                                    "Projection" : {
                                                                                                                        "Columns" : [
                                                                                                                            {
                                                                                                                                "Id" : 4
                                                                                                                            },
                                                                                                                            {
                                                                                                                                "Id" : 6
                                                                                                                            }
                                                                                                                        ]
                                                                                                                    }
                                                                                                                }
                                                                                                            ]
                                                                                                        },
                                                                                                        "E-Cost" : "0"
                                                                                                    }
                                                                                                ],
                                                                                                "Node Type" : "TableFullScan"
                                                                                            }
                                                                                        ],
                                                                                        "Operators" : [
                                                                                            {
                                                                                                "E-Rows" : "10000",
                                                                                                "Predicate" : "(p_size == 15) AND (p_type LIKE \"%BRASS\")",
                                                                                                "Pushdown" : "True",
                                                                                                "Name" : "Filter",
                                                                                                "E-Size" : "411678.0444",
                                                                                                "E-Cost" : "0"
                                                                                            }
                                                                                        ],
                                                                                        "Node Type" : "Filter"
                                                                                    }
                                                                                ],
                                                                                "Operators" : [
                                                                                    {
                                                                                        "E-Rows" : "400000",
                                                                                        "Condition" : "ps_1.ps_partkey = p.p_partkey",
                                                                                        "Name" : "InnerJoin (MapJoin)",
                                                                                        "E-Size" : "32823217.78",
                                                                                        "E-Cost" : "1827000"
                                                                                    }
                                                                                ],
                                                                                "Node Type" : "InnerJoin (MapJoin)"
                                                                            }
                                                                        ],
                                                                        "Node Type" : "HashShuffle (KeyColumns: [\"ps_1.ps_suppkey\"], HashFunc: \"HashV1\")",
                                                                        "PlanNodeType" : "Connection"
                                                                    },
                                                                    {
                                                                        "PlanNodeId" : 39,
                                                                        "Plans" : [
                                                                            {
                                                                                "PlanNodeId" : 40,
                                                                                "Operators" : [
                                                                                    {
                                                                                        "Scan" : "Parallel",
                                                                                        "E-Size" : "1106680",
                                                                                        "ReadRanges" : [
                                                                                            "s_suppkey (-∞, +∞)"
                                                                                        ],
                                                                                        "Name" : "TableFullScan",
                                                                                        "Path" : "/local/test_db/olap_yatests/tpch/s1/supplier",
                                                                                        "E-Rows" : "10000",
                                                                                        "Table" : "olap_yatests/tpch/s1/supplier",
                                                                                        "ReadColumns" : [
                                                                                            "s_acctbal",
                                                                                            "s_address",
                                                                                            "s_comment",
                                                                                            "s_name",
                                                                                            "s_nationkey",
                                                                                            "s_phone",
                                                                                            "s_suppkey"
                                                                                        ],
                                                                                        "SsaProgram" : {
                                                                                            "Command" : [
                                                                                                {
                                                                                                    "Projection" : {
                                                                                                        "Columns" : [
                                                                                                            {
                                                                                                                "Id" : 1
                                                                                                            },
                                                                                                            {
                                                                                                                "Id" : 2
                                                                                                            },
                                                                                                            {
                                                                                                                "Id" : 3
                                                                                                            },
                                                                                                            {
                                                                                                                "Id" : 4
                                                                                                            },
                                                                                                            {
                                                                                                                "Id" : 5
                                                                                                            },
                                                                                                            {
                                                                                                                "Id" : 6
                                                                                                            },
                                                                                                            {
                                                                                                                "Id" : 7
                                                                                                            }
                                                                                                        ]
                                                                                                    }
                                                                                                }
                                                                                            ]
                                                                                        },
                                                                                        "E-Cost" : "0"
                                                                                    }
                                                                                ],
                                                                                "Node Type" : "TableFullScan"
                                                                            }
                                                                        ],
                                                                        "Node Type" : "HashShuffle (KeyColumns: [\"s_suppkey\"], HashFunc: \"HashV1\")",
                                                                        "PlanNodeType" : "Connection"
                                                                    }
                                                                ],
                                                                "Operators" : [
                                                                    {
                                                                        "E-Rows" : "400000",
                                                                        "Condition" : "ps_1.ps_suppkey = s_1.s_suppkey",
                                                                        "Name" : "InnerJoin (Grace)",
                                                                        "E-Size" : "77090417.78",
                                                                        "E-Cost" : "3057000"
                                                                    }
                                                                ],
                                                                "Node Type" : "InnerJoin (Grace)"
                                                            },
                                                            {
                                                                "PlanNodeId" : 44,
                                                                "Plans" : [
                                                                    {
                                                                        "PlanNodeId" : 45,
                                                                        "Operators" : [
                                                                            {
                                                                                "Scan" : "Parallel",
                                                                                "E-Size" : "1818",
                                                                                "ReadRanges" : [
                                                                                    "n_nationkey (-∞, +∞)"
                                                                                ],
                                                                                "Name" : "TableFullScan",
                                                                                "Path" : "/local/test_db/olap_yatests/tpch/s1/nation",
                                                                                "E-Rows" : "25",
                                                                                "Table" : "olap_yatests/tpch/s1/nation",
                                                                                "ReadColumns" : [
                                                                                    "n_name",
                                                                                    "n_nationkey",
                                                                                    "n_regionkey"
                                                                                ],
                                                                                "SsaProgram" : {
                                                                                    "Command" : [
                                                                                        {
                                                                                            "Projection" : {
                                                                                                "Columns" : [
                                                                                                    {
                                                                                                        "Id" : 2
                                                                                                    },
                                                                                                    {
                                                                                                        "Id" : 3
                                                                                                    },
                                                                                                    {
                                                                                                        "Id" : 4
                                                                                                    }
                                                                                                ]
                                                                                            }
                                                                                        }
                                                                                    ]
                                                                                },
                                                                                "E-Cost" : "0"
                                                                            }
                                                                        ],
                                                                        "Node Type" : "TableFullScan"
                                                                    },
                                                                    {
                                                                        "PlanNodeId" : 49,
                                                                        "Plans" : [
                                                                            {
                                                                                "PlanNodeId" : 50,
                                                                                "Operators" : [
                                                                                    {
                                                                                        "Scan" : "Parallel",
                                                                                        "E-Size" : "672",
                                                                                        "ReadRanges" : [
                                                                                            "r_regionkey (-∞, +∞)"
                                                                                        ],
                                                                                        "Name" : "TableFullScan",
                                                                                        "Path" : "/local/test_db/olap_yatests/tpch/s1/region",
                                                                                        "E-Rows" : "5",
                                                                                        "Table" : "olap_yatests/tpch/s1/region",
                                                                                        "ReadColumns" : [
                                                                                            "r_name",
                                                                                            "r_regionkey"
                                                                                        ],
                                                                                        "SsaProgram" : {
                                                                                            "Command" : [
                                                                                                {
                                                                                                    "Assign" : {
                                                                                                        "Constant" : {
                                                                                                            "Bytes" : "EUROPE"
                                                                                                        },
                                                                                                        "Column" : {
                                                                                                            "Id" : 4
                                                                                                        }
                                                                                                    }
                                                                                                },
                                                                                                {
                                                                                                    "Assign" : {
                                                                                                        "Function" : {
                                                                                                            "YqlOperationId" : 11,
                                                                                                            "KernelIdx" : 0,
                                                                                                            "FunctionType" : 2,
                                                                                                            "Arguments" : [
                                                                                                                {
                                                                                                                    "Id" : 2
                                                                                                                },
                                                                                                                {
                                                                                                                    "Id" : 4
                                                                                                                }
                                                                                                            ]
                                                                                                        },
                                                                                                        "Column" : {
                                                                                                            "Id" : 5
                                                                                                        }
                                                                                                    }
                                                                                                },
                                                                                                {
                                                                                                    "Filter" : {
                                                                                                        "Predicate" : {
                                                                                                            "Id" : 5
                                                                                                        }
                                                                                                    }
                                                                                                },
                                                                                                {
                                                                                                    "Projection" : {
                                                                                                        "Columns" : [
                                                                                                            {
                                                                                                                "Id" : 3
                                                                                                            }
                                                                                                        ]
                                                                                                    }
                                                                                                }
                                                                                            ]
                                                                                        },
                                                                                        "E-Cost" : "0"
                                                                                    }
                                                                                ],
                                                                                "Node Type" : "TableFullScan"
                                                                            }
                                                                        ],
                                                                        "Operators" : [
                                                                            {
                                                                                "E-Rows" : "0.5",
                                                                                "Predicate" : "r_name == \"EUROPE\"",
                                                                                "Pushdown" : "True",
                                                                                "Name" : "Filter",
                                                                                "E-Size" : "67.2",
                                                                                "E-Cost" : "0"
                                                                            }
                                                                        ],
                                                                        "Node Type" : "Filter"
                                                                    }
                                                                ],
                                                                "Operators" : [
                                                                    {
                                                                        "E-Rows" : "25",
                                                                        "Condition" : "n.n_regionkey = r.r_regionkey",
                                                                        "Name" : "LeftSemiJoin (MapJoin)",
                                                                        "E-Size" : "5178",
                                                                        "E-Cost" : "76.35"
                                                                    }
                                                                ],
                                                                "Node Type" : "LeftSemiJoin (MapJoin)"
                                                            }
                                                        ],
                                                        "Operators" : [
                                                            {
                                                                "E-Rows" : "2000000",
                                                                "Condition" : "s_1.s_nationkey = n.n_nationkey",
                                                                "Name" : "InnerJoin (MapJoin)",
                                                                "E-Size" : "799692088.9",
                                                                "E-Cost" : "6657143.85"
                                                            }
                                                        ],
                                                        "Node Type" : "InnerJoin (MapJoin)"
                                                    }
                                                ],
                                                "Node Type" : "HashShuffle (KeyColumns: [\"ps_1.ps_partkey\",\"ps_1.ps_supplycost\"], HashFunc: \"HashV1\")",
                                                "PlanNodeType" : "Connection"
                                            }
                                        ],
                                        "Operators" : [
                                            {
                                                "E-Rows" : "3.2e+11",
                                                "Condition" : "m.Min0,m.ps.ps_partkey = ps_1.ps_partkey,ps_1.ps_supplycost",
                                                "Name" : "InnerJoin (Grace)",
                                                "E-Size" : "2.42727771e+14",
                                                "E-Cost" : "4.800163173e+11"
                                            }
                                        ],
                                        "Node Type" : "InnerJoin (Grace)"
                                    }
                                ],
                                "Operators" : [
                                    {
                                        "Name" : "TopSort",
                                        "Limit" : "100",
                                        "TopSortBy" : "[Arg.s_1.s_acctbal,Arg.n.n_name,Arg.s_1.s_name,Arg.ps_1.ps_partkey]"
                                    }
                                ],
                                "Node Type" : "TopSort"
                            }
                        ],
                        "Operators" : [
                            {
                                "Name" : "Limit",
                                "Limit" : "100"
                            }
                        ],
                        "Node Type" : "Limit"
                    }
                ],
                "Node Type" : "ResultSet",
                "PlanNodeType" : "ResultSet"
            }
        ],
        "Node Type" : "Query",
        "OptimizerStats" : {
            "EquiJoinsCount" : 3,
            "JoinsCount" : 10
        },
        "PlanNodeType" : "Query"
    }
}
