== Parsed Logical Plan ==
GlobalLimit 500000
+- LocalLimit 500000
+- Project [COL_5AB85F3B_5B32_415C_9969_81F27F0EB906#2750 AS COL_5AB85F3B_5B32_415C_9969_81F27F0EB906#2758, COL_CC29EA41_584A_4C3C_A9EF_4DD40F00A901#2751 AS COL_CC29EA41_584A_4C3C_A9EF_4DD40F00A901#2759, COL_0D91FD3C_FEF7_49DC_8CA7_FBA8FE9E9F93#2752 AS COL_0D91FD3C_FEF7_49DC_8CA7_FBA8FE9E9F93#2760, COL_CF7DA613_44D8_48D5_86DA_5741465BB7F7#2753 AS COL_CF7DA613_44D8_48D5_86DA_5741465BB7F7#2761]
+- Project [COL_5AB85F3B_5B32_415C_9969_81F27F0EB906#2742 AS COL_5AB85F3B_5B32_415C_9969_81F27F0EB906#2750, COL_CC29EA41_584A_4C3C_A9EF_4DD40F00A901#2743 AS COL_CC29EA41_584A_4C3C_A9EF_4DD40F00A901#2751, COL_0D91FD3C_FEF7_49DC_8CA7_FBA8FE9E9F93#2744 AS COL_0D91FD3C_FEF7_49DC_8CA7_FBA8FE9E9F93#2752, COL_CF7DA613_44D8_48D5_86DA_5741465BB7F7#2745 AS COL_CF7DA613_44D8_48D5_86DA_5741465BB7F7#2753]
+- Project [COL_5AB85F3B_5B32_415C_9969_81F27F0EB906#2730 AS COL_5AB85F3B_5B32_415C_9969_81F27F0EB906#2742, COL_CC29EA41_584A_4C3C_A9EF_4DD40F00A901#2731 AS COL_CC29EA41_584A_4C3C_A9EF_4DD40F00A901#2743, COL_0D91FD3C_FEF7_49DC_8CA7_FBA8FE9E9F93#2732 AS COL_0D91FD3C_FEF7_49DC_8CA7_FBA8FE9E9F93#2744, COL_CF7DA613_44D8_48D5_86DA_5741465BB7F7#2733 AS COL_CF7DA613_44D8_48D5_86DA_5741465BB7F7#2745]
+- Project [COL_5AB85F3B_5B32_415C_9969_81F27F0EB906#2682 AS COL_5AB85F3B_5B32_415C_9969_81F27F0EB906#2730, COL_CC29EA41_584A_4C3C_A9EF_4DD40F00A901#2683 AS COL_CC29EA41_584A_4C3C_A9EF_4DD40F00A901#2731, COL_0D91FD3C_FEF7_49DC_8CA7_FBA8FE9E9F93#2684 AS COL_0D91FD3C_FEF7_49DC_8CA7_FBA8FE9E9F93#2732, COL_CF7DA613_44D8_48D5_86DA_5741465BB7F7#2685 AS COL_CF7DA613_44D8_48D5_86DA_5741465BB7F7#2733]
+- Project [COL_5AB85F3B_5B32_415C_9969_81F27F0EB906#2661 AS COL_5AB85F3B_5B32_415C_9969_81F27F0EB906#2682, COL_CC29EA41_584A_4C3C_A9EF_4DD40F00A901#2662 AS COL_CC29EA41_584A_4C3C_A9EF_4DD40F00A901#2683, COL_0D91FD3C_FEF7_49DC_8CA7_FBA8FE9E9F93#2663 AS COL_0D91FD3C_FEF7_49DC_8CA7_FBA8FE9E9F93#2684, COL_CF7DA613_44D8_48D5_86DA_5741465BB7F7#2664 AS COL_CF7DA613_44D8_48D5_86DA_5741465BB7F7#2685]
+- Project [COL_5AB85F3B_5B32_415C_9969_81F27F0EB906#2661, COL_CC29EA41_584A_4C3C_A9EF_4DD40F00A901#2662, COL_0D91FD3C_FEF7_49DC_8CA7_FBA8FE9E9F93#2663, COL_CF7DA613_44D8_48D5_86DA_5741465BB7F7#2664]
+- Project [cast(QUALITE_SYNTHES_38196_COL_4527A65C_D87F_415F_B980_36B0177AB7DC#2639 as string) AS COL_5AB85F3B_5B32_415C_9969_81F27F0EB906#2661, cast(QUALITE_SYNTHES_38196_COL_C2CB73AD_8503_48AE_9E4C_D00723D883F3#2641 as int) AS COL_CC29EA41_584A_4C3C_A9EF_4DD40F00A901#2662, cast(QUALITE_SYNTHES_38196_COL_6E166050_3FFC_43E9_9135_3CAB9BA345E3#2643 as int) AS COL_0D91FD3C_FEF7_49DC_8CA7_FBA8FE9E9F93#2663, cast(QUALITE_SYNTHES_38196_COL_FA682729_CA34_4EE2_88BF_6E1B768CC02C#2644 as double) AS COL_CF7DA613_44D8_48D5_86DA_5741465BB7F7#2664]
+- Project [COL_4527A65C_D87F_415F_B980_36B0177AB7DC#2614 AS QUALITE_SYNTHES_38196_COL_4527A65C_D87F_415F_B980_36B0177AB7DC#2639, COL_C2CB73AD_8503_48AE_9E4C_D00723D883F3#2615 AS QUALITE_SYNTHES_38196_COL_C2CB73AD_8503_48AE_9E4C_D00723D883F3#2641, COL_6E166050_3FFC_43E9_9135_3CAB9BA345E3#2616 AS QUALITE_SYNTHES_38196_COL_6E166050_3FFC_43E9_9135_3CAB9BA345E3#2643, COL_FA682729_CA34_4EE2_88BF_6E1B768CC02C#2617 AS QUALITE_SYNTHES_38196_COL_FA682729_CA34_4EE2_88BF_6E1B768CC02C#2644]
+- SubqueryAlias QUALITE_SYNTHES_38196118
+- Relation[COL_4527A65C_D87F_415F_B980_36B0177AB7DC#2614,COL_C2CB73AD_8503_48AE_9E4C_D00723D883F3#2615,COL_6E166050_3FFC_43E9_9135_3CAB9BA345E3#2616,COL_FA682729_CA34_4EE2_88BF_6E1B768CC02C#2617] 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#2750 AS COL_5AB85F3B_5B32_415C_9969_81F27F0EB906#2758, COL_CC29EA41_584A_4C3C_A9EF_4DD40F00A901#2751 AS COL_CC29EA41_584A_4C3C_A9EF_4DD40F00A901#2759, COL_0D91FD3C_FEF7_49DC_8CA7_FBA8FE9E9F93#2752 AS COL_0D91FD3C_FEF7_49DC_8CA7_FBA8FE9E9F93#2760, COL_CF7DA613_44D8_48D5_86DA_5741465BB7F7#2753 AS COL_CF7DA613_44D8_48D5_86DA_5741465BB7F7#2761]
+- Project [COL_5AB85F3B_5B32_415C_9969_81F27F0EB906#2742 AS COL_5AB85F3B_5B32_415C_9969_81F27F0EB906#2750, COL_CC29EA41_584A_4C3C_A9EF_4DD40F00A901#2743 AS COL_CC29EA41_584A_4C3C_A9EF_4DD40F00A901#2751, COL_0D91FD3C_FEF7_49DC_8CA7_FBA8FE9E9F93#2744 AS COL_0D91FD3C_FEF7_49DC_8CA7_FBA8FE9E9F93#2752, COL_CF7DA613_44D8_48D5_86DA_5741465BB7F7#2745 AS COL_CF7DA613_44D8_48D5_86DA_5741465BB7F7#2753]
+- Project [COL_5AB85F3B_5B32_415C_9969_81F27F0EB906#2730 AS COL_5AB85F3B_5B32_415C_9969_81F27F0EB906#2742, COL_CC29EA41_584A_4C3C_A9EF_4DD40F00A901#2731 AS COL_CC29EA41_584A_4C3C_A9EF_4DD40F00A901#2743, COL_0D91FD3C_FEF7_49DC_8CA7_FBA8FE9E9F93#2732 AS COL_0D91FD3C_FEF7_49DC_8CA7_FBA8FE9E9F93#2744, COL_CF7DA613_44D8_48D5_86DA_5741465BB7F7#2733 AS COL_CF7DA613_44D8_48D5_86DA_5741465BB7F7#2745]
+- Project [COL_5AB85F3B_5B32_415C_9969_81F27F0EB906#2682 AS COL_5AB85F3B_5B32_415C_9969_81F27F0EB906#2730, COL_CC29EA41_584A_4C3C_A9EF_4DD40F00A901#2683 AS COL_CC29EA41_584A_4C3C_A9EF_4DD40F00A901#2731, COL_0D91FD3C_FEF7_49DC_8CA7_FBA8FE9E9F93#2684 AS COL_0D91FD3C_FEF7_49DC_8CA7_FBA8FE9E9F93#2732, COL_CF7DA613_44D8_48D5_86DA_5741465BB7F7#2685 AS COL_CF7DA613_44D8_48D5_86DA_5741465BB7F7#2733]
+- Project [COL_5AB85F3B_5B32_415C_9969_81F27F0EB906#2661 AS COL_5AB85F3B_5B32_415C_9969_81F27F0EB906#2682, COL_CC29EA41_584A_4C3C_A9EF_4DD40F00A901#2662 AS COL_CC29EA41_584A_4C3C_A9EF_4DD40F00A901#2683, COL_0D91FD3C_FEF7_49DC_8CA7_FBA8FE9E9F93#2663 AS COL_0D91FD3C_FEF7_49DC_8CA7_FBA8FE9E9F93#2684, COL_CF7DA613_44D8_48D5_86DA_5741465BB7F7#2664 AS COL_CF7DA613_44D8_48D5_86DA_5741465BB7F7#2685]
+- Project [COL_5AB85F3B_5B32_415C_9969_81F27F0EB906#2661, COL_CC29EA41_584A_4C3C_A9EF_4DD40F00A901#2662, COL_0D91FD3C_FEF7_49DC_8CA7_FBA8FE9E9F93#2663, COL_CF7DA613_44D8_48D5_86DA_5741465BB7F7#2664]
+- Project [cast(QUALITE_SYNTHES_38196_COL_4527A65C_D87F_415F_B980_36B0177AB7DC#2639 as string) AS COL_5AB85F3B_5B32_415C_9969_81F27F0EB906#2661, cast(QUALITE_SYNTHES_38196_COL_C2CB73AD_8503_48AE_9E4C_D00723D883F3#2641 as int) AS COL_CC29EA41_584A_4C3C_A9EF_4DD40F00A901#2662, cast(QUALITE_SYNTHES_38196_COL_6E166050_3FFC_43E9_9135_3CAB9BA345E3#2643 as int) AS COL_0D91FD3C_FEF7_49DC_8CA7_FBA8FE9E9F93#2663, cast(QUALITE_SYNTHES_38196_COL_FA682729_CA34_4EE2_88BF_6E1B768CC02C#2644 as double) AS COL_CF7DA613_44D8_48D5_86DA_5741465BB7F7#2664]
+- Project [COL_4527A65C_D87F_415F_B980_36B0177AB7DC#2614 AS QUALITE_SYNTHES_38196_COL_4527A65C_D87F_415F_B980_36B0177AB7DC#2639, COL_C2CB73AD_8503_48AE_9E4C_D00723D883F3#2615 AS QUALITE_SYNTHES_38196_COL_C2CB73AD_8503_48AE_9E4C_D00723D883F3#2641, COL_6E166050_3FFC_43E9_9135_3CAB9BA345E3#2616 AS QUALITE_SYNTHES_38196_COL_6E166050_3FFC_43E9_9135_3CAB9BA345E3#2643, COL_FA682729_CA34_4EE2_88BF_6E1B768CC02C#2617 AS QUALITE_SYNTHES_38196_COL_FA682729_CA34_4EE2_88BF_6E1B768CC02C#2644]
+- SubqueryAlias QUALITE_SYNTHES_38196118
+- Relation[COL_4527A65C_D87F_415F_B980_36B0177AB7DC#2614,COL_C2CB73AD_8503_48AE_9E4C_D00723D883F3#2615,COL_6E166050_3FFC_43E9_9135_3CAB9BA345E3#2616,COL_FA682729_CA34_4EE2_88BF_6E1B768CC02C#2617] parquet
== Optimized Logical Plan ==
GlobalLimit 500000
+- LocalLimit 500000
+- Project [COL_4527A65C_D87F_415F_B980_36B0177AB7DC#2614 AS COL_5AB85F3B_5B32_415C_9969_81F27F0EB906#2758, COL_C2CB73AD_8503_48AE_9E4C_D00723D883F3#2615 AS COL_CC29EA41_584A_4C3C_A9EF_4DD40F00A901#2759, COL_6E166050_3FFC_43E9_9135_3CAB9BA345E3#2616 AS COL_0D91FD3C_FEF7_49DC_8CA7_FBA8FE9E9F93#2760, COL_FA682729_CA34_4EE2_88BF_6E1B768CC02C#2617 AS COL_CF7DA613_44D8_48D5_86DA_5741465BB7F7#2761]
+- Relation[COL_4527A65C_D87F_415F_B980_36B0177AB7DC#2614,COL_C2CB73AD_8503_48AE_9E4C_D00723D883F3#2615,COL_6E166050_3FFC_43E9_9135_3CAB9BA345E3#2616,COL_FA682729_CA34_4EE2_88BF_6E1B768CC02C#2617] parquet
== Physical Plan ==
CollectLimit 500000
+- *(1) Project [COL_4527A65C_D87F_415F_B980_36B0177AB7DC#2614 AS COL_5AB85F3B_5B32_415C_9969_81F27F0EB906#2758, COL_C2CB73AD_8503_48AE_9E4C_D00723D883F3#2615 AS COL_CC29EA41_584A_4C3C_A9EF_4DD40F00A901#2759, COL_6E166050_3FFC_43E9_9135_3CAB9BA345E3#2616 AS COL_0D91FD3C_FEF7_49DC_8CA7_FBA8FE9E9F93#2760, COL_FA682729_CA34_4EE2_88BF_6E1B768CC02C#2617 AS COL_CF7DA613_44D8_48D5_86DA_5741465BB7F7#2761]
+- *(1) ColumnarToRow
+- FileScan parquet [COL_4527A65C_D87F_415F_B980_36B0177AB7DC#2614,COL_C2CB73AD_8503_48AE_9E4C_D00723D883F3#2615,COL_6E166050_3FFC_43E9_9135_3CAB9BA345E3#2616,COL_FA682729_CA34_4EE2_88BF_6E1B768CC02C#2617] 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...