SP1 - Details for Query 2399

Submitted Time: 2026/09/17 16:21:29
Duration: 1 s
Succeeded Jobs: 3479 3480 3481

Show the Stage ID and Task ID that corresponds to the max metric

digraph G { 0 [labelType="html" label=" AdaptiveSparkPlan "]; 1 [labelType="html" label="Execute InsertIntoHadoopFsRelationCommand task commit time total (min, med, max (stageId: taskId)) 9 ms (0 ms, 1 ms, 3 ms (stage 7096.0: task 9268)) number of written files: 10 job commit time: 19 ms number of output rows: 56,805 number of dynamic part: 0 written output: 6.4 MiB"]; 2 [labelType="html" label=" WriteFiles "]; subgraph cluster3 { isCluster="true"; label="WholeStageCodegen (5)\n \nduration: total (min, med, max (stageId: taskId))\n3.9 s (333 ms, 390 ms, 439 ms (stage 7096.0: task 9271))"; 4 [labelType="html" label=" Project "]; 5 [labelType="html" label="SortMergeJoin number of output rows: 56,805 spill size total (min, med, max (stageId: taskId)) 0.0 B (0.0 B, 0.0 B, 0.0 B (stage 7096.0: task 9273))"]; } subgraph cluster6 { isCluster="true"; label="WholeStageCodegen (3)\n \nduration: total (min, med, max (stageId: taskId))\n4.6 s (399 ms, 456 ms, 502 ms (stage 7096.0: task 9271))"; 7 [labelType="html" label="Sort sort time total (min, med, max (stageId: taskId)) 0 ms (0 ms, 0 ms, 0 ms (stage 7096.0: task 9268)) peak memory total (min, med, max (stageId: taskId)) 162.5 MiB (16.3 MiB, 16.3 MiB, 16.3 MiB (stage 7096.0: task 9268)) spill size total (min, med, max (stageId: taskId)) 0.0 B (0.0 B, 0.0 B, 0.0 B (stage 7096.0: task 9268))"]; } 8 [labelType="html" label="Exchange shuffle records written: 56,805 local merged chunks fetched: 0 shuffle write time total (min, med, max (stageId: taskId)) 69 ms (6 ms, 7 ms, 7 ms (stage 7092.0: task 9257)) remote merged bytes read: 0.0 B local merged blocks fetched: 0 corrupt merged block chunks: 0 remote merged reqs duration: 0 ms remote merged blocks fetched: 0 records read: 56,805 local bytes read total (min, med, max (stageId: taskId)) 19.8 MiB (2008.2 KiB, 2030.1 KiB, 2047.1 KiB (stage 7096.0: task 9269)) fetch wait time total (min, med, max (stageId: taskId)) 0 ms (0 ms, 0 ms, 0 ms (stage 7096.0: task 9268)) remote bytes read: 0.0 B merged fetch fallback count: 0 local blocks read: 100 remote merged chunks fetched: 0 remote blocks read: 0 data size total (min, med, max (stageId: taskId)) 64.1 MiB (6.1 MiB, 6.4 MiB, 6.8 MiB (stage 7092.0: task 9257)) local merged bytes read: 0.0 B number of partitions: 10 remote reqs duration: 0 ms remote bytes read to disk: 0.0 B shuffle bytes written total (min, med, max (stageId: taskId)) 19.8 MiB (1918.7 KiB, 2019.7 KiB, 2.1 MiB (stage 7092.0: task 9257))"]; subgraph cluster9 { isCluster="true"; label="WholeStageCodegen (1)\n \nduration: total (min, med, max (stageId: taskId))\n4.4 s (428 ms, 447 ms, 450 ms (stage 7092.0: task 9259))"; 10 [labelType="html" label=" Project "]; 11 [labelType="html" label="ColumnarToRow number of output rows: 56,805 number of input batches: 20"]; } 12 [labelType="html" label="Scan parquet number of files read: 10 scan time total (min, med, max (stageId: taskId)) 232 ms (19 ms, 25 ms, 28 ms (stage 7092.0: task 9259)) metadata time: 0 ms size of files read: 4.0 MiB number of output rows: 56,805"]; subgraph cluster13 { isCluster="true"; label="WholeStageCodegen (4)\n \nduration: total (min, med, max (stageId: taskId))\n34.2 m (35.8 s, 2.4 m, 12.8 m (stage 7096.0: task 9268))"; 14 [labelType="html" label="Sort sort time total (min, med, max (stageId: taskId)) 0 ms (0 ms, 0 ms, 0 ms (stage 7096.0: task 9268)) peak memory total (min, med, max (stageId: taskId)) 160.6 MiB (16.1 MiB, 16.1 MiB, 16.1 MiB (stage 7096.0: task 9268)) spill size total (min, med, max (stageId: taskId)) 0.0 B (0.0 B, 0.0 B, 0.0 B (stage 7096.0: task 9268))"]; } 15 [labelType="html" label="Exchange shuffle records written: 85 local merged chunks fetched: 0 shuffle write time: 1 ms remote merged bytes read: 0.0 B local merged blocks fetched: 0 corrupt merged block chunks: 0 remote merged reqs duration: 0 ms remote merged blocks fetched: 0 records read: 85 local bytes read total (min, med, max (stageId: taskId)) 1402.0 B (87.0 B, 140.0 B, 204.0 B (stage 7096.0: task 9270)) fetch wait time total (min, med, max (stageId: taskId)) 0 ms (0 ms, 0 ms, 0 ms (stage 7096.0: task 9268)) remote bytes read: 0.0 B merged fetch fallback count: 0 local blocks read: 10 remote merged chunks fetched: 0 remote blocks read: 0 data size: 2.7 KiB local merged bytes read: 0.0 B number of partitions: 10 remote reqs duration: 0 ms remote bytes read to disk: 0.0 B shuffle bytes written: 1402.0 B"]; subgraph cluster16 { isCluster="true"; label="WholeStageCodegen (2)\n \nduration: 4 ms"; 17 [labelType="html" label=" Project "]; 18 [labelType="html" label="Filter number of output rows: 85"]; 19 [labelType="html" label="ColumnarToRow number of output rows: 5,907 number of input batches: 2"]; } 20 [labelType="html" label="Scan parquet number of files read: 1 scan time: 2 ms metadata time: 0 ms size of files read: 197.4 KiB number of output rows: 5,907"]; 1->0; 2->1; 4->2; 5->4; 7->5; 8->7; 10->8; 11->10; 12->11; 14->5; 15->14; 17->15; 18->17; 19->18; 20->19; }

AdaptiveSparkPlan isFinalPlan=true

