Query: Summary: - Query ID: 019eb9a8-7b53-7289-8f38-bc3f2b520228 - Start Time: 2026-06-12 09:28:07 (+07:00) - End Time: 2026-06-12 09:30:37 (+07:00) - Total: 2m29s - Query Type: Query - Query State: Finished - StarRocks Version: 4.0.10-5b36164 - User: root - Default Db: lps - Sql Statement: /* ApplicationName=DBeaver 25.3.2 - SQLEditor */ INSERT /*+set_var(dynamic_overwrite = true, spill_mode = 'auto')*/ OVERWRITE lps.NHANNT33_V_DAILY_H WITH SelectedDates AS ( SELECT d.SYS_RUN_DAY AS load_date FROM lps.date_dim d WHERE d.SYS_RUN_DAY >= DATE_SUB(CURRENT_DATE(), INTERVAL 3 DAY) AND d.SYS_RUN_DAY < CURRENT_DATE() ) ,TargetDates AS ( SELECT DISTINCT SYS_RUN_DAY FROM ( SELECT d.SYS_RUN_DAY FROM lps.date_dim d INNER JOIN SelectedDates s ON d.SYS_RUN_DAY = s.load_date WHERE d.IS_PRESE = 1 UNION ALL SELECT d.BOM_base AS SYS_RUN_DAY FROM lps.date_dim d INNER JOIN SelectedDates s ON d.SYS_RUN_DAY = s.load_date WHERE d.is_rpt = 1 AND d.IS_PRESE = 1 UNION ALL SELECT d.BOM_base AS SYS_RUN_DAY FROM lps.date_dim d INNER JOIN SelectedDates s ON d.SYS_RUN_DAY = s.load_date WHERE d.IS_EOM = 1 AND d.IS_PRESE = 1 AND d.IS_LASTEST = 0 ) sub ) ,eom_ AS ( SELECT a.* FROM DMAPP.DTM_CUSTOMER_LD_SUMMARY a INNER JOIN TargetDates t ON a.SYS_RUN_DATE = t.SYS_RUN_DAY ) ,eom_distinct_acc AS ( SELECT DISTINCT ACCOUNT_NUMBER FROM eom_ ) ,T AS ( SELECT DATE_FORMAT(s.SCHEDULE_DUE_DATE, '%Y-%m') AS REPORT_MONTH, s.ACCOUNT_NUMBER, s.SCHEDULE_NO, s.SCHEDULE_ST_DATE, s.SCHEDULE_DUE_DATE, EXTRACT(DAY FROM s.SCHEDULE_DUE_DATE) AS due_day, SUM(CASE WHEN s.COMPONENT_NAME = 'PRINCIPAL' THEN s.AMOUNT_DUE ELSE 0 END) AS PRI_AMT, SUM(CASE WHEN s.COMPONENT_NAME = 'MAIN_INT' THEN s.AMOUNT_DUE ELSE 0 END) AS INT_AMT, SUM(s.AMOUNT_SETTLED) AS REPAY_AMT, SUM(s.EMI_AMOUNT) AS EMI_AMOUNT FROM dmapp.stg_clzb_account_schedules s INNER JOIN eom_distinct_acc e ON s.ACCOUNT_NUMBER = e.ACCOUNT_NUMBER WHERE s.SCHEDULE_NO IS NOT NULL GROUP BY 1, 2, 3, 4, 5, 6 ) ,due_ AS ( SELECT t.REPORT_MONTH, t.ACCOUNT_NUMBER, t.SCHEDULE_NO AS PERIOD_NO, t.SCHEDULE_ST_DATE AS start_date, t.SCHEDULE_DUE_DATE AS due_date, t.DUE_DAY, t.PRI_AMT, t.INT_AMT, t.REPAY_AMT, CEIL((COALESCE(t.EMI_AMOUNT, (t.PRI_AMT + t.INT_AMT)) + 12000) / 1000) * 1000 AS EMI_AMOUNT, ROW_NUMBER() OVER(PARTITION BY t.ACCOUNT_NUMBER, t.REPORT_MONTH ORDER BY t.SCHEDULE_NO ASC) AS row_num FROM T ) ,b_grouped AS ( SELECT CONTRACT_NO, MIN(MONTH_BEGIN) AS MONTH_BEGIN, COALESCE(MAX(MONTH_END) - INTERVAL 1 DAY, CURRENT_DATE()) AS MONTH_END FROM lps.DCS_CCN_QTDM GROUP BY CONTRACT_NO ) ,processed_base AS ( SELECT a.SYS_RUN_DATE, DATE_FORMAT(a.SYS_RUN_DATE, '%Y-%m') AS REPORT_MONTH, CASE WHEN a.SYS_RUN_DATE = LAST_DAY(a.SYS_RUN_DATE) THEN 1 ELSE 0 END AS IS_LAST_DAY, DATE_FORMAT(a.SYS_RUN_DATE + INTERVAL 1 DAY, '%Y-%m') AS REPORT_MONTH_BOM, a.CONTRACT_NO, a.LMS_CIF_NO, a.LD_NO, a.LD_DI_DATE, a.ACCOUNT_NUMBER, a.DRAWDOWN_AMOUNT_BASE AS LOAN_AMT, a.DPD_LD, CASE WHEN a.CONTRACT_STATUS = 'Close' THEN -1 ELSE CEIL(GREATEST(COALESCE(a.DPD_LD, 0), 0) / 30) END AS BUCKET_SUM, CASE WHEN a.CONTRACT_STATUS = 'WO' THEN 'WO' WHEN a.CONTRACT_STATUS = 'Close' THEN 'C' WHEN a.CONTRACT_STATUS = 'Active' THEN 'A' END AS STT, a.FIRST_PAYMENT_DATE, a.LAST_PAYMENT_DATE, a.LAST_PAYMENT_AMOUNT, a.OVER_DUE_DAYS_LD AS DPD_LMS, a.OUTSTANDING, a.DUE_DATE_OF_MON, a.PAYMENT_AMOUNT_NET_MTD, a.PAYMENT_AMOUNT_MTD, a.AMT_MUST_COLLECTED, ABS(a.CA_ACCT_BALANCE) AS CA_ACCT_BALANCE, CASE WHEN a.SYS_RUN_DATE <= '2025-08-31' THEN COALESCE(a.PRI_PAST_DUE, 0) + COALESCE(a.INT_PAST_DUE, 0) + COALESCE(a.OD_PAST_DUE, 0) + COALESCE(a.OD_UNBILL, 0) ELSE COALESCE(a.PRI_PAST_DUE, 0) + COALESCE(a.INT_PAST_DUE, 0) + COALESCE(a.OD_POSTED, 0) END AS TOTAL_OVER_DUE_AMOUNT, a.EMI_AMOUNT, a.TOTAL_EMI_AMOUNT_DCS AS EMI, a.MIN_MUST_PAYMENT, a.MIN_MUST_PAYMENT_DCS, a.TOTAL_MIN_MUST_PAYMENT_DCS, CASE WHEN b.CONTRACT_NO IS NOT NULL THEN 1 ELSE 0 END AS CCN_STT, CASE WHEN a.OD_PAST_DUE_MIN = 0 THEN a.PRI_PAST_DUE + a.INT_PAST_DUE_MIN ELSE a.PRI_PAST_DUE + a.INT_PAST_DUE + a.OD_PAST_DUE_MIN END AS MIN_MUST_PAYMENT_CIR06, CASE WHEN a.SYS_RUN_DATE <= '2025-08-31' AND a.LD_DI_DATE < '2023-09-01' THEN COALESCE(a.PRI_PAST_DUE_MIN, 0) + COALESCE(a.INT_PAST_DUE_MIN, 0) + COALESCE(a.OD_PAST_DUE_MIN, 0) WHEN a.SYS_RUN_DATE <= '2025-08-31' AND a.LD_DI_DATE >= '2023-09-01' AND COALESCE(a.OD_PAST_DUE_MIN, 0) = 0 THEN COALESCE(a.PRI_PAST_DUE, 0) + COALESCE(a.INT_PAST_DUE_MIN, 0) WHEN a.SYS_RUN_DATE <= '2025-08-31' AND a.LD_DI_DATE >= '2023-09-01' AND COALESCE(a.OD_PAST_DUE_MIN, 0) <> 0 THEN COALESCE(a.PRI_PAST_DUE, 0) + COALESCE(a.INT_PAST_DUE, 0) + COALESCE(a.OD_PAST_DUE_MIN, 0) WHEN a.SYS_RUN_DATE >= '2025-09-01' AND a.LD_DI_DATE < '2023-09-01' THEN COALESCE(a.PRI_PAST_DUE_MIN, 0) + COALESCE(a.INT_PAST_DUE_MIN, 0) ELSE COALESCE(a.PRI_PAST_DUE, 0) + COALESCE(a.INT_PAST_DUE_MIN, 0) END AS AMT_COLLECTED_TO_RESOLVE, a.PRI_REC_ALLOCATED_TO_DATE, a.INT_REC_ALLOCATED_TO_DATE, a.OD_REC_ALLOCATED_TO_DATE FROM eom_ a LEFT JOIN b_grouped b ON b.CONTRACT_NO = a.CONTRACT_NO AND b.MONTH_BEGIN <= a.SYS_RUN_DATE AND b.MONTH_END >= a.SYS_RUN_DATE ) ,ra AS ( SELECT EOM.REPORT_MONTH, EOM.SYS_RUN_DATE, BOM.DPD_LD AS DPD_BOM, EOM.DPD_LD AS DPD_EOM, BOM.BUCKET_SUM AS WAS_BUCKET, LEAST(BOM.BUCKET_SUM, 7) AS WAS_BUCKET_SUM, EOM.BUCKET_SUM, LEAST(EOM.BUCKET_SUM, 7) AS BUCKET_SUM_, BOM.STT AS WAS_STT, EOM.STT, EOM.CONTRACT_NO, EOM.LD_DI_DATE, EOM.LD_NO, BOM.OUTSTANDING AS POS_BOM, EOM.OUTSTANDING AS POS_EOM, EOM.LAST_PAYMENT_DATE, EOM.LAST_PAYMENT_AMOUNT, CASE WHEN BOM.STT = 'C' OR BOM.STT IS NULL THEN NULL WHEN BOM.FIRST_PAYMENT_DATE > EOM.SYS_RUN_DATE THEN 0 WHEN BOM.STT != 'C' AND EOM.STT = 'C' THEN 0 WHEN BOM.BUCKET_SUM = 0 AND EOM.DPD_LD > 0 THEN BOM.OUTSTANDING WHEN BOM.BUCKET_SUM > 0 AND EOM.DPD_LD >= (BOM.DPD_LD + DATEDIFF(EOM.SYS_RUN_DATE, DATE_TRUNC('month', EOM.SYS_RUN_DATE))) THEN BOM.OUTSTANDING WHEN BOM.BUCKET_SUM > 0 AND EOM.BUCKET_SUM > BOM.BUCKET_SUM THEN BOM.OUTSTANDING END AS ROLL_POS, CASE WHEN BOM.STT = 'C' OR BOM.STT IS NULL THEN NULL WHEN EOM.FIRST_PAYMENT_DATE > EOM.SYS_RUN_DATE THEN BOM.OUTSTANDING WHEN BOM.STT != 'C' AND EOM.STT = 'C' THEN 0 WHEN BOM.BUCKET_SUM = 0 AND EOM.DPD_LD <= 0 THEN BOM.OUTSTANDING WHEN BOM.BUCKET_SUM > 0 AND EOM.DPD_LD <= (BOM.DPD_LD + DATEDIFF(EOM.SYS_RUN_DATE, DATE_TRUNC('month', EOM.SYS_RUN_DATE))) AND EOM.BUCKET_SUM = BOM.BUCKET_SUM THEN BOM.OUTSTANDING END AS STAY_POS, CASE WHEN BOM.STT = 'C' OR BOM.STT IS NULL THEN NULL WHEN EOM.FIRST_PAYMENT_DATE > EOM.SYS_RUN_DATE THEN 0 WHEN BOM.STT != 'C' AND EOM.STT = 'C' THEN BOM.OUTSTANDING WHEN BOM.BUCKET_SUM = 0 AND EOM.STT = 'C' THEN BOM.OUTSTANDING WHEN BOM.BUCKET_SUM > 0 AND EOM.DPD_LD <= 0 THEN BOM.OUTSTANDING WHEN BOM.BUCKET_SUM > 0 AND EOM.BUCKET_SUM < BOM.BUCKET_SUM THEN BOM.OUTSTANDING END AS BACK_POS, EOM.PAYMENT_AMOUNT_NET_MTD AS cash_nofee, EOM.PAYMENT_AMOUNT_MTD AS total_cash, CASE WHEN BOM.STT = 'C' THEN 0 WHEN DATE_TRUNC('month', EOM.FIRST_PAYMENT_DATE) > DATE_TRUNC('month', EOM.SYS_RUN_DATE) THEN 0 WHEN BOM.CCN_STT = 1 THEN (EOM.EMI_AMOUNT - EOM.EMI + 12000) WHEN BOM.BUCKET_SUM = 0 THEN (BOM.EMI_AMOUNT + BOM.TOTAL_OVER_DUE_AMOUNT) ELSE BOM.TOTAL_OVER_DUE_AMOUNT END AS AMT_MUST_COLLECTED, EXTRACT(DAY FROM EOM.SYS_RUN_DATE) AS data_day, due.due_day, due.due_date, due.PRI_AMT, due.INT_AMT, due.REPAY_AMT, due.EMI_AMOUNT, due1.due_day AS due_day_2, due1.due_date AS due_date_2, due1.PRI_AMT AS PRI_AMT_2, due1.INT_AMT AS INT_AMT_2, due1.REPAY_AMT AS REPAY_AMT_2, due1.EMI_AMOUNT AS EMI_AMOUNT_2, BOM.MIN_MUST_PAYMENT AS MIN_MUST_PAYMENT_BOM, EOM.MIN_MUST_PAYMENT AS MIN_MUST_PAYMENT_EOM, BOM.MIN_MUST_PAYMENT_CIR06 AS MIN_MUST_PAYMENT_CIR06_BOM, EOM.MIN_MUST_PAYMENT_CIR06 AS MIN_MUST_PAYMENT_CIR06_EOM, EOM.MIN_MUST_PAYMENT_DCS AS MIN_MUST_PAYMENT_DCS_EOM, CASE WHEN BOM.LD_DI_DATE >= '2023-09-01' THEN 1 ELSE 0 END AS CIR06_flag, CASE WHEN BOM.LD_DI_DATE >= '2023-09-01' AND BOM.BUCKET_SUM > 0 AND due.due_day = 1 THEN (BOM.MIN_MUST_PAYMENT_CIR06 + due.PRI_AMT) - EOM.PAYMENT_AMOUNT_NET_MTD WHEN BOM.LD_DI_DATE >= '2023-09-01' AND BOM.BUCKET_SUM > 0 THEN BOM.MIN_MUST_PAYMENT_CIR06 - EOM.PAYMENT_AMOUNT_NET_MTD ELSE BOM.MIN_MUST_PAYMENT - EOM.PAYMENT_AMOUNT_NET_MTD END AS REMAIN_AMT, BOM.AMT_COLLECTED_TO_RESOLVE AS MIN_MUST_PAYMENT_RS_BOM, EOM.AMT_COLLECTED_TO_RESOLVE AS MIN_MUST_PAYMENT_RS_EOM, EOM.PRI_REC_ALLOCATED_TO_DATE, EOM.INT_REC_ALLOCATED_TO_DATE, EOM.OD_REC_ALLOCATED_TO_DATE FROM processed_base EOM LEFT JOIN processed_base BOM ON EOM.LD_NO = BOM.LD_NO AND EOM.REPORT_MONTH = BOM.REPORT_MONTH_BOM AND BOM.IS_LAST_DAY = 1 LEFT JOIN due_ due ON EOM.ACCOUNT_NUMBER = due.ACCOUNT_NUMBER AND EOM.REPORT_MONTH = due.REPORT_MONTH AND due.row_num = 1 LEFT JOIN due_ due1 ON EOM.ACCOUNT_NUMBER = due1.ACCOUNT_NUMBER AND EOM.REPORT_MONTH = due1.REPORT_MONTH AND due1.row_num = 2 ) ,fi AS ( SELECT ra.*, ALLOC.GROUP_ADJUST, ALLOC.USER_CURRENT, ALLOC.TEAM, CASE WHEN DPD_BOM > 360 THEN 1 ELSE 0 END AS DPD_GROUP, CASE WHEN POS_BOM < 7000000 THEN '<7tr' WHEN POS_BOM >= 7000000 AND POS_BOM <= 30000000 THEN '<=30tr' ELSE '>30tr' END AS pos_group, CASE WHEN ra.STAY_POS > 0 THEN 1 ELSE 0 END AS case_stay, CASE WHEN ra.BACK_POS > 0 THEN 1 ELSE 0 END AS case_back, CASE WHEN ra.ROLL_POS > 0 THEN 1 ELSE 0 END AS case_roll, CASE WHEN COALESCE(ra.ROLL_POS, 0) > 0 THEN 'RF' WHEN COALESCE(ra.STAY_POS, 0) > 0 THEN 'RT' WHEN COALESCE(ra.BACK_POS, 0) > 0 THEN 'RB' END AS DEBT_STATUS, CASE WHEN COALESCE(ra.ROLL_POS, 0) > 0 AND REMAIN_AMT <= 100000 AND REMAIN_AMT > 0 AND cash_nofee > 0 THEN 1 ELSE 0 END AS tolerance, CASE WHEN COALESCE(ra.ROLL_POS, 0) > 0 AND REMAIN_AMT <= 100000 AND REMAIN_AMT > 0 AND cash_nofee > 0 THEN CASE WHEN REMAIN_AMT <= 12000 THEN '<=12K' WHEN REMAIN_AMT <= 50000 THEN '<=50k' ELSE '<=100k' END ELSE 'NO_TOLERANCE' END AS tolerance_band, CEIL(CASE WHEN COALESCE(ra.ROLL_POS, 0) > 0 AND REMAIN_AMT <= 100000 AND REMAIN_AMT > 0 AND cash_nofee > 0 THEN REMAIN_AMT ELSE 0 END / 1000) * 1000 AS tolerance_amt_round FROM ra LEFT JOIN lps.ALLOCATE_JOIN ALLOC ON ALLOC.CONTRACT_NO = ra.CONTRACT_NO AND ALLOC.REPORT_MONTH = ra.REPORT_MONTH INNER JOIN SelectedDates p ON ra.SYS_RUN_DATE = p.load_date ) SELECT * FROM fi - Warehouse - Variables: parallel_fragment_exec_instance_num=1,max_parallel_scan_instance_num=-1,pipeline_dop=0,enable_adaptive_sink_dop=true,enable_runtime_adaptive_dop=false,runtime_profile_report_interval=10,resource_group=bui_wg - NonDefaultSessionVariables: {"sql_mode_v2":{"defaultValue":32,"actualValue":2097184},"enable_materialized_view_rewrite":{"defaultValue":true,"actualValue":false},"character_set_results":{"defaultValue":"utf8","actualValue":"NULL"},"dynamic_overwrite":{"defaultValue":false,"actualValue":true},"enable_local_shuffle_agg":{"defaultValue":true,"actualValue":false},"enable_adaptive_sink_dop":{"defaultValue":false,"actualValue":true},"enable_spill":{"defaultValue":false,"actualValue":true},"group_concat_max_len":{"defaultValue":1024,"actualValue":1000000},"use_compute_nodes":{"defaultValue":-1,"actualValue":0}} - Collect Profile Time: 0 - IsProfileAsync: true Planner: - -- Parser[1] 4ms - -- Total[1] 226ms - -- Analyzer[1] 11ms - -- Lock[1] 0 - -- AnalyzeDatabase[8] 0 - -- AnalyzeTemporaryTable[8] 0 - -- AnalyzeTable[8] 0 - -- Transform[1] 80ms - -- InsertPlanner[1] 131ms - -- Optimizer[1] 112ms - -- MVTextRewrite[1] 0 - -- RuleBaseOptimize[1] 82ms - -- CostBaseOptimize[1] 18ms - -- PhysicalRewrite[1] 8ms - -- DynamicRewrite[1] 0 - -- PlanValidate[1] 1ms - -- TypeChecker[1] 0 - -- CTEUniqueChecker[1] 0 - -- InputDependenciesChecker[1] 1ms - -- ColumnReuseChecker[1] 0 - -- PlanBuilder[1] 18ms - -- Analyzer[1] 10ms - -- Lock[1] 0 - -- AnalyzeDatabase[4] 0 - -- AnalyzeTemporaryTable[4] 0 - -- AnalyzeTable[4] 0 - -- Transform[1] 72ms - -- InsertPlanner[1] 135ms - -- Optimizer[1] 115ms - -- MVTextRewrite[1] 0 - -- RuleBaseOptimize[1] 83ms - -- CostBaseOptimize[1] 21ms - -- PhysicalRewrite[1] 7ms - -- DynamicRewrite[1] 0 - -- PlanValidate[1] 1ms - -- TypeChecker[1] 0 - -- CTEUniqueChecker[1] 0 - -- InputDependenciesChecker[1] 1ms - -- ColumnReuseChecker[1] 0 - -- PlanBuilder[1] 19ms - -- Pending[1] 0 - -- Prepare[1] 8ms - -- Deploy[1] 169ms - -- DeployLockInternalTime[1] 169ms - -- DeploySerializeConcurrencyTime[11] 44ms - -- DeployStageByStageTime[33] 1ms - -- DeployAsyncSendTime[91] 1ms - -- DeployWaitTime[33] 119ms - -- DeployScanRanges[1] 0 - DeployDataSize: 2617241 Reason: Execution: - Topology: {"rootId":340,"nodes":[{"id":340,"name":"DECODE","properties":{"sinkIds":[],"displayMem":false},"children":[339]},{"id":339,"name":"PROJECT","properties":{"displayMem":false},"children":[338]},{"id":338,"name":"HASH_JOIN","properties":{"displayMem":true},"children":[329,337]},{"id":329,"name":"PROJECT","properties":{"displayMem":false},"children":[328]},{"id":337,"name":"EXCHANGE","properties":{"displayMem":true},"children":[336]},{"id":328,"name":"HASH_JOIN","properties":{"displayMem":true},"children":[0,327]},{"id":336,"name":"SELECT","properties":{"sinkIds":[337],"displayMem":false},"children":[335]},{"id":0,"name":"OLAP_SCAN","properties":{"displayMem":false},"children":[]},{"id":327,"name":"EXCHANGE","properties":{"displayMem":true},"children":[326]},{"id":335,"name":"MERGE_EXCHANGE","properties":{"displayMem":true},"children":[334]},{"id":326,"name":"PROJECT","properties":{"sinkIds":[327],"displayMem":false},"children":[325]},{"id":334,"name":"SORT","properties":{"sinkIds":[335],"displayMem":true},"children":[333]},{"id":325,"name":"HASH_JOIN","properties":{"displayMem":true},"children":[239,324]},{"id":333,"name":"PROJECT","properties":{"displayMem":false},"children":[332]},{"id":239,"name":"PROJECT","properties":{"displayMem":false},"children":[238]},{"id":324,"name":"PROJECT","properties":{"displayMem":false},"children":[323]},{"id":332,"name":"TABLE_FUNCTION","properties":{"displayMem":false},"children":[331]},{"id":238,"name":"HASH_JOIN","properties":{"displayMem":true},"children":[152,237]},{"id":323,"name":"SELECT","properties":{"displayMem":false},"children":[322]},{"id":331,"name":"PROJECT","properties":{"displayMem":false},"children":[330]},{"id":152,"name":"EXCHANGE","properties":{"displayMem":true},"children":[151]},{"id":237,"name":"PROJECT","properties":{"displayMem":false},"children":[236]},{"id":322,"name":"ANALYTIC_EVAL","properties":{"displayMem":true},"children":[321]},{"id":330,"name":"UNION","properties":{"displayMem":false},"children":[]},{"id":151,"name":"PROJECT","properties":{"sinkIds":[152],"displayMem":false},"children":[150]},{"id":236,"name":"SELECT","properties":{"displayMem":false},"children":[235]},{"id":321,"name":"SORT","properties":{"displayMem":true},"children":[320]},{"id":150,"name":"HASH_JOIN","properties":{"displayMem":true},"children":[74,149]},{"id":235,"name":"ANALYTIC_EVAL","properties":{"displayMem":true},"children":[234]},{"id":320,"name":"EXCHANGE","properties":{"displayMem":true},"children":[319]},{"id":74,"name":"PROJECT","properties":{"displayMem":false},"children":[73]},{"id":149,"name":"EXCHANGE","properties":{"displayMem":true},"children":[148]},{"id":234,"name":"SORT","properties":{"displayMem":true},"children":[233]},{"id":319,"name":"PARTITION_TOP_N","properties":{"sinkIds":[320],"displayMem":true},"children":[318]},{"id":73,"name":"HASH_JOIN","properties":{"displayMem":true},"children":[68,72]},{"id":148,"name":"PROJECT","properties":{"sinkIds":[149],"displayMem":false},"children":[147]},{"id":233,"name":"EXCHANGE","properties":{"displayMem":true},"children":[232]},{"id":318,"name":"PROJECT","properties":{"displayMem":false},"children":[317]},{"id":68,"name":"PROJECT","properties":{"displayMem":false},"children":[67]},{"id":72,"name":"EXCHANGE","properties":{"displayMem":true},"children":[71]},{"id":147,"name":"HASH_JOIN","properties":{"displayMem":true},"children":[142,146]},{"id":232,"name":"PARTITION_TOP_N","properties":{"sinkIds":[233],"displayMem":true},"children":[231]},{"id":317,"name":"AGGREGATION","properties":{"displayMem":true},"children":[316]},{"id":67,"name":"HASH_JOIN","properties":{"displayMem":true},"children":[2,66]},{"id":71,"name":"PROJECT","properties":{"sinkIds":[72],"displayMem":false},"children":[70]},{"id":142,"name":"PROJECT","properties":{"displayMem":false},"children":[141]},{"id":146,"name":"EXCHANGE","properties":{"displayMem":true},"children":[145]},{"id":231,"name":"PROJECT","properties":{"displayMem":false},"children":[230]},{"id":316,"name":"EXCHANGE","properties":{"displayMem":true},"children":[315]},{"id":2,"name":"PROJECT","properties":{"displayMem":false},"children":[1]},{"id":66,"name":"EXCHANGE","properties":{"displayMem":true},"children":[65]},{"id":70,"name":"AGGREGATION","properties":{"displayMem":true},"children":[69]},{"id":141,"name":"HASH_JOIN","properties":{"displayMem":true},"children":[76,140]},{"id":145,"name":"PROJECT","properties":{"sinkIds":[146],"displayMem":false},"children":[144]},{"id":230,"name":"AGGREGATION","properties":{"displayMem":true},"children":[229]},{"id":315,"name":"AGGREGATION","properties":{"sinkIds":[316],"displayMem":true},"children":[314]},{"id":1,"name":"OLAP_SCAN","properties":{"displayMem":false},"children":[]},{"id":65,"name":"AGGREGATION","properties":{"sinkIds":[66],"displayMem":true},"children":[64]},{"id":69,"name":"OLAP_SCAN","properties":{"displayMem":false},"children":[]},{"id":76,"name":"PROJECT","properties":{"displayMem":false},"children":[75]},{"id":140,"name":"EXCHANGE","properties":{"displayMem":true},"children":[139]},{"id":144,"name":"AGGREGATION","properties":{"displayMem":true},"children":[143]},{"id":229,"name":"EXCHANGE","properties":{"displayMem":true},"children":[228]},{"id":314,"name":"PROJECT","properties":{"displayMem":false},"children":[313]},{"id":64,"name":"EXCHANGE","properties":{"displayMem":true},"children":[63]},{"id":75,"name":"OLAP_SCAN","properties":{"displayMem":false},"children":[]},{"id":139,"name":"AGGREGATION","properties":{"sinkIds":[140],"displayMem":true},"children":[138]},{"id":143,"name":"OLAP_SCAN","properties":{"displayMem":false},"children":[]},{"id":228,"name":"AGGREGATION","properties":{"sinkIds":[229],"displayMem":true},"children":[227]},{"id":313,"name":"HASH_JOIN","properties":{"displayMem":true},"children":[240,312]},{"id":63,"name":"AGGREGATION","properties":{"sinkIds":[64],"displayMem":true},"children":[3]},{"id":138,"name":"EXCHANGE","properties":{"displayMem":true},"children":[137]},{"id":227,"name":"PROJECT","properties":{"displayMem":false},"children":[226]},{"id":240,"name":"OLAP_SCAN","properties":{"displayMem":false},"children":[]},{"id":312,"name":"EXCHANGE","properties":{"displayMem":true},"children":[311]},{"id":3,"name":"UNION","properties":{"displayMem":false},"children":[22,42,62]},{"id":137,"name":"AGGREGATION","properties":{"sinkIds":[138],"displayMem":true},"children":[77]},{"id":226,"name":"HASH_JOIN","properties":{"displayMem":true},"children":[153,225]},{"id":311,"name":"AGGREGATION","properties":{"sinkIds":[312],"displayMem":true},"children":[310]},{"id":22,"name":"EXCHANGE","properties":{"displayMem":true},"children":[21]},{"id":42,"name":"EXCHANGE","properties":{"displayMem":true},"children":[41]},{"id":62,"name":"EXCHANGE","properties":{"displayMem":true},"children":[61]},{"id":77,"name":"UNION","properties":{"displayMem":false},"children":[96,116,136]},{"id":153,"name":"OLAP_SCAN","properties":{"displayMem":false},"children":[]},{"id":225,"name":"EXCHANGE","properties":{"displayMem":true},"children":[224]},{"id":310,"name":"EXCHANGE","properties":{"displayMem":true},"children":[309]},{"id":21,"name":"PROJECT","properties":{"sinkIds":[22],"displayMem":false},"children":[20]},{"id":41,"name":"PROJECT","properties":{"sinkIds":[42],"displayMem":false},"children":[40]},{"id":61,"name":"PROJECT","properties":{"sinkIds":[62],"displayMem":false},"children":[60]},{"id":96,"name":"EXCHANGE","properties":{"displayMem":true},"children":[95]},{"id":116,"name":"EXCHANGE","properties":{"displayMem":true},"children":[115]},{"id":136,"name":"EXCHANGE","properties":{"displayMem":true},"children":[135]},{"id":224,"name":"AGGREGATION","properties":{"sinkIds":[225],"displayMem":true},"children":[223]},{"id":309,"name":"AGGREGATION","properties":{"sinkIds":[310],"displayMem":true},"children":[308]},{"id":20,"name":"HASH_JOIN","properties":{"displayMem":true},"children":[11,19]},{"id":40,"name":"HASH_JOIN","properties":{"displayMem":true},"children":[31,39]},{"id":60,"name":"HASH_JOIN","properties":{"displayMem":true},"children":[51,59]},{"id":95,"name":"PROJECT","properties":{"sinkIds":[96],"displayMem":false},"children":[94]},{"id":115,"name":"PROJECT","properties":{"sinkIds":[116],"displayMem":false},"children":[114]},{"id":135,"name":"PROJECT","properties":{"sinkIds":[136],"displayMem":false},"children":[134]},{"id":223,"name":"EXCHANGE","properties":{"displayMem":true},"children":[222]},{"id":308,"name":"PROJECT","properties":{"displayMem":false},"children":[307]},{"id":11,"name":"EXCHANGE","properties":{"displayMem":true},"children":[10]},{"id":19,"name":"EXCHANGE","properties":{"displayMem":true},"children":[18]},{"id":31,"name":"EXCHANGE","properties":{"displayMem":true},"children":[30]},{"id":39,"name":"EXCHANGE","properties":{"displayMem":true},"children":[38]},{"id":51,"name":"EXCHANGE","properties":{"displayMem":true},"children":[50]},{"id":59,"name":"EXCHANGE","properties":{"displayMem":true},"children":[58]},{"id":94,"name":"HASH_JOIN","properties":{"displayMem":true},"children":[85,93]},{"id":114,"name":"HASH_JOIN","properties":{"displayMem":true},"children":[105,113]},{"id":134,"name":"HASH_JOIN","properties":{"displayMem":true},"children":[125,133]},{"id":222,"name":"AGGREGATION","properties":{"sinkIds":[223],"displayMem":true},"children":[221]},{"id":307,"name":"HASH_JOIN","properties":{"displayMem":true},"children":[242,306]},{"id":10,"name":"SELECT","properties":{"sinkIds":[11],"displayMem":false},"children":[9]},{"id":18,"name":"SELECT","properties":{"sinkIds":[19],"displayMem":false},"children":[17]},{"id":30,"name":"PROJECT","properties":{"sinkIds":[31],"displayMem":false},"children":[29]},{"id":38,"name":"SELECT","properties":{"sinkIds":[39],"displayMem":false},"children":[37]},{"id":50,"name":"PROJECT","properties":{"sinkIds":[51],"displayMem":false},"children":[49]},{"id":58,"name":"SELECT","properties":{"sinkIds":[59],"displayMem":false},"children":[57]},{"id":85,"name":"EXCHANGE","properties":{"displayMem":true},"children":[84]},{"id":93,"name":"EXCHANGE","properties":{"displayMem":true},"children":[92]},{"id":105,"name":"EXCHANGE","properties":{"displayMem":true},"children":[104]},{"id":113,"name":"EXCHANGE","properties":{"displayMem":true},"children":[112]},{"id":125,"name":"EXCHANGE","properties":{"displayMem":true},"children":[124]},{"id":133,"name":"EXCHANGE","properties":{"displayMem":true},"children":[132]},{"id":221,"name":"PROJECT","properties":{"displayMem":false},"children":[220]},{"id":242,"name":"PROJECT","properties":{"displayMem":false},"children":[241]},{"id":306,"name":"EXCHANGE","properties":{"displayMem":true},"children":[305]},{"id":9,"name":"MERGE_EXCHANGE","properties":{"displayMem":true},"children":[8]},{"id":17,"name":"MERGE_EXCHANGE","properties":{"displayMem":true},"children":[16]},{"id":29,"name":"SELECT","properties":{"displayMem":false},"children":[28]},{"id":37,"name":"MERGE_EXCHANGE","properties":{"displayMem":true},"children":[36]},{"id":49,"name":"SELECT","properties":{"displayMem":false},"children":[48]},{"id":57,"name":"MERGE_EXCHANGE","properties":{"displayMem":true},"children":[56]},{"id":84,"name":"SELECT","properties":{"sinkIds":[85],"displayMem":false},"children":[83]},{"id":92,"name":"SELECT","properties":{"sinkIds":[93],"displayMem":false},"children":[91]},{"id":104,"name":"PROJECT","properties":{"sinkIds":[105],"displayMem":false},"children":[103]},{"id":112,"name":"SELECT","properties":{"sinkIds":[113],"displayMem":false},"children":[111]},{"id":124,"name":"PROJECT","properties":{"sinkIds":[125],"displayMem":false},"children":[123]},{"id":132,"name":"SELECT","properties":{"sinkIds":[133],"displayMem":false},"children":[131]},{"id":220,"name":"HASH_JOIN","properties":{"displayMem":true},"children":[155,219]},{"id":241,"name":"OLAP_SCAN","properties":{"displayMem":false},"children":[]},{"id":305,"name":"AGGREGATION","properties":{"sinkIds":[306],"displayMem":true},"children":[304]},{"id":8,"name":"SORT","properties":{"sinkIds":[9],"displayMem":true},"children":[7]},{"id":16,"name":"SORT","properties":{"sinkIds":[17],"displayMem":true},"children":[15]},{"id":28,"name":"MERGE_EXCHANGE","properties":{"displayMem":true},"children":[27]},{"id":36,"name":"SORT","properties":{"sinkIds":[37],"displayMem":true},"children":[35]},{"id":48,"name":"MERGE_EXCHANGE","properties":{"displayMem":true},"children":[47]},{"id":56,"name":"SORT","properties":{"sinkIds":[57],"displayMem":true},"children":[55]},{"id":83,"name":"MERGE_EXCHANGE","properties":{"displayMem":true},"children":[82]},{"id":91,"name":"MERGE_EXCHANGE","properties":{"displayMem":true},"children":[90]},{"id":103,"name":"SELECT","properties":{"displayMem":false},"children":[102]},{"id":111,"name":"MERGE_EXCHANGE","properties":{"displayMem":true},"children":[110]},{"id":123,"name":"SELECT","properties":{"displayMem":false},"children":[122]},{"id":131,"name":"MERGE_EXCHANGE","properties":{"displayMem":true},"children":[130]},{"id":155,"name":"PROJECT","properties":{"displayMem":false},"children":[154]},{"id":219,"name":"EXCHANGE","properties":{"displayMem":true},"children":[218]},{"id":304,"name":"EXCHANGE","properties":{"displayMem":true},"children":[303]},{"id":7,"name":"PROJECT","properties":{"displayMem":false},"children":[6]},{"id":15,"name":"PROJECT","properties":{"displayMem":false},"children":[14]},{"id":27,"name":"SORT","properties":{"sinkIds":[28],"displayMem":true},"children":[26]},{"id":35,"name":"PROJECT","properties":{"displayMem":false},"children":[34]},{"id":47,"name":"SORT","properties":{"sinkIds":[48],"displayMem":true},"children":[46]},{"id":55,"name":"PROJECT","properties":{"displayMem":false},"children":[54]},{"id":82,"name":"SORT","properties":{"sinkIds":[83],"displayMem":true},"children":[81]},{"id":90,"name":"SORT","properties":{"sinkIds":[91],"displayMem":true},"children":[89]},{"id":102,"name":"MERGE_EXCHANGE","properties":{"displayMem":true},"children":[101]},{"id":110,"name":"SORT","properties":{"sinkIds":[111],"displayMem":true},"children":[109]},{"id":122,"name":"MERGE_EXCHANGE","properties":{"displayMem":true},"children":[121]},{"id":130,"name":"SORT","properties":{"sinkIds":[131],"displayMem":true},"children":[129]},{"id":154,"name":"OLAP_SCAN","properties":{"displayMem":false},"children":[]},{"id":218,"name":"AGGREGATION","properties":{"sinkIds":[219],"displayMem":true},"children":[217]},{"id":303,"name":"AGGREGATION","properties":{"sinkIds":[304],"displayMem":true},"children":[243]},{"id":6,"name":"TABLE_FUNCTION","properties":{"displayMem":false},"children":[5]},{"id":14,"name":"TABLE_FUNCTION","properties":{"displayMem":false},"children":[13]},{"id":26,"name":"PROJECT","properties":{"displayMem":false},"children":[25]},{"id":34,"name":"TABLE_FUNCTION","properties":{"displayMem":false},"children":[33]},{"id":46,"name":"PROJECT","properties":{"displayMem":false},"children":[45]},{"id":54,"name":"TABLE_FUNCTION","properties":{"displayMem":false},"children":[53]},{"id":81,"name":"PROJECT","properties":{"displayMem":false},"children":[80]},{"id":89,"name":"PROJECT","properties":{"displayMem":false},"children":[88]},{"id":101,"name":"SORT","properties":{"sinkIds":[102],"displayMem":true},"children":[100]},{"id":109,"name":"PROJECT","properties":{"displayMem":false},"children":[108]},{"id":121,"name":"SORT","properties":{"sinkIds":[122],"displayMem":true},"children":[120]},{"id":129,"name":"PROJECT","properties":{"displayMem":false},"children":[128]},{"id":217,"name":"EXCHANGE","properties":{"displayMem":true},"children":[216]},{"id":243,"name":"UNION","properties":{"displayMem":false},"children":[262,282,302]},{"id":5,"name":"PROJECT","properties":{"displayMem":false},"children":[4]},{"id":13,"name":"PROJECT","properties":{"displayMem":false},"children":[12]},{"id":25,"name":"TABLE_FUNCTION","properties":{"displayMem":false},"children":[24]},{"id":33,"name":"PROJECT","properties":{"displayMem":false},"children":[32]},{"id":45,"name":"TABLE_FUNCTION","properties":{"displayMem":false},"children":[44]},{"id":53,"name":"PROJECT","properties":{"displayMem":false},"children":[52]},{"id":80,"name":"TABLE_FUNCTION","properties":{"displayMem":false},"children":[79]},{"id":88,"name":"TABLE_FUNCTION","properties":{"displayMem":false},"children":[87]},{"id":100,"name":"PROJECT","properties":{"displayMem":false},"children":[99]},{"id":108,"name":"TABLE_FUNCTION","properties":{"displayMem":false},"children":[107]},{"id":120,"name":"PROJECT","properties":{"displayMem":false},"children":[119]},{"id":128,"name":"TABLE_FUNCTION","properties":{"displayMem":false},"children":[127]},{"id":216,"name":"AGGREGATION","properties":{"sinkIds":[217],"displayMem":true},"children":[156]},{"id":262,"name":"EXCHANGE","properties":{"displayMem":true},"children":[261]},{"id":282,"name":"EXCHANGE","properties":{"displayMem":true},"children":[281]},{"id":302,"name":"EXCHANGE","properties":{"displayMem":true},"children":[301]},{"id":4,"name":"UNION","properties":{"displayMem":false},"children":[]},{"id":12,"name":"UNION","properties":{"displayMem":false},"children":[]},{"id":24,"name":"PROJECT","properties":{"displayMem":false},"children":[23]},{"id":32,"name":"UNION","properties":{"displayMem":false},"children":[]},{"id":44,"name":"PROJECT","properties":{"displayMem":false},"children":[43]},{"id":52,"name":"UNION","properties":{"displayMem":false},"children":[]},{"id":79,"name":"PROJECT","properties":{"displayMem":false},"children":[78]},{"id":87,"name":"PROJECT","properties":{"displayMem":false},"children":[86]},{"id":99,"name":"TABLE_FUNCTION","properties":{"displayMem":false},"children":[98]},{"id":107,"name":"PROJECT","properties":{"displayMem":false},"children":[106]},{"id":119,"name":"TABLE_FUNCTION","properties":{"displayMem":false},"children":[118]},{"id":127,"name":"PROJECT","properties":{"displayMem":false},"children":[126]},{"id":156,"name":"UNION","properties":{"displayMem":false},"children":[175,195,215]},{"id":261,"name":"PROJECT","properties":{"sinkIds":[262],"displayMem":false},"children":[260]},{"id":281,"name":"PROJECT","properties":{"sinkIds":[282],"displayMem":false},"children":[280]},{"id":301,"name":"PROJECT","properties":{"sinkIds":[302],"displayMem":false},"children":[300]},{"id":23,"name":"UNION","properties":{"displayMem":false},"children":[]},{"id":43,"name":"UNION","properties":{"displayMem":false},"children":[]},{"id":78,"name":"UNION","properties":{"displayMem":false},"children":[]},{"id":86,"name":"UNION","properties":{"displayMem":false},"children":[]},{"id":98,"name":"PROJECT","properties":{"displayMem":false},"children":[97]},{"id":106,"name":"UNION","properties":{"displayMem":false},"children":[]},{"id":118,"name":"PROJECT","properties":{"displayMem":false},"children":[117]},{"id":126,"name":"UNION","properties":{"displayMem":false},"children":[]},{"id":175,"name":"EXCHANGE","properties":{"displayMem":true},"children":[174]},{"id":195,"name":"EXCHANGE","properties":{"displayMem":true},"children":[194]},{"id":215,"name":"EXCHANGE","properties":{"displayMem":true},"children":[214]},{"id":260,"name":"HASH_JOIN","properties":{"displayMem":true},"children":[251,259]},{"id":280,"name":"HASH_JOIN","properties":{"displayMem":true},"children":[271,279]},{"id":300,"name":"HASH_JOIN","properties":{"displayMem":true},"children":[291,299]},{"id":97,"name":"UNION","properties":{"displayMem":false},"children":[]},{"id":117,"name":"UNION","properties":{"displayMem":false},"children":[]},{"id":174,"name":"PROJECT","properties":{"sinkIds":[175],"displayMem":false},"children":[173]},{"id":194,"name":"PROJECT","properties":{"sinkIds":[195],"displayMem":false},"children":[193]},{"id":214,"name":"PROJECT","properties":{"sinkIds":[215],"displayMem":false},"children":[213]},{"id":251,"name":"EXCHANGE","properties":{"displayMem":true},"children":[250]},{"id":259,"name":"EXCHANGE","properties":{"displayMem":true},"children":[258]},{"id":271,"name":"EXCHANGE","properties":{"displayMem":true},"children":[270]},{"id":279,"name":"EXCHANGE","properties":{"displayMem":true},"children":[278]},{"id":291,"name":"EXCHANGE","properties":{"displayMem":true},"children":[290]},{"id":299,"name":"EXCHANGE","properties":{"displayMem":true},"children":[298]},{"id":173,"name":"HASH_JOIN","properties":{"displayMem":true},"children":[164,172]},{"id":193,"name":"HASH_JOIN","properties":{"displayMem":true},"children":[184,192]},{"id":213,"name":"HASH_JOIN","properties":{"displayMem":true},"children":[204,212]},{"id":250,"name":"SELECT","properties":{"sinkIds":[251],"displayMem":false},"children":[249]},{"id":258,"name":"SELECT","properties":{"sinkIds":[259],"displayMem":false},"children":[257]},{"id":270,"name":"PROJECT","properties":{"sinkIds":[271],"displayMem":false},"children":[269]},{"id":278,"name":"SELECT","properties":{"sinkIds":[279],"displayMem":false},"children":[277]},{"id":290,"name":"PROJECT","properties":{"sinkIds":[291],"displayMem":false},"children":[289]},{"id":298,"name":"SELECT","properties":{"sinkIds":[299],"displayMem":false},"children":[297]},{"id":164,"name":"EXCHANGE","properties":{"displayMem":true},"children":[163]},{"id":172,"name":"EXCHANGE","properties":{"displayMem":true},"children":[171]},{"id":184,"name":"EXCHANGE","properties":{"displayMem":true},"children":[183]},{"id":192,"name":"EXCHANGE","properties":{"displayMem":true},"children":[191]},{"id":204,"name":"EXCHANGE","properties":{"displayMem":true},"children":[203]},{"id":212,"name":"EXCHANGE","properties":{"displayMem":true},"children":[211]},{"id":249,"name":"MERGE_EXCHANGE","properties":{"displayMem":true},"children":[248]},{"id":257,"name":"MERGE_EXCHANGE","properties":{"displayMem":true},"children":[256]},{"id":269,"name":"SELECT","properties":{"displayMem":false},"children":[268]},{"id":277,"name":"MERGE_EXCHANGE","properties":{"displayMem":true},"children":[276]},{"id":289,"name":"SELECT","properties":{"displayMem":false},"children":[288]},{"id":297,"name":"MERGE_EXCHANGE","properties":{"displayMem":true},"children":[296]},{"id":163,"name":"SELECT","properties":{"sinkIds":[164],"displayMem":false},"children":[162]},{"id":171,"name":"SELECT","properties":{"sinkIds":[172],"displayMem":false},"children":[170]},{"id":183,"name":"PROJECT","properties":{"sinkIds":[184],"displayMem":false},"children":[182]},{"id":191,"name":"SELECT","properties":{"sinkIds":[192],"displayMem":false},"children":[190]},{"id":203,"name":"PROJECT","properties":{"sinkIds":[204],"displayMem":false},"children":[202]},{"id":211,"name":"SELECT","properties":{"sinkIds":[212],"displayMem":false},"children":[210]},{"id":248,"name":"SORT","properties":{"sinkIds":[249],"displayMem":true},"children":[247]},{"id":256,"name":"SORT","properties":{"sinkIds":[257],"displayMem":true},"children":[255]},{"id":268,"name":"MERGE_EXCHANGE","properties":{"displayMem":true},"children":[267]},{"id":276,"name":"SORT","properties":{"sinkIds":[277],"displayMem":true},"children":[275]},{"id":288,"name":"MERGE_EXCHANGE","properties":{"displayMem":true},"children":[287]},{"id":296,"name":"SORT","properties":{"sinkIds":[297],"displayMem":true},"children":[295]},{"id":162,"name":"MERGE_EXCHANGE","properties":{"displayMem":true},"children":[161]},{"id":170,"name":"MERGE_EXCHANGE","properties":{"displayMem":true},"children":[169]},{"id":182,"name":"SELECT","properties":{"displayMem":false},"children":[181]},{"id":190,"name":"MERGE_EXCHANGE","properties":{"displayMem":true},"children":[189]},{"id":202,"name":"SELECT","properties":{"displayMem":false},"children":[201]},{"id":210,"name":"MERGE_EXCHANGE","properties":{"displayMem":true},"children":[209]},{"id":247,"name":"PROJECT","properties":{"displayMem":false},"children":[246]},{"id":255,"name":"PROJECT","properties":{"displayMem":false},"children":[254]},{"id":267,"name":"SORT","properties":{"sinkIds":[268],"displayMem":true},"children":[266]},{"id":275,"name":"PROJECT","properties":{"displayMem":false},"children":[274]},{"id":287,"name":"SORT","properties":{"sinkIds":[288],"displayMem":true},"children":[286]},{"id":295,"name":"PROJECT","properties":{"displayMem":false},"children":[294]},{"id":161,"name":"SORT","properties":{"sinkIds":[162],"displayMem":true},"children":[160]},{"id":169,"name":"SORT","properties":{"sinkIds":[170],"displayMem":true},"children":[168]},{"id":181,"name":"MERGE_EXCHANGE","properties":{"displayMem":true},"children":[180]},{"id":189,"name":"SORT","properties":{"sinkIds":[190],"displayMem":true},"children":[188]},{"id":201,"name":"MERGE_EXCHANGE","properties":{"displayMem":true},"children":[200]},{"id":209,"name":"SORT","properties":{"sinkIds":[210],"displayMem":true},"children":[208]},{"id":246,"name":"TABLE_FUNCTION","properties":{"displayMem":false},"children":[245]},{"id":254,"name":"TABLE_FUNCTION","properties":{"displayMem":false},"children":[253]},{"id":266,"name":"PROJECT","properties":{"displayMem":false},"children":[265]},{"id":274,"name":"TABLE_FUNCTION","properties":{"displayMem":false},"children":[273]},{"id":286,"name":"PROJECT","properties":{"displayMem":false},"children":[285]},{"id":294,"name":"TABLE_FUNCTION","properties":{"displayMem":false},"children":[293]},{"id":160,"name":"PROJECT","properties":{"displayMem":false},"children":[159]},{"id":168,"name":"PROJECT","properties":{"displayMem":false},"children":[167]},{"id":180,"name":"SORT","properties":{"sinkIds":[181],"displayMem":true},"children":[179]},{"id":188,"name":"PROJECT","properties":{"displayMem":false},"children":[187]},{"id":200,"name":"SORT","properties":{"sinkIds":[201],"displayMem":true},"children":[199]},{"id":208,"name":"PROJECT","properties":{"displayMem":false},"children":[207]},{"id":245,"name":"PROJECT","properties":{"displayMem":false},"children":[244]},{"id":253,"name":"PROJECT","properties":{"displayMem":false},"children":[252]},{"id":265,"name":"TABLE_FUNCTION","properties":{"displayMem":false},"children":[264]},{"id":273,"name":"PROJECT","properties":{"displayMem":false},"children":[272]},{"id":285,"name":"TABLE_FUNCTION","properties":{"displayMem":false},"children":[284]},{"id":293,"name":"PROJECT","properties":{"displayMem":false},"children":[292]},{"id":159,"name":"TABLE_FUNCTION","properties":{"displayMem":false},"children":[158]},{"id":167,"name":"TABLE_FUNCTION","properties":{"displayMem":false},"children":[166]},{"id":179,"name":"PROJECT","properties":{"displayMem":false},"children":[178]},{"id":187,"name":"TABLE_FUNCTION","properties":{"displayMem":false},"children":[186]},{"id":199,"name":"PROJECT","properties":{"displayMem":false},"children":[198]},{"id":207,"name":"TABLE_FUNCTION","properties":{"displayMem":false},"children":[206]},{"id":244,"name":"UNION","properties":{"displayMem":false},"children":[]},{"id":252,"name":"UNION","properties":{"displayMem":false},"children":[]},{"id":264,"name":"PROJECT","properties":{"displayMem":false},"children":[263]},{"id":272,"name":"UNION","properties":{"displayMem":false},"children":[]},{"id":284,"name":"PROJECT","properties":{"displayMem":false},"children":[283]},{"id":292,"name":"UNION","properties":{"displayMem":false},"children":[]},{"id":158,"name":"PROJECT","properties":{"displayMem":false},"children":[157]},{"id":166,"name":"PROJECT","properties":{"displayMem":false},"children":[165]},{"id":178,"name":"TABLE_FUNCTION","properties":{"displayMem":false},"children":[177]},{"id":186,"name":"PROJECT","properties":{"displayMem":false},"children":[185]},{"id":198,"name":"TABLE_FUNCTION","properties":{"displayMem":false},"children":[197]},{"id":206,"name":"PROJECT","properties":{"displayMem":false},"children":[205]},{"id":263,"name":"UNION","properties":{"displayMem":false},"children":[]},{"id":283,"name":"UNION","properties":{"displayMem":false},"children":[]},{"id":157,"name":"UNION","properties":{"displayMem":false},"children":[]},{"id":165,"name":"UNION","properties":{"displayMem":false},"children":[]},{"id":177,"name":"PROJECT","properties":{"displayMem":false},"children":[176]},{"id":185,"name":"UNION","properties":{"displayMem":false},"children":[]},{"id":197,"name":"PROJECT","properties":{"displayMem":false},"children":[196]},{"id":205,"name":"UNION","properties":{"displayMem":false},"children":[]},{"id":176,"name":"UNION","properties":{"displayMem":false},"children":[]},{"id":196,"name":"UNION","properties":{"displayMem":false},"children":[]}]} - FrontendProfileMergeTime: 32.759ms - QueryAllocatedMemoryUsage: 2.801 TB - QueryCumulativeCpuTime: 6m18s - QueryCumulativeNetworkTime: 1s719ms - QueryCumulativeOperatorTime: 6m32s - QueryCumulativeScanTime: 6m8s - QueryDeallocatedMemoryUsage: 2.796 TB - QueryExecutionWallTime: 2m28s - QueryPeakMemoryUsagePerNode: 8.712 GB - QueryPeakScheduleTime: 2s757ms - QuerySpillBytes: 0.000 B - QuerySumMemoryUsage: 11.679 GB - ResultDeliverTime: 1s875ms Fragment 0: - BackendAddresses: 10.0.27.71:9060 - InstanceIds: 019eb9a8-7b53-7289-8f38-bc3f2b520229 - BackendNum: 1 - BackendProfileMergeTime: 5.050ms - FragmentInstancePrepareTime: 10.827ms - InitialProcessDriverCount: 0 - InitialProcessMem: 13.743 GB - InstanceAllocatedMemoryUsage: 580.886 GB - InstanceDeallocatedMemoryUsage: 579.171 GB - InstanceNum: 1 - InstancePeakMemoryUsage: 4.326 GB - JITCounter: 0 - JITTotalCostTime: 0ns - QueryMemoryLimit: -1.000 B Pipeline (id=0): - IsGroupExecution: false - ActiveTime: 20.120us - __MAX_OF_ActiveTime: 54.368us - __MIN_OF_ActiveTime: 6.458us - BlockByInputEmpty: 1 - __MAX_OF_BlockByInputEmpty: 1 - __MIN_OF_BlockByInputEmpty: 0 - BlockByOutputFull: 0 - BlockByPrecondition: 0 - DegreeOfParallelism: 5 - DriverTotalTime: 42.325ms - __MAX_OF_DriverTotalTime: 42.367ms - __MIN_OF_DriverTotalTime: 42.292ms - PeakDriverQueueSize: 10 - __MAX_OF_PeakDriverQueueSize: 4 - __MIN_OF_PeakDriverQueueSize: 0 - PendingTime: 42.180ms - __MAX_OF_PendingTime: 42.204ms - __MIN_OF_PendingTime: 42.170ms - InputEmptyTime: 42.181ms - __MAX_OF_InputEmptyTime: 42.209ms - __MIN_OF_InputEmptyTime: 42.169ms - FirstInputEmptyTime: 42.174ms - __MAX_OF_FirstInputEmptyTime: 42.181ms - __MIN_OF_FirstInputEmptyTime: 42.169ms - ScheduleCount: 6 - __MAX_OF_ScheduleCount: 2 - __MIN_OF_ScheduleCount: 1 - TotalDegreeOfParallelism: 5 - YieldByLocalWait: 0 - YieldByPreempt: 0 - YieldByTimeLimit: 0 LOCAL_EXCHANGE_SINK (plan_node_id=338): CommonMetrics: - IsSubordinate - OperatorTotalTime: 1.825us - __MAX_OF_OperatorTotalTime: 3.654us - __MIN_OF_OperatorTotalTime: 1.145us - OutputChunkBytes: 0.000 B - PullChunkNum: 0 - PullRowNum: 0 - PullTotalTime: 0ns - PushChunkNum: 1 - __MAX_OF_PushChunkNum: 1 - __MIN_OF_PushChunkNum: 0 - PushRowNum: 3 - __MAX_OF_PushRowNum: 3 - __MIN_OF_PushRowNum: 0 - PushTotalTime: 572ns - __MAX_OF_PushTotalTime: 2.860us - __MIN_OF_PushTotalTime: 0ns UniqueMetrics: - ShuffleNum: 1 - Type: Passthrough - LocalExchangePeakMemoryUsage: 28.000 B EXCHANGE_SOURCE (plan_node_id=337): CommonMetrics: - ConjunctsInputRows: 3 - ConjunctsOutputRows: 3 - ConjunctsTime: 760ns - JoinRuntimeFilterEvaluate: 0 - JoinRuntimeFilterHashTime: 0ns - JoinRuntimeFilterInputRows: 0 - JoinRuntimeFilterOutputRows: 0 - JoinRuntimeFilterTime: 0ns - OperatorTotalTime: 16.047us - __MAX_OF_OperatorTotalTime: 41.091us - __MIN_OF_OperatorTotalTime: 6.798us - OutputChunkBytes: 27.000 B - __MAX_OF_OutputChunkBytes: 27.000 B - __MIN_OF_OutputChunkBytes: 0.000 B - PullChunkNum: 1 - __MAX_OF_PullChunkNum: 1 - __MIN_OF_PullChunkNum: 0 - PullRowNum: 3 - __MAX_OF_PullRowNum: 3 - __MIN_OF_PullRowNum: 0 - PullTotalTime: 8.002us - __MAX_OF_PullTotalTime: 40.013us - __MIN_OF_PullTotalTime: 0ns - PushChunkNum: 0 - PushRowNum: 0 - PushTotalTime: 0ns - RuntimeFilterNum: 0 - RuntimeInFilterNum: 0 UniqueMetrics: - BufferUnplugCount: 0 - BytesPassThrough: 0.000 B - BytesReceived: 44.000 B - __MAX_OF_BytesReceived: 44.000 B - __MIN_OF_BytesReceived: 0.000 B - ClosureBlockCount: 0 - ClosureBlockTime: 0ns - DecompressChunkTime: 544ns - __MAX_OF_DecompressChunkTime: 2.722us - __MIN_OF_DecompressChunkTime: 0ns - DeserializeChunkTime: 2.693us - __MAX_OF_DeserializeChunkTime: 13.469us - __MIN_OF_DeserializeChunkTime: 0ns - PeakBufferMemoryBytes: 44.000 B - __MAX_OF_PeakBufferMemoryBytes: 44.000 B - __MIN_OF_PeakBufferMemoryBytes: 0.000 B - ReceiverProcessTotalTime: 2.959us - __MAX_OF_ReceiverProcessTotalTime: 14.797us - __MIN_OF_ReceiverProcessTotalTime: 0ns - RequestReceived: 1 - __MAX_OF_RequestReceived: 1 - __MIN_OF_RequestReceived: 0 - WaitLockTime: 54ns - __MAX_OF_WaitLockTime: 271ns - __MIN_OF_WaitLockTime: 0ns Pipeline (id=1): - IsGroupExecution: false - ActiveTime: 3.962us - BlockByInputEmpty: 0 - BlockByOutputFull: 0 - BlockByPrecondition: 0 - DegreeOfParallelism: 1 - DriverTotalTime: 42.535ms - PeakDriverQueueSize: 0 - PendingTime: 42.482ms - InputEmptyTime: 42.481ms - FirstInputEmptyTime: 42.481ms - ScheduleCount: 1 - TotalDegreeOfParallelism: 1 - YieldByLocalWait: 0 - YieldByPreempt: 0 - YieldByTimeLimit: 0 NOOP_SINK (plan_node_id=338): CommonMetrics: - IsSubordinate - OperatorTotalTime: 627ns - OutputChunkBytes: 0.000 B - PullChunkNum: 0 - PullRowNum: 0 - PullTotalTime: 0ns - PushChunkNum: 0 - PushRowNum: 0 - PushTotalTime: 0ns UniqueMetrics: SPILL_PROCESS (plan_node_id=338): CommonMetrics: - IsSubordinate - OperatorTotalTime: 1.034us - OutputChunkBytes: 0.000 B - PullChunkNum: 0 - PullRowNum: 0 - PullTotalTime: 0ns - PushChunkNum: 0 - PushRowNum: 0 - PushTotalTime: 0ns UniqueMetrics: Pipeline (id=2): - IsGroupExecution: false - ActiveTime: 125.503us - BlockByInputEmpty: 0 - BlockByOutputFull: 0 - BlockByPrecondition: 0 - DegreeOfParallelism: 1 - DriverTotalTime: 42.474ms - PeakDriverQueueSize: 0 - PendingTime: 42.306ms - InputEmptyTime: 42.307ms - FirstInputEmptyTime: 42.307ms - ScheduleCount: 1 - TotalDegreeOfParallelism: 1 - YieldByLocalWait: 0 - YieldByPreempt: 0 - YieldByTimeLimit: 0 SPILLABLE_HASH_JOIN_BUILD (plan_node_id=338): CommonMetrics: - OperatorTotalTime: 116.572us - OutputChunkBytes: 0.000 B - PullChunkNum: 0 - PullRowNum: 0 - PullTotalTime: 0ns - PushChunkNum: 1 - PushRowNum: 3 - PushTotalTime: 17.083us - RuntimeFilterNum: 0 - RuntimeInFilterNum: 0 UniqueMetrics: - DistributionMode: BROADCAST - HashMapType: ONE_KEY-LINEAR_CHAINED-TIMESTAMP:1 - JoinPredicates: 3793: cast = 3773: expr - JoinType: INNER_JOIN - BuildBuckets: 8 - BuildConjunctEvaluateTime: 2.508us - BuildHashTableTime: 57.598us - BuildKeysPerBucket%: 100 - CopyRightTableChunkTime: 11.027us - HashTableMemoryUsage: 85.000 B - PartialRuntimeMembershipFilterBytes: 64.000 B - PartitionNums: 1 - PeakRevocableMemoryBytes: 37.000 B - RuntimeFilterBuildTime: 33.588us - RuntimeFilterNum: 1 - SpillStatistics: - AppendDataTime: 0ns - BlockCount: - LocalBlockCount: 0 - RemoteBlockCount: 0 - BytesFlush: 0.000 B - BytesFlushToLocalDisk: 0.000 B - BytesFlushToRemoteStorage: 0.000 B - BytesRestore: 0.000 B - BytesRestoreFromLocalDisk: 0.000 B - BytesRestoreFromRemoteStorage: 0.000 B - BytesRestoreFromMemTable: 0 - CompactBlockCount: 0 - CompactCount: 0 - DeserializeTime: 0ns - FlushIOTaskCount: 0 - FlushIOTaskYieldCount: 0 - FlushTime: 0ns - InputStreamPeakMemoryBytes: 0.000 B - MaterializeChunkTime: 0ns - MemTableFinalizeTime: 0ns - MemTablePeakMemoryBytes: 0.000 B - PartitionWriterPeakMemoryBytes: 0.000 B - PeakFlushIOTaskCount: 0 - PeakRestoreIOTaskCount: 0 - ReadIOCount: 0 - LocalReadIOCount: 0 - RemoteReadIOCount: 0 - ReadIOTime: 0ns - LocalReadIOTime: 0ns - RemoteReadIOTime: 0ns - RestoreIOTaskCount: 0 - RestoreIOTaskYieldCount: 0 - RestoreTime: 0ns - RowsRestoreFromMemTable: 0 - RowsRestored: 0 - RowsSpilled: 0 - SerializeTime: 0ns - ShuffleTime: 0ns - SkewMemTableCount: 0 - SkewMemTableInputBytes: 0.000 B - SkewMemTableInputRows: 0 - SkewMemTableMergeTime: 0ns - SkewMemTableOutputBytes: 0.000 B - SkewMemTableOutputRows: 0 - SkewMemTableSkewRatio: 9223372036854776000.000 - SortChunkTime: 0ns - SplitPartitionTime: 0ns - WriteIOTime: 0ns - LocalWriteIOTime: 0ns - RemoteWriteIOTime: 0ns LOCAL_EXCHANGE_SOURCE (plan_node_id=338): CommonMetrics: - IsSubordinate - OperatorTotalTime: 6.456us - OutputChunkBytes: 27.000 B - PullChunkNum: 1 - PullRowNum: 3 - PullTotalTime: 4.006us - PushChunkNum: 0 - PushRowNum: 0 - PushTotalTime: 0ns UniqueMetrics: Pipeline (id=3): - IsGroupExecution: false - ActiveTime: 7.876us - __MAX_OF_ActiveTime: 10.597us - __MIN_OF_ActiveTime: 5.677us - BlockByInputEmpty: 0 - BlockByOutputFull: 0 - BlockByPrecondition: 0 - DegreeOfParallelism: 5 - DriverTotalTime: 2m17s - __MAX_OF_DriverTotalTime: 2m17s - __MIN_OF_DriverTotalTime: 2m17s - PeakDriverQueueSize: 71 - __MAX_OF_PeakDriverQueueSize: 20 - __MIN_OF_PeakDriverQueueSize: 3 - PendingTime: 2m17s - __MAX_OF_PendingTime: 2m17s - __MIN_OF_PendingTime: 2m17s - InputEmptyTime: 2m17s - __MAX_OF_InputEmptyTime: 2m17s - __MIN_OF_InputEmptyTime: 2m17s - FirstInputEmptyTime: 2m17s - __MAX_OF_FirstInputEmptyTime: 2m17s - __MIN_OF_FirstInputEmptyTime: 2m17s - ScheduleCount: 5 - __MAX_OF_ScheduleCount: 1 - __MIN_OF_ScheduleCount: 1 - ScheduleTime: 6.379ms - __MAX_OF_ScheduleTime: 8.457ms - __MIN_OF_ScheduleTime: 1.086ms - TotalDegreeOfParallelism: 5 - YieldByLocalWait: 0 - YieldByPreempt: 0 - YieldByTimeLimit: 0 NOOP_SINK (plan_node_id=328): CommonMetrics: - IsSubordinate - OperatorTotalTime: 615ns - __MAX_OF_OperatorTotalTime: 878ns - __MIN_OF_OperatorTotalTime: 292ns - OutputChunkBytes: 0.000 B - PullChunkNum: 0 - PullRowNum: 0 - PullTotalTime: 0ns - PushChunkNum: 0 - PushRowNum: 0 - PushTotalTime: 0ns UniqueMetrics: SPILL_PROCESS (plan_node_id=328): CommonMetrics: - IsSubordinate - OperatorTotalTime: 1.297us - __MAX_OF_OperatorTotalTime: 1.822us - __MIN_OF_OperatorTotalTime: 845ns - OutputChunkBytes: 0.000 B - PullChunkNum: 0 - PullRowNum: 0 - PullTotalTime: 0ns - PushChunkNum: 0 - PushRowNum: 0 - PushTotalTime: 0ns UniqueMetrics: Pipeline (id=4): - IsGroupExecution: false - ActiveTime: 749.602ms - __MAX_OF_ActiveTime: 3s746ms - __MIN_OF_ActiveTime: 302.312us - BlockByInputEmpty: 9 - __MAX_OF_BlockByInputEmpty: 9 - __MIN_OF_BlockByInputEmpty: 0 - BlockByOutputFull: 0 - BlockByPrecondition: 0 - DegreeOfParallelism: 5 - DriverTotalTime: 2m17s - __MAX_OF_DriverTotalTime: 2m17s - __MIN_OF_DriverTotalTime: 2m17s - OverheadTime: 10.959ms - __MAX_OF_OverheadTime: 54.799ms - __MIN_OF_OverheadTime: 0ns - PeakDriverQueueSize: 35 - __MAX_OF_PeakDriverQueueSize: 9 - __MIN_OF_PeakDriverQueueSize: 5 - PendingTime: 2m16s - __MAX_OF_PendingTime: 2m17s - __MIN_OF_PendingTime: 2m14s - InputEmptyTime: 2m16s - __MAX_OF_InputEmptyTime: 2m17s - __MIN_OF_InputEmptyTime: 2m14s - FirstInputEmptyTime: 2m16s - __MAX_OF_FirstInputEmptyTime: 2m17s - __MIN_OF_FirstInputEmptyTime: 2m13s - FollowupInputEmptyTime: 37.036ms - __MAX_OF_FollowupInputEmptyTime: 185.184ms - __MIN_OF_FollowupInputEmptyTime: 0ns - ScheduleCount: 47 - __MAX_OF_ScheduleCount: 43 - __MIN_OF_ScheduleCount: 1 - ScheduleTime: 1.328ms - __MAX_OF_ScheduleTime: 2.441ms - __MIN_OF_ScheduleTime: 981.140us - TotalDegreeOfParallelism: 5 - YieldByLocalWait: 0 - YieldByPreempt: 0 - YieldByTimeLimit: 33 - __MAX_OF_YieldByTimeLimit: 33 - __MIN_OF_YieldByTimeLimit: 0 SPILLABLE_HASH_JOIN_BUILD (plan_node_id=328): CommonMetrics: - OperatorTotalTime: 684.608ms - __MAX_OF_OperatorTotalTime: 3s421ms - __MIN_OF_OperatorTotalTime: 304.930us - OutputChunkBytes: 0.000 B - PullChunkNum: 0 - PullRowNum: 0 - PullTotalTime: 0ns - PushChunkNum: 691 - __MAX_OF_PushChunkNum: 691 - __MIN_OF_PushChunkNum: 0 - PushRowNum: 2.403M (2402729) - __MAX_OF_PushRowNum: 2.403M (2402729) - __MIN_OF_PushRowNum: 0 - PushTotalTime: 640.802ms - __MAX_OF_PushTotalTime: 3s204ms - __MIN_OF_PushTotalTime: 0ns - RuntimeFilterNum: 0 - RuntimeInFilterNum: 0 - SetFinishingTime: 43.761ms - __MAX_OF_SetFinishingTime: 217.117ms - __MIN_OF_SetFinishingTime: 291.093us UniqueMetrics: - DistributionMode: LOCAL_HASH_BUCKET - HashMapType: SERIALIZED-LINEAR_CHAINED-VARCHAR:16 - JoinPredicates: 3757: CONTRACT_NO = 1606: contract_no, 3756: REPORT_MONTH = 2103: date_format - JoinType: RIGHT_OUTER_JOIN - HashMapType__DUP(0): EMPTY:1