DC2 - Details for Query 61

Details for Query 61

Submitted Time: 2025/11/07 08:58:33
Duration: 70 ms
Succeeded Jobs: 87
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#19669 AS COL_2FF1A39D_4FA8_4890_A424_FA045DACBABB#19699, COL_4C98E2EF_DDAC_4AD8_BF0B_CD1EC268B902#19670 AS COL_4C98E2EF_DDAC_4AD8_BF0B_CD1EC268B902#19700, COL_1317ED80_3DBC_40E4_9C4A_4FCD9980386B#19671 AS COL_1317ED80_3DBC_40E4_9C4A_4FCD9980386B#19701, COL_C4F25DDE_86AD_4686_8C56_BE77EFFE1FCA#19672 AS COL_C4F25DDE_86AD_4686_8C56_BE77EFFE1FCA#19702]
      +- Project [COL_2FF1A39D_4FA8_4890_A424_FA045DACBABB#19661 AS COL_2FF1A39D_4FA8_4890_A424_FA045DACBABB#19669, COL_4C98E2EF_DDAC_4AD8_BF0B_CD1EC268B902#19662 AS COL_4C98E2EF_DDAC_4AD8_BF0B_CD1EC268B902#19670, COL_1317ED80_3DBC_40E4_9C4A_4FCD9980386B#19663 AS COL_1317ED80_3DBC_40E4_9C4A_4FCD9980386B#19671, COL_C4F25DDE_86AD_4686_8C56_BE77EFFE1FCA#19664 AS COL_C4F25DDE_86AD_4686_8C56_BE77EFFE1FCA#19672]
         +- Project [COL_2FF1A39D_4FA8_4890_A424_FA045DACBABB#19653 AS COL_2FF1A39D_4FA8_4890_A424_FA045DACBABB#19661, COL_4C98E2EF_DDAC_4AD8_BF0B_CD1EC268B902#19654 AS COL_4C98E2EF_DDAC_4AD8_BF0B_CD1EC268B902#19662, COL_1317ED80_3DBC_40E4_9C4A_4FCD9980386B#19655 AS COL_1317ED80_3DBC_40E4_9C4A_4FCD9980386B#19663, COL_C4F25DDE_86AD_4686_8C56_BE77EFFE1FCA#19656 AS COL_C4F25DDE_86AD_4686_8C56_BE77EFFE1FCA#19664]
            +- Project [COL_2FF1A39D_4FA8_4890_A424_FA045DACBABB#19623 AS COL_2FF1A39D_4FA8_4890_A424_FA045DACBABB#19653, COL_4C98E2EF_DDAC_4AD8_BF0B_CD1EC268B902#19624 AS COL_4C98E2EF_DDAC_4AD8_BF0B_CD1EC268B902#19654, COL_1317ED80_3DBC_40E4_9C4A_4FCD9980386B#19625 AS COL_1317ED80_3DBC_40E4_9C4A_4FCD9980386B#19655, COL_C4F25DDE_86AD_4686_8C56_BE77EFFE1FCA#19626 AS COL_C4F25DDE_86AD_4686_8C56_BE77EFFE1FCA#19656]
               +- Project [COL_2FF1A39D_4FA8_4890_A424_FA045DACBABB#19567 AS COL_2FF1A39D_4FA8_4890_A424_FA045DACBABB#19623, COL_4C98E2EF_DDAC_4AD8_BF0B_CD1EC268B902#19568 AS COL_4C98E2EF_DDAC_4AD8_BF0B_CD1EC268B902#19624, COL_1317ED80_3DBC_40E4_9C4A_4FCD9980386B#19569 AS COL_1317ED80_3DBC_40E4_9C4A_4FCD9980386B#19625, COL_C4F25DDE_86AD_4686_8C56_BE77EFFE1FCA#19570 AS COL_C4F25DDE_86AD_4686_8C56_BE77EFFE1FCA#19626]
                  +- Project [COL_2FF1A39D_4FA8_4890_A424_FA045DACBABB#19567, COL_4C98E2EF_DDAC_4AD8_BF0B_CD1EC268B902#19568, COL_1317ED80_3DBC_40E4_9C4A_4FCD9980386B#19569, COL_C4F25DDE_86AD_4686_8C56_BE77EFFE1FCA#19570]
                     +- Project [cast(QUALITE_REFEREN_36804_COL_4527A65C_D87F_415F_B980_36B0177AB7DC#19555 as string) AS COL_2FF1A39D_4FA8_4890_A424_FA045DACBABB#19567, cast(QUALITE_REFEREN_36804_COL_C2CB73AD_8503_48AE_9E4C_D00723D883F3#19556 as int) AS COL_4C98E2EF_DDAC_4AD8_BF0B_CD1EC268B902#19568, cast(QUALITE_REFEREN_36804_COL_6E166050_3FFC_43E9_9135_3CAB9BA345E3#19557 as int) AS COL_1317ED80_3DBC_40E4_9C4A_4FCD9980386B#19569, cast(QUALITE_REFEREN_36804_COL_FA682729_CA34_4EE2_88BF_6E1B768CC02C#19558 as double) AS COL_C4F25DDE_86AD_4686_8C56_BE77EFFE1FCA#19570]
                        +- Project [COL_4527A65C_D87F_415F_B980_36B0177AB7DC#19477 AS QUALITE_REFEREN_36804_COL_4527A65C_D87F_415F_B980_36B0177AB7DC#19555, COL_C2CB73AD_8503_48AE_9E4C_D00723D883F3#19478 AS QUALITE_REFEREN_36804_COL_C2CB73AD_8503_48AE_9E4C_D00723D883F3#19556, COL_6E166050_3FFC_43E9_9135_3CAB9BA345E3#19479 AS QUALITE_REFEREN_36804_COL_6E166050_3FFC_43E9_9135_3CAB9BA345E3#19557, COL_FA682729_CA34_4EE2_88BF_6E1B768CC02C#19480 AS QUALITE_REFEREN_36804_COL_FA682729_CA34_4EE2_88BF_6E1B768CC02C#19558]
                           +- SubqueryAlias QUALITE_REFEREN_36804116
                              +- Relation[COL_4527A65C_D87F_415F_B980_36B0177AB7DC#19477,COL_C2CB73AD_8503_48AE_9E4C_D00723D883F3#19478,COL_6E166050_3FFC_43E9_9135_3CAB9BA345E3#19479,COL_FA682729_CA34_4EE2_88BF_6E1B768CC02C#19480] 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#19669 AS COL_2FF1A39D_4FA8_4890_A424_FA045DACBABB#19699, COL_4C98E2EF_DDAC_4AD8_BF0B_CD1EC268B902#19670 AS COL_4C98E2EF_DDAC_4AD8_BF0B_CD1EC268B902#19700, COL_1317ED80_3DBC_40E4_9C4A_4FCD9980386B#19671 AS COL_1317ED80_3DBC_40E4_9C4A_4FCD9980386B#19701, COL_C4F25DDE_86AD_4686_8C56_BE77EFFE1FCA#19672 AS COL_C4F25DDE_86AD_4686_8C56_BE77EFFE1FCA#19702]
      +- Project [COL_2FF1A39D_4FA8_4890_A424_FA045DACBABB#19661 AS COL_2FF1A39D_4FA8_4890_A424_FA045DACBABB#19669, COL_4C98E2EF_DDAC_4AD8_BF0B_CD1EC268B902#19662 AS COL_4C98E2EF_DDAC_4AD8_BF0B_CD1EC268B902#19670, COL_1317ED80_3DBC_40E4_9C4A_4FCD9980386B#19663 AS COL_1317ED80_3DBC_40E4_9C4A_4FCD9980386B#19671, COL_C4F25DDE_86AD_4686_8C56_BE77EFFE1FCA#19664 AS COL_C4F25DDE_86AD_4686_8C56_BE77EFFE1FCA#19672]
         +- Project [COL_2FF1A39D_4FA8_4890_A424_FA045DACBABB#19653 AS COL_2FF1A39D_4FA8_4890_A424_FA045DACBABB#19661, COL_4C98E2EF_DDAC_4AD8_BF0B_CD1EC268B902#19654 AS COL_4C98E2EF_DDAC_4AD8_BF0B_CD1EC268B902#19662, COL_1317ED80_3DBC_40E4_9C4A_4FCD9980386B#19655 AS COL_1317ED80_3DBC_40E4_9C4A_4FCD9980386B#19663, COL_C4F25DDE_86AD_4686_8C56_BE77EFFE1FCA#19656 AS COL_C4F25DDE_86AD_4686_8C56_BE77EFFE1FCA#19664]
            +- Project [COL_2FF1A39D_4FA8_4890_A424_FA045DACBABB#19623 AS COL_2FF1A39D_4FA8_4890_A424_FA045DACBABB#19653, COL_4C98E2EF_DDAC_4AD8_BF0B_CD1EC268B902#19624 AS COL_4C98E2EF_DDAC_4AD8_BF0B_CD1EC268B902#19654, COL_1317ED80_3DBC_40E4_9C4A_4FCD9980386B#19625 AS COL_1317ED80_3DBC_40E4_9C4A_4FCD9980386B#19655, COL_C4F25DDE_86AD_4686_8C56_BE77EFFE1FCA#19626 AS COL_C4F25DDE_86AD_4686_8C56_BE77EFFE1FCA#19656]
               +- Project [COL_2FF1A39D_4FA8_4890_A424_FA045DACBABB#19567 AS COL_2FF1A39D_4FA8_4890_A424_FA045DACBABB#19623, COL_4C98E2EF_DDAC_4AD8_BF0B_CD1EC268B902#19568 AS COL_4C98E2EF_DDAC_4AD8_BF0B_CD1EC268B902#19624, COL_1317ED80_3DBC_40E4_9C4A_4FCD9980386B#19569 AS COL_1317ED80_3DBC_40E4_9C4A_4FCD9980386B#19625, COL_C4F25DDE_86AD_4686_8C56_BE77EFFE1FCA#19570 AS COL_C4F25DDE_86AD_4686_8C56_BE77EFFE1FCA#19626]
                  +- Project [COL_2FF1A39D_4FA8_4890_A424_FA045DACBABB#19567, COL_4C98E2EF_DDAC_4AD8_BF0B_CD1EC268B902#19568, COL_1317ED80_3DBC_40E4_9C4A_4FCD9980386B#19569, COL_C4F25DDE_86AD_4686_8C56_BE77EFFE1FCA#19570]
                     +- Project [cast(QUALITE_REFEREN_36804_COL_4527A65C_D87F_415F_B980_36B0177AB7DC#19555 as string) AS COL_2FF1A39D_4FA8_4890_A424_FA045DACBABB#19567, cast(QUALITE_REFEREN_36804_COL_C2CB73AD_8503_48AE_9E4C_D00723D883F3#19556 as int) AS COL_4C98E2EF_DDAC_4AD8_BF0B_CD1EC268B902#19568, cast(QUALITE_REFEREN_36804_COL_6E166050_3FFC_43E9_9135_3CAB9BA345E3#19557 as int) AS COL_1317ED80_3DBC_40E4_9C4A_4FCD9980386B#19569, cast(QUALITE_REFEREN_36804_COL_FA682729_CA34_4EE2_88BF_6E1B768CC02C#19558 as double) AS COL_C4F25DDE_86AD_4686_8C56_BE77EFFE1FCA#19570]
                        +- Project [COL_4527A65C_D87F_415F_B980_36B0177AB7DC#19477 AS QUALITE_REFEREN_36804_COL_4527A65C_D87F_415F_B980_36B0177AB7DC#19555, COL_C2CB73AD_8503_48AE_9E4C_D00723D883F3#19478 AS QUALITE_REFEREN_36804_COL_C2CB73AD_8503_48AE_9E4C_D00723D883F3#19556, COL_6E166050_3FFC_43E9_9135_3CAB9BA345E3#19479 AS QUALITE_REFEREN_36804_COL_6E166050_3FFC_43E9_9135_3CAB9BA345E3#19557, COL_FA682729_CA34_4EE2_88BF_6E1B768CC02C#19480 AS QUALITE_REFEREN_36804_COL_FA682729_CA34_4EE2_88BF_6E1B768CC02C#19558]
                           +- SubqueryAlias QUALITE_REFEREN_36804116
                              +- Relation[COL_4527A65C_D87F_415F_B980_36B0177AB7DC#19477,COL_C2CB73AD_8503_48AE_9E4C_D00723D883F3#19478,COL_6E166050_3FFC_43E9_9135_3CAB9BA345E3#19479,COL_FA682729_CA34_4EE2_88BF_6E1B768CC02C#19480] parquet

== Optimized Logical Plan ==
GlobalLimit 500000
+- LocalLimit 500000
   +- Project [COL_4527A65C_D87F_415F_B980_36B0177AB7DC#19477 AS COL_2FF1A39D_4FA8_4890_A424_FA045DACBABB#19699, COL_C2CB73AD_8503_48AE_9E4C_D00723D883F3#19478 AS COL_4C98E2EF_DDAC_4AD8_BF0B_CD1EC268B902#19700, COL_6E166050_3FFC_43E9_9135_3CAB9BA345E3#19479 AS COL_1317ED80_3DBC_40E4_9C4A_4FCD9980386B#19701, COL_FA682729_CA34_4EE2_88BF_6E1B768CC02C#19480 AS COL_C4F25DDE_86AD_4686_8C56_BE77EFFE1FCA#19702]
      +- Relation[COL_4527A65C_D87F_415F_B980_36B0177AB7DC#19477,COL_C2CB73AD_8503_48AE_9E4C_D00723D883F3#19478,COL_6E166050_3FFC_43E9_9135_3CAB9BA345E3#19479,COL_FA682729_CA34_4EE2_88BF_6E1B768CC02C#19480] parquet

== Physical Plan ==
CollectLimit 500000
+- *(1) Project [COL_4527A65C_D87F_415F_B980_36B0177AB7DC#19477 AS COL_2FF1A39D_4FA8_4890_A424_FA045DACBABB#19699, COL_C2CB73AD_8503_48AE_9E4C_D00723D883F3#19478 AS COL_4C98E2EF_DDAC_4AD8_BF0B_CD1EC268B902#19700, COL_6E166050_3FFC_43E9_9135_3CAB9BA345E3#19479 AS COL_1317ED80_3DBC_40E4_9C4A_4FCD9980386B#19701, COL_FA682729_CA34_4EE2_88BF_6E1B768CC02C#19480 AS COL_C4F25DDE_86AD_4686_8C56_BE77EFFE1FCA#19702]
   +- *(1) ColumnarToRow
      +- FileScan parquet [COL_4527A65C_D87F_415F_B980_36B0177AB7DC#19477,COL_C2CB73AD_8503_48AE_9E4C_D00723D883F3#19478,COL_6E166050_3FFC_43E9_9135_3CAB9BA345E3#19479,COL_FA682729_CA34_4EE2_88BF_6E1B768CC02C#19480] 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...