hdh-spark-job - Details for Query 989

Submitted Time: 2026/10/22 20:55:39
Duration: 0.7 s
Succeeded Jobs: 1008 1009 1010 1013 1014 1015

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

digraph G { 0 [labelType="html" label=" AdaptiveSparkPlan "]; 1 [labelType="html" label=" CollectLimit "]; subgraph cluster2 { isCluster="true"; label="WholeStageCodegen (9)\n \nduration: total (min, med, max (stageId: taskId))\n45 ms (22 ms, 23 ms, 23 ms (stage 1358.0: task 1230))"; 3 [labelType="html" label=" Project "]; 4 [labelType="html" label="SortMergeJoin number of output rows: 1,523 spill size total (min, med, max (stageId: taskId)) 0.0 B (0.0 B, 0.0 B, 0.0 B (stage 1358.0: task 1230))"]; } subgraph cluster5 { isCluster="true"; label="WholeStageCodegen (7)\n \nduration: total (min, med, max (stageId: taskId))\n59 ms (24 ms, 35 ms, 35 ms (stage 1358.0: task 1230))"; 6 [labelType="html" label="Sort sort time total (min, med, max (stageId: taskId)) 0 ms (0 ms, 0 ms, 0 ms (stage 1358.0: task 1230)) peak memory total (min, med, max (stageId: taskId)) 128.1 MiB (64.1 MiB, 64.1 MiB, 64.1 MiB (stage 1358.0: task 1230)) spill size total (min, med, max (stageId: taskId)) 0.0 B (0.0 B, 0.0 B, 0.0 B (stage 1358.0: task 1230))"]; } 7 [labelType="html" label="AQEShuffleRead number of partitions: 2 partition data size total (min, med, max (stageId: taskId)) 85.1 KiB (42.0 KiB, 43.1 KiB, 43.1 KiB (driver)) number of coalesced partitions: 2"]; 8 [labelType="html" label="Exchange shuffle records written: 1,500 local merged chunks fetched: 0 shuffle write time: 1 ms remote merged bytes read: 0.0 B local merged blocks fetched: 0 corrupt merged block chunks: 0 remote merged reqs duration: 0 ms remote merged blocks fetched: 0 records read: 1,500 local bytes read total (min, med, max (stageId: taskId)) 80.4 KiB (39.8 KiB, 40.7 KiB, 40.7 KiB (stage 1358.0: task 1230)) fetch wait time total (min, med, max (stageId: taskId)) 0 ms (0 ms, 0 ms, 0 ms (stage 1358.0: task 1230)) remote bytes read: 0.0 B merged fetch fallback count: 0 local blocks read: 2 remote merged chunks fetched: 0 remote blocks read: 0 data size: 334.2 KiB local merged bytes read: 0.0 B number of partitions: 10 remote reqs duration: 0 ms remote bytes read to disk: 0.0 B shuffle bytes written: 80.4 KiB"]; subgraph cluster9 { isCluster="true"; label="WholeStageCodegen (1)\n \nduration: 13 ms"; 10 [labelType="html" label=" LocalLimit "]; 11 [labelType="html" label=" Project "]; 12 [labelType="html" label="ColumnarToRow number of output rows: 4,096 number of input batches: 1"]; } 13 [labelType="html" label="Scan parquet number of files read: 1 scan time: 7 ms metadata time: 0 ms size of files read: 1014.0 KiB number of output rows: 4,096"]; subgraph cluster14 { isCluster="true"; label="WholeStageCodegen (8)\n \nduration: 0 ms"; 15 [labelType="html" label="Sort sort time total (min, med, max (stageId: taskId)) 10 ms (5 ms, 5 ms, 5 ms (stage 1358.0: task 1230)) peak memory total (min, med, max (stageId: taskId)) 128.5 MiB (64.2 MiB, 64.2 MiB, 64.2 MiB (stage 1358.0: task 1230)) spill size total (min, med, max (stageId: taskId)) 0.0 B (0.0 B, 0.0 B, 0.0 B (stage 1358.0: task 1230))"]; } 16 [labelType="html" label="AQEShuffleRead number of partitions: 2 partition data size total (min, med, max (stageId: taskId)) 4.6 MiB (2.3 MiB, 2.3 MiB, 2.3 MiB (driver)) number of coalesced partitions: 2"]; 17 [labelType="html" label="Exchange shuffle records written: 13,798 local merged chunks fetched: 0 shuffle write time total (min, med, max (stageId: taskId)) 15 ms (7 ms, 7 ms, 7 ms (stage 1353.0: task 1228)) 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: 13,798 local bytes read total (min, med, max (stageId: taskId)) 4.3 MiB (2.1 MiB, 2.2 MiB, 2.2 MiB (stage 1363.0: task 1231)) fetch wait time total (min, med, max (stageId: taskId)) 0 ms (0 ms, 0 ms, 0 ms (stage 1358.0: task 1230)) remote bytes read: 0.0 B merged fetch fallback count: 0 local blocks read: 4 remote merged chunks fetched: 0 remote blocks read: 0 data size total (min, med, max (stageId: taskId)) 8.8 MiB (4.3 MiB, 4.5 MiB, 4.5 MiB (stage 1353.0: task 1229)) 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)) 4.3 MiB (2.1 MiB, 2.2 MiB, 2.2 MiB (stage 1353.0: task 1229))"]; subgraph cluster18 { isCluster="true"; label="WholeStageCodegen (6)\n \nduration: total (min, med, max (stageId: taskId))\n266 ms (133 ms, 133 ms, 133 ms (stage 1353.0: task 1229))"; 19 [labelType="html" label=" Project "]; 20 [labelType="html" label="SortMergeJoin number of output rows: 13,798 spill size total (min, med, max (stageId: taskId)) 0.0 B (0.0 B, 0.0 B, 0.0 B (stage 1353.0: task 1229))"]; } subgraph cluster21 { isCluster="true"; label="WholeStageCodegen (4)\n \nduration: total (min, med, max (stageId: taskId))\n285 ms (142 ms, 143 ms, 143 ms (stage 1353.0: task 1228))"; 22 [labelType="html" label="Sort sort time total (min, med, max (stageId: taskId)) 9 ms (4 ms, 5 ms, 5 ms (stage 1353.0: task 1228)) peak memory total (min, med, max (stageId: taskId)) 128.5 MiB (64.2 MiB, 64.2 MiB, 64.2 MiB (stage 1353.0: task 1229)) spill size total (min, med, max (stageId: taskId)) 0.0 B (0.0 B, 0.0 B, 0.0 B (stage 1353.0: task 1229))"]; } 23 [labelType="html" label="AQEShuffleRead number of partitions: 2 partition data size total (min, med, max (stageId: taskId)) 4.7 MiB (2.3 MiB, 2.4 MiB, 2.4 MiB (driver)) number of coalesced partitions: 2"]; 24 [labelType="html" label="Exchange shuffle records written: 13,798 local merged chunks fetched: 0 shuffle write time: 10 ms remote merged bytes read: 0.0 B local merged blocks fetched: 0 corrupt merged block chunks: 0 remote merged reqs duration: 0 ms remote merged blocks fetched: 0 records read: 13,798 local bytes read total (min, med, max (stageId: taskId)) 4.4 MiB (2.2 MiB, 2.2 MiB, 2.2 MiB (stage 1353.0: task 1229)) fetch wait time total (min, med, max (stageId: taskId)) 0 ms (0 ms, 0 ms, 0 ms (stage 1353.0: task 1229)) remote bytes read: 0.0 B merged fetch fallback count: 0 local blocks read: 2 remote merged chunks fetched: 0 remote blocks read: 0 data size: 9.1 MiB 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: 4.4 MiB"]; subgraph cluster25 { isCluster="true"; label="WholeStageCodegen (2)\n \nduration: total (min, med, max (stageId: taskId))\n89 ms (4 ms, 85 ms, 85 ms (stage 1338.0: task 1223))"; 26 [labelType="html" label=" Project "]; 27 [labelType="html" label="Filter number of output rows: 13,798"]; 28 [labelType="html" label="ColumnarToRow number of output rows: 17,658 number of input batches: 5"]; } 29 [labelType="html" label="Scan parquet number of files read: 1 scan time total (min, med, max (stageId: taskId)) 33 ms (3 ms, 30 ms, 30 ms (stage 1338.0: task 1223)) metadata time: 0 ms size of files read: 4.5 MiB number of output rows: 17,658"]; subgraph cluster30 { isCluster="true"; label="WholeStageCodegen (5)\n \nduration: total (min, med, max (stageId: taskId))\n282 ms (141 ms, 141 ms, 141 ms (stage 1353.0: task 1229))"; 31 [labelType="html" label="Sort sort time total (min, med, max (stageId: taskId)) 11 ms (5 ms, 6 ms, 6 ms (stage 1353.0: task 1228)) peak memory total (min, med, max (stageId: taskId)) 129.0 MiB (64.5 MiB, 64.5 MiB, 64.5 MiB (stage 1353.0: task 1229)) spill size total (min, med, max (stageId: taskId)) 0.0 B (0.0 B, 0.0 B, 0.0 B (stage 1353.0: task 1229))"]; } 32 [labelType="html" label="AQEShuffleRead number of partitions: 2 partition data size total (min, med, max (stageId: taskId)) 1338.8 KiB (662.8 KiB, 676.0 KiB, 676.0 KiB (driver)) number of coalesced partitions: 2"]; 33 [labelType="html" label="Exchange shuffle records written: 23,504 local merged chunks fetched: 0 shuffle write time: 6 ms remote merged bytes read: 0.0 B local merged blocks fetched: 0 corrupt merged block chunks: 0 remote merged reqs duration: 0 ms remote merged blocks fetched: 0 records read: 23,504 local bytes read total (min, med, max (stageId: taskId)) 1301.3 KiB (645.6 KiB, 655.7 KiB, 655.7 KiB (stage 1353.0: task 1228)) fetch wait time total (min, med, max (stageId: taskId)) 0 ms (0 ms, 0 ms, 0 ms (stage 1353.0: task 1229)) remote bytes read: 0.0 B merged fetch fallback count: 0 local blocks read: 2 remote merged chunks fetched: 0 remote blocks read: 0 data size: 2.3 MiB 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: 1301.3 KiB"]; subgraph cluster34 { isCluster="true"; label="WholeStageCodegen (3)\n \nduration: 268 ms"; 35 [labelType="html" label=" Project "]; 36 [labelType="html" label="Filter number of output rows: 23,504"]; 37 [labelType="html" label="ColumnarToRow number of output rows: 23,504 number of input batches: 6"]; } 38 [labelType="html" label="Scan parquet number of files read: 1 scan time: 7 ms metadata time: 0 ms size of files read: 910.0 KiB number of output rows: 23,504"]; 1->0; 3->1; 4->3; 6->4; 7->6; 8->7; 10->8; 11->10; 12->11; 13->12; 15->4; 16->15; 17->16; 19->17; 20->19; 22->20; 23->22; 24->23; 26->24; 27->26; 28->27; 29->28; 31->20; 32->31; 33->32; 35->33; 36->35; 37->36; 38->37; }

