SP1 - Details for Query 5206

Submitted Time: 2026/05/22 14:21:44
Duration: 0.6 s
Succeeded Jobs: 8164

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

digraph G { 0 [labelType="html" label="Execute InsertIntoHadoopFsRelationCommand task commit time total (min, med, max (stageId: taskId)) 5 ms (0 ms, 1 ms, 1 ms (stage 16843.0: task 23273)) number of written files: 10 job commit time: 12 ms number of output rows: 48,276 number of dynamic part: 0 written output: 8.7 MiB"]; 1 [labelType="html" label=" WriteFiles "]; subgraph cluster2 { isCluster="true"; label="WholeStageCodegen (1)\n \nduration: total (min, med, max (stageId: taskId))\n3.8 s (348 ms, 390 ms, 406 ms (stage 16843.0: task 23272))"; 3 [labelType="html" label=" Project "]; 4 [labelType="html" label="Filter number of output rows: 48,276"]; 5 [labelType="html" label="ColumnarToRow number of output rows: 258,294 number of input batches: 70"]; } 6 [labelType="html" label="Scan parquet number of files read: 10 scan time total (min, med, max (stageId: taskId)) 450 ms (32 ms, 46 ms, 52 ms (stage 16843.0: task 23270)) metadata time: 0 ms size of files read: 18.6 MiB number of output rows: 258,294"]; 1->0; 3->1; 4->3; 5->4; 6->5; }

