hdh-spark-job - Details for Query 691

Submitted Time: 2026/10/26 22:25:00
Duration: 5 s
Succeeded Jobs: 609 611

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

digraph G { 0 [labelType="html" label=" AdaptiveSparkPlan "]; subgraph cluster1 { isCluster="true"; label="WholeStageCodegen (2)\n \nduration: 0 ms"; 2 [labelType="html" label="HashAggregate time in aggregation build: 0 ms number of output rows: 1"]; } 3 [labelType="html" label="Exchange shuffle records written: 3 local merged chunks fetched: 0 shuffle write time total (min, med, max (stageId: taskId)) 1 ms (0 ms, 0 ms, 0 ms (stage 894.0: task 778)) 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: 3 local bytes read: 171.0 B fetch wait time: 0 ms remote bytes read: 0.0 B merged fetch fallback count: 0 local blocks read: 3 remote merged chunks fetched: 0 remote blocks read: 0 data size total (min, med, max (stageId: taskId)) 48.0 B (16.0 B, 16.0 B, 16.0 B (stage 894.0: task 778)) local merged bytes read: 0.0 B number of partitions: 1 remote reqs duration: 0 ms remote bytes read to disk: 0.0 B shuffle bytes written total (min, med, max (stageId: taskId)) 171.0 B (56.0 B, 56.0 B, 59.0 B (stage 894.0: task 778))"]; subgraph cluster4 { isCluster="true"; label="WholeStageCodegen (1)\n \nduration: total (min, med, max (stageId: taskId))\n7.5 s (230 ms, 3.6 s, 3.7 s (stage 894.0: task 777))"; 5 [labelType="html" label="HashAggregate time in aggregation build total (min, med, max (stageId: taskId)) 7.5 s (230 ms, 3.6 s, 3.7 s (stage 894.0: task 777)) number of output rows: 3"]; } 6 [labelType="html" label=" Project "]; 7 [labelType="html" label="Filter number of output rows: 1"]; 8 [labelType="html" label="Scan csv number of output rows: 21,121 number of files read: 1 metadata time: 0 ms size of files read: 8.3 MiB"]; 2->0; 3->2; 5->3; 6->5; 7->6; 8->7; }

AdaptiveSparkPlan isFinalPlan=true

HashAggregate(keys=[], functions=[count(1)])

WholeStageCodegen (2)

Exchange SinglePartition, ENSURE_REQUIREMENTS, [plan_id=22708]

HashAggregate(keys=[], functions=[partial_count(1)])

WholeStageCodegen (1)

Project

