DC2 - Details for Query 130

Details for Query 130

Submitted Time: 2026/04/29 06:52:28
Duration: 0.7 s
Succeeded Jobs: 225 226
Show the Stage ID and Task ID that corresponds to the max metric
digraph G { 0 [labelType="html" label=" CollectLimit "]; subgraph cluster1 { isCluster="true"; label="WholeStageCodegen (1)\n \nduration: total (min, med, max (stageId: taskId))\n401 ms (3 ms, 3 ms, 389 ms (stage 357.0: task 1192))"; 2 [labelType="html" label=" Project "]; 3 [labelType="html" label="ColumnarToRow number of output rows: 1,259 number of input batches: 1"]; } 4 [labelType="html" label="Scan parquet number of files read: 1 scan time total (min, med, max (stageId: taskId)) 221 ms (2 ms, 3 ms, 210 ms (stage 357.0: task 1192)) metadata time: 0 ms size of files read: 16.8 MiB number of output rows: 1,259"]; 2->0; 3->2; 4->3; }
CollectLimit 500000
Project [COL_852340BE_F461_4346_93DB_C843DAAC0100#29577 AS COL_D0CA777F_6C2C_46FC_ADDD_72DC94CCFD2D#29832, COL_38D327C5_91C6_48DE_A550_D8D6FC7313DA#29578 AS COL_009EF890_E70E_4526_ADBC_30B4B756EBA1#29833, COL_F93C76F0_A78C_4080_96B7_C0F6F0DA41AF#29579 AS COL_F6BFAC80_3DA4_4D5F_9DD3_E8D2865AAB6C#29834, COL_168901A2_F20D_43CD_ADDF_914DCC871BA4#29580 AS COL_91ADF7E7_9909_41E7_A4AE_9B1765821250#29835, COL_BF23E4AD_C3E4_494A_B016_93BFEC3703FC#29581 AS COL_D5E1121F_1F0E_4C32_B782_8B81498DB680#29836, COL_D24AD23C_1196_4A9E_AC5C_1E320056D7C4#29582 AS COL_D52FDC9D_B060_4A0A_AF00_7DCCBCD008FB#29837, COL_23BDC03D_9214_41F7_B64D_6A67F66FD73A#29583 AS COL_90FA3F5A_12D0_4746_B684_FFDEEDCE9642#29838, COL_28E3CD57_3BBA_491C_9404_C1B9B544E9E9#29584 AS COL_C9EC0388_9F63_49A7_A1B4_CD06136CB768#29839, COL_9014F2F3_8A8A_43F2_81A5_C15BB75751E6#29585 AS COL_CC7D7432_DD73_43E7_815B_100C5FFD0FD4#29840, COL_D6D1736E_5928_416E_9A5B_1258C60FFCEE#29586 AS COL_A27EF8B5_32B3_4A20_B8DD_BC739249612D#29841, COL_6ABE7F1F_3F7A_499F_A959_41B52AEDE99A#29587 AS COL_C04C4FA4_57E5_4AFE_8A4A_303E1AFCCF76#29842, COL_51C7CEE7_8C89_4B66_9A0F_E0E1C7CA8D38#29588 AS COL_64BC8B8A_94C4_488D_A0F9_F623945F66AB#29843, COL_23D918EA_CEBE_472F_988F_E91E6A87F787#29589 AS COL_8C3665AA_685A_49CE_B85F_32FE33386B8B#29844, COL_54C88771_DD52_4B19_9D09_78CB036E1326#29590 AS COL_E1192796_FA55_4A14_B45E_CCF30BC19BCE#29845, COL_FA266E11_2885_4427_B14F_169FE51128B8#29591 AS COL_3BEF645A_08A5_4053_AF9E_B3C06DF915B6#29846]
ColumnarToRow
WholeStageCodegen (1)
FileScan parquet [COL_852340BE_F461_4346_93DB_C843DAAC0100#29577,COL_38D327C5_91C6_48DE_A550_D8D6FC7313DA#29578,COL_F93C76F0_A78C_4080_96B7_C0F6F0DA41AF#29579,COL_168901A2_F20D_43CD_ADDF_914DCC871BA4#29580,COL_BF23E4AD_C3E4_494A_B016_93BFEC3703FC#29581,COL_D24AD23C_1196_4A9E_AC5C_1E320056D7C4#29582,COL_23BDC03D_9214_41F7_B64D_6A67F66FD73A#29583,COL_28E3CD57_3BBA_491C_9404_C1B9B544E9E9#29584,COL_9014F2F3_8A8A_43F2_81A5_C15BB75751E6#29585,COL_D6D1736E_5928_416E_9A5B_1258C60FFCEE#29586,COL_6ABE7F1F_3F7A_499F_A959_41B52AEDE99A#29587,COL_51C7CEE7_8C89_4B66_9A0F_E0E1C7CA8D38#29588,COL_23D918EA_CEBE_472F_988F_E91E6A87F787#29589,COL_54C88771_DD52_4B19_9D09_78CB036E1326#29590,COL_FA266E11_2885_4427_B14F_169FE51128B8#29591] Batched: true, DataFilters: [], Format: Parquet, Location: InMemoryFileIndex[file:/data/output/cache/parquet/datablock/EPCI_REFERENCE_24128], PartitionFilters: [], PushedFilters: [], ReadSchema: struct<COL_852340BE_F461_4346_93DB_C843DAAC0100:string,COL_38D327C5_91C6_48DE_A550_D8D6FC7313DA:s...
Details
== Parsed Logical Plan ==
GlobalLimit 500000
+- LocalLimit 500000
   +- Project [COL_D0CA777F_6C2C_46FC_ADDD_72DC94CCFD2D#29802 AS COL_D0CA777F_6C2C_46FC_ADDD_72DC94CCFD2D#29832, COL_009EF890_E70E_4526_ADBC_30B4B756EBA1#29803 AS COL_009EF890_E70E_4526_ADBC_30B4B756EBA1#29833, COL_F6BFAC80_3DA4_4D5F_9DD3_E8D2865AAB6C#29804 AS COL_F6BFAC80_3DA4_4D5F_9DD3_E8D2865AAB6C#29834, COL_91ADF7E7_9909_41E7_A4AE_9B1765821250#29805 AS COL_91ADF7E7_9909_41E7_A4AE_9B1765821250#29835, COL_D5E1121F_1F0E_4C32_B782_8B81498DB680#29806 AS COL_D5E1121F_1F0E_4C32_B782_8B81498DB680#29836, COL_D52FDC9D_B060_4A0A_AF00_7DCCBCD008FB#29807 AS COL_D52FDC9D_B060_4A0A_AF00_7DCCBCD008FB#29837, COL_90FA3F5A_12D0_4746_B684_FFDEEDCE9642#29808 AS COL_90FA3F5A_12D0_4746_B684_FFDEEDCE9642#29838, COL_C9EC0388_9F63_49A7_A1B4_CD06136CB768#29809 AS COL_C9EC0388_9F63_49A7_A1B4_CD06136CB768#29839, COL_CC7D7432_DD73_43E7_815B_100C5FFD0FD4#29810 AS COL_CC7D7432_DD73_43E7_815B_100C5FFD0FD4#29840, COL_A27EF8B5_32B3_4A20_B8DD_BC739249612D#29811 AS COL_A27EF8B5_32B3_4A20_B8DD_BC739249612D#29841, COL_C04C4FA4_57E5_4AFE_8A4A_303E1AFCCF76#29812 AS COL_C04C4FA4_57E5_4AFE_8A4A_303E1AFCCF76#29842, COL_64BC8B8A_94C4_488D_A0F9_F623945F66AB#29813 AS COL_64BC8B8A_94C4_488D_A0F9_F623945F66AB#29843, COL_8C3665AA_685A_49CE_B85F_32FE33386B8B#29814 AS COL_8C3665AA_685A_49CE_B85F_32FE33386B8B#29844, COL_E1192796_FA55_4A14_B45E_CCF30BC19BCE#29815 AS COL_E1192796_FA55_4A14_B45E_CCF30BC19BCE#29845, COL_3BEF645A_08A5_4053_AF9E_B3C06DF915B6#29816 AS COL_3BEF645A_08A5_4053_AF9E_B3C06DF915B6#29846]
      +- Project [COL_D0CA777F_6C2C_46FC_ADDD_72DC94CCFD2D#29772 AS COL_D0CA777F_6C2C_46FC_ADDD_72DC94CCFD2D#29802, COL_009EF890_E70E_4526_ADBC_30B4B756EBA1#29773 AS COL_009EF890_E70E_4526_ADBC_30B4B756EBA1#29803, COL_F6BFAC80_3DA4_4D5F_9DD3_E8D2865AAB6C#29774 AS COL_F6BFAC80_3DA4_4D5F_9DD3_E8D2865AAB6C#29804, COL_91ADF7E7_9909_41E7_A4AE_9B1765821250#29775 AS COL_91ADF7E7_9909_41E7_A4AE_9B1765821250#29805, COL_D5E1121F_1F0E_4C32_B782_8B81498DB680#29776 AS COL_D5E1121F_1F0E_4C32_B782_8B81498DB680#29806, COL_D52FDC9D_B060_4A0A_AF00_7DCCBCD008FB#29777 AS COL_D52FDC9D_B060_4A0A_AF00_7DCCBCD008FB#29807, COL_90FA3F5A_12D0_4746_B684_FFDEEDCE9642#29778 AS COL_90FA3F5A_12D0_4746_B684_FFDEEDCE9642#29808, COL_C9EC0388_9F63_49A7_A1B4_CD06136CB768#29779 AS COL_C9EC0388_9F63_49A7_A1B4_CD06136CB768#29809, COL_CC7D7432_DD73_43E7_815B_100C5FFD0FD4#29780 AS COL_CC7D7432_DD73_43E7_815B_100C5FFD0FD4#29810, COL_A27EF8B5_32B3_4A20_B8DD_BC739249612D#29781 AS COL_A27EF8B5_32B3_4A20_B8DD_BC739249612D#29811, COL_C04C4FA4_57E5_4AFE_8A4A_303E1AFCCF76#29782 AS COL_C04C4FA4_57E5_4AFE_8A4A_303E1AFCCF76#29812, COL_64BC8B8A_94C4_488D_A0F9_F623945F66AB#29783 AS COL_64BC8B8A_94C4_488D_A0F9_F623945F66AB#29813, COL_8C3665AA_685A_49CE_B85F_32FE33386B8B#29784 AS COL_8C3665AA_685A_49CE_B85F_32FE33386B8B#29814, COL_E1192796_FA55_4A14_B45E_CCF30BC19BCE#29785 AS COL_E1192796_FA55_4A14_B45E_CCF30BC19BCE#29815, COL_3BEF645A_08A5_4053_AF9E_B3C06DF915B6#29786 AS COL_3BEF645A_08A5_4053_AF9E_B3C06DF915B6#29816]
         +- Project [COL_D0CA777F_6C2C_46FC_ADDD_72DC94CCFD2D#29742 AS COL_D0CA777F_6C2C_46FC_ADDD_72DC94CCFD2D#29772, COL_009EF890_E70E_4526_ADBC_30B4B756EBA1#29743 AS COL_009EF890_E70E_4526_ADBC_30B4B756EBA1#29773, COL_F6BFAC80_3DA4_4D5F_9DD3_E8D2865AAB6C#29744 AS COL_F6BFAC80_3DA4_4D5F_9DD3_E8D2865AAB6C#29774, COL_91ADF7E7_9909_41E7_A4AE_9B1765821250#29745 AS COL_91ADF7E7_9909_41E7_A4AE_9B1765821250#29775, COL_D5E1121F_1F0E_4C32_B782_8B81498DB680#29746 AS COL_D5E1121F_1F0E_4C32_B782_8B81498DB680#29776, COL_D52FDC9D_B060_4A0A_AF00_7DCCBCD008FB#29747 AS COL_D52FDC9D_B060_4A0A_AF00_7DCCBCD008FB#29777, COL_90FA3F5A_12D0_4746_B684_FFDEEDCE9642#29748 AS COL_90FA3F5A_12D0_4746_B684_FFDEEDCE9642#29778, COL_C9EC0388_9F63_49A7_A1B4_CD06136CB768#29749 AS COL_C9EC0388_9F63_49A7_A1B4_CD06136CB768#29779, COL_CC7D7432_DD73_43E7_815B_100C5FFD0FD4#29750 AS COL_CC7D7432_DD73_43E7_815B_100C5FFD0FD4#29780, COL_A27EF8B5_32B3_4A20_B8DD_BC739249612D#29751 AS COL_A27EF8B5_32B3_4A20_B8DD_BC739249612D#29781, COL_C04C4FA4_57E5_4AFE_8A4A_303E1AFCCF76#29752 AS COL_C04C4FA4_57E5_4AFE_8A4A_303E1AFCCF76#29782, COL_64BC8B8A_94C4_488D_A0F9_F623945F66AB#29753 AS COL_64BC8B8A_94C4_488D_A0F9_F623945F66AB#29783, COL_8C3665AA_685A_49CE_B85F_32FE33386B8B#29754 AS COL_8C3665AA_685A_49CE_B85F_32FE33386B8B#29784, COL_E1192796_FA55_4A14_B45E_CCF30BC19BCE#29755 AS COL_E1192796_FA55_4A14_B45E_CCF30BC19BCE#29785, COL_3BEF645A_08A5_4053_AF9E_B3C06DF915B6#29756 AS COL_3BEF645A_08A5_4053_AF9E_B3C06DF915B6#29786]
            +- Project [COL_D0CA777F_6C2C_46FC_ADDD_72DC94CCFD2D#29712 AS COL_D0CA777F_6C2C_46FC_ADDD_72DC94CCFD2D#29742, COL_009EF890_E70E_4526_ADBC_30B4B756EBA1#29713 AS COL_009EF890_E70E_4526_ADBC_30B4B756EBA1#29743, COL_F6BFAC80_3DA4_4D5F_9DD3_E8D2865AAB6C#29714 AS COL_F6BFAC80_3DA4_4D5F_9DD3_E8D2865AAB6C#29744, COL_91ADF7E7_9909_41E7_A4AE_9B1765821250#29715 AS COL_91ADF7E7_9909_41E7_A4AE_9B1765821250#29745, COL_D5E1121F_1F0E_4C32_B782_8B81498DB680#29716 AS COL_D5E1121F_1F0E_4C32_B782_8B81498DB680#29746, COL_D52FDC9D_B060_4A0A_AF00_7DCCBCD008FB#29717 AS COL_D52FDC9D_B060_4A0A_AF00_7DCCBCD008FB#29747, COL_90FA3F5A_12D0_4746_B684_FFDEEDCE9642#29718 AS COL_90FA3F5A_12D0_4746_B684_FFDEEDCE9642#29748, COL_C9EC0388_9F63_49A7_A1B4_CD06136CB768#29719 AS COL_C9EC0388_9F63_49A7_A1B4_CD06136CB768#29749, COL_CC7D7432_DD73_43E7_815B_100C5FFD0FD4#29720 AS COL_CC7D7432_DD73_43E7_815B_100C5FFD0FD4#29750, COL_A27EF8B5_32B3_4A20_B8DD_BC739249612D#29721 AS COL_A27EF8B5_32B3_4A20_B8DD_BC739249612D#29751, COL_C04C4FA4_57E5_4AFE_8A4A_303E1AFCCF76#29722 AS COL_C04C4FA4_57E5_4AFE_8A4A_303E1AFCCF76#29752, COL_64BC8B8A_94C4_488D_A0F9_F623945F66AB#29723 AS COL_64BC8B8A_94C4_488D_A0F9_F623945F66AB#29753, COL_8C3665AA_685A_49CE_B85F_32FE33386B8B#29724 AS COL_8C3665AA_685A_49CE_B85F_32FE33386B8B#29754, COL_E1192796_FA55_4A14_B45E_CCF30BC19BCE#29725 AS COL_E1192796_FA55_4A14_B45E_CCF30BC19BCE#29755, COL_3BEF645A_08A5_4053_AF9E_B3C06DF915B6#29726 AS COL_3BEF645A_08A5_4053_AF9E_B3C06DF915B6#29756]
               +- Project [COL_D0CA777F_6C2C_46FC_ADDD_72DC94CCFD2D#29667 AS COL_D0CA777F_6C2C_46FC_ADDD_72DC94CCFD2D#29712, COL_009EF890_E70E_4526_ADBC_30B4B756EBA1#29668 AS COL_009EF890_E70E_4526_ADBC_30B4B756EBA1#29713, COL_F6BFAC80_3DA4_4D5F_9DD3_E8D2865AAB6C#29669 AS COL_F6BFAC80_3DA4_4D5F_9DD3_E8D2865AAB6C#29714, COL_91ADF7E7_9909_41E7_A4AE_9B1765821250#29670 AS COL_91ADF7E7_9909_41E7_A4AE_9B1765821250#29715, COL_D5E1121F_1F0E_4C32_B782_8B81498DB680#29671 AS COL_D5E1121F_1F0E_4C32_B782_8B81498DB680#29716, COL_D52FDC9D_B060_4A0A_AF00_7DCCBCD008FB#29672 AS COL_D52FDC9D_B060_4A0A_AF00_7DCCBCD008FB#29717, COL_90FA3F5A_12D0_4746_B684_FFDEEDCE9642#29673 AS COL_90FA3F5A_12D0_4746_B684_FFDEEDCE9642#29718, COL_C9EC0388_9F63_49A7_A1B4_CD06136CB768#29674 AS COL_C9EC0388_9F63_49A7_A1B4_CD06136CB768#29719, COL_CC7D7432_DD73_43E7_815B_100C5FFD0FD4#29675 AS COL_CC7D7432_DD73_43E7_815B_100C5FFD0FD4#29720, COL_A27EF8B5_32B3_4A20_B8DD_BC739249612D#29676 AS COL_A27EF8B5_32B3_4A20_B8DD_BC739249612D#29721, COL_C04C4FA4_57E5_4AFE_8A4A_303E1AFCCF76#29677 AS COL_C04C4FA4_57E5_4AFE_8A4A_303E1AFCCF76#29722, COL_64BC8B8A_94C4_488D_A0F9_F623945F66AB#29678 AS COL_64BC8B8A_94C4_488D_A0F9_F623945F66AB#29723, COL_8C3665AA_685A_49CE_B85F_32FE33386B8B#29679 AS COL_8C3665AA_685A_49CE_B85F_32FE33386B8B#29724, COL_E1192796_FA55_4A14_B45E_CCF30BC19BCE#29680 AS COL_E1192796_FA55_4A14_B45E_CCF30BC19BCE#29725, COL_3BEF645A_08A5_4053_AF9E_B3C06DF915B6#29681 AS COL_3BEF645A_08A5_4053_AF9E_B3C06DF915B6#29726]
                  +- Project [COL_D0CA777F_6C2C_46FC_ADDD_72DC94CCFD2D#29667, COL_009EF890_E70E_4526_ADBC_30B4B756EBA1#29668, COL_F6BFAC80_3DA4_4D5F_9DD3_E8D2865AAB6C#29669, COL_91ADF7E7_9909_41E7_A4AE_9B1765821250#29670, COL_D5E1121F_1F0E_4C32_B782_8B81498DB680#29671, COL_D52FDC9D_B060_4A0A_AF00_7DCCBCD008FB#29672, COL_90FA3F5A_12D0_4746_B684_FFDEEDCE9642#29673, COL_C9EC0388_9F63_49A7_A1B4_CD06136CB768#29674, COL_CC7D7432_DD73_43E7_815B_100C5FFD0FD4#29675, COL_A27EF8B5_32B3_4A20_B8DD_BC739249612D#29676, COL_C04C4FA4_57E5_4AFE_8A4A_303E1AFCCF76#29677, COL_64BC8B8A_94C4_488D_A0F9_F623945F66AB#29678, COL_8C3665AA_685A_49CE_B85F_32FE33386B8B#29679, COL_E1192796_FA55_4A14_B45E_CCF30BC19BCE#29680, COL_3BEF645A_08A5_4053_AF9E_B3C06DF915B6#29681]
                     +- Project [cast(EPCI_REFERENCE_24128_COL_852340BE_F461_4346_93DB_C843DAAC0100#29622 as string) AS COL_D0CA777F_6C2C_46FC_ADDD_72DC94CCFD2D#29667, cast(EPCI_REFERENCE_24128_COL_38D327C5_91C6_48DE_A550_D8D6FC7313DA#29623 as string) AS COL_009EF890_E70E_4526_ADBC_30B4B756EBA1#29668, cast(EPCI_REFERENCE_24128_COL_F93C76F0_A78C_4080_96B7_C0F6F0DA41AF#29624 as string) AS COL_F6BFAC80_3DA4_4D5F_9DD3_E8D2865AAB6C#29669, cast(EPCI_REFERENCE_24128_COL_168901A2_F20D_43CD_ADDF_914DCC871BA4#29625 as string) AS COL_91ADF7E7_9909_41E7_A4AE_9B1765821250#29670, cast(EPCI_REFERENCE_24128_COL_BF23E4AD_C3E4_494A_B016_93BFEC3703FC#29626 as string) AS COL_D5E1121F_1F0E_4C32_B782_8B81498DB680#29671, cast(EPCI_REFERENCE_24128_COL_D24AD23C_1196_4A9E_AC5C_1E320056D7C4#29627 as string) AS COL_D52FDC9D_B060_4A0A_AF00_7DCCBCD008FB#29672, cast(EPCI_REFERENCE_24128_COL_23BDC03D_9214_41F7_B64D_6A67F66FD73A#29628 as string) AS COL_90FA3F5A_12D0_4746_B684_FFDEEDCE9642#29673, cast(EPCI_REFERENCE_24128_COL_28E3CD57_3BBA_491C_9404_C1B9B544E9E9#29629 as string) AS COL_C9EC0388_9F63_49A7_A1B4_CD06136CB768#29674, cast(EPCI_REFERENCE_24128_COL_9014F2F3_8A8A_43F2_81A5_C15BB75751E6#29630 as string) AS COL_CC7D7432_DD73_43E7_815B_100C5FFD0FD4#29675, cast(EPCI_REFERENCE_24128_COL_D6D1736E_5928_416E_9A5B_1258C60FFCEE#29631 as string) AS COL_A27EF8B5_32B3_4A20_B8DD_BC739249612D#29676, cast(EPCI_REFERENCE_24128_COL_6ABE7F1F_3F7A_499F_A959_41B52AEDE99A#29632 as string) AS COL_C04C4FA4_57E5_4AFE_8A4A_303E1AFCCF76#29677, cast(EPCI_REFERENCE_24128_COL_51C7CEE7_8C89_4B66_9A0F_E0E1C7CA8D38#29633 as string) AS COL_64BC8B8A_94C4_488D_A0F9_F623945F66AB#29678, cast(EPCI_REFERENCE_24128_COL_23D918EA_CEBE_472F_988F_E91E6A87F787#29634 as string) AS COL_8C3665AA_685A_49CE_B85F_32FE33386B8B#29679, cast(EPCI_REFERENCE_24128_COL_54C88771_DD52_4B19_9D09_78CB036E1326#29635 as string) AS COL_E1192796_FA55_4A14_B45E_CCF30BC19BCE#29680, cast(EPCI_REFERENCE_24128_COL_FA266E11_2885_4427_B14F_169FE51128B8#29636 as string) AS COL_3BEF645A_08A5_4053_AF9E_B3C06DF915B6#29681]
                        +- Project [COL_852340BE_F461_4346_93DB_C843DAAC0100#29577 AS EPCI_REFERENCE_24128_COL_852340BE_F461_4346_93DB_C843DAAC0100#29622, COL_38D327C5_91C6_48DE_A550_D8D6FC7313DA#29578 AS EPCI_REFERENCE_24128_COL_38D327C5_91C6_48DE_A550_D8D6FC7313DA#29623, COL_F93C76F0_A78C_4080_96B7_C0F6F0DA41AF#29579 AS EPCI_REFERENCE_24128_COL_F93C76F0_A78C_4080_96B7_C0F6F0DA41AF#29624, COL_168901A2_F20D_43CD_ADDF_914DCC871BA4#29580 AS EPCI_REFERENCE_24128_COL_168901A2_F20D_43CD_ADDF_914DCC871BA4#29625, COL_BF23E4AD_C3E4_494A_B016_93BFEC3703FC#29581 AS EPCI_REFERENCE_24128_COL_BF23E4AD_C3E4_494A_B016_93BFEC3703FC#29626, COL_D24AD23C_1196_4A9E_AC5C_1E320056D7C4#29582 AS EPCI_REFERENCE_24128_COL_D24AD23C_1196_4A9E_AC5C_1E320056D7C4#29627, COL_23BDC03D_9214_41F7_B64D_6A67F66FD73A#29583 AS EPCI_REFERENCE_24128_COL_23BDC03D_9214_41F7_B64D_6A67F66FD73A#29628, COL_28E3CD57_3BBA_491C_9404_C1B9B544E9E9#29584 AS EPCI_REFERENCE_24128_COL_28E3CD57_3BBA_491C_9404_C1B9B544E9E9#29629, COL_9014F2F3_8A8A_43F2_81A5_C15BB75751E6#29585 AS EPCI_REFERENCE_24128_COL_9014F2F3_8A8A_43F2_81A5_C15BB75751E6#29630, COL_D6D1736E_5928_416E_9A5B_1258C60FFCEE#29586 AS EPCI_REFERENCE_24128_COL_D6D1736E_5928_416E_9A5B_1258C60FFCEE#29631, COL_6ABE7F1F_3F7A_499F_A959_41B52AEDE99A#29587 AS EPCI_REFERENCE_24128_COL_6ABE7F1F_3F7A_499F_A959_41B52AEDE99A#29632, COL_51C7CEE7_8C89_4B66_9A0F_E0E1C7CA8D38#29588 AS EPCI_REFERENCE_24128_COL_51C7CEE7_8C89_4B66_9A0F_E0E1C7CA8D38#29633, COL_23D918EA_CEBE_472F_988F_E91E6A87F787#29589 AS EPCI_REFERENCE_24128_COL_23D918EA_CEBE_472F_988F_E91E6A87F787#29634, COL_54C88771_DD52_4B19_9D09_78CB036E1326#29590 AS EPCI_REFERENCE_24128_COL_54C88771_DD52_4B19_9D09_78CB036E1326#29635, COL_FA266E11_2885_4427_B14F_169FE51128B8#29591 AS EPCI_REFERENCE_24128_COL_FA266E11_2885_4427_B14F_169FE51128B8#29636]
                           +- SubqueryAlias EPCI_REFERENCE_24128114
                              +- Relation[COL_852340BE_F461_4346_93DB_C843DAAC0100#29577,COL_38D327C5_91C6_48DE_A550_D8D6FC7313DA#29578,COL_F93C76F0_A78C_4080_96B7_C0F6F0DA41AF#29579,COL_168901A2_F20D_43CD_ADDF_914DCC871BA4#29580,COL_BF23E4AD_C3E4_494A_B016_93BFEC3703FC#29581,COL_D24AD23C_1196_4A9E_AC5C_1E320056D7C4#29582,COL_23BDC03D_9214_41F7_B64D_6A67F66FD73A#29583,COL_28E3CD57_3BBA_491C_9404_C1B9B544E9E9#29584,COL_9014F2F3_8A8A_43F2_81A5_C15BB75751E6#29585,COL_D6D1736E_5928_416E_9A5B_1258C60FFCEE#29586,COL_6ABE7F1F_3F7A_499F_A959_41B52AEDE99A#29587,COL_51C7CEE7_8C89_4B66_9A0F_E0E1C7CA8D38#29588,COL_23D918EA_CEBE_472F_988F_E91E6A87F787#29589,COL_54C88771_DD52_4B19_9D09_78CB036E1326#29590,COL_FA266E11_2885_4427_B14F_169FE51128B8#29591] parquet

== Analyzed Logical Plan ==
COL_D0CA777F_6C2C_46FC_ADDD_72DC94CCFD2D: string, COL_009EF890_E70E_4526_ADBC_30B4B756EBA1: string, COL_F6BFAC80_3DA4_4D5F_9DD3_E8D2865AAB6C: string, COL_91ADF7E7_9909_41E7_A4AE_9B1765821250: string, COL_D5E1121F_1F0E_4C32_B782_8B81498DB680: string, COL_D52FDC9D_B060_4A0A_AF00_7DCCBCD008FB: string, COL_90FA3F5A_12D0_4746_B684_FFDEEDCE9642: string, COL_C9EC0388_9F63_49A7_A1B4_CD06136CB768: string, COL_CC7D7432_DD73_43E7_815B_100C5FFD0FD4: string, COL_A27EF8B5_32B3_4A20_B8DD_BC739249612D: string, COL_C04C4FA4_57E5_4AFE_8A4A_303E1AFCCF76: string, COL_64BC8B8A_94C4_488D_A0F9_F623945F66AB: string, COL_8C3665AA_685A_49CE_B85F_32FE33386B8B: string, COL_E1192796_FA55_4A14_B45E_CCF30BC19BCE: string, COL_3BEF645A_08A5_4053_AF9E_B3C06DF915B6: string
GlobalLimit 500000
+- LocalLimit 500000
   +- Project [COL_D0CA777F_6C2C_46FC_ADDD_72DC94CCFD2D#29802 AS COL_D0CA777F_6C2C_46FC_ADDD_72DC94CCFD2D#29832, COL_009EF890_E70E_4526_ADBC_30B4B756EBA1#29803 AS COL_009EF890_E70E_4526_ADBC_30B4B756EBA1#29833, COL_F6BFAC80_3DA4_4D5F_9DD3_E8D2865AAB6C#29804 AS COL_F6BFAC80_3DA4_4D5F_9DD3_E8D2865AAB6C#29834, COL_91ADF7E7_9909_41E7_A4AE_9B1765821250#29805 AS COL_91ADF7E7_9909_41E7_A4AE_9B1765821250#29835, COL_D5E1121F_1F0E_4C32_B782_8B81498DB680#29806 AS COL_D5E1121F_1F0E_4C32_B782_8B81498DB680#29836, COL_D52FDC9D_B060_4A0A_AF00_7DCCBCD008FB#29807 AS COL_D52FDC9D_B060_4A0A_AF00_7DCCBCD008FB#29837, COL_90FA3F5A_12D0_4746_B684_FFDEEDCE9642#29808 AS COL_90FA3F5A_12D0_4746_B684_FFDEEDCE9642#29838, COL_C9EC0388_9F63_49A7_A1B4_CD06136CB768#29809 AS COL_C9EC0388_9F63_49A7_A1B4_CD06136CB768#29839, COL_CC7D7432_DD73_43E7_815B_100C5FFD0FD4#29810 AS COL_CC7D7432_DD73_43E7_815B_100C5FFD0FD4#29840, COL_A27EF8B5_32B3_4A20_B8DD_BC739249612D#29811 AS COL_A27EF8B5_32B3_4A20_B8DD_BC739249612D#29841, COL_C04C4FA4_57E5_4AFE_8A4A_303E1AFCCF76#29812 AS COL_C04C4FA4_57E5_4AFE_8A4A_303E1AFCCF76#29842, COL_64BC8B8A_94C4_488D_A0F9_F623945F66AB#29813 AS COL_64BC8B8A_94C4_488D_A0F9_F623945F66AB#29843, COL_8C3665AA_685A_49CE_B85F_32FE33386B8B#29814 AS COL_8C3665AA_685A_49CE_B85F_32FE33386B8B#29844, COL_E1192796_FA55_4A14_B45E_CCF30BC19BCE#29815 AS COL_E1192796_FA55_4A14_B45E_CCF30BC19BCE#29845, COL_3BEF645A_08A5_4053_AF9E_B3C06DF915B6#29816 AS COL_3BEF645A_08A5_4053_AF9E_B3C06DF915B6#29846]
      +- Project [COL_D0CA777F_6C2C_46FC_ADDD_72DC94CCFD2D#29772 AS COL_D0CA777F_6C2C_46FC_ADDD_72DC94CCFD2D#29802, COL_009EF890_E70E_4526_ADBC_30B4B756EBA1#29773 AS COL_009EF890_E70E_4526_ADBC_30B4B756EBA1#29803, COL_F6BFAC80_3DA4_4D5F_9DD3_E8D2865AAB6C#29774 AS COL_F6BFAC80_3DA4_4D5F_9DD3_E8D2865AAB6C#29804, COL_91ADF7E7_9909_41E7_A4AE_9B1765821250#29775 AS COL_91ADF7E7_9909_41E7_A4AE_9B1765821250#29805, COL_D5E1121F_1F0E_4C32_B782_8B81498DB680#29776 AS COL_D5E1121F_1F0E_4C32_B782_8B81498DB680#29806, COL_D52FDC9D_B060_4A0A_AF00_7DCCBCD008FB#29777 AS COL_D52FDC9D_B060_4A0A_AF00_7DCCBCD008FB#29807, COL_90FA3F5A_12D0_4746_B684_FFDEEDCE9642#29778 AS COL_90FA3F5A_12D0_4746_B684_FFDEEDCE9642#29808, COL_C9EC0388_9F63_49A7_A1B4_CD06136CB768#29779 AS COL_C9EC0388_9F63_49A7_A1B4_CD06136CB768#29809, COL_CC7D7432_DD73_43E7_815B_100C5FFD0FD4#29780 AS COL_CC7D7432_DD73_43E7_815B_100C5FFD0FD4#29810, COL_A27EF8B5_32B3_4A20_B8DD_BC739249612D#29781 AS COL_A27EF8B5_32B3_4A20_B8DD_BC739249612D#29811, COL_C04C4FA4_57E5_4AFE_8A4A_303E1AFCCF76#29782 AS COL_C04C4FA4_57E5_4AFE_8A4A_303E1AFCCF76#29812, COL_64BC8B8A_94C4_488D_A0F9_F623945F66AB#29783 AS COL_64BC8B8A_94C4_488D_A0F9_F623945F66AB#29813, COL_8C3665AA_685A_49CE_B85F_32FE33386B8B#29784 AS COL_8C3665AA_685A_49CE_B85F_32FE33386B8B#29814, COL_E1192796_FA55_4A14_B45E_CCF30BC19BCE#29785 AS COL_E1192796_FA55_4A14_B45E_CCF30BC19BCE#29815, COL_3BEF645A_08A5_4053_AF9E_B3C06DF915B6#29786 AS COL_3BEF645A_08A5_4053_AF9E_B3C06DF915B6#29816]
         +- Project [COL_D0CA777F_6C2C_46FC_ADDD_72DC94CCFD2D#29742 AS COL_D0CA777F_6C2C_46FC_ADDD_72DC94CCFD2D#29772, COL_009EF890_E70E_4526_ADBC_30B4B756EBA1#29743 AS COL_009EF890_E70E_4526_ADBC_30B4B756EBA1#29773, COL_F6BFAC80_3DA4_4D5F_9DD3_E8D2865AAB6C#29744 AS COL_F6BFAC80_3DA4_4D5F_9DD3_E8D2865AAB6C#29774, COL_91ADF7E7_9909_41E7_A4AE_9B1765821250#29745 AS COL_91ADF7E7_9909_41E7_A4AE_9B1765821250#29775, COL_D5E1121F_1F0E_4C32_B782_8B81498DB680#29746 AS COL_D5E1121F_1F0E_4C32_B782_8B81498DB680#29776, COL_D52FDC9D_B060_4A0A_AF00_7DCCBCD008FB#29747 AS COL_D52FDC9D_B060_4A0A_AF00_7DCCBCD008FB#29777, COL_90FA3F5A_12D0_4746_B684_FFDEEDCE9642#29748 AS COL_90FA3F5A_12D0_4746_B684_FFDEEDCE9642#29778, COL_C9EC0388_9F63_49A7_A1B4_CD06136CB768#29749 AS COL_C9EC0388_9F63_49A7_A1B4_CD06136CB768#29779, COL_CC7D7432_DD73_43E7_815B_100C5FFD0FD4#29750 AS COL_CC7D7432_DD73_43E7_815B_100C5FFD0FD4#29780, COL_A27EF8B5_32B3_4A20_B8DD_BC739249612D#29751 AS COL_A27EF8B5_32B3_4A20_B8DD_BC739249612D#29781, COL_C04C4FA4_57E5_4AFE_8A4A_303E1AFCCF76#29752 AS COL_C04C4FA4_57E5_4AFE_8A4A_303E1AFCCF76#29782, COL_64BC8B8A_94C4_488D_A0F9_F623945F66AB#29753 AS COL_64BC8B8A_94C4_488D_A0F9_F623945F66AB#29783, COL_8C3665AA_685A_49CE_B85F_32FE33386B8B#29754 AS COL_8C3665AA_685A_49CE_B85F_32FE33386B8B#29784, COL_E1192796_FA55_4A14_B45E_CCF30BC19BCE#29755 AS COL_E1192796_FA55_4A14_B45E_CCF30BC19BCE#29785, COL_3BEF645A_08A5_4053_AF9E_B3C06DF915B6#29756 AS COL_3BEF645A_08A5_4053_AF9E_B3C06DF915B6#29786]
            +- Project [COL_D0CA777F_6C2C_46FC_ADDD_72DC94CCFD2D#29712 AS COL_D0CA777F_6C2C_46FC_ADDD_72DC94CCFD2D#29742, COL_009EF890_E70E_4526_ADBC_30B4B756EBA1#29713 AS COL_009EF890_E70E_4526_ADBC_30B4B756EBA1#29743, COL_F6BFAC80_3DA4_4D5F_9DD3_E8D2865AAB6C#29714 AS COL_F6BFAC80_3DA4_4D5F_9DD3_E8D2865AAB6C#29744, COL_91ADF7E7_9909_41E7_A4AE_9B1765821250#29715 AS COL_91ADF7E7_9909_41E7_A4AE_9B1765821250#29745, COL_D5E1121F_1F0E_4C32_B782_8B81498DB680#29716 AS COL_D5E1121F_1F0E_4C32_B782_8B81498DB680#29746, COL_D52FDC9D_B060_4A0A_AF00_7DCCBCD008FB#29717 AS COL_D52FDC9D_B060_4A0A_AF00_7DCCBCD008FB#29747, COL_90FA3F5A_12D0_4746_B684_FFDEEDCE9642#29718 AS COL_90FA3F5A_12D0_4746_B684_FFDEEDCE9642#29748, COL_C9EC0388_9F63_49A7_A1B4_CD06136CB768#29719 AS COL_C9EC0388_9F63_49A7_A1B4_CD06136CB768#29749, COL_CC7D7432_DD73_43E7_815B_100C5FFD0FD4#29720 AS COL_CC7D7432_DD73_43E7_815B_100C5FFD0FD4#29750, COL_A27EF8B5_32B3_4A20_B8DD_BC739249612D#29721 AS COL_A27EF8B5_32B3_4A20_B8DD_BC739249612D#29751, COL_C04C4FA4_57E5_4AFE_8A4A_303E1AFCCF76#29722 AS COL_C04C4FA4_57E5_4AFE_8A4A_303E1AFCCF76#29752, COL_64BC8B8A_94C4_488D_A0F9_F623945F66AB#29723 AS COL_64BC8B8A_94C4_488D_A0F9_F623945F66AB#29753, COL_8C3665AA_685A_49CE_B85F_32FE33386B8B#29724 AS COL_8C3665AA_685A_49CE_B85F_32FE33386B8B#29754, COL_E1192796_FA55_4A14_B45E_CCF30BC19BCE#29725 AS COL_E1192796_FA55_4A14_B45E_CCF30BC19BCE#29755, COL_3BEF645A_08A5_4053_AF9E_B3C06DF915B6#29726 AS COL_3BEF645A_08A5_4053_AF9E_B3C06DF915B6#29756]
               +- Project [COL_D0CA777F_6C2C_46FC_ADDD_72DC94CCFD2D#29667 AS COL_D0CA777F_6C2C_46FC_ADDD_72DC94CCFD2D#29712, COL_009EF890_E70E_4526_ADBC_30B4B756EBA1#29668 AS COL_009EF890_E70E_4526_ADBC_30B4B756EBA1#29713, COL_F6BFAC80_3DA4_4D5F_9DD3_E8D2865AAB6C#29669 AS COL_F6BFAC80_3DA4_4D5F_9DD3_E8D2865AAB6C#29714, COL_91ADF7E7_9909_41E7_A4AE_9B1765821250#29670 AS COL_91ADF7E7_9909_41E7_A4AE_9B1765821250#29715, COL_D5E1121F_1F0E_4C32_B782_8B81498DB680#29671 AS COL_D5E1121F_1F0E_4C32_B782_8B81498DB680#29716, COL_D52FDC9D_B060_4A0A_AF00_7DCCBCD008FB#29672 AS COL_D52FDC9D_B060_4A0A_AF00_7DCCBCD008FB#29717, COL_90FA3F5A_12D0_4746_B684_FFDEEDCE9642#29673 AS COL_90FA3F5A_12D0_4746_B684_FFDEEDCE9642#29718, COL_C9EC0388_9F63_49A7_A1B4_CD06136CB768#29674 AS COL_C9EC0388_9F63_49A7_A1B4_CD06136CB768#29719, COL_CC7D7432_DD73_43E7_815B_100C5FFD0FD4#29675 AS COL_CC7D7432_DD73_43E7_815B_100C5FFD0FD4#29720, COL_A27EF8B5_32B3_4A20_B8DD_BC739249612D#29676 AS COL_A27EF8B5_32B3_4A20_B8DD_BC739249612D#29721, COL_C04C4FA4_57E5_4AFE_8A4A_303E1AFCCF76#29677 AS COL_C04C4FA4_57E5_4AFE_8A4A_303E1AFCCF76#29722, COL_64BC8B8A_94C4_488D_A0F9_F623945F66AB#29678 AS COL_64BC8B8A_94C4_488D_A0F9_F623945F66AB#29723, COL_8C3665AA_685A_49CE_B85F_32FE33386B8B#29679 AS COL_8C3665AA_685A_49CE_B85F_32FE33386B8B#29724, COL_E1192796_FA55_4A14_B45E_CCF30BC19BCE#29680 AS COL_E1192796_FA55_4A14_B45E_CCF30BC19BCE#29725, COL_3BEF645A_08A5_4053_AF9E_B3C06DF915B6#29681 AS COL_3BEF645A_08A5_4053_AF9E_B3C06DF915B6#29726]
                  +- Project [COL_D0CA777F_6C2C_46FC_ADDD_72DC94CCFD2D#29667, COL_009EF890_E70E_4526_ADBC_30B4B756EBA1#29668, COL_F6BFAC80_3DA4_4D5F_9DD3_E8D2865AAB6C#29669, COL_91ADF7E7_9909_41E7_A4AE_9B1765821250#29670, COL_D5E1121F_1F0E_4C32_B782_8B81498DB680#29671, COL_D52FDC9D_B060_4A0A_AF00_7DCCBCD008FB#29672, COL_90FA3F5A_12D0_4746_B684_FFDEEDCE9642#29673, COL_C9EC0388_9F63_49A7_A1B4_CD06136CB768#29674, COL_CC7D7432_DD73_43E7_815B_100C5FFD0FD4#29675, COL_A27EF8B5_32B3_4A20_B8DD_BC739249612D#29676, COL_C04C4FA4_57E5_4AFE_8A4A_303E1AFCCF76#29677, COL_64BC8B8A_94C4_488D_A0F9_F623945F66AB#29678, COL_8C3665AA_685A_49CE_B85F_32FE33386B8B#29679, COL_E1192796_FA55_4A14_B45E_CCF30BC19BCE#29680, COL_3BEF645A_08A5_4053_AF9E_B3C06DF915B6#29681]
                     +- Project [cast(EPCI_REFERENCE_24128_COL_852340BE_F461_4346_93DB_C843DAAC0100#29622 as string) AS COL_D0CA777F_6C2C_46FC_ADDD_72DC94CCFD2D#29667, cast(EPCI_REFERENCE_24128_COL_38D327C5_91C6_48DE_A550_D8D6FC7313DA#29623 as string) AS COL_009EF890_E70E_4526_ADBC_30B4B756EBA1#29668, cast(EPCI_REFERENCE_24128_COL_F93C76F0_A78C_4080_96B7_C0F6F0DA41AF#29624 as string) AS COL_F6BFAC80_3DA4_4D5F_9DD3_E8D2865AAB6C#29669, cast(EPCI_REFERENCE_24128_COL_168901A2_F20D_43CD_ADDF_914DCC871BA4#29625 as string) AS COL_91ADF7E7_9909_41E7_A4AE_9B1765821250#29670, cast(EPCI_REFERENCE_24128_COL_BF23E4AD_C3E4_494A_B016_93BFEC3703FC#29626 as string) AS COL_D5E1121F_1F0E_4C32_B782_8B81498DB680#29671, cast(EPCI_REFERENCE_24128_COL_D24AD23C_1196_4A9E_AC5C_1E320056D7C4#29627 as string) AS COL_D52FDC9D_B060_4A0A_AF00_7DCCBCD008FB#29672, cast(EPCI_REFERENCE_24128_COL_23BDC03D_9214_41F7_B64D_6A67F66FD73A#29628 as string) AS COL_90FA3F5A_12D0_4746_B684_FFDEEDCE9642#29673, cast(EPCI_REFERENCE_24128_COL_28E3CD57_3BBA_491C_9404_C1B9B544E9E9#29629 as string) AS COL_C9EC0388_9F63_49A7_A1B4_CD06136CB768#29674, cast(EPCI_REFERENCE_24128_COL_9014F2F3_8A8A_43F2_81A5_C15BB75751E6#29630 as string) AS COL_CC7D7432_DD73_43E7_815B_100C5FFD0FD4#29675, cast(EPCI_REFERENCE_24128_COL_D6D1736E_5928_416E_9A5B_1258C60FFCEE#29631 as string) AS COL_A27EF8B5_32B3_4A20_B8DD_BC739249612D#29676, cast(EPCI_REFERENCE_24128_COL_6ABE7F1F_3F7A_499F_A959_41B52AEDE99A#29632 as string) AS COL_C04C4FA4_57E5_4AFE_8A4A_303E1AFCCF76#29677, cast(EPCI_REFERENCE_24128_COL_51C7CEE7_8C89_4B66_9A0F_E0E1C7CA8D38#29633 as string) AS COL_64BC8B8A_94C4_488D_A0F9_F623945F66AB#29678, cast(EPCI_REFERENCE_24128_COL_23D918EA_CEBE_472F_988F_E91E6A87F787#29634 as string) AS COL_8C3665AA_685A_49CE_B85F_32FE33386B8B#29679, cast(EPCI_REFERENCE_24128_COL_54C88771_DD52_4B19_9D09_78CB036E1326#29635 as string) AS COL_E1192796_FA55_4A14_B45E_CCF30BC19BCE#29680, cast(EPCI_REFERENCE_24128_COL_FA266E11_2885_4427_B14F_169FE51128B8#29636 as string) AS COL_3BEF645A_08A5_4053_AF9E_B3C06DF915B6#29681]
                        +- Project [COL_852340BE_F461_4346_93DB_C843DAAC0100#29577 AS EPCI_REFERENCE_24128_COL_852340BE_F461_4346_93DB_C843DAAC0100#29622, COL_38D327C5_91C6_48DE_A550_D8D6FC7313DA#29578 AS EPCI_REFERENCE_24128_COL_38D327C5_91C6_48DE_A550_D8D6FC7313DA#29623, COL_F93C76F0_A78C_4080_96B7_C0F6F0DA41AF#29579 AS EPCI_REFERENCE_24128_COL_F93C76F0_A78C_4080_96B7_C0F6F0DA41AF#29624, COL_168901A2_F20D_43CD_ADDF_914DCC871BA4#29580 AS EPCI_REFERENCE_24128_COL_168901A2_F20D_43CD_ADDF_914DCC871BA4#29625, COL_BF23E4AD_C3E4_494A_B016_93BFEC3703FC#29581 AS EPCI_REFERENCE_24128_COL_BF23E4AD_C3E4_494A_B016_93BFEC3703FC#29626, COL_D24AD23C_1196_4A9E_AC5C_1E320056D7C4#29582 AS EPCI_REFERENCE_24128_COL_D24AD23C_1196_4A9E_AC5C_1E320056D7C4#29627, COL_23BDC03D_9214_41F7_B64D_6A67F66FD73A#29583 AS EPCI_REFERENCE_24128_COL_23BDC03D_9214_41F7_B64D_6A67F66FD73A#29628, COL_28E3CD57_3BBA_491C_9404_C1B9B544E9E9#29584 AS EPCI_REFERENCE_24128_COL_28E3CD57_3BBA_491C_9404_C1B9B544E9E9#29629, COL_9014F2F3_8A8A_43F2_81A5_C15BB75751E6#29585 AS EPCI_REFERENCE_24128_COL_9014F2F3_8A8A_43F2_81A5_C15BB75751E6#29630, COL_D6D1736E_5928_416E_9A5B_1258C60FFCEE#29586 AS EPCI_REFERENCE_24128_COL_D6D1736E_5928_416E_9A5B_1258C60FFCEE#29631, COL_6ABE7F1F_3F7A_499F_A959_41B52AEDE99A#29587 AS EPCI_REFERENCE_24128_COL_6ABE7F1F_3F7A_499F_A959_41B52AEDE99A#29632, COL_51C7CEE7_8C89_4B66_9A0F_E0E1C7CA8D38#29588 AS EPCI_REFERENCE_24128_COL_51C7CEE7_8C89_4B66_9A0F_E0E1C7CA8D38#29633, COL_23D918EA_CEBE_472F_988F_E91E6A87F787#29589 AS EPCI_REFERENCE_24128_COL_23D918EA_CEBE_472F_988F_E91E6A87F787#29634, COL_54C88771_DD52_4B19_9D09_78CB036E1326#29590 AS EPCI_REFERENCE_24128_COL_54C88771_DD52_4B19_9D09_78CB036E1326#29635, COL_FA266E11_2885_4427_B14F_169FE51128B8#29591 AS EPCI_REFERENCE_24128_COL_FA266E11_2885_4427_B14F_169FE51128B8#29636]
                           +- SubqueryAlias EPCI_REFERENCE_24128114
                              +- Relation[COL_852340BE_F461_4346_93DB_C843DAAC0100#29577,COL_38D327C5_91C6_48DE_A550_D8D6FC7313DA#29578,COL_F93C76F0_A78C_4080_96B7_C0F6F0DA41AF#29579,COL_168901A2_F20D_43CD_ADDF_914DCC871BA4#29580,COL_BF23E4AD_C3E4_494A_B016_93BFEC3703FC#29581,COL_D24AD23C_1196_4A9E_AC5C_1E320056D7C4#29582,COL_23BDC03D_9214_41F7_B64D_6A67F66FD73A#29583,COL_28E3CD57_3BBA_491C_9404_C1B9B544E9E9#29584,COL_9014F2F3_8A8A_43F2_81A5_C15BB75751E6#29585,COL_D6D1736E_5928_416E_9A5B_1258C60FFCEE#29586,COL_6ABE7F1F_3F7A_499F_A959_41B52AEDE99A#29587,COL_51C7CEE7_8C89_4B66_9A0F_E0E1C7CA8D38#29588,COL_23D918EA_CEBE_472F_988F_E91E6A87F787#29589,COL_54C88771_DD52_4B19_9D09_78CB036E1326#29590,COL_FA266E11_2885_4427_B14F_169FE51128B8#29591] parquet

== Optimized Logical Plan ==
GlobalLimit 500000
+- LocalLimit 500000
   +- Project [COL_852340BE_F461_4346_93DB_C843DAAC0100#29577 AS COL_D0CA777F_6C2C_46FC_ADDD_72DC94CCFD2D#29832, COL_38D327C5_91C6_48DE_A550_D8D6FC7313DA#29578 AS COL_009EF890_E70E_4526_ADBC_30B4B756EBA1#29833, COL_F93C76F0_A78C_4080_96B7_C0F6F0DA41AF#29579 AS COL_F6BFAC80_3DA4_4D5F_9DD3_E8D2865AAB6C#29834, COL_168901A2_F20D_43CD_ADDF_914DCC871BA4#29580 AS COL_91ADF7E7_9909_41E7_A4AE_9B1765821250#29835, COL_BF23E4AD_C3E4_494A_B016_93BFEC3703FC#29581 AS COL_D5E1121F_1F0E_4C32_B782_8B81498DB680#29836, COL_D24AD23C_1196_4A9E_AC5C_1E320056D7C4#29582 AS COL_D52FDC9D_B060_4A0A_AF00_7DCCBCD008FB#29837, COL_23BDC03D_9214_41F7_B64D_6A67F66FD73A#29583 AS COL_90FA3F5A_12D0_4746_B684_FFDEEDCE9642#29838, COL_28E3CD57_3BBA_491C_9404_C1B9B544E9E9#29584 AS COL_C9EC0388_9F63_49A7_A1B4_CD06136CB768#29839, COL_9014F2F3_8A8A_43F2_81A5_C15BB75751E6#29585 AS COL_CC7D7432_DD73_43E7_815B_100C5FFD0FD4#29840, COL_D6D1736E_5928_416E_9A5B_1258C60FFCEE#29586 AS COL_A27EF8B5_32B3_4A20_B8DD_BC739249612D#29841, COL_6ABE7F1F_3F7A_499F_A959_41B52AEDE99A#29587 AS COL_C04C4FA4_57E5_4AFE_8A4A_303E1AFCCF76#29842, COL_51C7CEE7_8C89_4B66_9A0F_E0E1C7CA8D38#29588 AS COL_64BC8B8A_94C4_488D_A0F9_F623945F66AB#29843, COL_23D918EA_CEBE_472F_988F_E91E6A87F787#29589 AS COL_8C3665AA_685A_49CE_B85F_32FE33386B8B#29844, COL_54C88771_DD52_4B19_9D09_78CB036E1326#29590 AS COL_E1192796_FA55_4A14_B45E_CCF30BC19BCE#29845, COL_FA266E11_2885_4427_B14F_169FE51128B8#29591 AS COL_3BEF645A_08A5_4053_AF9E_B3C06DF915B6#29846]
      +- Relation[COL_852340BE_F461_4346_93DB_C843DAAC0100#29577,COL_38D327C5_91C6_48DE_A550_D8D6FC7313DA#29578,COL_F93C76F0_A78C_4080_96B7_C0F6F0DA41AF#29579,COL_168901A2_F20D_43CD_ADDF_914DCC871BA4#29580,COL_BF23E4AD_C3E4_494A_B016_93BFEC3703FC#29581,COL_D24AD23C_1196_4A9E_AC5C_1E320056D7C4#29582,COL_23BDC03D_9214_41F7_B64D_6A67F66FD73A#29583,COL_28E3CD57_3BBA_491C_9404_C1B9B544E9E9#29584,COL_9014F2F3_8A8A_43F2_81A5_C15BB75751E6#29585,COL_D6D1736E_5928_416E_9A5B_1258C60FFCEE#29586,COL_6ABE7F1F_3F7A_499F_A959_41B52AEDE99A#29587,COL_51C7CEE7_8C89_4B66_9A0F_E0E1C7CA8D38#29588,COL_23D918EA_CEBE_472F_988F_E91E6A87F787#29589,COL_54C88771_DD52_4B19_9D09_78CB036E1326#29590,COL_FA266E11_2885_4427_B14F_169FE51128B8#29591] parquet

== Physical Plan ==
CollectLimit 500000
+- *(1) Project [COL_852340BE_F461_4346_93DB_C843DAAC0100#29577 AS COL_D0CA777F_6C2C_46FC_ADDD_72DC94CCFD2D#29832, COL_38D327C5_91C6_48DE_A550_D8D6FC7313DA#29578 AS COL_009EF890_E70E_4526_ADBC_30B4B756EBA1#29833, COL_F93C76F0_A78C_4080_96B7_C0F6F0DA41AF#29579 AS COL_F6BFAC80_3DA4_4D5F_9DD3_E8D2865AAB6C#29834, COL_168901A2_F20D_43CD_ADDF_914DCC871BA4#29580 AS COL_91ADF7E7_9909_41E7_A4AE_9B1765821250#29835, COL_BF23E4AD_C3E4_494A_B016_93BFEC3703FC#29581 AS COL_D5E1121F_1F0E_4C32_B782_8B81498DB680#29836, COL_D24AD23C_1196_4A9E_AC5C_1E320056D7C4#29582 AS COL_D52FDC9D_B060_4A0A_AF00_7DCCBCD008FB#29837, COL_23BDC03D_9214_41F7_B64D_6A67F66FD73A#29583 AS COL_90FA3F5A_12D0_4746_B684_FFDEEDCE9642#29838, COL_28E3CD57_3BBA_491C_9404_C1B9B544E9E9#29584 AS COL_C9EC0388_9F63_49A7_A1B4_CD06136CB768#29839, COL_9014F2F3_8A8A_43F2_81A5_C15BB75751E6#29585 AS COL_CC7D7432_DD73_43E7_815B_100C5FFD0FD4#29840, COL_D6D1736E_5928_416E_9A5B_1258C60FFCEE#29586 AS COL_A27EF8B5_32B3_4A20_B8DD_BC739249612D#29841, COL_6ABE7F1F_3F7A_499F_A959_41B52AEDE99A#29587 AS COL_C04C4FA4_57E5_4AFE_8A4A_303E1AFCCF76#29842, COL_51C7CEE7_8C89_4B66_9A0F_E0E1C7CA8D38#29588 AS COL_64BC8B8A_94C4_488D_A0F9_F623945F66AB#29843, COL_23D918EA_CEBE_472F_988F_E91E6A87F787#29589 AS COL_8C3665AA_685A_49CE_B85F_32FE33386B8B#29844, COL_54C88771_DD52_4B19_9D09_78CB036E1326#29590 AS COL_E1192796_FA55_4A14_B45E_CCF30BC19BCE#29845, COL_FA266E11_2885_4427_B14F_169FE51128B8#29591 AS COL_3BEF645A_08A5_4053_AF9E_B3C06DF915B6#29846]
   +- *(1) ColumnarToRow
      +- FileScan parquet [COL_852340BE_F461_4346_93DB_C843DAAC0100#29577,COL_38D327C5_91C6_48DE_A550_D8D6FC7313DA#29578,COL_F93C76F0_A78C_4080_96B7_C0F6F0DA41AF#29579,COL_168901A2_F20D_43CD_ADDF_914DCC871BA4#29580,COL_BF23E4AD_C3E4_494A_B016_93BFEC3703FC#29581,COL_D24AD23C_1196_4A9E_AC5C_1E320056D7C4#29582,COL_23BDC03D_9214_41F7_B64D_6A67F66FD73A#29583,COL_28E3CD57_3BBA_491C_9404_C1B9B544E9E9#29584,COL_9014F2F3_8A8A_43F2_81A5_C15BB75751E6#29585,COL_D6D1736E_5928_416E_9A5B_1258C60FFCEE#29586,COL_6ABE7F1F_3F7A_499F_A959_41B52AEDE99A#29587,COL_51C7CEE7_8C89_4B66_9A0F_E0E1C7CA8D38#29588,COL_23D918EA_CEBE_472F_988F_E91E6A87F787#29589,COL_54C88771_DD52_4B19_9D09_78CB036E1326#29590,COL_FA266E11_2885_4427_B14F_169FE51128B8#29591] Batched: true, DataFilters: [], Format: Parquet, Location: InMemoryFileIndex[file:/data/output/cache/parquet/datablock/EPCI_REFERENCE_24128], PartitionFilters: [], PushedFilters: [], ReadSchema: struct<COL_852340BE_F461_4346_93DB_C843DAAC0100:string,COL_38D327C5_91C6_48DE_A550_D8D6FC7313DA:s...