DC2 - Details for Query 57

Details for Query 57

Submitted Time: 2025/11/07 08:58:33
Duration: 75 ms
Succeeded Jobs: 85
Show the Stage ID and Task ID that corresponds to the max metric
Details
== Parsed Logical Plan ==
GlobalLimit 500000
+- LocalLimit 500000
   +- Project [COL_5AB85F3B_5B32_415C_9969_81F27F0EB906#19434 AS COL_5AB85F3B_5B32_415C_9969_81F27F0EB906#19442, COL_CC29EA41_584A_4C3C_A9EF_4DD40F00A901#19435 AS COL_CC29EA41_584A_4C3C_A9EF_4DD40F00A901#19443, COL_0D91FD3C_FEF7_49DC_8CA7_FBA8FE9E9F93#19436 AS COL_0D91FD3C_FEF7_49DC_8CA7_FBA8FE9E9F93#19444, COL_CF7DA613_44D8_48D5_86DA_5741465BB7F7#19437 AS COL_CF7DA613_44D8_48D5_86DA_5741465BB7F7#19445]
      +- Project [COL_5AB85F3B_5B32_415C_9969_81F27F0EB906#19426 AS COL_5AB85F3B_5B32_415C_9969_81F27F0EB906#19434, COL_CC29EA41_584A_4C3C_A9EF_4DD40F00A901#19427 AS COL_CC29EA41_584A_4C3C_A9EF_4DD40F00A901#19435, COL_0D91FD3C_FEF7_49DC_8CA7_FBA8FE9E9F93#19428 AS COL_0D91FD3C_FEF7_49DC_8CA7_FBA8FE9E9F93#19436, COL_CF7DA613_44D8_48D5_86DA_5741465BB7F7#19429 AS COL_CF7DA613_44D8_48D5_86DA_5741465BB7F7#19437]
         +- Project [COL_5AB85F3B_5B32_415C_9969_81F27F0EB906#19418 AS COL_5AB85F3B_5B32_415C_9969_81F27F0EB906#19426, COL_CC29EA41_584A_4C3C_A9EF_4DD40F00A901#19419 AS COL_CC29EA41_584A_4C3C_A9EF_4DD40F00A901#19427, COL_0D91FD3C_FEF7_49DC_8CA7_FBA8FE9E9F93#19420 AS COL_0D91FD3C_FEF7_49DC_8CA7_FBA8FE9E9F93#19428, COL_CF7DA613_44D8_48D5_86DA_5741465BB7F7#19421 AS COL_CF7DA613_44D8_48D5_86DA_5741465BB7F7#19429]
            +- Project [COL_5AB85F3B_5B32_415C_9969_81F27F0EB906#19410 AS COL_5AB85F3B_5B32_415C_9969_81F27F0EB906#19418, COL_CC29EA41_584A_4C3C_A9EF_4DD40F00A901#19411 AS COL_CC29EA41_584A_4C3C_A9EF_4DD40F00A901#19419, COL_0D91FD3C_FEF7_49DC_8CA7_FBA8FE9E9F93#19412 AS COL_0D91FD3C_FEF7_49DC_8CA7_FBA8FE9E9F93#19420, COL_CF7DA613_44D8_48D5_86DA_5741465BB7F7#19413 AS COL_CF7DA613_44D8_48D5_86DA_5741465BB7F7#19421]
               +- Project [COL_5AB85F3B_5B32_415C_9969_81F27F0EB906#19398 AS COL_5AB85F3B_5B32_415C_9969_81F27F0EB906#19410, COL_CC29EA41_584A_4C3C_A9EF_4DD40F00A901#19399 AS COL_CC29EA41_584A_4C3C_A9EF_4DD40F00A901#19411, COL_0D91FD3C_FEF7_49DC_8CA7_FBA8FE9E9F93#19400 AS COL_0D91FD3C_FEF7_49DC_8CA7_FBA8FE9E9F93#19412, COL_CF7DA613_44D8_48D5_86DA_5741465BB7F7#19401 AS COL_CF7DA613_44D8_48D5_86DA_5741465BB7F7#19413]
                  +- Project [COL_5AB85F3B_5B32_415C_9969_81F27F0EB906#19398, COL_CC29EA41_584A_4C3C_A9EF_4DD40F00A901#19399, COL_0D91FD3C_FEF7_49DC_8CA7_FBA8FE9E9F93#19400, COL_CF7DA613_44D8_48D5_86DA_5741465BB7F7#19401]
                     +- Project [cast(QUALITE_SYNTHES_38196_COL_4527A65C_D87F_415F_B980_36B0177AB7DC#19386 as string) AS COL_5AB85F3B_5B32_415C_9969_81F27F0EB906#19398, cast(QUALITE_SYNTHES_38196_COL_C2CB73AD_8503_48AE_9E4C_D00723D883F3#19387 as int) AS COL_CC29EA41_584A_4C3C_A9EF_4DD40F00A901#19399, cast(QUALITE_SYNTHES_38196_COL_6E166050_3FFC_43E9_9135_3CAB9BA345E3#19388 as int) AS COL_0D91FD3C_FEF7_49DC_8CA7_FBA8FE9E9F93#19400, cast(QUALITE_SYNTHES_38196_COL_FA682729_CA34_4EE2_88BF_6E1B768CC02C#19389 as double) AS COL_CF7DA613_44D8_48D5_86DA_5741465BB7F7#19401]
                        +- Project [COL_4527A65C_D87F_415F_B980_36B0177AB7DC#19374 AS QUALITE_SYNTHES_38196_COL_4527A65C_D87F_415F_B980_36B0177AB7DC#19386, COL_C2CB73AD_8503_48AE_9E4C_D00723D883F3#19375 AS QUALITE_SYNTHES_38196_COL_C2CB73AD_8503_48AE_9E4C_D00723D883F3#19387, COL_6E166050_3FFC_43E9_9135_3CAB9BA345E3#19376 AS QUALITE_SYNTHES_38196_COL_6E166050_3FFC_43E9_9135_3CAB9BA345E3#19388, COL_FA682729_CA34_4EE2_88BF_6E1B768CC02C#19377 AS QUALITE_SYNTHES_38196_COL_FA682729_CA34_4EE2_88BF_6E1B768CC02C#19389]
                           +- SubqueryAlias QUALITE_SYNTHES_38196114
                              +- Relation[COL_4527A65C_D87F_415F_B980_36B0177AB7DC#19374,COL_C2CB73AD_8503_48AE_9E4C_D00723D883F3#19375,COL_6E166050_3FFC_43E9_9135_3CAB9BA345E3#19376,COL_FA682729_CA34_4EE2_88BF_6E1B768CC02C#19377] parquet

== Analyzed Logical Plan ==
COL_5AB85F3B_5B32_415C_9969_81F27F0EB906: string, COL_CC29EA41_584A_4C3C_A9EF_4DD40F00A901: int, COL_0D91FD3C_FEF7_49DC_8CA7_FBA8FE9E9F93: int, COL_CF7DA613_44D8_48D5_86DA_5741465BB7F7: double
GlobalLimit 500000
+- LocalLimit 500000
   +- Project [COL_5AB85F3B_5B32_415C_9969_81F27F0EB906#19434 AS COL_5AB85F3B_5B32_415C_9969_81F27F0EB906#19442, COL_CC29EA41_584A_4C3C_A9EF_4DD40F00A901#19435 AS COL_CC29EA41_584A_4C3C_A9EF_4DD40F00A901#19443, COL_0D91FD3C_FEF7_49DC_8CA7_FBA8FE9E9F93#19436 AS COL_0D91FD3C_FEF7_49DC_8CA7_FBA8FE9E9F93#19444, COL_CF7DA613_44D8_48D5_86DA_5741465BB7F7#19437 AS COL_CF7DA613_44D8_48D5_86DA_5741465BB7F7#19445]
      +- Project [COL_5AB85F3B_5B32_415C_9969_81F27F0EB906#19426 AS COL_5AB85F3B_5B32_415C_9969_81F27F0EB906#19434, COL_CC29EA41_584A_4C3C_A9EF_4DD40F00A901#19427 AS COL_CC29EA41_584A_4C3C_A9EF_4DD40F00A901#19435, COL_0D91FD3C_FEF7_49DC_8CA7_FBA8FE9E9F93#19428 AS COL_0D91FD3C_FEF7_49DC_8CA7_FBA8FE9E9F93#19436, COL_CF7DA613_44D8_48D5_86DA_5741465BB7F7#19429 AS COL_CF7DA613_44D8_48D5_86DA_5741465BB7F7#19437]
         +- Project [COL_5AB85F3B_5B32_415C_9969_81F27F0EB906#19418 AS COL_5AB85F3B_5B32_415C_9969_81F27F0EB906#19426, COL_CC29EA41_584A_4C3C_A9EF_4DD40F00A901#19419 AS COL_CC29EA41_584A_4C3C_A9EF_4DD40F00A901#19427, COL_0D91FD3C_FEF7_49DC_8CA7_FBA8FE9E9F93#19420 AS COL_0D91FD3C_FEF7_49DC_8CA7_FBA8FE9E9F93#19428, COL_CF7DA613_44D8_48D5_86DA_5741465BB7F7#19421 AS COL_CF7DA613_44D8_48D5_86DA_5741465BB7F7#19429]
            +- Project [COL_5AB85F3B_5B32_415C_9969_81F27F0EB906#19410 AS COL_5AB85F3B_5B32_415C_9969_81F27F0EB906#19418, COL_CC29EA41_584A_4C3C_A9EF_4DD40F00A901#19411 AS COL_CC29EA41_584A_4C3C_A9EF_4DD40F00A901#19419, COL_0D91FD3C_FEF7_49DC_8CA7_FBA8FE9E9F93#19412 AS COL_0D91FD3C_FEF7_49DC_8CA7_FBA8FE9E9F93#19420, COL_CF7DA613_44D8_48D5_86DA_5741465BB7F7#19413 AS COL_CF7DA613_44D8_48D5_86DA_5741465BB7F7#19421]
               +- Project [COL_5AB85F3B_5B32_415C_9969_81F27F0EB906#19398 AS COL_5AB85F3B_5B32_415C_9969_81F27F0EB906#19410, COL_CC29EA41_584A_4C3C_A9EF_4DD40F00A901#19399 AS COL_CC29EA41_584A_4C3C_A9EF_4DD40F00A901#19411, COL_0D91FD3C_FEF7_49DC_8CA7_FBA8FE9E9F93#19400 AS COL_0D91FD3C_FEF7_49DC_8CA7_FBA8FE9E9F93#19412, COL_CF7DA613_44D8_48D5_86DA_5741465BB7F7#19401 AS COL_CF7DA613_44D8_48D5_86DA_5741465BB7F7#19413]
                  +- Project [COL_5AB85F3B_5B32_415C_9969_81F27F0EB906#19398, COL_CC29EA41_584A_4C3C_A9EF_4DD40F00A901#19399, COL_0D91FD3C_FEF7_49DC_8CA7_FBA8FE9E9F93#19400, COL_CF7DA613_44D8_48D5_86DA_5741465BB7F7#19401]
                     +- Project [cast(QUALITE_SYNTHES_38196_COL_4527A65C_D87F_415F_B980_36B0177AB7DC#19386 as string) AS COL_5AB85F3B_5B32_415C_9969_81F27F0EB906#19398, cast(QUALITE_SYNTHES_38196_COL_C2CB73AD_8503_48AE_9E4C_D00723D883F3#19387 as int) AS COL_CC29EA41_584A_4C3C_A9EF_4DD40F00A901#19399, cast(QUALITE_SYNTHES_38196_COL_6E166050_3FFC_43E9_9135_3CAB9BA345E3#19388 as int) AS COL_0D91FD3C_FEF7_49DC_8CA7_FBA8FE9E9F93#19400, cast(QUALITE_SYNTHES_38196_COL_FA682729_CA34_4EE2_88BF_6E1B768CC02C#19389 as double) AS COL_CF7DA613_44D8_48D5_86DA_5741465BB7F7#19401]
                        +- Project [COL_4527A65C_D87F_415F_B980_36B0177AB7DC#19374 AS QUALITE_SYNTHES_38196_COL_4527A65C_D87F_415F_B980_36B0177AB7DC#19386, COL_C2CB73AD_8503_48AE_9E4C_D00723D883F3#19375 AS QUALITE_SYNTHES_38196_COL_C2CB73AD_8503_48AE_9E4C_D00723D883F3#19387, COL_6E166050_3FFC_43E9_9135_3CAB9BA345E3#19376 AS QUALITE_SYNTHES_38196_COL_6E166050_3FFC_43E9_9135_3CAB9BA345E3#19388, COL_FA682729_CA34_4EE2_88BF_6E1B768CC02C#19377 AS QUALITE_SYNTHES_38196_COL_FA682729_CA34_4EE2_88BF_6E1B768CC02C#19389]
                           +- SubqueryAlias QUALITE_SYNTHES_38196114
                              +- Relation[COL_4527A65C_D87F_415F_B980_36B0177AB7DC#19374,COL_C2CB73AD_8503_48AE_9E4C_D00723D883F3#19375,COL_6E166050_3FFC_43E9_9135_3CAB9BA345E3#19376,COL_FA682729_CA34_4EE2_88BF_6E1B768CC02C#19377] parquet

== Optimized Logical Plan ==
GlobalLimit 500000
+- LocalLimit 500000
   +- Project [COL_4527A65C_D87F_415F_B980_36B0177AB7DC#19374 AS COL_5AB85F3B_5B32_415C_9969_81F27F0EB906#19442, COL_C2CB73AD_8503_48AE_9E4C_D00723D883F3#19375 AS COL_CC29EA41_584A_4C3C_A9EF_4DD40F00A901#19443, COL_6E166050_3FFC_43E9_9135_3CAB9BA345E3#19376 AS COL_0D91FD3C_FEF7_49DC_8CA7_FBA8FE9E9F93#19444, COL_FA682729_CA34_4EE2_88BF_6E1B768CC02C#19377 AS COL_CF7DA613_44D8_48D5_86DA_5741465BB7F7#19445]
      +- Relation[COL_4527A65C_D87F_415F_B980_36B0177AB7DC#19374,COL_C2CB73AD_8503_48AE_9E4C_D00723D883F3#19375,COL_6E166050_3FFC_43E9_9135_3CAB9BA345E3#19376,COL_FA682729_CA34_4EE2_88BF_6E1B768CC02C#19377] parquet

== Physical Plan ==
CollectLimit 500000
+- *(1) Project [COL_4527A65C_D87F_415F_B980_36B0177AB7DC#19374 AS COL_5AB85F3B_5B32_415C_9969_81F27F0EB906#19442, COL_C2CB73AD_8503_48AE_9E4C_D00723D883F3#19375 AS COL_CC29EA41_584A_4C3C_A9EF_4DD40F00A901#19443, COL_6E166050_3FFC_43E9_9135_3CAB9BA345E3#19376 AS COL_0D91FD3C_FEF7_49DC_8CA7_FBA8FE9E9F93#19444, COL_FA682729_CA34_4EE2_88BF_6E1B768CC02C#19377 AS COL_CF7DA613_44D8_48D5_86DA_5741465BB7F7#19445]
   +- *(1) ColumnarToRow
      +- FileScan parquet [COL_4527A65C_D87F_415F_B980_36B0177AB7DC#19374,COL_C2CB73AD_8503_48AE_9E4C_D00723D883F3#19375,COL_6E166050_3FFC_43E9_9135_3CAB9BA345E3#19376,COL_FA682729_CA34_4EE2_88BF_6E1B768CC02C#19377] Batched: true, DataFilters: [], Format: Parquet, Location: InMemoryFileIndex[file:/data/output/cache/parquet/datablock/QUALITE_SYNTHES_38196], PartitionFilters: [], PushedFilters: [], ReadSchema: struct<COL_4527A65C_D87F_415F_B980_36B0177AB7DC:string,COL_C2CB73AD_8503_48AE_9E4C_D00723D883F3:i...