SP1 - Details for Query 3541

Submitted Time: 2026/08/26 10:44:15
Duration: 4 s
Succeeded Jobs: 3988 3989 3990 3991

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: 1 ms number of written files: 1 job commit time: 15 ms number of output rows: 43,429 number of dynamic part: 0 written output: 609.7 KiB"]; 2 [labelType="html" label=" WriteFiles "]; subgraph cluster3 { isCluster="true"; label="WholeStageCodegen (8)\n \nduration: 507 ms"; 4 [labelType="html" label=" Project "]; } 5 [labelType="html" label="Window spill size: 0.0 B"]; subgraph cluster6 { isCluster="true"; label="WholeStageCodegen (7)\n \nduration: 118 ms"; 7 [labelType="html" label="Sort sort time: 5 ms peak memory: 17.0 MiB spill size: 0.0 B"]; } 8 [labelType="html" label="AQEShuffleRead number of partitions: 1 partition data size: 3.7 MiB number of coalesced partitions: 1"]; 9 [labelType="html" label="Exchange shuffle records written: 43,429 local merged chunks fetched: 0 shuffle write time total (min, med, max (stageId: taskId)) 17 ms (1 ms, 1 ms, 2 ms (stage 5951.0: task 5524)) 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: 43,429 local bytes read: 3.6 MiB fetch wait time: 0 ms remote bytes read: 0.0 B merged fetch fallback count: 0 local blocks read: 10 remote merged chunks fetched: 0 remote blocks read: 0 data size total (min, med, max (stageId: taskId)) 13.0 MiB (1266.7 KiB, 1332.4 KiB, 1380.9 KiB (stage 5951.0: task 5525)) 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)) 3.6 MiB (354.2 KiB, 364.9 KiB, 379.5 KiB (stage 5951.0: task 5525))"]; 10 [labelType="html" label="Window spill size total (min, med, max (stageId: taskId)) 0.0 B (0.0 B, 0.0 B, 0.0 B (stage 5951.0: task 5524))"]; subgraph cluster11 { isCluster="true"; label="WholeStageCodegen (6)\n \nduration: total (min, med, max (stageId: taskId))\n810 ms (78 ms, 81 ms, 86 ms (stage 5951.0: task 5523))"; 12 [labelType="html" label="Filter number of output rows: 43,429"]; } 13 [labelType="html" label="Window spill size total (min, med, max (stageId: taskId)) 0.0 B (0.0 B, 0.0 B, 0.0 B (stage 5951.0: task 5524))"]; subgraph cluster14 { isCluster="true"; label="WholeStageCodegen (5)\n \nduration: total (min, med, max (stageId: taskId))\n1.4 s (130 ms, 137 ms, 157 ms (stage 5951.0: task 5526))"; 15 [labelType="html" label="Sort sort time total (min, med, max (stageId: taskId)) 86 ms (7 ms, 9 ms, 10 ms (stage 5951.0: task 5525)) peak memory total (min, med, max (stageId: taskId)) 180.0 MiB (18.0 MiB, 18.0 MiB, 18.0 MiB (stage 5951.0: task 5524)) spill size total (min, med, max (stageId: taskId)) 0.0 B (0.0 B, 0.0 B, 0.0 B (stage 5951.0: task 5524))"]; } 16 [labelType="html" label="Exchange shuffle records written: 520,195 local merged chunks fetched: 0 shuffle write time: 88 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: 520,195 local bytes read total (min, med, max (stageId: taskId)) 25.9 MiB (2.5 MiB, 2.6 MiB, 2.7 MiB (stage 5951.0: task 5525)) fetch wait time total (min, med, max (stageId: taskId)) 0 ms (0 ms, 0 ms, 0 ms (stage 5951.0: task 5524)) remote bytes read: 0.0 B merged fetch fallback count: 0 local blocks read: 10 remote merged chunks fetched: 0 remote blocks read: 0 data size: 149.6 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: 25.9 MiB"]; subgraph cluster17 { isCluster="true"; label="WholeStageCodegen (4)\n \nduration: 1.5 s"; 18 [labelType="html" label=" Project "]; } 19 [labelType="html" label="Window spill size: 0.0 B"]; subgraph cluster20 { isCluster="true"; label="WholeStageCodegen (3)\n \nduration: 1.9 s"; 21 [labelType="html" label="Sort sort time: 61 ms peak memory: 176.0 MiB spill size: 0.0 B"]; 22 [labelType="html" label=" Project "]; 23 [labelType="html" label="Generate number of output rows: 520,195"]; 24 [labelType="html" label=" Project "]; } 25 [labelType="html" label="Window spill size: 0.0 B"]; subgraph cluster26 { isCluster="true"; label="WholeStageCodegen (2)\n \nduration: 65 ms"; 27 [labelType="html" label="Sort sort time: 5 ms peak memory: 17.0 MiB spill size: 0.0 B"]; } 28 [labelType="html" label="AQEShuffleRead number of partitions: 1 partition data size: 3.2 MiB number of coalesced partitions: 1"]; 29 [labelType="html" label="Exchange shuffle records written: 40,015 local merged chunks fetched: 0 shuffle write time total (min, med, max (stageId: taskId)) 8 ms (3 ms, 4 ms, 4 ms (stage 5946.0: task 5520)) 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: 40,015 local bytes read: 3.1 MiB fetch wait time: 0 ms 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 total (min, med, max (stageId: taskId)) 11.0 MiB (4.5 MiB, 6.6 MiB, 6.6 MiB (stage 5946.0: task 5520)) 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)) 3.1 MiB (1133.8 KiB, 2023.0 KiB, 2023.0 KiB (stage 5946.0: task 5520))"]; subgraph cluster30 { isCluster="true"; label="WholeStageCodegen (1)\n \nduration: total (min, med, max (stageId: taskId))\n307 ms (143 ms, 164 ms, 164 ms (stage 5946.0: task 5520))"; 31 [labelType="html" label=" Project "]; 32 [labelType="html" label="ColumnarToRow number of output rows: 40,015 number of input batches: 10"]; } 33 [labelType="html" label="Scan parquet number of files read: 2 scan time total (min, med, max (stageId: taskId)) 12 ms (6 ms, 6 ms, 6 ms (stage 5946.0: task 5521)) metadata time: 0 ms size of files read: 1633.4 KiB number of output rows: 40,015"]; 1->0; 2->1; 4->2; 5->4; 7->5; 8->7; 9->8; 10->9; 12->10; 13->12; 15->13; 16->15; 18->16; 19->18; 21->19; 22->21; 23->22; 24->23; 25->24; 27->25; 28->27; 29->28; 31->29; 32->31; 33->32; }

AdaptiveSparkPlan isFinalPlan=true

