SP1 - Details for Query 4635

Submitted Time: 2026/05/20 14:36:40
Duration: 1 s
Succeeded Jobs: 7259 7260 7261

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)) 7 ms (0 ms, 1 ms, 2 ms (stage 14880.0: task 20718)) number of written files: 10 job commit time: 10 ms number of output rows: 45,283 number of dynamic part: 0 written output: 6.2 MiB"]; 2 [labelType="html" label=" WriteFiles "]; subgraph cluster3 { isCluster="true"; label="WholeStageCodegen (3)\n \nduration: total (min, med, max (stageId: taskId))\n4.3 s (314 ms, 458 ms, 482 ms (stage 14880.0: task 20722))"; 4 [labelType="html" label=" Project "]; 5 [labelType="html" label=" Project "]; } 6 [labelType="html" label="Exchange shuffle records written: 45,283 local merged chunks fetched: 0 shuffle write time total (min, med, max (stageId: taskId)) 58 ms (5 ms, 5 ms, 6 ms (stage 14877.0: task 20705)) 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: 45,283 local bytes read total (min, med, max (stageId: taskId)) 16.4 MiB (1638.6 KiB, 1682.8 KiB, 1732.6 KiB (stage 14880.0: task 20719)) fetch wait time total (min, med, max (stageId: taskId)) 0 ms (0 ms, 0 ms, 0 ms (stage 14880.0: task 20721)) 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)) 55.2 MiB (5.3 MiB, 5.6 MiB, 5.7 MiB (stage 14877.0: task 20704)) 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)) 16.4 MiB (1626.2 KiB, 1687.8 KiB, 1724.0 KiB (stage 14877.0: task 20704))"]; subgraph cluster7 { isCluster="true"; label="WholeStageCodegen (1)\n \nduration: total (min, med, max (stageId: taskId))\n3.2 s (282 ms, 323 ms, 346 ms (stage 14877.0: task 20704))"; 8 [labelType="html" label=" Project "]; 9 [labelType="html" label="ColumnarToRow number of output rows: 45,283 number of input batches: 20"]; } 10 [labelType="html" label="Scan parquet number of files read: 10 scan time total (min, med, max (stageId: taskId)) 239 ms (16 ms, 26 ms, 29 ms (stage 14877.0: task 20708)) metadata time: 0 ms size of files read: 3.4 MiB number of output rows: 45,283"]; 1->0; 2->1; 4->2; 5->4; 6->5; 8->6; 9->8; 10->9; }

AdaptiveSparkPlan isFinalPlan=true