AdaptiveSparkPlan isFinalPlan=true

CollectLimit 1500

Project [COL_E0C12307_2DFD_461B_A268_CB66A33E2661#288188, COL_6978BD12_4E34_42F4_B348_7D26A6960A06#288189, COL_DBF3310D_D0B3_4F12_97E3_D784101678F9#288190, COL_28B4C2E7_ADB7_4353_99B8_4C0363FF7FA3#288191, COL_6D30BEBE_B5FC_4776_BBC6_B7BF65C3988D#288192, COL_AF9B9274_40AB_4649_ABEA_227E03489167#288193, COL_EFAF9465_C15E_486A_9EC8_A3D3BB7B2579#288194, COL_7202DDB9_1174_4C92_A1EE_63FE75DF0315#288195, COL_C955A4C7_95F1_4454_94F5_5F1D6493E49B#288196, COL_375A0B27_862A_44CB_A74E_53438568AA12#288197, COL_0E71CDD6_8C8C_4761_A393_19FED9EE9068#288198, COL_A5B01183_1D29_430A_AC71_065E4A7E47DD#288199, COL_80AEA694_86F4_4A60_B1AB_DFB105398050#288200, COL_16455999_8A4B_4FD4_AA42_98C941611B74#288201, COL_817E12B1_8331_4FB8_B89B_D521761ECB85#288202, H_CR_438499_COL_B9580440_50FB_4495_B82E_8046068EB218#288239 AS COL_9455796A_A4BF_4EE8_887E_05945DBF262B#288362, H_CR_438499_COL_7CF26F14_9183_4CD5_A49C_F43999A51D88#288245 AS COL_ECDA08E5_81FF_457B_B34B_A0026B7AD8BC#288363]

SortMergeJoin [COL_E0C12307_2DFD_461B_A268_CB66A33E2661#288188], [H_CR_438499_COL_E60F0325_9D51_4908_9ED8_6F9DD6D3CC07#288238], LeftOuter

WholeStageCodegen (9)

Sort [COL_E0C12307_2DFD_461B_A268_CB66A33E2661#288188 ASC NULLS FIRST], false, 0

WholeStageCodegen (7)

AQEShuffleRead coalesced

Exchange hashpartitioning(COL_E0C12307_2DFD_461B_A268_CB66A33E2661#288188, 10), ENSURE_REQUIREMENTS, [plan_id=21023]

LocalLimit 1500

Project [ET_NUMEXA_437692#282116 AS COL_E0C12307_2DFD_461B_A268_CB66A33E2661#288188, ET_NUMDOS_437693#282115 AS COL_6978BD12_4E34_42F4_B348_7D26A6960A06#288189, ET_NUMDEM_437694#282114 AS COL_DBF3310D_D0B3_4F12_97E3_D784101678F9#288190, ET_TYPEXA_437695#282145 AS COL_28B4C2E7_ADB7_4353_99B8_4C0363FF7FA3#288191, ET_CODEXA_437696#282067 AS COL_6D30BEBE_B5FC_4776_BBC6_B7BF65C3988D#288192, ET_EXAACC_437697#282090 AS COL_AF9B9274_40AB_4649_ABEA_227E03489167#288193, ET_LIBEXA_437698#282106 AS COL_EFAF9465_C15E_486A_9EC8_A3D3BB7B2579#288194, ET_CODAPP_437699#282065 AS COL_7202DDB9_1174_4C92_A1EE_63FE75DF0315#288195, ET_NUMSAL_437700#282125 AS COL_C955A4C7_95F1_4454_94F5_5F1D6493E49B#288196, ET_CODPER_437701#282070 AS COL_375A0B27_862A_44CB_A74E_53438568AA12#288197, ET_CODRAD_437702#282074 AS COL_0E71CDD6_8C8C_4761_A393_19FED9EE9068#288198, ET_CODPRO_437703#282072 AS COL_A5B01183_1D29_430A_AC71_065E4A7E47DD#288199, ET_M_AM_I_437704#282109 AS COL_80AEA694_86F4_4A60_B1AB_DFB105398050#288200, ET_AG_ON_437705#282061 AS COL_16455999_8A4B_4FD4_AA42_98C941611B74#288201, ET_DATEXA_437706#282082 AS COL_817E12B1_8331_4FB8_B89B_D521761ECB85#288202]

ColumnarToRow

WholeStageCodegen (1)

FileScan parquet [ET_AG_ON_437705#282061,ET_CODAPP_437699#282065,ET_CODEXA_437696#282067,ET_CODPER_437701#282070,ET_CODPRO_437703#282072,ET_CODRAD_437702#282074,ET_DATEXA_437706#282082,ET_EXAACC_437697#282090,ET_LIBEXA_437698#282106,ET_M_AM_I_437704#282109,ET_NUMDEM_437694#282114,ET_NUMDOS_437693#282115,ET_NUMEXA_437692#282116,ET_NUMSAL_437700#282125,ET_TYPEXA_437695#282145] Batched: true, DataFilters: [], Format: Parquet, Location: InMemoryFileIndex(1 paths)[file:/data/output/cache/parquet/uet/H_DETEXA_437691], PartitionFilters: [], PushedFilters: [], ReadSchema: struct<ET_AG_ON_437705:string,ET_CODAPP_437699:string,ET_CODEXA_437696:string,ET_CODPER_437701:st...

Sort [H_CR_438499_COL_E60F0325_9D51_4908_9ED8_6F9DD6D3CC07#288238 ASC NULLS FIRST], false, 0

WholeStageCodegen (8)

AQEShuffleRead coalesced

Exchange hashpartitioning(H_CR_438499_COL_E60F0325_9D51_4908_9ED8_6F9DD6D3CC07#288238, 10), ENSURE_REQUIREMENTS, [plan_id=21308]

Project [COL_E60F0325_9D51_4908_9ED8_6F9DD6D3CC07#287110 AS H_CR_438499_COL_E60F0325_9D51_4908_9ED8_6F9DD6D3CC07#288238, COL_B9580440_50FB_4495_B82E_8046068EB218#287111 AS H_CR_438499_COL_B9580440_50FB_4495_B82E_8046068EB218#288239, str_replace_extend(COL_7CF26F14_9183_4CD5_A49C_F43999A51D88#287117, array(H_PATIEN_438514_COL_AA64E8D3_7ED0_414B_866A_8621D0D7CAAF#287180, H_PATIEN_438514_COL_7FAA4F01_934E_4C63_AFB7_19B1EC986E3E#287182), array(H_PATIEN_438514_COL_D741682E_18A7_4E09_96D0_47ED855868ED#287181, H_PATIEN_438514_COL_A172DAB9_DF0B_4747_83A1_22D06801DFF7#287183)) AS H_CR_438499_COL_7CF26F14_9183_4CD5_A49C_F43999A51D88#288245]

SortMergeJoin [COL_91CF17C4_5CDC_4008_8AD7_F1285B607EDB#287107], [H_PATIEN_438514_COL_499EB20D_E124_400E_A51E_F020884D243F#287177], LeftOuter

WholeStageCodegen (6)

Sort [COL_91CF17C4_5CDC_4008_8AD7_F1285B607EDB#287107 ASC NULLS FIRST], false, 0

WholeStageCodegen (4)

AQEShuffleRead coalesced

Exchange hashpartitioning(COL_91CF17C4_5CDC_4008_8AD7_F1285B607EDB#287107, 10), ENSURE_REQUIREMENTS, [plan_id=21067]

Project [CR_NUMDOS_437326#285626 AS COL_91CF17C4_5CDC_4008_8AD7_F1285B607EDB#287107, CR_NUMEXA_437329#285628 AS COL_E60F0325_9D51_4908_9ED8_6F9DD6D3CC07#287110, CR_TYPDOC_437330#285663 AS COL_B9580440_50FB_4495_B82E_8046068EB218#287111, CR_CR_437338#285573 AS COL_7CF26F14_9183_4CD5_A49C_F43999A51D88#287117]

Filter (NOT (CR_CR_437338#285573 <=> [NULL]) AND isnotnull(CR_NUMEXA_437329#285628))

ColumnarToRow

WholeStageCodegen (2)

FileScan parquet [CR_CR_437338#285573,CR_NUMDOS_437326#285626,CR_NUMEXA_437329#285628,CR_TYPDOC_437330#285663] Batched: true, DataFilters: [NOT (CR_CR_437338#285573 <=> [NULL]), isnotnull(CR_NUMEXA_437329#285628)], Format: Parquet, Location: InMemoryFileIndex(1 paths)[file:/data/output/cache/parquet/uet/H_CR_437324], PartitionFilters: [], PushedFilters: [Not(EqualNullSafe(CR_CR_437338,[NULL])), IsNotNull(CR_NUMEXA_437329)], ReadSchema: struct<CR_CR_437338:string,CR_NUMDOS_437326:string,CR_NUMEXA_437329:string,CR_TYPDOC_437330:string>

Sort [H_PATIEN_438514_COL_499EB20D_E124_400E_A51E_F020884D243F#287177 ASC NULLS FIRST], false, 0

WholeStageCodegen (5)

AQEShuffleRead coalesced

Exchange hashpartitioning(H_PATIEN_438514_COL_499EB20D_E124_400E_A51E_F020884D243F#287177, 10), ENSURE_REQUIREMENTS, [plan_id=21088]

Project [AT_NUMDOS_438023#282377 AS H_PATIEN_438514_COL_499EB20D_E124_400E_A51E_F020884D243F#287177, AT_NOMPAT_438026#282372 AS H_PATIEN_438514_COL_AA64E8D3_7ED0_414B_866A_8621D0D7CAAF#287180, str_replace_extend(str_replace_extend(AT_NOMPAT_438026#282372, [A,E,I,O,U,Y], [P,S,B,G,H,J]), [D,L,M,S,C,V,R,G], [U,E,U,K,J,O,Y,Z]) AS H_PATIEN_438514_COL_D741682E_18A7_4E09_96D0_47ED855868ED#287181, AT_PNOPAT_438027#282398 AS H_PATIEN_438514_COL_7FAA4F01_934E_4C63_AFB7_19B1EC986E3E#287182, str_replace_extend(str_replace_extend(AT_PNOPAT_438027#282398, [A,E,I,O,U,Y], [P,S,B,G,H,J]), [D,L,M,S,C,V,R,G], [U,E,U,K,J,O,Y,Z]) AS H_PATIEN_438514_COL_A172DAB9_DF0B_4747_83A1_22D06801DFF7#287183]

Filter isnotnull(AT_NUMDOS_438023#282377)

ColumnarToRow

WholeStageCodegen (3)

FileScan parquet [AT_NOMPAT_438026#282372,AT_NUMDOS_438023#282377,AT_PNOPAT_438027#282398] Batched: true, DataFilters: [isnotnull(AT_NUMDOS_438023#282377)], Format: Parquet, Location: InMemoryFileIndex(1 paths)[file:/data/output/cache/parquet/uet/H_PATIEN_438022], PartitionFilters: [], PushedFilters: [IsNotNull(AT_NUMDOS_438023)], ReadSchema: struct<AT_NOMPAT_438026:string,AT_NUMDOS_438023:string,AT_PNOPAT_438027:string>

Details

== Physical Plan ==
AdaptiveSparkPlan (53)
+- == Final Plan ==
   CollectLimit (33)
   +- * Project (32)
      +- * SortMergeJoin LeftOuter (31)
         :- * Sort (8)
         :  +- AQEShuffleRead (7)
         :     +- ShuffleQueryStage (6), Statistics(sizeInBytes=334.2 KiB, rowCount=1.50E+3)
         :        +- Exchange (5)
         :           +- * LocalLimit (4)
         :              +- * Project (3)
         :                 +- * ColumnarToRow (2)
         :                    +- Scan parquet  (1)
         +- * Sort (30)
            +- AQEShuffleRead (29)
               +- ShuffleQueryStage (28), Statistics(sizeInBytes=8.8 MiB, rowCount=1.38E+4)
                  +- Exchange (27)
                     +- * Project (26)
                        +- * SortMergeJoin LeftOuter (25)
                           :- * Sort (16)
                           :  +- AQEShuffleRead (15)
                           :     +- ShuffleQueryStage (14), Statistics(sizeInBytes=9.1 MiB, rowCount=1.38E+4)
                           :        +- Exchange (13)
                           :           +- * Project (12)
                           :              +- * Filter (11)
                           :                 +- * ColumnarToRow (10)
                           :                    +- Scan parquet  (9)
                           +- * Sort (24)
                              +- AQEShuffleRead (23)
                                 +- ShuffleQueryStage (22), Statistics(sizeInBytes=2.3 MiB, rowCount=2.35E+4)
                                    +- Exchange (21)
                                       +- * Project (20)
                                          +- * Filter (19)
                                             +- * ColumnarToRow (18)
                                                +- Scan parquet  (17)
+- == Initial Plan ==
   CollectLimit (52)
   +- Project (51)
      +- SortMergeJoin LeftOuter (50)
         :- Sort (37)
         :  +- Exchange (36)
         :     +- LocalLimit (35)
         :        +- Project (34)
         :           +- Scan parquet  (1)
         +- Sort (49)
            +- Exchange (48)
               +- Project (47)
                  +- SortMergeJoin LeftOuter (46)
                     :- Sort (41)
                     :  +- Exchange (40)
                     :     +- Project (39)
                     :        +- Filter (38)
                     :           +- Scan parquet  (9)
                     +- Sort (45)
                        +- Exchange (44)
                           +- Project (43)
                              +- Filter (42)
                                 +- Scan parquet  (17)


(1) Scan parquet 
Output [15]: [ET_AG_ON_437705#282061, ET_CODAPP_437699#282065, ET_CODEXA_437696#282067, ET_CODPER_437701#282070, ET_CODPRO_437703#282072, ET_CODRAD_437702#282074, ET_DATEXA_437706#282082, ET_EXAACC_437697#282090, ET_LIBEXA_437698#282106, ET_M_AM_I_437704#282109, ET_NUMDEM_437694#282114, ET_NUMDOS_437693#282115, ET_NUMEXA_437692#282116, ET_NUMSAL_437700#282125, ET_TYPEXA_437695#282145]
Batched: true
Location: InMemoryFileIndex [file:/data/output/cache/parquet/uet/H_DETEXA_437691]
ReadSchema: struct<ET_AG_ON_437705:string,ET_CODAPP_437699:string,ET_CODEXA_437696:string,ET_CODPER_437701:string,ET_CODPRO_437703:string,ET_CODRAD_437702:string,ET_DATEXA_437706:string,ET_EXAACC_437697:string,ET_LIBEXA_437698:string,ET_M_AM_I_437704:string,ET_NUMDEM_437694:string,ET_NUMDOS_437693:string,ET_NUMEXA_437692:string,ET_NUMSAL_437700:string,ET_TYPEXA_437695:string>

(2) ColumnarToRow [codegen id : 1]
Input [15]: [ET_AG_ON_437705#282061, ET_CODAPP_437699#282065, ET_CODEXA_437696#282067, ET_CODPER_437701#282070, ET_CODPRO_437703#282072, ET_CODRAD_437702#282074, ET_DATEXA_437706#282082, ET_EXAACC_437697#282090, ET_LIBEXA_437698#282106, ET_M_AM_I_437704#282109, ET_NUMDEM_437694#282114, ET_NUMDOS_437693#282115, ET_NUMEXA_437692#282116, ET_NUMSAL_437700#282125, ET_TYPEXA_437695#282145]

(3) Project [codegen id : 1]
Output [15]: [ET_NUMEXA_437692#282116 AS COL_E0C12307_2DFD_461B_A268_CB66A33E2661#288188, ET_NUMDOS_437693#282115 AS COL_6978BD12_4E34_42F4_B348_7D26A6960A06#288189, ET_NUMDEM_437694#282114 AS COL_DBF3310D_D0B3_4F12_97E3_D784101678F9#288190, ET_TYPEXA_437695#282145 AS COL_28B4C2E7_ADB7_4353_99B8_4C0363FF7FA3#288191, ET_CODEXA_437696#282067 AS COL_6D30BEBE_B5FC_4776_BBC6_B7BF65C3988D#288192, ET_EXAACC_437697#282090 AS COL_AF9B9274_40AB_4649_ABEA_227E03489167#288193, ET_LIBEXA_437698#282106 AS COL_EFAF9465_C15E_486A_9EC8_A3D3BB7B2579#288194, ET_CODAPP_437699#282065 AS COL_7202DDB9_1174_4C92_A1EE_63FE75DF0315#288195, ET_NUMSAL_437700#282125 AS COL_C955A4C7_95F1_4454_94F5_5F1D6493E49B#288196, ET_CODPER_437701#282070 AS COL_375A0B27_862A_44CB_A74E_53438568AA12#288197, ET_CODRAD_437702#282074 AS COL_0E71CDD6_8C8C_4761_A393_19FED9EE9068#288198, ET_CODPRO_437703#282072 AS COL_A5B01183_1D29_430A_AC71_065E4A7E47DD#288199, ET_M_AM_I_437704#282109 AS COL_80AEA694_86F4_4A60_B1AB_DFB105398050#288200, ET_AG_ON_437705#282061 AS COL_16455999_8A4B_4FD4_AA42_98C941611B74#288201, ET_DATEXA_437706#282082 AS COL_817E12B1_8331_4FB8_B89B_D521761ECB85#288202]
Input [15]: [ET_AG_ON_437705#282061, ET_CODAPP_437699#282065, ET_CODEXA_437696#282067, ET_CODPER_437701#282070, ET_CODPRO_437703#282072, ET_CODRAD_437702#282074, ET_DATEXA_437706#282082, ET_EXAACC_437697#282090, ET_LIBEXA_437698#282106, ET_M_AM_I_437704#282109, ET_NUMDEM_437694#282114, ET_NUMDOS_437693#282115, ET_NUMEXA_437692#282116, ET_NUMSAL_437700#282125, ET_TYPEXA_437695#282145]

(4) LocalLimit [codegen id : 1]
Input [15]: [COL_E0C12307_2DFD_461B_A268_CB66A33E2661#288188, COL_6978BD12_4E34_42F4_B348_7D26A6960A06#288189, COL_DBF3310D_D0B3_4F12_97E3_D784101678F9#288190, COL_28B4C2E7_ADB7_4353_99B8_4C0363FF7FA3#288191, COL_6D30BEBE_B5FC_4776_BBC6_B7BF65C3988D#288192, COL_AF9B9274_40AB_4649_ABEA_227E03489167#288193, COL_EFAF9465_C15E_486A_9EC8_A3D3BB7B2579#288194, COL_7202DDB9_1174_4C92_A1EE_63FE75DF0315#288195, COL_C955A4C7_95F1_4454_94F5_5F1D6493E49B#288196, COL_375A0B27_862A_44CB_A74E_53438568AA12#288197, COL_0E71CDD6_8C8C_4761_A393_19FED9EE9068#288198, COL_A5B01183_1D29_430A_AC71_065E4A7E47DD#288199, COL_80AEA694_86F4_4A60_B1AB_DFB105398050#288200, COL_16455999_8A4B_4FD4_AA42_98C941611B74#288201, COL_817E12B1_8331_4FB8_B89B_D521761ECB85#288202]
Arguments: 1500

(5) Exchange
Input [15]: [COL_E0C12307_2DFD_461B_A268_CB66A33E2661#288188, COL_6978BD12_4E34_42F4_B348_7D26A6960A06#288189, COL_DBF3310D_D0B3_4F12_97E3_D784101678F9#288190, COL_28B4C2E7_ADB7_4353_99B8_4C0363FF7FA3#288191, COL_6D30BEBE_B5FC_4776_BBC6_B7BF65C3988D#288192, COL_AF9B9274_40AB_4649_ABEA_227E03489167#288193, COL_EFAF9465_C15E_486A_9EC8_A3D3BB7B2579#288194, COL_7202DDB9_1174_4C92_A1EE_63FE75DF0315#288195, COL_C955A4C7_95F1_4454_94F5_5F1D6493E49B#288196, COL_375A0B27_862A_44CB_A74E_53438568AA12#288197, COL_0E71CDD6_8C8C_4761_A393_19FED9EE9068#288198, COL_A5B01183_1D29_430A_AC71_065E4A7E47DD#288199, COL_80AEA694_86F4_4A60_B1AB_DFB105398050#288200, COL_16455999_8A4B_4FD4_AA42_98C941611B74#288201, COL_817E12B1_8331_4FB8_B89B_D521761ECB85#288202]
Arguments: hashpartitioning(COL_E0C12307_2DFD_461B_A268_CB66A33E2661#288188, 10), ENSURE_REQUIREMENTS, [plan_id=21023]

(6) ShuffleQueryStage
Output [15]: [COL_E0C12307_2DFD_461B_A268_CB66A33E2661#288188, COL_6978BD12_4E34_42F4_B348_7D26A6960A06#288189, COL_DBF3310D_D0B3_4F12_97E3_D784101678F9#288190, COL_28B4C2E7_ADB7_4353_99B8_4C0363FF7FA3#288191, COL_6D30BEBE_B5FC_4776_BBC6_B7BF65C3988D#288192, COL_AF9B9274_40AB_4649_ABEA_227E03489167#288193, COL_EFAF9465_C15E_486A_9EC8_A3D3BB7B2579#288194, COL_7202DDB9_1174_4C92_A1EE_63FE75DF0315#288195, COL_C955A4C7_95F1_4454_94F5_5F1D6493E49B#288196, COL_375A0B27_862A_44CB_A74E_53438568AA12#288197, COL_0E71CDD6_8C8C_4761_A393_19FED9EE9068#288198, COL_A5B01183_1D29_430A_AC71_065E4A7E47DD#288199, COL_80AEA694_86F4_4A60_B1AB_DFB105398050#288200, COL_16455999_8A4B_4FD4_AA42_98C941611B74#288201, COL_817E12B1_8331_4FB8_B89B_D521761ECB85#288202]
Arguments: 0

(7) AQEShuffleRead
Input [15]: [COL_E0C12307_2DFD_461B_A268_CB66A33E2661#288188, COL_6978BD12_4E34_42F4_B348_7D26A6960A06#288189, COL_DBF3310D_D0B3_4F12_97E3_D784101678F9#288190, COL_28B4C2E7_ADB7_4353_99B8_4C0363FF7FA3#288191, COL_6D30BEBE_B5FC_4776_BBC6_B7BF65C3988D#288192, COL_AF9B9274_40AB_4649_ABEA_227E03489167#288193, COL_EFAF9465_C15E_486A_9EC8_A3D3BB7B2579#288194, COL_7202DDB9_1174_4C92_A1EE_63FE75DF0315#288195, COL_C955A4C7_95F1_4454_94F5_5F1D6493E49B#288196, COL_375A0B27_862A_44CB_A74E_53438568AA12#288197, COL_0E71CDD6_8C8C_4761_A393_19FED9EE9068#288198, COL_A5B01183_1D29_430A_AC71_065E4A7E47DD#288199, COL_80AEA694_86F4_4A60_B1AB_DFB105398050#288200, COL_16455999_8A4B_4FD4_AA42_98C941611B74#288201, COL_817E12B1_8331_4FB8_B89B_D521761ECB85#288202]
Arguments: coalesced

(8) Sort [codegen id : 7]
Input [15]: [COL_E0C12307_2DFD_461B_A268_CB66A33E2661#288188, COL_6978BD12_4E34_42F4_B348_7D26A6960A06#288189, COL_DBF3310D_D0B3_4F12_97E3_D784101678F9#288190, COL_28B4C2E7_ADB7_4353_99B8_4C0363FF7FA3#288191, COL_6D30BEBE_B5FC_4776_BBC6_B7BF65C3988D#288192, COL_AF9B9274_40AB_4649_ABEA_227E03489167#288193, COL_EFAF9465_C15E_486A_9EC8_A3D3BB7B2579#288194, COL_7202DDB9_1174_4C92_A1EE_63FE75DF0315#288195, COL_C955A4C7_95F1_4454_94F5_5F1D6493E49B#288196, COL_375A0B27_862A_44CB_A74E_53438568AA12#288197, COL_0E71CDD6_8C8C_4761_A393_19FED9EE9068#288198, COL_A5B01183_1D29_430A_AC71_065E4A7E47DD#288199, COL_80AEA694_86F4_4A60_B1AB_DFB105398050#288200, COL_16455999_8A4B_4FD4_AA42_98C941611B74#288201, COL_817E12B1_8331_4FB8_B89B_D521761ECB85#288202]
Arguments: [COL_E0C12307_2DFD_461B_A268_CB66A33E2661#288188 ASC NULLS FIRST], false, 0

(9) Scan parquet 
Output [4]: [CR_CR_437338#285573, CR_NUMDOS_437326#285626, CR_NUMEXA_437329#285628, CR_TYPDOC_437330#285663]
Batched: true
Location: InMemoryFileIndex [file:/data/output/cache/parquet/uet/H_CR_437324]
PushedFilters: [Not(EqualNullSafe(CR_CR_437338,[NULL])), IsNotNull(CR_NUMEXA_437329)]
ReadSchema: struct<CR_CR_437338:string,CR_NUMDOS_437326:string,CR_NUMEXA_437329:string,CR_TYPDOC_437330:string>

(10) ColumnarToRow [codegen id : 2]
Input [4]: [CR_CR_437338#285573, CR_NUMDOS_437326#285626, CR_NUMEXA_437329#285628, CR_TYPDOC_437330#285663]

(11) Filter [codegen id : 2]
Input [4]: [CR_CR_437338#285573, CR_NUMDOS_437326#285626, CR_NUMEXA_437329#285628, CR_TYPDOC_437330#285663]
Condition : (NOT (CR_CR_437338#285573 <=> [NULL]) AND isnotnull(CR_NUMEXA_437329#285628))

(12) Project [codegen id : 2]
Output [4]: [CR_NUMDOS_437326#285626 AS COL_91CF17C4_5CDC_4008_8AD7_F1285B607EDB#287107, CR_NUMEXA_437329#285628 AS COL_E60F0325_9D51_4908_9ED8_6F9DD6D3CC07#287110, CR_TYPDOC_437330#285663 AS COL_B9580440_50FB_4495_B82E_8046068EB218#287111, CR_CR_437338#285573 AS COL_7CF26F14_9183_4CD5_A49C_F43999A51D88#287117]
Input [4]: [CR_CR_437338#285573, CR_NUMDOS_437326#285626, CR_NUMEXA_437329#285628, CR_TYPDOC_437330#285663]

(13) Exchange
Input [4]: [COL_91CF17C4_5CDC_4008_8AD7_F1285B607EDB#287107, COL_E60F0325_9D51_4908_9ED8_6F9DD6D3CC07#287110, COL_B9580440_50FB_4495_B82E_8046068EB218#287111, COL_7CF26F14_9183_4CD5_A49C_F43999A51D88#287117]
Arguments: hashpartitioning(COL_91CF17C4_5CDC_4008_8AD7_F1285B607EDB#287107, 10), ENSURE_REQUIREMENTS, [plan_id=21067]

(14) ShuffleQueryStage
Output [4]: [COL_91CF17C4_5CDC_4008_8AD7_F1285B607EDB#287107, COL_E60F0325_9D51_4908_9ED8_6F9DD6D3CC07#287110, COL_B9580440_50FB_4495_B82E_8046068EB218#287111, COL_7CF26F14_9183_4CD5_A49C_F43999A51D88#287117]
Arguments: 1

(15) AQEShuffleRead
Input [4]: [COL_91CF17C4_5CDC_4008_8AD7_F1285B607EDB#287107, COL_E60F0325_9D51_4908_9ED8_6F9DD6D3CC07#287110, COL_B9580440_50FB_4495_B82E_8046068EB218#287111, COL_7CF26F14_9183_4CD5_A49C_F43999A51D88#287117]
Arguments: coalesced

(16) Sort [codegen id : 4]
Input [4]: [COL_91CF17C4_5CDC_4008_8AD7_F1285B607EDB#287107, COL_E60F0325_9D51_4908_9ED8_6F9DD6D3CC07#287110, COL_B9580440_50FB_4495_B82E_8046068EB218#287111, COL_7CF26F14_9183_4CD5_A49C_F43999A51D88#287117]
Arguments: [COL_91CF17C4_5CDC_4008_8AD7_F1285B607EDB#287107 ASC NULLS FIRST], false, 0

(17) Scan parquet 
Output [3]: [AT_NOMPAT_438026#282372, AT_NUMDOS_438023#282377, AT_PNOPAT_438027#282398]
Batched: true
Location: InMemoryFileIndex [file:/data/output/cache/parquet/uet/H_PATIEN_438022]
PushedFilters: [IsNotNull(AT_NUMDOS_438023)]
ReadSchema: struct<AT_NOMPAT_438026:string,AT_NUMDOS_438023:string,AT_PNOPAT_438027:string>

(18) ColumnarToRow [codegen id : 3]
Input [3]: [AT_NOMPAT_438026#282372, AT_NUMDOS_438023#282377, AT_PNOPAT_438027#282398]

(19) Filter [codegen id : 3]
Input [3]: [AT_NOMPAT_438026#282372, AT_NUMDOS_438023#282377, AT_PNOPAT_438027#282398]
Condition : isnotnull(AT_NUMDOS_438023#282377)

(20) Project [codegen id : 3]
Output [5]: [AT_NUMDOS_438023#282377 AS H_PATIEN_438514_COL_499EB20D_E124_400E_A51E_F020884D243F#287177, AT_NOMPAT_438026#282372 AS H_PATIEN_438514_COL_AA64E8D3_7ED0_414B_866A_8621D0D7CAAF#287180, str_replace_extend(str_replace_extend(AT_NOMPAT_438026#282372, [A,E,I,O,U,Y], [P,S,B,G,H,J]), [D,L,M,S,C,V,R,G], [U,E,U,K,J,O,Y,Z]) AS H_PATIEN_438514_COL_D741682E_18A7_4E09_96D0_47ED855868ED#287181, AT_PNOPAT_438027#282398 AS H_PATIEN_438514_COL_7FAA4F01_934E_4C63_AFB7_19B1EC986E3E#287182, str_replace_extend(str_replace_extend(AT_PNOPAT_438027#282398, [A,E,I,O,U,Y], [P,S,B,G,H,J]), [D,L,M,S,C,V,R,G], [U,E,U,K,J,O,Y,Z]) AS H_PATIEN_438514_COL_A172DAB9_DF0B_4747_83A1_22D06801DFF7#287183]
Input [3]: [AT_NOMPAT_438026#282372, AT_NUMDOS_438023#282377, AT_PNOPAT_438027#282398]

(21) Exchange
Input [5]: [H_PATIEN_438514_COL_499EB20D_E124_400E_A51E_F020884D243F#287177, H_PATIEN_438514_COL_AA64E8D3_7ED0_414B_866A_8621D0D7CAAF#287180, H_PATIEN_438514_COL_D741682E_18A7_4E09_96D0_47ED855868ED#287181, H_PATIEN_438514_COL_7FAA4F01_934E_4C63_AFB7_19B1EC986E3E#287182, H_PATIEN_438514_COL_A172DAB9_DF0B_4747_83A1_22D06801DFF7#287183]
Arguments: hashpartitioning(H_PATIEN_438514_COL_499EB20D_E124_400E_A51E_F020884D243F#287177, 10), ENSURE_REQUIREMENTS, [plan_id=21088]

(22) ShuffleQueryStage
Output [5]: [H_PATIEN_438514_COL_499EB20D_E124_400E_A51E_F020884D243F#287177, H_PATIEN_438514_COL_AA64E8D3_7ED0_414B_866A_8621D0D7CAAF#287180, H_PATIEN_438514_COL_D741682E_18A7_4E09_96D0_47ED855868ED#287181, H_PATIEN_438514_COL_7FAA4F01_934E_4C63_AFB7_19B1EC986E3E#287182, H_PATIEN_438514_COL_A172DAB9_DF0B_4747_83A1_22D06801DFF7#287183]
Arguments: 2

(23) AQEShuffleRead
Input [5]: [H_PATIEN_438514_COL_499EB20D_E124_400E_A51E_F020884D243F#287177, H_PATIEN_438514_COL_AA64E8D3_7ED0_414B_866A_8621D0D7CAAF#287180, H_PATIEN_438514_COL_D741682E_18A7_4E09_96D0_47ED855868ED#287181, H_PATIEN_438514_COL_7FAA4F01_934E_4C63_AFB7_19B1EC986E3E#287182, H_PATIEN_438514_COL_A172DAB9_DF0B_4747_83A1_22D06801DFF7#287183]
Arguments: coalesced

(24) Sort [codegen id : 5]
Input [5]: [H_PATIEN_438514_COL_499EB20D_E124_400E_A51E_F020884D243F#287177, H_PATIEN_438514_COL_AA64E8D3_7ED0_414B_866A_8621D0D7CAAF#287180, H_PATIEN_438514_COL_D741682E_18A7_4E09_96D0_47ED855868ED#287181, H_PATIEN_438514_COL_7FAA4F01_934E_4C63_AFB7_19B1EC986E3E#287182, H_PATIEN_438514_COL_A172DAB9_DF0B_4747_83A1_22D06801DFF7#287183]
Arguments: [H_PATIEN_438514_COL_499EB20D_E124_400E_A51E_F020884D243F#287177 ASC NULLS FIRST], false, 0

(25) SortMergeJoin [codegen id : 6]
Left keys [1]: [COL_91CF17C4_5CDC_4008_8AD7_F1285B607EDB#287107]
Right keys [1]: [H_PATIEN_438514_COL_499EB20D_E124_400E_A51E_F020884D243F#287177]
Join type: LeftOuter
Join condition: None

(26) Project [codegen id : 6]
Output [3]: [COL_E60F0325_9D51_4908_9ED8_6F9DD6D3CC07#287110 AS H_CR_438499_COL_E60F0325_9D51_4908_9ED8_6F9DD6D3CC07#288238, COL_B9580440_50FB_4495_B82E_8046068EB218#287111 AS H_CR_438499_COL_B9580440_50FB_4495_B82E_8046068EB218#288239, str_replace_extend(COL_7CF26F14_9183_4CD5_A49C_F43999A51D88#287117, array(H_PATIEN_438514_COL_AA64E8D3_7ED0_414B_866A_8621D0D7CAAF#287180, H_PATIEN_438514_COL_7FAA4F01_934E_4C63_AFB7_19B1EC986E3E#287182), array(H_PATIEN_438514_COL_D741682E_18A7_4E09_96D0_47ED855868ED#287181, H_PATIEN_438514_COL_A172DAB9_DF0B_4747_83A1_22D06801DFF7#287183)) AS H_CR_438499_COL_7CF26F14_9183_4CD5_A49C_F43999A51D88#288245]
Input [9]: [COL_91CF17C4_5CDC_4008_8AD7_F1285B607EDB#287107, COL_E60F0325_9D51_4908_9ED8_6F9DD6D3CC07#287110, COL_B9580440_50FB_4495_B82E_8046068EB218#287111, COL_7CF26F14_9183_4CD5_A49C_F43999A51D88#287117, H_PATIEN_438514_COL_499EB20D_E124_400E_A51E_F020884D243F#287177, H_PATIEN_438514_COL_AA64E8D3_7ED0_414B_866A_8621D0D7CAAF#287180, H_PATIEN_438514_COL_D741682E_18A7_4E09_96D0_47ED855868ED#287181, H_PATIEN_438514_COL_7FAA4F01_934E_4C63_AFB7_19B1EC986E3E#287182, H_PATIEN_438514_COL_A172DAB9_DF0B_4747_83A1_22D06801DFF7#287183]

(27) Exchange
Input [3]: [H_CR_438499_COL_E60F0325_9D51_4908_9ED8_6F9DD6D3CC07#288238, H_CR_438499_COL_B9580440_50FB_4495_B82E_8046068EB218#288239, H_CR_438499_COL_7CF26F14_9183_4CD5_A49C_F43999A51D88#288245]
Arguments: hashpartitioning(H_CR_438499_COL_E60F0325_9D51_4908_9ED8_6F9DD6D3CC07#288238, 10), ENSURE_REQUIREMENTS, [plan_id=21308]

(28) ShuffleQueryStage
Output [3]: [H_CR_438499_COL_E60F0325_9D51_4908_9ED8_6F9DD6D3CC07#288238, H_CR_438499_COL_B9580440_50FB_4495_B82E_8046068EB218#288239, H_CR_438499_COL_7CF26F14_9183_4CD5_A49C_F43999A51D88#288245]
Arguments: 3

(29) AQEShuffleRead
Input [3]: [H_CR_438499_COL_E60F0325_9D51_4908_9ED8_6F9DD6D3CC07#288238, H_CR_438499_COL_B9580440_50FB_4495_B82E_8046068EB218#288239, H_CR_438499_COL_7CF26F14_9183_4CD5_A49C_F43999A51D88#288245]
Arguments: coalesced

(30) Sort [codegen id : 8]
Input [3]: [H_CR_438499_COL_E60F0325_9D51_4908_9ED8_6F9DD6D3CC07#288238, H_CR_438499_COL_B9580440_50FB_4495_B82E_8046068EB218#288239, H_CR_438499_COL_7CF26F14_9183_4CD5_A49C_F43999A51D88#288245]
Arguments: [H_CR_438499_COL_E60F0325_9D51_4908_9ED8_6F9DD6D3CC07#288238 ASC NULLS FIRST], false, 0

(31) SortMergeJoin [codegen id : 9]
Left keys [1]: [COL_E0C12307_2DFD_461B_A268_CB66A33E2661#288188]
Right keys [1]: [H_CR_438499_COL_E60F0325_9D51_4908_9ED8_6F9DD6D3CC07#288238]
Join type: LeftOuter
Join condition: None

(32) Project [codegen id : 9]
Output [17]: [COL_E0C12307_2DFD_461B_A268_CB66A33E2661#288188, COL_6978BD12_4E34_42F4_B348_7D26A6960A06#288189, COL_DBF3310D_D0B3_4F12_97E3_D784101678F9#288190, COL_28B4C2E7_ADB7_4353_99B8_4C0363FF7FA3#288191, COL_6D30BEBE_B5FC_4776_BBC6_B7BF65C3988D#288192, COL_AF9B9274_40AB_4649_ABEA_227E03489167#288193, COL_EFAF9465_C15E_486A_9EC8_A3D3BB7B2579#288194, COL_7202DDB9_1174_4C92_A1EE_63FE75DF0315#288195, COL_C955A4C7_95F1_4454_94F5_5F1D6493E49B#288196, COL_375A0B27_862A_44CB_A74E_53438568AA12#288197, COL_0E71CDD6_8C8C_4761_A393_19FED9EE9068#288198, COL_A5B01183_1D29_430A_AC71_065E4A7E47DD#288199, COL_80AEA694_86F4_4A60_B1AB_DFB105398050#288200, COL_16455999_8A4B_4FD4_AA42_98C941611B74#288201, COL_817E12B1_8331_4FB8_B89B_D521761ECB85#288202, H_CR_438499_COL_B9580440_50FB_4495_B82E_8046068EB218#288239 AS COL_9455796A_A4BF_4EE8_887E_05945DBF262B#288362, H_CR_438499_COL_7CF26F14_9183_4CD5_A49C_F43999A51D88#288245 AS COL_ECDA08E5_81FF_457B_B34B_A0026B7AD8BC#288363]
Input [18]: [COL_E0C12307_2DFD_461B_A268_CB66A33E2661#288188, COL_6978BD12_4E34_42F4_B348_7D26A6960A06#288189, COL_DBF3310D_D0B3_4F12_97E3_D784101678F9#288190, COL_28B4C2E7_ADB7_4353_99B8_4C0363FF7FA3#288191, COL_6D30BEBE_B5FC_4776_BBC6_B7BF65C3988D#288192, COL_AF9B9274_40AB_4649_ABEA_227E03489167#288193, COL_EFAF9465_C15E_486A_9EC8_A3D3BB7B2579#288194, COL_7202DDB9_1174_4C92_A1EE_63FE75DF0315#288195, COL_C955A4C7_95F1_4454_94F5_5F1D6493E49B#288196, COL_375A0B27_862A_44CB_A74E_53438568AA12#288197, COL_0E71CDD6_8C8C_4761_A393_19FED9EE9068#288198, COL_A5B01183_1D29_430A_AC71_065E4A7E47DD#288199, COL_80AEA694_86F4_4A60_B1AB_DFB105398050#288200, COL_16455999_8A4B_4FD4_AA42_98C941611B74#288201, COL_817E12B1_8331_4FB8_B89B_D521761ECB85#288202, H_CR_438499_COL_E60F0325_9D51_4908_9ED8_6F9DD6D3CC07#288238, H_CR_438499_COL_B9580440_50FB_4495_B82E_8046068EB218#288239, H_CR_438499_COL_7CF26F14_9183_4CD5_A49C_F43999A51D88#288245]

(33) CollectLimit
Input [17]: [COL_E0C12307_2DFD_461B_A268_CB66A33E2661#288188, COL_6978BD12_4E34_42F4_B348_7D26A6960A06#288189, COL_DBF3310D_D0B3_4F12_97E3_D784101678F9#288190, COL_28B4C2E7_ADB7_4353_99B8_4C0363FF7FA3#288191, COL_6D30BEBE_B5FC_4776_BBC6_B7BF65C3988D#288192, COL_AF9B9274_40AB_4649_ABEA_227E03489167#288193, COL_EFAF9465_C15E_486A_9EC8_A3D3BB7B2579#288194, COL_7202DDB9_1174_4C92_A1EE_63FE75DF0315#288195, COL_C955A4C7_95F1_4454_94F5_5F1D6493E49B#288196, COL_375A0B27_862A_44CB_A74E_53438568AA12#288197, COL_0E71CDD6_8C8C_4761_A393_19FED9EE9068#288198, COL_A5B01183_1D29_430A_AC71_065E4A7E47DD#288199, COL_80AEA694_86F4_4A60_B1AB_DFB105398050#288200, COL_16455999_8A4B_4FD4_AA42_98C941611B74#288201, COL_817E12B1_8331_4FB8_B89B_D521761ECB85#288202, COL_9455796A_A4BF_4EE8_887E_05945DBF262B#288362, COL_ECDA08E5_81FF_457B_B34B_A0026B7AD8BC#288363]
Arguments: 1500

(34) Project
Output [15]: [ET_NUMEXA_437692#282116 AS COL_E0C12307_2DFD_461B_A268_CB66A33E2661#288188, ET_NUMDOS_437693#282115 AS COL_6978BD12_4E34_42F4_B348_7D26A6960A06#288189, ET_NUMDEM_437694#282114 AS COL_DBF3310D_D0B3_4F12_97E3_D784101678F9#288190, ET_TYPEXA_437695#282145 AS COL_28B4C2E7_ADB7_4353_99B8_4C0363FF7FA3#288191, ET_CODEXA_437696#282067 AS COL_6D30BEBE_B5FC_4776_BBC6_B7BF65C3988D#288192, ET_EXAACC_437697#282090 AS COL_AF9B9274_40AB_4649_ABEA_227E03489167#288193, ET_LIBEXA_437698#282106 AS COL_EFAF9465_C15E_486A_9EC8_A3D3BB7B2579#288194, ET_CODAPP_437699#282065 AS COL_7202DDB9_1174_4C92_A1EE_63FE75DF0315#288195, ET_NUMSAL_437700#282125 AS COL_C955A4C7_95F1_4454_94F5_5F1D6493E49B#288196, ET_CODPER_437701#282070 AS COL_375A0B27_862A_44CB_A74E_53438568AA12#288197, ET_CODRAD_437702#282074 AS COL_0E71CDD6_8C8C_4761_A393_19FED9EE9068#288198, ET_CODPRO_437703#282072 AS COL_A5B01183_1D29_430A_AC71_065E4A7E47DD#288199, ET_M_AM_I_437704#282109 AS COL_80AEA694_86F4_4A60_B1AB_DFB105398050#288200, ET_AG_ON_437705#282061 AS COL_16455999_8A4B_4FD4_AA42_98C941611B74#288201, ET_DATEXA_437706#282082 AS COL_817E12B1_8331_4FB8_B89B_D521761ECB85#288202]
Input [15]: [ET_AG_ON_437705#282061, ET_CODAPP_437699#282065, ET_CODEXA_437696#282067, ET_CODPER_437701#282070, ET_CODPRO_437703#282072, ET_CODRAD_437702#282074, ET_DATEXA_437706#282082, ET_EXAACC_437697#282090, ET_LIBEXA_437698#282106, ET_M_AM_I_437704#282109, ET_NUMDEM_437694#282114, ET_NUMDOS_437693#282115, ET_NUMEXA_437692#282116, ET_NUMSAL_437700#282125, ET_TYPEXA_437695#282145]

(35) LocalLimit
Input [15]: [COL_E0C12307_2DFD_461B_A268_CB66A33E2661#288188, COL_6978BD12_4E34_42F4_B348_7D26A6960A06#288189, COL_DBF3310D_D0B3_4F12_97E3_D784101678F9#288190, COL_28B4C2E7_ADB7_4353_99B8_4C0363FF7FA3#288191, COL_6D30BEBE_B5FC_4776_BBC6_B7BF65C3988D#288192, COL_AF9B9274_40AB_4649_ABEA_227E03489167#288193, COL_EFAF9465_C15E_486A_9EC8_A3D3BB7B2579#288194, COL_7202DDB9_1174_4C92_A1EE_63FE75DF0315#288195, COL_C955A4C7_95F1_4454_94F5_5F1D6493E49B#288196, COL_375A0B27_862A_44CB_A74E_53438568AA12#288197, COL_0E71CDD6_8C8C_4761_A393_19FED9EE9068#288198, COL_A5B01183_1D29_430A_AC71_065E4A7E47DD#288199, COL_80AEA694_86F4_4A60_B1AB_DFB105398050#288200, COL_16455999_8A4B_4FD4_AA42_98C941611B74#288201, COL_817E12B1_8331_4FB8_B89B_D521761ECB85#288202]
Arguments: 1500

(36) Exchange
Input [15]: [COL_E0C12307_2DFD_461B_A268_CB66A33E2661#288188, COL_6978BD12_4E34_42F4_B348_7D26A6960A06#288189, COL_DBF3310D_D0B3_4F12_97E3_D784101678F9#288190, COL_28B4C2E7_ADB7_4353_99B8_4C0363FF7FA3#288191, COL_6D30BEBE_B5FC_4776_BBC6_B7BF65C3988D#288192, COL_AF9B9274_40AB_4649_ABEA_227E03489167#288193, COL_EFAF9465_C15E_486A_9EC8_A3D3BB7B2579#288194, COL_7202DDB9_1174_4C92_A1EE_63FE75DF0315#288195, COL_C955A4C7_95F1_4454_94F5_5F1D6493E49B#288196, COL_375A0B27_862A_44CB_A74E_53438568AA12#288197, COL_0E71CDD6_8C8C_4761_A393_19FED9EE9068#288198, COL_A5B01183_1D29_430A_AC71_065E4A7E47DD#288199, COL_80AEA694_86F4_4A60_B1AB_DFB105398050#288200, COL_16455999_8A4B_4FD4_AA42_98C941611B74#288201, COL_817E12B1_8331_4FB8_B89B_D521761ECB85#288202]
Arguments: hashpartitioning(COL_E0C12307_2DFD_461B_A268_CB66A33E2661#288188, 10), ENSURE_REQUIREMENTS, [plan_id=21001]

(37) Sort
Input [15]: [COL_E0C12307_2DFD_461B_A268_CB66A33E2661#288188, COL_6978BD12_4E34_42F4_B348_7D26A6960A06#288189, COL_DBF3310D_D0B3_4F12_97E3_D784101678F9#288190, COL_28B4C2E7_ADB7_4353_99B8_4C0363FF7FA3#288191, COL_6D30BEBE_B5FC_4776_BBC6_B7BF65C3988D#288192, COL_AF9B9274_40AB_4649_ABEA_227E03489167#288193, COL_EFAF9465_C15E_486A_9EC8_A3D3BB7B2579#288194, COL_7202DDB9_1174_4C92_A1EE_63FE75DF0315#288195, COL_C955A4C7_95F1_4454_94F5_5F1D6493E49B#288196, COL_375A0B27_862A_44CB_A74E_53438568AA12#288197, COL_0E71CDD6_8C8C_4761_A393_19FED9EE9068#288198, COL_A5B01183_1D29_430A_AC71_065E4A7E47DD#288199, COL_80AEA694_86F4_4A60_B1AB_DFB105398050#288200, COL_16455999_8A4B_4FD4_AA42_98C941611B74#288201, COL_817E12B1_8331_4FB8_B89B_D521761ECB85#288202]
Arguments: [COL_E0C12307_2DFD_461B_A268_CB66A33E2661#288188 ASC NULLS FIRST], false, 0

(38) Filter
Input [4]: [CR_CR_437338#285573, CR_NUMDOS_437326#285626, CR_NUMEXA_437329#285628, CR_TYPDOC_437330#285663]
Condition : (NOT (CR_CR_437338#285573 <=> [NULL]) AND isnotnull(CR_NUMEXA_437329#285628))

(39) Project
Output [4]: [CR_NUMDOS_437326#285626 AS COL_91CF17C4_5CDC_4008_8AD7_F1285B607EDB#287107, CR_NUMEXA_437329#285628 AS COL_E60F0325_9D51_4908_9ED8_6F9DD6D3CC07#287110, CR_TYPDOC_437330#285663 AS COL_B9580440_50FB_4495_B82E_8046068EB218#287111, CR_CR_437338#285573 AS COL_7CF26F14_9183_4CD5_A49C_F43999A51D88#287117]
Input [4]: [CR_CR_437338#285573, CR_NUMDOS_437326#285626, CR_NUMEXA_437329#285628, CR_TYPDOC_437330#285663]

(40) Exchange
Input [4]: [COL_91CF17C4_5CDC_4008_8AD7_F1285B607EDB#287107, COL_E60F0325_9D51_4908_9ED8_6F9DD6D3CC07#287110, COL_B9580440_50FB_4495_B82E_8046068EB218#287111, COL_7CF26F14_9183_4CD5_A49C_F43999A51D88#287117]
Arguments: hashpartitioning(COL_91CF17C4_5CDC_4008_8AD7_F1285B607EDB#287107, 10), ENSURE_REQUIREMENTS, [plan_id=20991]

(41) Sort
Input [4]: [COL_91CF17C4_5CDC_4008_8AD7_F1285B607EDB#287107, COL_E60F0325_9D51_4908_9ED8_6F9DD6D3CC07#287110, COL_B9580440_50FB_4495_B82E_8046068EB218#287111, COL_7CF26F14_9183_4CD5_A49C_F43999A51D88#287117]
Arguments: [COL_91CF17C4_5CDC_4008_8AD7_F1285B607EDB#287107 ASC NULLS FIRST], false, 0

(42) Filter
Input [3]: [AT_NOMPAT_438026#282372, AT_NUMDOS_438023#282377, AT_PNOPAT_438027#282398]
Condition : isnotnull(AT_NUMDOS_438023#282377)

(43) Project
Output [5]: [AT_NUMDOS_438023#282377 AS H_PATIEN_438514_COL_499EB20D_E124_400E_A51E_F020884D243F#287177, AT_NOMPAT_438026#282372 AS H_PATIEN_438514_COL_AA64E8D3_7ED0_414B_866A_8621D0D7CAAF#287180, str_replace_extend(str_replace_extend(AT_NOMPAT_438026#282372, [A,E,I,O,U,Y], [P,S,B,G,H,J]), [D,L,M,S,C,V,R,G], [U,E,U,K,J,O,Y,Z]) AS H_PATIEN_438514_COL_D741682E_18A7_4E09_96D0_47ED855868ED#287181, AT_PNOPAT_438027#282398 AS H_PATIEN_438514_COL_7FAA4F01_934E_4C63_AFB7_19B1EC986E3E#287182, str_replace_extend(str_replace_extend(AT_PNOPAT_438027#282398, [A,E,I,O,U,Y], [P,S,B,G,H,J]), [D,L,M,S,C,V,R,G], [U,E,U,K,J,O,Y,Z]) AS H_PATIEN_438514_COL_A172DAB9_DF0B_4747_83A1_22D06801DFF7#287183]
Input [3]: [AT_NOMPAT_438026#282372, AT_NUMDOS_438023#282377, AT_PNOPAT_438027#282398]

(44) Exchange
Input [5]: [H_PATIEN_438514_COL_499EB20D_E124_400E_A51E_F020884D243F#287177, H_PATIEN_438514_COL_AA64E8D3_7ED0_414B_866A_8621D0D7CAAF#287180, H_PATIEN_438514_COL_D741682E_18A7_4E09_96D0_47ED855868ED#287181, H_PATIEN_438514_COL_7FAA4F01_934E_4C63_AFB7_19B1EC986E3E#287182, H_PATIEN_438514_COL_A172DAB9_DF0B_4747_83A1_22D06801DFF7#287183]
Arguments: hashpartitioning(H_PATIEN_438514_COL_499EB20D_E124_400E_A51E_F020884D243F#287177, 10), ENSURE_REQUIREMENTS, [plan_id=20992]

(45) Sort
Input [5]: [H_PATIEN_438514_COL_499EB20D_E124_400E_A51E_F020884D243F#287177, H_PATIEN_438514_COL_AA64E8D3_7ED0_414B_866A_8621D0D7CAAF#287180, H_PATIEN_438514_COL_D741682E_18A7_4E09_96D0_47ED855868ED#287181, H_PATIEN_438514_COL_7FAA4F01_934E_4C63_AFB7_19B1EC986E3E#287182, H_PATIEN_438514_COL_A172DAB9_DF0B_4747_83A1_22D06801DFF7#287183]
Arguments: [H_PATIEN_438514_COL_499EB20D_E124_400E_A51E_F020884D243F#287177 ASC NULLS FIRST], false, 0

(46) SortMergeJoin
Left keys [1]: [COL_91CF17C4_5CDC_4008_8AD7_F1285B607EDB#287107]
Right keys [1]: [H_PATIEN_438514_COL_499EB20D_E124_400E_A51E_F020884D243F#287177]
Join type: LeftOuter
Join condition: None

(47) Project
Output [3]: [COL_E60F0325_9D51_4908_9ED8_6F9DD6D3CC07#287110 AS H_CR_438499_COL_E60F0325_9D51_4908_9ED8_6F9DD6D3CC07#288238, COL_B9580440_50FB_4495_B82E_8046068EB218#287111 AS H_CR_438499_COL_B9580440_50FB_4495_B82E_8046068EB218#288239, str_replace_extend(COL_7CF26F14_9183_4CD5_A49C_F43999A51D88#287117, array(H_PATIEN_438514_COL_AA64E8D3_7ED0_414B_866A_8621D0D7CAAF#287180, H_PATIEN_438514_COL_7FAA4F01_934E_4C63_AFB7_19B1EC986E3E#287182), array(H_PATIEN_438514_COL_D741682E_18A7_4E09_96D0_47ED855868ED#287181, H_PATIEN_438514_COL_A172DAB9_DF0B_4747_83A1_22D06801DFF7#287183)) AS H_CR_438499_COL_7CF26F14_9183_4CD5_A49C_F43999A51D88#288245]
Input [9]: [COL_91CF17C4_5CDC_4008_8AD7_F1285B607EDB#287107, COL_E60F0325_9D51_4908_9ED8_6F9DD6D3CC07#287110, COL_B9580440_50FB_4495_B82E_8046068EB218#287111, COL_7CF26F14_9183_4CD5_A49C_F43999A51D88#287117, H_PATIEN_438514_COL_499EB20D_E124_400E_A51E_F020884D243F#287177, H_PATIEN_438514_COL_AA64E8D3_7ED0_414B_866A_8621D0D7CAAF#287180, H_PATIEN_438514_COL_D741682E_18A7_4E09_96D0_47ED855868ED#287181, H_PATIEN_438514_COL_7FAA4F01_934E_4C63_AFB7_19B1EC986E3E#287182, H_PATIEN_438514_COL_A172DAB9_DF0B_4747_83A1_22D06801DFF7#287183]

(48) Exchange
Input [3]: [H_CR_438499_COL_E60F0325_9D51_4908_9ED8_6F9DD6D3CC07#288238, H_CR_438499_COL_B9580440_50FB_4495_B82E_8046068EB218#288239, H_CR_438499_COL_7CF26F14_9183_4CD5_A49C_F43999A51D88#288245]
Arguments: hashpartitioning(H_CR_438499_COL_E60F0325_9D51_4908_9ED8_6F9DD6D3CC07#288238, 10), ENSURE_REQUIREMENTS, [plan_id=21002]

(49) Sort
Input [3]: [H_CR_438499_COL_E60F0325_9D51_4908_9ED8_6F9DD6D3CC07#288238, H_CR_438499_COL_B9580440_50FB_4495_B82E_8046068EB218#288239, H_CR_438499_COL_7CF26F14_9183_4CD5_A49C_F43999A51D88#288245]
Arguments: [H_CR_438499_COL_E60F0325_9D51_4908_9ED8_6F9DD6D3CC07#288238 ASC NULLS FIRST], false, 0

(50) SortMergeJoin
Left keys [1]: [COL_E0C12307_2DFD_461B_A268_CB66A33E2661#288188]
Right keys [1]: [H_CR_438499_COL_E60F0325_9D51_4908_9ED8_6F9DD6D3CC07#288238]
Join type: LeftOuter
Join condition: None

(51) Project
Output [17]: [COL_E0C12307_2DFD_461B_A268_CB66A33E2661#288188, COL_6978BD12_4E34_42F4_B348_7D26A6960A06#288189, COL_DBF3310D_D0B3_4F12_97E3_D784101678F9#288190, COL_28B4C2E7_ADB7_4353_99B8_4C0363FF7FA3#288191, COL_6D30BEBE_B5FC_4776_BBC6_B7BF65C3988D#288192, COL_AF9B9274_40AB_4649_ABEA_227E03489167#288193, COL_EFAF9465_C15E_486A_9EC8_A3D3BB7B2579#288194, COL_7202DDB9_1174_4C92_A1EE_63FE75DF0315#288195, COL_C955A4C7_95F1_4454_94F5_5F1D6493E49B#288196, COL_375A0B27_862A_44CB_A74E_53438568AA12#288197, COL_0E71CDD6_8C8C_4761_A393_19FED9EE9068#288198, COL_A5B01183_1D29_430A_AC71_065E4A7E47DD#288199, COL_80AEA694_86F4_4A60_B1AB_DFB105398050#288200, COL_16455999_8A4B_4FD4_AA42_98C941611B74#288201, COL_817E12B1_8331_4FB8_B89B_D521761ECB85#288202, H_CR_438499_COL_B9580440_50FB_4495_B82E_8046068EB218#288239 AS COL_9455796A_A4BF_4EE8_887E_05945DBF262B#288362, H_CR_438499_COL_7CF26F14_9183_4CD5_A49C_F43999A51D88#288245 AS COL_ECDA08E5_81FF_457B_B34B_A0026B7AD8BC#288363]
Input [18]: [COL_E0C12307_2DFD_461B_A268_CB66A33E2661#288188, COL_6978BD12_4E34_42F4_B348_7D26A6960A06#288189, COL_DBF3310D_D0B3_4F12_97E3_D784101678F9#288190, COL_28B4C2E7_ADB7_4353_99B8_4C0363FF7FA3#288191, COL_6D30BEBE_B5FC_4776_BBC6_B7BF65C3988D#288192, COL_AF9B9274_40AB_4649_ABEA_227E03489167#288193, COL_EFAF9465_C15E_486A_9EC8_A3D3BB7B2579#288194, COL_7202DDB9_1174_4C92_A1EE_63FE75DF0315#288195, COL_C955A4C7_95F1_4454_94F5_5F1D6493E49B#288196, COL_375A0B27_862A_44CB_A74E_53438568AA12#288197, COL_0E71CDD6_8C8C_4761_A393_19FED9EE9068#288198, COL_A5B01183_1D29_430A_AC71_065E4A7E47DD#288199, COL_80AEA694_86F4_4A60_B1AB_DFB105398050#288200, COL_16455999_8A4B_4FD4_AA42_98C941611B74#288201, COL_817E12B1_8331_4FB8_B89B_D521761ECB85#288202, H_CR_438499_COL_E60F0325_9D51_4908_9ED8_6F9DD6D3CC07#288238, H_CR_438499_COL_B9580440_50FB_4495_B82E_8046068EB218#288239, H_CR_438499_COL_7CF26F14_9183_4CD5_A49C_F43999A51D88#288245]

(52) CollectLimit
Input [17]: [COL_E0C12307_2DFD_461B_A268_CB66A33E2661#288188, COL_6978BD12_4E34_42F4_B348_7D26A6960A06#288189, COL_DBF3310D_D0B3_4F12_97E3_D784101678F9#288190, COL_28B4C2E7_ADB7_4353_99B8_4C0363FF7FA3#288191, COL_6D30BEBE_B5FC_4776_BBC6_B7BF65C3988D#288192, COL_AF9B9274_40AB_4649_ABEA_227E03489167#288193, COL_EFAF9465_C15E_486A_9EC8_A3D3BB7B2579#288194, COL_7202DDB9_1174_4C92_A1EE_63FE75DF0315#288195, COL_C955A4C7_95F1_4454_94F5_5F1D6493E49B#288196, COL_375A0B27_862A_44CB_A74E_53438568AA12#288197, COL_0E71CDD6_8C8C_4761_A393_19FED9EE9068#288198, COL_A5B01183_1D29_430A_AC71_065E4A7E47DD#288199, COL_80AEA694_86F4_4A60_B1AB_DFB105398050#288200, COL_16455999_8A4B_4FD4_AA42_98C941611B74#288201, COL_817E12B1_8331_4FB8_B89B_D521761ECB85#288202, COL_9455796A_A4BF_4EE8_887E_05945DBF262B#288362, COL_ECDA08E5_81FF_457B_B34B_A0026B7AD8BC#288363]
Arguments: 1500

(53) AdaptiveSparkPlan
Output [17]: [COL_E0C12307_2DFD_461B_A268_CB66A33E2661#288188, COL_6978BD12_4E34_42F4_B348_7D26A6960A06#288189, COL_DBF3310D_D0B3_4F12_97E3_D784101678F9#288190, COL_28B4C2E7_ADB7_4353_99B8_4C0363FF7FA3#288191, COL_6D30BEBE_B5FC_4776_BBC6_B7BF65C3988D#288192, COL_AF9B9274_40AB_4649_ABEA_227E03489167#288193, COL_EFAF9465_C15E_486A_9EC8_A3D3BB7B2579#288194, COL_7202DDB9_1174_4C92_A1EE_63FE75DF0315#288195, COL_C955A4C7_95F1_4454_94F5_5F1D6493E49B#288196, COL_375A0B27_862A_44CB_A74E_53438568AA12#288197, COL_0E71CDD6_8C8C_4761_A393_19FED9EE9068#288198, COL_A5B01183_1D29_430A_AC71_065E4A7E47DD#288199, COL_80AEA694_86F4_4A60_B1AB_DFB105398050#288200, COL_16455999_8A4B_4FD4_AA42_98C941611B74#288201, COL_817E12B1_8331_4FB8_B89B_D521761ECB85#288202, COL_9455796A_A4BF_4EE8_887E_05945DBF262B#288362, COL_ECDA08E5_81FF_457B_B34B_A0026B7AD8BC#288363]
Arguments: isFinalPlan=true

SQL / DataFrame Properties

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