Execute InsertIntoHadoopFsRelationCommand file:/data/output/cache/parquet/datablock/QUALITE_SEMANTI_66618, false, Parquet, [path=file:///data/output/cache/parquet/datablock/QUALITE_SEMANTI_66618], Overwrite, [COL_38355470_4B6E_4B4E_809B_5B281953DF16, COL_C285D4BB_A02E_4105_A400_1638DD0ACA0A, COL_C4879408_90C5_4F10_AF9F_648CDC892B1E, COL_EA107784_8709_46B5_AA55_86D465A8BEA6, COL_56CB150D_6DAC_4787_A325_C454247FF0CC, COL_7042F62C_E148_4413_A7A5_097C945232F2, COL_44B724FC_5FAF_4C3D_9106_AFCCC207B633, COL_B8C9FA08_2915_4ED7_A3BB_ADF6FA5643FD, COL_00FCD646_8EDD_4E64_AF23_D9CA8773E369, COL_98A321C5_57DC_439F_B059_7C5EF1A9642E, COL_18F75DE4_51FC_4581_8B68_D191957AE6BE, COL_BB75DAC6_A718_4A29_9850_CA70D3D9DEFD, COL_F6F84F2D_321A_4741_BD1C_1CB6CD3D1D24, COL_5CDBD9C9_E94A_4107_89EF_FFA3714428AB, COL_A0131DDF_C92E_4028_9DDB_1E1BE78CA89A, COL_BA88332F_1B23_4847_9054_82AA2086A665, COL_D232794D_6E04_42B4_88DD_D51030910AEA, COL_FE7584CE_A7B9_4550_A540_36A08BA05397, COL_970D8DCA_C522_4183_8ACB_9C9DAB1DF1B8]

WriteFiles

Project [COL_38355470_4B6E_4B4E_809B_5B281953DF16#873994, COL_C285D4BB_A02E_4105_A400_1638DD0ACA0A#873996, COL_C4879408_90C5_4F10_AF9F_648CDC892B1E#873997, COL_EA107784_8709_46B5_AA55_86D465A8BEA6#873998, COL_56CB150D_6DAC_4787_A325_C454247FF0CC#873999, COL_7042F62C_E148_4413_A7A5_097C945232F2#874000, COL_44B724FC_5FAF_4C3D_9106_AFCCC207B633#874001, COL_B8C9FA08_2915_4ED7_A3BB_ADF6FA5643FD#874002, COL_00FCD646_8EDD_4E64_AF23_D9CA8773E369#874003, COL_98A321C5_57DC_439F_B059_7C5EF1A9642E#874004, COL_18F75DE4_51FC_4581_8B68_D191957AE6BE#874018, COL_BB75DAC6_A718_4A29_9850_CA70D3D9DEFD#874032, COL_F6F84F2D_321A_4741_BD1C_1CB6CD3D1D24#873995, COL_5CDBD9C9_E94A_4107_89EF_FFA3714428AB#874360L, COL_A0131DDF_C92E_4028_9DDB_1E1BE78CA89A#874177L, round(dec_operator(PRODUIT, array(dec_operator(DIVISION, array(COL_5CDBD9C9_E94A_4107_89EF_FFA3714428AB#874360L, COL_A0131DDF_C92E_4028_9DDB_1E1BE78CA89A#874177L)), 100.0)), 2) AS COL_BA88332F_1B23_4847_9054_82AA2086A665#874638, COL_D232794D_6E04_42B4_88DD_D51030910AEA#874417L, COL_FE7584CE_A7B9_4550_A540_36A08BA05397#874065L, COL_970D8DCA_C522_4183_8ACB_9C9DAB1DF1B8#874005L]

WholeStageCodegen (8)

Window [count(1) windowspecdefinition(1, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_D232794D_6E04_42B4_88DD_D51030910AEA#874417L], [1], [1 DESC NULLS LAST]

Sort [1 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0

WholeStageCodegen (7)

AQEShuffleRead coalesced

Exchange hashpartitioning(1, 10), ENSURE_REQUIREMENTS, [plan_id=117512]

Window [count(1) windowspecdefinition(COL_C285D4BB_A02E_4105_A400_1638DD0ACA0A#873996, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_5CDBD9C9_E94A_4107_89EF_FFA3714428AB#874360L], [COL_C285D4BB_A02E_4105_A400_1638DD0ACA0A#873996], [1 DESC NULLS LAST]

Filter (COL_F6F84F2D_321A_4741_BD1C_1CB6CD3D1D24#873995 <=> 1)

WholeStageCodegen (6)

Window [count(1) windowspecdefinition(COL_C285D4BB_A02E_4105_A400_1638DD0ACA0A#873996, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_A0131DDF_C92E_4028_9DDB_1E1BE78CA89A#874177L], [COL_C285D4BB_A02E_4105_A400_1638DD0ACA0A#873996], [1 DESC NULLS LAST]

Sort [COL_C285D4BB_A02E_4105_A400_1638DD0ACA0A#873996 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0

WholeStageCodegen (5)

Exchange hashpartitioning(COL_C285D4BB_A02E_4105_A400_1638DD0ACA0A#873996, 10), ENSURE_REQUIREMENTS, [plan_id=117427]

WholeStageCodegen (4)

Window [count(1) windowspecdefinition(1, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_FE7584CE_A7B9_4550_A540_36A08BA05397#874065L], [1], [1 DESC NULLS LAST]

Sort [1 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0

Project [col0#873810 AS COL_38355470_4B6E_4B4E_809B_5B281953DF16#873994, coalesce(col1#873811, 1) AS COL_F6F84F2D_321A_4741_BD1C_1CB6CD3D1D24#873995, COL_E6AE24ED_8026_495F_A48A_A236DF26A045#873477 AS COL_C285D4BB_A02E_4105_A400_1638DD0ACA0A#873996, COL_4A1CE955_6068_4C7E_A3E5_D1247E0D721C#873478 AS COL_C4879408_90C5_4F10_AF9F_648CDC892B1E#873997, COL_1AB4B887_3C06_4F3A_ABF9_7AD8B2A320C0#873479 AS COL_EA107784_8709_46B5_AA55_86D465A8BEA6#873998, COL_D567C154_8DAA_4940_917F_47BC849D79C6#873480 AS COL_56CB150D_6DAC_4787_A325_C454247FF0CC#873999, COL_F7E49028_833B_451A_9E47_6BD3A0E316BF#873481 AS COL_7042F62C_E148_4413_A7A5_097C945232F2#874000, COL_3228D314_43D6_4FC0_93CF_06B11ACB10C3#873482 AS COL_44B724FC_5FAF_4C3D_9106_AFCCC207B633#874001, COL_94D8C66B_9389_4B85_AB9D_6D5C783EAB35#873486 AS COL_B8C9FA08_2915_4ED7_A3BB_ADF6FA5643FD#874002, COL_FF0B1DCA_05CD_4386_8A58_A3EBAB686C31#873487 AS COL_00FCD646_8EDD_4E64_AF23_D9CA8773E369#874003, COL_0C2F7757_16EE_45C2_81B7_A383DF708478#873490 AS COL_98A321C5_57DC_439F_B059_7C5EF1A9642E#874004, COL_5E05192E_2B2D_47F7_ACEA_8D574028FB87#873586L AS COL_970D8DCA_C522_4183_8ACB_9C9DAB1DF1B8#874005L, str_extract_by_str(col0#873810, _, LEFT) AS COL_18F75DE4_51FC_4581_8B68_D191957AE6BE#874018, str_extract_by_str(col0#873810, _, RIGHT) AS COL_BB75DAC6_A718_4A29_9850_CA70D3D9DEFD#874032]

Generate stack(13, Nom Naissance_Minuscule-Partiel, COL_B33BB2B1_4367_4C17_9E85_E1B83CEDA1F7#873498, Commune_Minuscule-Partiel, COL_5E2D72EA_FAB1_400C_B520_52899F382EF3#873499, Ipp_Caractère-Anormal, COL_9A64A372_5DD3_4A81_996C_613299ACD186#873500, Sexe_Caractère-Anormal, COL_73505A0D_7059_4377_994F_AAAAC3967AE3#873501, Département_Longueur-Anormal, COL_707861E9_0D04_42B9_BA95_403D54B5DC30#873502, Code Postal_Longueur Anormal, COL_5537EF2F_DF84_4745_87EE_5F3BF426F665#873503, IPP_Longueur Anormal, COL_9E2C1846_0355_4576_B77B_428DBDB090B0#873504, Prénom_Caractères-spéciaux, COL_4DD24825_2E66_4A12_BFE1_E5EA1B1621A3#873505, Nom Naissance_Caractères-spéciaux, COL_4B532A7C_520D_434B_A535_2B7D1BDF915F#873506, Nom Naissance_Caractères-spéciaux, COL_687009AE_1AB8_452A_A46D_474C97111A87#873507, Année de Naissance_Valeur-Anormale, COL_1ADE8408_96AB_4C46_8297_5F40911D23CF#873508, Mois de Naissance_Valeur-Anormale, ... 3 more fields), [COL_E6AE24ED_8026_495F_A48A_A236DF26A045#873477, COL_4A1CE955_6068_4C7E_A3E5_D1247E0D721C#873478, COL_1AB4B887_3C06_4F3A_ABF9_7AD8B2A320C0#873479, COL_D567C154_8DAA_4940_917F_47BC849D79C6#873480, COL_F7E49028_833B_451A_9E47_6BD3A0E316BF#873481, COL_3228D314_43D6_4FC0_93CF_06B11ACB10C3#873482, COL_94D8C66B_9389_4B85_AB9D_6D5C783EAB35#873486, COL_FF0B1DCA_05CD_4386_8A58_A3EBAB686C31#873487, COL_0C2F7757_16EE_45C2_81B7_A383DF708478#873490, COL_5E05192E_2B2D_47F7_ACEA_8D574028FB87#873586L], false, [col0#873810, col1#873811]

Project [COL_E6AE24ED_8026_495F_A48A_A236DF26A045#873477, COL_4A1CE955_6068_4C7E_A3E5_D1247E0D721C#873478, COL_1AB4B887_3C06_4F3A_ABF9_7AD8B2A320C0#873479, COL_D567C154_8DAA_4940_917F_47BC849D79C6#873480, COL_F7E49028_833B_451A_9E47_6BD3A0E316BF#873481, COL_3228D314_43D6_4FC0_93CF_06B11ACB10C3#873482, COL_94D8C66B_9389_4B85_AB9D_6D5C783EAB35#873486, COL_FF0B1DCA_05CD_4386_8A58_A3EBAB686C31#873487, COL_0C2F7757_16EE_45C2_81B7_A383DF708478#873490, COL_5E05192E_2B2D_47F7_ACEA_8D574028FB87#873586L, COL_B33BB2B1_4367_4C17_9E85_E1B83CEDA1F7#873498, COL_5E2D72EA_FAB1_400C_B520_52899F382EF3#873499, COL_9A64A372_5DD3_4A81_996C_613299ACD186#873500, COL_73505A0D_7059_4377_994F_AAAAC3967AE3#873501, COL_707861E9_0D04_42B9_BA95_403D54B5DC30#873502, COL_5537EF2F_DF84_4745_87EE_5F3BF426F665#873503, COL_9E2C1846_0355_4576_B77B_428DBDB090B0#873504, COL_4DD24825_2E66_4A12_BFE1_E5EA1B1621A3#873505, COL_4B532A7C_520D_434B_A535_2B7D1BDF915F#873506, COL_687009AE_1AB8_452A_A46D_474C97111A87#873507, COL_1ADE8408_96AB_4C46_8297_5F40911D23CF#873508, COL_AEEB13C5_B876_49B3_B291_94824FC83DB9#873509, COL_955D854F_430E_4A06_B726_979CD9E42132#873510]

WholeStageCodegen (3)

Window [count(1) windowspecdefinition(1, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_5E05192E_2B2D_47F7_ACEA_8D574028FB87#873586L], [1], [1 DESC NULLS LAST]

Sort [1 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0

WholeStageCodegen (2)

AQEShuffleRead coalesced

Exchange hashpartitioning(1, 10), ENSURE_REQUIREMENTS, [plan_id=117289]

Project [COL_048BE89C_8DF3_4FD9_8C59_0CA9BEA4176E#873177 AS COL_E6AE24ED_8026_495F_A48A_A236DF26A045#873477, COL_E629F76D_863A_4E83_AD7C_492C57E4101F#873178 AS COL_4A1CE955_6068_4C7E_A3E5_D1247E0D721C#873478, COL_E597AE48_3139_4249_BFDD_5C3C79C385B4#873179 AS COL_1AB4B887_3C06_4F3A_ABF9_7AD8B2A320C0#873479, COL_72635379_B018_4685_A1CC_92B117EF7EE7#873180 AS COL_D567C154_8DAA_4940_917F_47BC849D79C6#873480, COL_16E8EFFC_F554_4DC7_BDB9_319838F1DC37#873181 AS COL_F7E49028_833B_451A_9E47_6BD3A0E316BF#873481, COL_CCDC5A97_B422_48F9_9469_688A0DB55E03#873182 AS COL_3228D314_43D6_4FC0_93CF_06B11ACB10C3#873482, COL_56CCE68D_F02B_4AB1_BD66_4C704318B343#873186 AS COL_94D8C66B_9389_4B85_AB9D_6D5C783EAB35#873486, COL_09C049A5_7EB3_4AD9_9A4E_3485C4213E23#873187 AS COL_FF0B1DCA_05CD_4386_8A58_A3EBAB686C31#873487, COL_D466463E_85A4_4DE1_BB8C_2545604A7F54#873190 AS COL_0C2F7757_16EE_45C2_81B7_A383DF708478#873490, COL_16EC77F7_2283_4184_8409_4632F6CC15D3#873202 AS COL_B33BB2B1_4367_4C17_9E85_E1B83CEDA1F7#873498, COL_0738E545_DA3C_4C7F_BB3B_257B05496299#873203 AS COL_5E2D72EA_FAB1_400C_B520_52899F382EF3#873499, COL_B541F517_3A48_482B_A549_61AF5D172C6A#873215 AS COL_9A64A372_5DD3_4A81_996C_613299ACD186#873500, COL_11E8518B_C561_41A3_B5F9_74AB5187CDFC#873204 AS COL_73505A0D_7059_4377_994F_AAAAC3967AE3#873501, COL_B7441708_F9D2_4A2B_A397_8031C245497A#873212 AS COL_707861E9_0D04_42B9_BA95_403D54B5DC30#873502, COL_4A1D33D9_AEA4_4FAD_9BE2_F297C2BD00A5#873213 AS COL_5537EF2F_DF84_4745_87EE_5F3BF426F665#873503, COL_79A0D231_EA5A_4393_8B5B_3143358BCB50#873214 AS COL_9E2C1846_0355_4576_B77B_428DBDB090B0#873504, COL_718CE93B_A655_4623_A0DF_7B4858DBDBB2#873209 AS COL_4DD24825_2E66_4A12_BFE1_E5EA1B1621A3#873505, COL_8A4EC729_7CD0_45C2_9CE4_634409841EC5#873210 AS COL_4B532A7C_520D_434B_A535_2B7D1BDF915F#873506, COL_8A4EC729_7CD0_45C2_9CE4_634409841EC5#873210 AS COL_687009AE_1AB8_452A_A46D_474C97111A87#873507, COL_2126D381_FE6F_4D42_B46F_52B8D3FC58C1#873205 AS COL_1ADE8408_96AB_4C46_8297_5F40911D23CF#873508, COL_708C36C9_E248_4128_836B_F5A59970BDE2#873206 AS COL_AEEB13C5_B876_49B3_B291_94824FC83DB9#873509, COL_FC8B1025_0807_4366_B5F4_AD69D392ABAC#873207 AS COL_955D854F_430E_4A06_B726_979CD9E42132#873510]

ColumnarToRow

WholeStageCodegen (1)

FileScan parquet [COL_048BE89C_8DF3_4FD9_8C59_0CA9BEA4176E#873177,COL_E629F76D_863A_4E83_AD7C_492C57E4101F#873178,COL_E597AE48_3139_4249_BFDD_5C3C79C385B4#873179,COL_72635379_B018_4685_A1CC_92B117EF7EE7#873180,COL_16E8EFFC_F554_4DC7_BDB9_319838F1DC37#873181,COL_CCDC5A97_B422_48F9_9469_688A0DB55E03#873182,COL_56CCE68D_F02B_4AB1_BD66_4C704318B343#873186,COL_09C049A5_7EB3_4AD9_9A4E_3485C4213E23#873187,COL_D466463E_85A4_4DE1_BB8C_2545604A7F54#873190,COL_16EC77F7_2283_4184_8409_4632F6CC15D3#873202,COL_0738E545_DA3C_4C7F_BB3B_257B05496299#873203,COL_11E8518B_C561_41A3_B5F9_74AB5187CDFC#873204,COL_2126D381_FE6F_4D42_B46F_52B8D3FC58C1#873205,COL_708C36C9_E248_4128_836B_F5A59970BDE2#873206,COL_FC8B1025_0807_4366_B5F4_AD69D392ABAC#873207,COL_718CE93B_A655_4623_A0DF_7B4858DBDBB2#873209,COL_8A4EC729_7CD0_45C2_9CE4_634409841EC5#873210,COL_B7441708_F9D2_4A2B_A397_8031C245497A#873212,COL_4A1D33D9_AEA4_4FAD_9BE2_F297C2BD00A5#873213,COL_79A0D231_EA5A_4393_8B5B_3143358BCB50#873214,COL_B541F517_3A48_482B_A549_61AF5D172C6A#873215] Batched: true, DataFilters: [], Format: Parquet, Location: InMemoryFileIndex(1 paths)[file:/data/output/cache/parquet/datablock/06_QUALITE_SEMA_112136], PartitionFilters: [], PushedFilters: [], ReadSchema: struct<COL_048BE89C_8DF3_4FD9_8C59_0CA9BEA4176E:string,COL_E629F76D_863A_4E83_AD7C_492C57E4101F:s...

Details

== Physical Plan ==
AdaptiveSparkPlan (50)
+- == Final Plan ==
   Execute InsertIntoHadoopFsRelationCommand (28)
   +- WriteFiles (27)
      +- * Project (26)
         +- Window (25)
            +- * Sort (24)
               +- AQEShuffleRead (23)
                  +- ShuffleQueryStage (22), Statistics(sizeInBytes=13.0 MiB, rowCount=4.34E+4)
                     +- Exchange (21)
                        +- Window (20)
                           +- * Filter (19)
                              +- Window (18)
                                 +- * Sort (17)
                                    +- ShuffleQueryStage (16), Statistics(sizeInBytes=149.6 MiB, rowCount=5.20E+5)
                                       +- Exchange (15)
                                          +- * Project (14)
                                             +- Window (13)
                                                +- * Sort (12)
                                                   +- * Project (11)
                                                      +- * Generate (10)
                                                         +- * Project (9)
                                                            +- Window (8)
                                                               +- * Sort (7)
                                                                  +- AQEShuffleRead (6)
                                                                     +- ShuffleQueryStage (5), Statistics(sizeInBytes=11.0 MiB, rowCount=4.00E+4)
                                                                        +- Exchange (4)
                                                                           +- * Project (3)
                                                                              +- * ColumnarToRow (2)
                                                                                 +- Scan parquet  (1)
+- == Initial Plan ==
   Execute InsertIntoHadoopFsRelationCommand (49)
   +- WriteFiles (48)
      +- Project (47)
         +- Window (46)
            +- Sort (45)
               +- Exchange (44)
                  +- Window (43)
                     +- Filter (42)
                        +- Window (41)
                           +- Sort (40)
                              +- Exchange (39)
                                 +- Project (38)
                                    +- Window (37)
                                       +- Sort (36)
                                          +- Project (35)
                                             +- Generate (34)
                                                +- Project (33)
                                                   +- Window (32)
                                                      +- Sort (31)
                                                         +- Exchange (30)
                                                            +- Project (29)
                                                               +- Scan parquet  (1)


(1) Scan parquet 
Output [21]: [COL_048BE89C_8DF3_4FD9_8C59_0CA9BEA4176E#873177, COL_E629F76D_863A_4E83_AD7C_492C57E4101F#873178, COL_E597AE48_3139_4249_BFDD_5C3C79C385B4#873179, COL_72635379_B018_4685_A1CC_92B117EF7EE7#873180, COL_16E8EFFC_F554_4DC7_BDB9_319838F1DC37#873181, COL_CCDC5A97_B422_48F9_9469_688A0DB55E03#873182, COL_56CCE68D_F02B_4AB1_BD66_4C704318B343#873186, COL_09C049A5_7EB3_4AD9_9A4E_3485C4213E23#873187, COL_D466463E_85A4_4DE1_BB8C_2545604A7F54#873190, COL_16EC77F7_2283_4184_8409_4632F6CC15D3#873202, COL_0738E545_DA3C_4C7F_BB3B_257B05496299#873203, COL_11E8518B_C561_41A3_B5F9_74AB5187CDFC#873204, COL_2126D381_FE6F_4D42_B46F_52B8D3FC58C1#873205, COL_708C36C9_E248_4128_836B_F5A59970BDE2#873206, COL_FC8B1025_0807_4366_B5F4_AD69D392ABAC#873207, COL_718CE93B_A655_4623_A0DF_7B4858DBDBB2#873209, COL_8A4EC729_7CD0_45C2_9CE4_634409841EC5#873210, COL_B7441708_F9D2_4A2B_A397_8031C245497A#873212, COL_4A1D33D9_AEA4_4FAD_9BE2_F297C2BD00A5#873213, COL_79A0D231_EA5A_4393_8B5B_3143358BCB50#873214, COL_B541F517_3A48_482B_A549_61AF5D172C6A#873215]
Batched: true
Location: InMemoryFileIndex [file:/data/output/cache/parquet/datablock/06_QUALITE_SEMA_112136]
ReadSchema: struct<COL_048BE89C_8DF3_4FD9_8C59_0CA9BEA4176E:string,COL_E629F76D_863A_4E83_AD7C_492C57E4101F:string,COL_E597AE48_3139_4249_BFDD_5C3C79C385B4:string,COL_72635379_B018_4685_A1CC_92B117EF7EE7:string,COL_16E8EFFC_F554_4DC7_BDB9_319838F1DC37:string,COL_CCDC5A97_B422_48F9_9469_688A0DB55E03:string,COL_56CCE68D_F02B_4AB1_BD66_4C704318B343:string,COL_09C049A5_7EB3_4AD9_9A4E_3485C4213E23:string,COL_D466463E_85A4_4DE1_BB8C_2545604A7F54:string,COL_16EC77F7_2283_4184_8409_4632F6CC15D3:int,COL_0738E545_DA3C_4C7F_BB3B_257B05496299:int,COL_11E8518B_C561_41A3_B5F9_74AB5187CDFC:int,COL_2126D381_FE6F_4D42_B46F_52B8D3FC58C1:int,COL_708C36C9_E248_4128_836B_F5A59970BDE2:int,COL_FC8B1025_0807_4366_B5F4_AD69D392ABAC:int,COL_718CE93B_A655_4623_A0DF_7B4858DBDBB2:int,COL_8A4EC729_7CD0_45C2_9CE4_634409841EC5:int,COL_B7441708_F9D2_4A2B_A397_8031C245497A:int,COL_4A1D33D9_AEA4_4FAD_9BE2_F297C2BD00A5:int,COL_79A0D231_EA5A_4393_8B5B_3143358BCB50:int,COL_B541F517_3A48_482B_A549_61AF5D172C6A:int>

(2) ColumnarToRow [codegen id : 1]
Input [21]: [COL_048BE89C_8DF3_4FD9_8C59_0CA9BEA4176E#873177, COL_E629F76D_863A_4E83_AD7C_492C57E4101F#873178, COL_E597AE48_3139_4249_BFDD_5C3C79C385B4#873179, COL_72635379_B018_4685_A1CC_92B117EF7EE7#873180, COL_16E8EFFC_F554_4DC7_BDB9_319838F1DC37#873181, COL_CCDC5A97_B422_48F9_9469_688A0DB55E03#873182, COL_56CCE68D_F02B_4AB1_BD66_4C704318B343#873186, COL_09C049A5_7EB3_4AD9_9A4E_3485C4213E23#873187, COL_D466463E_85A4_4DE1_BB8C_2545604A7F54#873190, COL_16EC77F7_2283_4184_8409_4632F6CC15D3#873202, COL_0738E545_DA3C_4C7F_BB3B_257B05496299#873203, COL_11E8518B_C561_41A3_B5F9_74AB5187CDFC#873204, COL_2126D381_FE6F_4D42_B46F_52B8D3FC58C1#873205, COL_708C36C9_E248_4128_836B_F5A59970BDE2#873206, COL_FC8B1025_0807_4366_B5F4_AD69D392ABAC#873207, COL_718CE93B_A655_4623_A0DF_7B4858DBDBB2#873209, COL_8A4EC729_7CD0_45C2_9CE4_634409841EC5#873210, COL_B7441708_F9D2_4A2B_A397_8031C245497A#873212, COL_4A1D33D9_AEA4_4FAD_9BE2_F297C2BD00A5#873213, COL_79A0D231_EA5A_4393_8B5B_3143358BCB50#873214, COL_B541F517_3A48_482B_A549_61AF5D172C6A#873215]

(3) Project [codegen id : 1]
Output [22]: [COL_048BE89C_8DF3_4FD9_8C59_0CA9BEA4176E#873177 AS COL_E6AE24ED_8026_495F_A48A_A236DF26A045#873477, COL_E629F76D_863A_4E83_AD7C_492C57E4101F#873178 AS COL_4A1CE955_6068_4C7E_A3E5_D1247E0D721C#873478, COL_E597AE48_3139_4249_BFDD_5C3C79C385B4#873179 AS COL_1AB4B887_3C06_4F3A_ABF9_7AD8B2A320C0#873479, COL_72635379_B018_4685_A1CC_92B117EF7EE7#873180 AS COL_D567C154_8DAA_4940_917F_47BC849D79C6#873480, COL_16E8EFFC_F554_4DC7_BDB9_319838F1DC37#873181 AS COL_F7E49028_833B_451A_9E47_6BD3A0E316BF#873481, COL_CCDC5A97_B422_48F9_9469_688A0DB55E03#873182 AS COL_3228D314_43D6_4FC0_93CF_06B11ACB10C3#873482, COL_56CCE68D_F02B_4AB1_BD66_4C704318B343#873186 AS COL_94D8C66B_9389_4B85_AB9D_6D5C783EAB35#873486, COL_09C049A5_7EB3_4AD9_9A4E_3485C4213E23#873187 AS COL_FF0B1DCA_05CD_4386_8A58_A3EBAB686C31#873487, COL_D466463E_85A4_4DE1_BB8C_2545604A7F54#873190 AS COL_0C2F7757_16EE_45C2_81B7_A383DF708478#873490, COL_16EC77F7_2283_4184_8409_4632F6CC15D3#873202 AS COL_B33BB2B1_4367_4C17_9E85_E1B83CEDA1F7#873498, COL_0738E545_DA3C_4C7F_BB3B_257B05496299#873203 AS COL_5E2D72EA_FAB1_400C_B520_52899F382EF3#873499, COL_B541F517_3A48_482B_A549_61AF5D172C6A#873215 AS COL_9A64A372_5DD3_4A81_996C_613299ACD186#873500, COL_11E8518B_C561_41A3_B5F9_74AB5187CDFC#873204 AS COL_73505A0D_7059_4377_994F_AAAAC3967AE3#873501, COL_B7441708_F9D2_4A2B_A397_8031C245497A#873212 AS COL_707861E9_0D04_42B9_BA95_403D54B5DC30#873502, COL_4A1D33D9_AEA4_4FAD_9BE2_F297C2BD00A5#873213 AS COL_5537EF2F_DF84_4745_87EE_5F3BF426F665#873503, COL_79A0D231_EA5A_4393_8B5B_3143358BCB50#873214 AS COL_9E2C1846_0355_4576_B77B_428DBDB090B0#873504, COL_718CE93B_A655_4623_A0DF_7B4858DBDBB2#873209 AS COL_4DD24825_2E66_4A12_BFE1_E5EA1B1621A3#873505, COL_8A4EC729_7CD0_45C2_9CE4_634409841EC5#873210 AS COL_4B532A7C_520D_434B_A535_2B7D1BDF915F#873506, COL_8A4EC729_7CD0_45C2_9CE4_634409841EC5#873210 AS COL_687009AE_1AB8_452A_A46D_474C97111A87#873507, COL_2126D381_FE6F_4D42_B46F_52B8D3FC58C1#873205 AS COL_1ADE8408_96AB_4C46_8297_5F40911D23CF#873508, COL_708C36C9_E248_4128_836B_F5A59970BDE2#873206 AS COL_AEEB13C5_B876_49B3_B291_94824FC83DB9#873509, COL_FC8B1025_0807_4366_B5F4_AD69D392ABAC#873207 AS COL_955D854F_430E_4A06_B726_979CD9E42132#873510]
Input [21]: [COL_048BE89C_8DF3_4FD9_8C59_0CA9BEA4176E#873177, COL_E629F76D_863A_4E83_AD7C_492C57E4101F#873178, COL_E597AE48_3139_4249_BFDD_5C3C79C385B4#873179, COL_72635379_B018_4685_A1CC_92B117EF7EE7#873180, COL_16E8EFFC_F554_4DC7_BDB9_319838F1DC37#873181, COL_CCDC5A97_B422_48F9_9469_688A0DB55E03#873182, COL_56CCE68D_F02B_4AB1_BD66_4C704318B343#873186, COL_09C049A5_7EB3_4AD9_9A4E_3485C4213E23#873187, COL_D466463E_85A4_4DE1_BB8C_2545604A7F54#873190, COL_16EC77F7_2283_4184_8409_4632F6CC15D3#873202, COL_0738E545_DA3C_4C7F_BB3B_257B05496299#873203, COL_11E8518B_C561_41A3_B5F9_74AB5187CDFC#873204, COL_2126D381_FE6F_4D42_B46F_52B8D3FC58C1#873205, COL_708C36C9_E248_4128_836B_F5A59970BDE2#873206, COL_FC8B1025_0807_4366_B5F4_AD69D392ABAC#873207, COL_718CE93B_A655_4623_A0DF_7B4858DBDBB2#873209, COL_8A4EC729_7CD0_45C2_9CE4_634409841EC5#873210, COL_B7441708_F9D2_4A2B_A397_8031C245497A#873212, COL_4A1D33D9_AEA4_4FAD_9BE2_F297C2BD00A5#873213, COL_79A0D231_EA5A_4393_8B5B_3143358BCB50#873214, COL_B541F517_3A48_482B_A549_61AF5D172C6A#873215]

(4) Exchange
Input [22]: [COL_E6AE24ED_8026_495F_A48A_A236DF26A045#873477, COL_4A1CE955_6068_4C7E_A3E5_D1247E0D721C#873478, COL_1AB4B887_3C06_4F3A_ABF9_7AD8B2A320C0#873479, COL_D567C154_8DAA_4940_917F_47BC849D79C6#873480, COL_F7E49028_833B_451A_9E47_6BD3A0E316BF#873481, COL_3228D314_43D6_4FC0_93CF_06B11ACB10C3#873482, COL_94D8C66B_9389_4B85_AB9D_6D5C783EAB35#873486, COL_FF0B1DCA_05CD_4386_8A58_A3EBAB686C31#873487, COL_0C2F7757_16EE_45C2_81B7_A383DF708478#873490, COL_B33BB2B1_4367_4C17_9E85_E1B83CEDA1F7#873498, COL_5E2D72EA_FAB1_400C_B520_52899F382EF3#873499, COL_9A64A372_5DD3_4A81_996C_613299ACD186#873500, COL_73505A0D_7059_4377_994F_AAAAC3967AE3#873501, COL_707861E9_0D04_42B9_BA95_403D54B5DC30#873502, COL_5537EF2F_DF84_4745_87EE_5F3BF426F665#873503, COL_9E2C1846_0355_4576_B77B_428DBDB090B0#873504, COL_4DD24825_2E66_4A12_BFE1_E5EA1B1621A3#873505, COL_4B532A7C_520D_434B_A535_2B7D1BDF915F#873506, COL_687009AE_1AB8_452A_A46D_474C97111A87#873507, COL_1ADE8408_96AB_4C46_8297_5F40911D23CF#873508, COL_AEEB13C5_B876_49B3_B291_94824FC83DB9#873509, COL_955D854F_430E_4A06_B726_979CD9E42132#873510]
Arguments: hashpartitioning(1, 10), ENSURE_REQUIREMENTS, [plan_id=117289]

(5) ShuffleQueryStage
Output [22]: [COL_E6AE24ED_8026_495F_A48A_A236DF26A045#873477, COL_4A1CE955_6068_4C7E_A3E5_D1247E0D721C#873478, COL_1AB4B887_3C06_4F3A_ABF9_7AD8B2A320C0#873479, COL_D567C154_8DAA_4940_917F_47BC849D79C6#873480, COL_F7E49028_833B_451A_9E47_6BD3A0E316BF#873481, COL_3228D314_43D6_4FC0_93CF_06B11ACB10C3#873482, COL_94D8C66B_9389_4B85_AB9D_6D5C783EAB35#873486, COL_FF0B1DCA_05CD_4386_8A58_A3EBAB686C31#873487, COL_0C2F7757_16EE_45C2_81B7_A383DF708478#873490, COL_B33BB2B1_4367_4C17_9E85_E1B83CEDA1F7#873498, COL_5E2D72EA_FAB1_400C_B520_52899F382EF3#873499, COL_9A64A372_5DD3_4A81_996C_613299ACD186#873500, COL_73505A0D_7059_4377_994F_AAAAC3967AE3#873501, COL_707861E9_0D04_42B9_BA95_403D54B5DC30#873502, COL_5537EF2F_DF84_4745_87EE_5F3BF426F665#873503, COL_9E2C1846_0355_4576_B77B_428DBDB090B0#873504, COL_4DD24825_2E66_4A12_BFE1_E5EA1B1621A3#873505, COL_4B532A7C_520D_434B_A535_2B7D1BDF915F#873506, COL_687009AE_1AB8_452A_A46D_474C97111A87#873507, COL_1ADE8408_96AB_4C46_8297_5F40911D23CF#873508, COL_AEEB13C5_B876_49B3_B291_94824FC83DB9#873509, COL_955D854F_430E_4A06_B726_979CD9E42132#873510]
Arguments: 0

(6) AQEShuffleRead
Input [22]: [COL_E6AE24ED_8026_495F_A48A_A236DF26A045#873477, COL_4A1CE955_6068_4C7E_A3E5_D1247E0D721C#873478, COL_1AB4B887_3C06_4F3A_ABF9_7AD8B2A320C0#873479, COL_D567C154_8DAA_4940_917F_47BC849D79C6#873480, COL_F7E49028_833B_451A_9E47_6BD3A0E316BF#873481, COL_3228D314_43D6_4FC0_93CF_06B11ACB10C3#873482, COL_94D8C66B_9389_4B85_AB9D_6D5C783EAB35#873486, COL_FF0B1DCA_05CD_4386_8A58_A3EBAB686C31#873487, COL_0C2F7757_16EE_45C2_81B7_A383DF708478#873490, COL_B33BB2B1_4367_4C17_9E85_E1B83CEDA1F7#873498, COL_5E2D72EA_FAB1_400C_B520_52899F382EF3#873499, COL_9A64A372_5DD3_4A81_996C_613299ACD186#873500, COL_73505A0D_7059_4377_994F_AAAAC3967AE3#873501, COL_707861E9_0D04_42B9_BA95_403D54B5DC30#873502, COL_5537EF2F_DF84_4745_87EE_5F3BF426F665#873503, COL_9E2C1846_0355_4576_B77B_428DBDB090B0#873504, COL_4DD24825_2E66_4A12_BFE1_E5EA1B1621A3#873505, COL_4B532A7C_520D_434B_A535_2B7D1BDF915F#873506, COL_687009AE_1AB8_452A_A46D_474C97111A87#873507, COL_1ADE8408_96AB_4C46_8297_5F40911D23CF#873508, COL_AEEB13C5_B876_49B3_B291_94824FC83DB9#873509, COL_955D854F_430E_4A06_B726_979CD9E42132#873510]
Arguments: coalesced

(7) Sort [codegen id : 2]
Input [22]: [COL_E6AE24ED_8026_495F_A48A_A236DF26A045#873477, COL_4A1CE955_6068_4C7E_A3E5_D1247E0D721C#873478, COL_1AB4B887_3C06_4F3A_ABF9_7AD8B2A320C0#873479, COL_D567C154_8DAA_4940_917F_47BC849D79C6#873480, COL_F7E49028_833B_451A_9E47_6BD3A0E316BF#873481, COL_3228D314_43D6_4FC0_93CF_06B11ACB10C3#873482, COL_94D8C66B_9389_4B85_AB9D_6D5C783EAB35#873486, COL_FF0B1DCA_05CD_4386_8A58_A3EBAB686C31#873487, COL_0C2F7757_16EE_45C2_81B7_A383DF708478#873490, COL_B33BB2B1_4367_4C17_9E85_E1B83CEDA1F7#873498, COL_5E2D72EA_FAB1_400C_B520_52899F382EF3#873499, COL_9A64A372_5DD3_4A81_996C_613299ACD186#873500, COL_73505A0D_7059_4377_994F_AAAAC3967AE3#873501, COL_707861E9_0D04_42B9_BA95_403D54B5DC30#873502, COL_5537EF2F_DF84_4745_87EE_5F3BF426F665#873503, COL_9E2C1846_0355_4576_B77B_428DBDB090B0#873504, COL_4DD24825_2E66_4A12_BFE1_E5EA1B1621A3#873505, COL_4B532A7C_520D_434B_A535_2B7D1BDF915F#873506, COL_687009AE_1AB8_452A_A46D_474C97111A87#873507, COL_1ADE8408_96AB_4C46_8297_5F40911D23CF#873508, COL_AEEB13C5_B876_49B3_B291_94824FC83DB9#873509, COL_955D854F_430E_4A06_B726_979CD9E42132#873510]
Arguments: [1 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0

(8) Window
Input [22]: [COL_E6AE24ED_8026_495F_A48A_A236DF26A045#873477, COL_4A1CE955_6068_4C7E_A3E5_D1247E0D721C#873478, COL_1AB4B887_3C06_4F3A_ABF9_7AD8B2A320C0#873479, COL_D567C154_8DAA_4940_917F_47BC849D79C6#873480, COL_F7E49028_833B_451A_9E47_6BD3A0E316BF#873481, COL_3228D314_43D6_4FC0_93CF_06B11ACB10C3#873482, COL_94D8C66B_9389_4B85_AB9D_6D5C783EAB35#873486, COL_FF0B1DCA_05CD_4386_8A58_A3EBAB686C31#873487, COL_0C2F7757_16EE_45C2_81B7_A383DF708478#873490, COL_B33BB2B1_4367_4C17_9E85_E1B83CEDA1F7#873498, COL_5E2D72EA_FAB1_400C_B520_52899F382EF3#873499, COL_9A64A372_5DD3_4A81_996C_613299ACD186#873500, COL_73505A0D_7059_4377_994F_AAAAC3967AE3#873501, COL_707861E9_0D04_42B9_BA95_403D54B5DC30#873502, COL_5537EF2F_DF84_4745_87EE_5F3BF426F665#873503, COL_9E2C1846_0355_4576_B77B_428DBDB090B0#873504, COL_4DD24825_2E66_4A12_BFE1_E5EA1B1621A3#873505, COL_4B532A7C_520D_434B_A535_2B7D1BDF915F#873506, COL_687009AE_1AB8_452A_A46D_474C97111A87#873507, COL_1ADE8408_96AB_4C46_8297_5F40911D23CF#873508, COL_AEEB13C5_B876_49B3_B291_94824FC83DB9#873509, COL_955D854F_430E_4A06_B726_979CD9E42132#873510]
Arguments: [count(1) windowspecdefinition(1, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_5E05192E_2B2D_47F7_ACEA_8D574028FB87#873586L], [1], [1 DESC NULLS LAST]

(9) Project [codegen id : 3]
Output [23]: [COL_E6AE24ED_8026_495F_A48A_A236DF26A045#873477, COL_4A1CE955_6068_4C7E_A3E5_D1247E0D721C#873478, COL_1AB4B887_3C06_4F3A_ABF9_7AD8B2A320C0#873479, COL_D567C154_8DAA_4940_917F_47BC849D79C6#873480, COL_F7E49028_833B_451A_9E47_6BD3A0E316BF#873481, COL_3228D314_43D6_4FC0_93CF_06B11ACB10C3#873482, COL_94D8C66B_9389_4B85_AB9D_6D5C783EAB35#873486, COL_FF0B1DCA_05CD_4386_8A58_A3EBAB686C31#873487, COL_0C2F7757_16EE_45C2_81B7_A383DF708478#873490, COL_5E05192E_2B2D_47F7_ACEA_8D574028FB87#873586L, COL_B33BB2B1_4367_4C17_9E85_E1B83CEDA1F7#873498, COL_5E2D72EA_FAB1_400C_B520_52899F382EF3#873499, COL_9A64A372_5DD3_4A81_996C_613299ACD186#873500, COL_73505A0D_7059_4377_994F_AAAAC3967AE3#873501, COL_707861E9_0D04_42B9_BA95_403D54B5DC30#873502, COL_5537EF2F_DF84_4745_87EE_5F3BF426F665#873503, COL_9E2C1846_0355_4576_B77B_428DBDB090B0#873504, COL_4DD24825_2E66_4A12_BFE1_E5EA1B1621A3#873505, COL_4B532A7C_520D_434B_A535_2B7D1BDF915F#873506, COL_687009AE_1AB8_452A_A46D_474C97111A87#873507, COL_1ADE8408_96AB_4C46_8297_5F40911D23CF#873508, COL_AEEB13C5_B876_49B3_B291_94824FC83DB9#873509, COL_955D854F_430E_4A06_B726_979CD9E42132#873510]
Input [23]: [COL_E6AE24ED_8026_495F_A48A_A236DF26A045#873477, COL_4A1CE955_6068_4C7E_A3E5_D1247E0D721C#873478, COL_1AB4B887_3C06_4F3A_ABF9_7AD8B2A320C0#873479, COL_D567C154_8DAA_4940_917F_47BC849D79C6#873480, COL_F7E49028_833B_451A_9E47_6BD3A0E316BF#873481, COL_3228D314_43D6_4FC0_93CF_06B11ACB10C3#873482, COL_94D8C66B_9389_4B85_AB9D_6D5C783EAB35#873486, COL_FF0B1DCA_05CD_4386_8A58_A3EBAB686C31#873487, COL_0C2F7757_16EE_45C2_81B7_A383DF708478#873490, COL_B33BB2B1_4367_4C17_9E85_E1B83CEDA1F7#873498, COL_5E2D72EA_FAB1_400C_B520_52899F382EF3#873499, COL_9A64A372_5DD3_4A81_996C_613299ACD186#873500, COL_73505A0D_7059_4377_994F_AAAAC3967AE3#873501, COL_707861E9_0D04_42B9_BA95_403D54B5DC30#873502, COL_5537EF2F_DF84_4745_87EE_5F3BF426F665#873503, COL_9E2C1846_0355_4576_B77B_428DBDB090B0#873504, COL_4DD24825_2E66_4A12_BFE1_E5EA1B1621A3#873505, COL_4B532A7C_520D_434B_A535_2B7D1BDF915F#873506, COL_687009AE_1AB8_452A_A46D_474C97111A87#873507, COL_1ADE8408_96AB_4C46_8297_5F40911D23CF#873508, COL_AEEB13C5_B876_49B3_B291_94824FC83DB9#873509, COL_955D854F_430E_4A06_B726_979CD9E42132#873510, COL_5E05192E_2B2D_47F7_ACEA_8D574028FB87#873586L]

(10) Generate [codegen id : 3]
Input [23]: [COL_E6AE24ED_8026_495F_A48A_A236DF26A045#873477, COL_4A1CE955_6068_4C7E_A3E5_D1247E0D721C#873478, COL_1AB4B887_3C06_4F3A_ABF9_7AD8B2A320C0#873479, COL_D567C154_8DAA_4940_917F_47BC849D79C6#873480, COL_F7E49028_833B_451A_9E47_6BD3A0E316BF#873481, COL_3228D314_43D6_4FC0_93CF_06B11ACB10C3#873482, COL_94D8C66B_9389_4B85_AB9D_6D5C783EAB35#873486, COL_FF0B1DCA_05CD_4386_8A58_A3EBAB686C31#873487, COL_0C2F7757_16EE_45C2_81B7_A383DF708478#873490, COL_5E05192E_2B2D_47F7_ACEA_8D574028FB87#873586L, COL_B33BB2B1_4367_4C17_9E85_E1B83CEDA1F7#873498, COL_5E2D72EA_FAB1_400C_B520_52899F382EF3#873499, COL_9A64A372_5DD3_4A81_996C_613299ACD186#873500, COL_73505A0D_7059_4377_994F_AAAAC3967AE3#873501, COL_707861E9_0D04_42B9_BA95_403D54B5DC30#873502, COL_5537EF2F_DF84_4745_87EE_5F3BF426F665#873503, COL_9E2C1846_0355_4576_B77B_428DBDB090B0#873504, COL_4DD24825_2E66_4A12_BFE1_E5EA1B1621A3#873505, COL_4B532A7C_520D_434B_A535_2B7D1BDF915F#873506, COL_687009AE_1AB8_452A_A46D_474C97111A87#873507, COL_1ADE8408_96AB_4C46_8297_5F40911D23CF#873508, COL_AEEB13C5_B876_49B3_B291_94824FC83DB9#873509, COL_955D854F_430E_4A06_B726_979CD9E42132#873510]
Arguments: stack(13, Nom Naissance_Minuscule-Partiel, COL_B33BB2B1_4367_4C17_9E85_E1B83CEDA1F7#873498, Commune_Minuscule-Partiel, COL_5E2D72EA_FAB1_400C_B520_52899F382EF3#873499, Ipp_Caractère-Anormal, COL_9A64A372_5DD3_4A81_996C_613299ACD186#873500, Sexe_Caractère-Anormal, COL_73505A0D_7059_4377_994F_AAAAC3967AE3#873501, Département_Longueur-Anormal, COL_707861E9_0D04_42B9_BA95_403D54B5DC30#873502, Code Postal_Longueur Anormal, COL_5537EF2F_DF84_4745_87EE_5F3BF426F665#873503, IPP_Longueur Anormal, COL_9E2C1846_0355_4576_B77B_428DBDB090B0#873504, Prénom_Caractères-spéciaux, COL_4DD24825_2E66_4A12_BFE1_E5EA1B1621A3#873505, Nom Naissance_Caractères-spéciaux, COL_4B532A7C_520D_434B_A535_2B7D1BDF915F#873506, Nom Naissance_Caractères-spéciaux, COL_687009AE_1AB8_452A_A46D_474C97111A87#873507, Année de Naissance_Valeur-Anormale, COL_1ADE8408_96AB_4C46_8297_5F40911D23CF#873508, Mois de Naissance_Valeur-Anormale, ... 3 more fields), [COL_E6AE24ED_8026_495F_A48A_A236DF26A045#873477, COL_4A1CE955_6068_4C7E_A3E5_D1247E0D721C#873478, COL_1AB4B887_3C06_4F3A_ABF9_7AD8B2A320C0#873479, COL_D567C154_8DAA_4940_917F_47BC849D79C6#873480, COL_F7E49028_833B_451A_9E47_6BD3A0E316BF#873481, COL_3228D314_43D6_4FC0_93CF_06B11ACB10C3#873482, COL_94D8C66B_9389_4B85_AB9D_6D5C783EAB35#873486, COL_FF0B1DCA_05CD_4386_8A58_A3EBAB686C31#873487, COL_0C2F7757_16EE_45C2_81B7_A383DF708478#873490, COL_5E05192E_2B2D_47F7_ACEA_8D574028FB87#873586L], false, [col0#873810, col1#873811]

(11) Project [codegen id : 3]
Output [14]: [col0#873810 AS COL_38355470_4B6E_4B4E_809B_5B281953DF16#873994, coalesce(col1#873811, 1) AS COL_F6F84F2D_321A_4741_BD1C_1CB6CD3D1D24#873995, COL_E6AE24ED_8026_495F_A48A_A236DF26A045#873477 AS COL_C285D4BB_A02E_4105_A400_1638DD0ACA0A#873996, COL_4A1CE955_6068_4C7E_A3E5_D1247E0D721C#873478 AS COL_C4879408_90C5_4F10_AF9F_648CDC892B1E#873997, COL_1AB4B887_3C06_4F3A_ABF9_7AD8B2A320C0#873479 AS COL_EA107784_8709_46B5_AA55_86D465A8BEA6#873998, COL_D567C154_8DAA_4940_917F_47BC849D79C6#873480 AS COL_56CB150D_6DAC_4787_A325_C454247FF0CC#873999, COL_F7E49028_833B_451A_9E47_6BD3A0E316BF#873481 AS COL_7042F62C_E148_4413_A7A5_097C945232F2#874000, COL_3228D314_43D6_4FC0_93CF_06B11ACB10C3#873482 AS COL_44B724FC_5FAF_4C3D_9106_AFCCC207B633#874001, COL_94D8C66B_9389_4B85_AB9D_6D5C783EAB35#873486 AS COL_B8C9FA08_2915_4ED7_A3BB_ADF6FA5643FD#874002, COL_FF0B1DCA_05CD_4386_8A58_A3EBAB686C31#873487 AS COL_00FCD646_8EDD_4E64_AF23_D9CA8773E369#874003, COL_0C2F7757_16EE_45C2_81B7_A383DF708478#873490 AS COL_98A321C5_57DC_439F_B059_7C5EF1A9642E#874004, COL_5E05192E_2B2D_47F7_ACEA_8D574028FB87#873586L AS COL_970D8DCA_C522_4183_8ACB_9C9DAB1DF1B8#874005L, str_extract_by_str(col0#873810, _, LEFT) AS COL_18F75DE4_51FC_4581_8B68_D191957AE6BE#874018, str_extract_by_str(col0#873810, _, RIGHT) AS COL_BB75DAC6_A718_4A29_9850_CA70D3D9DEFD#874032]
Input [12]: [COL_E6AE24ED_8026_495F_A48A_A236DF26A045#873477, COL_4A1CE955_6068_4C7E_A3E5_D1247E0D721C#873478, COL_1AB4B887_3C06_4F3A_ABF9_7AD8B2A320C0#873479, COL_D567C154_8DAA_4940_917F_47BC849D79C6#873480, COL_F7E49028_833B_451A_9E47_6BD3A0E316BF#873481, COL_3228D314_43D6_4FC0_93CF_06B11ACB10C3#873482, COL_94D8C66B_9389_4B85_AB9D_6D5C783EAB35#873486, COL_FF0B1DCA_05CD_4386_8A58_A3EBAB686C31#873487, COL_0C2F7757_16EE_45C2_81B7_A383DF708478#873490, COL_5E05192E_2B2D_47F7_ACEA_8D574028FB87#873586L, col0#873810, col1#873811]

(12) Sort [codegen id : 3]
Input [14]: [COL_38355470_4B6E_4B4E_809B_5B281953DF16#873994, COL_F6F84F2D_321A_4741_BD1C_1CB6CD3D1D24#873995, COL_C285D4BB_A02E_4105_A400_1638DD0ACA0A#873996, COL_C4879408_90C5_4F10_AF9F_648CDC892B1E#873997, COL_EA107784_8709_46B5_AA55_86D465A8BEA6#873998, COL_56CB150D_6DAC_4787_A325_C454247FF0CC#873999, COL_7042F62C_E148_4413_A7A5_097C945232F2#874000, COL_44B724FC_5FAF_4C3D_9106_AFCCC207B633#874001, COL_B8C9FA08_2915_4ED7_A3BB_ADF6FA5643FD#874002, COL_00FCD646_8EDD_4E64_AF23_D9CA8773E369#874003, COL_98A321C5_57DC_439F_B059_7C5EF1A9642E#874004, COL_970D8DCA_C522_4183_8ACB_9C9DAB1DF1B8#874005L, COL_18F75DE4_51FC_4581_8B68_D191957AE6BE#874018, COL_BB75DAC6_A718_4A29_9850_CA70D3D9DEFD#874032]
Arguments: [1 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0

(13) Window
Input [14]: [COL_38355470_4B6E_4B4E_809B_5B281953DF16#873994, COL_F6F84F2D_321A_4741_BD1C_1CB6CD3D1D24#873995, COL_C285D4BB_A02E_4105_A400_1638DD0ACA0A#873996, COL_C4879408_90C5_4F10_AF9F_648CDC892B1E#873997, COL_EA107784_8709_46B5_AA55_86D465A8BEA6#873998, COL_56CB150D_6DAC_4787_A325_C454247FF0CC#873999, COL_7042F62C_E148_4413_A7A5_097C945232F2#874000, COL_44B724FC_5FAF_4C3D_9106_AFCCC207B633#874001, COL_B8C9FA08_2915_4ED7_A3BB_ADF6FA5643FD#874002, COL_00FCD646_8EDD_4E64_AF23_D9CA8773E369#874003, COL_98A321C5_57DC_439F_B059_7C5EF1A9642E#874004, COL_970D8DCA_C522_4183_8ACB_9C9DAB1DF1B8#874005L, COL_18F75DE4_51FC_4581_8B68_D191957AE6BE#874018, COL_BB75DAC6_A718_4A29_9850_CA70D3D9DEFD#874032]
Arguments: [count(1) windowspecdefinition(1, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_FE7584CE_A7B9_4550_A540_36A08BA05397#874065L], [1], [1 DESC NULLS LAST]

(14) Project [codegen id : 4]
Output [15]: [COL_38355470_4B6E_4B4E_809B_5B281953DF16#873994, COL_C285D4BB_A02E_4105_A400_1638DD0ACA0A#873996, COL_C4879408_90C5_4F10_AF9F_648CDC892B1E#873997, COL_EA107784_8709_46B5_AA55_86D465A8BEA6#873998, COL_56CB150D_6DAC_4787_A325_C454247FF0CC#873999, COL_7042F62C_E148_4413_A7A5_097C945232F2#874000, COL_44B724FC_5FAF_4C3D_9106_AFCCC207B633#874001, COL_B8C9FA08_2915_4ED7_A3BB_ADF6FA5643FD#874002, COL_00FCD646_8EDD_4E64_AF23_D9CA8773E369#874003, COL_98A321C5_57DC_439F_B059_7C5EF1A9642E#874004, COL_18F75DE4_51FC_4581_8B68_D191957AE6BE#874018, COL_BB75DAC6_A718_4A29_9850_CA70D3D9DEFD#874032, COL_F6F84F2D_321A_4741_BD1C_1CB6CD3D1D24#873995, COL_970D8DCA_C522_4183_8ACB_9C9DAB1DF1B8#874005L, COL_FE7584CE_A7B9_4550_A540_36A08BA05397#874065L]
Input [15]: [COL_38355470_4B6E_4B4E_809B_5B281953DF16#873994, COL_F6F84F2D_321A_4741_BD1C_1CB6CD3D1D24#873995, COL_C285D4BB_A02E_4105_A400_1638DD0ACA0A#873996, COL_C4879408_90C5_4F10_AF9F_648CDC892B1E#873997, COL_EA107784_8709_46B5_AA55_86D465A8BEA6#873998, COL_56CB150D_6DAC_4787_A325_C454247FF0CC#873999, COL_7042F62C_E148_4413_A7A5_097C945232F2#874000, COL_44B724FC_5FAF_4C3D_9106_AFCCC207B633#874001, COL_B8C9FA08_2915_4ED7_A3BB_ADF6FA5643FD#874002, COL_00FCD646_8EDD_4E64_AF23_D9CA8773E369#874003, COL_98A321C5_57DC_439F_B059_7C5EF1A9642E#874004, COL_970D8DCA_C522_4183_8ACB_9C9DAB1DF1B8#874005L, COL_18F75DE4_51FC_4581_8B68_D191957AE6BE#874018, COL_BB75DAC6_A718_4A29_9850_CA70D3D9DEFD#874032, COL_FE7584CE_A7B9_4550_A540_36A08BA05397#874065L]

(15) Exchange
Input [15]: [COL_38355470_4B6E_4B4E_809B_5B281953DF16#873994, COL_C285D4BB_A02E_4105_A400_1638DD0ACA0A#873996, COL_C4879408_90C5_4F10_AF9F_648CDC892B1E#873997, COL_EA107784_8709_46B5_AA55_86D465A8BEA6#873998, COL_56CB150D_6DAC_4787_A325_C454247FF0CC#873999, COL_7042F62C_E148_4413_A7A5_097C945232F2#874000, COL_44B724FC_5FAF_4C3D_9106_AFCCC207B633#874001, COL_B8C9FA08_2915_4ED7_A3BB_ADF6FA5643FD#874002, COL_00FCD646_8EDD_4E64_AF23_D9CA8773E369#874003, COL_98A321C5_57DC_439F_B059_7C5EF1A9642E#874004, COL_18F75DE4_51FC_4581_8B68_D191957AE6BE#874018, COL_BB75DAC6_A718_4A29_9850_CA70D3D9DEFD#874032, COL_F6F84F2D_321A_4741_BD1C_1CB6CD3D1D24#873995, COL_970D8DCA_C522_4183_8ACB_9C9DAB1DF1B8#874005L, COL_FE7584CE_A7B9_4550_A540_36A08BA05397#874065L]
Arguments: hashpartitioning(COL_C285D4BB_A02E_4105_A400_1638DD0ACA0A#873996, 10), ENSURE_REQUIREMENTS, [plan_id=117427]

(16) ShuffleQueryStage
Output [15]: [COL_38355470_4B6E_4B4E_809B_5B281953DF16#873994, COL_C285D4BB_A02E_4105_A400_1638DD0ACA0A#873996, COL_C4879408_90C5_4F10_AF9F_648CDC892B1E#873997, COL_EA107784_8709_46B5_AA55_86D465A8BEA6#873998, COL_56CB150D_6DAC_4787_A325_C454247FF0CC#873999, COL_7042F62C_E148_4413_A7A5_097C945232F2#874000, COL_44B724FC_5FAF_4C3D_9106_AFCCC207B633#874001, COL_B8C9FA08_2915_4ED7_A3BB_ADF6FA5643FD#874002, COL_00FCD646_8EDD_4E64_AF23_D9CA8773E369#874003, COL_98A321C5_57DC_439F_B059_7C5EF1A9642E#874004, COL_18F75DE4_51FC_4581_8B68_D191957AE6BE#874018, COL_BB75DAC6_A718_4A29_9850_CA70D3D9DEFD#874032, COL_F6F84F2D_321A_4741_BD1C_1CB6CD3D1D24#873995, COL_970D8DCA_C522_4183_8ACB_9C9DAB1DF1B8#874005L, COL_FE7584CE_A7B9_4550_A540_36A08BA05397#874065L]
Arguments: 1

(17) Sort [codegen id : 5]
Input [15]: [COL_38355470_4B6E_4B4E_809B_5B281953DF16#873994, COL_C285D4BB_A02E_4105_A400_1638DD0ACA0A#873996, COL_C4879408_90C5_4F10_AF9F_648CDC892B1E#873997, COL_EA107784_8709_46B5_AA55_86D465A8BEA6#873998, COL_56CB150D_6DAC_4787_A325_C454247FF0CC#873999, COL_7042F62C_E148_4413_A7A5_097C945232F2#874000, COL_44B724FC_5FAF_4C3D_9106_AFCCC207B633#874001, COL_B8C9FA08_2915_4ED7_A3BB_ADF6FA5643FD#874002, COL_00FCD646_8EDD_4E64_AF23_D9CA8773E369#874003, COL_98A321C5_57DC_439F_B059_7C5EF1A9642E#874004, COL_18F75DE4_51FC_4581_8B68_D191957AE6BE#874018, COL_BB75DAC6_A718_4A29_9850_CA70D3D9DEFD#874032, COL_F6F84F2D_321A_4741_BD1C_1CB6CD3D1D24#873995, COL_970D8DCA_C522_4183_8ACB_9C9DAB1DF1B8#874005L, COL_FE7584CE_A7B9_4550_A540_36A08BA05397#874065L]
Arguments: [COL_C285D4BB_A02E_4105_A400_1638DD0ACA0A#873996 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0

(18) Window
Input [15]: [COL_38355470_4B6E_4B4E_809B_5B281953DF16#873994, COL_C285D4BB_A02E_4105_A400_1638DD0ACA0A#873996, COL_C4879408_90C5_4F10_AF9F_648CDC892B1E#873997, COL_EA107784_8709_46B5_AA55_86D465A8BEA6#873998, COL_56CB150D_6DAC_4787_A325_C454247FF0CC#873999, COL_7042F62C_E148_4413_A7A5_097C945232F2#874000, COL_44B724FC_5FAF_4C3D_9106_AFCCC207B633#874001, COL_B8C9FA08_2915_4ED7_A3BB_ADF6FA5643FD#874002, COL_00FCD646_8EDD_4E64_AF23_D9CA8773E369#874003, COL_98A321C5_57DC_439F_B059_7C5EF1A9642E#874004, COL_18F75DE4_51FC_4581_8B68_D191957AE6BE#874018, COL_BB75DAC6_A718_4A29_9850_CA70D3D9DEFD#874032, COL_F6F84F2D_321A_4741_BD1C_1CB6CD3D1D24#873995, COL_970D8DCA_C522_4183_8ACB_9C9DAB1DF1B8#874005L, COL_FE7584CE_A7B9_4550_A540_36A08BA05397#874065L]
Arguments: [count(1) windowspecdefinition(COL_C285D4BB_A02E_4105_A400_1638DD0ACA0A#873996, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_A0131DDF_C92E_4028_9DDB_1E1BE78CA89A#874177L], [COL_C285D4BB_A02E_4105_A400_1638DD0ACA0A#873996], [1 DESC NULLS LAST]

(19) Filter [codegen id : 6]
Input [16]: [COL_38355470_4B6E_4B4E_809B_5B281953DF16#873994, COL_C285D4BB_A02E_4105_A400_1638DD0ACA0A#873996, COL_C4879408_90C5_4F10_AF9F_648CDC892B1E#873997, COL_EA107784_8709_46B5_AA55_86D465A8BEA6#873998, COL_56CB150D_6DAC_4787_A325_C454247FF0CC#873999, COL_7042F62C_E148_4413_A7A5_097C945232F2#874000, COL_44B724FC_5FAF_4C3D_9106_AFCCC207B633#874001, COL_B8C9FA08_2915_4ED7_A3BB_ADF6FA5643FD#874002, COL_00FCD646_8EDD_4E64_AF23_D9CA8773E369#874003, COL_98A321C5_57DC_439F_B059_7C5EF1A9642E#874004, COL_18F75DE4_51FC_4581_8B68_D191957AE6BE#874018, COL_BB75DAC6_A718_4A29_9850_CA70D3D9DEFD#874032, COL_F6F84F2D_321A_4741_BD1C_1CB6CD3D1D24#873995, COL_970D8DCA_C522_4183_8ACB_9C9DAB1DF1B8#874005L, COL_FE7584CE_A7B9_4550_A540_36A08BA05397#874065L, COL_A0131DDF_C92E_4028_9DDB_1E1BE78CA89A#874177L]
Condition : (COL_F6F84F2D_321A_4741_BD1C_1CB6CD3D1D24#873995 <=> 1)

(20) Window
Input [16]: [COL_38355470_4B6E_4B4E_809B_5B281953DF16#873994, COL_C285D4BB_A02E_4105_A400_1638DD0ACA0A#873996, COL_C4879408_90C5_4F10_AF9F_648CDC892B1E#873997, COL_EA107784_8709_46B5_AA55_86D465A8BEA6#873998, COL_56CB150D_6DAC_4787_A325_C454247FF0CC#873999, COL_7042F62C_E148_4413_A7A5_097C945232F2#874000, COL_44B724FC_5FAF_4C3D_9106_AFCCC207B633#874001, COL_B8C9FA08_2915_4ED7_A3BB_ADF6FA5643FD#874002, COL_00FCD646_8EDD_4E64_AF23_D9CA8773E369#874003, COL_98A321C5_57DC_439F_B059_7C5EF1A9642E#874004, COL_18F75DE4_51FC_4581_8B68_D191957AE6BE#874018, COL_BB75DAC6_A718_4A29_9850_CA70D3D9DEFD#874032, COL_F6F84F2D_321A_4741_BD1C_1CB6CD3D1D24#873995, COL_970D8DCA_C522_4183_8ACB_9C9DAB1DF1B8#874005L, COL_FE7584CE_A7B9_4550_A540_36A08BA05397#874065L, COL_A0131DDF_C92E_4028_9DDB_1E1BE78CA89A#874177L]
Arguments: [count(1) windowspecdefinition(COL_C285D4BB_A02E_4105_A400_1638DD0ACA0A#873996, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_5CDBD9C9_E94A_4107_89EF_FFA3714428AB#874360L], [COL_C285D4BB_A02E_4105_A400_1638DD0ACA0A#873996], [1 DESC NULLS LAST]

(21) Exchange
Input [17]: [COL_38355470_4B6E_4B4E_809B_5B281953DF16#873994, COL_C285D4BB_A02E_4105_A400_1638DD0ACA0A#873996, COL_C4879408_90C5_4F10_AF9F_648CDC892B1E#873997, COL_EA107784_8709_46B5_AA55_86D465A8BEA6#873998, COL_56CB150D_6DAC_4787_A325_C454247FF0CC#873999, COL_7042F62C_E148_4413_A7A5_097C945232F2#874000, COL_44B724FC_5FAF_4C3D_9106_AFCCC207B633#874001, COL_B8C9FA08_2915_4ED7_A3BB_ADF6FA5643FD#874002, COL_00FCD646_8EDD_4E64_AF23_D9CA8773E369#874003, COL_98A321C5_57DC_439F_B059_7C5EF1A9642E#874004, COL_18F75DE4_51FC_4581_8B68_D191957AE6BE#874018, COL_BB75DAC6_A718_4A29_9850_CA70D3D9DEFD#874032, COL_F6F84F2D_321A_4741_BD1C_1CB6CD3D1D24#873995, COL_970D8DCA_C522_4183_8ACB_9C9DAB1DF1B8#874005L, COL_FE7584CE_A7B9_4550_A540_36A08BA05397#874065L, COL_A0131DDF_C92E_4028_9DDB_1E1BE78CA89A#874177L, COL_5CDBD9C9_E94A_4107_89EF_FFA3714428AB#874360L]
Arguments: hashpartitioning(1, 10), ENSURE_REQUIREMENTS, [plan_id=117512]

(22) ShuffleQueryStage
Output [17]: [COL_38355470_4B6E_4B4E_809B_5B281953DF16#873994, COL_C285D4BB_A02E_4105_A400_1638DD0ACA0A#873996, COL_C4879408_90C5_4F10_AF9F_648CDC892B1E#873997, COL_EA107784_8709_46B5_AA55_86D465A8BEA6#873998, COL_56CB150D_6DAC_4787_A325_C454247FF0CC#873999, COL_7042F62C_E148_4413_A7A5_097C945232F2#874000, COL_44B724FC_5FAF_4C3D_9106_AFCCC207B633#874001, COL_B8C9FA08_2915_4ED7_A3BB_ADF6FA5643FD#874002, COL_00FCD646_8EDD_4E64_AF23_D9CA8773E369#874003, COL_98A321C5_57DC_439F_B059_7C5EF1A9642E#874004, COL_18F75DE4_51FC_4581_8B68_D191957AE6BE#874018, COL_BB75DAC6_A718_4A29_9850_CA70D3D9DEFD#874032, COL_F6F84F2D_321A_4741_BD1C_1CB6CD3D1D24#873995, COL_970D8DCA_C522_4183_8ACB_9C9DAB1DF1B8#874005L, COL_FE7584CE_A7B9_4550_A540_36A08BA05397#874065L, COL_A0131DDF_C92E_4028_9DDB_1E1BE78CA89A#874177L, COL_5CDBD9C9_E94A_4107_89EF_FFA3714428AB#874360L]
Arguments: 2

(23) AQEShuffleRead
Input [17]: [COL_38355470_4B6E_4B4E_809B_5B281953DF16#873994, COL_C285D4BB_A02E_4105_A400_1638DD0ACA0A#873996, COL_C4879408_90C5_4F10_AF9F_648CDC892B1E#873997, COL_EA107784_8709_46B5_AA55_86D465A8BEA6#873998, COL_56CB150D_6DAC_4787_A325_C454247FF0CC#873999, COL_7042F62C_E148_4413_A7A5_097C945232F2#874000, COL_44B724FC_5FAF_4C3D_9106_AFCCC207B633#874001, COL_B8C9FA08_2915_4ED7_A3BB_ADF6FA5643FD#874002, COL_00FCD646_8EDD_4E64_AF23_D9CA8773E369#874003, COL_98A321C5_57DC_439F_B059_7C5EF1A9642E#874004, COL_18F75DE4_51FC_4581_8B68_D191957AE6BE#874018, COL_BB75DAC6_A718_4A29_9850_CA70D3D9DEFD#874032, COL_F6F84F2D_321A_4741_BD1C_1CB6CD3D1D24#873995, COL_970D8DCA_C522_4183_8ACB_9C9DAB1DF1B8#874005L, COL_FE7584CE_A7B9_4550_A540_36A08BA05397#874065L, COL_A0131DDF_C92E_4028_9DDB_1E1BE78CA89A#874177L, COL_5CDBD9C9_E94A_4107_89EF_FFA3714428AB#874360L]
Arguments: coalesced

(24) Sort [codegen id : 7]
Input [17]: [COL_38355470_4B6E_4B4E_809B_5B281953DF16#873994, COL_C285D4BB_A02E_4105_A400_1638DD0ACA0A#873996, COL_C4879408_90C5_4F10_AF9F_648CDC892B1E#873997, COL_EA107784_8709_46B5_AA55_86D465A8BEA6#873998, COL_56CB150D_6DAC_4787_A325_C454247FF0CC#873999, COL_7042F62C_E148_4413_A7A5_097C945232F2#874000, COL_44B724FC_5FAF_4C3D_9106_AFCCC207B633#874001, COL_B8C9FA08_2915_4ED7_A3BB_ADF6FA5643FD#874002, COL_00FCD646_8EDD_4E64_AF23_D9CA8773E369#874003, COL_98A321C5_57DC_439F_B059_7C5EF1A9642E#874004, COL_18F75DE4_51FC_4581_8B68_D191957AE6BE#874018, COL_BB75DAC6_A718_4A29_9850_CA70D3D9DEFD#874032, COL_F6F84F2D_321A_4741_BD1C_1CB6CD3D1D24#873995, COL_970D8DCA_C522_4183_8ACB_9C9DAB1DF1B8#874005L, COL_FE7584CE_A7B9_4550_A540_36A08BA05397#874065L, COL_A0131DDF_C92E_4028_9DDB_1E1BE78CA89A#874177L, COL_5CDBD9C9_E94A_4107_89EF_FFA3714428AB#874360L]
Arguments: [1 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0

(25) Window
Input [17]: [COL_38355470_4B6E_4B4E_809B_5B281953DF16#873994, COL_C285D4BB_A02E_4105_A400_1638DD0ACA0A#873996, COL_C4879408_90C5_4F10_AF9F_648CDC892B1E#873997, COL_EA107784_8709_46B5_AA55_86D465A8BEA6#873998, COL_56CB150D_6DAC_4787_A325_C454247FF0CC#873999, COL_7042F62C_E148_4413_A7A5_097C945232F2#874000, COL_44B724FC_5FAF_4C3D_9106_AFCCC207B633#874001, COL_B8C9FA08_2915_4ED7_A3BB_ADF6FA5643FD#874002, COL_00FCD646_8EDD_4E64_AF23_D9CA8773E369#874003, COL_98A321C5_57DC_439F_B059_7C5EF1A9642E#874004, COL_18F75DE4_51FC_4581_8B68_D191957AE6BE#874018, COL_BB75DAC6_A718_4A29_9850_CA70D3D9DEFD#874032, COL_F6F84F2D_321A_4741_BD1C_1CB6CD3D1D24#873995, COL_970D8DCA_C522_4183_8ACB_9C9DAB1DF1B8#874005L, COL_FE7584CE_A7B9_4550_A540_36A08BA05397#874065L, COL_A0131DDF_C92E_4028_9DDB_1E1BE78CA89A#874177L, COL_5CDBD9C9_E94A_4107_89EF_FFA3714428AB#874360L]
Arguments: [count(1) windowspecdefinition(1, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_D232794D_6E04_42B4_88DD_D51030910AEA#874417L], [1], [1 DESC NULLS LAST]

(26) Project [codegen id : 8]
Output [19]: [COL_38355470_4B6E_4B4E_809B_5B281953DF16#873994, COL_C285D4BB_A02E_4105_A400_1638DD0ACA0A#873996, COL_C4879408_90C5_4F10_AF9F_648CDC892B1E#873997, COL_EA107784_8709_46B5_AA55_86D465A8BEA6#873998, COL_56CB150D_6DAC_4787_A325_C454247FF0CC#873999, COL_7042F62C_E148_4413_A7A5_097C945232F2#874000, COL_44B724FC_5FAF_4C3D_9106_AFCCC207B633#874001, COL_B8C9FA08_2915_4ED7_A3BB_ADF6FA5643FD#874002, COL_00FCD646_8EDD_4E64_AF23_D9CA8773E369#874003, COL_98A321C5_57DC_439F_B059_7C5EF1A9642E#874004, COL_18F75DE4_51FC_4581_8B68_D191957AE6BE#874018, COL_BB75DAC6_A718_4A29_9850_CA70D3D9DEFD#874032, COL_F6F84F2D_321A_4741_BD1C_1CB6CD3D1D24#873995, COL_5CDBD9C9_E94A_4107_89EF_FFA3714428AB#874360L, COL_A0131DDF_C92E_4028_9DDB_1E1BE78CA89A#874177L, round(dec_operator(PRODUIT, array(dec_operator(DIVISION, array(COL_5CDBD9C9_E94A_4107_89EF_FFA3714428AB#874360L, COL_A0131DDF_C92E_4028_9DDB_1E1BE78CA89A#874177L)), 100.0)), 2) AS COL_BA88332F_1B23_4847_9054_82AA2086A665#874638, COL_D232794D_6E04_42B4_88DD_D51030910AEA#874417L, COL_FE7584CE_A7B9_4550_A540_36A08BA05397#874065L, COL_970D8DCA_C522_4183_8ACB_9C9DAB1DF1B8#874005L]
Input [18]: [COL_38355470_4B6E_4B4E_809B_5B281953DF16#873994, COL_C285D4BB_A02E_4105_A400_1638DD0ACA0A#873996, COL_C4879408_90C5_4F10_AF9F_648CDC892B1E#873997, COL_EA107784_8709_46B5_AA55_86D465A8BEA6#873998, COL_56CB150D_6DAC_4787_A325_C454247FF0CC#873999, COL_7042F62C_E148_4413_A7A5_097C945232F2#874000, COL_44B724FC_5FAF_4C3D_9106_AFCCC207B633#874001, COL_B8C9FA08_2915_4ED7_A3BB_ADF6FA5643FD#874002, COL_00FCD646_8EDD_4E64_AF23_D9CA8773E369#874003, COL_98A321C5_57DC_439F_B059_7C5EF1A9642E#874004, COL_18F75DE4_51FC_4581_8B68_D191957AE6BE#874018, COL_BB75DAC6_A718_4A29_9850_CA70D3D9DEFD#874032, COL_F6F84F2D_321A_4741_BD1C_1CB6CD3D1D24#873995, COL_970D8DCA_C522_4183_8ACB_9C9DAB1DF1B8#874005L, COL_FE7584CE_A7B9_4550_A540_36A08BA05397#874065L, COL_A0131DDF_C92E_4028_9DDB_1E1BE78CA89A#874177L, COL_5CDBD9C9_E94A_4107_89EF_FFA3714428AB#874360L, COL_D232794D_6E04_42B4_88DD_D51030910AEA#874417L]

(27) WriteFiles
Input [19]: [COL_38355470_4B6E_4B4E_809B_5B281953DF16#873994, COL_C285D4BB_A02E_4105_A400_1638DD0ACA0A#873996, COL_C4879408_90C5_4F10_AF9F_648CDC892B1E#873997, COL_EA107784_8709_46B5_AA55_86D465A8BEA6#873998, COL_56CB150D_6DAC_4787_A325_C454247FF0CC#873999, COL_7042F62C_E148_4413_A7A5_097C945232F2#874000, COL_44B724FC_5FAF_4C3D_9106_AFCCC207B633#874001, COL_B8C9FA08_2915_4ED7_A3BB_ADF6FA5643FD#874002, COL_00FCD646_8EDD_4E64_AF23_D9CA8773E369#874003, COL_98A321C5_57DC_439F_B059_7C5EF1A9642E#874004, COL_18F75DE4_51FC_4581_8B68_D191957AE6BE#874018, COL_BB75DAC6_A718_4A29_9850_CA70D3D9DEFD#874032, COL_F6F84F2D_321A_4741_BD1C_1CB6CD3D1D24#873995, COL_5CDBD9C9_E94A_4107_89EF_FFA3714428AB#874360L, COL_A0131DDF_C92E_4028_9DDB_1E1BE78CA89A#874177L, COL_BA88332F_1B23_4847_9054_82AA2086A665#874638, COL_D232794D_6E04_42B4_88DD_D51030910AEA#874417L, COL_FE7584CE_A7B9_4550_A540_36A08BA05397#874065L, COL_970D8DCA_C522_4183_8ACB_9C9DAB1DF1B8#874005L]

(28) Execute InsertIntoHadoopFsRelationCommand
Input: []
Arguments: file:/data/output/cache/parquet/datablock/QUALITE_SEMANTI_66618, false, Parquet, [path=file:///data/output/cache/parquet/datablock/QUALITE_SEMANTI_66618], Overwrite, [COL_38355470_4B6E_4B4E_809B_5B281953DF16, COL_C285D4BB_A02E_4105_A400_1638DD0ACA0A, COL_C4879408_90C5_4F10_AF9F_648CDC892B1E, COL_EA107784_8709_46B5_AA55_86D465A8BEA6, COL_56CB150D_6DAC_4787_A325_C454247FF0CC, COL_7042F62C_E148_4413_A7A5_097C945232F2, COL_44B724FC_5FAF_4C3D_9106_AFCCC207B633, COL_B8C9FA08_2915_4ED7_A3BB_ADF6FA5643FD, COL_00FCD646_8EDD_4E64_AF23_D9CA8773E369, COL_98A321C5_57DC_439F_B059_7C5EF1A9642E, COL_18F75DE4_51FC_4581_8B68_D191957AE6BE, COL_BB75DAC6_A718_4A29_9850_CA70D3D9DEFD, COL_F6F84F2D_321A_4741_BD1C_1CB6CD3D1D24, COL_5CDBD9C9_E94A_4107_89EF_FFA3714428AB, COL_A0131DDF_C92E_4028_9DDB_1E1BE78CA89A, COL_BA88332F_1B23_4847_9054_82AA2086A665, COL_D232794D_6E04_42B4_88DD_D51030910AEA, COL_FE7584CE_A7B9_4550_A540_36A08BA05397, COL_970D8DCA_C522_4183_8ACB_9C9DAB1DF1B8]

(29) Project
Output [22]: [COL_048BE89C_8DF3_4FD9_8C59_0CA9BEA4176E#873177 AS COL_E6AE24ED_8026_495F_A48A_A236DF26A045#873477, COL_E629F76D_863A_4E83_AD7C_492C57E4101F#873178 AS COL_4A1CE955_6068_4C7E_A3E5_D1247E0D721C#873478, COL_E597AE48_3139_4249_BFDD_5C3C79C385B4#873179 AS COL_1AB4B887_3C06_4F3A_ABF9_7AD8B2A320C0#873479, COL_72635379_B018_4685_A1CC_92B117EF7EE7#873180 AS COL_D567C154_8DAA_4940_917F_47BC849D79C6#873480, COL_16E8EFFC_F554_4DC7_BDB9_319838F1DC37#873181 AS COL_F7E49028_833B_451A_9E47_6BD3A0E316BF#873481, COL_CCDC5A97_B422_48F9_9469_688A0DB55E03#873182 AS COL_3228D314_43D6_4FC0_93CF_06B11ACB10C3#873482, COL_56CCE68D_F02B_4AB1_BD66_4C704318B343#873186 AS COL_94D8C66B_9389_4B85_AB9D_6D5C783EAB35#873486, COL_09C049A5_7EB3_4AD9_9A4E_3485C4213E23#873187 AS COL_FF0B1DCA_05CD_4386_8A58_A3EBAB686C31#873487, COL_D466463E_85A4_4DE1_BB8C_2545604A7F54#873190 AS COL_0C2F7757_16EE_45C2_81B7_A383DF708478#873490, COL_16EC77F7_2283_4184_8409_4632F6CC15D3#873202 AS COL_B33BB2B1_4367_4C17_9E85_E1B83CEDA1F7#873498, COL_0738E545_DA3C_4C7F_BB3B_257B05496299#873203 AS COL_5E2D72EA_FAB1_400C_B520_52899F382EF3#873499, COL_B541F517_3A48_482B_A549_61AF5D172C6A#873215 AS COL_9A64A372_5DD3_4A81_996C_613299ACD186#873500, COL_11E8518B_C561_41A3_B5F9_74AB5187CDFC#873204 AS COL_73505A0D_7059_4377_994F_AAAAC3967AE3#873501, COL_B7441708_F9D2_4A2B_A397_8031C245497A#873212 AS COL_707861E9_0D04_42B9_BA95_403D54B5DC30#873502, COL_4A1D33D9_AEA4_4FAD_9BE2_F297C2BD00A5#873213 AS COL_5537EF2F_DF84_4745_87EE_5F3BF426F665#873503, COL_79A0D231_EA5A_4393_8B5B_3143358BCB50#873214 AS COL_9E2C1846_0355_4576_B77B_428DBDB090B0#873504, COL_718CE93B_A655_4623_A0DF_7B4858DBDBB2#873209 AS COL_4DD24825_2E66_4A12_BFE1_E5EA1B1621A3#873505, COL_8A4EC729_7CD0_45C2_9CE4_634409841EC5#873210 AS COL_4B532A7C_520D_434B_A535_2B7D1BDF915F#873506, COL_8A4EC729_7CD0_45C2_9CE4_634409841EC5#873210 AS COL_687009AE_1AB8_452A_A46D_474C97111A87#873507, COL_2126D381_FE6F_4D42_B46F_52B8D3FC58C1#873205 AS COL_1ADE8408_96AB_4C46_8297_5F40911D23CF#873508, COL_708C36C9_E248_4128_836B_F5A59970BDE2#873206 AS COL_AEEB13C5_B876_49B3_B291_94824FC83DB9#873509, COL_FC8B1025_0807_4366_B5F4_AD69D392ABAC#873207 AS COL_955D854F_430E_4A06_B726_979CD9E42132#873510]
Input [21]: [COL_048BE89C_8DF3_4FD9_8C59_0CA9BEA4176E#873177, COL_E629F76D_863A_4E83_AD7C_492C57E4101F#873178, COL_E597AE48_3139_4249_BFDD_5C3C79C385B4#873179, COL_72635379_B018_4685_A1CC_92B117EF7EE7#873180, COL_16E8EFFC_F554_4DC7_BDB9_319838F1DC37#873181, COL_CCDC5A97_B422_48F9_9469_688A0DB55E03#873182, COL_56CCE68D_F02B_4AB1_BD66_4C704318B343#873186, COL_09C049A5_7EB3_4AD9_9A4E_3485C4213E23#873187, COL_D466463E_85A4_4DE1_BB8C_2545604A7F54#873190, COL_16EC77F7_2283_4184_8409_4632F6CC15D3#873202, COL_0738E545_DA3C_4C7F_BB3B_257B05496299#873203, COL_11E8518B_C561_41A3_B5F9_74AB5187CDFC#873204, COL_2126D381_FE6F_4D42_B46F_52B8D3FC58C1#873205, COL_708C36C9_E248_4128_836B_F5A59970BDE2#873206, COL_FC8B1025_0807_4366_B5F4_AD69D392ABAC#873207, COL_718CE93B_A655_4623_A0DF_7B4858DBDBB2#873209, COL_8A4EC729_7CD0_45C2_9CE4_634409841EC5#873210, COL_B7441708_F9D2_4A2B_A397_8031C245497A#873212, COL_4A1D33D9_AEA4_4FAD_9BE2_F297C2BD00A5#873213, COL_79A0D231_EA5A_4393_8B5B_3143358BCB50#873214, COL_B541F517_3A48_482B_A549_61AF5D172C6A#873215]

(30) Exchange
Input [22]: [COL_E6AE24ED_8026_495F_A48A_A236DF26A045#873477, COL_4A1CE955_6068_4C7E_A3E5_D1247E0D721C#873478, COL_1AB4B887_3C06_4F3A_ABF9_7AD8B2A320C0#873479, COL_D567C154_8DAA_4940_917F_47BC849D79C6#873480, COL_F7E49028_833B_451A_9E47_6BD3A0E316BF#873481, COL_3228D314_43D6_4FC0_93CF_06B11ACB10C3#873482, COL_94D8C66B_9389_4B85_AB9D_6D5C783EAB35#873486, COL_FF0B1DCA_05CD_4386_8A58_A3EBAB686C31#873487, COL_0C2F7757_16EE_45C2_81B7_A383DF708478#873490, COL_B33BB2B1_4367_4C17_9E85_E1B83CEDA1F7#873498, COL_5E2D72EA_FAB1_400C_B520_52899F382EF3#873499, COL_9A64A372_5DD3_4A81_996C_613299ACD186#873500, COL_73505A0D_7059_4377_994F_AAAAC3967AE3#873501, COL_707861E9_0D04_42B9_BA95_403D54B5DC30#873502, COL_5537EF2F_DF84_4745_87EE_5F3BF426F665#873503, COL_9E2C1846_0355_4576_B77B_428DBDB090B0#873504, COL_4DD24825_2E66_4A12_BFE1_E5EA1B1621A3#873505, COL_4B532A7C_520D_434B_A535_2B7D1BDF915F#873506, COL_687009AE_1AB8_452A_A46D_474C97111A87#873507, COL_1ADE8408_96AB_4C46_8297_5F40911D23CF#873508, COL_AEEB13C5_B876_49B3_B291_94824FC83DB9#873509, COL_955D854F_430E_4A06_B726_979CD9E42132#873510]
Arguments: hashpartitioning(1, 10), ENSURE_REQUIREMENTS, [plan_id=117230]

(31) Sort
Input [22]: [COL_E6AE24ED_8026_495F_A48A_A236DF26A045#873477, COL_4A1CE955_6068_4C7E_A3E5_D1247E0D721C#873478, COL_1AB4B887_3C06_4F3A_ABF9_7AD8B2A320C0#873479, COL_D567C154_8DAA_4940_917F_47BC849D79C6#873480, COL_F7E49028_833B_451A_9E47_6BD3A0E316BF#873481, COL_3228D314_43D6_4FC0_93CF_06B11ACB10C3#873482, COL_94D8C66B_9389_4B85_AB9D_6D5C783EAB35#873486, COL_FF0B1DCA_05CD_4386_8A58_A3EBAB686C31#873487, COL_0C2F7757_16EE_45C2_81B7_A383DF708478#873490, COL_B33BB2B1_4367_4C17_9E85_E1B83CEDA1F7#873498, COL_5E2D72EA_FAB1_400C_B520_52899F382EF3#873499, COL_9A64A372_5DD3_4A81_996C_613299ACD186#873500, COL_73505A0D_7059_4377_994F_AAAAC3967AE3#873501, COL_707861E9_0D04_42B9_BA95_403D54B5DC30#873502, COL_5537EF2F_DF84_4745_87EE_5F3BF426F665#873503, COL_9E2C1846_0355_4576_B77B_428DBDB090B0#873504, COL_4DD24825_2E66_4A12_BFE1_E5EA1B1621A3#873505, COL_4B532A7C_520D_434B_A535_2B7D1BDF915F#873506, COL_687009AE_1AB8_452A_A46D_474C97111A87#873507, COL_1ADE8408_96AB_4C46_8297_5F40911D23CF#873508, COL_AEEB13C5_B876_49B3_B291_94824FC83DB9#873509, COL_955D854F_430E_4A06_B726_979CD9E42132#873510]
Arguments: [1 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0

(32) Window
Input [22]: [COL_E6AE24ED_8026_495F_A48A_A236DF26A045#873477, COL_4A1CE955_6068_4C7E_A3E5_D1247E0D721C#873478, COL_1AB4B887_3C06_4F3A_ABF9_7AD8B2A320C0#873479, COL_D567C154_8DAA_4940_917F_47BC849D79C6#873480, COL_F7E49028_833B_451A_9E47_6BD3A0E316BF#873481, COL_3228D314_43D6_4FC0_93CF_06B11ACB10C3#873482, COL_94D8C66B_9389_4B85_AB9D_6D5C783EAB35#873486, COL_FF0B1DCA_05CD_4386_8A58_A3EBAB686C31#873487, COL_0C2F7757_16EE_45C2_81B7_A383DF708478#873490, COL_B33BB2B1_4367_4C17_9E85_E1B83CEDA1F7#873498, COL_5E2D72EA_FAB1_400C_B520_52899F382EF3#873499, COL_9A64A372_5DD3_4A81_996C_613299ACD186#873500, COL_73505A0D_7059_4377_994F_AAAAC3967AE3#873501, COL_707861E9_0D04_42B9_BA95_403D54B5DC30#873502, COL_5537EF2F_DF84_4745_87EE_5F3BF426F665#873503, COL_9E2C1846_0355_4576_B77B_428DBDB090B0#873504, COL_4DD24825_2E66_4A12_BFE1_E5EA1B1621A3#873505, COL_4B532A7C_520D_434B_A535_2B7D1BDF915F#873506, COL_687009AE_1AB8_452A_A46D_474C97111A87#873507, COL_1ADE8408_96AB_4C46_8297_5F40911D23CF#873508, COL_AEEB13C5_B876_49B3_B291_94824FC83DB9#873509, COL_955D854F_430E_4A06_B726_979CD9E42132#873510]
Arguments: [count(1) windowspecdefinition(1, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_5E05192E_2B2D_47F7_ACEA_8D574028FB87#873586L], [1], [1 DESC NULLS LAST]

(33) Project
Output [23]: [COL_E6AE24ED_8026_495F_A48A_A236DF26A045#873477, COL_4A1CE955_6068_4C7E_A3E5_D1247E0D721C#873478, COL_1AB4B887_3C06_4F3A_ABF9_7AD8B2A320C0#873479, COL_D567C154_8DAA_4940_917F_47BC849D79C6#873480, COL_F7E49028_833B_451A_9E47_6BD3A0E316BF#873481, COL_3228D314_43D6_4FC0_93CF_06B11ACB10C3#873482, COL_94D8C66B_9389_4B85_AB9D_6D5C783EAB35#873486, COL_FF0B1DCA_05CD_4386_8A58_A3EBAB686C31#873487, COL_0C2F7757_16EE_45C2_81B7_A383DF708478#873490, COL_5E05192E_2B2D_47F7_ACEA_8D574028FB87#873586L, COL_B33BB2B1_4367_4C17_9E85_E1B83CEDA1F7#873498, COL_5E2D72EA_FAB1_400C_B520_52899F382EF3#873499, COL_9A64A372_5DD3_4A81_996C_613299ACD186#873500, COL_73505A0D_7059_4377_994F_AAAAC3967AE3#873501, COL_707861E9_0D04_42B9_BA95_403D54B5DC30#873502, COL_5537EF2F_DF84_4745_87EE_5F3BF426F665#873503, COL_9E2C1846_0355_4576_B77B_428DBDB090B0#873504, COL_4DD24825_2E66_4A12_BFE1_E5EA1B1621A3#873505, COL_4B532A7C_520D_434B_A535_2B7D1BDF915F#873506, COL_687009AE_1AB8_452A_A46D_474C97111A87#873507, COL_1ADE8408_96AB_4C46_8297_5F40911D23CF#873508, COL_AEEB13C5_B876_49B3_B291_94824FC83DB9#873509, COL_955D854F_430E_4A06_B726_979CD9E42132#873510]
Input [23]: [COL_E6AE24ED_8026_495F_A48A_A236DF26A045#873477, COL_4A1CE955_6068_4C7E_A3E5_D1247E0D721C#873478, COL_1AB4B887_3C06_4F3A_ABF9_7AD8B2A320C0#873479, COL_D567C154_8DAA_4940_917F_47BC849D79C6#873480, COL_F7E49028_833B_451A_9E47_6BD3A0E316BF#873481, COL_3228D314_43D6_4FC0_93CF_06B11ACB10C3#873482, COL_94D8C66B_9389_4B85_AB9D_6D5C783EAB35#873486, COL_FF0B1DCA_05CD_4386_8A58_A3EBAB686C31#873487, COL_0C2F7757_16EE_45C2_81B7_A383DF708478#873490, COL_B33BB2B1_4367_4C17_9E85_E1B83CEDA1F7#873498, COL_5E2D72EA_FAB1_400C_B520_52899F382EF3#873499, COL_9A64A372_5DD3_4A81_996C_613299ACD186#873500, COL_73505A0D_7059_4377_994F_AAAAC3967AE3#873501, COL_707861E9_0D04_42B9_BA95_403D54B5DC30#873502, COL_5537EF2F_DF84_4745_87EE_5F3BF426F665#873503, COL_9E2C1846_0355_4576_B77B_428DBDB090B0#873504, COL_4DD24825_2E66_4A12_BFE1_E5EA1B1621A3#873505, COL_4B532A7C_520D_434B_A535_2B7D1BDF915F#873506, COL_687009AE_1AB8_452A_A46D_474C97111A87#873507, COL_1ADE8408_96AB_4C46_8297_5F40911D23CF#873508, COL_AEEB13C5_B876_49B3_B291_94824FC83DB9#873509, COL_955D854F_430E_4A06_B726_979CD9E42132#873510, COL_5E05192E_2B2D_47F7_ACEA_8D574028FB87#873586L]

(34) Generate
Input [23]: [COL_E6AE24ED_8026_495F_A48A_A236DF26A045#873477, COL_4A1CE955_6068_4C7E_A3E5_D1247E0D721C#873478, COL_1AB4B887_3C06_4F3A_ABF9_7AD8B2A320C0#873479, COL_D567C154_8DAA_4940_917F_47BC849D79C6#873480, COL_F7E49028_833B_451A_9E47_6BD3A0E316BF#873481, COL_3228D314_43D6_4FC0_93CF_06B11ACB10C3#873482, COL_94D8C66B_9389_4B85_AB9D_6D5C783EAB35#873486, COL_FF0B1DCA_05CD_4386_8A58_A3EBAB686C31#873487, COL_0C2F7757_16EE_45C2_81B7_A383DF708478#873490, COL_5E05192E_2B2D_47F7_ACEA_8D574028FB87#873586L, COL_B33BB2B1_4367_4C17_9E85_E1B83CEDA1F7#873498, COL_5E2D72EA_FAB1_400C_B520_52899F382EF3#873499, COL_9A64A372_5DD3_4A81_996C_613299ACD186#873500, COL_73505A0D_7059_4377_994F_AAAAC3967AE3#873501, COL_707861E9_0D04_42B9_BA95_403D54B5DC30#873502, COL_5537EF2F_DF84_4745_87EE_5F3BF426F665#873503, COL_9E2C1846_0355_4576_B77B_428DBDB090B0#873504, COL_4DD24825_2E66_4A12_BFE1_E5EA1B1621A3#873505, COL_4B532A7C_520D_434B_A535_2B7D1BDF915F#873506, COL_687009AE_1AB8_452A_A46D_474C97111A87#873507, COL_1ADE8408_96AB_4C46_8297_5F40911D23CF#873508, COL_AEEB13C5_B876_49B3_B291_94824FC83DB9#873509, COL_955D854F_430E_4A06_B726_979CD9E42132#873510]
Arguments: stack(13, Nom Naissance_Minuscule-Partiel, COL_B33BB2B1_4367_4C17_9E85_E1B83CEDA1F7#873498, Commune_Minuscule-Partiel, COL_5E2D72EA_FAB1_400C_B520_52899F382EF3#873499, Ipp_Caractère-Anormal, COL_9A64A372_5DD3_4A81_996C_613299ACD186#873500, Sexe_Caractère-Anormal, COL_73505A0D_7059_4377_994F_AAAAC3967AE3#873501, Département_Longueur-Anormal, COL_707861E9_0D04_42B9_BA95_403D54B5DC30#873502, Code Postal_Longueur Anormal, COL_5537EF2F_DF84_4745_87EE_5F3BF426F665#873503, IPP_Longueur Anormal, COL_9E2C1846_0355_4576_B77B_428DBDB090B0#873504, Prénom_Caractères-spéciaux, COL_4DD24825_2E66_4A12_BFE1_E5EA1B1621A3#873505, Nom Naissance_Caractères-spéciaux, COL_4B532A7C_520D_434B_A535_2B7D1BDF915F#873506, Nom Naissance_Caractères-spéciaux, COL_687009AE_1AB8_452A_A46D_474C97111A87#873507, Année de Naissance_Valeur-Anormale, COL_1ADE8408_96AB_4C46_8297_5F40911D23CF#873508, Mois de Naissance_Valeur-Anormale, ... 3 more fields), [COL_E6AE24ED_8026_495F_A48A_A236DF26A045#873477, COL_4A1CE955_6068_4C7E_A3E5_D1247E0D721C#873478, COL_1AB4B887_3C06_4F3A_ABF9_7AD8B2A320C0#873479, COL_D567C154_8DAA_4940_917F_47BC849D79C6#873480, COL_F7E49028_833B_451A_9E47_6BD3A0E316BF#873481, COL_3228D314_43D6_4FC0_93CF_06B11ACB10C3#873482, COL_94D8C66B_9389_4B85_AB9D_6D5C783EAB35#873486, COL_FF0B1DCA_05CD_4386_8A58_A3EBAB686C31#873487, COL_0C2F7757_16EE_45C2_81B7_A383DF708478#873490, COL_5E05192E_2B2D_47F7_ACEA_8D574028FB87#873586L], false, [col0#873810, col1#873811]

(35) Project
Output [14]: [col0#873810 AS COL_38355470_4B6E_4B4E_809B_5B281953DF16#873994, coalesce(col1#873811, 1) AS COL_F6F84F2D_321A_4741_BD1C_1CB6CD3D1D24#873995, COL_E6AE24ED_8026_495F_A48A_A236DF26A045#873477 AS COL_C285D4BB_A02E_4105_A400_1638DD0ACA0A#873996, COL_4A1CE955_6068_4C7E_A3E5_D1247E0D721C#873478 AS COL_C4879408_90C5_4F10_AF9F_648CDC892B1E#873997, COL_1AB4B887_3C06_4F3A_ABF9_7AD8B2A320C0#873479 AS COL_EA107784_8709_46B5_AA55_86D465A8BEA6#873998, COL_D567C154_8DAA_4940_917F_47BC849D79C6#873480 AS COL_56CB150D_6DAC_4787_A325_C454247FF0CC#873999, COL_F7E49028_833B_451A_9E47_6BD3A0E316BF#873481 AS COL_7042F62C_E148_4413_A7A5_097C945232F2#874000, COL_3228D314_43D6_4FC0_93CF_06B11ACB10C3#873482 AS COL_44B724FC_5FAF_4C3D_9106_AFCCC207B633#874001, COL_94D8C66B_9389_4B85_AB9D_6D5C783EAB35#873486 AS COL_B8C9FA08_2915_4ED7_A3BB_ADF6FA5643FD#874002, COL_FF0B1DCA_05CD_4386_8A58_A3EBAB686C31#873487 AS COL_00FCD646_8EDD_4E64_AF23_D9CA8773E369#874003, COL_0C2F7757_16EE_45C2_81B7_A383DF708478#873490 AS COL_98A321C5_57DC_439F_B059_7C5EF1A9642E#874004, COL_5E05192E_2B2D_47F7_ACEA_8D574028FB87#873586L AS COL_970D8DCA_C522_4183_8ACB_9C9DAB1DF1B8#874005L, str_extract_by_str(col0#873810, _, LEFT) AS COL_18F75DE4_51FC_4581_8B68_D191957AE6BE#874018, str_extract_by_str(col0#873810, _, RIGHT) AS COL_BB75DAC6_A718_4A29_9850_CA70D3D9DEFD#874032]
Input [12]: [COL_E6AE24ED_8026_495F_A48A_A236DF26A045#873477, COL_4A1CE955_6068_4C7E_A3E5_D1247E0D721C#873478, COL_1AB4B887_3C06_4F3A_ABF9_7AD8B2A320C0#873479, COL_D567C154_8DAA_4940_917F_47BC849D79C6#873480, COL_F7E49028_833B_451A_9E47_6BD3A0E316BF#873481, COL_3228D314_43D6_4FC0_93CF_06B11ACB10C3#873482, COL_94D8C66B_9389_4B85_AB9D_6D5C783EAB35#873486, COL_FF0B1DCA_05CD_4386_8A58_A3EBAB686C31#873487, COL_0C2F7757_16EE_45C2_81B7_A383DF708478#873490, COL_5E05192E_2B2D_47F7_ACEA_8D574028FB87#873586L, col0#873810, col1#873811]

(36) Sort
Input [14]: [COL_38355470_4B6E_4B4E_809B_5B281953DF16#873994, COL_F6F84F2D_321A_4741_BD1C_1CB6CD3D1D24#873995, COL_C285D4BB_A02E_4105_A400_1638DD0ACA0A#873996, COL_C4879408_90C5_4F10_AF9F_648CDC892B1E#873997, COL_EA107784_8709_46B5_AA55_86D465A8BEA6#873998, COL_56CB150D_6DAC_4787_A325_C454247FF0CC#873999, COL_7042F62C_E148_4413_A7A5_097C945232F2#874000, COL_44B724FC_5FAF_4C3D_9106_AFCCC207B633#874001, COL_B8C9FA08_2915_4ED7_A3BB_ADF6FA5643FD#874002, COL_00FCD646_8EDD_4E64_AF23_D9CA8773E369#874003, COL_98A321C5_57DC_439F_B059_7C5EF1A9642E#874004, COL_970D8DCA_C522_4183_8ACB_9C9DAB1DF1B8#874005L, COL_18F75DE4_51FC_4581_8B68_D191957AE6BE#874018, COL_BB75DAC6_A718_4A29_9850_CA70D3D9DEFD#874032]
Arguments: [1 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0

(37) Window
Input [14]: [COL_38355470_4B6E_4B4E_809B_5B281953DF16#873994, COL_F6F84F2D_321A_4741_BD1C_1CB6CD3D1D24#873995, COL_C285D4BB_A02E_4105_A400_1638DD0ACA0A#873996, COL_C4879408_90C5_4F10_AF9F_648CDC892B1E#873997, COL_EA107784_8709_46B5_AA55_86D465A8BEA6#873998, COL_56CB150D_6DAC_4787_A325_C454247FF0CC#873999, COL_7042F62C_E148_4413_A7A5_097C945232F2#874000, COL_44B724FC_5FAF_4C3D_9106_AFCCC207B633#874001, COL_B8C9FA08_2915_4ED7_A3BB_ADF6FA5643FD#874002, COL_00FCD646_8EDD_4E64_AF23_D9CA8773E369#874003, COL_98A321C5_57DC_439F_B059_7C5EF1A9642E#874004, COL_970D8DCA_C522_4183_8ACB_9C9DAB1DF1B8#874005L, COL_18F75DE4_51FC_4581_8B68_D191957AE6BE#874018, COL_BB75DAC6_A718_4A29_9850_CA70D3D9DEFD#874032]
Arguments: [count(1) windowspecdefinition(1, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_FE7584CE_A7B9_4550_A540_36A08BA05397#874065L], [1], [1 DESC NULLS LAST]

(38) Project
Output [15]: [COL_38355470_4B6E_4B4E_809B_5B281953DF16#873994, COL_C285D4BB_A02E_4105_A400_1638DD0ACA0A#873996, COL_C4879408_90C5_4F10_AF9F_648CDC892B1E#873997, COL_EA107784_8709_46B5_AA55_86D465A8BEA6#873998, COL_56CB150D_6DAC_4787_A325_C454247FF0CC#873999, COL_7042F62C_E148_4413_A7A5_097C945232F2#874000, COL_44B724FC_5FAF_4C3D_9106_AFCCC207B633#874001, COL_B8C9FA08_2915_4ED7_A3BB_ADF6FA5643FD#874002, COL_00FCD646_8EDD_4E64_AF23_D9CA8773E369#874003, COL_98A321C5_57DC_439F_B059_7C5EF1A9642E#874004, COL_18F75DE4_51FC_4581_8B68_D191957AE6BE#874018, COL_BB75DAC6_A718_4A29_9850_CA70D3D9DEFD#874032, COL_F6F84F2D_321A_4741_BD1C_1CB6CD3D1D24#873995, COL_970D8DCA_C522_4183_8ACB_9C9DAB1DF1B8#874005L, COL_FE7584CE_A7B9_4550_A540_36A08BA05397#874065L]
Input [15]: [COL_38355470_4B6E_4B4E_809B_5B281953DF16#873994, COL_F6F84F2D_321A_4741_BD1C_1CB6CD3D1D24#873995, COL_C285D4BB_A02E_4105_A400_1638DD0ACA0A#873996, COL_C4879408_90C5_4F10_AF9F_648CDC892B1E#873997, COL_EA107784_8709_46B5_AA55_86D465A8BEA6#873998, COL_56CB150D_6DAC_4787_A325_C454247FF0CC#873999, COL_7042F62C_E148_4413_A7A5_097C945232F2#874000, COL_44B724FC_5FAF_4C3D_9106_AFCCC207B633#874001, COL_B8C9FA08_2915_4ED7_A3BB_ADF6FA5643FD#874002, COL_00FCD646_8EDD_4E64_AF23_D9CA8773E369#874003, COL_98A321C5_57DC_439F_B059_7C5EF1A9642E#874004, COL_970D8DCA_C522_4183_8ACB_9C9DAB1DF1B8#874005L, COL_18F75DE4_51FC_4581_8B68_D191957AE6BE#874018, COL_BB75DAC6_A718_4A29_9850_CA70D3D9DEFD#874032, COL_FE7584CE_A7B9_4550_A540_36A08BA05397#874065L]

(39) Exchange
Input [15]: [COL_38355470_4B6E_4B4E_809B_5B281953DF16#873994, COL_C285D4BB_A02E_4105_A400_1638DD0ACA0A#873996, COL_C4879408_90C5_4F10_AF9F_648CDC892B1E#873997, COL_EA107784_8709_46B5_AA55_86D465A8BEA6#873998, COL_56CB150D_6DAC_4787_A325_C454247FF0CC#873999, COL_7042F62C_E148_4413_A7A5_097C945232F2#874000, COL_44B724FC_5FAF_4C3D_9106_AFCCC207B633#874001, COL_B8C9FA08_2915_4ED7_A3BB_ADF6FA5643FD#874002, COL_00FCD646_8EDD_4E64_AF23_D9CA8773E369#874003, COL_98A321C5_57DC_439F_B059_7C5EF1A9642E#874004, COL_18F75DE4_51FC_4581_8B68_D191957AE6BE#874018, COL_BB75DAC6_A718_4A29_9850_CA70D3D9DEFD#874032, COL_F6F84F2D_321A_4741_BD1C_1CB6CD3D1D24#873995, COL_970D8DCA_C522_4183_8ACB_9C9DAB1DF1B8#874005L, COL_FE7584CE_A7B9_4550_A540_36A08BA05397#874065L]
Arguments: hashpartitioning(COL_C285D4BB_A02E_4105_A400_1638DD0ACA0A#873996, 10), ENSURE_REQUIREMENTS, [plan_id=117241]

(40) Sort
Input [15]: [COL_38355470_4B6E_4B4E_809B_5B281953DF16#873994, COL_C285D4BB_A02E_4105_A400_1638DD0ACA0A#873996, COL_C4879408_90C5_4F10_AF9F_648CDC892B1E#873997, COL_EA107784_8709_46B5_AA55_86D465A8BEA6#873998, COL_56CB150D_6DAC_4787_A325_C454247FF0CC#873999, COL_7042F62C_E148_4413_A7A5_097C945232F2#874000, COL_44B724FC_5FAF_4C3D_9106_AFCCC207B633#874001, COL_B8C9FA08_2915_4ED7_A3BB_ADF6FA5643FD#874002, COL_00FCD646_8EDD_4E64_AF23_D9CA8773E369#874003, COL_98A321C5_57DC_439F_B059_7C5EF1A9642E#874004, COL_18F75DE4_51FC_4581_8B68_D191957AE6BE#874018, COL_BB75DAC6_A718_4A29_9850_CA70D3D9DEFD#874032, COL_F6F84F2D_321A_4741_BD1C_1CB6CD3D1D24#873995, COL_970D8DCA_C522_4183_8ACB_9C9DAB1DF1B8#874005L, COL_FE7584CE_A7B9_4550_A540_36A08BA05397#874065L]
Arguments: [COL_C285D4BB_A02E_4105_A400_1638DD0ACA0A#873996 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0

(41) Window
Input [15]: [COL_38355470_4B6E_4B4E_809B_5B281953DF16#873994, COL_C285D4BB_A02E_4105_A400_1638DD0ACA0A#873996, COL_C4879408_90C5_4F10_AF9F_648CDC892B1E#873997, COL_EA107784_8709_46B5_AA55_86D465A8BEA6#873998, COL_56CB150D_6DAC_4787_A325_C454247FF0CC#873999, COL_7042F62C_E148_4413_A7A5_097C945232F2#874000, COL_44B724FC_5FAF_4C3D_9106_AFCCC207B633#874001, COL_B8C9FA08_2915_4ED7_A3BB_ADF6FA5643FD#874002, COL_00FCD646_8EDD_4E64_AF23_D9CA8773E369#874003, COL_98A321C5_57DC_439F_B059_7C5EF1A9642E#874004, COL_18F75DE4_51FC_4581_8B68_D191957AE6BE#874018, COL_BB75DAC6_A718_4A29_9850_CA70D3D9DEFD#874032, COL_F6F84F2D_321A_4741_BD1C_1CB6CD3D1D24#873995, COL_970D8DCA_C522_4183_8ACB_9C9DAB1DF1B8#874005L, COL_FE7584CE_A7B9_4550_A540_36A08BA05397#874065L]
Arguments: [count(1) windowspecdefinition(COL_C285D4BB_A02E_4105_A400_1638DD0ACA0A#873996, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_A0131DDF_C92E_4028_9DDB_1E1BE78CA89A#874177L], [COL_C285D4BB_A02E_4105_A400_1638DD0ACA0A#873996], [1 DESC NULLS LAST]

(42) Filter
Input [16]: [COL_38355470_4B6E_4B4E_809B_5B281953DF16#873994, COL_C285D4BB_A02E_4105_A400_1638DD0ACA0A#873996, COL_C4879408_90C5_4F10_AF9F_648CDC892B1E#873997, COL_EA107784_8709_46B5_AA55_86D465A8BEA6#873998, COL_56CB150D_6DAC_4787_A325_C454247FF0CC#873999, COL_7042F62C_E148_4413_A7A5_097C945232F2#874000, COL_44B724FC_5FAF_4C3D_9106_AFCCC207B633#874001, COL_B8C9FA08_2915_4ED7_A3BB_ADF6FA5643FD#874002, COL_00FCD646_8EDD_4E64_AF23_D9CA8773E369#874003, COL_98A321C5_57DC_439F_B059_7C5EF1A9642E#874004, COL_18F75DE4_51FC_4581_8B68_D191957AE6BE#874018, COL_BB75DAC6_A718_4A29_9850_CA70D3D9DEFD#874032, COL_F6F84F2D_321A_4741_BD1C_1CB6CD3D1D24#873995, COL_970D8DCA_C522_4183_8ACB_9C9DAB1DF1B8#874005L, COL_FE7584CE_A7B9_4550_A540_36A08BA05397#874065L, COL_A0131DDF_C92E_4028_9DDB_1E1BE78CA89A#874177L]
Condition : (COL_F6F84F2D_321A_4741_BD1C_1CB6CD3D1D24#873995 <=> 1)

(43) Window
Input [16]: [COL_38355470_4B6E_4B4E_809B_5B281953DF16#873994, COL_C285D4BB_A02E_4105_A400_1638DD0ACA0A#873996, COL_C4879408_90C5_4F10_AF9F_648CDC892B1E#873997, COL_EA107784_8709_46B5_AA55_86D465A8BEA6#873998, COL_56CB150D_6DAC_4787_A325_C454247FF0CC#873999, COL_7042F62C_E148_4413_A7A5_097C945232F2#874000, COL_44B724FC_5FAF_4C3D_9106_AFCCC207B633#874001, COL_B8C9FA08_2915_4ED7_A3BB_ADF6FA5643FD#874002, COL_00FCD646_8EDD_4E64_AF23_D9CA8773E369#874003, COL_98A321C5_57DC_439F_B059_7C5EF1A9642E#874004, COL_18F75DE4_51FC_4581_8B68_D191957AE6BE#874018, COL_BB75DAC6_A718_4A29_9850_CA70D3D9DEFD#874032, COL_F6F84F2D_321A_4741_BD1C_1CB6CD3D1D24#873995, COL_970D8DCA_C522_4183_8ACB_9C9DAB1DF1B8#874005L, COL_FE7584CE_A7B9_4550_A540_36A08BA05397#874065L, COL_A0131DDF_C92E_4028_9DDB_1E1BE78CA89A#874177L]
Arguments: [count(1) windowspecdefinition(COL_C285D4BB_A02E_4105_A400_1638DD0ACA0A#873996, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_5CDBD9C9_E94A_4107_89EF_FFA3714428AB#874360L], [COL_C285D4BB_A02E_4105_A400_1638DD0ACA0A#873996], [1 DESC NULLS LAST]

(44) Exchange
Input [17]: [COL_38355470_4B6E_4B4E_809B_5B281953DF16#873994, COL_C285D4BB_A02E_4105_A400_1638DD0ACA0A#873996, COL_C4879408_90C5_4F10_AF9F_648CDC892B1E#873997, COL_EA107784_8709_46B5_AA55_86D465A8BEA6#873998, COL_56CB150D_6DAC_4787_A325_C454247FF0CC#873999, COL_7042F62C_E148_4413_A7A5_097C945232F2#874000, COL_44B724FC_5FAF_4C3D_9106_AFCCC207B633#874001, COL_B8C9FA08_2915_4ED7_A3BB_ADF6FA5643FD#874002, COL_00FCD646_8EDD_4E64_AF23_D9CA8773E369#874003, COL_98A321C5_57DC_439F_B059_7C5EF1A9642E#874004, COL_18F75DE4_51FC_4581_8B68_D191957AE6BE#874018, COL_BB75DAC6_A718_4A29_9850_CA70D3D9DEFD#874032, COL_F6F84F2D_321A_4741_BD1C_1CB6CD3D1D24#873995, COL_970D8DCA_C522_4183_8ACB_9C9DAB1DF1B8#874005L, COL_FE7584CE_A7B9_4550_A540_36A08BA05397#874065L, COL_A0131DDF_C92E_4028_9DDB_1E1BE78CA89A#874177L, COL_5CDBD9C9_E94A_4107_89EF_FFA3714428AB#874360L]
Arguments: hashpartitioning(1, 10), ENSURE_REQUIREMENTS, [plan_id=117247]

(45) Sort
Input [17]: [COL_38355470_4B6E_4B4E_809B_5B281953DF16#873994, COL_C285D4BB_A02E_4105_A400_1638DD0ACA0A#873996, COL_C4879408_90C5_4F10_AF9F_648CDC892B1E#873997, COL_EA107784_8709_46B5_AA55_86D465A8BEA6#873998, COL_56CB150D_6DAC_4787_A325_C454247FF0CC#873999, COL_7042F62C_E148_4413_A7A5_097C945232F2#874000, COL_44B724FC_5FAF_4C3D_9106_AFCCC207B633#874001, COL_B8C9FA08_2915_4ED7_A3BB_ADF6FA5643FD#874002, COL_00FCD646_8EDD_4E64_AF23_D9CA8773E369#874003, COL_98A321C5_57DC_439F_B059_7C5EF1A9642E#874004, COL_18F75DE4_51FC_4581_8B68_D191957AE6BE#874018, COL_BB75DAC6_A718_4A29_9850_CA70D3D9DEFD#874032, COL_F6F84F2D_321A_4741_BD1C_1CB6CD3D1D24#873995, COL_970D8DCA_C522_4183_8ACB_9C9DAB1DF1B8#874005L, COL_FE7584CE_A7B9_4550_A540_36A08BA05397#874065L, COL_A0131DDF_C92E_4028_9DDB_1E1BE78CA89A#874177L, COL_5CDBD9C9_E94A_4107_89EF_FFA3714428AB#874360L]
Arguments: [1 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0

(46) Window
Input [17]: [COL_38355470_4B6E_4B4E_809B_5B281953DF16#873994, COL_C285D4BB_A02E_4105_A400_1638DD0ACA0A#873996, COL_C4879408_90C5_4F10_AF9F_648CDC892B1E#873997, COL_EA107784_8709_46B5_AA55_86D465A8BEA6#873998, COL_56CB150D_6DAC_4787_A325_C454247FF0CC#873999, COL_7042F62C_E148_4413_A7A5_097C945232F2#874000, COL_44B724FC_5FAF_4C3D_9106_AFCCC207B633#874001, COL_B8C9FA08_2915_4ED7_A3BB_ADF6FA5643FD#874002, COL_00FCD646_8EDD_4E64_AF23_D9CA8773E369#874003, COL_98A321C5_57DC_439F_B059_7C5EF1A9642E#874004, COL_18F75DE4_51FC_4581_8B68_D191957AE6BE#874018, COL_BB75DAC6_A718_4A29_9850_CA70D3D9DEFD#874032, COL_F6F84F2D_321A_4741_BD1C_1CB6CD3D1D24#873995, COL_970D8DCA_C522_4183_8ACB_9C9DAB1DF1B8#874005L, COL_FE7584CE_A7B9_4550_A540_36A08BA05397#874065L, COL_A0131DDF_C92E_4028_9DDB_1E1BE78CA89A#874177L, COL_5CDBD9C9_E94A_4107_89EF_FFA3714428AB#874360L]
Arguments: [count(1) windowspecdefinition(1, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_D232794D_6E04_42B4_88DD_D51030910AEA#874417L], [1], [1 DESC NULLS LAST]

(47) Project
Output [19]: [COL_38355470_4B6E_4B4E_809B_5B281953DF16#873994, COL_C285D4BB_A02E_4105_A400_1638DD0ACA0A#873996, COL_C4879408_90C5_4F10_AF9F_648CDC892B1E#873997, COL_EA107784_8709_46B5_AA55_86D465A8BEA6#873998, COL_56CB150D_6DAC_4787_A325_C454247FF0CC#873999, COL_7042F62C_E148_4413_A7A5_097C945232F2#874000, COL_44B724FC_5FAF_4C3D_9106_AFCCC207B633#874001, COL_B8C9FA08_2915_4ED7_A3BB_ADF6FA5643FD#874002, COL_00FCD646_8EDD_4E64_AF23_D9CA8773E369#874003, COL_98A321C5_57DC_439F_B059_7C5EF1A9642E#874004, COL_18F75DE4_51FC_4581_8B68_D191957AE6BE#874018, COL_BB75DAC6_A718_4A29_9850_CA70D3D9DEFD#874032, COL_F6F84F2D_321A_4741_BD1C_1CB6CD3D1D24#873995, COL_5CDBD9C9_E94A_4107_89EF_FFA3714428AB#874360L, COL_A0131DDF_C92E_4028_9DDB_1E1BE78CA89A#874177L, round(dec_operator(PRODUIT, array(dec_operator(DIVISION, array(COL_5CDBD9C9_E94A_4107_89EF_FFA3714428AB#874360L, COL_A0131DDF_C92E_4028_9DDB_1E1BE78CA89A#874177L)), 100.0)), 2) AS COL_BA88332F_1B23_4847_9054_82AA2086A665#874638, COL_D232794D_6E04_42B4_88DD_D51030910AEA#874417L, COL_FE7584CE_A7B9_4550_A540_36A08BA05397#874065L, COL_970D8DCA_C522_4183_8ACB_9C9DAB1DF1B8#874005L]
Input [18]: [COL_38355470_4B6E_4B4E_809B_5B281953DF16#873994, COL_C285D4BB_A02E_4105_A400_1638DD0ACA0A#873996, COL_C4879408_90C5_4F10_AF9F_648CDC892B1E#873997, COL_EA107784_8709_46B5_AA55_86D465A8BEA6#873998, COL_56CB150D_6DAC_4787_A325_C454247FF0CC#873999, COL_7042F62C_E148_4413_A7A5_097C945232F2#874000, COL_44B724FC_5FAF_4C3D_9106_AFCCC207B633#874001, COL_B8C9FA08_2915_4ED7_A3BB_ADF6FA5643FD#874002, COL_00FCD646_8EDD_4E64_AF23_D9CA8773E369#874003, COL_98A321C5_57DC_439F_B059_7C5EF1A9642E#874004, COL_18F75DE4_51FC_4581_8B68_D191957AE6BE#874018, COL_BB75DAC6_A718_4A29_9850_CA70D3D9DEFD#874032, COL_F6F84F2D_321A_4741_BD1C_1CB6CD3D1D24#873995, COL_970D8DCA_C522_4183_8ACB_9C9DAB1DF1B8#874005L, COL_FE7584CE_A7B9_4550_A540_36A08BA05397#874065L, COL_A0131DDF_C92E_4028_9DDB_1E1BE78CA89A#874177L, COL_5CDBD9C9_E94A_4107_89EF_FFA3714428AB#874360L, COL_D232794D_6E04_42B4_88DD_D51030910AEA#874417L]

(48) WriteFiles
Input [19]: [COL_38355470_4B6E_4B4E_809B_5B281953DF16#873994, COL_C285D4BB_A02E_4105_A400_1638DD0ACA0A#873996, COL_C4879408_90C5_4F10_AF9F_648CDC892B1E#873997, COL_EA107784_8709_46B5_AA55_86D465A8BEA6#873998, COL_56CB150D_6DAC_4787_A325_C454247FF0CC#873999, COL_7042F62C_E148_4413_A7A5_097C945232F2#874000, COL_44B724FC_5FAF_4C3D_9106_AFCCC207B633#874001, COL_B8C9FA08_2915_4ED7_A3BB_ADF6FA5643FD#874002, COL_00FCD646_8EDD_4E64_AF23_D9CA8773E369#874003, COL_98A321C5_57DC_439F_B059_7C5EF1A9642E#874004, COL_18F75DE4_51FC_4581_8B68_D191957AE6BE#874018, COL_BB75DAC6_A718_4A29_9850_CA70D3D9DEFD#874032, COL_F6F84F2D_321A_4741_BD1C_1CB6CD3D1D24#873995, COL_5CDBD9C9_E94A_4107_89EF_FFA3714428AB#874360L, COL_A0131DDF_C92E_4028_9DDB_1E1BE78CA89A#874177L, COL_BA88332F_1B23_4847_9054_82AA2086A665#874638, COL_D232794D_6E04_42B4_88DD_D51030910AEA#874417L, COL_FE7584CE_A7B9_4550_A540_36A08BA05397#874065L, COL_970D8DCA_C522_4183_8ACB_9C9DAB1DF1B8#874005L]

(49) Execute InsertIntoHadoopFsRelationCommand
Input: []
Arguments: file:/data/output/cache/parquet/datablock/QUALITE_SEMANTI_66618, false, Parquet, [path=file:///data/output/cache/parquet/datablock/QUALITE_SEMANTI_66618], Overwrite, [COL_38355470_4B6E_4B4E_809B_5B281953DF16, COL_C285D4BB_A02E_4105_A400_1638DD0ACA0A, COL_C4879408_90C5_4F10_AF9F_648CDC892B1E, COL_EA107784_8709_46B5_AA55_86D465A8BEA6, COL_56CB150D_6DAC_4787_A325_C454247FF0CC, COL_7042F62C_E148_4413_A7A5_097C945232F2, COL_44B724FC_5FAF_4C3D_9106_AFCCC207B633, COL_B8C9FA08_2915_4ED7_A3BB_ADF6FA5643FD, COL_00FCD646_8EDD_4E64_AF23_D9CA8773E369, COL_98A321C5_57DC_439F_B059_7C5EF1A9642E, COL_18F75DE4_51FC_4581_8B68_D191957AE6BE, COL_BB75DAC6_A718_4A29_9850_CA70D3D9DEFD, COL_F6F84F2D_321A_4741_BD1C_1CB6CD3D1D24, COL_5CDBD9C9_E94A_4107_89EF_FFA3714428AB, COL_A0131DDF_C92E_4028_9DDB_1E1BE78CA89A, COL_BA88332F_1B23_4847_9054_82AA2086A665, COL_D232794D_6E04_42B4_88DD_D51030910AEA, COL_FE7584CE_A7B9_4550_A540_36A08BA05397, COL_970D8DCA_C522_4183_8ACB_9C9DAB1DF1B8]

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

SQL / DataFrame Properties

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