Execute InsertIntoHadoopFsRelationCommand file:/data/output/cache/parquet/datablock/09_A_TTT_SUPLIG_225939, false, Parquet, [path=file:///data/output/cache/parquet/datablock/09_A_TTT_SUPLIG_225939], Overwrite, [COL_497B3BF1_A9CE_4411_8889_2F0461FEE049, COL_8DCB3027_3C9D_41AC_A59E_4DD19821C3A6, COL_F36F08A6_928E_400F_B138_61F9B8D28AF3, COL_A213E432_2691_4225_8DF4_C45A67AF4D9C, COL_E3EB948B_0B85_4F37_970A_DD334B343EE2, COL_77534C40_F008_4F9B_99A1_4982451B7A24, COL_AF30678A_46A6_422E_838A_452D36B65FC1, COL_29EA226E_C020_4D1F_A8DC_11FA4AB16409, COL_C3DFC75D_DBFD_47F3_B940_59BD461CA3C0, COL_7506CA9E_3DD1_4B12_8A2A_D2766532D59A, COL_64235A62_C014_4D54_98DA_329A3C835EDA, COL_76B3E933_F01E_4379_9153_B0E76D1633B5, COL_9AE6D4D7_A126_4880_B33C_1337A4899A8C, COL_9A5C81F5_9A6A_450B_AEBB_DB3516344104, COL_066BC6D4_55AA_434A_8BD9_1D16816DDDDA, COL_22D6710B_B7B5_4729_9BCB_202027CB0BD4, COL_6102ADDE_08E8_4710_9AD0_D2CA02BC21DE, COL_4A1DE469_43EB_4CAC_9134_3E477437431A, COL_7666BE37_7FEC_476C_B19D_F98892962E5D, COL_0BAF376F_F7D0_45AE_AEF9_8E19B504594E, COL_554D78B0_EA21_483D_B574_547426ADB482, COL_0B066C93_809D_4EB0_8ADF_3636D7B76593, COL_EB753D17_130C_4979_986B_D18FFF9DD40A, COL_0A7B71F1_4A2E_4EB3_A94C_939DCDA503B9, ... 32 more fields]

WriteFiles

Project [COL_497B3BF1_A9CE_4411_8889_2F0461FEE049#595587, COL_8DCB3027_3C9D_41AC_A59E_4DD19821C3A6#595588, COL_F36F08A6_928E_400F_B138_61F9B8D28AF3#595589, COL_A213E432_2691_4225_8DF4_C45A67AF4D9C#595590, COL_E3EB948B_0B85_4F37_970A_DD334B343EE2#595591, COL_77534C40_F008_4F9B_99A1_4982451B7A24#595592, COL_AF30678A_46A6_422E_838A_452D36B65FC1#595593, COL_29EA226E_C020_4D1F_A8DC_11FA4AB16409#595594, COL_C3DFC75D_DBFD_47F3_B940_59BD461CA3C0#595595, COL_7506CA9E_3DD1_4B12_8A2A_D2766532D59A#595596, COL_64235A62_C014_4D54_98DA_329A3C835EDA#595597, COL_76B3E933_F01E_4379_9153_B0E76D1633B5#595598, COL_9AE6D4D7_A126_4880_B33C_1337A4899A8C#595599, COL_9A5C81F5_9A6A_450B_AEBB_DB3516344104#595600, COL_066BC6D4_55AA_434A_8BD9_1D16816DDDDA#595601, COL_22D6710B_B7B5_4729_9BCB_202027CB0BD4#595602, COL_6102ADDE_08E8_4710_9AD0_D2CA02BC21DE#595603, COL_4A1DE469_43EB_4CAC_9134_3E477437431A#595604, COL_7666BE37_7FEC_476C_B19D_F98892962E5D#595605, COL_0BAF376F_F7D0_45AE_AEF9_8E19B504594E#595606, COL_554D78B0_EA21_483D_B574_547426ADB482#595607, COL_0B066C93_809D_4EB0_8ADF_3636D7B76593#595608, COL_EB753D17_130C_4979_986B_D18FFF9DD40A#595609, COL_0A7B71F1_4A2E_4EB3_A94C_939DCDA503B9#595610, ... 32 more fields]

SortMergeJoin [COL_F36F08A6_928E_400F_B138_61F9B8D28AF3#595589], [06_COMPILATION__226005_COL_A2516838_D999_49FB_A245_E9F9B72D742A#595725], LeftOuter

WholeStageCodegen (5)

Sort [COL_F36F08A6_928E_400F_B138_61F9B8D28AF3#595589 ASC NULLS FIRST], false, 0

WholeStageCodegen (3)

Exchange hashpartitioning(COL_F36F08A6_928E_400F_B138_61F9B8D28AF3#595589, 10), ENSURE_REQUIREMENTS, [plan_id=368062]

Project [COL_4ECA949F_2DA4_41C5_80E1_520DEFC8D1EA#595129 AS COL_497B3BF1_A9CE_4411_8889_2F0461FEE049#595587, COL_F522EF71_EF5D_46C0_B0EC_B3EB638B97F7#595130 AS COL_8DCB3027_3C9D_41AC_A59E_4DD19821C3A6#595588, COL_CEFA2472_1E3F_469C_9633_864540C40AD9#595131 AS COL_F36F08A6_928E_400F_B138_61F9B8D28AF3#595589, COL_1DDA21A4_0127_416B_A5DB_7EDD9CC61B56#595132 AS COL_A213E432_2691_4225_8DF4_C45A67AF4D9C#595590, COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#595133 AS COL_E3EB948B_0B85_4F37_970A_DD334B343EE2#595591, COL_0521CAB9_7617_4F31_948E_95DCA16387D7#595134 AS COL_77534C40_F008_4F9B_99A1_4982451B7A24#595592, COL_1DACB81E_AFA5_4BB8_83D7_57DE8B8062B7#595135 AS COL_AF30678A_46A6_422E_838A_452D36B65FC1#595593, COL_9262BBED_C393_416D_B38C_8F1458965BA7#595136 AS COL_29EA226E_C020_4D1F_A8DC_11FA4AB16409#595594, COL_F76265AB_8748_4114_92B4_00E37DE25D34#595137 AS COL_C3DFC75D_DBFD_47F3_B940_59BD461CA3C0#595595, COL_96E2282E_0771_460E_8BDB_D11261BD9020#595138 AS COL_7506CA9E_3DD1_4B12_8A2A_D2766532D59A#595596, COL_12028397_66B1_4E3C_BBDB_64537606E7DE#595139 AS COL_64235A62_C014_4D54_98DA_329A3C835EDA#595597, COL_580D5890_2839_4108_A636_8E25F97E50E0#595140 AS COL_76B3E933_F01E_4379_9153_B0E76D1633B5#595598, COL_3AFB6BB7_7AA1_4D16_AE24_4CB203A67B51#595141 AS COL_9AE6D4D7_A126_4880_B33C_1337A4899A8C#595599, COL_2C09E3B7_4086_45D3_8676_F1D58494C2DD#595142 AS COL_9A5C81F5_9A6A_450B_AEBB_DB3516344104#595600, COL_4473F770_A575_4100_97F6_8190F900749A#595143 AS COL_066BC6D4_55AA_434A_8BD9_1D16816DDDDA#595601, COL_715B3479_EAD2_422C_BF5C_7B020197D946#595144 AS COL_22D6710B_B7B5_4729_9BCB_202027CB0BD4#595602, COL_B41952EB_DE3F_4899_8A04_46EF55D519D3#595145 AS COL_6102ADDE_08E8_4710_9AD0_D2CA02BC21DE#595603, COL_13C7079E_53C2_4945_BB83_A9CBB5596CA7#595146 AS COL_4A1DE469_43EB_4CAC_9134_3E477437431A#595604, COL_1DD27485_A759_457B_BE67_EC6813E5F6C7#595147 AS COL_7666BE37_7FEC_476C_B19D_F98892962E5D#595605, COL_5F21C9DE_C72B_4C4D_A042_7C2B1C8E43BD#595148 AS COL_0BAF376F_F7D0_45AE_AEF9_8E19B504594E#595606, COL_97360DFB_D20B_4DFF_A68A_57C41867D04E#595149 AS COL_554D78B0_EA21_483D_B574_547426ADB482#595607, COL_8F13405A_6271_4B4F_BE3D_AFBE0E624AFC#595150 AS COL_0B066C93_809D_4EB0_8ADF_3636D7B76593#595608, COL_390B6626_6008_4E32_942E_6ED08B69626F#595151 AS COL_EB753D17_130C_4979_986B_D18FFF9DD40A#595609, COL_CD30424F_E1B5_4038_9F6F_A6119868B45C#595152 AS COL_0A7B71F1_4A2E_4EB3_A94C_939DCDA503B9#595610, ... 29 more fields]

ColumnarToRow

WholeStageCodegen (1)

FileScan parquet [COL_4ECA949F_2DA4_41C5_80E1_520DEFC8D1EA#595129,COL_F522EF71_EF5D_46C0_B0EC_B3EB638B97F7#595130,COL_CEFA2472_1E3F_469C_9633_864540C40AD9#595131,COL_1DDA21A4_0127_416B_A5DB_7EDD9CC61B56#595132,COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#595133,COL_0521CAB9_7617_4F31_948E_95DCA16387D7#595134,COL_1DACB81E_AFA5_4BB8_83D7_57DE8B8062B7#595135,COL_9262BBED_C393_416D_B38C_8F1458965BA7#595136,COL_F76265AB_8748_4114_92B4_00E37DE25D34#595137,COL_96E2282E_0771_460E_8BDB_D11261BD9020#595138,COL_12028397_66B1_4E3C_BBDB_64537606E7DE#595139,COL_580D5890_2839_4108_A636_8E25F97E50E0#595140,COL_3AFB6BB7_7AA1_4D16_AE24_4CB203A67B51#595141,COL_2C09E3B7_4086_45D3_8676_F1D58494C2DD#595142,COL_4473F770_A575_4100_97F6_8190F900749A#595143,COL_715B3479_EAD2_422C_BF5C_7B020197D946#595144,COL_B41952EB_DE3F_4899_8A04_46EF55D519D3#595145,COL_13C7079E_53C2_4945_BB83_A9CBB5596CA7#595146,COL_1DD27485_A759_457B_BE67_EC6813E5F6C7#595147,COL_5F21C9DE_C72B_4C4D_A042_7C2B1C8E43BD#595148,COL_97360DFB_D20B_4DFF_A68A_57C41867D04E#595149,COL_8F13405A_6271_4B4F_BE3D_AFBE0E624AFC#595150,COL_390B6626_6008_4E32_942E_6ED08B69626F#595151,COL_CD30424F_E1B5_4038_9F6F_A6119868B45C#595152,... 29 more fields] Batched: true, DataFilters: [], Format: Parquet, Location: InMemoryFileIndex(1 paths)[file:/data/output/cache/parquet/datablock/02_A_ELIGIBLE_225697], PartitionFilters: [], PushedFilters: [], ReadSchema: struct<COL_4ECA949F_2DA4_41C5_80E1_520DEFC8D1EA:string,COL_F522EF71_EF5D_46C0_B0EC_B3EB638B97F7:s...

Sort [06_COMPILATION__226005_COL_A2516838_D999_49FB_A245_E9F9B72D742A#595725 ASC NULLS FIRST], false, 0

WholeStageCodegen (4)

Exchange hashpartitioning(06_COMPILATION__226005_COL_A2516838_D999_49FB_A245_E9F9B72D742A#595725, 10), ENSURE_REQUIREMENTS, [plan_id=368088]

Project [COL_E38AB62F_E896_4A72_BE7E_515F8BC641C6#595246 AS 06_COMPILATION__226005_COL_E38AB62F_E896_4A72_BE7E_515F8BC641C6#595721, COL_A2516838_D999_49FB_A245_E9F9B72D742A#595250 AS 06_COMPILATION__226005_COL_A2516838_D999_49FB_A245_E9F9B72D742A#595725, COL_8EA5D1BB_B903_4AA6_811C_01F4D36D9299#595251 AS 06_COMPILATION__226005_COL_8EA5D1BB_B903_4AA6_811C_01F4D36D9299#595726]

Filter isnotnull(COL_A2516838_D999_49FB_A245_E9F9B72D742A#595250)

ColumnarToRow

WholeStageCodegen (2)

FileScan parquet [COL_E38AB62F_E896_4A72_BE7E_515F8BC641C6#595246,COL_A2516838_D999_49FB_A245_E9F9B72D742A#595250,COL_8EA5D1BB_B903_4AA6_811C_01F4D36D9299#595251] Batched: true, DataFilters: [isnotnull(COL_A2516838_D999_49FB_A245_E9F9B72D742A#595250)], Format: Parquet, Location: InMemoryFileIndex(1 paths)[file:/data/output/cache/parquet/datablock/06_COMPILATION__226005], PartitionFilters: [], PushedFilters: [IsNotNull(COL_A2516838_D999_49FB_A245_E9F9B72D742A)], ReadSchema: struct<COL_E38AB62F_E896_4A72_BE7E_515F8BC641C6:double,COL_A2516838_D999_49FB_A245_E9F9B72D742A:i...

Details

== Physical Plan ==
AdaptiveSparkPlan (29)
+- == Final Plan ==
   Execute InsertIntoHadoopFsRelationCommand (17)
   +- WriteFiles (16)
      +- * Project (15)
         +- * SortMergeJoin LeftOuter (14)
            :- * Sort (6)
            :  +- ShuffleQueryStage (5), Statistics(sizeInBytes=64.1 MiB, rowCount=5.68E+4)
            :     +- Exchange (4)
            :        +- * Project (3)
            :           +- * ColumnarToRow (2)
            :              +- Scan parquet  (1)
            +- * Sort (13)
               +- ShuffleQueryStage (12), Statistics(sizeInBytes=2.7 KiB, rowCount=85)
                  +- Exchange (11)
                     +- * Project (10)
                        +- * Filter (9)
                           +- * ColumnarToRow (8)
                              +- Scan parquet  (7)
+- == Initial Plan ==
   Execute InsertIntoHadoopFsRelationCommand (28)
   +- WriteFiles (27)
      +- Project (26)
         +- SortMergeJoin LeftOuter (25)
            :- Sort (20)
            :  +- Exchange (19)
            :     +- Project (18)
            :        +- Scan parquet  (1)
            +- Sort (24)
               +- Exchange (23)
                  +- Project (22)
                     +- Filter (21)
                        +- Scan parquet  (7)


(1) Scan parquet 
Output [53]: [COL_4ECA949F_2DA4_41C5_80E1_520DEFC8D1EA#595129, COL_F522EF71_EF5D_46C0_B0EC_B3EB638B97F7#595130, COL_CEFA2472_1E3F_469C_9633_864540C40AD9#595131, COL_1DDA21A4_0127_416B_A5DB_7EDD9CC61B56#595132, COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#595133, COL_0521CAB9_7617_4F31_948E_95DCA16387D7#595134, COL_1DACB81E_AFA5_4BB8_83D7_57DE8B8062B7#595135, COL_9262BBED_C393_416D_B38C_8F1458965BA7#595136, COL_F76265AB_8748_4114_92B4_00E37DE25D34#595137, COL_96E2282E_0771_460E_8BDB_D11261BD9020#595138, COL_12028397_66B1_4E3C_BBDB_64537606E7DE#595139, COL_580D5890_2839_4108_A636_8E25F97E50E0#595140, COL_3AFB6BB7_7AA1_4D16_AE24_4CB203A67B51#595141, COL_2C09E3B7_4086_45D3_8676_F1D58494C2DD#595142, COL_4473F770_A575_4100_97F6_8190F900749A#595143, COL_715B3479_EAD2_422C_BF5C_7B020197D946#595144, COL_B41952EB_DE3F_4899_8A04_46EF55D519D3#595145, COL_13C7079E_53C2_4945_BB83_A9CBB5596CA7#595146, COL_1DD27485_A759_457B_BE67_EC6813E5F6C7#595147, COL_5F21C9DE_C72B_4C4D_A042_7C2B1C8E43BD#595148, COL_97360DFB_D20B_4DFF_A68A_57C41867D04E#595149, COL_8F13405A_6271_4B4F_BE3D_AFBE0E624AFC#595150, COL_390B6626_6008_4E32_942E_6ED08B69626F#595151, COL_CD30424F_E1B5_4038_9F6F_A6119868B45C#595152, COL_2B738BBE_CFA2_41EB_9490_76129BDDA7D3#595153, COL_869EE117_A1AF_4643_9C63_B2E044E76011#595154, COL_2DEF4579_4198_4381_9794_0850D509C4D9#595155, COL_28DD75A8_B9B0_41E0_B8DE_4C1D788339EF#595156, COL_5143601C_5C8F_46DA_8653_3EFEB2EE859D#595157, COL_603BA3E4_9B75_44D5_A914_615FAE0C5436#595158, COL_50D051CB_B5A3_4A22_99CF_B636DE0B08A4#595159, COL_B2D69078_23A7_4B36_BBF2_3F9C29840464#595160, COL_47A73BC1_4566_45A9_8162_7B6B9E438C8D#595161, COL_91F5095A_FAAE_4325_81BC_62ABDD788E8D#595162, COL_394590C1_A817_4CDB_80AC_456AA6E27DEA#595163, COL_011EF34A_6883_4296_BBBF_AC60A68C84DD#595164, COL_C1F37338_7743_4434_879A_FF32C1BC5112#595165, COL_FAEC3B31_0447_4E4B_B8EC_83794AF975DD#595166, COL_FF5E7CF3_75CA_45FF_AA0E_98474CEB50C2#595167, COL_6B0E2B89_AC1D_411B_A0AB_19B2CEF8CFC9#595168, COL_D7508510_B4D7_44C5_A063_A2132B6EF08A#595169, COL_EAA75683_8CB4_4075_AA4A_FACAF98EBD6E#595170, COL_B8D0B7A4_71CB_4406_88C1_4791F02E29EF#595171, COL_AA499A88_B893_47E4_99C5_0EB9F6D69842#595172, COL_95383EBC_3648_4E94_9C53_D311092BF5F4#595173, COL_7DC2A78A_5ED5_4908_AC94_0885B83B98CD#595174, COL_383EDE50_7CF9_4E24_A70F_BA7CD5C9D6BA#595175, COL_585F8C49_925B_4809_B445_C6A91423BA50#595176, COL_E7D4B3BC_F96E_4431_BC95_1D1CCE75D846#595177, COL_B057EBBF_57E7_449C_9DE3_CD56F041B86B#595178, COL_B8D74F46_C755_4417_9E18_FAA760CD8457#595179, COL_51335C75_C8A9_4932_8985_BA9E68B80F3A#595180, COL_03AE34A5_99F1_4525_9BD2_BF7BAFE47F5C#595181]
Batched: true
Location: InMemoryFileIndex [file:/data/output/cache/parquet/datablock/02_A_ELIGIBLE_225697]
ReadSchema: struct<COL_4ECA949F_2DA4_41C5_80E1_520DEFC8D1EA:string,COL_F522EF71_EF5D_46C0_B0EC_B3EB638B97F7:string,COL_CEFA2472_1E3F_469C_9633_864540C40AD9:int,COL_1DDA21A4_0127_416B_A5DB_7EDD9CC61B56:string,COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB:string,COL_0521CAB9_7617_4F31_948E_95DCA16387D7:string,COL_1DACB81E_AFA5_4BB8_83D7_57DE8B8062B7:string,COL_9262BBED_C393_416D_B38C_8F1458965BA7:string,COL_F76265AB_8748_4114_92B4_00E37DE25D34:string,COL_96E2282E_0771_460E_8BDB_D11261BD9020:string,COL_12028397_66B1_4E3C_BBDB_64537606E7DE:string,COL_580D5890_2839_4108_A636_8E25F97E50E0:double,COL_3AFB6BB7_7AA1_4D16_AE24_4CB203A67B51:string,COL_2C09E3B7_4086_45D3_8676_F1D58494C2DD:string,COL_4473F770_A575_4100_97F6_8190F900749A:string,COL_715B3479_EAD2_422C_BF5C_7B020197D946:string,COL_B41952EB_DE3F_4899_8A04_46EF55D519D3:string,COL_13C7079E_53C2_4945_BB83_A9CBB5596CA7:string,COL_1DD27485_A759_457B_BE67_EC6813E5F6C7:array<string>,COL_5F21C9DE_C72B_4C4D_A042_7C2B1C8E43BD:array<string>,COL_97360DFB_D20B_4DFF_A68A_57C41867D04E:double,COL_8F13405A_6271_4B4F_BE3D_AFBE0E624AFC:string,COL_390B6626_6008_4E32_942E_6ED08B69626F:string,COL_CD30424F_E1B5_4038_9F6F_A6119868B45C:string,COL_2B738BBE_CFA2_41EB_9490_76129BDDA7D3:string,COL_869EE117_A1AF_4643_9C63_B2E044E76011:string,COL_2DEF4579_4198_4381_9794_0850D509C4D9:string,COL_28DD75A8_B9B0_41E0_B8DE_4C1D788339EF:string,COL_5143601C_5C8F_46DA_8653_3EFEB2EE859D:string,COL_603BA3E4_9B75_44D5_A914_615FAE0C5436:string,COL_50D051CB_B5A3_4A22_99CF_B636DE0B08A4:string,COL_B2D69078_23A7_4B36_BBF2_3F9C29840464:string,COL_47A73BC1_4566_45A9_8162_7B6B9E438C8D:string,COL_91F5095A_FAAE_4325_81BC_62ABDD788E8D:string,COL_394590C1_A817_4CDB_80AC_456AA6E27DEA:string,COL_011EF34A_6883_4296_BBBF_AC60A68C84DD:string,COL_C1F37338_7743_4434_879A_FF32C1BC5112:string,COL_FAEC3B31_0447_4E4B_B8EC_83794AF975DD:string,COL_FF5E7CF3_75CA_45FF_AA0E_98474CEB50C2:string,COL_6B0E2B89_AC1D_411B_A0AB_19B2CEF8CFC9:string,COL_D7508510_B4D7_44C5_A063_A2132B6EF08A:array<string>,COL_EAA75683_8CB4_4075_AA4A_FACAF98EBD6E:string,COL_B8D0B7A4_71CB_4406_88C1_4791F02E29EF:array<string>,COL_AA499A88_B893_47E4_99C5_0EB9F6D69842:string,COL_95383EBC_3648_4E94_9C53_D311092BF5F4:array<string>,COL_7DC2A78A_5ED5_4908_AC94_0885B83B98CD:string,COL_383EDE50_7CF9_4E24_A70F_BA7CD5C9D6BA:string,COL_585F8C49_925B_4809_B445_C6A91423BA50:string,COL_E7D4B3BC_F96E_4431_BC95_1D1CCE75D846:int,COL_B057EBBF_57E7_449C_9DE3_CD56F041B86B:int,COL_B8D74F46_C755_4417_9E18_FAA760CD8457:int,COL_51335C75_C8A9_4932_8985_BA9E68B80F3A:int,COL_03AE34A5_99F1_4525_9BD2_BF7BAFE47F5C:int>

(2) ColumnarToRow [codegen id : 1]
Input [53]: [COL_4ECA949F_2DA4_41C5_80E1_520DEFC8D1EA#595129, COL_F522EF71_EF5D_46C0_B0EC_B3EB638B97F7#595130, COL_CEFA2472_1E3F_469C_9633_864540C40AD9#595131, COL_1DDA21A4_0127_416B_A5DB_7EDD9CC61B56#595132, COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#595133, COL_0521CAB9_7617_4F31_948E_95DCA16387D7#595134, COL_1DACB81E_AFA5_4BB8_83D7_57DE8B8062B7#595135, COL_9262BBED_C393_416D_B38C_8F1458965BA7#595136, COL_F76265AB_8748_4114_92B4_00E37DE25D34#595137, COL_96E2282E_0771_460E_8BDB_D11261BD9020#595138, COL_12028397_66B1_4E3C_BBDB_64537606E7DE#595139, COL_580D5890_2839_4108_A636_8E25F97E50E0#595140, COL_3AFB6BB7_7AA1_4D16_AE24_4CB203A67B51#595141, COL_2C09E3B7_4086_45D3_8676_F1D58494C2DD#595142, COL_4473F770_A575_4100_97F6_8190F900749A#595143, COL_715B3479_EAD2_422C_BF5C_7B020197D946#595144, COL_B41952EB_DE3F_4899_8A04_46EF55D519D3#595145, COL_13C7079E_53C2_4945_BB83_A9CBB5596CA7#595146, COL_1DD27485_A759_457B_BE67_EC6813E5F6C7#595147, COL_5F21C9DE_C72B_4C4D_A042_7C2B1C8E43BD#595148, COL_97360DFB_D20B_4DFF_A68A_57C41867D04E#595149, COL_8F13405A_6271_4B4F_BE3D_AFBE0E624AFC#595150, COL_390B6626_6008_4E32_942E_6ED08B69626F#595151, COL_CD30424F_E1B5_4038_9F6F_A6119868B45C#595152, COL_2B738BBE_CFA2_41EB_9490_76129BDDA7D3#595153, COL_869EE117_A1AF_4643_9C63_B2E044E76011#595154, COL_2DEF4579_4198_4381_9794_0850D509C4D9#595155, COL_28DD75A8_B9B0_41E0_B8DE_4C1D788339EF#595156, COL_5143601C_5C8F_46DA_8653_3EFEB2EE859D#595157, COL_603BA3E4_9B75_44D5_A914_615FAE0C5436#595158, COL_50D051CB_B5A3_4A22_99CF_B636DE0B08A4#595159, COL_B2D69078_23A7_4B36_BBF2_3F9C29840464#595160, COL_47A73BC1_4566_45A9_8162_7B6B9E438C8D#595161, COL_91F5095A_FAAE_4325_81BC_62ABDD788E8D#595162, COL_394590C1_A817_4CDB_80AC_456AA6E27DEA#595163, COL_011EF34A_6883_4296_BBBF_AC60A68C84DD#595164, COL_C1F37338_7743_4434_879A_FF32C1BC5112#595165, COL_FAEC3B31_0447_4E4B_B8EC_83794AF975DD#595166, COL_FF5E7CF3_75CA_45FF_AA0E_98474CEB50C2#595167, COL_6B0E2B89_AC1D_411B_A0AB_19B2CEF8CFC9#595168, COL_D7508510_B4D7_44C5_A063_A2132B6EF08A#595169, COL_EAA75683_8CB4_4075_AA4A_FACAF98EBD6E#595170, COL_B8D0B7A4_71CB_4406_88C1_4791F02E29EF#595171, COL_AA499A88_B893_47E4_99C5_0EB9F6D69842#595172, COL_95383EBC_3648_4E94_9C53_D311092BF5F4#595173, COL_7DC2A78A_5ED5_4908_AC94_0885B83B98CD#595174, COL_383EDE50_7CF9_4E24_A70F_BA7CD5C9D6BA#595175, COL_585F8C49_925B_4809_B445_C6A91423BA50#595176, COL_E7D4B3BC_F96E_4431_BC95_1D1CCE75D846#595177, COL_B057EBBF_57E7_449C_9DE3_CD56F041B86B#595178, COL_B8D74F46_C755_4417_9E18_FAA760CD8457#595179, COL_51335C75_C8A9_4932_8985_BA9E68B80F3A#595180, COL_03AE34A5_99F1_4525_9BD2_BF7BAFE47F5C#595181]

(3) Project [codegen id : 1]
Output [53]: [COL_4ECA949F_2DA4_41C5_80E1_520DEFC8D1EA#595129 AS COL_497B3BF1_A9CE_4411_8889_2F0461FEE049#595587, COL_F522EF71_EF5D_46C0_B0EC_B3EB638B97F7#595130 AS COL_8DCB3027_3C9D_41AC_A59E_4DD19821C3A6#595588, COL_CEFA2472_1E3F_469C_9633_864540C40AD9#595131 AS COL_F36F08A6_928E_400F_B138_61F9B8D28AF3#595589, COL_1DDA21A4_0127_416B_A5DB_7EDD9CC61B56#595132 AS COL_A213E432_2691_4225_8DF4_C45A67AF4D9C#595590, COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#595133 AS COL_E3EB948B_0B85_4F37_970A_DD334B343EE2#595591, COL_0521CAB9_7617_4F31_948E_95DCA16387D7#595134 AS COL_77534C40_F008_4F9B_99A1_4982451B7A24#595592, COL_1DACB81E_AFA5_4BB8_83D7_57DE8B8062B7#595135 AS COL_AF30678A_46A6_422E_838A_452D36B65FC1#595593, COL_9262BBED_C393_416D_B38C_8F1458965BA7#595136 AS COL_29EA226E_C020_4D1F_A8DC_11FA4AB16409#595594, COL_F76265AB_8748_4114_92B4_00E37DE25D34#595137 AS COL_C3DFC75D_DBFD_47F3_B940_59BD461CA3C0#595595, COL_96E2282E_0771_460E_8BDB_D11261BD9020#595138 AS COL_7506CA9E_3DD1_4B12_8A2A_D2766532D59A#595596, COL_12028397_66B1_4E3C_BBDB_64537606E7DE#595139 AS COL_64235A62_C014_4D54_98DA_329A3C835EDA#595597, COL_580D5890_2839_4108_A636_8E25F97E50E0#595140 AS COL_76B3E933_F01E_4379_9153_B0E76D1633B5#595598, COL_3AFB6BB7_7AA1_4D16_AE24_4CB203A67B51#595141 AS COL_9AE6D4D7_A126_4880_B33C_1337A4899A8C#595599, COL_2C09E3B7_4086_45D3_8676_F1D58494C2DD#595142 AS COL_9A5C81F5_9A6A_450B_AEBB_DB3516344104#595600, COL_4473F770_A575_4100_97F6_8190F900749A#595143 AS COL_066BC6D4_55AA_434A_8BD9_1D16816DDDDA#595601, COL_715B3479_EAD2_422C_BF5C_7B020197D946#595144 AS COL_22D6710B_B7B5_4729_9BCB_202027CB0BD4#595602, COL_B41952EB_DE3F_4899_8A04_46EF55D519D3#595145 AS COL_6102ADDE_08E8_4710_9AD0_D2CA02BC21DE#595603, COL_13C7079E_53C2_4945_BB83_A9CBB5596CA7#595146 AS COL_4A1DE469_43EB_4CAC_9134_3E477437431A#595604, COL_1DD27485_A759_457B_BE67_EC6813E5F6C7#595147 AS COL_7666BE37_7FEC_476C_B19D_F98892962E5D#595605, COL_5F21C9DE_C72B_4C4D_A042_7C2B1C8E43BD#595148 AS COL_0BAF376F_F7D0_45AE_AEF9_8E19B504594E#595606, COL_97360DFB_D20B_4DFF_A68A_57C41867D04E#595149 AS COL_554D78B0_EA21_483D_B574_547426ADB482#595607, COL_8F13405A_6271_4B4F_BE3D_AFBE0E624AFC#595150 AS COL_0B066C93_809D_4EB0_8ADF_3636D7B76593#595608, COL_390B6626_6008_4E32_942E_6ED08B69626F#595151 AS COL_EB753D17_130C_4979_986B_D18FFF9DD40A#595609, COL_CD30424F_E1B5_4038_9F6F_A6119868B45C#595152 AS COL_0A7B71F1_4A2E_4EB3_A94C_939DCDA503B9#595610, COL_2B738BBE_CFA2_41EB_9490_76129BDDA7D3#595153 AS COL_3942BD61_7E90_4C5E_9240_75A61CE57789#595611, COL_869EE117_A1AF_4643_9C63_B2E044E76011#595154 AS COL_10C0E375_56E4_415A_AF3C_59B02B4E8408#595612, COL_2DEF4579_4198_4381_9794_0850D509C4D9#595155 AS COL_265D3814_0F5F_49EC_BEAE_386902F30D16#595613, COL_28DD75A8_B9B0_41E0_B8DE_4C1D788339EF#595156 AS COL_D26072D1_60A6_4A96_B906_BE91ACB59614#595614, COL_5143601C_5C8F_46DA_8653_3EFEB2EE859D#595157 AS COL_22A9E0BF_52D7_4815_A42C_BA2F7EDBB3C0#595615, COL_603BA3E4_9B75_44D5_A914_615FAE0C5436#595158 AS COL_3D1D7AA8_1BB1_46F0_8501_CDDDFE0E78BA#595616, COL_50D051CB_B5A3_4A22_99CF_B636DE0B08A4#595159 AS COL_2B27FA6E_B24E_4B22_8ACC_F3D028A40856#595617, COL_B2D69078_23A7_4B36_BBF2_3F9C29840464#595160 AS COL_80238879_541A_4F44_92A5_9926F6B94DB8#595618, COL_47A73BC1_4566_45A9_8162_7B6B9E438C8D#595161 AS COL_621D957A_7A06_4745_964E_FE09BFFF8DB7#595619, COL_91F5095A_FAAE_4325_81BC_62ABDD788E8D#595162 AS COL_34B3B671_24B2_4686_8CB9_962569FCA41D#595620, COL_394590C1_A817_4CDB_80AC_456AA6E27DEA#595163 AS COL_4FDAA229_CCB9_46CF_9F7E_A744CF47F572#595621, COL_011EF34A_6883_4296_BBBF_AC60A68C84DD#595164 AS COL_275DF47E_340B_4E55_A9F4_EDCC14A9627D#595622, COL_C1F37338_7743_4434_879A_FF32C1BC5112#595165 AS COL_7E77AF73_752C_48EE_856C_5C920DEA334B#595623, COL_FAEC3B31_0447_4E4B_B8EC_83794AF975DD#595166 AS COL_EC7C9040_E9DF_4E9F_BA9E_A1A6A0233AF9#595624, COL_FF5E7CF3_75CA_45FF_AA0E_98474CEB50C2#595167 AS COL_21232554_8AE3_4294_9504_876AA3A8D672#595625, COL_6B0E2B89_AC1D_411B_A0AB_19B2CEF8CFC9#595168 AS COL_C0597E1D_6B5A_4F8B_9564_EE724FCB06A6#595626, COL_D7508510_B4D7_44C5_A063_A2132B6EF08A#595169 AS COL_8806DAD5_E7F9_4288_9EF7_33FF7C7ABBFD#595627, COL_EAA75683_8CB4_4075_AA4A_FACAF98EBD6E#595170 AS COL_5D701CFC_3360_465B_9BEE_24B4F9CA695B#595628, COL_B8D0B7A4_71CB_4406_88C1_4791F02E29EF#595171 AS COL_F0D25D20_CEE9_44DC_ADA4_FEB5CC21F368#595629, COL_AA499A88_B893_47E4_99C5_0EB9F6D69842#595172 AS COL_C18DDF33_5647_412B_B46F_605FB907BC20#595630, COL_95383EBC_3648_4E94_9C53_D311092BF5F4#595173 AS COL_CFBEFC28_3BE8_4A12_8520_4056414B51FB#595631, COL_7DC2A78A_5ED5_4908_AC94_0885B83B98CD#595174 AS COL_8E05E990_9DCD_4946_810B_5D660C48B128#595632, COL_383EDE50_7CF9_4E24_A70F_BA7CD5C9D6BA#595175 AS COL_C644CF67_72CA_452B_8B61_CFFAE6D90B0B#595633, COL_585F8C49_925B_4809_B445_C6A91423BA50#595176 AS COL_968995BF_0BEB_4F9D_AB7B_2F70009B0383#595634, COL_E7D4B3BC_F96E_4431_BC95_1D1CCE75D846#595177 AS COL_C931157E_CFBA_4535_B8F1_D3C29D1EFD77#595635, COL_B057EBBF_57E7_449C_9DE3_CD56F041B86B#595178 AS COL_1BB74F82_ECBC_4133_AF56_13121C73FA5D#595636, COL_B8D74F46_C755_4417_9E18_FAA760CD8457#595179 AS COL_77DF2687_0629_4378_B27F_E72E041D79EC#595637, COL_51335C75_C8A9_4932_8985_BA9E68B80F3A#595180 AS COL_BF828FB3_0BA8_4921_A6A5_07A65F79C8E0#595638, COL_03AE34A5_99F1_4525_9BD2_BF7BAFE47F5C#595181 AS COL_04822B1E_A0F2_4670_BDB2_507D07D8F3DE#595639]
Input [53]: [COL_4ECA949F_2DA4_41C5_80E1_520DEFC8D1EA#595129, COL_F522EF71_EF5D_46C0_B0EC_B3EB638B97F7#595130, COL_CEFA2472_1E3F_469C_9633_864540C40AD9#595131, COL_1DDA21A4_0127_416B_A5DB_7EDD9CC61B56#595132, COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#595133, COL_0521CAB9_7617_4F31_948E_95DCA16387D7#595134, COL_1DACB81E_AFA5_4BB8_83D7_57DE8B8062B7#595135, COL_9262BBED_C393_416D_B38C_8F1458965BA7#595136, COL_F76265AB_8748_4114_92B4_00E37DE25D34#595137, COL_96E2282E_0771_460E_8BDB_D11261BD9020#595138, COL_12028397_66B1_4E3C_BBDB_64537606E7DE#595139, COL_580D5890_2839_4108_A636_8E25F97E50E0#595140, COL_3AFB6BB7_7AA1_4D16_AE24_4CB203A67B51#595141, COL_2C09E3B7_4086_45D3_8676_F1D58494C2DD#595142, COL_4473F770_A575_4100_97F6_8190F900749A#595143, COL_715B3479_EAD2_422C_BF5C_7B020197D946#595144, COL_B41952EB_DE3F_4899_8A04_46EF55D519D3#595145, COL_13C7079E_53C2_4945_BB83_A9CBB5596CA7#595146, COL_1DD27485_A759_457B_BE67_EC6813E5F6C7#595147, COL_5F21C9DE_C72B_4C4D_A042_7C2B1C8E43BD#595148, COL_97360DFB_D20B_4DFF_A68A_57C41867D04E#595149, COL_8F13405A_6271_4B4F_BE3D_AFBE0E624AFC#595150, COL_390B6626_6008_4E32_942E_6ED08B69626F#595151, COL_CD30424F_E1B5_4038_9F6F_A6119868B45C#595152, COL_2B738BBE_CFA2_41EB_9490_76129BDDA7D3#595153, COL_869EE117_A1AF_4643_9C63_B2E044E76011#595154, COL_2DEF4579_4198_4381_9794_0850D509C4D9#595155, COL_28DD75A8_B9B0_41E0_B8DE_4C1D788339EF#595156, COL_5143601C_5C8F_46DA_8653_3EFEB2EE859D#595157, COL_603BA3E4_9B75_44D5_A914_615FAE0C5436#595158, COL_50D051CB_B5A3_4A22_99CF_B636DE0B08A4#595159, COL_B2D69078_23A7_4B36_BBF2_3F9C29840464#595160, COL_47A73BC1_4566_45A9_8162_7B6B9E438C8D#595161, COL_91F5095A_FAAE_4325_81BC_62ABDD788E8D#595162, COL_394590C1_A817_4CDB_80AC_456AA6E27DEA#595163, COL_011EF34A_6883_4296_BBBF_AC60A68C84DD#595164, COL_C1F37338_7743_4434_879A_FF32C1BC5112#595165, COL_FAEC3B31_0447_4E4B_B8EC_83794AF975DD#595166, COL_FF5E7CF3_75CA_45FF_AA0E_98474CEB50C2#595167, COL_6B0E2B89_AC1D_411B_A0AB_19B2CEF8CFC9#595168, COL_D7508510_B4D7_44C5_A063_A2132B6EF08A#595169, COL_EAA75683_8CB4_4075_AA4A_FACAF98EBD6E#595170, COL_B8D0B7A4_71CB_4406_88C1_4791F02E29EF#595171, COL_AA499A88_B893_47E4_99C5_0EB9F6D69842#595172, COL_95383EBC_3648_4E94_9C53_D311092BF5F4#595173, COL_7DC2A78A_5ED5_4908_AC94_0885B83B98CD#595174, COL_383EDE50_7CF9_4E24_A70F_BA7CD5C9D6BA#595175, COL_585F8C49_925B_4809_B445_C6A91423BA50#595176, COL_E7D4B3BC_F96E_4431_BC95_1D1CCE75D846#595177, COL_B057EBBF_57E7_449C_9DE3_CD56F041B86B#595178, COL_B8D74F46_C755_4417_9E18_FAA760CD8457#595179, COL_51335C75_C8A9_4932_8985_BA9E68B80F3A#595180, COL_03AE34A5_99F1_4525_9BD2_BF7BAFE47F5C#595181]

(4) Exchange
Input [53]: [COL_497B3BF1_A9CE_4411_8889_2F0461FEE049#595587, COL_8DCB3027_3C9D_41AC_A59E_4DD19821C3A6#595588, COL_F36F08A6_928E_400F_B138_61F9B8D28AF3#595589, COL_A213E432_2691_4225_8DF4_C45A67AF4D9C#595590, COL_E3EB948B_0B85_4F37_970A_DD334B343EE2#595591, COL_77534C40_F008_4F9B_99A1_4982451B7A24#595592, COL_AF30678A_46A6_422E_838A_452D36B65FC1#595593, COL_29EA226E_C020_4D1F_A8DC_11FA4AB16409#595594, COL_C3DFC75D_DBFD_47F3_B940_59BD461CA3C0#595595, COL_7506CA9E_3DD1_4B12_8A2A_D2766532D59A#595596, COL_64235A62_C014_4D54_98DA_329A3C835EDA#595597, COL_76B3E933_F01E_4379_9153_B0E76D1633B5#595598, COL_9AE6D4D7_A126_4880_B33C_1337A4899A8C#595599, COL_9A5C81F5_9A6A_450B_AEBB_DB3516344104#595600, COL_066BC6D4_55AA_434A_8BD9_1D16816DDDDA#595601, COL_22D6710B_B7B5_4729_9BCB_202027CB0BD4#595602, COL_6102ADDE_08E8_4710_9AD0_D2CA02BC21DE#595603, COL_4A1DE469_43EB_4CAC_9134_3E477437431A#595604, COL_7666BE37_7FEC_476C_B19D_F98892962E5D#595605, COL_0BAF376F_F7D0_45AE_AEF9_8E19B504594E#595606, COL_554D78B0_EA21_483D_B574_547426ADB482#595607, COL_0B066C93_809D_4EB0_8ADF_3636D7B76593#595608, COL_EB753D17_130C_4979_986B_D18FFF9DD40A#595609, COL_0A7B71F1_4A2E_4EB3_A94C_939DCDA503B9#595610, COL_3942BD61_7E90_4C5E_9240_75A61CE57789#595611, COL_10C0E375_56E4_415A_AF3C_59B02B4E8408#595612, COL_265D3814_0F5F_49EC_BEAE_386902F30D16#595613, COL_D26072D1_60A6_4A96_B906_BE91ACB59614#595614, COL_22A9E0BF_52D7_4815_A42C_BA2F7EDBB3C0#595615, COL_3D1D7AA8_1BB1_46F0_8501_CDDDFE0E78BA#595616, COL_2B27FA6E_B24E_4B22_8ACC_F3D028A40856#595617, COL_80238879_541A_4F44_92A5_9926F6B94DB8#595618, COL_621D957A_7A06_4745_964E_FE09BFFF8DB7#595619, COL_34B3B671_24B2_4686_8CB9_962569FCA41D#595620, COL_4FDAA229_CCB9_46CF_9F7E_A744CF47F572#595621, COL_275DF47E_340B_4E55_A9F4_EDCC14A9627D#595622, COL_7E77AF73_752C_48EE_856C_5C920DEA334B#595623, COL_EC7C9040_E9DF_4E9F_BA9E_A1A6A0233AF9#595624, COL_21232554_8AE3_4294_9504_876AA3A8D672#595625, COL_C0597E1D_6B5A_4F8B_9564_EE724FCB06A6#595626, COL_8806DAD5_E7F9_4288_9EF7_33FF7C7ABBFD#595627, COL_5D701CFC_3360_465B_9BEE_24B4F9CA695B#595628, COL_F0D25D20_CEE9_44DC_ADA4_FEB5CC21F368#595629, COL_C18DDF33_5647_412B_B46F_605FB907BC20#595630, COL_CFBEFC28_3BE8_4A12_8520_4056414B51FB#595631, COL_8E05E990_9DCD_4946_810B_5D660C48B128#595632, COL_C644CF67_72CA_452B_8B61_CFFAE6D90B0B#595633, COL_968995BF_0BEB_4F9D_AB7B_2F70009B0383#595634, COL_C931157E_CFBA_4535_B8F1_D3C29D1EFD77#595635, COL_1BB74F82_ECBC_4133_AF56_13121C73FA5D#595636, COL_77DF2687_0629_4378_B27F_E72E041D79EC#595637, COL_BF828FB3_0BA8_4921_A6A5_07A65F79C8E0#595638, COL_04822B1E_A0F2_4670_BDB2_507D07D8F3DE#595639]
Arguments: hashpartitioning(COL_F36F08A6_928E_400F_B138_61F9B8D28AF3#595589, 10), ENSURE_REQUIREMENTS, [plan_id=368062]

(5) ShuffleQueryStage
Output [53]: [COL_497B3BF1_A9CE_4411_8889_2F0461FEE049#595587, COL_8DCB3027_3C9D_41AC_A59E_4DD19821C3A6#595588, COL_F36F08A6_928E_400F_B138_61F9B8D28AF3#595589, COL_A213E432_2691_4225_8DF4_C45A67AF4D9C#595590, COL_E3EB948B_0B85_4F37_970A_DD334B343EE2#595591, COL_77534C40_F008_4F9B_99A1_4982451B7A24#595592, COL_AF30678A_46A6_422E_838A_452D36B65FC1#595593, COL_29EA226E_C020_4D1F_A8DC_11FA4AB16409#595594, COL_C3DFC75D_DBFD_47F3_B940_59BD461CA3C0#595595, COL_7506CA9E_3DD1_4B12_8A2A_D2766532D59A#595596, COL_64235A62_C014_4D54_98DA_329A3C835EDA#595597, COL_76B3E933_F01E_4379_9153_B0E76D1633B5#595598, COL_9AE6D4D7_A126_4880_B33C_1337A4899A8C#595599, COL_9A5C81F5_9A6A_450B_AEBB_DB3516344104#595600, COL_066BC6D4_55AA_434A_8BD9_1D16816DDDDA#595601, COL_22D6710B_B7B5_4729_9BCB_202027CB0BD4#595602, COL_6102ADDE_08E8_4710_9AD0_D2CA02BC21DE#595603, COL_4A1DE469_43EB_4CAC_9134_3E477437431A#595604, COL_7666BE37_7FEC_476C_B19D_F98892962E5D#595605, COL_0BAF376F_F7D0_45AE_AEF9_8E19B504594E#595606, COL_554D78B0_EA21_483D_B574_547426ADB482#595607, COL_0B066C93_809D_4EB0_8ADF_3636D7B76593#595608, COL_EB753D17_130C_4979_986B_D18FFF9DD40A#595609, COL_0A7B71F1_4A2E_4EB3_A94C_939DCDA503B9#595610, COL_3942BD61_7E90_4C5E_9240_75A61CE57789#595611, COL_10C0E375_56E4_415A_AF3C_59B02B4E8408#595612, COL_265D3814_0F5F_49EC_BEAE_386902F30D16#595613, COL_D26072D1_60A6_4A96_B906_BE91ACB59614#595614, COL_22A9E0BF_52D7_4815_A42C_BA2F7EDBB3C0#595615, COL_3D1D7AA8_1BB1_46F0_8501_CDDDFE0E78BA#595616, COL_2B27FA6E_B24E_4B22_8ACC_F3D028A40856#595617, COL_80238879_541A_4F44_92A5_9926F6B94DB8#595618, COL_621D957A_7A06_4745_964E_FE09BFFF8DB7#595619, COL_34B3B671_24B2_4686_8CB9_962569FCA41D#595620, COL_4FDAA229_CCB9_46CF_9F7E_A744CF47F572#595621, COL_275DF47E_340B_4E55_A9F4_EDCC14A9627D#595622, COL_7E77AF73_752C_48EE_856C_5C920DEA334B#595623, COL_EC7C9040_E9DF_4E9F_BA9E_A1A6A0233AF9#595624, COL_21232554_8AE3_4294_9504_876AA3A8D672#595625, COL_C0597E1D_6B5A_4F8B_9564_EE724FCB06A6#595626, COL_8806DAD5_E7F9_4288_9EF7_33FF7C7ABBFD#595627, COL_5D701CFC_3360_465B_9BEE_24B4F9CA695B#595628, COL_F0D25D20_CEE9_44DC_ADA4_FEB5CC21F368#595629, COL_C18DDF33_5647_412B_B46F_605FB907BC20#595630, COL_CFBEFC28_3BE8_4A12_8520_4056414B51FB#595631, COL_8E05E990_9DCD_4946_810B_5D660C48B128#595632, COL_C644CF67_72CA_452B_8B61_CFFAE6D90B0B#595633, COL_968995BF_0BEB_4F9D_AB7B_2F70009B0383#595634, COL_C931157E_CFBA_4535_B8F1_D3C29D1EFD77#595635, COL_1BB74F82_ECBC_4133_AF56_13121C73FA5D#595636, COL_77DF2687_0629_4378_B27F_E72E041D79EC#595637, COL_BF828FB3_0BA8_4921_A6A5_07A65F79C8E0#595638, COL_04822B1E_A0F2_4670_BDB2_507D07D8F3DE#595639]
Arguments: 0

(6) Sort [codegen id : 3]
Input [53]: [COL_497B3BF1_A9CE_4411_8889_2F0461FEE049#595587, COL_8DCB3027_3C9D_41AC_A59E_4DD19821C3A6#595588, COL_F36F08A6_928E_400F_B138_61F9B8D28AF3#595589, COL_A213E432_2691_4225_8DF4_C45A67AF4D9C#595590, COL_E3EB948B_0B85_4F37_970A_DD334B343EE2#595591, COL_77534C40_F008_4F9B_99A1_4982451B7A24#595592, COL_AF30678A_46A6_422E_838A_452D36B65FC1#595593, COL_29EA226E_C020_4D1F_A8DC_11FA4AB16409#595594, COL_C3DFC75D_DBFD_47F3_B940_59BD461CA3C0#595595, COL_7506CA9E_3DD1_4B12_8A2A_D2766532D59A#595596, COL_64235A62_C014_4D54_98DA_329A3C835EDA#595597, COL_76B3E933_F01E_4379_9153_B0E76D1633B5#595598, COL_9AE6D4D7_A126_4880_B33C_1337A4899A8C#595599, COL_9A5C81F5_9A6A_450B_AEBB_DB3516344104#595600, COL_066BC6D4_55AA_434A_8BD9_1D16816DDDDA#595601, COL_22D6710B_B7B5_4729_9BCB_202027CB0BD4#595602, COL_6102ADDE_08E8_4710_9AD0_D2CA02BC21DE#595603, COL_4A1DE469_43EB_4CAC_9134_3E477437431A#595604, COL_7666BE37_7FEC_476C_B19D_F98892962E5D#595605, COL_0BAF376F_F7D0_45AE_AEF9_8E19B504594E#595606, COL_554D78B0_EA21_483D_B574_547426ADB482#595607, COL_0B066C93_809D_4EB0_8ADF_3636D7B76593#595608, COL_EB753D17_130C_4979_986B_D18FFF9DD40A#595609, COL_0A7B71F1_4A2E_4EB3_A94C_939DCDA503B9#595610, COL_3942BD61_7E90_4C5E_9240_75A61CE57789#595611, COL_10C0E375_56E4_415A_AF3C_59B02B4E8408#595612, COL_265D3814_0F5F_49EC_BEAE_386902F30D16#595613, COL_D26072D1_60A6_4A96_B906_BE91ACB59614#595614, COL_22A9E0BF_52D7_4815_A42C_BA2F7EDBB3C0#595615, COL_3D1D7AA8_1BB1_46F0_8501_CDDDFE0E78BA#595616, COL_2B27FA6E_B24E_4B22_8ACC_F3D028A40856#595617, COL_80238879_541A_4F44_92A5_9926F6B94DB8#595618, COL_621D957A_7A06_4745_964E_FE09BFFF8DB7#595619, COL_34B3B671_24B2_4686_8CB9_962569FCA41D#595620, COL_4FDAA229_CCB9_46CF_9F7E_A744CF47F572#595621, COL_275DF47E_340B_4E55_A9F4_EDCC14A9627D#595622, COL_7E77AF73_752C_48EE_856C_5C920DEA334B#595623, COL_EC7C9040_E9DF_4E9F_BA9E_A1A6A0233AF9#595624, COL_21232554_8AE3_4294_9504_876AA3A8D672#595625, COL_C0597E1D_6B5A_4F8B_9564_EE724FCB06A6#595626, COL_8806DAD5_E7F9_4288_9EF7_33FF7C7ABBFD#595627, COL_5D701CFC_3360_465B_9BEE_24B4F9CA695B#595628, COL_F0D25D20_CEE9_44DC_ADA4_FEB5CC21F368#595629, COL_C18DDF33_5647_412B_B46F_605FB907BC20#595630, COL_CFBEFC28_3BE8_4A12_8520_4056414B51FB#595631, COL_8E05E990_9DCD_4946_810B_5D660C48B128#595632, COL_C644CF67_72CA_452B_8B61_CFFAE6D90B0B#595633, COL_968995BF_0BEB_4F9D_AB7B_2F70009B0383#595634, COL_C931157E_CFBA_4535_B8F1_D3C29D1EFD77#595635, COL_1BB74F82_ECBC_4133_AF56_13121C73FA5D#595636, COL_77DF2687_0629_4378_B27F_E72E041D79EC#595637, COL_BF828FB3_0BA8_4921_A6A5_07A65F79C8E0#595638, COL_04822B1E_A0F2_4670_BDB2_507D07D8F3DE#595639]
Arguments: [COL_F36F08A6_928E_400F_B138_61F9B8D28AF3#595589 ASC NULLS FIRST], false, 0

(7) Scan parquet 
Output [3]: [COL_E38AB62F_E896_4A72_BE7E_515F8BC641C6#595246, COL_A2516838_D999_49FB_A245_E9F9B72D742A#595250, COL_8EA5D1BB_B903_4AA6_811C_01F4D36D9299#595251]
Batched: true
Location: InMemoryFileIndex [file:/data/output/cache/parquet/datablock/06_COMPILATION__226005]
PushedFilters: [IsNotNull(COL_A2516838_D999_49FB_A245_E9F9B72D742A)]
ReadSchema: struct<COL_E38AB62F_E896_4A72_BE7E_515F8BC641C6:double,COL_A2516838_D999_49FB_A245_E9F9B72D742A:int,COL_8EA5D1BB_B903_4AA6_811C_01F4D36D9299:double>

(8) ColumnarToRow [codegen id : 2]
Input [3]: [COL_E38AB62F_E896_4A72_BE7E_515F8BC641C6#595246, COL_A2516838_D999_49FB_A245_E9F9B72D742A#595250, COL_8EA5D1BB_B903_4AA6_811C_01F4D36D9299#595251]

(9) Filter [codegen id : 2]
Input [3]: [COL_E38AB62F_E896_4A72_BE7E_515F8BC641C6#595246, COL_A2516838_D999_49FB_A245_E9F9B72D742A#595250, COL_8EA5D1BB_B903_4AA6_811C_01F4D36D9299#595251]
Condition : isnotnull(COL_A2516838_D999_49FB_A245_E9F9B72D742A#595250)

(10) Project [codegen id : 2]
Output [3]: [COL_E38AB62F_E896_4A72_BE7E_515F8BC641C6#595246 AS 06_COMPILATION__226005_COL_E38AB62F_E896_4A72_BE7E_515F8BC641C6#595721, COL_A2516838_D999_49FB_A245_E9F9B72D742A#595250 AS 06_COMPILATION__226005_COL_A2516838_D999_49FB_A245_E9F9B72D742A#595725, COL_8EA5D1BB_B903_4AA6_811C_01F4D36D9299#595251 AS 06_COMPILATION__226005_COL_8EA5D1BB_B903_4AA6_811C_01F4D36D9299#595726]
Input [3]: [COL_E38AB62F_E896_4A72_BE7E_515F8BC641C6#595246, COL_A2516838_D999_49FB_A245_E9F9B72D742A#595250, COL_8EA5D1BB_B903_4AA6_811C_01F4D36D9299#595251]

(11) Exchange
Input [3]: [06_COMPILATION__226005_COL_E38AB62F_E896_4A72_BE7E_515F8BC641C6#595721, 06_COMPILATION__226005_COL_A2516838_D999_49FB_A245_E9F9B72D742A#595725, 06_COMPILATION__226005_COL_8EA5D1BB_B903_4AA6_811C_01F4D36D9299#595726]
Arguments: hashpartitioning(06_COMPILATION__226005_COL_A2516838_D999_49FB_A245_E9F9B72D742A#595725, 10), ENSURE_REQUIREMENTS, [plan_id=368088]

(12) ShuffleQueryStage
Output [3]: [06_COMPILATION__226005_COL_E38AB62F_E896_4A72_BE7E_515F8BC641C6#595721, 06_COMPILATION__226005_COL_A2516838_D999_49FB_A245_E9F9B72D742A#595725, 06_COMPILATION__226005_COL_8EA5D1BB_B903_4AA6_811C_01F4D36D9299#595726]
Arguments: 1

(13) Sort [codegen id : 4]
Input [3]: [06_COMPILATION__226005_COL_E38AB62F_E896_4A72_BE7E_515F8BC641C6#595721, 06_COMPILATION__226005_COL_A2516838_D999_49FB_A245_E9F9B72D742A#595725, 06_COMPILATION__226005_COL_8EA5D1BB_B903_4AA6_811C_01F4D36D9299#595726]
Arguments: [06_COMPILATION__226005_COL_A2516838_D999_49FB_A245_E9F9B72D742A#595725 ASC NULLS FIRST], false, 0

(14) SortMergeJoin [codegen id : 5]
Left keys [1]: [COL_F36F08A6_928E_400F_B138_61F9B8D28AF3#595589]
Right keys [1]: [06_COMPILATION__226005_COL_A2516838_D999_49FB_A245_E9F9B72D742A#595725]
Join type: LeftOuter
Join condition: None

(15) Project [codegen id : 5]
Output [56]: [COL_497B3BF1_A9CE_4411_8889_2F0461FEE049#595587, COL_8DCB3027_3C9D_41AC_A59E_4DD19821C3A6#595588, COL_F36F08A6_928E_400F_B138_61F9B8D28AF3#595589, COL_A213E432_2691_4225_8DF4_C45A67AF4D9C#595590, COL_E3EB948B_0B85_4F37_970A_DD334B343EE2#595591, COL_77534C40_F008_4F9B_99A1_4982451B7A24#595592, COL_AF30678A_46A6_422E_838A_452D36B65FC1#595593, COL_29EA226E_C020_4D1F_A8DC_11FA4AB16409#595594, COL_C3DFC75D_DBFD_47F3_B940_59BD461CA3C0#595595, COL_7506CA9E_3DD1_4B12_8A2A_D2766532D59A#595596, COL_64235A62_C014_4D54_98DA_329A3C835EDA#595597, COL_76B3E933_F01E_4379_9153_B0E76D1633B5#595598, COL_9AE6D4D7_A126_4880_B33C_1337A4899A8C#595599, COL_9A5C81F5_9A6A_450B_AEBB_DB3516344104#595600, COL_066BC6D4_55AA_434A_8BD9_1D16816DDDDA#595601, COL_22D6710B_B7B5_4729_9BCB_202027CB0BD4#595602, COL_6102ADDE_08E8_4710_9AD0_D2CA02BC21DE#595603, COL_4A1DE469_43EB_4CAC_9134_3E477437431A#595604, COL_7666BE37_7FEC_476C_B19D_F98892962E5D#595605, COL_0BAF376F_F7D0_45AE_AEF9_8E19B504594E#595606, COL_554D78B0_EA21_483D_B574_547426ADB482#595607, COL_0B066C93_809D_4EB0_8ADF_3636D7B76593#595608, COL_EB753D17_130C_4979_986B_D18FFF9DD40A#595609, COL_0A7B71F1_4A2E_4EB3_A94C_939DCDA503B9#595610, COL_3942BD61_7E90_4C5E_9240_75A61CE57789#595611, COL_10C0E375_56E4_415A_AF3C_59B02B4E8408#595612, COL_265D3814_0F5F_49EC_BEAE_386902F30D16#595613, COL_D26072D1_60A6_4A96_B906_BE91ACB59614#595614, COL_22A9E0BF_52D7_4815_A42C_BA2F7EDBB3C0#595615, COL_3D1D7AA8_1BB1_46F0_8501_CDDDFE0E78BA#595616, COL_2B27FA6E_B24E_4B22_8ACC_F3D028A40856#595617, COL_80238879_541A_4F44_92A5_9926F6B94DB8#595618, COL_621D957A_7A06_4745_964E_FE09BFFF8DB7#595619, COL_34B3B671_24B2_4686_8CB9_962569FCA41D#595620, COL_4FDAA229_CCB9_46CF_9F7E_A744CF47F572#595621, COL_275DF47E_340B_4E55_A9F4_EDCC14A9627D#595622, COL_7E77AF73_752C_48EE_856C_5C920DEA334B#595623, COL_EC7C9040_E9DF_4E9F_BA9E_A1A6A0233AF9#595624, COL_21232554_8AE3_4294_9504_876AA3A8D672#595625, COL_C0597E1D_6B5A_4F8B_9564_EE724FCB06A6#595626, COL_8806DAD5_E7F9_4288_9EF7_33FF7C7ABBFD#595627, COL_5D701CFC_3360_465B_9BEE_24B4F9CA695B#595628, COL_F0D25D20_CEE9_44DC_ADA4_FEB5CC21F368#595629, COL_C18DDF33_5647_412B_B46F_605FB907BC20#595630, COL_CFBEFC28_3BE8_4A12_8520_4056414B51FB#595631, COL_8E05E990_9DCD_4946_810B_5D660C48B128#595632, COL_C644CF67_72CA_452B_8B61_CFFAE6D90B0B#595633, COL_968995BF_0BEB_4F9D_AB7B_2F70009B0383#595634, COL_C931157E_CFBA_4535_B8F1_D3C29D1EFD77#595635, COL_1BB74F82_ECBC_4133_AF56_13121C73FA5D#595636, COL_77DF2687_0629_4378_B27F_E72E041D79EC#595637, COL_BF828FB3_0BA8_4921_A6A5_07A65F79C8E0#595638, COL_04822B1E_A0F2_4670_BDB2_507D07D8F3DE#595639, 06_COMPILATION__226005_COL_E38AB62F_E896_4A72_BE7E_515F8BC641C6#595721 AS COL_36411CB9_EA90_4CC8_9DF1_BF8D8F09879E#596271, str_if_with_rule(isnotnull(06_COMPILATION__226005_COL_E38AB62F_E896_4A72_BE7E_515F8BC641C6#595721), 1, 0) AS COL_BD3E04C0_8EA0_45E3_B543_6A416F1B68FC#596272, 06_COMPILATION__226005_COL_8EA5D1BB_B903_4AA6_811C_01F4D36D9299#595726 AS COL_415D2D73_010E_4929_AF07_08F5C67C77B2#596273]
Input [56]: [COL_497B3BF1_A9CE_4411_8889_2F0461FEE049#595587, COL_8DCB3027_3C9D_41AC_A59E_4DD19821C3A6#595588, COL_F36F08A6_928E_400F_B138_61F9B8D28AF3#595589, COL_A213E432_2691_4225_8DF4_C45A67AF4D9C#595590, COL_E3EB948B_0B85_4F37_970A_DD334B343EE2#595591, COL_77534C40_F008_4F9B_99A1_4982451B7A24#595592, COL_AF30678A_46A6_422E_838A_452D36B65FC1#595593, COL_29EA226E_C020_4D1F_A8DC_11FA4AB16409#595594, COL_C3DFC75D_DBFD_47F3_B940_59BD461CA3C0#595595, COL_7506CA9E_3DD1_4B12_8A2A_D2766532D59A#595596, COL_64235A62_C014_4D54_98DA_329A3C835EDA#595597, COL_76B3E933_F01E_4379_9153_B0E76D1633B5#595598, COL_9AE6D4D7_A126_4880_B33C_1337A4899A8C#595599, COL_9A5C81F5_9A6A_450B_AEBB_DB3516344104#595600, COL_066BC6D4_55AA_434A_8BD9_1D16816DDDDA#595601, COL_22D6710B_B7B5_4729_9BCB_202027CB0BD4#595602, COL_6102ADDE_08E8_4710_9AD0_D2CA02BC21DE#595603, COL_4A1DE469_43EB_4CAC_9134_3E477437431A#595604, COL_7666BE37_7FEC_476C_B19D_F98892962E5D#595605, COL_0BAF376F_F7D0_45AE_AEF9_8E19B504594E#595606, COL_554D78B0_EA21_483D_B574_547426ADB482#595607, COL_0B066C93_809D_4EB0_8ADF_3636D7B76593#595608, COL_EB753D17_130C_4979_986B_D18FFF9DD40A#595609, COL_0A7B71F1_4A2E_4EB3_A94C_939DCDA503B9#595610, COL_3942BD61_7E90_4C5E_9240_75A61CE57789#595611, COL_10C0E375_56E4_415A_AF3C_59B02B4E8408#595612, COL_265D3814_0F5F_49EC_BEAE_386902F30D16#595613, COL_D26072D1_60A6_4A96_B906_BE91ACB59614#595614, COL_22A9E0BF_52D7_4815_A42C_BA2F7EDBB3C0#595615, COL_3D1D7AA8_1BB1_46F0_8501_CDDDFE0E78BA#595616, COL_2B27FA6E_B24E_4B22_8ACC_F3D028A40856#595617, COL_80238879_541A_4F44_92A5_9926F6B94DB8#595618, COL_621D957A_7A06_4745_964E_FE09BFFF8DB7#595619, COL_34B3B671_24B2_4686_8CB9_962569FCA41D#595620, COL_4FDAA229_CCB9_46CF_9F7E_A744CF47F572#595621, COL_275DF47E_340B_4E55_A9F4_EDCC14A9627D#595622, COL_7E77AF73_752C_48EE_856C_5C920DEA334B#595623, COL_EC7C9040_E9DF_4E9F_BA9E_A1A6A0233AF9#595624, COL_21232554_8AE3_4294_9504_876AA3A8D672#595625, COL_C0597E1D_6B5A_4F8B_9564_EE724FCB06A6#595626, COL_8806DAD5_E7F9_4288_9EF7_33FF7C7ABBFD#595627, COL_5D701CFC_3360_465B_9BEE_24B4F9CA695B#595628, COL_F0D25D20_CEE9_44DC_ADA4_FEB5CC21F368#595629, COL_C18DDF33_5647_412B_B46F_605FB907BC20#595630, COL_CFBEFC28_3BE8_4A12_8520_4056414B51FB#595631, COL_8E05E990_9DCD_4946_810B_5D660C48B128#595632, COL_C644CF67_72CA_452B_8B61_CFFAE6D90B0B#595633, COL_968995BF_0BEB_4F9D_AB7B_2F70009B0383#595634, COL_C931157E_CFBA_4535_B8F1_D3C29D1EFD77#595635, COL_1BB74F82_ECBC_4133_AF56_13121C73FA5D#595636, COL_77DF2687_0629_4378_B27F_E72E041D79EC#595637, COL_BF828FB3_0BA8_4921_A6A5_07A65F79C8E0#595638, COL_04822B1E_A0F2_4670_BDB2_507D07D8F3DE#595639, 06_COMPILATION__226005_COL_E38AB62F_E896_4A72_BE7E_515F8BC641C6#595721, 06_COMPILATION__226005_COL_A2516838_D999_49FB_A245_E9F9B72D742A#595725, 06_COMPILATION__226005_COL_8EA5D1BB_B903_4AA6_811C_01F4D36D9299#595726]

(16) WriteFiles
Input [56]: [COL_497B3BF1_A9CE_4411_8889_2F0461FEE049#595587, COL_8DCB3027_3C9D_41AC_A59E_4DD19821C3A6#595588, COL_F36F08A6_928E_400F_B138_61F9B8D28AF3#595589, COL_A213E432_2691_4225_8DF4_C45A67AF4D9C#595590, COL_E3EB948B_0B85_4F37_970A_DD334B343EE2#595591, COL_77534C40_F008_4F9B_99A1_4982451B7A24#595592, COL_AF30678A_46A6_422E_838A_452D36B65FC1#595593, COL_29EA226E_C020_4D1F_A8DC_11FA4AB16409#595594, COL_C3DFC75D_DBFD_47F3_B940_59BD461CA3C0#595595, COL_7506CA9E_3DD1_4B12_8A2A_D2766532D59A#595596, COL_64235A62_C014_4D54_98DA_329A3C835EDA#595597, COL_76B3E933_F01E_4379_9153_B0E76D1633B5#595598, COL_9AE6D4D7_A126_4880_B33C_1337A4899A8C#595599, COL_9A5C81F5_9A6A_450B_AEBB_DB3516344104#595600, COL_066BC6D4_55AA_434A_8BD9_1D16816DDDDA#595601, COL_22D6710B_B7B5_4729_9BCB_202027CB0BD4#595602, COL_6102ADDE_08E8_4710_9AD0_D2CA02BC21DE#595603, COL_4A1DE469_43EB_4CAC_9134_3E477437431A#595604, COL_7666BE37_7FEC_476C_B19D_F98892962E5D#595605, COL_0BAF376F_F7D0_45AE_AEF9_8E19B504594E#595606, COL_554D78B0_EA21_483D_B574_547426ADB482#595607, COL_0B066C93_809D_4EB0_8ADF_3636D7B76593#595608, COL_EB753D17_130C_4979_986B_D18FFF9DD40A#595609, COL_0A7B71F1_4A2E_4EB3_A94C_939DCDA503B9#595610, COL_3942BD61_7E90_4C5E_9240_75A61CE57789#595611, COL_10C0E375_56E4_415A_AF3C_59B02B4E8408#595612, COL_265D3814_0F5F_49EC_BEAE_386902F30D16#595613, COL_D26072D1_60A6_4A96_B906_BE91ACB59614#595614, COL_22A9E0BF_52D7_4815_A42C_BA2F7EDBB3C0#595615, COL_3D1D7AA8_1BB1_46F0_8501_CDDDFE0E78BA#595616, COL_2B27FA6E_B24E_4B22_8ACC_F3D028A40856#595617, COL_80238879_541A_4F44_92A5_9926F6B94DB8#595618, COL_621D957A_7A06_4745_964E_FE09BFFF8DB7#595619, COL_34B3B671_24B2_4686_8CB9_962569FCA41D#595620, COL_4FDAA229_CCB9_46CF_9F7E_A744CF47F572#595621, COL_275DF47E_340B_4E55_A9F4_EDCC14A9627D#595622, COL_7E77AF73_752C_48EE_856C_5C920DEA334B#595623, COL_EC7C9040_E9DF_4E9F_BA9E_A1A6A0233AF9#595624, COL_21232554_8AE3_4294_9504_876AA3A8D672#595625, COL_C0597E1D_6B5A_4F8B_9564_EE724FCB06A6#595626, COL_8806DAD5_E7F9_4288_9EF7_33FF7C7ABBFD#595627, COL_5D701CFC_3360_465B_9BEE_24B4F9CA695B#595628, COL_F0D25D20_CEE9_44DC_ADA4_FEB5CC21F368#595629, COL_C18DDF33_5647_412B_B46F_605FB907BC20#595630, COL_CFBEFC28_3BE8_4A12_8520_4056414B51FB#595631, COL_8E05E990_9DCD_4946_810B_5D660C48B128#595632, COL_C644CF67_72CA_452B_8B61_CFFAE6D90B0B#595633, COL_968995BF_0BEB_4F9D_AB7B_2F70009B0383#595634, COL_C931157E_CFBA_4535_B8F1_D3C29D1EFD77#595635, COL_1BB74F82_ECBC_4133_AF56_13121C73FA5D#595636, COL_77DF2687_0629_4378_B27F_E72E041D79EC#595637, COL_BF828FB3_0BA8_4921_A6A5_07A65F79C8E0#595638, COL_04822B1E_A0F2_4670_BDB2_507D07D8F3DE#595639, COL_36411CB9_EA90_4CC8_9DF1_BF8D8F09879E#596271, COL_BD3E04C0_8EA0_45E3_B543_6A416F1B68FC#596272, COL_415D2D73_010E_4929_AF07_08F5C67C77B2#596273]

(17) Execute InsertIntoHadoopFsRelationCommand
Input: []
Arguments: file:/data/output/cache/parquet/datablock/09_A_TTT_SUPLIG_225939, false, Parquet, [path=file:///data/output/cache/parquet/datablock/09_A_TTT_SUPLIG_225939], Overwrite, [COL_497B3BF1_A9CE_4411_8889_2F0461FEE049, COL_8DCB3027_3C9D_41AC_A59E_4DD19821C3A6, COL_F36F08A6_928E_400F_B138_61F9B8D28AF3, COL_A213E432_2691_4225_8DF4_C45A67AF4D9C, COL_E3EB948B_0B85_4F37_970A_DD334B343EE2, COL_77534C40_F008_4F9B_99A1_4982451B7A24, COL_AF30678A_46A6_422E_838A_452D36B65FC1, COL_29EA226E_C020_4D1F_A8DC_11FA4AB16409, COL_C3DFC75D_DBFD_47F3_B940_59BD461CA3C0, COL_7506CA9E_3DD1_4B12_8A2A_D2766532D59A, COL_64235A62_C014_4D54_98DA_329A3C835EDA, COL_76B3E933_F01E_4379_9153_B0E76D1633B5, COL_9AE6D4D7_A126_4880_B33C_1337A4899A8C, COL_9A5C81F5_9A6A_450B_AEBB_DB3516344104, COL_066BC6D4_55AA_434A_8BD9_1D16816DDDDA, COL_22D6710B_B7B5_4729_9BCB_202027CB0BD4, COL_6102ADDE_08E8_4710_9AD0_D2CA02BC21DE, COL_4A1DE469_43EB_4CAC_9134_3E477437431A, COL_7666BE37_7FEC_476C_B19D_F98892962E5D, COL_0BAF376F_F7D0_45AE_AEF9_8E19B504594E, COL_554D78B0_EA21_483D_B574_547426ADB482, COL_0B066C93_809D_4EB0_8ADF_3636D7B76593, COL_EB753D17_130C_4979_986B_D18FFF9DD40A, COL_0A7B71F1_4A2E_4EB3_A94C_939DCDA503B9, ... 32 more fields]

(18) Project
Output [53]: [COL_4ECA949F_2DA4_41C5_80E1_520DEFC8D1EA#595129 AS COL_497B3BF1_A9CE_4411_8889_2F0461FEE049#595587, COL_F522EF71_EF5D_46C0_B0EC_B3EB638B97F7#595130 AS COL_8DCB3027_3C9D_41AC_A59E_4DD19821C3A6#595588, COL_CEFA2472_1E3F_469C_9633_864540C40AD9#595131 AS COL_F36F08A6_928E_400F_B138_61F9B8D28AF3#595589, COL_1DDA21A4_0127_416B_A5DB_7EDD9CC61B56#595132 AS COL_A213E432_2691_4225_8DF4_C45A67AF4D9C#595590, COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#595133 AS COL_E3EB948B_0B85_4F37_970A_DD334B343EE2#595591, COL_0521CAB9_7617_4F31_948E_95DCA16387D7#595134 AS COL_77534C40_F008_4F9B_99A1_4982451B7A24#595592, COL_1DACB81E_AFA5_4BB8_83D7_57DE8B8062B7#595135 AS COL_AF30678A_46A6_422E_838A_452D36B65FC1#595593, COL_9262BBED_C393_416D_B38C_8F1458965BA7#595136 AS COL_29EA226E_C020_4D1F_A8DC_11FA4AB16409#595594, COL_F76265AB_8748_4114_92B4_00E37DE25D34#595137 AS COL_C3DFC75D_DBFD_47F3_B940_59BD461CA3C0#595595, COL_96E2282E_0771_460E_8BDB_D11261BD9020#595138 AS COL_7506CA9E_3DD1_4B12_8A2A_D2766532D59A#595596, COL_12028397_66B1_4E3C_BBDB_64537606E7DE#595139 AS COL_64235A62_C014_4D54_98DA_329A3C835EDA#595597, COL_580D5890_2839_4108_A636_8E25F97E50E0#595140 AS COL_76B3E933_F01E_4379_9153_B0E76D1633B5#595598, COL_3AFB6BB7_7AA1_4D16_AE24_4CB203A67B51#595141 AS COL_9AE6D4D7_A126_4880_B33C_1337A4899A8C#595599, COL_2C09E3B7_4086_45D3_8676_F1D58494C2DD#595142 AS COL_9A5C81F5_9A6A_450B_AEBB_DB3516344104#595600, COL_4473F770_A575_4100_97F6_8190F900749A#595143 AS COL_066BC6D4_55AA_434A_8BD9_1D16816DDDDA#595601, COL_715B3479_EAD2_422C_BF5C_7B020197D946#595144 AS COL_22D6710B_B7B5_4729_9BCB_202027CB0BD4#595602, COL_B41952EB_DE3F_4899_8A04_46EF55D519D3#595145 AS COL_6102ADDE_08E8_4710_9AD0_D2CA02BC21DE#595603, COL_13C7079E_53C2_4945_BB83_A9CBB5596CA7#595146 AS COL_4A1DE469_43EB_4CAC_9134_3E477437431A#595604, COL_1DD27485_A759_457B_BE67_EC6813E5F6C7#595147 AS COL_7666BE37_7FEC_476C_B19D_F98892962E5D#595605, COL_5F21C9DE_C72B_4C4D_A042_7C2B1C8E43BD#595148 AS COL_0BAF376F_F7D0_45AE_AEF9_8E19B504594E#595606, COL_97360DFB_D20B_4DFF_A68A_57C41867D04E#595149 AS COL_554D78B0_EA21_483D_B574_547426ADB482#595607, COL_8F13405A_6271_4B4F_BE3D_AFBE0E624AFC#595150 AS COL_0B066C93_809D_4EB0_8ADF_3636D7B76593#595608, COL_390B6626_6008_4E32_942E_6ED08B69626F#595151 AS COL_EB753D17_130C_4979_986B_D18FFF9DD40A#595609, COL_CD30424F_E1B5_4038_9F6F_A6119868B45C#595152 AS COL_0A7B71F1_4A2E_4EB3_A94C_939DCDA503B9#595610, COL_2B738BBE_CFA2_41EB_9490_76129BDDA7D3#595153 AS COL_3942BD61_7E90_4C5E_9240_75A61CE57789#595611, COL_869EE117_A1AF_4643_9C63_B2E044E76011#595154 AS COL_10C0E375_56E4_415A_AF3C_59B02B4E8408#595612, COL_2DEF4579_4198_4381_9794_0850D509C4D9#595155 AS COL_265D3814_0F5F_49EC_BEAE_386902F30D16#595613, COL_28DD75A8_B9B0_41E0_B8DE_4C1D788339EF#595156 AS COL_D26072D1_60A6_4A96_B906_BE91ACB59614#595614, COL_5143601C_5C8F_46DA_8653_3EFEB2EE859D#595157 AS COL_22A9E0BF_52D7_4815_A42C_BA2F7EDBB3C0#595615, COL_603BA3E4_9B75_44D5_A914_615FAE0C5436#595158 AS COL_3D1D7AA8_1BB1_46F0_8501_CDDDFE0E78BA#595616, COL_50D051CB_B5A3_4A22_99CF_B636DE0B08A4#595159 AS COL_2B27FA6E_B24E_4B22_8ACC_F3D028A40856#595617, COL_B2D69078_23A7_4B36_BBF2_3F9C29840464#595160 AS COL_80238879_541A_4F44_92A5_9926F6B94DB8#595618, COL_47A73BC1_4566_45A9_8162_7B6B9E438C8D#595161 AS COL_621D957A_7A06_4745_964E_FE09BFFF8DB7#595619, COL_91F5095A_FAAE_4325_81BC_62ABDD788E8D#595162 AS COL_34B3B671_24B2_4686_8CB9_962569FCA41D#595620, COL_394590C1_A817_4CDB_80AC_456AA6E27DEA#595163 AS COL_4FDAA229_CCB9_46CF_9F7E_A744CF47F572#595621, COL_011EF34A_6883_4296_BBBF_AC60A68C84DD#595164 AS COL_275DF47E_340B_4E55_A9F4_EDCC14A9627D#595622, COL_C1F37338_7743_4434_879A_FF32C1BC5112#595165 AS COL_7E77AF73_752C_48EE_856C_5C920DEA334B#595623, COL_FAEC3B31_0447_4E4B_B8EC_83794AF975DD#595166 AS COL_EC7C9040_E9DF_4E9F_BA9E_A1A6A0233AF9#595624, COL_FF5E7CF3_75CA_45FF_AA0E_98474CEB50C2#595167 AS COL_21232554_8AE3_4294_9504_876AA3A8D672#595625, COL_6B0E2B89_AC1D_411B_A0AB_19B2CEF8CFC9#595168 AS COL_C0597E1D_6B5A_4F8B_9564_EE724FCB06A6#595626, COL_D7508510_B4D7_44C5_A063_A2132B6EF08A#595169 AS COL_8806DAD5_E7F9_4288_9EF7_33FF7C7ABBFD#595627, COL_EAA75683_8CB4_4075_AA4A_FACAF98EBD6E#595170 AS COL_5D701CFC_3360_465B_9BEE_24B4F9CA695B#595628, COL_B8D0B7A4_71CB_4406_88C1_4791F02E29EF#595171 AS COL_F0D25D20_CEE9_44DC_ADA4_FEB5CC21F368#595629, COL_AA499A88_B893_47E4_99C5_0EB9F6D69842#595172 AS COL_C18DDF33_5647_412B_B46F_605FB907BC20#595630, COL_95383EBC_3648_4E94_9C53_D311092BF5F4#595173 AS COL_CFBEFC28_3BE8_4A12_8520_4056414B51FB#595631, COL_7DC2A78A_5ED5_4908_AC94_0885B83B98CD#595174 AS COL_8E05E990_9DCD_4946_810B_5D660C48B128#595632, COL_383EDE50_7CF9_4E24_A70F_BA7CD5C9D6BA#595175 AS COL_C644CF67_72CA_452B_8B61_CFFAE6D90B0B#595633, COL_585F8C49_925B_4809_B445_C6A91423BA50#595176 AS COL_968995BF_0BEB_4F9D_AB7B_2F70009B0383#595634, COL_E7D4B3BC_F96E_4431_BC95_1D1CCE75D846#595177 AS COL_C931157E_CFBA_4535_B8F1_D3C29D1EFD77#595635, COL_B057EBBF_57E7_449C_9DE3_CD56F041B86B#595178 AS COL_1BB74F82_ECBC_4133_AF56_13121C73FA5D#595636, COL_B8D74F46_C755_4417_9E18_FAA760CD8457#595179 AS COL_77DF2687_0629_4378_B27F_E72E041D79EC#595637, COL_51335C75_C8A9_4932_8985_BA9E68B80F3A#595180 AS COL_BF828FB3_0BA8_4921_A6A5_07A65F79C8E0#595638, COL_03AE34A5_99F1_4525_9BD2_BF7BAFE47F5C#595181 AS COL_04822B1E_A0F2_4670_BDB2_507D07D8F3DE#595639]
Input [53]: [COL_4ECA949F_2DA4_41C5_80E1_520DEFC8D1EA#595129, COL_F522EF71_EF5D_46C0_B0EC_B3EB638B97F7#595130, COL_CEFA2472_1E3F_469C_9633_864540C40AD9#595131, COL_1DDA21A4_0127_416B_A5DB_7EDD9CC61B56#595132, COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#595133, COL_0521CAB9_7617_4F31_948E_95DCA16387D7#595134, COL_1DACB81E_AFA5_4BB8_83D7_57DE8B8062B7#595135, COL_9262BBED_C393_416D_B38C_8F1458965BA7#595136, COL_F76265AB_8748_4114_92B4_00E37DE25D34#595137, COL_96E2282E_0771_460E_8BDB_D11261BD9020#595138, COL_12028397_66B1_4E3C_BBDB_64537606E7DE#595139, COL_580D5890_2839_4108_A636_8E25F97E50E0#595140, COL_3AFB6BB7_7AA1_4D16_AE24_4CB203A67B51#595141, COL_2C09E3B7_4086_45D3_8676_F1D58494C2DD#595142, COL_4473F770_A575_4100_97F6_8190F900749A#595143, COL_715B3479_EAD2_422C_BF5C_7B020197D946#595144, COL_B41952EB_DE3F_4899_8A04_46EF55D519D3#595145, COL_13C7079E_53C2_4945_BB83_A9CBB5596CA7#595146, COL_1DD27485_A759_457B_BE67_EC6813E5F6C7#595147, COL_5F21C9DE_C72B_4C4D_A042_7C2B1C8E43BD#595148, COL_97360DFB_D20B_4DFF_A68A_57C41867D04E#595149, COL_8F13405A_6271_4B4F_BE3D_AFBE0E624AFC#595150, COL_390B6626_6008_4E32_942E_6ED08B69626F#595151, COL_CD30424F_E1B5_4038_9F6F_A6119868B45C#595152, COL_2B738BBE_CFA2_41EB_9490_76129BDDA7D3#595153, COL_869EE117_A1AF_4643_9C63_B2E044E76011#595154, COL_2DEF4579_4198_4381_9794_0850D509C4D9#595155, COL_28DD75A8_B9B0_41E0_B8DE_4C1D788339EF#595156, COL_5143601C_5C8F_46DA_8653_3EFEB2EE859D#595157, COL_603BA3E4_9B75_44D5_A914_615FAE0C5436#595158, COL_50D051CB_B5A3_4A22_99CF_B636DE0B08A4#595159, COL_B2D69078_23A7_4B36_BBF2_3F9C29840464#595160, COL_47A73BC1_4566_45A9_8162_7B6B9E438C8D#595161, COL_91F5095A_FAAE_4325_81BC_62ABDD788E8D#595162, COL_394590C1_A817_4CDB_80AC_456AA6E27DEA#595163, COL_011EF34A_6883_4296_BBBF_AC60A68C84DD#595164, COL_C1F37338_7743_4434_879A_FF32C1BC5112#595165, COL_FAEC3B31_0447_4E4B_B8EC_83794AF975DD#595166, COL_FF5E7CF3_75CA_45FF_AA0E_98474CEB50C2#595167, COL_6B0E2B89_AC1D_411B_A0AB_19B2CEF8CFC9#595168, COL_D7508510_B4D7_44C5_A063_A2132B6EF08A#595169, COL_EAA75683_8CB4_4075_AA4A_FACAF98EBD6E#595170, COL_B8D0B7A4_71CB_4406_88C1_4791F02E29EF#595171, COL_AA499A88_B893_47E4_99C5_0EB9F6D69842#595172, COL_95383EBC_3648_4E94_9C53_D311092BF5F4#595173, COL_7DC2A78A_5ED5_4908_AC94_0885B83B98CD#595174, COL_383EDE50_7CF9_4E24_A70F_BA7CD5C9D6BA#595175, COL_585F8C49_925B_4809_B445_C6A91423BA50#595176, COL_E7D4B3BC_F96E_4431_BC95_1D1CCE75D846#595177, COL_B057EBBF_57E7_449C_9DE3_CD56F041B86B#595178, COL_B8D74F46_C755_4417_9E18_FAA760CD8457#595179, COL_51335C75_C8A9_4932_8985_BA9E68B80F3A#595180, COL_03AE34A5_99F1_4525_9BD2_BF7BAFE47F5C#595181]

(19) Exchange
Input [53]: [COL_497B3BF1_A9CE_4411_8889_2F0461FEE049#595587, COL_8DCB3027_3C9D_41AC_A59E_4DD19821C3A6#595588, COL_F36F08A6_928E_400F_B138_61F9B8D28AF3#595589, COL_A213E432_2691_4225_8DF4_C45A67AF4D9C#595590, COL_E3EB948B_0B85_4F37_970A_DD334B343EE2#595591, COL_77534C40_F008_4F9B_99A1_4982451B7A24#595592, COL_AF30678A_46A6_422E_838A_452D36B65FC1#595593, COL_29EA226E_C020_4D1F_A8DC_11FA4AB16409#595594, COL_C3DFC75D_DBFD_47F3_B940_59BD461CA3C0#595595, COL_7506CA9E_3DD1_4B12_8A2A_D2766532D59A#595596, COL_64235A62_C014_4D54_98DA_329A3C835EDA#595597, COL_76B3E933_F01E_4379_9153_B0E76D1633B5#595598, COL_9AE6D4D7_A126_4880_B33C_1337A4899A8C#595599, COL_9A5C81F5_9A6A_450B_AEBB_DB3516344104#595600, COL_066BC6D4_55AA_434A_8BD9_1D16816DDDDA#595601, COL_22D6710B_B7B5_4729_9BCB_202027CB0BD4#595602, COL_6102ADDE_08E8_4710_9AD0_D2CA02BC21DE#595603, COL_4A1DE469_43EB_4CAC_9134_3E477437431A#595604, COL_7666BE37_7FEC_476C_B19D_F98892962E5D#595605, COL_0BAF376F_F7D0_45AE_AEF9_8E19B504594E#595606, COL_554D78B0_EA21_483D_B574_547426ADB482#595607, COL_0B066C93_809D_4EB0_8ADF_3636D7B76593#595608, COL_EB753D17_130C_4979_986B_D18FFF9DD40A#595609, COL_0A7B71F1_4A2E_4EB3_A94C_939DCDA503B9#595610, COL_3942BD61_7E90_4C5E_9240_75A61CE57789#595611, COL_10C0E375_56E4_415A_AF3C_59B02B4E8408#595612, COL_265D3814_0F5F_49EC_BEAE_386902F30D16#595613, COL_D26072D1_60A6_4A96_B906_BE91ACB59614#595614, COL_22A9E0BF_52D7_4815_A42C_BA2F7EDBB3C0#595615, COL_3D1D7AA8_1BB1_46F0_8501_CDDDFE0E78BA#595616, COL_2B27FA6E_B24E_4B22_8ACC_F3D028A40856#595617, COL_80238879_541A_4F44_92A5_9926F6B94DB8#595618, COL_621D957A_7A06_4745_964E_FE09BFFF8DB7#595619, COL_34B3B671_24B2_4686_8CB9_962569FCA41D#595620, COL_4FDAA229_CCB9_46CF_9F7E_A744CF47F572#595621, COL_275DF47E_340B_4E55_A9F4_EDCC14A9627D#595622, COL_7E77AF73_752C_48EE_856C_5C920DEA334B#595623, COL_EC7C9040_E9DF_4E9F_BA9E_A1A6A0233AF9#595624, COL_21232554_8AE3_4294_9504_876AA3A8D672#595625, COL_C0597E1D_6B5A_4F8B_9564_EE724FCB06A6#595626, COL_8806DAD5_E7F9_4288_9EF7_33FF7C7ABBFD#595627, COL_5D701CFC_3360_465B_9BEE_24B4F9CA695B#595628, COL_F0D25D20_CEE9_44DC_ADA4_FEB5CC21F368#595629, COL_C18DDF33_5647_412B_B46F_605FB907BC20#595630, COL_CFBEFC28_3BE8_4A12_8520_4056414B51FB#595631, COL_8E05E990_9DCD_4946_810B_5D660C48B128#595632, COL_C644CF67_72CA_452B_8B61_CFFAE6D90B0B#595633, COL_968995BF_0BEB_4F9D_AB7B_2F70009B0383#595634, COL_C931157E_CFBA_4535_B8F1_D3C29D1EFD77#595635, COL_1BB74F82_ECBC_4133_AF56_13121C73FA5D#595636, COL_77DF2687_0629_4378_B27F_E72E041D79EC#595637, COL_BF828FB3_0BA8_4921_A6A5_07A65F79C8E0#595638, COL_04822B1E_A0F2_4670_BDB2_507D07D8F3DE#595639]
Arguments: hashpartitioning(COL_F36F08A6_928E_400F_B138_61F9B8D28AF3#595589, 10), ENSURE_REQUIREMENTS, [plan_id=368042]

(20) Sort
Input [53]: [COL_497B3BF1_A9CE_4411_8889_2F0461FEE049#595587, COL_8DCB3027_3C9D_41AC_A59E_4DD19821C3A6#595588, COL_F36F08A6_928E_400F_B138_61F9B8D28AF3#595589, COL_A213E432_2691_4225_8DF4_C45A67AF4D9C#595590, COL_E3EB948B_0B85_4F37_970A_DD334B343EE2#595591, COL_77534C40_F008_4F9B_99A1_4982451B7A24#595592, COL_AF30678A_46A6_422E_838A_452D36B65FC1#595593, COL_29EA226E_C020_4D1F_A8DC_11FA4AB16409#595594, COL_C3DFC75D_DBFD_47F3_B940_59BD461CA3C0#595595, COL_7506CA9E_3DD1_4B12_8A2A_D2766532D59A#595596, COL_64235A62_C014_4D54_98DA_329A3C835EDA#595597, COL_76B3E933_F01E_4379_9153_B0E76D1633B5#595598, COL_9AE6D4D7_A126_4880_B33C_1337A4899A8C#595599, COL_9A5C81F5_9A6A_450B_AEBB_DB3516344104#595600, COL_066BC6D4_55AA_434A_8BD9_1D16816DDDDA#595601, COL_22D6710B_B7B5_4729_9BCB_202027CB0BD4#595602, COL_6102ADDE_08E8_4710_9AD0_D2CA02BC21DE#595603, COL_4A1DE469_43EB_4CAC_9134_3E477437431A#595604, COL_7666BE37_7FEC_476C_B19D_F98892962E5D#595605, COL_0BAF376F_F7D0_45AE_AEF9_8E19B504594E#595606, COL_554D78B0_EA21_483D_B574_547426ADB482#595607, COL_0B066C93_809D_4EB0_8ADF_3636D7B76593#595608, COL_EB753D17_130C_4979_986B_D18FFF9DD40A#595609, COL_0A7B71F1_4A2E_4EB3_A94C_939DCDA503B9#595610, COL_3942BD61_7E90_4C5E_9240_75A61CE57789#595611, COL_10C0E375_56E4_415A_AF3C_59B02B4E8408#595612, COL_265D3814_0F5F_49EC_BEAE_386902F30D16#595613, COL_D26072D1_60A6_4A96_B906_BE91ACB59614#595614, COL_22A9E0BF_52D7_4815_A42C_BA2F7EDBB3C0#595615, COL_3D1D7AA8_1BB1_46F0_8501_CDDDFE0E78BA#595616, COL_2B27FA6E_B24E_4B22_8ACC_F3D028A40856#595617, COL_80238879_541A_4F44_92A5_9926F6B94DB8#595618, COL_621D957A_7A06_4745_964E_FE09BFFF8DB7#595619, COL_34B3B671_24B2_4686_8CB9_962569FCA41D#595620, COL_4FDAA229_CCB9_46CF_9F7E_A744CF47F572#595621, COL_275DF47E_340B_4E55_A9F4_EDCC14A9627D#595622, COL_7E77AF73_752C_48EE_856C_5C920DEA334B#595623, COL_EC7C9040_E9DF_4E9F_BA9E_A1A6A0233AF9#595624, COL_21232554_8AE3_4294_9504_876AA3A8D672#595625, COL_C0597E1D_6B5A_4F8B_9564_EE724FCB06A6#595626, COL_8806DAD5_E7F9_4288_9EF7_33FF7C7ABBFD#595627, COL_5D701CFC_3360_465B_9BEE_24B4F9CA695B#595628, COL_F0D25D20_CEE9_44DC_ADA4_FEB5CC21F368#595629, COL_C18DDF33_5647_412B_B46F_605FB907BC20#595630, COL_CFBEFC28_3BE8_4A12_8520_4056414B51FB#595631, COL_8E05E990_9DCD_4946_810B_5D660C48B128#595632, COL_C644CF67_72CA_452B_8B61_CFFAE6D90B0B#595633, COL_968995BF_0BEB_4F9D_AB7B_2F70009B0383#595634, COL_C931157E_CFBA_4535_B8F1_D3C29D1EFD77#595635, COL_1BB74F82_ECBC_4133_AF56_13121C73FA5D#595636, COL_77DF2687_0629_4378_B27F_E72E041D79EC#595637, COL_BF828FB3_0BA8_4921_A6A5_07A65F79C8E0#595638, COL_04822B1E_A0F2_4670_BDB2_507D07D8F3DE#595639]
Arguments: [COL_F36F08A6_928E_400F_B138_61F9B8D28AF3#595589 ASC NULLS FIRST], false, 0

(21) Filter
Input [3]: [COL_E38AB62F_E896_4A72_BE7E_515F8BC641C6#595246, COL_A2516838_D999_49FB_A245_E9F9B72D742A#595250, COL_8EA5D1BB_B903_4AA6_811C_01F4D36D9299#595251]
Condition : isnotnull(COL_A2516838_D999_49FB_A245_E9F9B72D742A#595250)

(22) Project
Output [3]: [COL_E38AB62F_E896_4A72_BE7E_515F8BC641C6#595246 AS 06_COMPILATION__226005_COL_E38AB62F_E896_4A72_BE7E_515F8BC641C6#595721, COL_A2516838_D999_49FB_A245_E9F9B72D742A#595250 AS 06_COMPILATION__226005_COL_A2516838_D999_49FB_A245_E9F9B72D742A#595725, COL_8EA5D1BB_B903_4AA6_811C_01F4D36D9299#595251 AS 06_COMPILATION__226005_COL_8EA5D1BB_B903_4AA6_811C_01F4D36D9299#595726]
Input [3]: [COL_E38AB62F_E896_4A72_BE7E_515F8BC641C6#595246, COL_A2516838_D999_49FB_A245_E9F9B72D742A#595250, COL_8EA5D1BB_B903_4AA6_811C_01F4D36D9299#595251]

(23) Exchange
Input [3]: [06_COMPILATION__226005_COL_E38AB62F_E896_4A72_BE7E_515F8BC641C6#595721, 06_COMPILATION__226005_COL_A2516838_D999_49FB_A245_E9F9B72D742A#595725, 06_COMPILATION__226005_COL_8EA5D1BB_B903_4AA6_811C_01F4D36D9299#595726]
Arguments: hashpartitioning(06_COMPILATION__226005_COL_A2516838_D999_49FB_A245_E9F9B72D742A#595725, 10), ENSURE_REQUIREMENTS, [plan_id=368043]

(24) Sort
Input [3]: [06_COMPILATION__226005_COL_E38AB62F_E896_4A72_BE7E_515F8BC641C6#595721, 06_COMPILATION__226005_COL_A2516838_D999_49FB_A245_E9F9B72D742A#595725, 06_COMPILATION__226005_COL_8EA5D1BB_B903_4AA6_811C_01F4D36D9299#595726]
Arguments: [06_COMPILATION__226005_COL_A2516838_D999_49FB_A245_E9F9B72D742A#595725 ASC NULLS FIRST], false, 0

(25) SortMergeJoin
Left keys [1]: [COL_F36F08A6_928E_400F_B138_61F9B8D28AF3#595589]
Right keys [1]: [06_COMPILATION__226005_COL_A2516838_D999_49FB_A245_E9F9B72D742A#595725]
Join type: LeftOuter
Join condition: None

(26) Project
Output [56]: [COL_497B3BF1_A9CE_4411_8889_2F0461FEE049#595587, COL_8DCB3027_3C9D_41AC_A59E_4DD19821C3A6#595588, COL_F36F08A6_928E_400F_B138_61F9B8D28AF3#595589, COL_A213E432_2691_4225_8DF4_C45A67AF4D9C#595590, COL_E3EB948B_0B85_4F37_970A_DD334B343EE2#595591, COL_77534C40_F008_4F9B_99A1_4982451B7A24#595592, COL_AF30678A_46A6_422E_838A_452D36B65FC1#595593, COL_29EA226E_C020_4D1F_A8DC_11FA4AB16409#595594, COL_C3DFC75D_DBFD_47F3_B940_59BD461CA3C0#595595, COL_7506CA9E_3DD1_4B12_8A2A_D2766532D59A#595596, COL_64235A62_C014_4D54_98DA_329A3C835EDA#595597, COL_76B3E933_F01E_4379_9153_B0E76D1633B5#595598, COL_9AE6D4D7_A126_4880_B33C_1337A4899A8C#595599, COL_9A5C81F5_9A6A_450B_AEBB_DB3516344104#595600, COL_066BC6D4_55AA_434A_8BD9_1D16816DDDDA#595601, COL_22D6710B_B7B5_4729_9BCB_202027CB0BD4#595602, COL_6102ADDE_08E8_4710_9AD0_D2CA02BC21DE#595603, COL_4A1DE469_43EB_4CAC_9134_3E477437431A#595604, COL_7666BE37_7FEC_476C_B19D_F98892962E5D#595605, COL_0BAF376F_F7D0_45AE_AEF9_8E19B504594E#595606, COL_554D78B0_EA21_483D_B574_547426ADB482#595607, COL_0B066C93_809D_4EB0_8ADF_3636D7B76593#595608, COL_EB753D17_130C_4979_986B_D18FFF9DD40A#595609, COL_0A7B71F1_4A2E_4EB3_A94C_939DCDA503B9#595610, COL_3942BD61_7E90_4C5E_9240_75A61CE57789#595611, COL_10C0E375_56E4_415A_AF3C_59B02B4E8408#595612, COL_265D3814_0F5F_49EC_BEAE_386902F30D16#595613, COL_D26072D1_60A6_4A96_B906_BE91ACB59614#595614, COL_22A9E0BF_52D7_4815_A42C_BA2F7EDBB3C0#595615, COL_3D1D7AA8_1BB1_46F0_8501_CDDDFE0E78BA#595616, COL_2B27FA6E_B24E_4B22_8ACC_F3D028A40856#595617, COL_80238879_541A_4F44_92A5_9926F6B94DB8#595618, COL_621D957A_7A06_4745_964E_FE09BFFF8DB7#595619, COL_34B3B671_24B2_4686_8CB9_962569FCA41D#595620, COL_4FDAA229_CCB9_46CF_9F7E_A744CF47F572#595621, COL_275DF47E_340B_4E55_A9F4_EDCC14A9627D#595622, COL_7E77AF73_752C_48EE_856C_5C920DEA334B#595623, COL_EC7C9040_E9DF_4E9F_BA9E_A1A6A0233AF9#595624, COL_21232554_8AE3_4294_9504_876AA3A8D672#595625, COL_C0597E1D_6B5A_4F8B_9564_EE724FCB06A6#595626, COL_8806DAD5_E7F9_4288_9EF7_33FF7C7ABBFD#595627, COL_5D701CFC_3360_465B_9BEE_24B4F9CA695B#595628, COL_F0D25D20_CEE9_44DC_ADA4_FEB5CC21F368#595629, COL_C18DDF33_5647_412B_B46F_605FB907BC20#595630, COL_CFBEFC28_3BE8_4A12_8520_4056414B51FB#595631, COL_8E05E990_9DCD_4946_810B_5D660C48B128#595632, COL_C644CF67_72CA_452B_8B61_CFFAE6D90B0B#595633, COL_968995BF_0BEB_4F9D_AB7B_2F70009B0383#595634, COL_C931157E_CFBA_4535_B8F1_D3C29D1EFD77#595635, COL_1BB74F82_ECBC_4133_AF56_13121C73FA5D#595636, COL_77DF2687_0629_4378_B27F_E72E041D79EC#595637, COL_BF828FB3_0BA8_4921_A6A5_07A65F79C8E0#595638, COL_04822B1E_A0F2_4670_BDB2_507D07D8F3DE#595639, 06_COMPILATION__226005_COL_E38AB62F_E896_4A72_BE7E_515F8BC641C6#595721 AS COL_36411CB9_EA90_4CC8_9DF1_BF8D8F09879E#596271, str_if_with_rule(isnotnull(06_COMPILATION__226005_COL_E38AB62F_E896_4A72_BE7E_515F8BC641C6#595721), 1, 0) AS COL_BD3E04C0_8EA0_45E3_B543_6A416F1B68FC#596272, 06_COMPILATION__226005_COL_8EA5D1BB_B903_4AA6_811C_01F4D36D9299#595726 AS COL_415D2D73_010E_4929_AF07_08F5C67C77B2#596273]
Input [56]: [COL_497B3BF1_A9CE_4411_8889_2F0461FEE049#595587, COL_8DCB3027_3C9D_41AC_A59E_4DD19821C3A6#595588, COL_F36F08A6_928E_400F_B138_61F9B8D28AF3#595589, COL_A213E432_2691_4225_8DF4_C45A67AF4D9C#595590, COL_E3EB948B_0B85_4F37_970A_DD334B343EE2#595591, COL_77534C40_F008_4F9B_99A1_4982451B7A24#595592, COL_AF30678A_46A6_422E_838A_452D36B65FC1#595593, COL_29EA226E_C020_4D1F_A8DC_11FA4AB16409#595594, COL_C3DFC75D_DBFD_47F3_B940_59BD461CA3C0#595595, COL_7506CA9E_3DD1_4B12_8A2A_D2766532D59A#595596, COL_64235A62_C014_4D54_98DA_329A3C835EDA#595597, COL_76B3E933_F01E_4379_9153_B0E76D1633B5#595598, COL_9AE6D4D7_A126_4880_B33C_1337A4899A8C#595599, COL_9A5C81F5_9A6A_450B_AEBB_DB3516344104#595600, COL_066BC6D4_55AA_434A_8BD9_1D16816DDDDA#595601, COL_22D6710B_B7B5_4729_9BCB_202027CB0BD4#595602, COL_6102ADDE_08E8_4710_9AD0_D2CA02BC21DE#595603, COL_4A1DE469_43EB_4CAC_9134_3E477437431A#595604, COL_7666BE37_7FEC_476C_B19D_F98892962E5D#595605, COL_0BAF376F_F7D0_45AE_AEF9_8E19B504594E#595606, COL_554D78B0_EA21_483D_B574_547426ADB482#595607, COL_0B066C93_809D_4EB0_8ADF_3636D7B76593#595608, COL_EB753D17_130C_4979_986B_D18FFF9DD40A#595609, COL_0A7B71F1_4A2E_4EB3_A94C_939DCDA503B9#595610, COL_3942BD61_7E90_4C5E_9240_75A61CE57789#595611, COL_10C0E375_56E4_415A_AF3C_59B02B4E8408#595612, COL_265D3814_0F5F_49EC_BEAE_386902F30D16#595613, COL_D26072D1_60A6_4A96_B906_BE91ACB59614#595614, COL_22A9E0BF_52D7_4815_A42C_BA2F7EDBB3C0#595615, COL_3D1D7AA8_1BB1_46F0_8501_CDDDFE0E78BA#595616, COL_2B27FA6E_B24E_4B22_8ACC_F3D028A40856#595617, COL_80238879_541A_4F44_92A5_9926F6B94DB8#595618, COL_621D957A_7A06_4745_964E_FE09BFFF8DB7#595619, COL_34B3B671_24B2_4686_8CB9_962569FCA41D#595620, COL_4FDAA229_CCB9_46CF_9F7E_A744CF47F572#595621, COL_275DF47E_340B_4E55_A9F4_EDCC14A9627D#595622, COL_7E77AF73_752C_48EE_856C_5C920DEA334B#595623, COL_EC7C9040_E9DF_4E9F_BA9E_A1A6A0233AF9#595624, COL_21232554_8AE3_4294_9504_876AA3A8D672#595625, COL_C0597E1D_6B5A_4F8B_9564_EE724FCB06A6#595626, COL_8806DAD5_E7F9_4288_9EF7_33FF7C7ABBFD#595627, COL_5D701CFC_3360_465B_9BEE_24B4F9CA695B#595628, COL_F0D25D20_CEE9_44DC_ADA4_FEB5CC21F368#595629, COL_C18DDF33_5647_412B_B46F_605FB907BC20#595630, COL_CFBEFC28_3BE8_4A12_8520_4056414B51FB#595631, COL_8E05E990_9DCD_4946_810B_5D660C48B128#595632, COL_C644CF67_72CA_452B_8B61_CFFAE6D90B0B#595633, COL_968995BF_0BEB_4F9D_AB7B_2F70009B0383#595634, COL_C931157E_CFBA_4535_B8F1_D3C29D1EFD77#595635, COL_1BB74F82_ECBC_4133_AF56_13121C73FA5D#595636, COL_77DF2687_0629_4378_B27F_E72E041D79EC#595637, COL_BF828FB3_0BA8_4921_A6A5_07A65F79C8E0#595638, COL_04822B1E_A0F2_4670_BDB2_507D07D8F3DE#595639, 06_COMPILATION__226005_COL_E38AB62F_E896_4A72_BE7E_515F8BC641C6#595721, 06_COMPILATION__226005_COL_A2516838_D999_49FB_A245_E9F9B72D742A#595725, 06_COMPILATION__226005_COL_8EA5D1BB_B903_4AA6_811C_01F4D36D9299#595726]

(27) WriteFiles
Input [56]: [COL_497B3BF1_A9CE_4411_8889_2F0461FEE049#595587, COL_8DCB3027_3C9D_41AC_A59E_4DD19821C3A6#595588, COL_F36F08A6_928E_400F_B138_61F9B8D28AF3#595589, COL_A213E432_2691_4225_8DF4_C45A67AF4D9C#595590, COL_E3EB948B_0B85_4F37_970A_DD334B343EE2#595591, COL_77534C40_F008_4F9B_99A1_4982451B7A24#595592, COL_AF30678A_46A6_422E_838A_452D36B65FC1#595593, COL_29EA226E_C020_4D1F_A8DC_11FA4AB16409#595594, COL_C3DFC75D_DBFD_47F3_B940_59BD461CA3C0#595595, COL_7506CA9E_3DD1_4B12_8A2A_D2766532D59A#595596, COL_64235A62_C014_4D54_98DA_329A3C835EDA#595597, COL_76B3E933_F01E_4379_9153_B0E76D1633B5#595598, COL_9AE6D4D7_A126_4880_B33C_1337A4899A8C#595599, COL_9A5C81F5_9A6A_450B_AEBB_DB3516344104#595600, COL_066BC6D4_55AA_434A_8BD9_1D16816DDDDA#595601, COL_22D6710B_B7B5_4729_9BCB_202027CB0BD4#595602, COL_6102ADDE_08E8_4710_9AD0_D2CA02BC21DE#595603, COL_4A1DE469_43EB_4CAC_9134_3E477437431A#595604, COL_7666BE37_7FEC_476C_B19D_F98892962E5D#595605, COL_0BAF376F_F7D0_45AE_AEF9_8E19B504594E#595606, COL_554D78B0_EA21_483D_B574_547426ADB482#595607, COL_0B066C93_809D_4EB0_8ADF_3636D7B76593#595608, COL_EB753D17_130C_4979_986B_D18FFF9DD40A#595609, COL_0A7B71F1_4A2E_4EB3_A94C_939DCDA503B9#595610, COL_3942BD61_7E90_4C5E_9240_75A61CE57789#595611, COL_10C0E375_56E4_415A_AF3C_59B02B4E8408#595612, COL_265D3814_0F5F_49EC_BEAE_386902F30D16#595613, COL_D26072D1_60A6_4A96_B906_BE91ACB59614#595614, COL_22A9E0BF_52D7_4815_A42C_BA2F7EDBB3C0#595615, COL_3D1D7AA8_1BB1_46F0_8501_CDDDFE0E78BA#595616, COL_2B27FA6E_B24E_4B22_8ACC_F3D028A40856#595617, COL_80238879_541A_4F44_92A5_9926F6B94DB8#595618, COL_621D957A_7A06_4745_964E_FE09BFFF8DB7#595619, COL_34B3B671_24B2_4686_8CB9_962569FCA41D#595620, COL_4FDAA229_CCB9_46CF_9F7E_A744CF47F572#595621, COL_275DF47E_340B_4E55_A9F4_EDCC14A9627D#595622, COL_7E77AF73_752C_48EE_856C_5C920DEA334B#595623, COL_EC7C9040_E9DF_4E9F_BA9E_A1A6A0233AF9#595624, COL_21232554_8AE3_4294_9504_876AA3A8D672#595625, COL_C0597E1D_6B5A_4F8B_9564_EE724FCB06A6#595626, COL_8806DAD5_E7F9_4288_9EF7_33FF7C7ABBFD#595627, COL_5D701CFC_3360_465B_9BEE_24B4F9CA695B#595628, COL_F0D25D20_CEE9_44DC_ADA4_FEB5CC21F368#595629, COL_C18DDF33_5647_412B_B46F_605FB907BC20#595630, COL_CFBEFC28_3BE8_4A12_8520_4056414B51FB#595631, COL_8E05E990_9DCD_4946_810B_5D660C48B128#595632, COL_C644CF67_72CA_452B_8B61_CFFAE6D90B0B#595633, COL_968995BF_0BEB_4F9D_AB7B_2F70009B0383#595634, COL_C931157E_CFBA_4535_B8F1_D3C29D1EFD77#595635, COL_1BB74F82_ECBC_4133_AF56_13121C73FA5D#595636, COL_77DF2687_0629_4378_B27F_E72E041D79EC#595637, COL_BF828FB3_0BA8_4921_A6A5_07A65F79C8E0#595638, COL_04822B1E_A0F2_4670_BDB2_507D07D8F3DE#595639, COL_36411CB9_EA90_4CC8_9DF1_BF8D8F09879E#596271, COL_BD3E04C0_8EA0_45E3_B543_6A416F1B68FC#596272, COL_415D2D73_010E_4929_AF07_08F5C67C77B2#596273]

(28) Execute InsertIntoHadoopFsRelationCommand
Input: []
Arguments: file:/data/output/cache/parquet/datablock/09_A_TTT_SUPLIG_225939, false, Parquet, [path=file:///data/output/cache/parquet/datablock/09_A_TTT_SUPLIG_225939], Overwrite, [COL_497B3BF1_A9CE_4411_8889_2F0461FEE049, COL_8DCB3027_3C9D_41AC_A59E_4DD19821C3A6, COL_F36F08A6_928E_400F_B138_61F9B8D28AF3, COL_A213E432_2691_4225_8DF4_C45A67AF4D9C, COL_E3EB948B_0B85_4F37_970A_DD334B343EE2, COL_77534C40_F008_4F9B_99A1_4982451B7A24, COL_AF30678A_46A6_422E_838A_452D36B65FC1, COL_29EA226E_C020_4D1F_A8DC_11FA4AB16409, COL_C3DFC75D_DBFD_47F3_B940_59BD461CA3C0, COL_7506CA9E_3DD1_4B12_8A2A_D2766532D59A, COL_64235A62_C014_4D54_98DA_329A3C835EDA, COL_76B3E933_F01E_4379_9153_B0E76D1633B5, COL_9AE6D4D7_A126_4880_B33C_1337A4899A8C, COL_9A5C81F5_9A6A_450B_AEBB_DB3516344104, COL_066BC6D4_55AA_434A_8BD9_1D16816DDDDA, COL_22D6710B_B7B5_4729_9BCB_202027CB0BD4, COL_6102ADDE_08E8_4710_9AD0_D2CA02BC21DE, COL_4A1DE469_43EB_4CAC_9134_3E477437431A, COL_7666BE37_7FEC_476C_B19D_F98892962E5D, COL_0BAF376F_F7D0_45AE_AEF9_8E19B504594E, COL_554D78B0_EA21_483D_B574_547426ADB482, COL_0B066C93_809D_4EB0_8ADF_3636D7B76593, COL_EB753D17_130C_4979_986B_D18FFF9DD40A, COL_0A7B71F1_4A2E_4EB3_A94C_939DCDA503B9, ... 32 more fields]

(29) AdaptiveSparkPlan
Output: []
Arguments: isFinalPlan=true

SQL / DataFrame Properties

Name	Value
spark.sql.optimizer.nestedPredicatePushdown.supportedFileSources	parquet,orc,geoparquet