Filter ((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(FINESS#226274)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(FINESS#226274)), 300288329) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(NO_RSS#226275)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(NO_RSS#226275)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(NO_ADMIN#226276)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(NO_ADMIN#226276)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(DATE_ENT#226277)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(DATE_ENT#226277)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(DATE_SOR#226278)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(DATE_SOR#226278)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(VALO#226279)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(VALO#226279)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(GHS#226280)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(GHS#226280)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(PONDER#226281)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(PONDER#226281)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COEFSEG#226282)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(COEFSEG#226282)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COEFGEO#226283)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(COEFGEO#226283)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(TAUX2#226284)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(TAUX2#226284)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(MNT_MAJO#226285)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(MNT_MAJO#226285)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(TMF#226286)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(TMF#226286)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(MNT_FJ2#226287)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(MNT_FJ2#226287)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(MNT_GHS#226288)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(MNT_GHS#226288)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(MNT_GHS_AM#226289)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(MNT_GHS_AM#226289)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(NBEXB#226290)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(NBEXB#226290)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(MNT_EXINF#226291)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(MNT_EXINF#226291)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(MNT_EXINF_AM#226292)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(MNT_EXINF_AM#226292)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(GHS50#226293)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(GHS50#226293)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(MNT_GHS50#226294)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(MNT_GHS50#226294)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(MNT_GHS50_AM#226295)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(MNT_GHS50_AM#226295)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(NBEXH#226296)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(NBEXH#226296)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(MNT_EXH#226297)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(MNT_EXH#226297)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(MNT_EXH_AM#226298)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(MNT_EXH_AM#226298)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(MNT_SUPPHD#226299)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(MNT_SUPPHD#226299)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(MNT_SUPPHD_AM#226300)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(MNT_SUPPHD_AM#226300)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(MNT_SUPPENT1#226301)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(MNT_SUPPENT1#226301)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(MNT_SUPPENT1_AM#226302)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(MNT_SUPPENT1_AM#226302)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(MNT_SUPPENT2#226303)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(MNT_SUPPENT2#226303)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(MNT_SUPPENT2_AM#226304)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(MNT_SUPPENT2_AM#226304)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(MNT_SUPPENT3#226305)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(MNT_SUPPENT3#226305)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(MNT_SUPPENT3_AM#226306)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(MNT_SUPPENT3_AM#226306)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(MNT_DIP#226307)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(MNT_DIP#226307)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(MNT_DIP_AM#226308)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(MNT_DIP_AM#226308)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SUPPHD#226309)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(SUPPHD#226309)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SUPPENT1#226310)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(SUPPENT1#226310)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SUPPENT2#226311)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(SUPPENT2#226311)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SUPPENT3#226312)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(SUPPENT3#226312)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(NB_DIP#226313)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(NB_DIP#226313)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(TYPORG#226314)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(TYPORG#226314)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(TYPORG5#226315)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(TYPORG5#226315)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(TYPORG6#226316)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(TYPORG6#226316)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(TYPORG7#226317)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(TYPORG7#226317)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(TYPORG8#226318)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(TYPORG8#226318)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(TYPORG9#226319)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(TYPORG9#226319)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(TYPORGA#226320)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(TYPORGA#226320)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(MNT_PO1#226321)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(MNT_PO1#226321)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(MNT_PO1_AM#226322)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(MNT_PO1_AM#226322)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(MNT_PO2#226323)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(MNT_PO2#226323)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(MNT_PO2_AM#226324)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(MNT_PO2_AM#226324)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(MNT_PO3#226325)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(MNT_PO3#226325)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(MNT_PO3_AM#226326)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(MNT_PO3_AM#226326)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(MNT_PO4#226327)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(MNT_PO4#226327)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(MNT_PO4_AM#226328)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(MNT_PO4_AM#226328)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(MNT_PO5#226329)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(MNT_PO5#226329)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(MNT_PO5_AM#226330)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(MNT_PO5_AM#226330)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(MNT_PO6#226331)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(MNT_PO6#226331)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(MNT_PO6_AM#226332)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(MNT_PO6_AM#226332)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(MNT_PO7#226333)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(MNT_PO7#226333)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(MNT_PO7_AM#226334)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(MNT_PO7_AM#226334)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(MNT_PO8#226335)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(MNT_PO8#226335)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(MNT_PO8_AM#226336)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(MNT_PO8_AM#226336)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(MNT_PO9#226337)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(MNT_PO9#226337)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(MNT_PO9_AM#226338)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(MNT_PO9_AM#226338)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(MNT_POA#226339)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(MNT_POA#226339)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(MNT_POA_AM#226340)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(MNT_POA_AM#226340)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(NB_9610#226341)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(NB_9610#226341)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(MNT_9610#226342)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(MNT_9610#226342)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(MNT_9610_AM#226343)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(MNT_9610_AM#226343)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(NB_9619#226344)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(NB_9619#226344)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(MNT_9619#226345)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(MNT_9619#226345)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(MNT_9619_AM#226346)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(MNT_9619_AM#226346)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(NB_9620#226347)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(NB_9620#226347)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(MNT_9620#226348)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(MNT_9620#226348)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(MNT_9620_AM#226349)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(MNT_9620_AM#226349)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(NB_9621#226350)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(NB_9621#226350)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(MNT_9621#226351)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(MNT_9621#226351)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(MNT_9621_AM#226352)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(MNT_9621_AM#226352)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(NB_9622#226353)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(NB_9622#226353)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(MNT_9622#226354)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(MNT_9622#226354)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(MNT_9622_AM#226355)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(MNT_9622_AM#226355)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(NB_9623#226356)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(NB_9623#226356)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(MNT_9623#226357)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(MNT_9623#226357)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(MNT_9623_AM#226358)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(MNT_9623_AM#226358)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(NB_9625#226359)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(NB_9625#226359)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(MNT_9625#226360)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(MNT_9625#226360)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(MNT_9625_AM#226361)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(MNT_9625_AM#226361)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(NB_9631#226362)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(NB_9631#226362)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(MNT_9631#226363)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(MNT_9631#226363)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(MNT_9631_AM#226364)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(MNT_9631_AM#226364)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(NB_9632#226365)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(NB_9632#226365)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(MNT_9632#226366)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(MNT_9632#226366)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(MNT_9632_AM#226367)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(MNT_9632_AM#226367)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(NB_9633#226368)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(NB_9633#226368)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(MNT_9633#226369)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(MNT_9633#226369)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(MNT_9633_AM#226370)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(MNT_9633_AM#226370)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(NB_9639#226371)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(NB_9639#226371)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(MNT_9639#226372)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(MNT_9639#226372)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(MNT_9639_AM#226373)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(MNT_9639_AM#226373)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(NB_9615#226374)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(NB_9615#226374)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(MNT_9615#226375)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(MNT_9615#226375)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(MNT_9615_AM#226376)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(MNT_9615_AM#226376)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(NBJREA#226377)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(NBJREA#226377)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(MNT_REA#226378)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(MNT_REA#226378)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(MNT_REA_AM#226379)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(MNT_REA_AM#226379)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(NBREP#226380)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(NBREP#226380)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(MNT_REP#226381)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(MNT_REP#226381)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(MNT_REP_AM#226382)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(MNT_REP_AM#226382)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(NB_STF2#226383)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(NB_STF2#226383)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(MNT_SI#226384)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(MNT_SI#226384)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(MNT_SI_AM#226385)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(MNT_SI_AM#226385)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(NB_SRC2#226386)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(NB_SRC2#226386)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(MNT_SC#226387)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(MNT_SC#226387)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(MNT_SC_AM#226388)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(MNT_SC_AM#226388)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(NB_NN1#226389)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(NB_NN1#226389)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(MNT_NN1#226390)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(MNT_NN1#226390)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(MNT_NN1_AM#226391)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(MNT_NN1_AM#226391)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(NB_NN2#226392)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(NB_NN2#226392)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(MNT_NN2#226393)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(MNT_NN2#226393)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(MNT_NN2_AM#226394)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(MNT_NN2_AM#226394)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(NB_NN3#226395)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(NB_NN3#226395)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(MNT_NN3#226396)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(MNT_NN3#226396)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(MNT_NN3_AM#226397)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(MNT_NN3_AM#226397)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(NBCAISSON#226398)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(NBCAISSON#226398)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(MNT_CAISSON#226399)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(MNT_CAISSON#226399)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(MNT_CAISSON_AM#226400)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(MNT_CAISSON_AM#226400)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(NB_RAP#226401)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(NB_RAP#226401)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(MNT_RAP#226402)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(MNT_RAP#226402)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(MNT_RAP_AM#226403)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(MNT_RAP_AM#226403)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(NB_ANT#226404)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(NB_ANT#226404)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(MNT_ANT#226405)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(MNT_ANT#226405)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(MNT_ANT_AM#226406)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(MNT_ANT_AM#226406)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(NB_SUPP_INNO#226407)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(NB_SUPP_INNO#226407)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(MNT_SUPP_INNO#226408)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(MNT_SUPP_INNO#226408)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(MNT_SUPP_INNO_AM#226409)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(MNT_SUPP_INNO_AM#226409)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(NB_SDC#226410)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(NB_SDC#226410)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(MNT_SDC#226411)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(MNT_SDC#226411)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(MNT_SDC_AM#226412)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(MNT_SDC_AM#226412)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(NB_CTC#226413)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(NB_CTC#226413)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(MNT_CTC#226414)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(MNT_CTC#226414)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(MNT_CTC_AM#226415)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(MNT_CTC_AM#226415)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(MNT_MON#226416)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(MNT_MON#226416)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(MNT_DMI#226417)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(MNT_DMI#226417)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(MNT_MED_APAC#226418)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(MNT_MED_APAC#226418)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(MNT_IVG#226419)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(MNT_IVG#226419)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(MNT_IVG_AM#226420)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(MNT_IVG_AM#226420)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(MNT_TRANS#226421)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(MNT_TRANS#226421)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(MNT_TRANS_AM#226422)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(MNT_TRANS_AM#226422)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(MNT_TOT#226423)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(MNT_TOT#226423)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(MNT_TOT_AM#226424)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(MNT_TOT_AM#226424)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(MNT_RAC#226425)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(MNT_RAC#226425)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(FLAG_FIDES#226426)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(FLAG_FIDES#226426)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COEFP#226427)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(COEFP#226427)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COEFREP#226428)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(COEFREP#226428)), 300288329) END)

FileScan csv [FINESS#226274,NO_RSS#226275,NO_ADMIN#226276,DATE_ENT#226277,DATE_SOR#226278,VALO#226279,GHS#226280,PONDER#226281,COEFSEG#226282,COEFGEO#226283,TAUX2#226284,MNT_MAJO#226285,TMF#226286,MNT_FJ2#226287,MNT_GHS#226288,MNT_GHS_AM#226289,NBEXB#226290,MNT_EXINF#226291,MNT_EXINF_AM#226292,GHS50#226293,MNT_GHS50#226294,MNT_GHS50_AM#226295,NBEXH#226296,MNT_EXH#226297,... 131 more fields] Batched: false, DataFilters: [((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((..., Format: CSV, Location: InMemoryFileIndex(1 paths)[file:/data/input/depot/csv/tmp/VISUALVALOSEJOU_440300/420780652.2025.1..., PartitionFilters: [], PushedFilters: [], ReadSchema: struct<FINESS:string,NO_RSS:string,NO_ADMIN:string,DATE_ENT:string,DATE_SOR:string,VALO:string,GH...

Details

== Physical Plan ==
AdaptiveSparkPlan (11)
+- == Final Plan ==
   * HashAggregate (7)
   +- ShuffleQueryStage (6), Statistics(sizeInBytes=48.0 B, rowCount=3)
      +- Exchange (5)
         +- * HashAggregate (4)
            +- Project (3)
               +- Filter (2)
                  +- Scan csv  (1)
+- == Initial Plan ==
   HashAggregate (10)
   +- Exchange (9)
      +- HashAggregate (8)
         +- Project (3)
            +- Filter (2)
               +- Scan csv  (1)


(1) Scan csv 
Output [155]: [FINESS#226274, NO_RSS#226275, NO_ADMIN#226276, DATE_ENT#226277, DATE_SOR#226278, VALO#226279, GHS#226280, PONDER#226281, COEFSEG#226282, COEFGEO#226283, TAUX2#226284, MNT_MAJO#226285, TMF#226286, MNT_FJ2#226287, MNT_GHS#226288, MNT_GHS_AM#226289, NBEXB#226290, MNT_EXINF#226291, MNT_EXINF_AM#226292, GHS50#226293, MNT_GHS50#226294, MNT_GHS50_AM#226295, NBEXH#226296, MNT_EXH#226297, MNT_EXH_AM#226298, MNT_SUPPHD#226299, MNT_SUPPHD_AM#226300, MNT_SUPPENT1#226301, MNT_SUPPENT1_AM#226302, MNT_SUPPENT2#226303, MNT_SUPPENT2_AM#226304, MNT_SUPPENT3#226305, MNT_SUPPENT3_AM#226306, MNT_DIP#226307, MNT_DIP_AM#226308, SUPPHD#226309, SUPPENT1#226310, SUPPENT2#226311, SUPPENT3#226312, NB_DIP#226313, TYPORG#226314, TYPORG5#226315, TYPORG6#226316, TYPORG7#226317, TYPORG8#226318, TYPORG9#226319, TYPORGA#226320, MNT_PO1#226321, MNT_PO1_AM#226322, MNT_PO2#226323, MNT_PO2_AM#226324, MNT_PO3#226325, MNT_PO3_AM#226326, MNT_PO4#226327, MNT_PO4_AM#226328, MNT_PO5#226329, MNT_PO5_AM#226330, MNT_PO6#226331, MNT_PO6_AM#226332, MNT_PO7#226333, MNT_PO7_AM#226334, MNT_PO8#226335, MNT_PO8_AM#226336, MNT_PO9#226337, MNT_PO9_AM#226338, MNT_POA#226339, MNT_POA_AM#226340, NB_9610#226341, MNT_9610#226342, MNT_9610_AM#226343, NB_9619#226344, MNT_9619#226345, MNT_9619_AM#226346, NB_9620#226347, MNT_9620#226348, MNT_9620_AM#226349, NB_9621#226350, MNT_9621#226351, MNT_9621_AM#226352, NB_9622#226353, MNT_9622#226354, MNT_9622_AM#226355, NB_9623#226356, MNT_9623#226357, MNT_9623_AM#226358, NB_9625#226359, MNT_9625#226360, MNT_9625_AM#226361, NB_9631#226362, MNT_9631#226363, MNT_9631_AM#226364, NB_9632#226365, MNT_9632#226366, MNT_9632_AM#226367, NB_9633#226368, MNT_9633#226369, MNT_9633_AM#226370, NB_9639#226371, MNT_9639#226372, MNT_9639_AM#226373, NB_9615#226374, MNT_9615#226375, MNT_9615_AM#226376, NBJREA#226377, MNT_REA#226378, MNT_REA_AM#226379, NBREP#226380, MNT_REP#226381, MNT_REP_AM#226382, NB_STF2#226383, MNT_SI#226384, MNT_SI_AM#226385, NB_SRC2#226386, MNT_SC#226387, MNT_SC_AM#226388, NB_NN1#226389, MNT_NN1#226390, MNT_NN1_AM#226391, NB_NN2#226392, MNT_NN2#226393, MNT_NN2_AM#226394, NB_NN3#226395, MNT_NN3#226396, MNT_NN3_AM#226397, NBCAISSON#226398, MNT_CAISSON#226399, MNT_CAISSON_AM#226400, NB_RAP#226401, MNT_RAP#226402, MNT_RAP_AM#226403, NB_ANT#226404, MNT_ANT#226405, MNT_ANT_AM#226406, NB_SUPP_INNO#226407, MNT_SUPP_INNO#226408, MNT_SUPP_INNO_AM#226409, NB_SDC#226410, MNT_SDC#226411, MNT_SDC_AM#226412, NB_CTC#226413, MNT_CTC#226414, MNT_CTC_AM#226415, MNT_MON#226416, MNT_DMI#226417, MNT_MED_APAC#226418, MNT_IVG#226419, MNT_IVG_AM#226420, MNT_TRANS#226421, MNT_TRANS_AM#226422, MNT_TOT#226423, MNT_TOT_AM#226424, MNT_RAC#226425, FLAG_FIDES#226426, COEFP#226427, COEFREP#226428]
Batched: false
Location: InMemoryFileIndex [file:/data/input/depot/csv/tmp/VISUALVALOSEJOU_440300/420780652.2025.12.MCO.VisualValoSejours.csv]
ReadSchema: struct<FINESS:string,NO_RSS:string,NO_ADMIN:string,DATE_ENT:string,DATE_SOR:string,VALO:string,GHS:string,PONDER:string,COEFSEG:string,COEFGEO:string,TAUX2:string,MNT_MAJO:string,TMF:string,MNT_FJ2:string,MNT_GHS:string,MNT_GHS_AM:string,NBEXB:string,MNT_EXINF:string,MNT_EXINF_AM:string,GHS50:string,MNT_GHS50:string,MNT_GHS50_AM:string,NBEXH:string,MNT_EXH:string,MNT_EXH_AM:string,MNT_SUPPHD:string,MNT_SUPPHD_AM:string,MNT_SUPPENT1:string,MNT_SUPPENT1_AM:string,MNT_SUPPENT2:string,MNT_SUPPENT2_AM:string,MNT_SUPPENT3:string,MNT_SUPPENT3_AM:string,MNT_DIP:string,MNT_DIP_AM:string,SUPPHD:string,SUPPENT1:string,SUPPENT2:string,SUPPENT3:string,NB_DIP:string,TYPORG:string,TYPORG5:string,TYPORG6:string,TYPORG7:string,TYPORG8:string,TYPORG9:string,TYPORGA:string,MNT_PO1:string,MNT_PO1_AM:string,MNT_PO2:string,MNT_PO2_AM:string,MNT_PO3:string,MNT_PO3_AM:string,MNT_PO4:string,MNT_PO4_AM:string,MNT_PO5:string,MNT_PO5_AM:string,MNT_PO6:string,MNT_PO6_AM:string,MNT_PO7:string,MNT_PO7_AM:string,MNT_PO8:string,MNT_PO8_AM:string,MNT_PO9:string,MNT_PO9_AM:string,MNT_POA:string,MNT_POA_AM:string,NB_9610:string,MNT_9610:string,MNT_9610_AM:string,NB_9619:string,MNT_9619:string,MNT_9619_AM:string,NB_9620:string,MNT_9620:string,MNT_9620_AM:string,NB_9621:string,MNT_9621:string,MNT_9621_AM:string,NB_9622:string,MNT_9622:string,MNT_9622_AM:string,NB_9623:string,MNT_9623:string,MNT_9623_AM:string,NB_9625:string,MNT_9625:string,MNT_9625_AM:string,NB_9631:string,MNT_9631:string,MNT_9631_AM:string,NB_9632:string,MNT_9632:string,MNT_9632_AM:string,NB_9633:string,MNT_9633:string,MNT_9633_AM:string,NB_9639:string,MNT_9639:string,MNT_9639_AM:string,NB_9615:string,MNT_9615:string,MNT_9615_AM:string,NBJREA:string,MNT_REA:string,MNT_REA_AM:string,NBREP:string,MNT_REP:string,MNT_REP_AM:string,NB_STF2:string,MNT_SI:string,MNT_SI_AM:string,NB_SRC2:string,MNT_SC:string,MNT_SC_AM:string,NB_NN1:string,MNT_NN1:string,MNT_NN1_AM:string,NB_NN2:string,MNT_NN2:string,MNT_NN2_AM:string,NB_NN3:string,MNT_NN3:string,MNT_NN3_AM:string,NBCAISSON:string,MNT_CAISSON:string,MNT_CAISSON_AM:string,NB_RAP:string,MNT_RAP:string,MNT_RAP_AM:string,NB_ANT:string,MNT_ANT:string,MNT_ANT_AM:string,NB_SUPP_INNO:string,MNT_SUPP_INNO:string,MNT_SUPP_INNO_AM:string,NB_SDC:string,MNT_SDC:string,MNT_SDC_AM:string,NB_CTC:string,MNT_CTC:string,MNT_CTC_AM:string,MNT_MON:string,MNT_DMI:string,MNT_MED_APAC:string,MNT_IVG:string,MNT_IVG_AM:string,MNT_TRANS:string,MNT_TRANS_AM:string,MNT_TOT:string,MNT_TOT_AM:string,MNT_RAC:string,FLAG_FIDES:string,COEFP:string,COEFREP:string>

(2) Filter
Input [155]: [FINESS#226274, NO_RSS#226275, NO_ADMIN#226276, DATE_ENT#226277, DATE_SOR#226278, VALO#226279, GHS#226280, PONDER#226281, COEFSEG#226282, COEFGEO#226283, TAUX2#226284, MNT_MAJO#226285, TMF#226286, MNT_FJ2#226287, MNT_GHS#226288, MNT_GHS_AM#226289, NBEXB#226290, MNT_EXINF#226291, MNT_EXINF_AM#226292, GHS50#226293, MNT_GHS50#226294, MNT_GHS50_AM#226295, NBEXH#226296, MNT_EXH#226297, MNT_EXH_AM#226298, MNT_SUPPHD#226299, MNT_SUPPHD_AM#226300, MNT_SUPPENT1#226301, MNT_SUPPENT1_AM#226302, MNT_SUPPENT2#226303, MNT_SUPPENT2_AM#226304, MNT_SUPPENT3#226305, MNT_SUPPENT3_AM#226306, MNT_DIP#226307, MNT_DIP_AM#226308, SUPPHD#226309, SUPPENT1#226310, SUPPENT2#226311, SUPPENT3#226312, NB_DIP#226313, TYPORG#226314, TYPORG5#226315, TYPORG6#226316, TYPORG7#226317, TYPORG8#226318, TYPORG9#226319, TYPORGA#226320, MNT_PO1#226321, MNT_PO1_AM#226322, MNT_PO2#226323, MNT_PO2_AM#226324, MNT_PO3#226325, MNT_PO3_AM#226326, MNT_PO4#226327, MNT_PO4_AM#226328, MNT_PO5#226329, MNT_PO5_AM#226330, MNT_PO6#226331, MNT_PO6_AM#226332, MNT_PO7#226333, MNT_PO7_AM#226334, MNT_PO8#226335, MNT_PO8_AM#226336, MNT_PO9#226337, MNT_PO9_AM#226338, MNT_POA#226339, MNT_POA_AM#226340, NB_9610#226341, MNT_9610#226342, MNT_9610_AM#226343, NB_9619#226344, MNT_9619#226345, MNT_9619_AM#226346, NB_9620#226347, MNT_9620#226348, MNT_9620_AM#226349, NB_9621#226350, MNT_9621#226351, MNT_9621_AM#226352, NB_9622#226353, MNT_9622#226354, MNT_9622_AM#226355, NB_9623#226356, MNT_9623#226357, MNT_9623_AM#226358, NB_9625#226359, MNT_9625#226360, MNT_9625_AM#226361, NB_9631#226362, MNT_9631#226363, MNT_9631_AM#226364, NB_9632#226365, MNT_9632#226366, MNT_9632_AM#226367, NB_9633#226368, MNT_9633#226369, MNT_9633_AM#226370, NB_9639#226371, MNT_9639#226372, MNT_9639_AM#226373, NB_9615#226374, MNT_9615#226375, MNT_9615_AM#226376, NBJREA#226377, MNT_REA#226378, MNT_REA_AM#226379, NBREP#226380, MNT_REP#226381, MNT_REP_AM#226382, NB_STF2#226383, MNT_SI#226384, MNT_SI_AM#226385, NB_SRC2#226386, MNT_SC#226387, MNT_SC_AM#226388, NB_NN1#226389, MNT_NN1#226390, MNT_NN1_AM#226391, NB_NN2#226392, MNT_NN2#226393, MNT_NN2_AM#226394, NB_NN3#226395, MNT_NN3#226396, MNT_NN3_AM#226397, NBCAISSON#226398, MNT_CAISSON#226399, MNT_CAISSON_AM#226400, NB_RAP#226401, MNT_RAP#226402, MNT_RAP_AM#226403, NB_ANT#226404, MNT_ANT#226405, MNT_ANT_AM#226406, NB_SUPP_INNO#226407, MNT_SUPP_INNO#226408, MNT_SUPP_INNO_AM#226409, NB_SDC#226410, MNT_SDC#226411, MNT_SDC_AM#226412, NB_CTC#226413, MNT_CTC#226414, MNT_CTC_AM#226415, MNT_MON#226416, MNT_DMI#226417, MNT_MED_APAC#226418, MNT_IVG#226419, MNT_IVG_AM#226420, MNT_TRANS#226421, MNT_TRANS_AM#226422, MNT_TOT#226423, MNT_TOT_AM#226424, MNT_RAC#226425, FLAG_FIDES#226426, COEFP#226427, COEFREP#226428]
Condition : ((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(FINESS#226274)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(FINESS#226274)), 300288329) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(NO_RSS#226275)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(NO_RSS#226275)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(NO_ADMIN#226276)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(NO_ADMIN#226276)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(DATE_ENT#226277)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(DATE_ENT#226277)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(DATE_SOR#226278)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(DATE_SOR#226278)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(VALO#226279)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(VALO#226279)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(GHS#226280)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(GHS#226280)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(PONDER#226281)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(PONDER#226281)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COEFSEG#226282)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(COEFSEG#226282)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COEFGEO#226283)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(COEFGEO#226283)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(TAUX2#226284)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(TAUX2#226284)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(MNT_MAJO#226285)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(MNT_MAJO#226285)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(TMF#226286)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(TMF#226286)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(MNT_FJ2#226287)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(MNT_FJ2#226287)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(MNT_GHS#226288)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(MNT_GHS#226288)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(MNT_GHS_AM#226289)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(MNT_GHS_AM#226289)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(NBEXB#226290)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(NBEXB#226290)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(MNT_EXINF#226291)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(MNT_EXINF#226291)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(MNT_EXINF_AM#226292)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(MNT_EXINF_AM#226292)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(GHS50#226293)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(GHS50#226293)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(MNT_GHS50#226294)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(MNT_GHS50#226294)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(MNT_GHS50_AM#226295)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(MNT_GHS50_AM#226295)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(NBEXH#226296)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(NBEXH#226296)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(MNT_EXH#226297)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(MNT_EXH#226297)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(MNT_EXH_AM#226298)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(MNT_EXH_AM#226298)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(MNT_SUPPHD#226299)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(MNT_SUPPHD#226299)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(MNT_SUPPHD_AM#226300)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(MNT_SUPPHD_AM#226300)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(MNT_SUPPENT1#226301)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(MNT_SUPPENT1#226301)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(MNT_SUPPENT1_AM#226302)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(MNT_SUPPENT1_AM#226302)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(MNT_SUPPENT2#226303)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(MNT_SUPPENT2#226303)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(MNT_SUPPENT2_AM#226304)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(MNT_SUPPENT2_AM#226304)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(MNT_SUPPENT3#226305)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(MNT_SUPPENT3#226305)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(MNT_SUPPENT3_AM#226306)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(MNT_SUPPENT3_AM#226306)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(MNT_DIP#226307)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(MNT_DIP#226307)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(MNT_DIP_AM#226308)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(MNT_DIP_AM#226308)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SUPPHD#226309)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(SUPPHD#226309)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SUPPENT1#226310)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(SUPPENT1#226310)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SUPPENT2#226311)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(SUPPENT2#226311)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SUPPENT3#226312)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(SUPPENT3#226312)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(NB_DIP#226313)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(NB_DIP#226313)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(TYPORG#226314)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(TYPORG#226314)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(TYPORG5#226315)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(TYPORG5#226315)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(TYPORG6#226316)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(TYPORG6#226316)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(TYPORG7#226317)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(TYPORG7#226317)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(TYPORG8#226318)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(TYPORG8#226318)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(TYPORG9#226319)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(TYPORG9#226319)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(TYPORGA#226320)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(TYPORGA#226320)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(MNT_PO1#226321)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(MNT_PO1#226321)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(MNT_PO1_AM#226322)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(MNT_PO1_AM#226322)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(MNT_PO2#226323)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(MNT_PO2#226323)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(MNT_PO2_AM#226324)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(MNT_PO2_AM#226324)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(MNT_PO3#226325)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(MNT_PO3#226325)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(MNT_PO3_AM#226326)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(MNT_PO3_AM#226326)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(MNT_PO4#226327)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(MNT_PO4#226327)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(MNT_PO4_AM#226328)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(MNT_PO4_AM#226328)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(MNT_PO5#226329)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(MNT_PO5#226329)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(MNT_PO5_AM#226330)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(MNT_PO5_AM#226330)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(MNT_PO6#226331)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(MNT_PO6#226331)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(MNT_PO6_AM#226332)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(MNT_PO6_AM#226332)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(MNT_PO7#226333)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(MNT_PO7#226333)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(MNT_PO7_AM#226334)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(MNT_PO7_AM#226334)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(MNT_PO8#226335)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(MNT_PO8#226335)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(MNT_PO8_AM#226336)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(MNT_PO8_AM#226336)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(MNT_PO9#226337)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(MNT_PO9#226337)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(MNT_PO9_AM#226338)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(MNT_PO9_AM#226338)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(MNT_POA#226339)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(MNT_POA#226339)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(MNT_POA_AM#226340)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(MNT_POA_AM#226340)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(NB_9610#226341)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(NB_9610#226341)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(MNT_9610#226342)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(MNT_9610#226342)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(MNT_9610_AM#226343)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(MNT_9610_AM#226343)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(NB_9619#226344)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(NB_9619#226344)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(MNT_9619#226345)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(MNT_9619#226345)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(MNT_9619_AM#226346)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(MNT_9619_AM#226346)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(NB_9620#226347)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(NB_9620#226347)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(MNT_9620#226348)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(MNT_9620#226348)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(MNT_9620_AM#226349)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(MNT_9620_AM#226349)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(NB_9621#226350)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(NB_9621#226350)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(MNT_9621#226351)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(MNT_9621#226351)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(MNT_9621_AM#226352)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(MNT_9621_AM#226352)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(NB_9622#226353)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(NB_9622#226353)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(MNT_9622#226354)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(MNT_9622#226354)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(MNT_9622_AM#226355)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(MNT_9622_AM#226355)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(NB_9623#226356)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(NB_9623#226356)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(MNT_9623#226357)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(MNT_9623#226357)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(MNT_9623_AM#226358)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(MNT_9623_AM#226358)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(NB_9625#226359)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(NB_9625#226359)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(MNT_9625#226360)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(MNT_9625#226360)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(MNT_9625_AM#226361)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(MNT_9625_AM#226361)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(NB_9631#226362)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(NB_9631#226362)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(MNT_9631#226363)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(MNT_9631#226363)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(MNT_9631_AM#226364)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(MNT_9631_AM#226364)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(NB_9632#226365)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(NB_9632#226365)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(MNT_9632#226366)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(MNT_9632#226366)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(MNT_9632_AM#226367)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(MNT_9632_AM#226367)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(NB_9633#226368)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(NB_9633#226368)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(MNT_9633#226369)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(MNT_9633#226369)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(MNT_9633_AM#226370)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(MNT_9633_AM#226370)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(NB_9639#226371)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(NB_9639#226371)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(MNT_9639#226372)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(MNT_9639#226372)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(MNT_9639_AM#226373)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(MNT_9639_AM#226373)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(NB_9615#226374)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(NB_9615#226374)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(MNT_9615#226375)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(MNT_9615#226375)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(MNT_9615_AM#226376)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(MNT_9615_AM#226376)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(NBJREA#226377)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(NBJREA#226377)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(MNT_REA#226378)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(MNT_REA#226378)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(MNT_REA_AM#226379)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(MNT_REA_AM#226379)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(NBREP#226380)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(NBREP#226380)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(MNT_REP#226381)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(MNT_REP#226381)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(MNT_REP_AM#226382)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(MNT_REP_AM#226382)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(NB_STF2#226383)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(NB_STF2#226383)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(MNT_SI#226384)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(MNT_SI#226384)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(MNT_SI_AM#226385)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(MNT_SI_AM#226385)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(NB_SRC2#226386)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(NB_SRC2#226386)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(MNT_SC#226387)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(MNT_SC#226387)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(MNT_SC_AM#226388)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(MNT_SC_AM#226388)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(NB_NN1#226389)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(NB_NN1#226389)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(MNT_NN1#226390)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(MNT_NN1#226390)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(MNT_NN1_AM#226391)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(MNT_NN1_AM#226391)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(NB_NN2#226392)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(NB_NN2#226392)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(MNT_NN2#226393)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(MNT_NN2#226393)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(MNT_NN2_AM#226394)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(MNT_NN2_AM#226394)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(NB_NN3#226395)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(NB_NN3#226395)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(MNT_NN3#226396)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(MNT_NN3#226396)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(MNT_NN3_AM#226397)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(MNT_NN3_AM#226397)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(NBCAISSON#226398)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(NBCAISSON#226398)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(MNT_CAISSON#226399)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(MNT_CAISSON#226399)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(MNT_CAISSON_AM#226400)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(MNT_CAISSON_AM#226400)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(NB_RAP#226401)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(NB_RAP#226401)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(MNT_RAP#226402)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(MNT_RAP#226402)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(MNT_RAP_AM#226403)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(MNT_RAP_AM#226403)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(NB_ANT#226404)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(NB_ANT#226404)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(MNT_ANT#226405)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(MNT_ANT#226405)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(MNT_ANT_AM#226406)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(MNT_ANT_AM#226406)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(NB_SUPP_INNO#226407)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(NB_SUPP_INNO#226407)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(MNT_SUPP_INNO#226408)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(MNT_SUPP_INNO#226408)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(MNT_SUPP_INNO_AM#226409)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(MNT_SUPP_INNO_AM#226409)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(NB_SDC#226410)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(NB_SDC#226410)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(MNT_SDC#226411)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(MNT_SDC#226411)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(MNT_SDC_AM#226412)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(MNT_SDC_AM#226412)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(NB_CTC#226413)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(NB_CTC#226413)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(MNT_CTC#226414)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(MNT_CTC#226414)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(MNT_CTC_AM#226415)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(MNT_CTC_AM#226415)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(MNT_MON#226416)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(MNT_MON#226416)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(MNT_DMI#226417)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(MNT_DMI#226417)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(MNT_MED_APAC#226418)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(MNT_MED_APAC#226418)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(MNT_IVG#226419)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(MNT_IVG#226419)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(MNT_IVG_AM#226420)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(MNT_IVG_AM#226420)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(MNT_TRANS#226421)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(MNT_TRANS#226421)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(MNT_TRANS_AM#226422)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(MNT_TRANS_AM#226422)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(MNT_TOT#226423)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(MNT_TOT#226423)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(MNT_TOT_AM#226424)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(MNT_TOT_AM#226424)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(MNT_RAC#226425)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(MNT_RAC#226425)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(FLAG_FIDES#226426)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(FLAG_FIDES#226426)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COEFP#226427)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(COEFP#226427)), 300288329) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COEFREP#226428)), 300288329)) THEN false ELSE Contains(str_remove_accent(upper(COEFREP#226428)), 300288329) END)

(3) Project
Output: []
Input [155]: [FINESS#226274, NO_RSS#226275, NO_ADMIN#226276, DATE_ENT#226277, DATE_SOR#226278, VALO#226279, GHS#226280, PONDER#226281, COEFSEG#226282, COEFGEO#226283, TAUX2#226284, MNT_MAJO#226285, TMF#226286, MNT_FJ2#226287, MNT_GHS#226288, MNT_GHS_AM#226289, NBEXB#226290, MNT_EXINF#226291, MNT_EXINF_AM#226292, GHS50#226293, MNT_GHS50#226294, MNT_GHS50_AM#226295, NBEXH#226296, MNT_EXH#226297, MNT_EXH_AM#226298, MNT_SUPPHD#226299, MNT_SUPPHD_AM#226300, MNT_SUPPENT1#226301, MNT_SUPPENT1_AM#226302, MNT_SUPPENT2#226303, MNT_SUPPENT2_AM#226304, MNT_SUPPENT3#226305, MNT_SUPPENT3_AM#226306, MNT_DIP#226307, MNT_DIP_AM#226308, SUPPHD#226309, SUPPENT1#226310, SUPPENT2#226311, SUPPENT3#226312, NB_DIP#226313, TYPORG#226314, TYPORG5#226315, TYPORG6#226316, TYPORG7#226317, TYPORG8#226318, TYPORG9#226319, TYPORGA#226320, MNT_PO1#226321, MNT_PO1_AM#226322, MNT_PO2#226323, MNT_PO2_AM#226324, MNT_PO3#226325, MNT_PO3_AM#226326, MNT_PO4#226327, MNT_PO4_AM#226328, MNT_PO5#226329, MNT_PO5_AM#226330, MNT_PO6#226331, MNT_PO6_AM#226332, MNT_PO7#226333, MNT_PO7_AM#226334, MNT_PO8#226335, MNT_PO8_AM#226336, MNT_PO9#226337, MNT_PO9_AM#226338, MNT_POA#226339, MNT_POA_AM#226340, NB_9610#226341, MNT_9610#226342, MNT_9610_AM#226343, NB_9619#226344, MNT_9619#226345, MNT_9619_AM#226346, NB_9620#226347, MNT_9620#226348, MNT_9620_AM#226349, NB_9621#226350, MNT_9621#226351, MNT_9621_AM#226352, NB_9622#226353, MNT_9622#226354, MNT_9622_AM#226355, NB_9623#226356, MNT_9623#226357, MNT_9623_AM#226358, NB_9625#226359, MNT_9625#226360, MNT_9625_AM#226361, NB_9631#226362, MNT_9631#226363, MNT_9631_AM#226364, NB_9632#226365, MNT_9632#226366, MNT_9632_AM#226367, NB_9633#226368, MNT_9633#226369, MNT_9633_AM#226370, NB_9639#226371, MNT_9639#226372, MNT_9639_AM#226373, NB_9615#226374, MNT_9615#226375, MNT_9615_AM#226376, NBJREA#226377, MNT_REA#226378, MNT_REA_AM#226379, NBREP#226380, MNT_REP#226381, MNT_REP_AM#226382, NB_STF2#226383, MNT_SI#226384, MNT_SI_AM#226385, NB_SRC2#226386, MNT_SC#226387, MNT_SC_AM#226388, NB_NN1#226389, MNT_NN1#226390, MNT_NN1_AM#226391, NB_NN2#226392, MNT_NN2#226393, MNT_NN2_AM#226394, NB_NN3#226395, MNT_NN3#226396, MNT_NN3_AM#226397, NBCAISSON#226398, MNT_CAISSON#226399, MNT_CAISSON_AM#226400, NB_RAP#226401, MNT_RAP#226402, MNT_RAP_AM#226403, NB_ANT#226404, MNT_ANT#226405, MNT_ANT_AM#226406, NB_SUPP_INNO#226407, MNT_SUPP_INNO#226408, MNT_SUPP_INNO_AM#226409, NB_SDC#226410, MNT_SDC#226411, MNT_SDC_AM#226412, NB_CTC#226413, MNT_CTC#226414, MNT_CTC_AM#226415, MNT_MON#226416, MNT_DMI#226417, MNT_MED_APAC#226418, MNT_IVG#226419, MNT_IVG_AM#226420, MNT_TRANS#226421, MNT_TRANS_AM#226422, MNT_TOT#226423, MNT_TOT_AM#226424, MNT_RAC#226425, FLAG_FIDES#226426, COEFP#226427, COEFREP#226428]

(4) HashAggregate [codegen id : 1]
Input: []
Keys: []
Functions [1]: [partial_count(1)]
Aggregate Attributes [1]: [count#228758L]
Results [1]: [count#228759L]

(5) Exchange
Input [1]: [count#228759L]
Arguments: SinglePartition, ENSURE_REQUIREMENTS, [plan_id=22708]

(6) ShuffleQueryStage
Output [1]: [count#228759L]
Arguments: 0

(7) HashAggregate [codegen id : 2]
Input [1]: [count#228759L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#228755L]
Results [1]: [count(1)#228755L AS count#228756L]

(8) HashAggregate
Input: []
Keys: []
Functions [1]: [partial_count(1)]
Aggregate Attributes [1]: [count#228758L]
Results [1]: [count#228759L]

(9) Exchange
Input [1]: [count#228759L]
Arguments: SinglePartition, ENSURE_REQUIREMENTS, [plan_id=22696]

(10) HashAggregate
Input [1]: [count#228759L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#228755L]
Results [1]: [count(1)#228755L AS count#228756L]

(11) AdaptiveSparkPlan
Output [1]: [count#228756L]
Arguments: isFinalPlan=true

SQL / DataFrame Properties

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