DC2 - Details for Query 13

Details for Query 13

Submitted Time: 2026/03/05 07:13:36
Duration: 0.2 s
Succeeded Jobs: 23
Show the Stage ID and Task ID that corresponds to the max metric
Details
== Parsed Logical Plan ==
GlobalLimit 500000
+- LocalLimit 500000
   +- Project [COL_2FF1A39D_4FA8_4890_A424_FA045DACBABB#2714 AS COL_2FF1A39D_4FA8_4890_A424_FA045DACBABB#2722, COL_4C98E2EF_DDAC_4AD8_BF0B_CD1EC268B902#2715 AS COL_4C98E2EF_DDAC_4AD8_BF0B_CD1EC268B902#2723, COL_1317ED80_3DBC_40E4_9C4A_4FCD9980386B#2716 AS COL_1317ED80_3DBC_40E4_9C4A_4FCD9980386B#2724, COL_C4F25DDE_86AD_4686_8C56_BE77EFFE1FCA#2717 AS COL_C4F25DDE_86AD_4686_8C56_BE77EFFE1FCA#2725]
      +- Project [COL_2FF1A39D_4FA8_4890_A424_FA045DACBABB#2706 AS COL_2FF1A39D_4FA8_4890_A424_FA045DACBABB#2714, COL_4C98E2EF_DDAC_4AD8_BF0B_CD1EC268B902#2707 AS COL_4C98E2EF_DDAC_4AD8_BF0B_CD1EC268B902#2715, COL_1317ED80_3DBC_40E4_9C4A_4FCD9980386B#2708 AS COL_1317ED80_3DBC_40E4_9C4A_4FCD9980386B#2716, COL_C4F25DDE_86AD_4686_8C56_BE77EFFE1FCA#2709 AS COL_C4F25DDE_86AD_4686_8C56_BE77EFFE1FCA#2717]
         +- Project [COL_2FF1A39D_4FA8_4890_A424_FA045DACBABB#2698 AS COL_2FF1A39D_4FA8_4890_A424_FA045DACBABB#2706, COL_4C98E2EF_DDAC_4AD8_BF0B_CD1EC268B902#2699 AS COL_4C98E2EF_DDAC_4AD8_BF0B_CD1EC268B902#2707, COL_1317ED80_3DBC_40E4_9C4A_4FCD9980386B#2700 AS COL_1317ED80_3DBC_40E4_9C4A_4FCD9980386B#2708, COL_C4F25DDE_86AD_4686_8C56_BE77EFFE1FCA#2701 AS COL_C4F25DDE_86AD_4686_8C56_BE77EFFE1FCA#2709]
            +- Project [COL_2FF1A39D_4FA8_4890_A424_FA045DACBABB#2690 AS COL_2FF1A39D_4FA8_4890_A424_FA045DACBABB#2698, COL_4C98E2EF_DDAC_4AD8_BF0B_CD1EC268B902#2691 AS COL_4C98E2EF_DDAC_4AD8_BF0B_CD1EC268B902#2699, COL_1317ED80_3DBC_40E4_9C4A_4FCD9980386B#2692 AS COL_1317ED80_3DBC_40E4_9C4A_4FCD9980386B#2700, COL_C4F25DDE_86AD_4686_8C56_BE77EFFE1FCA#2693 AS COL_C4F25DDE_86AD_4686_8C56_BE77EFFE1FCA#2701]
               +- Project [COL_2FF1A39D_4FA8_4890_A424_FA045DACBABB#2666 AS COL_2FF1A39D_4FA8_4890_A424_FA045DACBABB#2690, COL_4C98E2EF_DDAC_4AD8_BF0B_CD1EC268B902#2667 AS COL_4C98E2EF_DDAC_4AD8_BF0B_CD1EC268B902#2691, COL_1317ED80_3DBC_40E4_9C4A_4FCD9980386B#2668 AS COL_1317ED80_3DBC_40E4_9C4A_4FCD9980386B#2692, COL_C4F25DDE_86AD_4686_8C56_BE77EFFE1FCA#2669 AS COL_C4F25DDE_86AD_4686_8C56_BE77EFFE1FCA#2693]
                  +- Project [COL_2FF1A39D_4FA8_4890_A424_FA045DACBABB#2666, COL_4C98E2EF_DDAC_4AD8_BF0B_CD1EC268B902#2667, COL_1317ED80_3DBC_40E4_9C4A_4FCD9980386B#2668, COL_C4F25DDE_86AD_4686_8C56_BE77EFFE1FCA#2669]
                     +- Project [cast(QUALITE_REFEREN_36804_COL_4527A65C_D87F_415F_B980_36B0177AB7DC#2638 as string) AS COL_2FF1A39D_4FA8_4890_A424_FA045DACBABB#2666, cast(QUALITE_REFEREN_36804_COL_C2CB73AD_8503_48AE_9E4C_D00723D883F3#2640 as int) AS COL_4C98E2EF_DDAC_4AD8_BF0B_CD1EC268B902#2667, cast(QUALITE_REFEREN_36804_COL_6E166050_3FFC_43E9_9135_3CAB9BA345E3#2642 as int) AS COL_1317ED80_3DBC_40E4_9C4A_4FCD9980386B#2668, cast(QUALITE_REFEREN_36804_COL_FA682729_CA34_4EE2_88BF_6E1B768CC02C#2645 as double) AS COL_C4F25DDE_86AD_4686_8C56_BE77EFFE1FCA#2669]
                        +- Project [COL_4527A65C_D87F_415F_B980_36B0177AB7DC#2618 AS QUALITE_REFEREN_36804_COL_4527A65C_D87F_415F_B980_36B0177AB7DC#2638, COL_C2CB73AD_8503_48AE_9E4C_D00723D883F3#2619 AS QUALITE_REFEREN_36804_COL_C2CB73AD_8503_48AE_9E4C_D00723D883F3#2640, COL_6E166050_3FFC_43E9_9135_3CAB9BA345E3#2620 AS QUALITE_REFEREN_36804_COL_6E166050_3FFC_43E9_9135_3CAB9BA345E3#2642, COL_FA682729_CA34_4EE2_88BF_6E1B768CC02C#2621 AS QUALITE_REFEREN_36804_COL_FA682729_CA34_4EE2_88BF_6E1B768CC02C#2645]
                           +- SubqueryAlias QUALITE_REFEREN_36804116
                              +- Relation[COL_4527A65C_D87F_415F_B980_36B0177AB7DC#2618,COL_C2CB73AD_8503_48AE_9E4C_D00723D883F3#2619,COL_6E166050_3FFC_43E9_9135_3CAB9BA345E3#2620,COL_FA682729_CA34_4EE2_88BF_6E1B768CC02C#2621] parquet

== Analyzed Logical Plan ==
COL_2FF1A39D_4FA8_4890_A424_FA045DACBABB: string, COL_4C98E2EF_DDAC_4AD8_BF0B_CD1EC268B902: int, COL_1317ED80_3DBC_40E4_9C4A_4FCD9980386B: int, COL_C4F25DDE_86AD_4686_8C56_BE77EFFE1FCA: double
GlobalLimit 500000
+- LocalLimit 500000
   +- Project [COL_2FF1A39D_4FA8_4890_A424_FA045DACBABB#2714 AS COL_2FF1A39D_4FA8_4890_A424_FA045DACBABB#2722, COL_4C98E2EF_DDAC_4AD8_BF0B_CD1EC268B902#2715 AS COL_4C98E2EF_DDAC_4AD8_BF0B_CD1EC268B902#2723, COL_1317ED80_3DBC_40E4_9C4A_4FCD9980386B#2716 AS COL_1317ED80_3DBC_40E4_9C4A_4FCD9980386B#2724, COL_C4F25DDE_86AD_4686_8C56_BE77EFFE1FCA#2717 AS COL_C4F25DDE_86AD_4686_8C56_BE77EFFE1FCA#2725]
      +- Project [COL_2FF1A39D_4FA8_4890_A424_FA045DACBABB#2706 AS COL_2FF1A39D_4FA8_4890_A424_FA045DACBABB#2714, COL_4C98E2EF_DDAC_4AD8_BF0B_CD1EC268B902#2707 AS COL_4C98E2EF_DDAC_4AD8_BF0B_CD1EC268B902#2715, COL_1317ED80_3DBC_40E4_9C4A_4FCD9980386B#2708 AS COL_1317ED80_3DBC_40E4_9C4A_4FCD9980386B#2716, COL_C4F25DDE_86AD_4686_8C56_BE77EFFE1FCA#2709 AS COL_C4F25DDE_86AD_4686_8C56_BE77EFFE1FCA#2717]
         +- Project [COL_2FF1A39D_4FA8_4890_A424_FA045DACBABB#2698 AS COL_2FF1A39D_4FA8_4890_A424_FA045DACBABB#2706, COL_4C98E2EF_DDAC_4AD8_BF0B_CD1EC268B902#2699 AS COL_4C98E2EF_DDAC_4AD8_BF0B_CD1EC268B902#2707, COL_1317ED80_3DBC_40E4_9C4A_4FCD9980386B#2700 AS COL_1317ED80_3DBC_40E4_9C4A_4FCD9980386B#2708, COL_C4F25DDE_86AD_4686_8C56_BE77EFFE1FCA#2701 AS COL_C4F25DDE_86AD_4686_8C56_BE77EFFE1FCA#2709]
            +- Project [COL_2FF1A39D_4FA8_4890_A424_FA045DACBABB#2690 AS COL_2FF1A39D_4FA8_4890_A424_FA045DACBABB#2698, COL_4C98E2EF_DDAC_4AD8_BF0B_CD1EC268B902#2691 AS COL_4C98E2EF_DDAC_4AD8_BF0B_CD1EC268B902#2699, COL_1317ED80_3DBC_40E4_9C4A_4FCD9980386B#2692 AS COL_1317ED80_3DBC_40E4_9C4A_4FCD9980386B#2700, COL_C4F25DDE_86AD_4686_8C56_BE77EFFE1FCA#2693 AS COL_C4F25DDE_86AD_4686_8C56_BE77EFFE1FCA#2701]
               +- Project [COL_2FF1A39D_4FA8_4890_A424_FA045DACBABB#2666 AS COL_2FF1A39D_4FA8_4890_A424_FA045DACBABB#2690, COL_4C98E2EF_DDAC_4AD8_BF0B_CD1EC268B902#2667 AS COL_4C98E2EF_DDAC_4AD8_BF0B_CD1EC268B902#2691, COL_1317ED80_3DBC_40E4_9C4A_4FCD9980386B#2668 AS COL_1317ED80_3DBC_40E4_9C4A_4FCD9980386B#2692, COL_C4F25DDE_86AD_4686_8C56_BE77EFFE1FCA#2669 AS COL_C4F25DDE_86AD_4686_8C56_BE77EFFE1FCA#2693]
                  +- Project [COL_2FF1A39D_4FA8_4890_A424_FA045DACBABB#2666, COL_4C98E2EF_DDAC_4AD8_BF0B_CD1EC268B902#2667, COL_1317ED80_3DBC_40E4_9C4A_4FCD9980386B#2668, COL_C4F25DDE_86AD_4686_8C56_BE77EFFE1FCA#2669]
                     +- Project [cast(QUALITE_REFEREN_36804_COL_4527A65C_D87F_415F_B980_36B0177AB7DC#2638 as string) AS COL_2FF1A39D_4FA8_4890_A424_FA045DACBABB#2666, cast(QUALITE_REFEREN_36804_COL_C2CB73AD_8503_48AE_9E4C_D00723D883F3#2640 as int) AS COL_4C98E2EF_DDAC_4AD8_BF0B_CD1EC268B902#2667, cast(QUALITE_REFEREN_36804_COL_6E166050_3FFC_43E9_9135_3CAB9BA345E3#2642 as int) AS COL_1317ED80_3DBC_40E4_9C4A_4FCD9980386B#2668, cast(QUALITE_REFEREN_36804_COL_FA682729_CA34_4EE2_88BF_6E1B768CC02C#2645 as double) AS COL_C4F25DDE_86AD_4686_8C56_BE77EFFE1FCA#2669]
                        +- Project [COL_4527A65C_D87F_415F_B980_36B0177AB7DC#2618 AS QUALITE_REFEREN_36804_COL_4527A65C_D87F_415F_B980_36B0177AB7DC#2638, COL_C2CB73AD_8503_48AE_9E4C_D00723D883F3#2619 AS QUALITE_REFEREN_36804_COL_C2CB73AD_8503_48AE_9E4C_D00723D883F3#2640, COL_6E166050_3FFC_43E9_9135_3CAB9BA345E3#2620 AS QUALITE_REFEREN_36804_COL_6E166050_3FFC_43E9_9135_3CAB9BA345E3#2642, COL_FA682729_CA34_4EE2_88BF_6E1B768CC02C#2621 AS QUALITE_REFEREN_36804_COL_FA682729_CA34_4EE2_88BF_6E1B768CC02C#2645]
                           +- SubqueryAlias QUALITE_REFEREN_36804116
                              +- Relation[COL_4527A65C_D87F_415F_B980_36B0177AB7DC#2618,COL_C2CB73AD_8503_48AE_9E4C_D00723D883F3#2619,COL_6E166050_3FFC_43E9_9135_3CAB9BA345E3#2620,COL_FA682729_CA34_4EE2_88BF_6E1B768CC02C#2621] parquet

== Optimized Logical Plan ==
GlobalLimit 500000
+- LocalLimit 500000
   +- Project [COL_4527A65C_D87F_415F_B980_36B0177AB7DC#2618 AS COL_2FF1A39D_4FA8_4890_A424_FA045DACBABB#2722, COL_C2CB73AD_8503_48AE_9E4C_D00723D883F3#2619 AS COL_4C98E2EF_DDAC_4AD8_BF0B_CD1EC268B902#2723, COL_6E166050_3FFC_43E9_9135_3CAB9BA345E3#2620 AS COL_1317ED80_3DBC_40E4_9C4A_4FCD9980386B#2724, COL_FA682729_CA34_4EE2_88BF_6E1B768CC02C#2621 AS COL_C4F25DDE_86AD_4686_8C56_BE77EFFE1FCA#2725]
      +- Relation[COL_4527A65C_D87F_415F_B980_36B0177AB7DC#2618,COL_C2CB73AD_8503_48AE_9E4C_D00723D883F3#2619,COL_6E166050_3FFC_43E9_9135_3CAB9BA345E3#2620,COL_FA682729_CA34_4EE2_88BF_6E1B768CC02C#2621] parquet

== Physical Plan ==
CollectLimit 500000
+- *(1) Project [COL_4527A65C_D87F_415F_B980_36B0177AB7DC#2618 AS COL_2FF1A39D_4FA8_4890_A424_FA045DACBABB#2722, COL_C2CB73AD_8503_48AE_9E4C_D00723D883F3#2619 AS COL_4C98E2EF_DDAC_4AD8_BF0B_CD1EC268B902#2723, COL_6E166050_3FFC_43E9_9135_3CAB9BA345E3#2620 AS COL_1317ED80_3DBC_40E4_9C4A_4FCD9980386B#2724, COL_FA682729_CA34_4EE2_88BF_6E1B768CC02C#2621 AS COL_C4F25DDE_86AD_4686_8C56_BE77EFFE1FCA#2725]
   +- *(1) ColumnarToRow
      +- FileScan parquet [COL_4527A65C_D87F_415F_B980_36B0177AB7DC#2618,COL_C2CB73AD_8503_48AE_9E4C_D00723D883F3#2619,COL_6E166050_3FFC_43E9_9135_3CAB9BA345E3#2620,COL_FA682729_CA34_4EE2_88BF_6E1B768CC02C#2621] Batched: true, DataFilters: [], Format: Parquet, Location: InMemoryFileIndex[file:/data/output/cache/parquet/datablock/QUALITE_REFEREN_36804], PartitionFilters: [], PushedFilters: [], ReadSchema: struct<COL_4527A65C_D87F_415F_B980_36B0177AB7DC:string,COL_C2CB73AD_8503_48AE_9E4C_D00723D883F3:i...