Execute InsertIntoHadoopFsRelationCommand file:/data/output/cache/parquet/datablock/09_A_TTT_SUPLIG_172632, false, Parquet, [path=file:///data/output/cache/parquet/datablock/09_A_TTT_SUPLIG_172632], Overwrite, [COL_497B3BF1_A9CE_4411_8889_2F0461FEE049, COL_162F4FF6_9702_423C_8695_B193CBA6104D, 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, ... 33 more fields]

WriteFiles

Project [COL_497B3BF1_A9CE_4411_8889_2F0461FEE049#1161241, COL_162F4FF6_9702_423C_8695_B193CBA6104D#1161242, COL_8DCB3027_3C9D_41AC_A59E_4DD19821C3A6#1161243, COL_F36F08A6_928E_400F_B138_61F9B8D28AF3#1161244, COL_A213E432_2691_4225_8DF4_C45A67AF4D9C#1161245, COL_E3EB948B_0B85_4F37_970A_DD334B343EE2#1161246, COL_77534C40_F008_4F9B_99A1_4982451B7A24#1161247, COL_AF30678A_46A6_422E_838A_452D36B65FC1#1161248, COL_29EA226E_C020_4D1F_A8DC_11FA4AB16409#1161249, COL_C3DFC75D_DBFD_47F3_B940_59BD461CA3C0#1161250, COL_7506CA9E_3DD1_4B12_8A2A_D2766532D59A#1161251, COL_64235A62_C014_4D54_98DA_329A3C835EDA#1161252, COL_76B3E933_F01E_4379_9153_B0E76D1633B5#1161253, COL_9AE6D4D7_A126_4880_B33C_1337A4899A8C#1161254, COL_9A5C81F5_9A6A_450B_AEBB_DB3516344104#1161255, COL_066BC6D4_55AA_434A_8BD9_1D16816DDDDA#1161256, COL_22D6710B_B7B5_4729_9BCB_202027CB0BD4#1161257, COL_6102ADDE_08E8_4710_9AD0_D2CA02BC21DE#1161258, COL_4A1DE469_43EB_4CAC_9134_3E477437431A#1161259, COL_7666BE37_7FEC_476C_B19D_F98892962E5D#1161260, COL_0BAF376F_F7D0_45AE_AEF9_8E19B504594E#1161261, COL_554D78B0_EA21_483D_B574_547426ADB482#1161262, COL_0B066C93_809D_4EB0_8ADF_3636D7B76593#1161263, COL_EB753D17_130C_4979_986B_D18FFF9DD40A#1161264, ... 33 more fields]

WholeStageCodegen (3)

Exchange hashpartitioning(COL_F36F08A6_928E_400F_B138_61F9B8D28AF3#1161244, 10), ENSURE_REQUIREMENTS, [plan_id=659160]

Project [COL_4ECA949F_2DA4_41C5_80E1_520DEFC8D1EA#1160809 AS COL_497B3BF1_A9CE_4411_8889_2F0461FEE049#1161241, COL_D14F6518_D1F3_4F18_93EC_DEF8E6712184#1160810 AS COL_162F4FF6_9702_423C_8695_B193CBA6104D#1161242, COL_F522EF71_EF5D_46C0_B0EC_B3EB638B97F7#1160811 AS COL_8DCB3027_3C9D_41AC_A59E_4DD19821C3A6#1161243, COL_CEFA2472_1E3F_469C_9633_864540C40AD9#1160812 AS COL_F36F08A6_928E_400F_B138_61F9B8D28AF3#1161244, COL_1DDA21A4_0127_416B_A5DB_7EDD9CC61B56#1160813 AS COL_A213E432_2691_4225_8DF4_C45A67AF4D9C#1161245, COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#1160814 AS COL_E3EB948B_0B85_4F37_970A_DD334B343EE2#1161246, COL_0521CAB9_7617_4F31_948E_95DCA16387D7#1160815 AS COL_77534C40_F008_4F9B_99A1_4982451B7A24#1161247, COL_1DACB81E_AFA5_4BB8_83D7_57DE8B8062B7#1160816 AS COL_AF30678A_46A6_422E_838A_452D36B65FC1#1161248, COL_9262BBED_C393_416D_B38C_8F1458965BA7#1160817 AS COL_29EA226E_C020_4D1F_A8DC_11FA4AB16409#1161249, COL_F76265AB_8748_4114_92B4_00E37DE25D34#1160818 AS COL_C3DFC75D_DBFD_47F3_B940_59BD461CA3C0#1161250, COL_96E2282E_0771_460E_8BDB_D11261BD9020#1160819 AS COL_7506CA9E_3DD1_4B12_8A2A_D2766532D59A#1161251, COL_12028397_66B1_4E3C_BBDB_64537606E7DE#1160820 AS COL_64235A62_C014_4D54_98DA_329A3C835EDA#1161252, COL_580D5890_2839_4108_A636_8E25F97E50E0#1160821 AS COL_76B3E933_F01E_4379_9153_B0E76D1633B5#1161253, COL_3AFB6BB7_7AA1_4D16_AE24_4CB203A67B51#1160822 AS COL_9AE6D4D7_A126_4880_B33C_1337A4899A8C#1161254, COL_2C09E3B7_4086_45D3_8676_F1D58494C2DD#1160823 AS COL_9A5C81F5_9A6A_450B_AEBB_DB3516344104#1161255, COL_4473F770_A575_4100_97F6_8190F900749A#1160824 AS COL_066BC6D4_55AA_434A_8BD9_1D16816DDDDA#1161256, COL_715B3479_EAD2_422C_BF5C_7B020197D946#1160825 AS COL_22D6710B_B7B5_4729_9BCB_202027CB0BD4#1161257, COL_B41952EB_DE3F_4899_8A04_46EF55D519D3#1160826 AS COL_6102ADDE_08E8_4710_9AD0_D2CA02BC21DE#1161258, COL_13C7079E_53C2_4945_BB83_A9CBB5596CA7#1160827 AS COL_4A1DE469_43EB_4CAC_9134_3E477437431A#1161259, COL_1DD27485_A759_457B_BE67_EC6813E5F6C7#1160828 AS COL_7666BE37_7FEC_476C_B19D_F98892962E5D#1161260, COL_5F21C9DE_C72B_4C4D_A042_7C2B1C8E43BD#1160829 AS COL_0BAF376F_F7D0_45AE_AEF9_8E19B504594E#1161261, COL_97360DFB_D20B_4DFF_A68A_57C41867D04E#1160830 AS COL_554D78B0_EA21_483D_B574_547426ADB482#1161262, COL_8F13405A_6271_4B4F_BE3D_AFBE0E624AFC#1160831 AS COL_0B066C93_809D_4EB0_8ADF_3636D7B76593#1161263, COL_390B6626_6008_4E32_942E_6ED08B69626F#1160832 AS COL_EB753D17_130C_4979_986B_D18FFF9DD40A#1161264, ... 30 more fields]

ColumnarToRow

WholeStageCodegen (1)

FileScan parquet [COL_4ECA949F_2DA4_41C5_80E1_520DEFC8D1EA#1160809,COL_D14F6518_D1F3_4F18_93EC_DEF8E6712184#1160810,COL_F522EF71_EF5D_46C0_B0EC_B3EB638B97F7#1160811,COL_CEFA2472_1E3F_469C_9633_864540C40AD9#1160812,COL_1DDA21A4_0127_416B_A5DB_7EDD9CC61B56#1160813,COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#1160814,COL_0521CAB9_7617_4F31_948E_95DCA16387D7#1160815,COL_1DACB81E_AFA5_4BB8_83D7_57DE8B8062B7#1160816,COL_9262BBED_C393_416D_B38C_8F1458965BA7#1160817,COL_F76265AB_8748_4114_92B4_00E37DE25D34#1160818,COL_96E2282E_0771_460E_8BDB_D11261BD9020#1160819,COL_12028397_66B1_4E3C_BBDB_64537606E7DE#1160820,COL_580D5890_2839_4108_A636_8E25F97E50E0#1160821,COL_3AFB6BB7_7AA1_4D16_AE24_4CB203A67B51#1160822,COL_2C09E3B7_4086_45D3_8676_F1D58494C2DD#1160823,COL_4473F770_A575_4100_97F6_8190F900749A#1160824,COL_715B3479_EAD2_422C_BF5C_7B020197D946#1160825,COL_B41952EB_DE3F_4899_8A04_46EF55D519D3#1160826,COL_13C7079E_53C2_4945_BB83_A9CBB5596CA7#1160827,COL_1DD27485_A759_457B_BE67_EC6813E5F6C7#1160828,COL_5F21C9DE_C72B_4C4D_A042_7C2B1C8E43BD#1160829,COL_97360DFB_D20B_4DFF_A68A_57C41867D04E#1160830,COL_8F13405A_6271_4B4F_BE3D_AFBE0E624AFC#1160831,COL_390B6626_6008_4E32_942E_6ED08B69626F#1160832,... 30 more fields] Batched: true, DataFilters: [], Format: Parquet, Location: InMemoryFileIndex(1 paths)[file:/data/output/cache/parquet/datablock/02_A_ELIGIBLE_172496], PartitionFilters: [], PushedFilters: [], ReadSchema: struct<COL_4ECA949F_2DA4_41C5_80E1_520DEFC8D1EA:string,COL_D14F6518_D1F3_4F18_93EC_DEF8E6712184:s...

Details

== Physical Plan ==
AdaptiveSparkPlan (22)
+- == Final Plan ==
   Execute InsertIntoHadoopFsRelationCommand (9)
   +- WriteFiles (8)
      +- * Project (7)
         +- * Project (6)
            +- ShuffleQueryStage (5), Statistics(sizeInBytes=55.2 MiB, rowCount=4.53E+4)
               +- Exchange (4)
                  +- * Project (3)
                     +- * ColumnarToRow (2)
                        +- Scan parquet  (1)
+- == Initial Plan ==
   Execute InsertIntoHadoopFsRelationCommand (21)
   +- WriteFiles (20)
      +- Project (19)
         +- SortMergeJoin LeftOuter (18)
            :- Sort (12)
            :  +- Exchange (11)
            :     +- Project (10)
            :        +- Scan parquet  (1)
            +- Sort (17)
               +- Exchange (16)
                  +- Project (15)
                     +- Filter (14)
                        +- Scan parquet  (13)


(1) Scan parquet 
Output [54]: [COL_4ECA949F_2DA4_41C5_80E1_520DEFC8D1EA#1160809, COL_D14F6518_D1F3_4F18_93EC_DEF8E6712184#1160810, COL_F522EF71_EF5D_46C0_B0EC_B3EB638B97F7#1160811, COL_CEFA2472_1E3F_469C_9633_864540C40AD9#1160812, COL_1DDA21A4_0127_416B_A5DB_7EDD9CC61B56#1160813, COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#1160814, COL_0521CAB9_7617_4F31_948E_95DCA16387D7#1160815, COL_1DACB81E_AFA5_4BB8_83D7_57DE8B8062B7#1160816, COL_9262BBED_C393_416D_B38C_8F1458965BA7#1160817, COL_F76265AB_8748_4114_92B4_00E37DE25D34#1160818, COL_96E2282E_0771_460E_8BDB_D11261BD9020#1160819, COL_12028397_66B1_4E3C_BBDB_64537606E7DE#1160820, COL_580D5890_2839_4108_A636_8E25F97E50E0#1160821, COL_3AFB6BB7_7AA1_4D16_AE24_4CB203A67B51#1160822, COL_2C09E3B7_4086_45D3_8676_F1D58494C2DD#1160823, COL_4473F770_A575_4100_97F6_8190F900749A#1160824, COL_715B3479_EAD2_422C_BF5C_7B020197D946#1160825, COL_B41952EB_DE3F_4899_8A04_46EF55D519D3#1160826, COL_13C7079E_53C2_4945_BB83_A9CBB5596CA7#1160827, COL_1DD27485_A759_457B_BE67_EC6813E5F6C7#1160828, COL_5F21C9DE_C72B_4C4D_A042_7C2B1C8E43BD#1160829, COL_97360DFB_D20B_4DFF_A68A_57C41867D04E#1160830, COL_8F13405A_6271_4B4F_BE3D_AFBE0E624AFC#1160831, COL_390B6626_6008_4E32_942E_6ED08B69626F#1160832, COL_CD30424F_E1B5_4038_9F6F_A6119868B45C#1160833, COL_2B738BBE_CFA2_41EB_9490_76129BDDA7D3#1160834, COL_869EE117_A1AF_4643_9C63_B2E044E76011#1160835, COL_2DEF4579_4198_4381_9794_0850D509C4D9#1160836, COL_28DD75A8_B9B0_41E0_B8DE_4C1D788339EF#1160837, COL_5143601C_5C8F_46DA_8653_3EFEB2EE859D#1160838, COL_603BA3E4_9B75_44D5_A914_615FAE0C5436#1160839, COL_50D051CB_B5A3_4A22_99CF_B636DE0B08A4#1160840, COL_B2D69078_23A7_4B36_BBF2_3F9C29840464#1160841, COL_47A73BC1_4566_45A9_8162_7B6B9E438C8D#1160842, COL_91F5095A_FAAE_4325_81BC_62ABDD788E8D#1160843, COL_394590C1_A817_4CDB_80AC_456AA6E27DEA#1160844, COL_011EF34A_6883_4296_BBBF_AC60A68C84DD#1160845, COL_C1F37338_7743_4434_879A_FF32C1BC5112#1160846, COL_FAEC3B31_0447_4E4B_B8EC_83794AF975DD#1160847, COL_FF5E7CF3_75CA_45FF_AA0E_98474CEB50C2#1160848, COL_6B0E2B89_AC1D_411B_A0AB_19B2CEF8CFC9#1160849, COL_D7508510_B4D7_44C5_A063_A2132B6EF08A#1160850, COL_EAA75683_8CB4_4075_AA4A_FACAF98EBD6E#1160851, COL_B8D0B7A4_71CB_4406_88C1_4791F02E29EF#1160852, COL_AA499A88_B893_47E4_99C5_0EB9F6D69842#1160853, COL_95383EBC_3648_4E94_9C53_D311092BF5F4#1160854, COL_7DC2A78A_5ED5_4908_AC94_0885B83B98CD#1160855, COL_383EDE50_7CF9_4E24_A70F_BA7CD5C9D6BA#1160856, COL_585F8C49_925B_4809_B445_C6A91423BA50#1160857, COL_E7D4B3BC_F96E_4431_BC95_1D1CCE75D846#1160858, COL_B057EBBF_57E7_449C_9DE3_CD56F041B86B#1160859, COL_B8D74F46_C755_4417_9E18_FAA760CD8457#1160860, COL_51335C75_C8A9_4932_8985_BA9E68B80F3A#1160861, COL_03AE34A5_99F1_4525_9BD2_BF7BAFE47F5C#1160862]
Batched: true
Location: InMemoryFileIndex [file:/data/output/cache/parquet/datablock/02_A_ELIGIBLE_172496]
ReadSchema: struct<COL_4ECA949F_2DA4_41C5_80E1_520DEFC8D1EA:string,COL_D14F6518_D1F3_4F18_93EC_DEF8E6712184: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 [54]: [COL_4ECA949F_2DA4_41C5_80E1_520DEFC8D1EA#1160809, COL_D14F6518_D1F3_4F18_93EC_DEF8E6712184#1160810, COL_F522EF71_EF5D_46C0_B0EC_B3EB638B97F7#1160811, COL_CEFA2472_1E3F_469C_9633_864540C40AD9#1160812, COL_1DDA21A4_0127_416B_A5DB_7EDD9CC61B56#1160813, COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#1160814, COL_0521CAB9_7617_4F31_948E_95DCA16387D7#1160815, COL_1DACB81E_AFA5_4BB8_83D7_57DE8B8062B7#1160816, COL_9262BBED_C393_416D_B38C_8F1458965BA7#1160817, COL_F76265AB_8748_4114_92B4_00E37DE25D34#1160818, COL_96E2282E_0771_460E_8BDB_D11261BD9020#1160819, COL_12028397_66B1_4E3C_BBDB_64537606E7DE#1160820, COL_580D5890_2839_4108_A636_8E25F97E50E0#1160821, COL_3AFB6BB7_7AA1_4D16_AE24_4CB203A67B51#1160822, COL_2C09E3B7_4086_45D3_8676_F1D58494C2DD#1160823, COL_4473F770_A575_4100_97F6_8190F900749A#1160824, COL_715B3479_EAD2_422C_BF5C_7B020197D946#1160825, COL_B41952EB_DE3F_4899_8A04_46EF55D519D3#1160826, COL_13C7079E_53C2_4945_BB83_A9CBB5596CA7#1160827, COL_1DD27485_A759_457B_BE67_EC6813E5F6C7#1160828, COL_5F21C9DE_C72B_4C4D_A042_7C2B1C8E43BD#1160829, COL_97360DFB_D20B_4DFF_A68A_57C41867D04E#1160830, COL_8F13405A_6271_4B4F_BE3D_AFBE0E624AFC#1160831, COL_390B6626_6008_4E32_942E_6ED08B69626F#1160832, COL_CD30424F_E1B5_4038_9F6F_A6119868B45C#1160833, COL_2B738BBE_CFA2_41EB_9490_76129BDDA7D3#1160834, COL_869EE117_A1AF_4643_9C63_B2E044E76011#1160835, COL_2DEF4579_4198_4381_9794_0850D509C4D9#1160836, COL_28DD75A8_B9B0_41E0_B8DE_4C1D788339EF#1160837, COL_5143601C_5C8F_46DA_8653_3EFEB2EE859D#1160838, COL_603BA3E4_9B75_44D5_A914_615FAE0C5436#1160839, COL_50D051CB_B5A3_4A22_99CF_B636DE0B08A4#1160840, COL_B2D69078_23A7_4B36_BBF2_3F9C29840464#1160841, COL_47A73BC1_4566_45A9_8162_7B6B9E438C8D#1160842, COL_91F5095A_FAAE_4325_81BC_62ABDD788E8D#1160843, COL_394590C1_A817_4CDB_80AC_456AA6E27DEA#1160844, COL_011EF34A_6883_4296_BBBF_AC60A68C84DD#1160845, COL_C1F37338_7743_4434_879A_FF32C1BC5112#1160846, COL_FAEC3B31_0447_4E4B_B8EC_83794AF975DD#1160847, COL_FF5E7CF3_75CA_45FF_AA0E_98474CEB50C2#1160848, COL_6B0E2B89_AC1D_411B_A0AB_19B2CEF8CFC9#1160849, COL_D7508510_B4D7_44C5_A063_A2132B6EF08A#1160850, COL_EAA75683_8CB4_4075_AA4A_FACAF98EBD6E#1160851, COL_B8D0B7A4_71CB_4406_88C1_4791F02E29EF#1160852, COL_AA499A88_B893_47E4_99C5_0EB9F6D69842#1160853, COL_95383EBC_3648_4E94_9C53_D311092BF5F4#1160854, COL_7DC2A78A_5ED5_4908_AC94_0885B83B98CD#1160855, COL_383EDE50_7CF9_4E24_A70F_BA7CD5C9D6BA#1160856, COL_585F8C49_925B_4809_B445_C6A91423BA50#1160857, COL_E7D4B3BC_F96E_4431_BC95_1D1CCE75D846#1160858, COL_B057EBBF_57E7_449C_9DE3_CD56F041B86B#1160859, COL_B8D74F46_C755_4417_9E18_FAA760CD8457#1160860, COL_51335C75_C8A9_4932_8985_BA9E68B80F3A#1160861, COL_03AE34A5_99F1_4525_9BD2_BF7BAFE47F5C#1160862]

(3) Project [codegen id : 1]
Output [54]: [COL_4ECA949F_2DA4_41C5_80E1_520DEFC8D1EA#1160809 AS COL_497B3BF1_A9CE_4411_8889_2F0461FEE049#1161241, COL_D14F6518_D1F3_4F18_93EC_DEF8E6712184#1160810 AS COL_162F4FF6_9702_423C_8695_B193CBA6104D#1161242, COL_F522EF71_EF5D_46C0_B0EC_B3EB638B97F7#1160811 AS COL_8DCB3027_3C9D_41AC_A59E_4DD19821C3A6#1161243, COL_CEFA2472_1E3F_469C_9633_864540C40AD9#1160812 AS COL_F36F08A6_928E_400F_B138_61F9B8D28AF3#1161244, COL_1DDA21A4_0127_416B_A5DB_7EDD9CC61B56#1160813 AS COL_A213E432_2691_4225_8DF4_C45A67AF4D9C#1161245, COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#1160814 AS COL_E3EB948B_0B85_4F37_970A_DD334B343EE2#1161246, COL_0521CAB9_7617_4F31_948E_95DCA16387D7#1160815 AS COL_77534C40_F008_4F9B_99A1_4982451B7A24#1161247, COL_1DACB81E_AFA5_4BB8_83D7_57DE8B8062B7#1160816 AS COL_AF30678A_46A6_422E_838A_452D36B65FC1#1161248, COL_9262BBED_C393_416D_B38C_8F1458965BA7#1160817 AS COL_29EA226E_C020_4D1F_A8DC_11FA4AB16409#1161249, COL_F76265AB_8748_4114_92B4_00E37DE25D34#1160818 AS COL_C3DFC75D_DBFD_47F3_B940_59BD461CA3C0#1161250, COL_96E2282E_0771_460E_8BDB_D11261BD9020#1160819 AS COL_7506CA9E_3DD1_4B12_8A2A_D2766532D59A#1161251, COL_12028397_66B1_4E3C_BBDB_64537606E7DE#1160820 AS COL_64235A62_C014_4D54_98DA_329A3C835EDA#1161252, COL_580D5890_2839_4108_A636_8E25F97E50E0#1160821 AS COL_76B3E933_F01E_4379_9153_B0E76D1633B5#1161253, COL_3AFB6BB7_7AA1_4D16_AE24_4CB203A67B51#1160822 AS COL_9AE6D4D7_A126_4880_B33C_1337A4899A8C#1161254, COL_2C09E3B7_4086_45D3_8676_F1D58494C2DD#1160823 AS COL_9A5C81F5_9A6A_450B_AEBB_DB3516344104#1161255, COL_4473F770_A575_4100_97F6_8190F900749A#1160824 AS COL_066BC6D4_55AA_434A_8BD9_1D16816DDDDA#1161256, COL_715B3479_EAD2_422C_BF5C_7B020197D946#1160825 AS COL_22D6710B_B7B5_4729_9BCB_202027CB0BD4#1161257, COL_B41952EB_DE3F_4899_8A04_46EF55D519D3#1160826 AS COL_6102ADDE_08E8_4710_9AD0_D2CA02BC21DE#1161258, COL_13C7079E_53C2_4945_BB83_A9CBB5596CA7#1160827 AS COL_4A1DE469_43EB_4CAC_9134_3E477437431A#1161259, COL_1DD27485_A759_457B_BE67_EC6813E5F6C7#1160828 AS COL_7666BE37_7FEC_476C_B19D_F98892962E5D#1161260, COL_5F21C9DE_C72B_4C4D_A042_7C2B1C8E43BD#1160829 AS COL_0BAF376F_F7D0_45AE_AEF9_8E19B504594E#1161261, COL_97360DFB_D20B_4DFF_A68A_57C41867D04E#1160830 AS COL_554D78B0_EA21_483D_B574_547426ADB482#1161262, COL_8F13405A_6271_4B4F_BE3D_AFBE0E624AFC#1160831 AS COL_0B066C93_809D_4EB0_8ADF_3636D7B76593#1161263, COL_390B6626_6008_4E32_942E_6ED08B69626F#1160832 AS COL_EB753D17_130C_4979_986B_D18FFF9DD40A#1161264, COL_CD30424F_E1B5_4038_9F6F_A6119868B45C#1160833 AS COL_0A7B71F1_4A2E_4EB3_A94C_939DCDA503B9#1161265, COL_2B738BBE_CFA2_41EB_9490_76129BDDA7D3#1160834 AS COL_3942BD61_7E90_4C5E_9240_75A61CE57789#1161266, COL_869EE117_A1AF_4643_9C63_B2E044E76011#1160835 AS COL_10C0E375_56E4_415A_AF3C_59B02B4E8408#1161267, COL_2DEF4579_4198_4381_9794_0850D509C4D9#1160836 AS COL_265D3814_0F5F_49EC_BEAE_386902F30D16#1161268, COL_28DD75A8_B9B0_41E0_B8DE_4C1D788339EF#1160837 AS COL_D26072D1_60A6_4A96_B906_BE91ACB59614#1161269, COL_5143601C_5C8F_46DA_8653_3EFEB2EE859D#1160838 AS COL_22A9E0BF_52D7_4815_A42C_BA2F7EDBB3C0#1161270, COL_603BA3E4_9B75_44D5_A914_615FAE0C5436#1160839 AS COL_3D1D7AA8_1BB1_46F0_8501_CDDDFE0E78BA#1161271, COL_50D051CB_B5A3_4A22_99CF_B636DE0B08A4#1160840 AS COL_2B27FA6E_B24E_4B22_8ACC_F3D028A40856#1161272, COL_B2D69078_23A7_4B36_BBF2_3F9C29840464#1160841 AS COL_80238879_541A_4F44_92A5_9926F6B94DB8#1161273, COL_47A73BC1_4566_45A9_8162_7B6B9E438C8D#1160842 AS COL_621D957A_7A06_4745_964E_FE09BFFF8DB7#1161274, COL_91F5095A_FAAE_4325_81BC_62ABDD788E8D#1160843 AS COL_34B3B671_24B2_4686_8CB9_962569FCA41D#1161275, COL_394590C1_A817_4CDB_80AC_456AA6E27DEA#1160844 AS COL_4FDAA229_CCB9_46CF_9F7E_A744CF47F572#1161276, COL_011EF34A_6883_4296_BBBF_AC60A68C84DD#1160845 AS COL_275DF47E_340B_4E55_A9F4_EDCC14A9627D#1161277, COL_C1F37338_7743_4434_879A_FF32C1BC5112#1160846 AS COL_7E77AF73_752C_48EE_856C_5C920DEA334B#1161278, COL_FAEC3B31_0447_4E4B_B8EC_83794AF975DD#1160847 AS COL_EC7C9040_E9DF_4E9F_BA9E_A1A6A0233AF9#1161279, COL_FF5E7CF3_75CA_45FF_AA0E_98474CEB50C2#1160848 AS COL_21232554_8AE3_4294_9504_876AA3A8D672#1161280, COL_6B0E2B89_AC1D_411B_A0AB_19B2CEF8CFC9#1160849 AS COL_C0597E1D_6B5A_4F8B_9564_EE724FCB06A6#1161281, COL_D7508510_B4D7_44C5_A063_A2132B6EF08A#1160850 AS COL_8806DAD5_E7F9_4288_9EF7_33FF7C7ABBFD#1161282, COL_EAA75683_8CB4_4075_AA4A_FACAF98EBD6E#1160851 AS COL_5D701CFC_3360_465B_9BEE_24B4F9CA695B#1161283, COL_B8D0B7A4_71CB_4406_88C1_4791F02E29EF#1160852 AS COL_F0D25D20_CEE9_44DC_ADA4_FEB5CC21F368#1161284, COL_AA499A88_B893_47E4_99C5_0EB9F6D69842#1160853 AS COL_C18DDF33_5647_412B_B46F_605FB907BC20#1161285, COL_95383EBC_3648_4E94_9C53_D311092BF5F4#1160854 AS COL_CFBEFC28_3BE8_4A12_8520_4056414B51FB#1161286, COL_7DC2A78A_5ED5_4908_AC94_0885B83B98CD#1160855 AS COL_8E05E990_9DCD_4946_810B_5D660C48B128#1161287, COL_383EDE50_7CF9_4E24_A70F_BA7CD5C9D6BA#1160856 AS COL_C644CF67_72CA_452B_8B61_CFFAE6D90B0B#1161288, COL_585F8C49_925B_4809_B445_C6A91423BA50#1160857 AS COL_968995BF_0BEB_4F9D_AB7B_2F70009B0383#1161289, COL_E7D4B3BC_F96E_4431_BC95_1D1CCE75D846#1160858 AS COL_C931157E_CFBA_4535_B8F1_D3C29D1EFD77#1161290, COL_B057EBBF_57E7_449C_9DE3_CD56F041B86B#1160859 AS COL_1BB74F82_ECBC_4133_AF56_13121C73FA5D#1161291, COL_B8D74F46_C755_4417_9E18_FAA760CD8457#1160860 AS COL_77DF2687_0629_4378_B27F_E72E041D79EC#1161292, COL_51335C75_C8A9_4932_8985_BA9E68B80F3A#1160861 AS COL_BF828FB3_0BA8_4921_A6A5_07A65F79C8E0#1161293, COL_03AE34A5_99F1_4525_9BD2_BF7BAFE47F5C#1160862 AS COL_04822B1E_A0F2_4670_BDB2_507D07D8F3DE#1161294]
Input [54]: [COL_4ECA949F_2DA4_41C5_80E1_520DEFC8D1EA#1160809, COL_D14F6518_D1F3_4F18_93EC_DEF8E6712184#1160810, COL_F522EF71_EF5D_46C0_B0EC_B3EB638B97F7#1160811, COL_CEFA2472_1E3F_469C_9633_864540C40AD9#1160812, COL_1DDA21A4_0127_416B_A5DB_7EDD9CC61B56#1160813, COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#1160814, COL_0521CAB9_7617_4F31_948E_95DCA16387D7#1160815, COL_1DACB81E_AFA5_4BB8_83D7_57DE8B8062B7#1160816, COL_9262BBED_C393_416D_B38C_8F1458965BA7#1160817, COL_F76265AB_8748_4114_92B4_00E37DE25D34#1160818, COL_96E2282E_0771_460E_8BDB_D11261BD9020#1160819, COL_12028397_66B1_4E3C_BBDB_64537606E7DE#1160820, COL_580D5890_2839_4108_A636_8E25F97E50E0#1160821, COL_3AFB6BB7_7AA1_4D16_AE24_4CB203A67B51#1160822, COL_2C09E3B7_4086_45D3_8676_F1D58494C2DD#1160823, COL_4473F770_A575_4100_97F6_8190F900749A#1160824, COL_715B3479_EAD2_422C_BF5C_7B020197D946#1160825, COL_B41952EB_DE3F_4899_8A04_46EF55D519D3#1160826, COL_13C7079E_53C2_4945_BB83_A9CBB5596CA7#1160827, COL_1DD27485_A759_457B_BE67_EC6813E5F6C7#1160828, COL_5F21C9DE_C72B_4C4D_A042_7C2B1C8E43BD#1160829, COL_97360DFB_D20B_4DFF_A68A_57C41867D04E#1160830, COL_8F13405A_6271_4B4F_BE3D_AFBE0E624AFC#1160831, COL_390B6626_6008_4E32_942E_6ED08B69626F#1160832, COL_CD30424F_E1B5_4038_9F6F_A6119868B45C#1160833, COL_2B738BBE_CFA2_41EB_9490_76129BDDA7D3#1160834, COL_869EE117_A1AF_4643_9C63_B2E044E76011#1160835, COL_2DEF4579_4198_4381_9794_0850D509C4D9#1160836, COL_28DD75A8_B9B0_41E0_B8DE_4C1D788339EF#1160837, COL_5143601C_5C8F_46DA_8653_3EFEB2EE859D#1160838, COL_603BA3E4_9B75_44D5_A914_615FAE0C5436#1160839, COL_50D051CB_B5A3_4A22_99CF_B636DE0B08A4#1160840, COL_B2D69078_23A7_4B36_BBF2_3F9C29840464#1160841, COL_47A73BC1_4566_45A9_8162_7B6B9E438C8D#1160842, COL_91F5095A_FAAE_4325_81BC_62ABDD788E8D#1160843, COL_394590C1_A817_4CDB_80AC_456AA6E27DEA#1160844, COL_011EF34A_6883_4296_BBBF_AC60A68C84DD#1160845, COL_C1F37338_7743_4434_879A_FF32C1BC5112#1160846, COL_FAEC3B31_0447_4E4B_B8EC_83794AF975DD#1160847, COL_FF5E7CF3_75CA_45FF_AA0E_98474CEB50C2#1160848, COL_6B0E2B89_AC1D_411B_A0AB_19B2CEF8CFC9#1160849, COL_D7508510_B4D7_44C5_A063_A2132B6EF08A#1160850, COL_EAA75683_8CB4_4075_AA4A_FACAF98EBD6E#1160851, COL_B8D0B7A4_71CB_4406_88C1_4791F02E29EF#1160852, COL_AA499A88_B893_47E4_99C5_0EB9F6D69842#1160853, COL_95383EBC_3648_4E94_9C53_D311092BF5F4#1160854, COL_7DC2A78A_5ED5_4908_AC94_0885B83B98CD#1160855, COL_383EDE50_7CF9_4E24_A70F_BA7CD5C9D6BA#1160856, COL_585F8C49_925B_4809_B445_C6A91423BA50#1160857, COL_E7D4B3BC_F96E_4431_BC95_1D1CCE75D846#1160858, COL_B057EBBF_57E7_449C_9DE3_CD56F041B86B#1160859, COL_B8D74F46_C755_4417_9E18_FAA760CD8457#1160860, COL_51335C75_C8A9_4932_8985_BA9E68B80F3A#1160861, COL_03AE34A5_99F1_4525_9BD2_BF7BAFE47F5C#1160862]

(4) Exchange
Input [54]: [COL_497B3BF1_A9CE_4411_8889_2F0461FEE049#1161241, COL_162F4FF6_9702_423C_8695_B193CBA6104D#1161242, COL_8DCB3027_3C9D_41AC_A59E_4DD19821C3A6#1161243, COL_F36F08A6_928E_400F_B138_61F9B8D28AF3#1161244, COL_A213E432_2691_4225_8DF4_C45A67AF4D9C#1161245, COL_E3EB948B_0B85_4F37_970A_DD334B343EE2#1161246, COL_77534C40_F008_4F9B_99A1_4982451B7A24#1161247, COL_AF30678A_46A6_422E_838A_452D36B65FC1#1161248, COL_29EA226E_C020_4D1F_A8DC_11FA4AB16409#1161249, COL_C3DFC75D_DBFD_47F3_B940_59BD461CA3C0#1161250, COL_7506CA9E_3DD1_4B12_8A2A_D2766532D59A#1161251, COL_64235A62_C014_4D54_98DA_329A3C835EDA#1161252, COL_76B3E933_F01E_4379_9153_B0E76D1633B5#1161253, COL_9AE6D4D7_A126_4880_B33C_1337A4899A8C#1161254, COL_9A5C81F5_9A6A_450B_AEBB_DB3516344104#1161255, COL_066BC6D4_55AA_434A_8BD9_1D16816DDDDA#1161256, COL_22D6710B_B7B5_4729_9BCB_202027CB0BD4#1161257, COL_6102ADDE_08E8_4710_9AD0_D2CA02BC21DE#1161258, COL_4A1DE469_43EB_4CAC_9134_3E477437431A#1161259, COL_7666BE37_7FEC_476C_B19D_F98892962E5D#1161260, COL_0BAF376F_F7D0_45AE_AEF9_8E19B504594E#1161261, COL_554D78B0_EA21_483D_B574_547426ADB482#1161262, COL_0B066C93_809D_4EB0_8ADF_3636D7B76593#1161263, COL_EB753D17_130C_4979_986B_D18FFF9DD40A#1161264, COL_0A7B71F1_4A2E_4EB3_A94C_939DCDA503B9#1161265, COL_3942BD61_7E90_4C5E_9240_75A61CE57789#1161266, COL_10C0E375_56E4_415A_AF3C_59B02B4E8408#1161267, COL_265D3814_0F5F_49EC_BEAE_386902F30D16#1161268, COL_D26072D1_60A6_4A96_B906_BE91ACB59614#1161269, COL_22A9E0BF_52D7_4815_A42C_BA2F7EDBB3C0#1161270, COL_3D1D7AA8_1BB1_46F0_8501_CDDDFE0E78BA#1161271, COL_2B27FA6E_B24E_4B22_8ACC_F3D028A40856#1161272, COL_80238879_541A_4F44_92A5_9926F6B94DB8#1161273, COL_621D957A_7A06_4745_964E_FE09BFFF8DB7#1161274, COL_34B3B671_24B2_4686_8CB9_962569FCA41D#1161275, COL_4FDAA229_CCB9_46CF_9F7E_A744CF47F572#1161276, COL_275DF47E_340B_4E55_A9F4_EDCC14A9627D#1161277, COL_7E77AF73_752C_48EE_856C_5C920DEA334B#1161278, COL_EC7C9040_E9DF_4E9F_BA9E_A1A6A0233AF9#1161279, COL_21232554_8AE3_4294_9504_876AA3A8D672#1161280, COL_C0597E1D_6B5A_4F8B_9564_EE724FCB06A6#1161281, COL_8806DAD5_E7F9_4288_9EF7_33FF7C7ABBFD#1161282, COL_5D701CFC_3360_465B_9BEE_24B4F9CA695B#1161283, COL_F0D25D20_CEE9_44DC_ADA4_FEB5CC21F368#1161284, COL_C18DDF33_5647_412B_B46F_605FB907BC20#1161285, COL_CFBEFC28_3BE8_4A12_8520_4056414B51FB#1161286, COL_8E05E990_9DCD_4946_810B_5D660C48B128#1161287, COL_C644CF67_72CA_452B_8B61_CFFAE6D90B0B#1161288, COL_968995BF_0BEB_4F9D_AB7B_2F70009B0383#1161289, COL_C931157E_CFBA_4535_B8F1_D3C29D1EFD77#1161290, COL_1BB74F82_ECBC_4133_AF56_13121C73FA5D#1161291, COL_77DF2687_0629_4378_B27F_E72E041D79EC#1161292, COL_BF828FB3_0BA8_4921_A6A5_07A65F79C8E0#1161293, COL_04822B1E_A0F2_4670_BDB2_507D07D8F3DE#1161294]
Arguments: hashpartitioning(COL_F36F08A6_928E_400F_B138_61F9B8D28AF3#1161244, 10), ENSURE_REQUIREMENTS, [plan_id=659160]

(5) ShuffleQueryStage
Output [54]: [COL_497B3BF1_A9CE_4411_8889_2F0461FEE049#1161241, COL_162F4FF6_9702_423C_8695_B193CBA6104D#1161242, COL_8DCB3027_3C9D_41AC_A59E_4DD19821C3A6#1161243, COL_F36F08A6_928E_400F_B138_61F9B8D28AF3#1161244, COL_A213E432_2691_4225_8DF4_C45A67AF4D9C#1161245, COL_E3EB948B_0B85_4F37_970A_DD334B343EE2#1161246, COL_77534C40_F008_4F9B_99A1_4982451B7A24#1161247, COL_AF30678A_46A6_422E_838A_452D36B65FC1#1161248, COL_29EA226E_C020_4D1F_A8DC_11FA4AB16409#1161249, COL_C3DFC75D_DBFD_47F3_B940_59BD461CA3C0#1161250, COL_7506CA9E_3DD1_4B12_8A2A_D2766532D59A#1161251, COL_64235A62_C014_4D54_98DA_329A3C835EDA#1161252, COL_76B3E933_F01E_4379_9153_B0E76D1633B5#1161253, COL_9AE6D4D7_A126_4880_B33C_1337A4899A8C#1161254, COL_9A5C81F5_9A6A_450B_AEBB_DB3516344104#1161255, COL_066BC6D4_55AA_434A_8BD9_1D16816DDDDA#1161256, COL_22D6710B_B7B5_4729_9BCB_202027CB0BD4#1161257, COL_6102ADDE_08E8_4710_9AD0_D2CA02BC21DE#1161258, COL_4A1DE469_43EB_4CAC_9134_3E477437431A#1161259, COL_7666BE37_7FEC_476C_B19D_F98892962E5D#1161260, COL_0BAF376F_F7D0_45AE_AEF9_8E19B504594E#1161261, COL_554D78B0_EA21_483D_B574_547426ADB482#1161262, COL_0B066C93_809D_4EB0_8ADF_3636D7B76593#1161263, COL_EB753D17_130C_4979_986B_D18FFF9DD40A#1161264, COL_0A7B71F1_4A2E_4EB3_A94C_939DCDA503B9#1161265, COL_3942BD61_7E90_4C5E_9240_75A61CE57789#1161266, COL_10C0E375_56E4_415A_AF3C_59B02B4E8408#1161267, COL_265D3814_0F5F_49EC_BEAE_386902F30D16#1161268, COL_D26072D1_60A6_4A96_B906_BE91ACB59614#1161269, COL_22A9E0BF_52D7_4815_A42C_BA2F7EDBB3C0#1161270, COL_3D1D7AA8_1BB1_46F0_8501_CDDDFE0E78BA#1161271, COL_2B27FA6E_B24E_4B22_8ACC_F3D028A40856#1161272, COL_80238879_541A_4F44_92A5_9926F6B94DB8#1161273, COL_621D957A_7A06_4745_964E_FE09BFFF8DB7#1161274, COL_34B3B671_24B2_4686_8CB9_962569FCA41D#1161275, COL_4FDAA229_CCB9_46CF_9F7E_A744CF47F572#1161276, COL_275DF47E_340B_4E55_A9F4_EDCC14A9627D#1161277, COL_7E77AF73_752C_48EE_856C_5C920DEA334B#1161278, COL_EC7C9040_E9DF_4E9F_BA9E_A1A6A0233AF9#1161279, COL_21232554_8AE3_4294_9504_876AA3A8D672#1161280, COL_C0597E1D_6B5A_4F8B_9564_EE724FCB06A6#1161281, COL_8806DAD5_E7F9_4288_9EF7_33FF7C7ABBFD#1161282, COL_5D701CFC_3360_465B_9BEE_24B4F9CA695B#1161283, COL_F0D25D20_CEE9_44DC_ADA4_FEB5CC21F368#1161284, COL_C18DDF33_5647_412B_B46F_605FB907BC20#1161285, COL_CFBEFC28_3BE8_4A12_8520_4056414B51FB#1161286, COL_8E05E990_9DCD_4946_810B_5D660C48B128#1161287, COL_C644CF67_72CA_452B_8B61_CFFAE6D90B0B#1161288, COL_968995BF_0BEB_4F9D_AB7B_2F70009B0383#1161289, COL_C931157E_CFBA_4535_B8F1_D3C29D1EFD77#1161290, COL_1BB74F82_ECBC_4133_AF56_13121C73FA5D#1161291, COL_77DF2687_0629_4378_B27F_E72E041D79EC#1161292, COL_BF828FB3_0BA8_4921_A6A5_07A65F79C8E0#1161293, COL_04822B1E_A0F2_4670_BDB2_507D07D8F3DE#1161294]
Arguments: 0

(6) Project [codegen id : 3]
Output [57]: [COL_497B3BF1_A9CE_4411_8889_2F0461FEE049#1161241, COL_162F4FF6_9702_423C_8695_B193CBA6104D#1161242, COL_8DCB3027_3C9D_41AC_A59E_4DD19821C3A6#1161243, COL_F36F08A6_928E_400F_B138_61F9B8D28AF3#1161244, COL_A213E432_2691_4225_8DF4_C45A67AF4D9C#1161245, COL_E3EB948B_0B85_4F37_970A_DD334B343EE2#1161246, COL_77534C40_F008_4F9B_99A1_4982451B7A24#1161247, COL_AF30678A_46A6_422E_838A_452D36B65FC1#1161248, COL_29EA226E_C020_4D1F_A8DC_11FA4AB16409#1161249, COL_C3DFC75D_DBFD_47F3_B940_59BD461CA3C0#1161250, COL_7506CA9E_3DD1_4B12_8A2A_D2766532D59A#1161251, COL_64235A62_C014_4D54_98DA_329A3C835EDA#1161252, COL_76B3E933_F01E_4379_9153_B0E76D1633B5#1161253, COL_9AE6D4D7_A126_4880_B33C_1337A4899A8C#1161254, COL_9A5C81F5_9A6A_450B_AEBB_DB3516344104#1161255, COL_066BC6D4_55AA_434A_8BD9_1D16816DDDDA#1161256, COL_22D6710B_B7B5_4729_9BCB_202027CB0BD4#1161257, COL_6102ADDE_08E8_4710_9AD0_D2CA02BC21DE#1161258, COL_4A1DE469_43EB_4CAC_9134_3E477437431A#1161259, COL_7666BE37_7FEC_476C_B19D_F98892962E5D#1161260, COL_0BAF376F_F7D0_45AE_AEF9_8E19B504594E#1161261, COL_554D78B0_EA21_483D_B574_547426ADB482#1161262, COL_0B066C93_809D_4EB0_8ADF_3636D7B76593#1161263, COL_EB753D17_130C_4979_986B_D18FFF9DD40A#1161264, COL_0A7B71F1_4A2E_4EB3_A94C_939DCDA503B9#1161265, COL_3942BD61_7E90_4C5E_9240_75A61CE57789#1161266, COL_10C0E375_56E4_415A_AF3C_59B02B4E8408#1161267, COL_265D3814_0F5F_49EC_BEAE_386902F30D16#1161268, COL_D26072D1_60A6_4A96_B906_BE91ACB59614#1161269, COL_22A9E0BF_52D7_4815_A42C_BA2F7EDBB3C0#1161270, COL_3D1D7AA8_1BB1_46F0_8501_CDDDFE0E78BA#1161271, COL_2B27FA6E_B24E_4B22_8ACC_F3D028A40856#1161272, COL_80238879_541A_4F44_92A5_9926F6B94DB8#1161273, COL_621D957A_7A06_4745_964E_FE09BFFF8DB7#1161274, COL_34B3B671_24B2_4686_8CB9_962569FCA41D#1161275, COL_4FDAA229_CCB9_46CF_9F7E_A744CF47F572#1161276, COL_275DF47E_340B_4E55_A9F4_EDCC14A9627D#1161277, COL_7E77AF73_752C_48EE_856C_5C920DEA334B#1161278, COL_EC7C9040_E9DF_4E9F_BA9E_A1A6A0233AF9#1161279, COL_21232554_8AE3_4294_9504_876AA3A8D672#1161280, COL_C0597E1D_6B5A_4F8B_9564_EE724FCB06A6#1161281, COL_8806DAD5_E7F9_4288_9EF7_33FF7C7ABBFD#1161282, COL_5D701CFC_3360_465B_9BEE_24B4F9CA695B#1161283, COL_F0D25D20_CEE9_44DC_ADA4_FEB5CC21F368#1161284, COL_C18DDF33_5647_412B_B46F_605FB907BC20#1161285, COL_CFBEFC28_3BE8_4A12_8520_4056414B51FB#1161286, COL_8E05E990_9DCD_4946_810B_5D660C48B128#1161287, COL_C644CF67_72CA_452B_8B61_CFFAE6D90B0B#1161288, COL_968995BF_0BEB_4F9D_AB7B_2F70009B0383#1161289, COL_C931157E_CFBA_4535_B8F1_D3C29D1EFD77#1161290, COL_1BB74F82_ECBC_4133_AF56_13121C73FA5D#1161291, COL_77DF2687_0629_4378_B27F_E72E041D79EC#1161292, COL_BF828FB3_0BA8_4921_A6A5_07A65F79C8E0#1161293, COL_04822B1E_A0F2_4670_BDB2_507D07D8F3DE#1161294, cast(null as double) AS 06_COMPILATION__172800_COL_E38AB62F_E896_4A72_BE7E_515F8BC641C6#1161377, cast(null as int) AS 06_COMPILATION__172800_COL_A2516838_D999_49FB_A245_E9F9B72D742A#1161381, cast(null as double) AS 06_COMPILATION__172800_COL_8EA5D1BB_B903_4AA6_811C_01F4D36D9299#1161382]
Input [54]: [COL_497B3BF1_A9CE_4411_8889_2F0461FEE049#1161241, COL_162F4FF6_9702_423C_8695_B193CBA6104D#1161242, COL_8DCB3027_3C9D_41AC_A59E_4DD19821C3A6#1161243, COL_F36F08A6_928E_400F_B138_61F9B8D28AF3#1161244, COL_A213E432_2691_4225_8DF4_C45A67AF4D9C#1161245, COL_E3EB948B_0B85_4F37_970A_DD334B343EE2#1161246, COL_77534C40_F008_4F9B_99A1_4982451B7A24#1161247, COL_AF30678A_46A6_422E_838A_452D36B65FC1#1161248, COL_29EA226E_C020_4D1F_A8DC_11FA4AB16409#1161249, COL_C3DFC75D_DBFD_47F3_B940_59BD461CA3C0#1161250, COL_7506CA9E_3DD1_4B12_8A2A_D2766532D59A#1161251, COL_64235A62_C014_4D54_98DA_329A3C835EDA#1161252, COL_76B3E933_F01E_4379_9153_B0E76D1633B5#1161253, COL_9AE6D4D7_A126_4880_B33C_1337A4899A8C#1161254, COL_9A5C81F5_9A6A_450B_AEBB_DB3516344104#1161255, COL_066BC6D4_55AA_434A_8BD9_1D16816DDDDA#1161256, COL_22D6710B_B7B5_4729_9BCB_202027CB0BD4#1161257, COL_6102ADDE_08E8_4710_9AD0_D2CA02BC21DE#1161258, COL_4A1DE469_43EB_4CAC_9134_3E477437431A#1161259, COL_7666BE37_7FEC_476C_B19D_F98892962E5D#1161260, COL_0BAF376F_F7D0_45AE_AEF9_8E19B504594E#1161261, COL_554D78B0_EA21_483D_B574_547426ADB482#1161262, COL_0B066C93_809D_4EB0_8ADF_3636D7B76593#1161263, COL_EB753D17_130C_4979_986B_D18FFF9DD40A#1161264, COL_0A7B71F1_4A2E_4EB3_A94C_939DCDA503B9#1161265, COL_3942BD61_7E90_4C5E_9240_75A61CE57789#1161266, COL_10C0E375_56E4_415A_AF3C_59B02B4E8408#1161267, COL_265D3814_0F5F_49EC_BEAE_386902F30D16#1161268, COL_D26072D1_60A6_4A96_B906_BE91ACB59614#1161269, COL_22A9E0BF_52D7_4815_A42C_BA2F7EDBB3C0#1161270, COL_3D1D7AA8_1BB1_46F0_8501_CDDDFE0E78BA#1161271, COL_2B27FA6E_B24E_4B22_8ACC_F3D028A40856#1161272, COL_80238879_541A_4F44_92A5_9926F6B94DB8#1161273, COL_621D957A_7A06_4745_964E_FE09BFFF8DB7#1161274, COL_34B3B671_24B2_4686_8CB9_962569FCA41D#1161275, COL_4FDAA229_CCB9_46CF_9F7E_A744CF47F572#1161276, COL_275DF47E_340B_4E55_A9F4_EDCC14A9627D#1161277, COL_7E77AF73_752C_48EE_856C_5C920DEA334B#1161278, COL_EC7C9040_E9DF_4E9F_BA9E_A1A6A0233AF9#1161279, COL_21232554_8AE3_4294_9504_876AA3A8D672#1161280, COL_C0597E1D_6B5A_4F8B_9564_EE724FCB06A6#1161281, COL_8806DAD5_E7F9_4288_9EF7_33FF7C7ABBFD#1161282, COL_5D701CFC_3360_465B_9BEE_24B4F9CA695B#1161283, COL_F0D25D20_CEE9_44DC_ADA4_FEB5CC21F368#1161284, COL_C18DDF33_5647_412B_B46F_605FB907BC20#1161285, COL_CFBEFC28_3BE8_4A12_8520_4056414B51FB#1161286, COL_8E05E990_9DCD_4946_810B_5D660C48B128#1161287, COL_C644CF67_72CA_452B_8B61_CFFAE6D90B0B#1161288, COL_968995BF_0BEB_4F9D_AB7B_2F70009B0383#1161289, COL_C931157E_CFBA_4535_B8F1_D3C29D1EFD77#1161290, COL_1BB74F82_ECBC_4133_AF56_13121C73FA5D#1161291, COL_77DF2687_0629_4378_B27F_E72E041D79EC#1161292, COL_BF828FB3_0BA8_4921_A6A5_07A65F79C8E0#1161293, COL_04822B1E_A0F2_4670_BDB2_507D07D8F3DE#1161294]

(7) Project [codegen id : 3]
Output [57]: [COL_497B3BF1_A9CE_4411_8889_2F0461FEE049#1161241, COL_162F4FF6_9702_423C_8695_B193CBA6104D#1161242, COL_8DCB3027_3C9D_41AC_A59E_4DD19821C3A6#1161243, COL_F36F08A6_928E_400F_B138_61F9B8D28AF3#1161244, COL_A213E432_2691_4225_8DF4_C45A67AF4D9C#1161245, COL_E3EB948B_0B85_4F37_970A_DD334B343EE2#1161246, COL_77534C40_F008_4F9B_99A1_4982451B7A24#1161247, COL_AF30678A_46A6_422E_838A_452D36B65FC1#1161248, COL_29EA226E_C020_4D1F_A8DC_11FA4AB16409#1161249, COL_C3DFC75D_DBFD_47F3_B940_59BD461CA3C0#1161250, COL_7506CA9E_3DD1_4B12_8A2A_D2766532D59A#1161251, COL_64235A62_C014_4D54_98DA_329A3C835EDA#1161252, COL_76B3E933_F01E_4379_9153_B0E76D1633B5#1161253, COL_9AE6D4D7_A126_4880_B33C_1337A4899A8C#1161254, COL_9A5C81F5_9A6A_450B_AEBB_DB3516344104#1161255, COL_066BC6D4_55AA_434A_8BD9_1D16816DDDDA#1161256, COL_22D6710B_B7B5_4729_9BCB_202027CB0BD4#1161257, COL_6102ADDE_08E8_4710_9AD0_D2CA02BC21DE#1161258, COL_4A1DE469_43EB_4CAC_9134_3E477437431A#1161259, COL_7666BE37_7FEC_476C_B19D_F98892962E5D#1161260, COL_0BAF376F_F7D0_45AE_AEF9_8E19B504594E#1161261, COL_554D78B0_EA21_483D_B574_547426ADB482#1161262, COL_0B066C93_809D_4EB0_8ADF_3636D7B76593#1161263, COL_EB753D17_130C_4979_986B_D18FFF9DD40A#1161264, COL_0A7B71F1_4A2E_4EB3_A94C_939DCDA503B9#1161265, COL_3942BD61_7E90_4C5E_9240_75A61CE57789#1161266, COL_10C0E375_56E4_415A_AF3C_59B02B4E8408#1161267, COL_265D3814_0F5F_49EC_BEAE_386902F30D16#1161268, COL_D26072D1_60A6_4A96_B906_BE91ACB59614#1161269, COL_22A9E0BF_52D7_4815_A42C_BA2F7EDBB3C0#1161270, COL_3D1D7AA8_1BB1_46F0_8501_CDDDFE0E78BA#1161271, COL_2B27FA6E_B24E_4B22_8ACC_F3D028A40856#1161272, COL_80238879_541A_4F44_92A5_9926F6B94DB8#1161273, COL_621D957A_7A06_4745_964E_FE09BFFF8DB7#1161274, COL_34B3B671_24B2_4686_8CB9_962569FCA41D#1161275, COL_4FDAA229_CCB9_46CF_9F7E_A744CF47F572#1161276, COL_275DF47E_340B_4E55_A9F4_EDCC14A9627D#1161277, COL_7E77AF73_752C_48EE_856C_5C920DEA334B#1161278, COL_EC7C9040_E9DF_4E9F_BA9E_A1A6A0233AF9#1161279, COL_21232554_8AE3_4294_9504_876AA3A8D672#1161280, COL_C0597E1D_6B5A_4F8B_9564_EE724FCB06A6#1161281, COL_8806DAD5_E7F9_4288_9EF7_33FF7C7ABBFD#1161282, COL_5D701CFC_3360_465B_9BEE_24B4F9CA695B#1161283, COL_F0D25D20_CEE9_44DC_ADA4_FEB5CC21F368#1161284, COL_C18DDF33_5647_412B_B46F_605FB907BC20#1161285, COL_CFBEFC28_3BE8_4A12_8520_4056414B51FB#1161286, COL_8E05E990_9DCD_4946_810B_5D660C48B128#1161287, COL_C644CF67_72CA_452B_8B61_CFFAE6D90B0B#1161288, COL_968995BF_0BEB_4F9D_AB7B_2F70009B0383#1161289, COL_C931157E_CFBA_4535_B8F1_D3C29D1EFD77#1161290, COL_1BB74F82_ECBC_4133_AF56_13121C73FA5D#1161291, COL_77DF2687_0629_4378_B27F_E72E041D79EC#1161292, COL_BF828FB3_0BA8_4921_A6A5_07A65F79C8E0#1161293, COL_04822B1E_A0F2_4670_BDB2_507D07D8F3DE#1161294, 06_COMPILATION__172800_COL_E38AB62F_E896_4A72_BE7E_515F8BC641C6#1161377 AS COL_36411CB9_EA90_4CC8_9DF1_BF8D8F09879E#1161936, str_if_with_rule(isnotnull(06_COMPILATION__172800_COL_E38AB62F_E896_4A72_BE7E_515F8BC641C6#1161377), 1, 0) AS COL_BD3E04C0_8EA0_45E3_B543_6A416F1B68FC#1161937, 06_COMPILATION__172800_COL_8EA5D1BB_B903_4AA6_811C_01F4D36D9299#1161382 AS COL_415D2D73_010E_4929_AF07_08F5C67C77B2#1161938]
Input [57]: [COL_497B3BF1_A9CE_4411_8889_2F0461FEE049#1161241, COL_162F4FF6_9702_423C_8695_B193CBA6104D#1161242, COL_8DCB3027_3C9D_41AC_A59E_4DD19821C3A6#1161243, COL_F36F08A6_928E_400F_B138_61F9B8D28AF3#1161244, COL_A213E432_2691_4225_8DF4_C45A67AF4D9C#1161245, COL_E3EB948B_0B85_4F37_970A_DD334B343EE2#1161246, COL_77534C40_F008_4F9B_99A1_4982451B7A24#1161247, COL_AF30678A_46A6_422E_838A_452D36B65FC1#1161248, COL_29EA226E_C020_4D1F_A8DC_11FA4AB16409#1161249, COL_C3DFC75D_DBFD_47F3_B940_59BD461CA3C0#1161250, COL_7506CA9E_3DD1_4B12_8A2A_D2766532D59A#1161251, COL_64235A62_C014_4D54_98DA_329A3C835EDA#1161252, COL_76B3E933_F01E_4379_9153_B0E76D1633B5#1161253, COL_9AE6D4D7_A126_4880_B33C_1337A4899A8C#1161254, COL_9A5C81F5_9A6A_450B_AEBB_DB3516344104#1161255, COL_066BC6D4_55AA_434A_8BD9_1D16816DDDDA#1161256, COL_22D6710B_B7B5_4729_9BCB_202027CB0BD4#1161257, COL_6102ADDE_08E8_4710_9AD0_D2CA02BC21DE#1161258, COL_4A1DE469_43EB_4CAC_9134_3E477437431A#1161259, COL_7666BE37_7FEC_476C_B19D_F98892962E5D#1161260, COL_0BAF376F_F7D0_45AE_AEF9_8E19B504594E#1161261, COL_554D78B0_EA21_483D_B574_547426ADB482#1161262, COL_0B066C93_809D_4EB0_8ADF_3636D7B76593#1161263, COL_EB753D17_130C_4979_986B_D18FFF9DD40A#1161264, COL_0A7B71F1_4A2E_4EB3_A94C_939DCDA503B9#1161265, COL_3942BD61_7E90_4C5E_9240_75A61CE57789#1161266, COL_10C0E375_56E4_415A_AF3C_59B02B4E8408#1161267, COL_265D3814_0F5F_49EC_BEAE_386902F30D16#1161268, COL_D26072D1_60A6_4A96_B906_BE91ACB59614#1161269, COL_22A9E0BF_52D7_4815_A42C_BA2F7EDBB3C0#1161270, COL_3D1D7AA8_1BB1_46F0_8501_CDDDFE0E78BA#1161271, COL_2B27FA6E_B24E_4B22_8ACC_F3D028A40856#1161272, COL_80238879_541A_4F44_92A5_9926F6B94DB8#1161273, COL_621D957A_7A06_4745_964E_FE09BFFF8DB7#1161274, COL_34B3B671_24B2_4686_8CB9_962569FCA41D#1161275, COL_4FDAA229_CCB9_46CF_9F7E_A744CF47F572#1161276, COL_275DF47E_340B_4E55_A9F4_EDCC14A9627D#1161277, COL_7E77AF73_752C_48EE_856C_5C920DEA334B#1161278, COL_EC7C9040_E9DF_4E9F_BA9E_A1A6A0233AF9#1161279, COL_21232554_8AE3_4294_9504_876AA3A8D672#1161280, COL_C0597E1D_6B5A_4F8B_9564_EE724FCB06A6#1161281, COL_8806DAD5_E7F9_4288_9EF7_33FF7C7ABBFD#1161282, COL_5D701CFC_3360_465B_9BEE_24B4F9CA695B#1161283, COL_F0D25D20_CEE9_44DC_ADA4_FEB5CC21F368#1161284, COL_C18DDF33_5647_412B_B46F_605FB907BC20#1161285, COL_CFBEFC28_3BE8_4A12_8520_4056414B51FB#1161286, COL_8E05E990_9DCD_4946_810B_5D660C48B128#1161287, COL_C644CF67_72CA_452B_8B61_CFFAE6D90B0B#1161288, COL_968995BF_0BEB_4F9D_AB7B_2F70009B0383#1161289, COL_C931157E_CFBA_4535_B8F1_D3C29D1EFD77#1161290, COL_1BB74F82_ECBC_4133_AF56_13121C73FA5D#1161291, COL_77DF2687_0629_4378_B27F_E72E041D79EC#1161292, COL_BF828FB3_0BA8_4921_A6A5_07A65F79C8E0#1161293, COL_04822B1E_A0F2_4670_BDB2_507D07D8F3DE#1161294, 06_COMPILATION__172800_COL_E38AB62F_E896_4A72_BE7E_515F8BC641C6#1161377, 06_COMPILATION__172800_COL_A2516838_D999_49FB_A245_E9F9B72D742A#1161381, 06_COMPILATION__172800_COL_8EA5D1BB_B903_4AA6_811C_01F4D36D9299#1161382]

(8) WriteFiles
Input [57]: [COL_497B3BF1_A9CE_4411_8889_2F0461FEE049#1161241, COL_162F4FF6_9702_423C_8695_B193CBA6104D#1161242, COL_8DCB3027_3C9D_41AC_A59E_4DD19821C3A6#1161243, COL_F36F08A6_928E_400F_B138_61F9B8D28AF3#1161244, COL_A213E432_2691_4225_8DF4_C45A67AF4D9C#1161245, COL_E3EB948B_0B85_4F37_970A_DD334B343EE2#1161246, COL_77534C40_F008_4F9B_99A1_4982451B7A24#1161247, COL_AF30678A_46A6_422E_838A_452D36B65FC1#1161248, COL_29EA226E_C020_4D1F_A8DC_11FA4AB16409#1161249, COL_C3DFC75D_DBFD_47F3_B940_59BD461CA3C0#1161250, COL_7506CA9E_3DD1_4B12_8A2A_D2766532D59A#1161251, COL_64235A62_C014_4D54_98DA_329A3C835EDA#1161252, COL_76B3E933_F01E_4379_9153_B0E76D1633B5#1161253, COL_9AE6D4D7_A126_4880_B33C_1337A4899A8C#1161254, COL_9A5C81F5_9A6A_450B_AEBB_DB3516344104#1161255, COL_066BC6D4_55AA_434A_8BD9_1D16816DDDDA#1161256, COL_22D6710B_B7B5_4729_9BCB_202027CB0BD4#1161257, COL_6102ADDE_08E8_4710_9AD0_D2CA02BC21DE#1161258, COL_4A1DE469_43EB_4CAC_9134_3E477437431A#1161259, COL_7666BE37_7FEC_476C_B19D_F98892962E5D#1161260, COL_0BAF376F_F7D0_45AE_AEF9_8E19B504594E#1161261, COL_554D78B0_EA21_483D_B574_547426ADB482#1161262, COL_0B066C93_809D_4EB0_8ADF_3636D7B76593#1161263, COL_EB753D17_130C_4979_986B_D18FFF9DD40A#1161264, COL_0A7B71F1_4A2E_4EB3_A94C_939DCDA503B9#1161265, COL_3942BD61_7E90_4C5E_9240_75A61CE57789#1161266, COL_10C0E375_56E4_415A_AF3C_59B02B4E8408#1161267, COL_265D3814_0F5F_49EC_BEAE_386902F30D16#1161268, COL_D26072D1_60A6_4A96_B906_BE91ACB59614#1161269, COL_22A9E0BF_52D7_4815_A42C_BA2F7EDBB3C0#1161270, COL_3D1D7AA8_1BB1_46F0_8501_CDDDFE0E78BA#1161271, COL_2B27FA6E_B24E_4B22_8ACC_F3D028A40856#1161272, COL_80238879_541A_4F44_92A5_9926F6B94DB8#1161273, COL_621D957A_7A06_4745_964E_FE09BFFF8DB7#1161274, COL_34B3B671_24B2_4686_8CB9_962569FCA41D#1161275, COL_4FDAA229_CCB9_46CF_9F7E_A744CF47F572#1161276, COL_275DF47E_340B_4E55_A9F4_EDCC14A9627D#1161277, COL_7E77AF73_752C_48EE_856C_5C920DEA334B#1161278, COL_EC7C9040_E9DF_4E9F_BA9E_A1A6A0233AF9#1161279, COL_21232554_8AE3_4294_9504_876AA3A8D672#1161280, COL_C0597E1D_6B5A_4F8B_9564_EE724FCB06A6#1161281, COL_8806DAD5_E7F9_4288_9EF7_33FF7C7ABBFD#1161282, COL_5D701CFC_3360_465B_9BEE_24B4F9CA695B#1161283, COL_F0D25D20_CEE9_44DC_ADA4_FEB5CC21F368#1161284, COL_C18DDF33_5647_412B_B46F_605FB907BC20#1161285, COL_CFBEFC28_3BE8_4A12_8520_4056414B51FB#1161286, COL_8E05E990_9DCD_4946_810B_5D660C48B128#1161287, COL_C644CF67_72CA_452B_8B61_CFFAE6D90B0B#1161288, COL_968995BF_0BEB_4F9D_AB7B_2F70009B0383#1161289, COL_C931157E_CFBA_4535_B8F1_D3C29D1EFD77#1161290, COL_1BB74F82_ECBC_4133_AF56_13121C73FA5D#1161291, COL_77DF2687_0629_4378_B27F_E72E041D79EC#1161292, COL_BF828FB3_0BA8_4921_A6A5_07A65F79C8E0#1161293, COL_04822B1E_A0F2_4670_BDB2_507D07D8F3DE#1161294, COL_36411CB9_EA90_4CC8_9DF1_BF8D8F09879E#1161936, COL_BD3E04C0_8EA0_45E3_B543_6A416F1B68FC#1161937, COL_415D2D73_010E_4929_AF07_08F5C67C77B2#1161938]

(9) Execute InsertIntoHadoopFsRelationCommand
Input: []
Arguments: file:/data/output/cache/parquet/datablock/09_A_TTT_SUPLIG_172632, false, Parquet, [path=file:///data/output/cache/parquet/datablock/09_A_TTT_SUPLIG_172632], Overwrite, [COL_497B3BF1_A9CE_4411_8889_2F0461FEE049, COL_162F4FF6_9702_423C_8695_B193CBA6104D, 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, ... 33 more fields]

(10) Project
Output [54]: [COL_4ECA949F_2DA4_41C5_80E1_520DEFC8D1EA#1160809 AS COL_497B3BF1_A9CE_4411_8889_2F0461FEE049#1161241, COL_D14F6518_D1F3_4F18_93EC_DEF8E6712184#1160810 AS COL_162F4FF6_9702_423C_8695_B193CBA6104D#1161242, COL_F522EF71_EF5D_46C0_B0EC_B3EB638B97F7#1160811 AS COL_8DCB3027_3C9D_41AC_A59E_4DD19821C3A6#1161243, COL_CEFA2472_1E3F_469C_9633_864540C40AD9#1160812 AS COL_F36F08A6_928E_400F_B138_61F9B8D28AF3#1161244, COL_1DDA21A4_0127_416B_A5DB_7EDD9CC61B56#1160813 AS COL_A213E432_2691_4225_8DF4_C45A67AF4D9C#1161245, COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#1160814 AS COL_E3EB948B_0B85_4F37_970A_DD334B343EE2#1161246, COL_0521CAB9_7617_4F31_948E_95DCA16387D7#1160815 AS COL_77534C40_F008_4F9B_99A1_4982451B7A24#1161247, COL_1DACB81E_AFA5_4BB8_83D7_57DE8B8062B7#1160816 AS COL_AF30678A_46A6_422E_838A_452D36B65FC1#1161248, COL_9262BBED_C393_416D_B38C_8F1458965BA7#1160817 AS COL_29EA226E_C020_4D1F_A8DC_11FA4AB16409#1161249, COL_F76265AB_8748_4114_92B4_00E37DE25D34#1160818 AS COL_C3DFC75D_DBFD_47F3_B940_59BD461CA3C0#1161250, COL_96E2282E_0771_460E_8BDB_D11261BD9020#1160819 AS COL_7506CA9E_3DD1_4B12_8A2A_D2766532D59A#1161251, COL_12028397_66B1_4E3C_BBDB_64537606E7DE#1160820 AS COL_64235A62_C014_4D54_98DA_329A3C835EDA#1161252, COL_580D5890_2839_4108_A636_8E25F97E50E0#1160821 AS COL_76B3E933_F01E_4379_9153_B0E76D1633B5#1161253, COL_3AFB6BB7_7AA1_4D16_AE24_4CB203A67B51#1160822 AS COL_9AE6D4D7_A126_4880_B33C_1337A4899A8C#1161254, COL_2C09E3B7_4086_45D3_8676_F1D58494C2DD#1160823 AS COL_9A5C81F5_9A6A_450B_AEBB_DB3516344104#1161255, COL_4473F770_A575_4100_97F6_8190F900749A#1160824 AS COL_066BC6D4_55AA_434A_8BD9_1D16816DDDDA#1161256, COL_715B3479_EAD2_422C_BF5C_7B020197D946#1160825 AS COL_22D6710B_B7B5_4729_9BCB_202027CB0BD4#1161257, COL_B41952EB_DE3F_4899_8A04_46EF55D519D3#1160826 AS COL_6102ADDE_08E8_4710_9AD0_D2CA02BC21DE#1161258, COL_13C7079E_53C2_4945_BB83_A9CBB5596CA7#1160827 AS COL_4A1DE469_43EB_4CAC_9134_3E477437431A#1161259, COL_1DD27485_A759_457B_BE67_EC6813E5F6C7#1160828 AS COL_7666BE37_7FEC_476C_B19D_F98892962E5D#1161260, COL_5F21C9DE_C72B_4C4D_A042_7C2B1C8E43BD#1160829 AS COL_0BAF376F_F7D0_45AE_AEF9_8E19B504594E#1161261, COL_97360DFB_D20B_4DFF_A68A_57C41867D04E#1160830 AS COL_554D78B0_EA21_483D_B574_547426ADB482#1161262, COL_8F13405A_6271_4B4F_BE3D_AFBE0E624AFC#1160831 AS COL_0B066C93_809D_4EB0_8ADF_3636D7B76593#1161263, COL_390B6626_6008_4E32_942E_6ED08B69626F#1160832 AS COL_EB753D17_130C_4979_986B_D18FFF9DD40A#1161264, COL_CD30424F_E1B5_4038_9F6F_A6119868B45C#1160833 AS COL_0A7B71F1_4A2E_4EB3_A94C_939DCDA503B9#1161265, COL_2B738BBE_CFA2_41EB_9490_76129BDDA7D3#1160834 AS COL_3942BD61_7E90_4C5E_9240_75A61CE57789#1161266, COL_869EE117_A1AF_4643_9C63_B2E044E76011#1160835 AS COL_10C0E375_56E4_415A_AF3C_59B02B4E8408#1161267, COL_2DEF4579_4198_4381_9794_0850D509C4D9#1160836 AS COL_265D3814_0F5F_49EC_BEAE_386902F30D16#1161268, COL_28DD75A8_B9B0_41E0_B8DE_4C1D788339EF#1160837 AS COL_D26072D1_60A6_4A96_B906_BE91ACB59614#1161269, COL_5143601C_5C8F_46DA_8653_3EFEB2EE859D#1160838 AS COL_22A9E0BF_52D7_4815_A42C_BA2F7EDBB3C0#1161270, COL_603BA3E4_9B75_44D5_A914_615FAE0C5436#1160839 AS COL_3D1D7AA8_1BB1_46F0_8501_CDDDFE0E78BA#1161271, COL_50D051CB_B5A3_4A22_99CF_B636DE0B08A4#1160840 AS COL_2B27FA6E_B24E_4B22_8ACC_F3D028A40856#1161272, COL_B2D69078_23A7_4B36_BBF2_3F9C29840464#1160841 AS COL_80238879_541A_4F44_92A5_9926F6B94DB8#1161273, COL_47A73BC1_4566_45A9_8162_7B6B9E438C8D#1160842 AS COL_621D957A_7A06_4745_964E_FE09BFFF8DB7#1161274, COL_91F5095A_FAAE_4325_81BC_62ABDD788E8D#1160843 AS COL_34B3B671_24B2_4686_8CB9_962569FCA41D#1161275, COL_394590C1_A817_4CDB_80AC_456AA6E27DEA#1160844 AS COL_4FDAA229_CCB9_46CF_9F7E_A744CF47F572#1161276, COL_011EF34A_6883_4296_BBBF_AC60A68C84DD#1160845 AS COL_275DF47E_340B_4E55_A9F4_EDCC14A9627D#1161277, COL_C1F37338_7743_4434_879A_FF32C1BC5112#1160846 AS COL_7E77AF73_752C_48EE_856C_5C920DEA334B#1161278, COL_FAEC3B31_0447_4E4B_B8EC_83794AF975DD#1160847 AS COL_EC7C9040_E9DF_4E9F_BA9E_A1A6A0233AF9#1161279, COL_FF5E7CF3_75CA_45FF_AA0E_98474CEB50C2#1160848 AS COL_21232554_8AE3_4294_9504_876AA3A8D672#1161280, COL_6B0E2B89_AC1D_411B_A0AB_19B2CEF8CFC9#1160849 AS COL_C0597E1D_6B5A_4F8B_9564_EE724FCB06A6#1161281, COL_D7508510_B4D7_44C5_A063_A2132B6EF08A#1160850 AS COL_8806DAD5_E7F9_4288_9EF7_33FF7C7ABBFD#1161282, COL_EAA75683_8CB4_4075_AA4A_FACAF98EBD6E#1160851 AS COL_5D701CFC_3360_465B_9BEE_24B4F9CA695B#1161283, COL_B8D0B7A4_71CB_4406_88C1_4791F02E29EF#1160852 AS COL_F0D25D20_CEE9_44DC_ADA4_FEB5CC21F368#1161284, COL_AA499A88_B893_47E4_99C5_0EB9F6D69842#1160853 AS COL_C18DDF33_5647_412B_B46F_605FB907BC20#1161285, COL_95383EBC_3648_4E94_9C53_D311092BF5F4#1160854 AS COL_CFBEFC28_3BE8_4A12_8520_4056414B51FB#1161286, COL_7DC2A78A_5ED5_4908_AC94_0885B83B98CD#1160855 AS COL_8E05E990_9DCD_4946_810B_5D660C48B128#1161287, COL_383EDE50_7CF9_4E24_A70F_BA7CD5C9D6BA#1160856 AS COL_C644CF67_72CA_452B_8B61_CFFAE6D90B0B#1161288, COL_585F8C49_925B_4809_B445_C6A91423BA50#1160857 AS COL_968995BF_0BEB_4F9D_AB7B_2F70009B0383#1161289, COL_E7D4B3BC_F96E_4431_BC95_1D1CCE75D846#1160858 AS COL_C931157E_CFBA_4535_B8F1_D3C29D1EFD77#1161290, COL_B057EBBF_57E7_449C_9DE3_CD56F041B86B#1160859 AS COL_1BB74F82_ECBC_4133_AF56_13121C73FA5D#1161291, COL_B8D74F46_C755_4417_9E18_FAA760CD8457#1160860 AS COL_77DF2687_0629_4378_B27F_E72E041D79EC#1161292, COL_51335C75_C8A9_4932_8985_BA9E68B80F3A#1160861 AS COL_BF828FB3_0BA8_4921_A6A5_07A65F79C8E0#1161293, COL_03AE34A5_99F1_4525_9BD2_BF7BAFE47F5C#1160862 AS COL_04822B1E_A0F2_4670_BDB2_507D07D8F3DE#1161294]
Input [54]: [COL_4ECA949F_2DA4_41C5_80E1_520DEFC8D1EA#1160809, COL_D14F6518_D1F3_4F18_93EC_DEF8E6712184#1160810, COL_F522EF71_EF5D_46C0_B0EC_B3EB638B97F7#1160811, COL_CEFA2472_1E3F_469C_9633_864540C40AD9#1160812, COL_1DDA21A4_0127_416B_A5DB_7EDD9CC61B56#1160813, COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#1160814, COL_0521CAB9_7617_4F31_948E_95DCA16387D7#1160815, COL_1DACB81E_AFA5_4BB8_83D7_57DE8B8062B7#1160816, COL_9262BBED_C393_416D_B38C_8F1458965BA7#1160817, COL_F76265AB_8748_4114_92B4_00E37DE25D34#1160818, COL_96E2282E_0771_460E_8BDB_D11261BD9020#1160819, COL_12028397_66B1_4E3C_BBDB_64537606E7DE#1160820, COL_580D5890_2839_4108_A636_8E25F97E50E0#1160821, COL_3AFB6BB7_7AA1_4D16_AE24_4CB203A67B51#1160822, COL_2C09E3B7_4086_45D3_8676_F1D58494C2DD#1160823, COL_4473F770_A575_4100_97F6_8190F900749A#1160824, COL_715B3479_EAD2_422C_BF5C_7B020197D946#1160825, COL_B41952EB_DE3F_4899_8A04_46EF55D519D3#1160826, COL_13C7079E_53C2_4945_BB83_A9CBB5596CA7#1160827, COL_1DD27485_A759_457B_BE67_EC6813E5F6C7#1160828, COL_5F21C9DE_C72B_4C4D_A042_7C2B1C8E43BD#1160829, COL_97360DFB_D20B_4DFF_A68A_57C41867D04E#1160830, COL_8F13405A_6271_4B4F_BE3D_AFBE0E624AFC#1160831, COL_390B6626_6008_4E32_942E_6ED08B69626F#1160832, COL_CD30424F_E1B5_4038_9F6F_A6119868B45C#1160833, COL_2B738BBE_CFA2_41EB_9490_76129BDDA7D3#1160834, COL_869EE117_A1AF_4643_9C63_B2E044E76011#1160835, COL_2DEF4579_4198_4381_9794_0850D509C4D9#1160836, COL_28DD75A8_B9B0_41E0_B8DE_4C1D788339EF#1160837, COL_5143601C_5C8F_46DA_8653_3EFEB2EE859D#1160838, COL_603BA3E4_9B75_44D5_A914_615FAE0C5436#1160839, COL_50D051CB_B5A3_4A22_99CF_B636DE0B08A4#1160840, COL_B2D69078_23A7_4B36_BBF2_3F9C29840464#1160841, COL_47A73BC1_4566_45A9_8162_7B6B9E438C8D#1160842, COL_91F5095A_FAAE_4325_81BC_62ABDD788E8D#1160843, COL_394590C1_A817_4CDB_80AC_456AA6E27DEA#1160844, COL_011EF34A_6883_4296_BBBF_AC60A68C84DD#1160845, COL_C1F37338_7743_4434_879A_FF32C1BC5112#1160846, COL_FAEC3B31_0447_4E4B_B8EC_83794AF975DD#1160847, COL_FF5E7CF3_75CA_45FF_AA0E_98474CEB50C2#1160848, COL_6B0E2B89_AC1D_411B_A0AB_19B2CEF8CFC9#1160849, COL_D7508510_B4D7_44C5_A063_A2132B6EF08A#1160850, COL_EAA75683_8CB4_4075_AA4A_FACAF98EBD6E#1160851, COL_B8D0B7A4_71CB_4406_88C1_4791F02E29EF#1160852, COL_AA499A88_B893_47E4_99C5_0EB9F6D69842#1160853, COL_95383EBC_3648_4E94_9C53_D311092BF5F4#1160854, COL_7DC2A78A_5ED5_4908_AC94_0885B83B98CD#1160855, COL_383EDE50_7CF9_4E24_A70F_BA7CD5C9D6BA#1160856, COL_585F8C49_925B_4809_B445_C6A91423BA50#1160857, COL_E7D4B3BC_F96E_4431_BC95_1D1CCE75D846#1160858, COL_B057EBBF_57E7_449C_9DE3_CD56F041B86B#1160859, COL_B8D74F46_C755_4417_9E18_FAA760CD8457#1160860, COL_51335C75_C8A9_4932_8985_BA9E68B80F3A#1160861, COL_03AE34A5_99F1_4525_9BD2_BF7BAFE47F5C#1160862]

(11) Exchange
Input [54]: [COL_497B3BF1_A9CE_4411_8889_2F0461FEE049#1161241, COL_162F4FF6_9702_423C_8695_B193CBA6104D#1161242, COL_8DCB3027_3C9D_41AC_A59E_4DD19821C3A6#1161243, COL_F36F08A6_928E_400F_B138_61F9B8D28AF3#1161244, COL_A213E432_2691_4225_8DF4_C45A67AF4D9C#1161245, COL_E3EB948B_0B85_4F37_970A_DD334B343EE2#1161246, COL_77534C40_F008_4F9B_99A1_4982451B7A24#1161247, COL_AF30678A_46A6_422E_838A_452D36B65FC1#1161248, COL_29EA226E_C020_4D1F_A8DC_11FA4AB16409#1161249, COL_C3DFC75D_DBFD_47F3_B940_59BD461CA3C0#1161250, COL_7506CA9E_3DD1_4B12_8A2A_D2766532D59A#1161251, COL_64235A62_C014_4D54_98DA_329A3C835EDA#1161252, COL_76B3E933_F01E_4379_9153_B0E76D1633B5#1161253, COL_9AE6D4D7_A126_4880_B33C_1337A4899A8C#1161254, COL_9A5C81F5_9A6A_450B_AEBB_DB3516344104#1161255, COL_066BC6D4_55AA_434A_8BD9_1D16816DDDDA#1161256, COL_22D6710B_B7B5_4729_9BCB_202027CB0BD4#1161257, COL_6102ADDE_08E8_4710_9AD0_D2CA02BC21DE#1161258, COL_4A1DE469_43EB_4CAC_9134_3E477437431A#1161259, COL_7666BE37_7FEC_476C_B19D_F98892962E5D#1161260, COL_0BAF376F_F7D0_45AE_AEF9_8E19B504594E#1161261, COL_554D78B0_EA21_483D_B574_547426ADB482#1161262, COL_0B066C93_809D_4EB0_8ADF_3636D7B76593#1161263, COL_EB753D17_130C_4979_986B_D18FFF9DD40A#1161264, COL_0A7B71F1_4A2E_4EB3_A94C_939DCDA503B9#1161265, COL_3942BD61_7E90_4C5E_9240_75A61CE57789#1161266, COL_10C0E375_56E4_415A_AF3C_59B02B4E8408#1161267, COL_265D3814_0F5F_49EC_BEAE_386902F30D16#1161268, COL_D26072D1_60A6_4A96_B906_BE91ACB59614#1161269, COL_22A9E0BF_52D7_4815_A42C_BA2F7EDBB3C0#1161270, COL_3D1D7AA8_1BB1_46F0_8501_CDDDFE0E78BA#1161271, COL_2B27FA6E_B24E_4B22_8ACC_F3D028A40856#1161272, COL_80238879_541A_4F44_92A5_9926F6B94DB8#1161273, COL_621D957A_7A06_4745_964E_FE09BFFF8DB7#1161274, COL_34B3B671_24B2_4686_8CB9_962569FCA41D#1161275, COL_4FDAA229_CCB9_46CF_9F7E_A744CF47F572#1161276, COL_275DF47E_340B_4E55_A9F4_EDCC14A9627D#1161277, COL_7E77AF73_752C_48EE_856C_5C920DEA334B#1161278, COL_EC7C9040_E9DF_4E9F_BA9E_A1A6A0233AF9#1161279, COL_21232554_8AE3_4294_9504_876AA3A8D672#1161280, COL_C0597E1D_6B5A_4F8B_9564_EE724FCB06A6#1161281, COL_8806DAD5_E7F9_4288_9EF7_33FF7C7ABBFD#1161282, COL_5D701CFC_3360_465B_9BEE_24B4F9CA695B#1161283, COL_F0D25D20_CEE9_44DC_ADA4_FEB5CC21F368#1161284, COL_C18DDF33_5647_412B_B46F_605FB907BC20#1161285, COL_CFBEFC28_3BE8_4A12_8520_4056414B51FB#1161286, COL_8E05E990_9DCD_4946_810B_5D660C48B128#1161287, COL_C644CF67_72CA_452B_8B61_CFFAE6D90B0B#1161288, COL_968995BF_0BEB_4F9D_AB7B_2F70009B0383#1161289, COL_C931157E_CFBA_4535_B8F1_D3C29D1EFD77#1161290, COL_1BB74F82_ECBC_4133_AF56_13121C73FA5D#1161291, COL_77DF2687_0629_4378_B27F_E72E041D79EC#1161292, COL_BF828FB3_0BA8_4921_A6A5_07A65F79C8E0#1161293, COL_04822B1E_A0F2_4670_BDB2_507D07D8F3DE#1161294]
Arguments: hashpartitioning(COL_F36F08A6_928E_400F_B138_61F9B8D28AF3#1161244, 10), ENSURE_REQUIREMENTS, [plan_id=659140]

(12) Sort
Input [54]: [COL_497B3BF1_A9CE_4411_8889_2F0461FEE049#1161241, COL_162F4FF6_9702_423C_8695_B193CBA6104D#1161242, COL_8DCB3027_3C9D_41AC_A59E_4DD19821C3A6#1161243, COL_F36F08A6_928E_400F_B138_61F9B8D28AF3#1161244, COL_A213E432_2691_4225_8DF4_C45A67AF4D9C#1161245, COL_E3EB948B_0B85_4F37_970A_DD334B343EE2#1161246, COL_77534C40_F008_4F9B_99A1_4982451B7A24#1161247, COL_AF30678A_46A6_422E_838A_452D36B65FC1#1161248, COL_29EA226E_C020_4D1F_A8DC_11FA4AB16409#1161249, COL_C3DFC75D_DBFD_47F3_B940_59BD461CA3C0#1161250, COL_7506CA9E_3DD1_4B12_8A2A_D2766532D59A#1161251, COL_64235A62_C014_4D54_98DA_329A3C835EDA#1161252, COL_76B3E933_F01E_4379_9153_B0E76D1633B5#1161253, COL_9AE6D4D7_A126_4880_B33C_1337A4899A8C#1161254, COL_9A5C81F5_9A6A_450B_AEBB_DB3516344104#1161255, COL_066BC6D4_55AA_434A_8BD9_1D16816DDDDA#1161256, COL_22D6710B_B7B5_4729_9BCB_202027CB0BD4#1161257, COL_6102ADDE_08E8_4710_9AD0_D2CA02BC21DE#1161258, COL_4A1DE469_43EB_4CAC_9134_3E477437431A#1161259, COL_7666BE37_7FEC_476C_B19D_F98892962E5D#1161260, COL_0BAF376F_F7D0_45AE_AEF9_8E19B504594E#1161261, COL_554D78B0_EA21_483D_B574_547426ADB482#1161262, COL_0B066C93_809D_4EB0_8ADF_3636D7B76593#1161263, COL_EB753D17_130C_4979_986B_D18FFF9DD40A#1161264, COL_0A7B71F1_4A2E_4EB3_A94C_939DCDA503B9#1161265, COL_3942BD61_7E90_4C5E_9240_75A61CE57789#1161266, COL_10C0E375_56E4_415A_AF3C_59B02B4E8408#1161267, COL_265D3814_0F5F_49EC_BEAE_386902F30D16#1161268, COL_D26072D1_60A6_4A96_B906_BE91ACB59614#1161269, COL_22A9E0BF_52D7_4815_A42C_BA2F7EDBB3C0#1161270, COL_3D1D7AA8_1BB1_46F0_8501_CDDDFE0E78BA#1161271, COL_2B27FA6E_B24E_4B22_8ACC_F3D028A40856#1161272, COL_80238879_541A_4F44_92A5_9926F6B94DB8#1161273, COL_621D957A_7A06_4745_964E_FE09BFFF8DB7#1161274, COL_34B3B671_24B2_4686_8CB9_962569FCA41D#1161275, COL_4FDAA229_CCB9_46CF_9F7E_A744CF47F572#1161276, COL_275DF47E_340B_4E55_A9F4_EDCC14A9627D#1161277, COL_7E77AF73_752C_48EE_856C_5C920DEA334B#1161278, COL_EC7C9040_E9DF_4E9F_BA9E_A1A6A0233AF9#1161279, COL_21232554_8AE3_4294_9504_876AA3A8D672#1161280, COL_C0597E1D_6B5A_4F8B_9564_EE724FCB06A6#1161281, COL_8806DAD5_E7F9_4288_9EF7_33FF7C7ABBFD#1161282, COL_5D701CFC_3360_465B_9BEE_24B4F9CA695B#1161283, COL_F0D25D20_CEE9_44DC_ADA4_FEB5CC21F368#1161284, COL_C18DDF33_5647_412B_B46F_605FB907BC20#1161285, COL_CFBEFC28_3BE8_4A12_8520_4056414B51FB#1161286, COL_8E05E990_9DCD_4946_810B_5D660C48B128#1161287, COL_C644CF67_72CA_452B_8B61_CFFAE6D90B0B#1161288, COL_968995BF_0BEB_4F9D_AB7B_2F70009B0383#1161289, COL_C931157E_CFBA_4535_B8F1_D3C29D1EFD77#1161290, COL_1BB74F82_ECBC_4133_AF56_13121C73FA5D#1161291, COL_77DF2687_0629_4378_B27F_E72E041D79EC#1161292, COL_BF828FB3_0BA8_4921_A6A5_07A65F79C8E0#1161293, COL_04822B1E_A0F2_4670_BDB2_507D07D8F3DE#1161294]
Arguments: [COL_F36F08A6_928E_400F_B138_61F9B8D28AF3#1161244 ASC NULLS FIRST], false, 0

(13) Scan parquet 
Output [3]: [COL_E38AB62F_E896_4A72_BE7E_515F8BC641C6#1160786, COL_A2516838_D999_49FB_A245_E9F9B72D742A#1160790, COL_8EA5D1BB_B903_4AA6_811C_01F4D36D9299#1160791]
Batched: true
Location: InMemoryFileIndex [file:/data/output/cache/parquet/datablock/06_COMPILATION__172800]
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>

(14) Filter
Input [3]: [COL_E38AB62F_E896_4A72_BE7E_515F8BC641C6#1160786, COL_A2516838_D999_49FB_A245_E9F9B72D742A#1160790, COL_8EA5D1BB_B903_4AA6_811C_01F4D36D9299#1160791]
Condition : isnotnull(COL_A2516838_D999_49FB_A245_E9F9B72D742A#1160790)

(15) Project
Output [3]: [COL_E38AB62F_E896_4A72_BE7E_515F8BC641C6#1160786 AS 06_COMPILATION__172800_COL_E38AB62F_E896_4A72_BE7E_515F8BC641C6#1161377, COL_A2516838_D999_49FB_A245_E9F9B72D742A#1160790 AS 06_COMPILATION__172800_COL_A2516838_D999_49FB_A245_E9F9B72D742A#1161381, COL_8EA5D1BB_B903_4AA6_811C_01F4D36D9299#1160791 AS 06_COMPILATION__172800_COL_8EA5D1BB_B903_4AA6_811C_01F4D36D9299#1161382]
Input [3]: [COL_E38AB62F_E896_4A72_BE7E_515F8BC641C6#1160786, COL_A2516838_D999_49FB_A245_E9F9B72D742A#1160790, COL_8EA5D1BB_B903_4AA6_811C_01F4D36D9299#1160791]

(16) Exchange
Input [3]: [06_COMPILATION__172800_COL_E38AB62F_E896_4A72_BE7E_515F8BC641C6#1161377, 06_COMPILATION__172800_COL_A2516838_D999_49FB_A245_E9F9B72D742A#1161381, 06_COMPILATION__172800_COL_8EA5D1BB_B903_4AA6_811C_01F4D36D9299#1161382]
Arguments: hashpartitioning(06_COMPILATION__172800_COL_A2516838_D999_49FB_A245_E9F9B72D742A#1161381, 10), ENSURE_REQUIREMENTS, [plan_id=659141]

(17) Sort
Input [3]: [06_COMPILATION__172800_COL_E38AB62F_E896_4A72_BE7E_515F8BC641C6#1161377, 06_COMPILATION__172800_COL_A2516838_D999_49FB_A245_E9F9B72D742A#1161381, 06_COMPILATION__172800_COL_8EA5D1BB_B903_4AA6_811C_01F4D36D9299#1161382]
Arguments: [06_COMPILATION__172800_COL_A2516838_D999_49FB_A245_E9F9B72D742A#1161381 ASC NULLS FIRST], false, 0

(18) SortMergeJoin
Left keys [1]: [COL_F36F08A6_928E_400F_B138_61F9B8D28AF3#1161244]
Right keys [1]: [06_COMPILATION__172800_COL_A2516838_D999_49FB_A245_E9F9B72D742A#1161381]
Join type: LeftOuter
Join condition: None

(19) Project
Output [57]: [COL_497B3BF1_A9CE_4411_8889_2F0461FEE049#1161241, COL_162F4FF6_9702_423C_8695_B193CBA6104D#1161242, COL_8DCB3027_3C9D_41AC_A59E_4DD19821C3A6#1161243, COL_F36F08A6_928E_400F_B138_61F9B8D28AF3#1161244, COL_A213E432_2691_4225_8DF4_C45A67AF4D9C#1161245, COL_E3EB948B_0B85_4F37_970A_DD334B343EE2#1161246, COL_77534C40_F008_4F9B_99A1_4982451B7A24#1161247, COL_AF30678A_46A6_422E_838A_452D36B65FC1#1161248, COL_29EA226E_C020_4D1F_A8DC_11FA4AB16409#1161249, COL_C3DFC75D_DBFD_47F3_B940_59BD461CA3C0#1161250, COL_7506CA9E_3DD1_4B12_8A2A_D2766532D59A#1161251, COL_64235A62_C014_4D54_98DA_329A3C835EDA#1161252, COL_76B3E933_F01E_4379_9153_B0E76D1633B5#1161253, COL_9AE6D4D7_A126_4880_B33C_1337A4899A8C#1161254, COL_9A5C81F5_9A6A_450B_AEBB_DB3516344104#1161255, COL_066BC6D4_55AA_434A_8BD9_1D16816DDDDA#1161256, COL_22D6710B_B7B5_4729_9BCB_202027CB0BD4#1161257, COL_6102ADDE_08E8_4710_9AD0_D2CA02BC21DE#1161258, COL_4A1DE469_43EB_4CAC_9134_3E477437431A#1161259, COL_7666BE37_7FEC_476C_B19D_F98892962E5D#1161260, COL_0BAF376F_F7D0_45AE_AEF9_8E19B504594E#1161261, COL_554D78B0_EA21_483D_B574_547426ADB482#1161262, COL_0B066C93_809D_4EB0_8ADF_3636D7B76593#1161263, COL_EB753D17_130C_4979_986B_D18FFF9DD40A#1161264, COL_0A7B71F1_4A2E_4EB3_A94C_939DCDA503B9#1161265, COL_3942BD61_7E90_4C5E_9240_75A61CE57789#1161266, COL_10C0E375_56E4_415A_AF3C_59B02B4E8408#1161267, COL_265D3814_0F5F_49EC_BEAE_386902F30D16#1161268, COL_D26072D1_60A6_4A96_B906_BE91ACB59614#1161269, COL_22A9E0BF_52D7_4815_A42C_BA2F7EDBB3C0#1161270, COL_3D1D7AA8_1BB1_46F0_8501_CDDDFE0E78BA#1161271, COL_2B27FA6E_B24E_4B22_8ACC_F3D028A40856#1161272, COL_80238879_541A_4F44_92A5_9926F6B94DB8#1161273, COL_621D957A_7A06_4745_964E_FE09BFFF8DB7#1161274, COL_34B3B671_24B2_4686_8CB9_962569FCA41D#1161275, COL_4FDAA229_CCB9_46CF_9F7E_A744CF47F572#1161276, COL_275DF47E_340B_4E55_A9F4_EDCC14A9627D#1161277, COL_7E77AF73_752C_48EE_856C_5C920DEA334B#1161278, COL_EC7C9040_E9DF_4E9F_BA9E_A1A6A0233AF9#1161279, COL_21232554_8AE3_4294_9504_876AA3A8D672#1161280, COL_C0597E1D_6B5A_4F8B_9564_EE724FCB06A6#1161281, COL_8806DAD5_E7F9_4288_9EF7_33FF7C7ABBFD#1161282, COL_5D701CFC_3360_465B_9BEE_24B4F9CA695B#1161283, COL_F0D25D20_CEE9_44DC_ADA4_FEB5CC21F368#1161284, COL_C18DDF33_5647_412B_B46F_605FB907BC20#1161285, COL_CFBEFC28_3BE8_4A12_8520_4056414B51FB#1161286, COL_8E05E990_9DCD_4946_810B_5D660C48B128#1161287, COL_C644CF67_72CA_452B_8B61_CFFAE6D90B0B#1161288, COL_968995BF_0BEB_4F9D_AB7B_2F70009B0383#1161289, COL_C931157E_CFBA_4535_B8F1_D3C29D1EFD77#1161290, COL_1BB74F82_ECBC_4133_AF56_13121C73FA5D#1161291, COL_77DF2687_0629_4378_B27F_E72E041D79EC#1161292, COL_BF828FB3_0BA8_4921_A6A5_07A65F79C8E0#1161293, COL_04822B1E_A0F2_4670_BDB2_507D07D8F3DE#1161294, 06_COMPILATION__172800_COL_E38AB62F_E896_4A72_BE7E_515F8BC641C6#1161377 AS COL_36411CB9_EA90_4CC8_9DF1_BF8D8F09879E#1161936, str_if_with_rule(isnotnull(06_COMPILATION__172800_COL_E38AB62F_E896_4A72_BE7E_515F8BC641C6#1161377), 1, 0) AS COL_BD3E04C0_8EA0_45E3_B543_6A416F1B68FC#1161937, 06_COMPILATION__172800_COL_8EA5D1BB_B903_4AA6_811C_01F4D36D9299#1161382 AS COL_415D2D73_010E_4929_AF07_08F5C67C77B2#1161938]
Input [57]: [COL_497B3BF1_A9CE_4411_8889_2F0461FEE049#1161241, COL_162F4FF6_9702_423C_8695_B193CBA6104D#1161242, COL_8DCB3027_3C9D_41AC_A59E_4DD19821C3A6#1161243, COL_F36F08A6_928E_400F_B138_61F9B8D28AF3#1161244, COL_A213E432_2691_4225_8DF4_C45A67AF4D9C#1161245, COL_E3EB948B_0B85_4F37_970A_DD334B343EE2#1161246, COL_77534C40_F008_4F9B_99A1_4982451B7A24#1161247, COL_AF30678A_46A6_422E_838A_452D36B65FC1#1161248, COL_29EA226E_C020_4D1F_A8DC_11FA4AB16409#1161249, COL_C3DFC75D_DBFD_47F3_B940_59BD461CA3C0#1161250, COL_7506CA9E_3DD1_4B12_8A2A_D2766532D59A#1161251, COL_64235A62_C014_4D54_98DA_329A3C835EDA#1161252, COL_76B3E933_F01E_4379_9153_B0E76D1633B5#1161253, COL_9AE6D4D7_A126_4880_B33C_1337A4899A8C#1161254, COL_9A5C81F5_9A6A_450B_AEBB_DB3516344104#1161255, COL_066BC6D4_55AA_434A_8BD9_1D16816DDDDA#1161256, COL_22D6710B_B7B5_4729_9BCB_202027CB0BD4#1161257, COL_6102ADDE_08E8_4710_9AD0_D2CA02BC21DE#1161258, COL_4A1DE469_43EB_4CAC_9134_3E477437431A#1161259, COL_7666BE37_7FEC_476C_B19D_F98892962E5D#1161260, COL_0BAF376F_F7D0_45AE_AEF9_8E19B504594E#1161261, COL_554D78B0_EA21_483D_B574_547426ADB482#1161262, COL_0B066C93_809D_4EB0_8ADF_3636D7B76593#1161263, COL_EB753D17_130C_4979_986B_D18FFF9DD40A#1161264, COL_0A7B71F1_4A2E_4EB3_A94C_939DCDA503B9#1161265, COL_3942BD61_7E90_4C5E_9240_75A61CE57789#1161266, COL_10C0E375_56E4_415A_AF3C_59B02B4E8408#1161267, COL_265D3814_0F5F_49EC_BEAE_386902F30D16#1161268, COL_D26072D1_60A6_4A96_B906_BE91ACB59614#1161269, COL_22A9E0BF_52D7_4815_A42C_BA2F7EDBB3C0#1161270, COL_3D1D7AA8_1BB1_46F0_8501_CDDDFE0E78BA#1161271, COL_2B27FA6E_B24E_4B22_8ACC_F3D028A40856#1161272, COL_80238879_541A_4F44_92A5_9926F6B94DB8#1161273, COL_621D957A_7A06_4745_964E_FE09BFFF8DB7#1161274, COL_34B3B671_24B2_4686_8CB9_962569FCA41D#1161275, COL_4FDAA229_CCB9_46CF_9F7E_A744CF47F572#1161276, COL_275DF47E_340B_4E55_A9F4_EDCC14A9627D#1161277, COL_7E77AF73_752C_48EE_856C_5C920DEA334B#1161278, COL_EC7C9040_E9DF_4E9F_BA9E_A1A6A0233AF9#1161279, COL_21232554_8AE3_4294_9504_876AA3A8D672#1161280, COL_C0597E1D_6B5A_4F8B_9564_EE724FCB06A6#1161281, COL_8806DAD5_E7F9_4288_9EF7_33FF7C7ABBFD#1161282, COL_5D701CFC_3360_465B_9BEE_24B4F9CA695B#1161283, COL_F0D25D20_CEE9_44DC_ADA4_FEB5CC21F368#1161284, COL_C18DDF33_5647_412B_B46F_605FB907BC20#1161285, COL_CFBEFC28_3BE8_4A12_8520_4056414B51FB#1161286, COL_8E05E990_9DCD_4946_810B_5D660C48B128#1161287, COL_C644CF67_72CA_452B_8B61_CFFAE6D90B0B#1161288, COL_968995BF_0BEB_4F9D_AB7B_2F70009B0383#1161289, COL_C931157E_CFBA_4535_B8F1_D3C29D1EFD77#1161290, COL_1BB74F82_ECBC_4133_AF56_13121C73FA5D#1161291, COL_77DF2687_0629_4378_B27F_E72E041D79EC#1161292, COL_BF828FB3_0BA8_4921_A6A5_07A65F79C8E0#1161293, COL_04822B1E_A0F2_4670_BDB2_507D07D8F3DE#1161294, 06_COMPILATION__172800_COL_E38AB62F_E896_4A72_BE7E_515F8BC641C6#1161377, 06_COMPILATION__172800_COL_A2516838_D999_49FB_A245_E9F9B72D742A#1161381, 06_COMPILATION__172800_COL_8EA5D1BB_B903_4AA6_811C_01F4D36D9299#1161382]

(20) WriteFiles
Input [57]: [COL_497B3BF1_A9CE_4411_8889_2F0461FEE049#1161241, COL_162F4FF6_9702_423C_8695_B193CBA6104D#1161242, COL_8DCB3027_3C9D_41AC_A59E_4DD19821C3A6#1161243, COL_F36F08A6_928E_400F_B138_61F9B8D28AF3#1161244, COL_A213E432_2691_4225_8DF4_C45A67AF4D9C#1161245, COL_E3EB948B_0B85_4F37_970A_DD334B343EE2#1161246, COL_77534C40_F008_4F9B_99A1_4982451B7A24#1161247, COL_AF30678A_46A6_422E_838A_452D36B65FC1#1161248, COL_29EA226E_C020_4D1F_A8DC_11FA4AB16409#1161249, COL_C3DFC75D_DBFD_47F3_B940_59BD461CA3C0#1161250, COL_7506CA9E_3DD1_4B12_8A2A_D2766532D59A#1161251, COL_64235A62_C014_4D54_98DA_329A3C835EDA#1161252, COL_76B3E933_F01E_4379_9153_B0E76D1633B5#1161253, COL_9AE6D4D7_A126_4880_B33C_1337A4899A8C#1161254, COL_9A5C81F5_9A6A_450B_AEBB_DB3516344104#1161255, COL_066BC6D4_55AA_434A_8BD9_1D16816DDDDA#1161256, COL_22D6710B_B7B5_4729_9BCB_202027CB0BD4#1161257, COL_6102ADDE_08E8_4710_9AD0_D2CA02BC21DE#1161258, COL_4A1DE469_43EB_4CAC_9134_3E477437431A#1161259, COL_7666BE37_7FEC_476C_B19D_F98892962E5D#1161260, COL_0BAF376F_F7D0_45AE_AEF9_8E19B504594E#1161261, COL_554D78B0_EA21_483D_B574_547426ADB482#1161262, COL_0B066C93_809D_4EB0_8ADF_3636D7B76593#1161263, COL_EB753D17_130C_4979_986B_D18FFF9DD40A#1161264, COL_0A7B71F1_4A2E_4EB3_A94C_939DCDA503B9#1161265, COL_3942BD61_7E90_4C5E_9240_75A61CE57789#1161266, COL_10C0E375_56E4_415A_AF3C_59B02B4E8408#1161267, COL_265D3814_0F5F_49EC_BEAE_386902F30D16#1161268, COL_D26072D1_60A6_4A96_B906_BE91ACB59614#1161269, COL_22A9E0BF_52D7_4815_A42C_BA2F7EDBB3C0#1161270, COL_3D1D7AA8_1BB1_46F0_8501_CDDDFE0E78BA#1161271, COL_2B27FA6E_B24E_4B22_8ACC_F3D028A40856#1161272, COL_80238879_541A_4F44_92A5_9926F6B94DB8#1161273, COL_621D957A_7A06_4745_964E_FE09BFFF8DB7#1161274, COL_34B3B671_24B2_4686_8CB9_962569FCA41D#1161275, COL_4FDAA229_CCB9_46CF_9F7E_A744CF47F572#1161276, COL_275DF47E_340B_4E55_A9F4_EDCC14A9627D#1161277, COL_7E77AF73_752C_48EE_856C_5C920DEA334B#1161278, COL_EC7C9040_E9DF_4E9F_BA9E_A1A6A0233AF9#1161279, COL_21232554_8AE3_4294_9504_876AA3A8D672#1161280, COL_C0597E1D_6B5A_4F8B_9564_EE724FCB06A6#1161281, COL_8806DAD5_E7F9_4288_9EF7_33FF7C7ABBFD#1161282, COL_5D701CFC_3360_465B_9BEE_24B4F9CA695B#1161283, COL_F0D25D20_CEE9_44DC_ADA4_FEB5CC21F368#1161284, COL_C18DDF33_5647_412B_B46F_605FB907BC20#1161285, COL_CFBEFC28_3BE8_4A12_8520_4056414B51FB#1161286, COL_8E05E990_9DCD_4946_810B_5D660C48B128#1161287, COL_C644CF67_72CA_452B_8B61_CFFAE6D90B0B#1161288, COL_968995BF_0BEB_4F9D_AB7B_2F70009B0383#1161289, COL_C931157E_CFBA_4535_B8F1_D3C29D1EFD77#1161290, COL_1BB74F82_ECBC_4133_AF56_13121C73FA5D#1161291, COL_77DF2687_0629_4378_B27F_E72E041D79EC#1161292, COL_BF828FB3_0BA8_4921_A6A5_07A65F79C8E0#1161293, COL_04822B1E_A0F2_4670_BDB2_507D07D8F3DE#1161294, COL_36411CB9_EA90_4CC8_9DF1_BF8D8F09879E#1161936, COL_BD3E04C0_8EA0_45E3_B543_6A416F1B68FC#1161937, COL_415D2D73_010E_4929_AF07_08F5C67C77B2#1161938]

(21) Execute InsertIntoHadoopFsRelationCommand
Input: []
Arguments: file:/data/output/cache/parquet/datablock/09_A_TTT_SUPLIG_172632, false, Parquet, [path=file:///data/output/cache/parquet/datablock/09_A_TTT_SUPLIG_172632], Overwrite, [COL_497B3BF1_A9CE_4411_8889_2F0461FEE049, COL_162F4FF6_9702_423C_8695_B193CBA6104D, 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, ... 33 more fields]

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

SQL / DataFrame Properties

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