{
    "Plan" : {
        "Plans" : [
            {
                "PlanNodeId" : 17,
                "Plans" : [
                    {
                        "PlanNodeId" : 16,
                        "Plans" : [
                            {
                                "PlanNodeId" : 15,
                                "Plans" : [
                                    {
                                        "PlanNodeId" : 14,
                                        "Plans" : [
                                            {
                                                "PlanNodeId" : 13,
                                                "Plans" : [
                                                    {
                                                        "PlanNodeId" : 12,
                                                        "Subplan Name" : "CTE Aggregate_7",
                                                        "Plans" : [
                                                            {
                                                                "PlanNodeId" : 11,
                                                                "Plans" : [
                                                                    {
                                                                        "Tables" : [
                                                                            "olap_yatests/tpcds/s1/store_returns"
                                                                        ],
                                                                        "PlanNodeId" : 10,
                                                                        "Plans" : [
                                                                            {
                                                                                "PlanNodeId" : 9,
                                                                                "Plans" : [
                                                                                    {
                                                                                        "Tables" : [
                                                                                            "olap_yatests/tpcds/s1/date_dim"
                                                                                        ],
                                                                                        "PlanNodeId" : 8,
                                                                                        "Operators" : [
                                                                                            {
                                                                                                "Inputs" : [
                                                                                                    {
                                                                                                        "InternalOperatorId" : 1
                                                                                                    }
                                                                                                ],
                                                                                                "E-Rows" : "0",
                                                                                                "Predicate" : "d_year == 2000",
                                                                                                "Pushdown" : "True",
                                                                                                "Name" : "Filter",
                                                                                                "E-Size" : "0",
                                                                                                "E-Cost" : "0"
                                                                                            },
                                                                                            {
                                                                                                "Scan" : "Parallel",
                                                                                                "E-Size" : "0",
                                                                                                "ReadRanges" : [
                                                                                                    "d_date_sk (-∞, +∞)"
                                                                                                ],
                                                                                                "Name" : "TableFullScan",
                                                                                                "Inputs" : [ ],
                                                                                                "Path" : "/local/test_db/olap_yatests/tpcds/s1/date_dim",
                                                                                                "E-Rows" : "0",
                                                                                                "Table" : "olap_yatests/tpcds/s1/date_dim",
                                                                                                "ReadColumns" : [
                                                                                                    "d_date_sk",
                                                                                                    "d_year"
                                                                                                ],
                                                                                                "SsaProgram" : {
                                                                                                    "Version" : 5,
                                                                                                    "Command" : [
                                                                                                        {
                                                                                                            "Assign" : {
                                                                                                                "Constant" : {
                                                                                                                    "Int32" : 2000
                                                                                                                },
                                                                                                                "Column" : {
                                                                                                                    "Id" : 29
                                                                                                                }
                                                                                                            }
                                                                                                        },
                                                                                                        {
                                                                                                            "Assign" : {
                                                                                                                "Function" : {
                                                                                                                    "YqlOperationId" : 11,
                                                                                                                    "KernelIdx" : 0,
                                                                                                                    "FunctionType" : 2,
                                                                                                                    "Arguments" : [
                                                                                                                        {
                                                                                                                            "Id" : 7
                                                                                                                        },
                                                                                                                        {
                                                                                                                            "Id" : 29
                                                                                                                        }
                                                                                                                    ]
                                                                                                                },
                                                                                                                "Column" : {
                                                                                                                    "Id" : 30
                                                                                                                }
                                                                                                            }
                                                                                                        },
                                                                                                        {
                                                                                                            "Assign" : {
                                                                                                                "Constant" : {
                                                                                                                    "Uint8" : 0
                                                                                                                },
                                                                                                                "Column" : {
                                                                                                                    "Id" : 31
                                                                                                                }
                                                                                                            }
                                                                                                        },
                                                                                                        {
                                                                                                            "Assign" : {
                                                                                                                "Function" : {
                                                                                                                    "YqlOperationId" : 17,
                                                                                                                    "KernelIdx" : 1,
                                                                                                                    "FunctionType" : 2,
                                                                                                                    "Arguments" : [
                                                                                                                        {
                                                                                                                            "Id" : 30
                                                                                                                        },
                                                                                                                        {
                                                                                                                            "Id" : 31
                                                                                                                        }
                                                                                                                    ]
                                                                                                                },
                                                                                                                "Column" : {
                                                                                                                    "Id" : 32
                                                                                                                }
                                                                                                            }
                                                                                                        },
                                                                                                        {
                                                                                                            "Filter" : {
                                                                                                                "Predicate" : {
                                                                                                                    "Id" : 32
                                                                                                                }
                                                                                                            }
                                                                                                        },
                                                                                                        {
                                                                                                            "Projection" : {
                                                                                                                "Columns" : [
                                                                                                                    {
                                                                                                                        "Id" : 1
                                                                                                                    }
                                                                                                                ]
                                                                                                            }
                                                                                                        }
                                                                                                    ]
                                                                                                },
                                                                                                "E-Cost" : "0"
                                                                                            }
                                                                                        ],
                                                                                        "Node Type" : "Filter-TableFullScan",
                                                                                        "Stats" : {
                                                                                            "UseLlvm" : "undefined",
                                                                                            "Output" : [
                                                                                                {
                                                                                                    "Pop" : { },
                                                                                                    "Name" : "10",
                                                                                                    "Push" : {
                                                                                                        "WaitTimeUs" : {
                                                                                                            "Count" : 1,
                                                                                                            "Sum" : 451540,
                                                                                                            "Max" : 451540,
                                                                                                            "Min" : 451540
                                                                                                        }
                                                                                                    }
                                                                                                }
                                                                                            ],
                                                                                            "MaxMemoryUsage" : {
                                                                                                "Count" : 1,
                                                                                                "Sum" : 65536,
                                                                                                "Max" : 65536,
                                                                                                "Min" : 65536
                                                                                            },
                                                                                            "Tasks" : 1,
                                                                                            "FinishedTasks" : 1,
                                                                                            "PhysicalStageId" : 0,
                                                                                            "StageDurationUs" : 0,
                                                                                            "Table" : [
                                                                                                {
                                                                                                    "Path" : "/local/test_db/olap_yatests/tpcds/s1/date_dim"
                                                                                                }
                                                                                            ],
                                                                                            "BaseTimeMs" : 1765530690080,
                                                                                            "CpuTimeUs" : {
                                                                                                "Count" : 1,
                                                                                                "Sum" : 1338,
                                                                                                "Max" : 1338,
                                                                                                "Min" : 1338
                                                                                            },
                                                                                            "Ingress" : [
                                                                                                {
                                                                                                    "Pop" : { },
                                                                                                    "External" : { },
                                                                                                    "Name" : "CS",
                                                                                                    "Ingress" : { },
                                                                                                    "Push" : { }
                                                                                                }
                                                                                            ],
                                                                                            "UpdateTimeMs" : 481
                                                                                        }
                                                                                    }
                                                                                ],
                                                                                "Node Type" : "Broadcast",
                                                                                "PlanNodeType" : "Connection"
                                                                            }
                                                                        ],
                                                                        "Operators" : [
                                                                            {
                                                                                "Inputs" : [
                                                                                    {
                                                                                        "InternalOperatorId" : 1
                                                                                    }
                                                                                ],
                                                                                "GroupBy" : "[item.a.sr_customer_sk,item.a.sr_store_sk]",
                                                                                "Aggregation" : "{SUM(item.a.sr_return_amt)}",
                                                                                "Name" : "Aggregate",
                                                                                "Phase" : "Intermediate"
                                                                            },
                                                                            {
                                                                                "Inputs" : [
                                                                                    {
                                                                                        "InternalOperatorId" : 2
                                                                                    },
                                                                                    {
                                                                                        "ExternalPlanNodeId" : 9
                                                                                    }
                                                                                ],
                                                                                "E-Rows" : "0",
                                                                                "Condition" : "a.sr_returned_date_sk = b.d_date_sk",
                                                                                "Name" : "InnerJoin (MapJoin)",
                                                                                "E-Size" : "0",
                                                                                "E-Cost" : "0"
                                                                            },
                                                                            {
                                                                                "Inputs" : [
                                                                                    {
                                                                                        "InternalOperatorId" : 3
                                                                                    }
                                                                                ],
                                                                                "E-Rows" : "0",
                                                                                "Predicate" : "Exist(item.sr_returned_date_sk)",
                                                                                "Name" : "Filter",
                                                                                "E-Size" : "0",
                                                                                "E-Cost" : "0"
                                                                            },
                                                                            {
                                                                                "Scan" : "Parallel",
                                                                                "E-Size" : "0",
                                                                                "ReadRanges" : [
                                                                                    "sr_item_sk (-∞, +∞)",
                                                                                    "sr_ticket_number (-∞, +∞)"
                                                                                ],
                                                                                "Name" : "TableFullScan",
                                                                                "Inputs" : [ ],
                                                                                "Path" : "/local/test_db/olap_yatests/tpcds/s1/store_returns",
                                                                                "E-Rows" : "0",
                                                                                "Table" : "olap_yatests/tpcds/s1/store_returns",
                                                                                "ReadColumns" : [
                                                                                    "sr_customer_sk",
                                                                                    "sr_return_amt",
                                                                                    "sr_returned_date_sk",
                                                                                    "sr_store_sk"
                                                                                ],
                                                                                "SsaProgram" : {
                                                                                    "Version" : 5,
                                                                                    "Command" : [
                                                                                        {
                                                                                            "Projection" : {
                                                                                                "Columns" : [
                                                                                                    {
                                                                                                        "Id" : 4
                                                                                                    },
                                                                                                    {
                                                                                                        "Id" : 12
                                                                                                    },
                                                                                                    {
                                                                                                        "Id" : 1
                                                                                                    },
                                                                                                    {
                                                                                                        "Id" : 8
                                                                                                    }
                                                                                                ]
                                                                                            }
                                                                                        }
                                                                                    ]
                                                                                },
                                                                                "E-Cost" : "0"
                                                                            }
                                                                        ],
                                                                        "Node Type" : "Aggregate-InnerJoin (MapJoin)-Filter-TableFullScan",
                                                                        "Stats" : {
                                                                            "Operator" : [
                                                                                {
                                                                                    "Id" : "0",
                                                                                    "Type" : "Filter"
                                                                                },
                                                                                {
                                                                                    "Id" : "0",
                                                                                    "Type" : "Aggregation"
                                                                                }
                                                                            ],
                                                                            "UseLlvm" : "undefined",
                                                                            "Output" : [
                                                                                {
                                                                                    "Pop" : { },
                                                                                    "Name" : "12",
                                                                                    "Push" : {
                                                                                        "WaitTimeUs" : {
                                                                                            "Count" : 3,
                                                                                            "Sum" : 1385188,
                                                                                            "Max" : 469167,
                                                                                            "Min" : 457922
                                                                                        }
                                                                                    }
                                                                                }
                                                                            ],
                                                                            "DurationUs" : {
                                                                                "Count" : 2,
                                                                                "Sum" : 6000,
                                                                                "Max" : 3000,
                                                                                "Min" : 3000
                                                                            },
                                                                            "MaxMemoryUsage" : {
                                                                                "Count" : 3,
                                                                                "Sum" : 6291456,
                                                                                "Max" : 2097152,
                                                                                "Min" : 2097152
                                                                            },
                                                                            "Tasks" : 3,
                                                                            "FinishedTasks" : 3,
                                                                            "PhysicalStageId" : 1,
                                                                            "StageDurationUs" : 3000,
                                                                            "Table" : [
                                                                                {
                                                                                    "Path" : "/local/test_db/olap_yatests/tpcds/s1/store_returns"
                                                                                }
                                                                            ],
                                                                            "BaseTimeMs" : 1765530690080,
                                                                            "CpuTimeUs" : {
                                                                                "Count" : 3,
                                                                                "Sum" : 7937,
                                                                                "Max" : 2867,
                                                                                "Min" : 2413
                                                                            },
                                                                            "Ingress" : [
                                                                                {
                                                                                    "Pop" : { },
                                                                                    "External" : { },
                                                                                    "Name" : "CS",
                                                                                    "Ingress" : { },
                                                                                    "Push" : { }
                                                                                }
                                                                            ],
                                                                            "UpdateTimeMs" : 484,
                                                                            "Input" : [
                                                                                {
                                                                                    "Pop" : { },
                                                                                    "Name" : "8",
                                                                                    "Push" : {
                                                                                        "WaitTimeUs" : {
                                                                                            "Count" : 3,
                                                                                            "Sum" : 1383716,
                                                                                            "Max" : 468638,
                                                                                            "Min" : 457439
                                                                                        }
                                                                                    }
                                                                                }
                                                                            ]
                                                                        }
                                                                    }
                                                                ],
                                                                "Node Type" : "HashShuffle",
                                                                "KeyColumns" : [
                                                                    "a.sr_customer_sk",
                                                                    "a.sr_store_sk"
                                                                ],
                                                                "PlanNodeType" : "Connection"
                                                            }
                                                        ],
                                                        "Operators" : [
                                                            {
                                                                "Inputs" : [
                                                                    {
                                                                        "ExternalPlanNodeId" : 11
                                                                    }
                                                                ],
                                                                "Name" : "Aggregate",
                                                                "Phase" : "Final"
                                                            }
                                                        ],
                                                        "Node Type" : "Aggregate",
                                                        "Parent Relationship" : "InitPlan",
                                                        "Stats" : {
                                                            "Operator" : [
                                                                {
                                                                    "Id" : "0",
                                                                    "Type" : "Aggregation"
                                                                }
                                                            ],
                                                            "UseLlvm" : "undefined",
                                                            "Output" : [
                                                                {
                                                                    "Pop" : { },
                                                                    "Name" : "6",
                                                                    "Push" : {
                                                                        "WaitTimeUs" : {
                                                                            "Count" : 2,
                                                                            "Sum" : 936616,
                                                                            "Max" : 468571,
                                                                            "Min" : 468045
                                                                        }
                                                                    }
                                                                },
                                                                {
                                                                    "Pop" : { },
                                                                    "Name" : "14",
                                                                    "Push" : {
                                                                        "WaitTimeUs" : {
                                                                            "Count" : 2,
                                                                            "Sum" : 936550,
                                                                            "Max" : 468556,
                                                                            "Min" : 467994
                                                                        }
                                                                    }
                                                                }
                                                            ],
                                                            "DurationUs" : {
                                                                "Count" : 2,
                                                                "Sum" : 2000,
                                                                "Max" : 1000,
                                                                "Min" : 1000
                                                            },
                                                            "MaxMemoryUsage" : {
                                                                "Count" : 2,
                                                                "Sum" : 4194304,
                                                                "Max" : 2097152,
                                                                "Min" : 2097152
                                                            },
                                                            "Tasks" : 2,
                                                            "FinishedTasks" : 2,
                                                            "PhysicalStageId" : 2,
                                                            "StageDurationUs" : 1000,
                                                            "BaseTimeMs" : 1765530690080,
                                                            "CpuTimeUs" : {
                                                                "Count" : 2,
                                                                "Sum" : 795,
                                                                "Max" : 497,
                                                                "Min" : 298
                                                            },
                                                            "UpdateTimeMs" : 482,
                                                            "Input" : [
                                                                {
                                                                    "Pop" : { },
                                                                    "Name" : "10",
                                                                    "Push" : {
                                                                        "WaitTimeUs" : {
                                                                            "Count" : 2,
                                                                            "Sum" : 936453,
                                                                            "Max" : 468480,
                                                                            "Min" : 467973
                                                                        }
                                                                    }
                                                                }
                                                            ]
                                                        }
                                                    }
                                                ],
                                                "Node Type" : "Map",
                                                "PlanNodeType" : "Connection"
                                            },
                                            {
                                                "PlanNodeId" : 7,
                                                "Plans" : [
                                                    {
                                                        "PlanNodeId" : 6,
                                                        "Plans" : [
                                                            {
                                                                "PlanNodeId" : 5,
                                                                "Node Type" : "HashShuffle",
                                                                "KeyColumns" : [
                                                                    "ctr_store_sk"
                                                                ],
                                                                "PlanNodeType" : "Connection",
                                                                "CTE Name" : "Aggregate_7"
                                                            }
                                                        ],
                                                        "Operators" : [
                                                            {
                                                                "Inputs" : [
                                                                    {
                                                                        "ExternalPlanNodeId" : 5
                                                                    }
                                                                ],
                                                                "Name" : "Aggregate",
                                                                "Phase" : "Final"
                                                            }
                                                        ],
                                                        "Node Type" : "Aggregate",
                                                        "Stats" : {
                                                            "Operator" : [
                                                                {
                                                                    "Id" : "0",
                                                                    "Type" : "Aggregation"
                                                                }
                                                            ],
                                                            "UseLlvm" : "undefined",
                                                            "Output" : [
                                                                {
                                                                    "Pop" : { },
                                                                    "Name" : "14",
                                                                    "Push" : {
                                                                        "WaitTimeUs" : {
                                                                            "Count" : 2,
                                                                            "Sum" : 928870,
                                                                            "Max" : 467677,
                                                                            "Min" : 461193
                                                                        }
                                                                    }
                                                                }
                                                            ],
                                                            "MaxMemoryUsage" : {
                                                                "Count" : 2,
                                                                "Sum" : 4194304,
                                                                "Max" : 2097152,
                                                                "Min" : 2097152
                                                            },
                                                            "Tasks" : 2,
                                                            "FinishedTasks" : 2,
                                                            "PhysicalStageId" : 3,
                                                            "StageDurationUs" : 0,
                                                            "BaseTimeMs" : 1765530690080,
                                                            "CpuTimeUs" : {
                                                                "Count" : 2,
                                                                "Sum" : 705,
                                                                "Max" : 361,
                                                                "Min" : 344
                                                            },
                                                            "UpdateTimeMs" : 483,
                                                            "Input" : [
                                                                {
                                                                    "Pop" : { },
                                                                    "Name" : "12",
                                                                    "Push" : {
                                                                        "WaitTimeUs" : {
                                                                            "Count" : 2,
                                                                            "Sum" : 928906,
                                                                            "Max" : 467695,
                                                                            "Min" : 461211
                                                                        }
                                                                    }
                                                                }
                                                            ]
                                                        }
                                                    }
                                                ],
                                                "Node Type" : "Broadcast",
                                                "PlanNodeType" : "Connection"
                                            },
                                            {
                                                "PlanNodeId" : 4,
                                                "Plans" : [
                                                    {
                                                        "Tables" : [
                                                            "olap_yatests/tpcds/s1/store"
                                                        ],
                                                        "PlanNodeId" : 3,
                                                        "Operators" : [
                                                            {
                                                                "Inputs" : [
                                                                    {
                                                                        "InternalOperatorId" : 1
                                                                    }
                                                                ],
                                                                "E-Rows" : "0",
                                                                "Predicate" : "s_state == \"TN\"",
                                                                "Pushdown" : "True",
                                                                "Name" : "Filter",
                                                                "E-Size" : "0",
                                                                "E-Cost" : "0"
                                                            },
                                                            {
                                                                "Scan" : "Parallel",
                                                                "E-Size" : "0",
                                                                "ReadRanges" : [
                                                                    "s_store_sk (-∞, +∞)"
                                                                ],
                                                                "Name" : "TableFullScan",
                                                                "Inputs" : [ ],
                                                                "Path" : "/local/test_db/olap_yatests/tpcds/s1/store",
                                                                "E-Rows" : "0",
                                                                "Table" : "olap_yatests/tpcds/s1/store",
                                                                "ReadColumns" : [
                                                                    "s_state",
                                                                    "s_store_sk"
                                                                ],
                                                                "SsaProgram" : {
                                                                    "Version" : 5,
                                                                    "Command" : [
                                                                        {
                                                                            "Assign" : {
                                                                                "Constant" : {
                                                                                    "Bytes" : "TN"
                                                                                },
                                                                                "Column" : {
                                                                                    "Id" : 30
                                                                                }
                                                                            }
                                                                        },
                                                                        {
                                                                            "Assign" : {
                                                                                "Function" : {
                                                                                    "YqlOperationId" : 11,
                                                                                    "KernelIdx" : 0,
                                                                                    "FunctionType" : 2,
                                                                                    "Arguments" : [
                                                                                        {
                                                                                            "Id" : 25
                                                                                        },
                                                                                        {
                                                                                            "Id" : 30
                                                                                        }
                                                                                    ]
                                                                                },
                                                                                "Column" : {
                                                                                    "Id" : 31
                                                                                }
                                                                            }
                                                                        },
                                                                        {
                                                                            "Assign" : {
                                                                                "Constant" : {
                                                                                    "Uint8" : 0
                                                                                },
                                                                                "Column" : {
                                                                                    "Id" : 32
                                                                                }
                                                                            }
                                                                        },
                                                                        {
                                                                            "Assign" : {
                                                                                "Function" : {
                                                                                    "YqlOperationId" : 17,
                                                                                    "KernelIdx" : 1,
                                                                                    "FunctionType" : 2,
                                                                                    "Arguments" : [
                                                                                        {
                                                                                            "Id" : 31
                                                                                        },
                                                                                        {
                                                                                            "Id" : 32
                                                                                        }
                                                                                    ]
                                                                                },
                                                                                "Column" : {
                                                                                    "Id" : 33
                                                                                }
                                                                            }
                                                                        },
                                                                        {
                                                                            "Filter" : {
                                                                                "Predicate" : {
                                                                                    "Id" : 33
                                                                                }
                                                                            }
                                                                        },
                                                                        {
                                                                            "Projection" : {
                                                                                "Columns" : [
                                                                                    {
                                                                                        "Id" : 1
                                                                                    }
                                                                                ]
                                                                            }
                                                                        }
                                                                    ]
                                                                },
                                                                "E-Cost" : "0"
                                                            }
                                                        ],
                                                        "Node Type" : "Filter-TableFullScan",
                                                        "Stats" : {
                                                            "UseLlvm" : "undefined",
                                                            "Output" : [
                                                                {
                                                                    "Pop" : { },
                                                                    "Name" : "14",
                                                                    "Push" : {
                                                                        "WaitTimeUs" : {
                                                                            "Count" : 1,
                                                                            "Sum" : 456474,
                                                                            "Max" : 456474,
                                                                            "Min" : 456474
                                                                        }
                                                                    }
                                                                }
                                                            ],
                                                            "MaxMemoryUsage" : {
                                                                "Count" : 1,
                                                                "Sum" : 65536,
                                                                "Max" : 65536,
                                                                "Min" : 65536
                                                            },
                                                            "Tasks" : 1,
                                                            "FinishedTasks" : 1,
                                                            "PhysicalStageId" : 4,
                                                            "StageDurationUs" : 0,
                                                            "Table" : [
                                                                {
                                                                    "Path" : "/local/test_db/olap_yatests/tpcds/s1/store"
                                                                }
                                                            ],
                                                            "BaseTimeMs" : 1765530690080,
                                                            "CpuTimeUs" : {
                                                                "Count" : 1,
                                                                "Sum" : 5855,
                                                                "Max" : 5855,
                                                                "Min" : 5855
                                                            },
                                                            "Ingress" : [
                                                                {
                                                                    "Pop" : { },
                                                                    "External" : { },
                                                                    "Name" : "CS",
                                                                    "Ingress" : { },
                                                                    "Push" : { }
                                                                }
                                                            ],
                                                            "UpdateTimeMs" : 484
                                                        }
                                                    }
                                                ],
                                                "Node Type" : "Broadcast",
                                                "PlanNodeType" : "Connection"
                                            },
                                            {
                                                "PlanNodeId" : 2,
                                                "Plans" : [
                                                    {
                                                        "Tables" : [
                                                            "olap_yatests/tpcds/s1/customer"
                                                        ],
                                                        "PlanNodeId" : 1,
                                                        "Operators" : [
                                                            {
                                                                "Scan" : "Parallel",
                                                                "E-Size" : "0",
                                                                "ReadRanges" : [
                                                                    "c_customer_sk (-∞, +∞)"
                                                                ],
                                                                "Name" : "TableFullScan",
                                                                "Inputs" : [ ],
                                                                "Path" : "/local/test_db/olap_yatests/tpcds/s1/customer",
                                                                "E-Rows" : "0",
                                                                "Table" : "olap_yatests/tpcds/s1/customer",
                                                                "ReadColumns" : [
                                                                    "c_customer_id",
                                                                    "c_customer_sk"
                                                                ],
                                                                "SsaProgram" : {
                                                                    "Version" : 5,
                                                                    "Command" : [
                                                                        {
                                                                            "Projection" : {
                                                                                "Columns" : [
                                                                                    {
                                                                                        "Id" : 2
                                                                                    },
                                                                                    {
                                                                                        "Id" : 1
                                                                                    }
                                                                                ]
                                                                            }
                                                                        }
                                                                    ]
                                                                },
                                                                "E-Cost" : "0"
                                                            }
                                                        ],
                                                        "Node Type" : "TableFullScan",
                                                        "Stats" : {
                                                            "UseLlvm" : "undefined",
                                                            "Output" : [
                                                                {
                                                                    "Pop" : { },
                                                                    "Name" : "14",
                                                                    "Push" : {
                                                                        "WaitTimeUs" : {
                                                                            "Count" : 1,
                                                                            "Sum" : 453861,
                                                                            "Max" : 453861,
                                                                            "Min" : 453861
                                                                        }
                                                                    }
                                                                }
                                                            ],
                                                            "MaxMemoryUsage" : {
                                                                "Count" : 1,
                                                                "Sum" : 65536,
                                                                "Max" : 65536,
                                                                "Min" : 65536
                                                            },
                                                            "Tasks" : 1,
                                                            "FinishedTasks" : 1,
                                                            "PhysicalStageId" : 5,
                                                            "StageDurationUs" : 0,
                                                            "Table" : [
                                                                {
                                                                    "Path" : "/local/test_db/olap_yatests/tpcds/s1/customer"
                                                                }
                                                            ],
                                                            "BaseTimeMs" : 1765530690080,
                                                            "CpuTimeUs" : {
                                                                "Count" : 1,
                                                                "Sum" : 1424,
                                                                "Max" : 1424,
                                                                "Min" : 1424
                                                            },
                                                            "Ingress" : [
                                                                {
                                                                    "Pop" : { },
                                                                    "External" : { },
                                                                    "Name" : "CS",
                                                                    "Ingress" : { },
                                                                    "Push" : { }
                                                                }
                                                            ],
                                                            "UpdateTimeMs" : 480
                                                        }
                                                    }
                                                ],
                                                "Node Type" : "Broadcast",
                                                "PlanNodeType" : "Connection"
                                            }
                                        ],
                                        "Operators" : [
                                            {
                                                "Inputs" : [
                                                    {
                                                        "InternalOperatorId" : 1
                                                    }
                                                ],
                                                "Name" : "TopSort",
                                                "Limit" : "100",
                                                "TopSortBy" : "row.c_customer_id"
                                            },
                                            {
                                                "Inputs" : [
                                                    {
                                                        "InternalOperatorId" : 2
                                                    }
                                                ],
                                                "E-Rows" : "0",
                                                "Predicate" : "item.ctr1.ctr_total_return > item.ctr2.Avg0 * \"1.2\"",
                                                "Name" : "Filter",
                                                "E-Size" : "0",
                                                "E-Cost" : "0"
                                            },
                                            {
                                                "Inputs" : [
                                                    {
                                                        "InternalOperatorId" : 3
                                                    },
                                                    {
                                                        "ExternalPlanNodeId" : 2
                                                    }
                                                ],
                                                "E-Rows" : "0",
                                                "Condition" : "ctr1.ctr_customer_sk = olap_yatests/tpcds/s1/customer.c_customer_sk",
                                                "Name" : "InnerJoin (MapJoin)",
                                                "E-Size" : "0",
                                                "E-Cost" : "0"
                                            },
                                            {
                                                "Inputs" : [
                                                    {
                                                        "InternalOperatorId" : 4
                                                    }
                                                ],
                                                "E-Rows" : "0",
                                                "Predicate" : "Exist(item.ctr1.ctr_customer_sk)",
                                                "Name" : "Filter",
                                                "E-Size" : "0",
                                                "E-Cost" : "0"
                                            },
                                            {
                                                "Inputs" : [
                                                    {
                                                        "InternalOperatorId" : 5
                                                    },
                                                    {
                                                        "ExternalPlanNodeId" : 4
                                                    }
                                                ],
                                                "E-Rows" : "0",
                                                "Condition" : "ctr1.ctr_store_sk = olap_yatests/tpcds/s1/store.s_store_sk",
                                                "Name" : "InnerJoin (MapJoin)",
                                                "E-Size" : "0",
                                                "E-Cost" : "0"
                                            },
                                            {
                                                "Inputs" : [
                                                    {
                                                        "InternalOperatorId" : 6
                                                    }
                                                ],
                                                "E-Rows" : "0",
                                                "Predicate" : "Exist(item.ctr1.ctr_store_sk)",
                                                "Name" : "Filter",
                                                "E-Size" : "0",
                                                "E-Cost" : "0"
                                            },
                                            {
                                                "Inputs" : [
                                                    {
                                                        "InternalOperatorId" : 7
                                                    },
                                                    {
                                                        "ExternalPlanNodeId" : 7
                                                    }
                                                ],
                                                "E-Rows" : "0",
                                                "Condition" : "ctr1.ctr_store_sk = ctr2.ctr_store_sk",
                                                "Name" : "InnerJoin (MapJoin)",
                                                "E-Size" : "0",
                                                "E-Cost" : "0"
                                            },
                                            {
                                                "Inputs" : [
                                                    {
                                                        "ExternalPlanNodeId" : 13
                                                    }
                                                ],
                                                "E-Rows" : "0",
                                                "Predicate" : "Exist(item.ctr_store_sk)",
                                                "Name" : "Filter",
                                                "E-Size" : "0",
                                                "E-Cost" : "0"
                                            }
                                        ],
                                        "Node Type" : "TopSort-Filter-InnerJoin (MapJoin)-Filter-InnerJoin (MapJoin)-Filter-InnerJoin (MapJoin)-Filter",
                                        "Stats" : {
                                            "UseLlvm" : "undefined",
                                            "DurationUs" : {
                                                "Count" : 2,
                                                "Sum" : 12000,
                                                "Max" : 6000,
                                                "Min" : 6000
                                            },
                                            "Output" : [
                                                {
                                                    "Pop" : { },
                                                    "Name" : "16",
                                                    "Push" : {
                                                        "WaitTimeUs" : {
                                                            "Count" : 2,
                                                            "Sum" : 911697,
                                                            "Max" : 456578,
                                                            "Min" : 455119
                                                        }
                                                    }
                                                }
                                            ],
                                            "MaxMemoryUsage" : {
                                                "Count" : 2,
                                                "Sum" : 2097152,
                                                "Max" : 1048576,
                                                "Min" : 1048576
                                            },
                                            "Tasks" : 2,
                                            "FinishedTasks" : 2,
                                            "PhysicalStageId" : 6,
                                            "StageDurationUs" : 6000,
                                            "BaseTimeMs" : 1765530690080,
                                            "WaitInputTimeUs" : {
                                                "Count" : 2,
                                                "Sum" : 7486,
                                                "Max" : 3803,
                                                "Min" : 3683
                                            },
                                            "CpuTimeUs" : {
                                                "Count" : 2,
                                                "Sum" : 733,
                                                "Max" : 367,
                                                "Min" : 366
                                            },
                                            "UpdateTimeMs" : 485,
                                            "Input" : [
                                                {
                                                    "Pop" : { },
                                                    "Name" : "1",
                                                    "Push" : {
                                                        "WaitTimeUs" : {
                                                            "Count" : 2,
                                                            "Sum" : 903890,
                                                            "Max" : 452621,
                                                            "Min" : 451269
                                                        }
                                                    }
                                                },
                                                {
                                                    "Pop" : { },
                                                    "Name" : "3",
                                                    "Push" : {
                                                        "WaitTimeUs" : {
                                                            "Count" : 2,
                                                            "Sum" : 7409,
                                                            "Max" : 3781,
                                                            "Min" : 3628
                                                        }
                                                    }
                                                },
                                                {
                                                    "Pop" : { },
                                                    "Name" : "6",
                                                    "Push" : { }
                                                },
                                                {
                                                    "Pop" : { },
                                                    "Name" : "12",
                                                    "Push" : { }
                                                }
                                            ]
                                        }
                                    }
                                ],
                                "Node Type" : "Merge",
                                "SortColumns" : [
                                    "c_customer_id (Asc)"
                                ],
                                "PlanNodeType" : "Connection"
                            }
                        ],
                        "Operators" : [
                            {
                                "Inputs" : [
                                    {
                                        "ExternalPlanNodeId" : 15
                                    }
                                ],
                                "Name" : "Limit",
                                "Limit" : "100"
                            }
                        ],
                        "Node Type" : "Limit",
                        "Stats" : {
                            "UseLlvm" : "undefined",
                            "Output" : [
                                {
                                    "Pop" : { },
                                    "Name" : "RESULT",
                                    "Push" : {
                                        "WaitTimeUs" : {
                                            "Count" : 1,
                                            "Sum" : 456970,
                                            "Max" : 456970,
                                            "Min" : 456970
                                        }
                                    }
                                }
                            ],
                            "MaxMemoryUsage" : {
                                "Count" : 1,
                                "Sum" : 65536,
                                "Max" : 65536,
                                "Min" : 65536
                            },
                            "Tasks" : 1,
                            "FinishedTasks" : 1,
                            "PhysicalStageId" : 7,
                            "StageDurationUs" : 0,
                            "BaseTimeMs" : 1765530690080,
                            "CpuTimeUs" : {
                                "Count" : 1,
                                "Sum" : 117,
                                "Max" : 117,
                                "Min" : 117
                            },
                            "UpdateTimeMs" : 485,
                            "Input" : [
                                {
                                    "Pop" : { },
                                    "Name" : "14",
                                    "Push" : {
                                        "WaitTimeUs" : {
                                            "Count" : 1,
                                            "Sum" : 228488,
                                            "Max" : 228488,
                                            "Min" : 228488
                                        }
                                    }
                                }
                            ]
                        }
                    }
                ],
                "Node Type" : "ResultSet",
                "PlanNodeType" : "ResultSet"
            }
        ],
        "Node Type" : "Query",
        "Stats" : {
            "Compilation" : {
                "FromCache" : true,
                "DurationUs" : 0,
                "CpuTimeUs" : 0
            },
            "ProcessCpuTimeUs" : 306,
            "TotalDurationUs" : 524239,
            "ResourcePoolId" : "default",
            "QueuedTimeUs" : 0
        },
        "PlanNodeType" : "Query"
    },
    "meta" : {
        "version" : "0.2",
        "type" : "query"
    },
    "SimplifiedPlan" : {
        "PlanNodeId" : 0,
        "Plans" : [
            {
                "PlanNodeId" : 1,
                "Plans" : [
                    {
                        "PlanNodeId" : 2,
                        "Plans" : [
                            {
                                "PlanNodeId" : 4,
                                "Plans" : [
                                    {
                                        "PlanNodeId" : 5,
                                        "Plans" : [
                                            {
                                                "PlanNodeId" : 6,
                                                "Plans" : [
                                                    {
                                                        "PlanNodeId" : 7,
                                                        "Plans" : [
                                                            {
                                                                "PlanNodeId" : 8,
                                                                "Plans" : [
                                                                    {
                                                                        "PlanNodeId" : 9,
                                                                        "Plans" : [
                                                                            {
                                                                                "PlanNodeId" : 10,
                                                                                "Plans" : [
                                                                                    {
                                                                                        "PlanNodeId" : 11,
                                                                                        "Plans" : [
                                                                                            {
                                                                                                "PlanNodeId" : 13,
                                                                                                "Plans" : [
                                                                                                    {
                                                                                                        "PlanNodeId" : 14,
                                                                                                        "Plans" : [
                                                                                                            {
                                                                                                                "PlanNodeId" : 15,
                                                                                                                "Plans" : [
                                                                                                                    {
                                                                                                                        "PlanNodeId" : 16,
                                                                                                                        "Plans" : [
                                                                                                                            {
                                                                                                                                "PlanNodeId" : 17,
                                                                                                                                "Plans" : [
                                                                                                                                    {
                                                                                                                                        "PlanNodeId" : 18,
                                                                                                                                        "Operators" : [
                                                                                                                                            {
                                                                                                                                                "Scan" : "Parallel",
                                                                                                                                                "E-Size" : "0",
                                                                                                                                                "ReadRanges" : [
                                                                                                                                                    "sr_item_sk (-∞, +∞)",
                                                                                                                                                    "sr_ticket_number (-∞, +∞)"
                                                                                                                                                ],
                                                                                                                                                "Name" : "TableFullScan",
                                                                                                                                                "Path" : "/local/test_db/olap_yatests/tpcds/s1/store_returns",
                                                                                                                                                "E-Rows" : "0",
                                                                                                                                                "Table" : "olap_yatests/tpcds/s1/store_returns",
                                                                                                                                                "ReadColumns" : [
                                                                                                                                                    "sr_customer_sk",
                                                                                                                                                    "sr_return_amt",
                                                                                                                                                    "sr_returned_date_sk",
                                                                                                                                                    "sr_store_sk"
                                                                                                                                                ],
                                                                                                                                                "SsaProgram" : {
                                                                                                                                                    "Version" : 5,
                                                                                                                                                    "Command" : [
                                                                                                                                                        {
                                                                                                                                                            "Projection" : {
                                                                                                                                                                "Columns" : [
                                                                                                                                                                    {
                                                                                                                                                                        "Id" : 4
                                                                                                                                                                    },
                                                                                                                                                                    {
                                                                                                                                                                        "Id" : 12
                                                                                                                                                                    },
                                                                                                                                                                    {
                                                                                                                                                                        "Id" : 1
                                                                                                                                                                    },
                                                                                                                                                                    {
                                                                                                                                                                        "Id" : 8
                                                                                                                                                                    }
                                                                                                                                                                ]
                                                                                                                                                            }
                                                                                                                                                        }
                                                                                                                                                    ]
                                                                                                                                                },
                                                                                                                                                "E-Cost" : "0"
                                                                                                                                            }
                                                                                                                                        ],
                                                                                                                                        "Node Type" : "TableFullScan"
                                                                                                                                    }
                                                                                                                                ],
                                                                                                                                "Operators" : [
                                                                                                                                    {
                                                                                                                                        "E-Rows" : "0",
                                                                                                                                        "Predicate" : "Exist(item.sr_returned_date_sk)",
                                                                                                                                        "Name" : "Filter",
                                                                                                                                        "E-Size" : "0",
                                                                                                                                        "E-Cost" : "0"
                                                                                                                                    }
                                                                                                                                ],
                                                                                                                                "Node Type" : "Filter"
                                                                                                                            },
                                                                                                                            {
                                                                                                                                "PlanNodeId" : 20,
                                                                                                                                "Plans" : [
                                                                                                                                    {
                                                                                                                                        "PlanNodeId" : 21,
                                                                                                                                        "Operators" : [
                                                                                                                                            {
                                                                                                                                                "Scan" : "Parallel",
                                                                                                                                                "E-Size" : "0",
                                                                                                                                                "ReadRanges" : [
                                                                                                                                                    "d_date_sk (-∞, +∞)"
                                                                                                                                                ],
                                                                                                                                                "Name" : "TableFullScan",
                                                                                                                                                "Path" : "/local/test_db/olap_yatests/tpcds/s1/date_dim",
                                                                                                                                                "E-Rows" : "0",
                                                                                                                                                "Table" : "olap_yatests/tpcds/s1/date_dim",
                                                                                                                                                "ReadColumns" : [
                                                                                                                                                    "d_date_sk",
                                                                                                                                                    "d_year"
                                                                                                                                                ],
                                                                                                                                                "SsaProgram" : {
                                                                                                                                                    "Version" : 5,
                                                                                                                                                    "Command" : [
                                                                                                                                                        {
                                                                                                                                                            "Assign" : {
                                                                                                                                                                "Constant" : {
                                                                                                                                                                    "Int32" : 2000
                                                                                                                                                                },
                                                                                                                                                                "Column" : {
                                                                                                                                                                    "Id" : 29
                                                                                                                                                                }
                                                                                                                                                            }
                                                                                                                                                        },
                                                                                                                                                        {
                                                                                                                                                            "Assign" : {
                                                                                                                                                                "Function" : {
                                                                                                                                                                    "YqlOperationId" : 11,
                                                                                                                                                                    "KernelIdx" : 0,
                                                                                                                                                                    "FunctionType" : 2,
                                                                                                                                                                    "Arguments" : [
                                                                                                                                                                        {
                                                                                                                                                                            "Id" : 7
                                                                                                                                                                        },
                                                                                                                                                                        {
                                                                                                                                                                            "Id" : 29
                                                                                                                                                                        }
                                                                                                                                                                    ]
                                                                                                                                                                },
                                                                                                                                                                "Column" : {
                                                                                                                                                                    "Id" : 30
                                                                                                                                                                }
                                                                                                                                                            }
                                                                                                                                                        },
                                                                                                                                                        {
                                                                                                                                                            "Assign" : {
                                                                                                                                                                "Constant" : {
                                                                                                                                                                    "Uint8" : 0
                                                                                                                                                                },
                                                                                                                                                                "Column" : {
                                                                                                                                                                    "Id" : 31
                                                                                                                                                                }
                                                                                                                                                            }
                                                                                                                                                        },
                                                                                                                                                        {
                                                                                                                                                            "Assign" : {
                                                                                                                                                                "Function" : {
                                                                                                                                                                    "YqlOperationId" : 17,
                                                                                                                                                                    "KernelIdx" : 1,
                                                                                                                                                                    "FunctionType" : 2,
                                                                                                                                                                    "Arguments" : [
                                                                                                                                                                        {
                                                                                                                                                                            "Id" : 30
                                                                                                                                                                        },
                                                                                                                                                                        {
                                                                                                                                                                            "Id" : 31
                                                                                                                                                                        }
                                                                                                                                                                    ]
                                                                                                                                                                },
                                                                                                                                                                "Column" : {
                                                                                                                                                                    "Id" : 32
                                                                                                                                                                }
                                                                                                                                                            }
                                                                                                                                                        },
                                                                                                                                                        {
                                                                                                                                                            "Filter" : {
                                                                                                                                                                "Predicate" : {
                                                                                                                                                                    "Id" : 32
                                                                                                                                                                }
                                                                                                                                                            }
                                                                                                                                                        },
                                                                                                                                                        {
                                                                                                                                                            "Projection" : {
                                                                                                                                                                "Columns" : [
                                                                                                                                                                    {
                                                                                                                                                                        "Id" : 1
                                                                                                                                                                    }
                                                                                                                                                                ]
                                                                                                                                                            }
                                                                                                                                                        }
                                                                                                                                                    ]
                                                                                                                                                },
                                                                                                                                                "E-Cost" : "0"
                                                                                                                                            }
                                                                                                                                        ],
                                                                                                                                        "Node Type" : "TableFullScan"
                                                                                                                                    }
                                                                                                                                ],
                                                                                                                                "Operators" : [
                                                                                                                                    {
                                                                                                                                        "E-Size" : "0",
                                                                                                                                        "Name" : "Filter",
                                                                                                                                        "Predicate" : "d_year == 2000",
                                                                                                                                        "A-SelfCpu" : 1.338,
                                                                                                                                        "E-Rows" : "0",
                                                                                                                                        "A-Cpu" : 1.338,
                                                                                                                                        "Pushdown" : "True",
                                                                                                                                        "E-Cost" : "0"
                                                                                                                                    }
                                                                                                                                ],
                                                                                                                                "Node Type" : "Filter"
                                                                                                                            }
                                                                                                                        ],
                                                                                                                        "Operators" : [
                                                                                                                            {
                                                                                                                                "E-Rows" : "0",
                                                                                                                                "Condition" : "a.sr_returned_date_sk = b.d_date_sk",
                                                                                                                                "Name" : "InnerJoin (MapJoin)",
                                                                                                                                "E-Size" : "0",
                                                                                                                                "E-Cost" : "0"
                                                                                                                            }
                                                                                                                        ],
                                                                                                                        "Node Type" : "InnerJoin (MapJoin)"
                                                                                                                    }
                                                                                                                ],
                                                                                                                "Operators" : [
                                                                                                                    {
                                                                                                                        "GroupBy" : "[item.a.sr_customer_sk,item.a.sr_store_sk]",
                                                                                                                        "A-SelfCpu" : 2.867,
                                                                                                                        "Aggregation" : "{SUM(item.a.sr_return_amt)}",
                                                                                                                        "A-Cpu" : 4.205,
                                                                                                                        "Name" : "Aggregate",
                                                                                                                        "Phase" : "Intermediate"
                                                                                                                    }
                                                                                                                ],
                                                                                                                "Node Type" : "Aggregate"
                                                                                                            }
                                                                                                        ],
                                                                                                        "Node Type" : "HashShuffle (KeyColumns: [\"a.sr_customer_sk\",\"a.sr_store_sk\"])",
                                                                                                        "PlanNodeType" : "Connection"
                                                                                                    }
                                                                                                ],
                                                                                                "Operators" : [
                                                                                                    {
                                                                                                        "A-SelfCpu" : 0.497,
                                                                                                        "A-Cpu" : 4.702,
                                                                                                        "Name" : "Aggregate",
                                                                                                        "Phase" : "Final"
                                                                                                    }
                                                                                                ],
                                                                                                "Node Type" : "Aggregate"
                                                                                            }
                                                                                        ],
                                                                                        "Operators" : [
                                                                                            {
                                                                                                "E-Rows" : "0",
                                                                                                "Predicate" : "Exist(item.ctr_store_sk)",
                                                                                                "Name" : "Filter",
                                                                                                "E-Size" : "0",
                                                                                                "E-Cost" : "0"
                                                                                            }
                                                                                        ],
                                                                                        "Node Type" : "Filter"
                                                                                    },
                                                                                    {
                                                                                        "PlanNodeId" : 23,
                                                                                        "Plans" : [
                                                                                            {
                                                                                                "PlanNodeId" : 24,
                                                                                                "Plans" : [
                                                                                                    {
                                                                                                        "PlanNodeId" : 25,
                                                                                                        "Plans" : [
                                                                                                            {
                                                                                                                "PlanNodeId" : 26,
                                                                                                                "Plans" : [
                                                                                                                    {
                                                                                                                        "PlanNodeId" : 27,
                                                                                                                        "Plans" : [
                                                                                                                            {
                                                                                                                                "PlanNodeId" : 28,
                                                                                                                                "Plans" : [
                                                                                                                                    {
                                                                                                                                        "PlanNodeId" : 29,
                                                                                                                                        "Plans" : [
                                                                                                                                            {
                                                                                                                                                "PlanNodeId" : 30,
                                                                                                                                                "Operators" : [
                                                                                                                                                    {
                                                                                                                                                        "Scan" : "Parallel",
                                                                                                                                                        "E-Size" : "0",
                                                                                                                                                        "ReadRanges" : [
                                                                                                                                                            "sr_item_sk (-∞, +∞)",
                                                                                                                                                            "sr_ticket_number (-∞, +∞)"
                                                                                                                                                        ],
                                                                                                                                                        "Name" : "TableFullScan",
                                                                                                                                                        "Path" : "/local/test_db/olap_yatests/tpcds/s1/store_returns",
                                                                                                                                                        "E-Rows" : "0",
                                                                                                                                                        "Table" : "olap_yatests/tpcds/s1/store_returns",
                                                                                                                                                        "ReadColumns" : [
                                                                                                                                                            "sr_customer_sk",
                                                                                                                                                            "sr_return_amt",
                                                                                                                                                            "sr_returned_date_sk",
                                                                                                                                                            "sr_store_sk"
                                                                                                                                                        ],
                                                                                                                                                        "SsaProgram" : {
                                                                                                                                                            "Version" : 5,
                                                                                                                                                            "Command" : [
                                                                                                                                                                {
                                                                                                                                                                    "Projection" : {
                                                                                                                                                                        "Columns" : [
                                                                                                                                                                            {
                                                                                                                                                                                "Id" : 4
                                                                                                                                                                            },
                                                                                                                                                                            {
                                                                                                                                                                                "Id" : 12
                                                                                                                                                                            },
                                                                                                                                                                            {
                                                                                                                                                                                "Id" : 1
                                                                                                                                                                            },
                                                                                                                                                                            {
                                                                                                                                                                                "Id" : 8
                                                                                                                                                                            }
                                                                                                                                                                        ]
                                                                                                                                                                    }
                                                                                                                                                                }
                                                                                                                                                            ]
                                                                                                                                                        },
                                                                                                                                                        "E-Cost" : "0"
                                                                                                                                                    }
                                                                                                                                                ],
                                                                                                                                                "Node Type" : "TableFullScan"
                                                                                                                                            }
                                                                                                                                        ],
                                                                                                                                        "Operators" : [
                                                                                                                                            {
                                                                                                                                                "E-Rows" : "0",
                                                                                                                                                "Predicate" : "Exist(item.sr_returned_date_sk)",
                                                                                                                                                "Name" : "Filter",
                                                                                                                                                "E-Size" : "0",
                                                                                                                                                "E-Cost" : "0"
                                                                                                                                            }
                                                                                                                                        ],
                                                                                                                                        "Node Type" : "Filter"
                                                                                                                                    },
                                                                                                                                    {
                                                                                                                                        "PlanNodeId" : 32,
                                                                                                                                        "Plans" : [
                                                                                                                                            {
                                                                                                                                                "PlanNodeId" : 33,
                                                                                                                                                "Operators" : [
                                                                                                                                                    {
                                                                                                                                                        "Scan" : "Parallel",
                                                                                                                                                        "E-Size" : "0",
                                                                                                                                                        "ReadRanges" : [
                                                                                                                                                            "d_date_sk (-∞, +∞)"
                                                                                                                                                        ],
                                                                                                                                                        "Name" : "TableFullScan",
                                                                                                                                                        "Path" : "/local/test_db/olap_yatests/tpcds/s1/date_dim",
                                                                                                                                                        "E-Rows" : "0",
                                                                                                                                                        "Table" : "olap_yatests/tpcds/s1/date_dim",
                                                                                                                                                        "ReadColumns" : [
                                                                                                                                                            "d_date_sk",
                                                                                                                                                            "d_year"
                                                                                                                                                        ],
                                                                                                                                                        "SsaProgram" : {
                                                                                                                                                            "Version" : 5,
                                                                                                                                                            "Command" : [
                                                                                                                                                                {
                                                                                                                                                                    "Assign" : {
                                                                                                                                                                        "Constant" : {
                                                                                                                                                                            "Int32" : 2000
                                                                                                                                                                        },
                                                                                                                                                                        "Column" : {
                                                                                                                                                                            "Id" : 29
                                                                                                                                                                        }
                                                                                                                                                                    }
                                                                                                                                                                },
                                                                                                                                                                {
                                                                                                                                                                    "Assign" : {
                                                                                                                                                                        "Function" : {
                                                                                                                                                                            "YqlOperationId" : 11,
                                                                                                                                                                            "KernelIdx" : 0,
                                                                                                                                                                            "FunctionType" : 2,
                                                                                                                                                                            "Arguments" : [
                                                                                                                                                                                {
                                                                                                                                                                                    "Id" : 7
                                                                                                                                                                                },
                                                                                                                                                                                {
                                                                                                                                                                                    "Id" : 29
                                                                                                                                                                                }
                                                                                                                                                                            ]
                                                                                                                                                                        },
                                                                                                                                                                        "Column" : {
                                                                                                                                                                            "Id" : 30
                                                                                                                                                                        }
                                                                                                                                                                    }
                                                                                                                                                                },
                                                                                                                                                                {
                                                                                                                                                                    "Assign" : {
                                                                                                                                                                        "Constant" : {
                                                                                                                                                                            "Uint8" : 0
                                                                                                                                                                        },
                                                                                                                                                                        "Column" : {
                                                                                                                                                                            "Id" : 31
                                                                                                                                                                        }
                                                                                                                                                                    }
                                                                                                                                                                },
                                                                                                                                                                {
                                                                                                                                                                    "Assign" : {
                                                                                                                                                                        "Function" : {
                                                                                                                                                                            "YqlOperationId" : 17,
                                                                                                                                                                            "KernelIdx" : 1,
                                                                                                                                                                            "FunctionType" : 2,
                                                                                                                                                                            "Arguments" : [
                                                                                                                                                                                {
                                                                                                                                                                                    "Id" : 30
                                                                                                                                                                                },
                                                                                                                                                                                {
                                                                                                                                                                                    "Id" : 31
                                                                                                                                                                                }
                                                                                                                                                                            ]
                                                                                                                                                                        },
                                                                                                                                                                        "Column" : {
                                                                                                                                                                            "Id" : 32
                                                                                                                                                                        }
                                                                                                                                                                    }
                                                                                                                                                                },
                                                                                                                                                                {
                                                                                                                                                                    "Filter" : {
                                                                                                                                                                        "Predicate" : {
                                                                                                                                                                            "Id" : 32
                                                                                                                                                                        }
                                                                                                                                                                    }
                                                                                                                                                                },
                                                                                                                                                                {
                                                                                                                                                                    "Projection" : {
                                                                                                                                                                        "Columns" : [
                                                                                                                                                                            {
                                                                                                                                                                                "Id" : 1
                                                                                                                                                                            }
                                                                                                                                                                        ]
                                                                                                                                                                    }
                                                                                                                                                                }
                                                                                                                                                            ]
                                                                                                                                                        },
                                                                                                                                                        "E-Cost" : "0"
                                                                                                                                                    }
                                                                                                                                                ],
                                                                                                                                                "Node Type" : "TableFullScan"
                                                                                                                                            }
                                                                                                                                        ],
                                                                                                                                        "Operators" : [
                                                                                                                                            {
                                                                                                                                                "E-Size" : "0",
                                                                                                                                                "Name" : "Filter",
                                                                                                                                                "Predicate" : "d_year == 2000",
                                                                                                                                                "A-SelfCpu" : 1.338,
                                                                                                                                                "E-Rows" : "0",
                                                                                                                                                "A-Cpu" : 1.338,
                                                                                                                                                "Pushdown" : "True",
                                                                                                                                                "E-Cost" : "0"
                                                                                                                                            }
                                                                                                                                        ],
                                                                                                                                        "Node Type" : "Filter"
                                                                                                                                    }
                                                                                                                                ],
                                                                                                                                "Operators" : [
                                                                                                                                    {
                                                                                                                                        "E-Rows" : "0",
                                                                                                                                        "Condition" : "a.sr_returned_date_sk = b.d_date_sk",
                                                                                                                                        "Name" : "InnerJoin (MapJoin)",
                                                                                                                                        "E-Size" : "0",
                                                                                                                                        "E-Cost" : "0"
                                                                                                                                    }
                                                                                                                                ],
                                                                                                                                "Node Type" : "InnerJoin (MapJoin)"
                                                                                                                            }
                                                                                                                        ],
                                                                                                                        "Operators" : [
                                                                                                                            {
                                                                                                                                "GroupBy" : "[item.a.sr_customer_sk,item.a.sr_store_sk]",
                                                                                                                                "A-SelfCpu" : 2.867,
                                                                                                                                "Aggregation" : "{SUM(item.a.sr_return_amt)}",
                                                                                                                                "A-Cpu" : 4.205,
                                                                                                                                "Name" : "Aggregate",
                                                                                                                                "Phase" : "Intermediate"
                                                                                                                            }
                                                                                                                        ],
                                                                                                                        "Node Type" : "Aggregate"
                                                                                                                    }
                                                                                                                ],
                                                                                                                "Node Type" : "HashShuffle (KeyColumns: [\"a.sr_customer_sk\",\"a.sr_store_sk\"])",
                                                                                                                "PlanNodeType" : "Connection"
                                                                                                            }
                                                                                                        ],
                                                                                                        "Operators" : [
                                                                                                            {
                                                                                                                "A-SelfCpu" : 0.497,
                                                                                                                "A-Cpu" : 4.702,
                                                                                                                "Name" : "Aggregate",
                                                                                                                "Phase" : "Final"
                                                                                                            }
                                                                                                        ],
                                                                                                        "Node Type" : "Aggregate"
                                                                                                    }
                                                                                                ],
                                                                                                "Node Type" : "HashShuffle (KeyColumns: [\"ctr_store_sk\"])",
                                                                                                "PlanNodeType" : "Connection"
                                                                                            }
                                                                                        ],
                                                                                        "Operators" : [
                                                                                            {
                                                                                                "A-SelfCpu" : 0.361,
                                                                                                "A-Cpu" : 5.063,
                                                                                                "Name" : "Aggregate",
                                                                                                "Phase" : "Final"
                                                                                            }
                                                                                        ],
                                                                                        "Node Type" : "Aggregate"
                                                                                    }
                                                                                ],
                                                                                "Operators" : [
                                                                                    {
                                                                                        "E-Rows" : "0",
                                                                                        "Condition" : "ctr1.ctr_store_sk = ctr2.ctr_store_sk",
                                                                                        "Name" : "InnerJoin (MapJoin)",
                                                                                        "E-Size" : "0",
                                                                                        "E-Cost" : "0"
                                                                                    }
                                                                                ],
                                                                                "Node Type" : "InnerJoin (MapJoin)"
                                                                            }
                                                                        ],
                                                                        "Operators" : [
                                                                            {
                                                                                "E-Rows" : "0",
                                                                                "Predicate" : "Exist(item.ctr1.ctr_store_sk)",
                                                                                "Name" : "Filter",
                                                                                "E-Size" : "0",
                                                                                "E-Cost" : "0"
                                                                            }
                                                                        ],
                                                                        "Node Type" : "Filter"
                                                                    },
                                                                    {
                                                                        "PlanNodeId" : 35,
                                                                        "Plans" : [
                                                                            {
                                                                                "PlanNodeId" : 36,
                                                                                "Operators" : [
                                                                                    {
                                                                                        "Scan" : "Parallel",
                                                                                        "E-Size" : "0",
                                                                                        "ReadRanges" : [
                                                                                            "s_store_sk (-∞, +∞)"
                                                                                        ],
                                                                                        "Name" : "TableFullScan",
                                                                                        "Path" : "/local/test_db/olap_yatests/tpcds/s1/store",
                                                                                        "E-Rows" : "0",
                                                                                        "Table" : "olap_yatests/tpcds/s1/store",
                                                                                        "ReadColumns" : [
                                                                                            "s_state",
                                                                                            "s_store_sk"
                                                                                        ],
                                                                                        "SsaProgram" : {
                                                                                            "Version" : 5,
                                                                                            "Command" : [
                                                                                                {
                                                                                                    "Assign" : {
                                                                                                        "Constant" : {
                                                                                                            "Bytes" : "TN"
                                                                                                        },
                                                                                                        "Column" : {
                                                                                                            "Id" : 30
                                                                                                        }
                                                                                                    }
                                                                                                },
                                                                                                {
                                                                                                    "Assign" : {
                                                                                                        "Function" : {
                                                                                                            "YqlOperationId" : 11,
                                                                                                            "KernelIdx" : 0,
                                                                                                            "FunctionType" : 2,
                                                                                                            "Arguments" : [
                                                                                                                {
                                                                                                                    "Id" : 25
                                                                                                                },
                                                                                                                {
                                                                                                                    "Id" : 30
                                                                                                                }
                                                                                                            ]
                                                                                                        },
                                                                                                        "Column" : {
                                                                                                            "Id" : 31
                                                                                                        }
                                                                                                    }
                                                                                                },
                                                                                                {
                                                                                                    "Assign" : {
                                                                                                        "Constant" : {
                                                                                                            "Uint8" : 0
                                                                                                        },
                                                                                                        "Column" : {
                                                                                                            "Id" : 32
                                                                                                        }
                                                                                                    }
                                                                                                },
                                                                                                {
                                                                                                    "Assign" : {
                                                                                                        "Function" : {
                                                                                                            "YqlOperationId" : 17,
                                                                                                            "KernelIdx" : 1,
                                                                                                            "FunctionType" : 2,
                                                                                                            "Arguments" : [
                                                                                                                {
                                                                                                                    "Id" : 31
                                                                                                                },
                                                                                                                {
                                                                                                                    "Id" : 32
                                                                                                                }
                                                                                                            ]
                                                                                                        },
                                                                                                        "Column" : {
                                                                                                            "Id" : 33
                                                                                                        }
                                                                                                    }
                                                                                                },
                                                                                                {
                                                                                                    "Filter" : {
                                                                                                        "Predicate" : {
                                                                                                            "Id" : 33
                                                                                                        }
                                                                                                    }
                                                                                                },
                                                                                                {
                                                                                                    "Projection" : {
                                                                                                        "Columns" : [
                                                                                                            {
                                                                                                                "Id" : 1
                                                                                                            }
                                                                                                        ]
                                                                                                    }
                                                                                                }
                                                                                            ]
                                                                                        },
                                                                                        "E-Cost" : "0"
                                                                                    }
                                                                                ],
                                                                                "Node Type" : "TableFullScan"
                                                                            }
                                                                        ],
                                                                        "Operators" : [
                                                                            {
                                                                                "E-Size" : "0",
                                                                                "Name" : "Filter",
                                                                                "Predicate" : "s_state == \"TN\"",
                                                                                "A-SelfCpu" : 5.855,
                                                                                "E-Rows" : "0",
                                                                                "A-Cpu" : 5.855,
                                                                                "Pushdown" : "True",
                                                                                "E-Cost" : "0"
                                                                            }
                                                                        ],
                                                                        "Node Type" : "Filter"
                                                                    }
                                                                ],
                                                                "Operators" : [
                                                                    {
                                                                        "E-Rows" : "0",
                                                                        "Condition" : "ctr1.ctr_store_sk = olap_yatests/tpcds/s1/store.s_store_sk",
                                                                        "Name" : "InnerJoin (MapJoin)",
                                                                        "E-Size" : "0",
                                                                        "E-Cost" : "0"
                                                                    }
                                                                ],
                                                                "Node Type" : "InnerJoin (MapJoin)"
                                                            }
                                                        ],
                                                        "Operators" : [
                                                            {
                                                                "E-Rows" : "0",
                                                                "Predicate" : "Exist(item.ctr1.ctr_customer_sk)",
                                                                "Name" : "Filter",
                                                                "E-Size" : "0",
                                                                "E-Cost" : "0"
                                                            }
                                                        ],
                                                        "Node Type" : "Filter"
                                                    },
                                                    {
                                                        "PlanNodeId" : 38,
                                                        "Operators" : [
                                                            {
                                                                "Scan" : "Parallel",
                                                                "E-Size" : "0",
                                                                "ReadRanges" : [
                                                                    "c_customer_sk (-∞, +∞)"
                                                                ],
                                                                "A-SelfCpu" : 1.424,
                                                                "Name" : "TableFullScan",
                                                                "Path" : "/local/test_db/olap_yatests/tpcds/s1/customer",
                                                                "E-Rows" : "0",
                                                                "A-Cpu" : 1.424,
                                                                "Table" : "olap_yatests/tpcds/s1/customer",
                                                                "ReadColumns" : [
                                                                    "c_customer_id",
                                                                    "c_customer_sk"
                                                                ],
                                                                "SsaProgram" : {
                                                                    "Version" : 5,
                                                                    "Command" : [
                                                                        {
                                                                            "Projection" : {
                                                                                "Columns" : [
                                                                                    {
                                                                                        "Id" : 2
                                                                                    },
                                                                                    {
                                                                                        "Id" : 1
                                                                                    }
                                                                                ]
                                                                            }
                                                                        }
                                                                    ]
                                                                },
                                                                "E-Cost" : "0"
                                                            }
                                                        ],
                                                        "Node Type" : "TableFullScan"
                                                    }
                                                ],
                                                "Operators" : [
                                                    {
                                                        "E-Rows" : "0",
                                                        "Condition" : "ctr1.ctr_customer_sk = olap_yatests/tpcds/s1/customer.c_customer_sk",
                                                        "Name" : "InnerJoin (MapJoin)",
                                                        "E-Size" : "0",
                                                        "E-Cost" : "0"
                                                    }
                                                ],
                                                "Node Type" : "InnerJoin (MapJoin)"
                                            }
                                        ],
                                        "Operators" : [
                                            {
                                                "E-Rows" : "0",
                                                "Predicate" : "item.ctr1.ctr_total_return > item.ctr2.Avg0 * \"1.2\"",
                                                "Name" : "Filter",
                                                "E-Size" : "0",
                                                "E-Cost" : "0"
                                            }
                                        ],
                                        "Node Type" : "Filter"
                                    }
                                ],
                                "Operators" : [
                                    {
                                        "A-SelfCpu" : 0.367,
                                        "A-Cpu" : 17.411,
                                        "Name" : "TopSort",
                                        "Limit" : "100",
                                        "TopSortBy" : "row.c_customer_id"
                                    }
                                ],
                                "Node Type" : "TopSort"
                            }
                        ],
                        "Operators" : [
                            {
                                "A-SelfCpu" : 0.117,
                                "A-Cpu" : 17.528,
                                "Name" : "Limit",
                                "Limit" : "100"
                            }
                        ],
                        "Node Type" : "Limit"
                    }
                ],
                "Node Type" : "ResultSet",
                "PlanNodeType" : "ResultSet"
            }
        ],
        "Node Type" : "Query",
        "PlanNodeType" : "Query"
    }
}