Execute InsertIntoHadoopFsRelationCommand file:/data/output/cache/parquet/datablock/03_PIVOT_INFORM_188182, false, Parquet, [path=file:///data/output/cache/parquet/datablock/03_PIVOT_INFORM_188182], Overwrite, [COL_B0A29476_8712_4938_9AAA_2B3FED3AA843, COL_AF3F7921_8BD5_48BC_A5E7_2558D4D7693B, COL_2C57AE56_072C_4967_B155_3BCF550AC929, COL_1856697C_8DD2_425F_AA61_054524CA3E4B, COL_CC27206E_3AE7_4822_B5CA_6AFE91FF041F, COL_F1E7803C_F059_4667_8E32_963E2B3DA65F, COL_351EE403_0229_4432_B273_A1F41BC78672, COL_12B44094_B64E_4779_A967_D983CDAB1370, COL_8761272F_9915_40EB_8429_20EFEF6A9A31, COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8, COL_5F8E1D72_6344_42AB_A08C_3B4735439F46, COL_3B226ACB_AA4E_47E6_BD93_5023DCAC91B8, COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A, COL_FEC0DD4A_81C8_43C0_839B_6C467192AD00, COL_F59EBD3D_6145_41E4_8527_CC67B7C9A720, COL_43523D61_1E4B_4377_998B_7E898D87B867, COL_5B5B1560_CF55_4AC4_BCE9_7B7950215A94, COL_60F7C888_9836_4535_A22F_D43D2994E019, COL_6D75D92E_6F3C_4FDD_9F7E_C7DF90A88506, COL_F32292CE_571F_40F2_88B1_7D25A50B5BBB, COL_090106A5_73E4_4A2F_B079_EA4B1A7BC0D3, COL_0319BDA3_7106_4508_AF3E_C32CDF2C0BC2, COL_5C845018_CED0_4FFF_8CB9_3F313C12BC9F, COL_DB215276_6B31_4B67_9D4C_389CB35AE0FA, ... 10 more fields]

WriteFiles

Project [COL_4ECA949F_2DA4_41C5_80E1_520DEFC8D1EA#1300685 AS COL_B0A29476_8712_4938_9AAA_2B3FED3AA843#1301125, COL_D14F6518_D1F3_4F18_93EC_DEF8E6712184#1300686 AS COL_AF3F7921_8BD5_48BC_A5E7_2558D4D7693B#1301126, COL_F522EF71_EF5D_46C0_B0EC_B3EB638B97F7#1300687 AS COL_2C57AE56_072C_4967_B155_3BCF550AC929#1301127, COL_CEFA2472_1E3F_469C_9633_864540C40AD9#1300688 AS COL_1856697C_8DD2_425F_AA61_054524CA3E4B#1301128, COL_1DDA21A4_0127_416B_A5DB_7EDD9CC61B56#1300689 AS COL_CC27206E_3AE7_4822_B5CA_6AFE91FF041F#1301129, COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#1300690 AS COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#1301130, COL_0521CAB9_7617_4F31_948E_95DCA16387D7#1300691 AS COL_351EE403_0229_4432_B273_A1F41BC78672#1301131, COL_1DACB81E_AFA5_4BB8_83D7_57DE8B8062B7#1300692 AS COL_12B44094_B64E_4779_A967_D983CDAB1370#1301132, COL_9262BBED_C393_416D_B38C_8F1458965BA7#1300693 AS COL_8761272F_9915_40EB_8429_20EFEF6A9A31#1301133, COL_F76265AB_8748_4114_92B4_00E37DE25D34#1300694 AS COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#1301134, COL_96E2282E_0771_460E_8BDB_D11261BD9020#1300695 AS COL_5F8E1D72_6344_42AB_A08C_3B4735439F46#1301135, COL_12028397_66B1_4E3C_BBDB_64537606E7DE#1300696 AS COL_3B226ACB_AA4E_47E6_BD93_5023DCAC91B8#1301136, COL_580D5890_2839_4108_A636_8E25F97E50E0#1300697 AS COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1301137, COL_3AFB6BB7_7AA1_4D16_AE24_4CB203A67B51#1300698 AS COL_FEC0DD4A_81C8_43C0_839B_6C467192AD00#1301138, COL_2C09E3B7_4086_45D3_8676_F1D58494C2DD#1300699 AS COL_F59EBD3D_6145_41E4_8527_CC67B7C9A720#1301139, COL_4473F770_A575_4100_97F6_8190F900749A#1300700 AS COL_43523D61_1E4B_4377_998B_7E898D87B867#1301140, COL_715B3479_EAD2_422C_BF5C_7B020197D946#1300701 AS COL_5B5B1560_CF55_4AC4_BCE9_7B7950215A94#1301141, COL_B41952EB_DE3F_4899_8A04_46EF55D519D3#1300702 AS COL_60F7C888_9836_4535_A22F_D43D2994E019#1301142, COL_13C7079E_53C2_4945_BB83_A9CBB5596CA7#1300703 AS COL_6D75D92E_6F3C_4FDD_9F7E_C7DF90A88506#1301143, COL_1DD27485_A759_457B_BE67_EC6813E5F6C7#1300704 AS COL_F32292CE_571F_40F2_88B1_7D25A50B5BBB#1301144, COL_5F21C9DE_C72B_4C4D_A042_7C2B1C8E43BD#1300705 AS COL_090106A5_73E4_4A2F_B079_EA4B1A7BC0D3#1301145, COL_97360DFB_D20B_4DFF_A68A_57C41867D04E#1300706 AS COL_0319BDA3_7106_4508_AF3E_C32CDF2C0BC2#1301146, COL_47A73BC1_4566_45A9_8162_7B6B9E438C8D#1300718 AS COL_5C845018_CED0_4FFF_8CB9_3F313C12BC9F#1301147, COL_390B6626_6008_4E32_942E_6ED08B69626F#1300708 AS COL_DB215276_6B31_4B67_9D4C_389CB35AE0FA#1301148, ... 10 more fields]

Filter (COL_1DDA21A4_0127_416B_A5DB_7EDD9CC61B56#1300689 <=> A)

ColumnarToRow

WholeStageCodegen (1)

FileScan parquet [COL_4ECA949F_2DA4_41C5_80E1_520DEFC8D1EA#1300685,COL_D14F6518_D1F3_4F18_93EC_DEF8E6712184#1300686,COL_F522EF71_EF5D_46C0_B0EC_B3EB638B97F7#1300687,COL_CEFA2472_1E3F_469C_9633_864540C40AD9#1300688,COL_1DDA21A4_0127_416B_A5DB_7EDD9CC61B56#1300689,COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#1300690,COL_0521CAB9_7617_4F31_948E_95DCA16387D7#1300691,COL_1DACB81E_AFA5_4BB8_83D7_57DE8B8062B7#1300692,COL_9262BBED_C393_416D_B38C_8F1458965BA7#1300693,COL_F76265AB_8748_4114_92B4_00E37DE25D34#1300694,COL_96E2282E_0771_460E_8BDB_D11261BD9020#1300695,COL_12028397_66B1_4E3C_BBDB_64537606E7DE#1300696,COL_580D5890_2839_4108_A636_8E25F97E50E0#1300697,COL_3AFB6BB7_7AA1_4D16_AE24_4CB203A67B51#1300698,COL_2C09E3B7_4086_45D3_8676_F1D58494C2DD#1300699,COL_4473F770_A575_4100_97F6_8190F900749A#1300700,COL_715B3479_EAD2_422C_BF5C_7B020197D946#1300701,COL_B41952EB_DE3F_4899_8A04_46EF55D519D3#1300702,COL_13C7079E_53C2_4945_BB83_A9CBB5596CA7#1300703,COL_1DD27485_A759_457B_BE67_EC6813E5F6C7#1300704,COL_5F21C9DE_C72B_4C4D_A042_7C2B1C8E43BD#1300705,COL_97360DFB_D20B_4DFF_A68A_57C41867D04E#1300706,COL_390B6626_6008_4E32_942E_6ED08B69626F#1300708,COL_CD30424F_E1B5_4038_9F6F_A6119868B45C#1300709,... 10 more fields] Batched: true, DataFilters: [(COL_1DDA21A4_0127_416B_A5DB_7EDD9CC61B56#1300689 <=> A)], Format: Parquet, Location: InMemoryFileIndex(1 paths)[file:/data/output/cache/parquet/datablock/02_A_ELIGIBLE_188318], PartitionFilters: [], PushedFilters: [EqualNullSafe(COL_1DDA21A4_0127_416B_A5DB_7EDD9CC61B56,A)], ReadSchema: struct<COL_4ECA949F_2DA4_41C5_80E1_520DEFC8D1EA:string,COL_D14F6518_D1F3_4F18_93EC_DEF8E6712184:s...

Details

== Physical Plan ==
Execute InsertIntoHadoopFsRelationCommand (6)
+- WriteFiles (5)
   +- * Project (4)
      +- * Filter (3)
         +- * ColumnarToRow (2)
            +- Scan parquet  (1)


(1) Scan parquet 
Output [34]: [COL_4ECA949F_2DA4_41C5_80E1_520DEFC8D1EA#1300685, COL_D14F6518_D1F3_4F18_93EC_DEF8E6712184#1300686, COL_F522EF71_EF5D_46C0_B0EC_B3EB638B97F7#1300687, COL_CEFA2472_1E3F_469C_9633_864540C40AD9#1300688, COL_1DDA21A4_0127_416B_A5DB_7EDD9CC61B56#1300689, COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#1300690, COL_0521CAB9_7617_4F31_948E_95DCA16387D7#1300691, COL_1DACB81E_AFA5_4BB8_83D7_57DE8B8062B7#1300692, COL_9262BBED_C393_416D_B38C_8F1458965BA7#1300693, COL_F76265AB_8748_4114_92B4_00E37DE25D34#1300694, COL_96E2282E_0771_460E_8BDB_D11261BD9020#1300695, COL_12028397_66B1_4E3C_BBDB_64537606E7DE#1300696, COL_580D5890_2839_4108_A636_8E25F97E50E0#1300697, COL_3AFB6BB7_7AA1_4D16_AE24_4CB203A67B51#1300698, COL_2C09E3B7_4086_45D3_8676_F1D58494C2DD#1300699, COL_4473F770_A575_4100_97F6_8190F900749A#1300700, COL_715B3479_EAD2_422C_BF5C_7B020197D946#1300701, COL_B41952EB_DE3F_4899_8A04_46EF55D519D3#1300702, COL_13C7079E_53C2_4945_BB83_A9CBB5596CA7#1300703, COL_1DD27485_A759_457B_BE67_EC6813E5F6C7#1300704, COL_5F21C9DE_C72B_4C4D_A042_7C2B1C8E43BD#1300705, COL_97360DFB_D20B_4DFF_A68A_57C41867D04E#1300706, COL_390B6626_6008_4E32_942E_6ED08B69626F#1300708, COL_CD30424F_E1B5_4038_9F6F_A6119868B45C#1300709, COL_2B738BBE_CFA2_41EB_9490_76129BDDA7D3#1300710, COL_869EE117_A1AF_4643_9C63_B2E044E76011#1300711, COL_2DEF4579_4198_4381_9794_0850D509C4D9#1300712, COL_28DD75A8_B9B0_41E0_B8DE_4C1D788339EF#1300713, COL_603BA3E4_9B75_44D5_A914_615FAE0C5436#1300715, COL_47A73BC1_4566_45A9_8162_7B6B9E438C8D#1300718, COL_FAEC3B31_0447_4E4B_B8EC_83794AF975DD#1300723, COL_FF5E7CF3_75CA_45FF_AA0E_98474CEB50C2#1300724, COL_6B0E2B89_AC1D_411B_A0AB_19B2CEF8CFC9#1300725, COL_383EDE50_7CF9_4E24_A70F_BA7CD5C9D6BA#1300732]
Batched: true
Location: InMemoryFileIndex [file:/data/output/cache/parquet/datablock/02_A_ELIGIBLE_188318]
PushedFilters: [EqualNullSafe(COL_1DDA21A4_0127_416B_A5DB_7EDD9CC61B56,A)]
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_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_603BA3E4_9B75_44D5_A914_615FAE0C5436:string,COL_47A73BC1_4566_45A9_8162_7B6B9E438C8D:string,COL_FAEC3B31_0447_4E4B_B8EC_83794AF975DD:string,COL_FF5E7CF3_75CA_45FF_AA0E_98474CEB50C2:string,COL_6B0E2B89_AC1D_411B_A0AB_19B2CEF8CFC9:string,COL_383EDE50_7CF9_4E24_A70F_BA7CD5C9D6BA:string>

(2) ColumnarToRow [codegen id : 1]
Input [34]: [COL_4ECA949F_2DA4_41C5_80E1_520DEFC8D1EA#1300685, COL_D14F6518_D1F3_4F18_93EC_DEF8E6712184#1300686, COL_F522EF71_EF5D_46C0_B0EC_B3EB638B97F7#1300687, COL_CEFA2472_1E3F_469C_9633_864540C40AD9#1300688, COL_1DDA21A4_0127_416B_A5DB_7EDD9CC61B56#1300689, COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#1300690, COL_0521CAB9_7617_4F31_948E_95DCA16387D7#1300691, COL_1DACB81E_AFA5_4BB8_83D7_57DE8B8062B7#1300692, COL_9262BBED_C393_416D_B38C_8F1458965BA7#1300693, COL_F76265AB_8748_4114_92B4_00E37DE25D34#1300694, COL_96E2282E_0771_460E_8BDB_D11261BD9020#1300695, COL_12028397_66B1_4E3C_BBDB_64537606E7DE#1300696, COL_580D5890_2839_4108_A636_8E25F97E50E0#1300697, COL_3AFB6BB7_7AA1_4D16_AE24_4CB203A67B51#1300698, COL_2C09E3B7_4086_45D3_8676_F1D58494C2DD#1300699, COL_4473F770_A575_4100_97F6_8190F900749A#1300700, COL_715B3479_EAD2_422C_BF5C_7B020197D946#1300701, COL_B41952EB_DE3F_4899_8A04_46EF55D519D3#1300702, COL_13C7079E_53C2_4945_BB83_A9CBB5596CA7#1300703, COL_1DD27485_A759_457B_BE67_EC6813E5F6C7#1300704, COL_5F21C9DE_C72B_4C4D_A042_7C2B1C8E43BD#1300705, COL_97360DFB_D20B_4DFF_A68A_57C41867D04E#1300706, COL_390B6626_6008_4E32_942E_6ED08B69626F#1300708, COL_CD30424F_E1B5_4038_9F6F_A6119868B45C#1300709, COL_2B738BBE_CFA2_41EB_9490_76129BDDA7D3#1300710, COL_869EE117_A1AF_4643_9C63_B2E044E76011#1300711, COL_2DEF4579_4198_4381_9794_0850D509C4D9#1300712, COL_28DD75A8_B9B0_41E0_B8DE_4C1D788339EF#1300713, COL_603BA3E4_9B75_44D5_A914_615FAE0C5436#1300715, COL_47A73BC1_4566_45A9_8162_7B6B9E438C8D#1300718, COL_FAEC3B31_0447_4E4B_B8EC_83794AF975DD#1300723, COL_FF5E7CF3_75CA_45FF_AA0E_98474CEB50C2#1300724, COL_6B0E2B89_AC1D_411B_A0AB_19B2CEF8CFC9#1300725, COL_383EDE50_7CF9_4E24_A70F_BA7CD5C9D6BA#1300732]

(3) Filter [codegen id : 1]
Input [34]: [COL_4ECA949F_2DA4_41C5_80E1_520DEFC8D1EA#1300685, COL_D14F6518_D1F3_4F18_93EC_DEF8E6712184#1300686, COL_F522EF71_EF5D_46C0_B0EC_B3EB638B97F7#1300687, COL_CEFA2472_1E3F_469C_9633_864540C40AD9#1300688, COL_1DDA21A4_0127_416B_A5DB_7EDD9CC61B56#1300689, COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#1300690, COL_0521CAB9_7617_4F31_948E_95DCA16387D7#1300691, COL_1DACB81E_AFA5_4BB8_83D7_57DE8B8062B7#1300692, COL_9262BBED_C393_416D_B38C_8F1458965BA7#1300693, COL_F76265AB_8748_4114_92B4_00E37DE25D34#1300694, COL_96E2282E_0771_460E_8BDB_D11261BD9020#1300695, COL_12028397_66B1_4E3C_BBDB_64537606E7DE#1300696, COL_580D5890_2839_4108_A636_8E25F97E50E0#1300697, COL_3AFB6BB7_7AA1_4D16_AE24_4CB203A67B51#1300698, COL_2C09E3B7_4086_45D3_8676_F1D58494C2DD#1300699, COL_4473F770_A575_4100_97F6_8190F900749A#1300700, COL_715B3479_EAD2_422C_BF5C_7B020197D946#1300701, COL_B41952EB_DE3F_4899_8A04_46EF55D519D3#1300702, COL_13C7079E_53C2_4945_BB83_A9CBB5596CA7#1300703, COL_1DD27485_A759_457B_BE67_EC6813E5F6C7#1300704, COL_5F21C9DE_C72B_4C4D_A042_7C2B1C8E43BD#1300705, COL_97360DFB_D20B_4DFF_A68A_57C41867D04E#1300706, COL_390B6626_6008_4E32_942E_6ED08B69626F#1300708, COL_CD30424F_E1B5_4038_9F6F_A6119868B45C#1300709, COL_2B738BBE_CFA2_41EB_9490_76129BDDA7D3#1300710, COL_869EE117_A1AF_4643_9C63_B2E044E76011#1300711, COL_2DEF4579_4198_4381_9794_0850D509C4D9#1300712, COL_28DD75A8_B9B0_41E0_B8DE_4C1D788339EF#1300713, COL_603BA3E4_9B75_44D5_A914_615FAE0C5436#1300715, COL_47A73BC1_4566_45A9_8162_7B6B9E438C8D#1300718, COL_FAEC3B31_0447_4E4B_B8EC_83794AF975DD#1300723, COL_FF5E7CF3_75CA_45FF_AA0E_98474CEB50C2#1300724, COL_6B0E2B89_AC1D_411B_A0AB_19B2CEF8CFC9#1300725, COL_383EDE50_7CF9_4E24_A70F_BA7CD5C9D6BA#1300732]
Condition : (COL_1DDA21A4_0127_416B_A5DB_7EDD9CC61B56#1300689 <=> A)

(4) Project [codegen id : 1]
Output [34]: [COL_4ECA949F_2DA4_41C5_80E1_520DEFC8D1EA#1300685 AS COL_B0A29476_8712_4938_9AAA_2B3FED3AA843#1301125, COL_D14F6518_D1F3_4F18_93EC_DEF8E6712184#1300686 AS COL_AF3F7921_8BD5_48BC_A5E7_2558D4D7693B#1301126, COL_F522EF71_EF5D_46C0_B0EC_B3EB638B97F7#1300687 AS COL_2C57AE56_072C_4967_B155_3BCF550AC929#1301127, COL_CEFA2472_1E3F_469C_9633_864540C40AD9#1300688 AS COL_1856697C_8DD2_425F_AA61_054524CA3E4B#1301128, COL_1DDA21A4_0127_416B_A5DB_7EDD9CC61B56#1300689 AS COL_CC27206E_3AE7_4822_B5CA_6AFE91FF041F#1301129, COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#1300690 AS COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#1301130, COL_0521CAB9_7617_4F31_948E_95DCA16387D7#1300691 AS COL_351EE403_0229_4432_B273_A1F41BC78672#1301131, COL_1DACB81E_AFA5_4BB8_83D7_57DE8B8062B7#1300692 AS COL_12B44094_B64E_4779_A967_D983CDAB1370#1301132, COL_9262BBED_C393_416D_B38C_8F1458965BA7#1300693 AS COL_8761272F_9915_40EB_8429_20EFEF6A9A31#1301133, COL_F76265AB_8748_4114_92B4_00E37DE25D34#1300694 AS COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#1301134, COL_96E2282E_0771_460E_8BDB_D11261BD9020#1300695 AS COL_5F8E1D72_6344_42AB_A08C_3B4735439F46#1301135, COL_12028397_66B1_4E3C_BBDB_64537606E7DE#1300696 AS COL_3B226ACB_AA4E_47E6_BD93_5023DCAC91B8#1301136, COL_580D5890_2839_4108_A636_8E25F97E50E0#1300697 AS COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1301137, COL_3AFB6BB7_7AA1_4D16_AE24_4CB203A67B51#1300698 AS COL_FEC0DD4A_81C8_43C0_839B_6C467192AD00#1301138, COL_2C09E3B7_4086_45D3_8676_F1D58494C2DD#1300699 AS COL_F59EBD3D_6145_41E4_8527_CC67B7C9A720#1301139, COL_4473F770_A575_4100_97F6_8190F900749A#1300700 AS COL_43523D61_1E4B_4377_998B_7E898D87B867#1301140, COL_715B3479_EAD2_422C_BF5C_7B020197D946#1300701 AS COL_5B5B1560_CF55_4AC4_BCE9_7B7950215A94#1301141, COL_B41952EB_DE3F_4899_8A04_46EF55D519D3#1300702 AS COL_60F7C888_9836_4535_A22F_D43D2994E019#1301142, COL_13C7079E_53C2_4945_BB83_A9CBB5596CA7#1300703 AS COL_6D75D92E_6F3C_4FDD_9F7E_C7DF90A88506#1301143, COL_1DD27485_A759_457B_BE67_EC6813E5F6C7#1300704 AS COL_F32292CE_571F_40F2_88B1_7D25A50B5BBB#1301144, COL_5F21C9DE_C72B_4C4D_A042_7C2B1C8E43BD#1300705 AS COL_090106A5_73E4_4A2F_B079_EA4B1A7BC0D3#1301145, COL_97360DFB_D20B_4DFF_A68A_57C41867D04E#1300706 AS COL_0319BDA3_7106_4508_AF3E_C32CDF2C0BC2#1301146, COL_47A73BC1_4566_45A9_8162_7B6B9E438C8D#1300718 AS COL_5C845018_CED0_4FFF_8CB9_3F313C12BC9F#1301147, COL_390B6626_6008_4E32_942E_6ED08B69626F#1300708 AS COL_DB215276_6B31_4B67_9D4C_389CB35AE0FA#1301148, COL_CD30424F_E1B5_4038_9F6F_A6119868B45C#1300709 AS COL_424BD83C_9FCF_4274_A31C_5230975FAA39#1301149, COL_2B738BBE_CFA2_41EB_9490_76129BDDA7D3#1300710 AS COL_A9EE234C_2331_4F24_A871_CDC3E977A099#1301150, COL_869EE117_A1AF_4643_9C63_B2E044E76011#1300711 AS COL_993C7415_5ED8_45E3_974D_5AC6A1E300DB#1301151, COL_2DEF4579_4198_4381_9794_0850D509C4D9#1300712 AS COL_9D918C3A_0604_4D49_B80D_5AEDD299E876#1301152, COL_28DD75A8_B9B0_41E0_B8DE_4C1D788339EF#1300713 AS COL_72A37D1A_DF4A_4A75_9AD5_73AACCF514F6#1301153, COL_603BA3E4_9B75_44D5_A914_615FAE0C5436#1300715 AS COL_F8DBDC17_BE98_41AF_8CD3_D2487EC91EE5#1301154, COL_6B0E2B89_AC1D_411B_A0AB_19B2CEF8CFC9#1300725 AS COL_A7768292_3D54_4C6B_A913_97990CF0FF89#1301155, COL_FF5E7CF3_75CA_45FF_AA0E_98474CEB50C2#1300724 AS COL_68FEC954_2062_4A81_A435_980FFC81CDAE#1301156, COL_FAEC3B31_0447_4E4B_B8EC_83794AF975DD#1300723 AS COL_FF0FF21A_DDF6_44ED_AD1B_3669B56FC1C8#1301157, COL_383EDE50_7CF9_4E24_A70F_BA7CD5C9D6BA#1300732 AS COL_D631DB4E_3B5D_4865_8545_A4E1FBEC583D#1301158]
Input [34]: [COL_4ECA949F_2DA4_41C5_80E1_520DEFC8D1EA#1300685, COL_D14F6518_D1F3_4F18_93EC_DEF8E6712184#1300686, COL_F522EF71_EF5D_46C0_B0EC_B3EB638B97F7#1300687, COL_CEFA2472_1E3F_469C_9633_864540C40AD9#1300688, COL_1DDA21A4_0127_416B_A5DB_7EDD9CC61B56#1300689, COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#1300690, COL_0521CAB9_7617_4F31_948E_95DCA16387D7#1300691, COL_1DACB81E_AFA5_4BB8_83D7_57DE8B8062B7#1300692, COL_9262BBED_C393_416D_B38C_8F1458965BA7#1300693, COL_F76265AB_8748_4114_92B4_00E37DE25D34#1300694, COL_96E2282E_0771_460E_8BDB_D11261BD9020#1300695, COL_12028397_66B1_4E3C_BBDB_64537606E7DE#1300696, COL_580D5890_2839_4108_A636_8E25F97E50E0#1300697, COL_3AFB6BB7_7AA1_4D16_AE24_4CB203A67B51#1300698, COL_2C09E3B7_4086_45D3_8676_F1D58494C2DD#1300699, COL_4473F770_A575_4100_97F6_8190F900749A#1300700, COL_715B3479_EAD2_422C_BF5C_7B020197D946#1300701, COL_B41952EB_DE3F_4899_8A04_46EF55D519D3#1300702, COL_13C7079E_53C2_4945_BB83_A9CBB5596CA7#1300703, COL_1DD27485_A759_457B_BE67_EC6813E5F6C7#1300704, COL_5F21C9DE_C72B_4C4D_A042_7C2B1C8E43BD#1300705, COL_97360DFB_D20B_4DFF_A68A_57C41867D04E#1300706, COL_390B6626_6008_4E32_942E_6ED08B69626F#1300708, COL_CD30424F_E1B5_4038_9F6F_A6119868B45C#1300709, COL_2B738BBE_CFA2_41EB_9490_76129BDDA7D3#1300710, COL_869EE117_A1AF_4643_9C63_B2E044E76011#1300711, COL_2DEF4579_4198_4381_9794_0850D509C4D9#1300712, COL_28DD75A8_B9B0_41E0_B8DE_4C1D788339EF#1300713, COL_603BA3E4_9B75_44D5_A914_615FAE0C5436#1300715, COL_47A73BC1_4566_45A9_8162_7B6B9E438C8D#1300718, COL_FAEC3B31_0447_4E4B_B8EC_83794AF975DD#1300723, COL_FF5E7CF3_75CA_45FF_AA0E_98474CEB50C2#1300724, COL_6B0E2B89_AC1D_411B_A0AB_19B2CEF8CFC9#1300725, COL_383EDE50_7CF9_4E24_A70F_BA7CD5C9D6BA#1300732]

(5) WriteFiles
Input [34]: [COL_B0A29476_8712_4938_9AAA_2B3FED3AA843#1301125, COL_AF3F7921_8BD5_48BC_A5E7_2558D4D7693B#1301126, COL_2C57AE56_072C_4967_B155_3BCF550AC929#1301127, COL_1856697C_8DD2_425F_AA61_054524CA3E4B#1301128, COL_CC27206E_3AE7_4822_B5CA_6AFE91FF041F#1301129, COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#1301130, COL_351EE403_0229_4432_B273_A1F41BC78672#1301131, COL_12B44094_B64E_4779_A967_D983CDAB1370#1301132, COL_8761272F_9915_40EB_8429_20EFEF6A9A31#1301133, COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#1301134, COL_5F8E1D72_6344_42AB_A08C_3B4735439F46#1301135, COL_3B226ACB_AA4E_47E6_BD93_5023DCAC91B8#1301136, COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1301137, COL_FEC0DD4A_81C8_43C0_839B_6C467192AD00#1301138, COL_F59EBD3D_6145_41E4_8527_CC67B7C9A720#1301139, COL_43523D61_1E4B_4377_998B_7E898D87B867#1301140, COL_5B5B1560_CF55_4AC4_BCE9_7B7950215A94#1301141, COL_60F7C888_9836_4535_A22F_D43D2994E019#1301142, COL_6D75D92E_6F3C_4FDD_9F7E_C7DF90A88506#1301143, COL_F32292CE_571F_40F2_88B1_7D25A50B5BBB#1301144, COL_090106A5_73E4_4A2F_B079_EA4B1A7BC0D3#1301145, COL_0319BDA3_7106_4508_AF3E_C32CDF2C0BC2#1301146, COL_5C845018_CED0_4FFF_8CB9_3F313C12BC9F#1301147, COL_DB215276_6B31_4B67_9D4C_389CB35AE0FA#1301148, COL_424BD83C_9FCF_4274_A31C_5230975FAA39#1301149, COL_A9EE234C_2331_4F24_A871_CDC3E977A099#1301150, COL_993C7415_5ED8_45E3_974D_5AC6A1E300DB#1301151, COL_9D918C3A_0604_4D49_B80D_5AEDD299E876#1301152, COL_72A37D1A_DF4A_4A75_9AD5_73AACCF514F6#1301153, COL_F8DBDC17_BE98_41AF_8CD3_D2487EC91EE5#1301154, COL_A7768292_3D54_4C6B_A913_97990CF0FF89#1301155, COL_68FEC954_2062_4A81_A435_980FFC81CDAE#1301156, COL_FF0FF21A_DDF6_44ED_AD1B_3669B56FC1C8#1301157, COL_D631DB4E_3B5D_4865_8545_A4E1FBEC583D#1301158]

(6) Execute InsertIntoHadoopFsRelationCommand
Input: []
Arguments: file:/data/output/cache/parquet/datablock/03_PIVOT_INFORM_188182, false, Parquet, [path=file:///data/output/cache/parquet/datablock/03_PIVOT_INFORM_188182], Overwrite, [COL_B0A29476_8712_4938_9AAA_2B3FED3AA843, COL_AF3F7921_8BD5_48BC_A5E7_2558D4D7693B, COL_2C57AE56_072C_4967_B155_3BCF550AC929, COL_1856697C_8DD2_425F_AA61_054524CA3E4B, COL_CC27206E_3AE7_4822_B5CA_6AFE91FF041F, COL_F1E7803C_F059_4667_8E32_963E2B3DA65F, COL_351EE403_0229_4432_B273_A1F41BC78672, COL_12B44094_B64E_4779_A967_D983CDAB1370, COL_8761272F_9915_40EB_8429_20EFEF6A9A31, COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8, COL_5F8E1D72_6344_42AB_A08C_3B4735439F46, COL_3B226ACB_AA4E_47E6_BD93_5023DCAC91B8, COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A, COL_FEC0DD4A_81C8_43C0_839B_6C467192AD00, COL_F59EBD3D_6145_41E4_8527_CC67B7C9A720, COL_43523D61_1E4B_4377_998B_7E898D87B867, COL_5B5B1560_CF55_4AC4_BCE9_7B7950215A94, COL_60F7C888_9836_4535_A22F_D43D2994E019, COL_6D75D92E_6F3C_4FDD_9F7E_C7DF90A88506, COL_F32292CE_571F_40F2_88B1_7D25A50B5BBB, COL_090106A5_73E4_4A2F_B079_EA4B1A7BC0D3, COL_0319BDA3_7106_4508_AF3E_C32CDF2C0BC2, COL_5C845018_CED0_4FFF_8CB9_3F313C12BC9F, COL_DB215276_6B31_4B67_9D4C_389CB35AE0FA, ... 10 more fields]

SQL / DataFrame Properties

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