SP1 - Details for Query 314

Submitted Time: 2026/02/20 09:26:21
Duration: 17 s
Succeeded Jobs: 454 457

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 (5)\n \nduration: 1 ms"; 2 [labelType="html" label="HashAggregate time in aggregation build: 1 ms number of output rows: 1"]; } 3 [labelType="html" label="Exchange shuffle records written: 21 local merged chunks fetched: 0 shuffle write time total (min, med, max (stageId: taskId)) 10 ms (0 ms, 0 ms, 0 ms (stage 610.0: task 907)) 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: 21 local bytes read: 1239.0 B fetch wait time: 0 ms remote bytes read: 0.0 B merged fetch fallback count: 0 local blocks read: 21 remote merged chunks fetched: 0 remote blocks read: 0 data size total (min, med, max (stageId: taskId)) 336.0 B (16.0 B, 16.0 B, 16.0 B (stage 610.0: task 897)) 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)) 1239.0 B (59.0 B, 59.0 B, 59.0 B (stage 610.0: task 897))"]; subgraph cluster4 { isCluster="true"; label="WholeStageCodegen (4)\n \nduration: total (min, med, max (stageId: taskId))\n55.8 s (661 ms, 2.3 s, 12.2 s (stage 610.0: task 912))"; 5 [labelType="html" label="HashAggregate time in aggregation build total (min, med, max (stageId: taskId)) 55.8 s (660 ms, 2.3 s, 12.2 s (stage 610.0: task 912)) number of output rows: 21"]; } 6 [labelType="html" label=" Union "]; subgraph cluster7 { isCluster="true"; label="WholeStageCodegen (1)\n \nduration: total (min, med, max (stageId: taskId))\n28.4 s (2.3 s, 2.8 s, 3.5 s (stage 610.0: task 893))"; 8 [labelType="html" label=" Project "]; 9 [labelType="html" label="Filter number of output rows: 105,442"]; } 10 [labelType="html" label="Scan csv number of output rows: 601,244 number of files read: 1 metadata time: 0 ms size of files read: 104.1 MiB"]; subgraph cluster11 { isCluster="true"; label="WholeStageCodegen (2)\n \nduration: total (min, med, max (stageId: taskId))\n15.1 s (660 ms, 1.6 s, 1.8 s (stage 610.0: task 896))"; 12 [labelType="html" label=" Project "]; 13 [labelType="html" label="Filter number of output rows: 68,820"]; } 14 [labelType="html" label="Scan csv number of output rows: 354,774 number of files read: 1 metadata time: 0 ms size of files read: 58.3 MiB"]; subgraph cluster15 { isCluster="true"; label="WholeStageCodegen (3)\n \nduration: 12.2 s"; 16 [labelType="html" label=" Project "]; 17 [labelType="html" label="Filter number of output rows: 63,933"]; 18 [labelType="html" label="Scan JDBCRelation((SELECT \"IPP\", \"Code \u00E9tablissement\", \"Lib \u00E9tablissement\", \"Date pr\u00E9l\u00E9vement\", \"Code examen Biologie\", \"Libell\u00E9 examen Biologie\", \"R\u00E9sultat (num\u00E9rique)\", \"Unite\", \"Code m\u00E9decin\", \"Nom m\u00E9decin\", \"Pr\u00E9nom m\u00E9decin\", \"Nom document biologie\", \"Nom complet document biologie\", \"Venue\", \"Borne basse\", \"Borne haute\" FROM \"public\".\"biologie_etb_lin\") as x) [numPartitions=1] number of output rows: 471,858"]; } 2->0; 3->2; 5->3; 6->5; 8->6; 9->8; 10->9; 12->6; 13->12; 14->13; 16->6; 17->16; 18->17; }

AdaptiveSparkPlan isFinalPlan=true

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

WholeStageCodegen (5)

Exchange SinglePartition, ENSURE_REQUIREMENTS, [plan_id=9315]

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

WholeStageCodegen (4)

Union

Project

Filter (((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(IPP#119558)), ME)) THEN false ELSE Contains(str_remove_accent(upper(IPP#119558)), ME) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(Code établissement#119559)), ME)) THEN false ELSE Contains(str_remove_accent(upper(Code établissement#119559)), ME) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(Lib établissement#119560)), ME)) THEN false ELSE Contains(str_remove_accent(upper(Lib établissement#119560)), ME) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(Code examen Biologie#119562)), ME)) THEN false ELSE Contains(str_remove_accent(upper(Code examen Biologie#119562)), ME) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(Libellé examen Biologie#119563)), ME)) THEN false ELSE Contains(str_remove_accent(upper(Libellé examen Biologie#119563)), ME) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(Unite#119565)), ME)) THEN false ELSE Contains(str_remove_accent(upper(Unite#119565)), ME) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(Code médecin#119566)), ME)) THEN false ELSE Contains(str_remove_accent(upper(Code médecin#119566)), ME) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(Nom médecin#119567)), ME)) THEN false ELSE Contains(str_remove_accent(upper(Nom médecin#119567)), ME) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(Prénom médecin#119568)), ME)) THEN false ELSE Contains(str_remove_accent(upper(Prénom médecin#119568)), ME) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(Nom document biologie#119569)), ME)) THEN false ELSE Contains(str_remove_accent(upper(Nom document biologie#119569)), ME) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(Nom complet document biologie#119570)), ME)) THEN false ELSE Contains(str_remove_accent(upper(Nom complet document biologie#119570)), ME) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(Venue#119571)), ME)) THEN false ELSE Contains(str_remove_accent(upper(Venue#119571)), ME) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_create(CH St Agnès))), ME)) THEN false ELSE Contains(str_remove_accent(upper(str_create(CH St Agnès))), ME) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_extract_by_str(Code examen Biologie#119562, _, RIGHT))), ME)) THEN false ELSE Contains(str_remove_accent(upper(str_extract_by_str(Code examen Biologie#119562, _, RIGHT))), ME) END)

WholeStageCodegen (1)

FileScan csv [IPP#119558,Code établissement#119559,Lib établissement#119560,Code examen Biologie#119562,Libellé examen Biologie#119563,Unite#119565,Code médecin#119566,Nom médecin#119567,Prénom médecin#119568,Nom document biologie#119569,Nom complet document biologie#119570,Venue#119571] Batched: false, DataFilters: [(((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(IPP#119558)), ME)) THEN false ELS..., Format: CSV, Location: InMemoryFileIndex(1 paths)[file:/data/input/depot/csv/tmp/BIOLOGIE_SAINT__19889/BIOLOGIE_Etab_STA..., PartitionFilters: [], PushedFilters: [], ReadSchema: struct<IPP:string,Code établissement:string,Lib établissement:string,Code examen Biologie:string,...

Project

Filter (((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(IPP#119723)), ME)) THEN false ELSE Contains(str_remove_accent(upper(IPP#119723)), ME) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(Code établissement#119724)), ME)) THEN false ELSE Contains(str_remove_accent(upper(Code établissement#119724)), ME) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(Lib établissement#119725)), ME)) THEN false ELSE Contains(str_remove_accent(upper(Lib établissement#119725)), ME) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(Code examen Biologie#119727)), ME)) THEN false ELSE Contains(str_remove_accent(upper(Code examen Biologie#119727)), ME) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(Libellé examen Biologie#119728)), ME)) THEN false ELSE Contains(str_remove_accent(upper(Libellé examen Biologie#119728)), ME) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(Unite#119730)), ME)) THEN false ELSE Contains(str_remove_accent(upper(Unite#119730)), ME) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(Code médecin#119731)), ME)) THEN false ELSE Contains(str_remove_accent(upper(Code médecin#119731)), ME) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(Nom médecin#119732)), ME)) THEN false ELSE Contains(str_remove_accent(upper(Nom médecin#119732)), ME) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(Prénom médecin#119733)), ME)) THEN false ELSE Contains(str_remove_accent(upper(Prénom médecin#119733)), ME) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(Nom document biologie#119734)), ME)) THEN false ELSE Contains(str_remove_accent(upper(Nom document biologie#119734)), ME) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(Nom complet document biologie#119735)), ME)) THEN false ELSE Contains(str_remove_accent(upper(Nom complet document biologie#119735)), ME) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(Venue#119736)), ME)) THEN false ELSE Contains(str_remove_accent(upper(Venue#119736)), ME) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_create(CH Butel))), ME)) THEN false ELSE Contains(str_remove_accent(upper(str_create(CH Butel))), ME) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_extract_by_str(Code examen Biologie#119727, _, RIGHT))), ME)) THEN false ELSE Contains(str_remove_accent(upper(str_extract_by_str(Code examen Biologie#119727, _, RIGHT))), ME) END)

WholeStageCodegen (2)

FileScan csv [IPP#119723,Code établissement#119724,Lib établissement#119725,Code examen Biologie#119727,Libellé examen Biologie#119728,Unite#119730,Code médecin#119731,Nom médecin#119732,Prénom médecin#119733,Nom document biologie#119734,Nom complet document biologie#119735,Venue#119736] Batched: false, DataFilters: [(((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(IPP#119723)), ME)) THEN false ELS..., Format: CSV, Location: InMemoryFileIndex(1 paths)[file:/data/input/depot/csv/execution/DD31E585_3541_4A5B_BCA8_52E9CD3FA..., PartitionFilters: [], PushedFilters: [], ReadSchema: struct<IPP:string,Code établissement:string,Lib établissement:string,Code examen Biologie:string,...

Project

Filter (((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(IPP#119888)), ME)) THEN false ELSE Contains(str_remove_accent(upper(IPP#119888)), ME) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(Code établissement#119889)), ME)) THEN false ELSE Contains(str_remove_accent(upper(Code établissement#119889)), ME) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(Lib établissement#119890)), ME)) THEN false ELSE Contains(str_remove_accent(upper(Lib établissement#119890)), ME) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(Code examen Biologie#119892)), ME)) THEN false ELSE Contains(str_remove_accent(upper(Code examen Biologie#119892)), ME) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(Libellé examen Biologie#119893)), ME)) THEN false ELSE Contains(str_remove_accent(upper(Libellé examen Biologie#119893)), ME) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(Unite#119895)), ME)) THEN false ELSE Contains(str_remove_accent(upper(Unite#119895)), ME) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(Code médecin#119896)), ME)) THEN false ELSE Contains(str_remove_accent(upper(Code médecin#119896)), ME) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(Nom médecin#119897)), ME)) THEN false ELSE Contains(str_remove_accent(upper(Nom médecin#119897)), ME) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(Prénom médecin#119898)), ME)) THEN false ELSE Contains(str_remove_accent(upper(Prénom médecin#119898)), ME) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(Nom document biologie#119899)), ME)) THEN false ELSE Contains(str_remove_accent(upper(Nom document biologie#119899)), ME) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(Nom complet document biologie#119900)), ME)) THEN false ELSE Contains(str_remove_accent(upper(Nom complet document biologie#119900)), ME) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(Venue#119901)), ME)) THEN false ELSE Contains(str_remove_accent(upper(Venue#119901)), ME) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_create(Etb Linet))), ME)) THEN false ELSE Contains(str_remove_accent(upper(str_create(Etb Linet))), ME) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_extract_by_str(Code examen Biologie#119892, _, RIGHT))), ME)) THEN false ELSE Contains(str_remove_accent(upper(str_extract_by_str(Code examen Biologie#119892, _, RIGHT))), ME) END)

Scan JDBCRelation((SELECT "IPP", "Code établissement", "Lib établissement", "Date prélévement", "Code examen Biologie", "Libellé examen Biologie", "Résultat (numérique)", "Unite", "Code médecin", "Nom médecin", "Prénom médecin", "Nom document biologie", "Nom complet document biologie", "Venue", "Borne basse", "Borne haute" FROM "public"."biologie_etb_lin") as x) [numPartitions=1] [IPP#119888,Code établissement#119889,Lib établissement#119890,Code examen Biologie#119892,Libellé examen Biologie#119893,Unite#119895,Code médecin#119896,Nom médecin#119897,Prénom médecin#119898,Nom document biologie#119899,Nom complet document biologie#119900,Venue#119901] PushedFilters: [], ReadSchema: struct<IPP:string,Code établissement:string,Lib établissement:string,Code examen Biologie:string,...

WholeStageCodegen (3)

Details

== Physical Plan ==
AdaptiveSparkPlan (23)
+- == Final Plan ==
   * HashAggregate (14)
   +- ShuffleQueryStage (13), Statistics(sizeInBytes=336.0 B, rowCount=21)
      +- Exchange (12)
         +- * HashAggregate (11)
            +- Union (10)
               :- * Project (3)
               :  +- * Filter (2)
               :     +- Scan csv  (1)
               :- * Project (6)
               :  +- * Filter (5)
               :     +- Scan csv  (4)
               +- * Project (9)
                  +- * Filter (8)
                     +- * Scan JDBCRelation((SELECT "IPP", "Code établissement", "Lib établissement", "Date prélévement", "Code examen Biologie", "Libellé  examen Biologie", "Résultat (numérique)", "Unite", "Code médecin", "Nom médecin", "Prénom médecin", "Nom document biologie", "Nom complet document biologie", "Venue", "Borne basse", "Borne haute" FROM "public"."biologie_etb_lin") as x) [numPartitions=1]  (7)
+- == Initial Plan ==
   HashAggregate (22)
   +- Exchange (21)
      +- HashAggregate (20)
         +- Union (19)
            :- Project (16)
            :  +- Filter (15)
            :     +- Scan csv  (1)
            :- Project (18)
            :  +- Filter (17)
            :     +- Scan csv  (4)
            +- Project (9)
               +- Filter (8)
                  +- Scan JDBCRelation((SELECT "IPP", "Code établissement", "Lib établissement", "Date prélévement", "Code examen Biologie", "Libellé  examen Biologie", "Résultat (numérique)", "Unite", "Code médecin", "Nom médecin", "Prénom médecin", "Nom document biologie", "Nom complet document biologie", "Venue", "Borne basse", "Borne haute" FROM "public"."biologie_etb_lin") as x) [numPartitions=1]  (7)


(1) Scan csv 
Output [12]: [IPP#119558, Code établissement#119559, Lib établissement#119560, Code examen Biologie#119562, Libellé  examen Biologie#119563, Unite#119565, Code médecin#119566, Nom médecin#119567, Prénom médecin#119568, Nom document biologie#119569, Nom complet document biologie#119570, Venue#119571]
Batched: false
Location: InMemoryFileIndex [file:/data/input/depot/csv/tmp/BIOLOGIE_SAINT__19889/BIOLOGIE_Etab_STA.csv]
ReadSchema: struct<IPP:string,Code établissement:string,Lib établissement:string,Code examen Biologie:string,Libellé  examen Biologie:string,Unite:string,Code médecin:string,Nom médecin:string,Prénom médecin:string,Nom document biologie:string,Nom complet document biologie:string,Venue:string>

(2) Filter [codegen id : 1]
Input [12]: [IPP#119558, Code établissement#119559, Lib établissement#119560, Code examen Biologie#119562, Libellé  examen Biologie#119563, Unite#119565, Code médecin#119566, Nom médecin#119567, Prénom médecin#119568, Nom document biologie#119569, Nom complet document biologie#119570, Venue#119571]
Condition : (((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(IPP#119558)), ME)) THEN false ELSE Contains(str_remove_accent(upper(IPP#119558)), ME) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(Code établissement#119559)), ME)) THEN false ELSE Contains(str_remove_accent(upper(Code établissement#119559)), ME) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(Lib établissement#119560)), ME)) THEN false ELSE Contains(str_remove_accent(upper(Lib établissement#119560)), ME) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(Code examen Biologie#119562)), ME)) THEN false ELSE Contains(str_remove_accent(upper(Code examen Biologie#119562)), ME) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(Libellé  examen Biologie#119563)), ME)) THEN false ELSE Contains(str_remove_accent(upper(Libellé  examen Biologie#119563)), ME) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(Unite#119565)), ME)) THEN false ELSE Contains(str_remove_accent(upper(Unite#119565)), ME) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(Code médecin#119566)), ME)) THEN false ELSE Contains(str_remove_accent(upper(Code médecin#119566)), ME) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(Nom médecin#119567)), ME)) THEN false ELSE Contains(str_remove_accent(upper(Nom médecin#119567)), ME) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(Prénom médecin#119568)), ME)) THEN false ELSE Contains(str_remove_accent(upper(Prénom médecin#119568)), ME) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(Nom document biologie#119569)), ME)) THEN false ELSE Contains(str_remove_accent(upper(Nom document biologie#119569)), ME) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(Nom complet document biologie#119570)), ME)) THEN false ELSE Contains(str_remove_accent(upper(Nom complet document biologie#119570)), ME) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(Venue#119571)), ME)) THEN false ELSE Contains(str_remove_accent(upper(Venue#119571)), ME) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_create(CH St Agnès))), ME)) THEN false ELSE Contains(str_remove_accent(upper(str_create(CH St Agnès))), ME) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_extract_by_str(Code examen Biologie#119562, _, RIGHT))), ME)) THEN false ELSE Contains(str_remove_accent(upper(str_extract_by_str(Code examen Biologie#119562, _, RIGHT))), ME) END)

(3) Project [codegen id : 1]
Output: []
Input [12]: [IPP#119558, Code établissement#119559, Lib établissement#119560, Code examen Biologie#119562, Libellé  examen Biologie#119563, Unite#119565, Code médecin#119566, Nom médecin#119567, Prénom médecin#119568, Nom document biologie#119569, Nom complet document biologie#119570, Venue#119571]

(4) Scan csv 
Output [12]: [IPP#119723, Code établissement#119724, Lib établissement#119725, Code examen Biologie#119727, Libellé  examen Biologie#119728, Unite#119730, Code médecin#119731, Nom médecin#119732, Prénom médecin#119733, Nom document biologie#119734, Nom complet document biologie#119735, Venue#119736]
Batched: false
Location: InMemoryFileIndex [file:/data/input/depot/csv/execution/DD31E585_3541_4A5B_BCA8_52E9CD3FA16F/current/BIOLOGIE_Etab_STI.csv]
ReadSchema: struct<IPP:string,Code établissement:string,Lib établissement:string,Code examen Biologie:string,Libellé  examen Biologie:string,Unite:string,Code médecin:string,Nom médecin:string,Prénom médecin:string,Nom document biologie:string,Nom complet document biologie:string,Venue:string>

(5) Filter [codegen id : 2]
Input [12]: [IPP#119723, Code établissement#119724, Lib établissement#119725, Code examen Biologie#119727, Libellé  examen Biologie#119728, Unite#119730, Code médecin#119731, Nom médecin#119732, Prénom médecin#119733, Nom document biologie#119734, Nom complet document biologie#119735, Venue#119736]
Condition : (((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(IPP#119723)), ME)) THEN false ELSE Contains(str_remove_accent(upper(IPP#119723)), ME) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(Code établissement#119724)), ME)) THEN false ELSE Contains(str_remove_accent(upper(Code établissement#119724)), ME) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(Lib établissement#119725)), ME)) THEN false ELSE Contains(str_remove_accent(upper(Lib établissement#119725)), ME) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(Code examen Biologie#119727)), ME)) THEN false ELSE Contains(str_remove_accent(upper(Code examen Biologie#119727)), ME) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(Libellé  examen Biologie#119728)), ME)) THEN false ELSE Contains(str_remove_accent(upper(Libellé  examen Biologie#119728)), ME) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(Unite#119730)), ME)) THEN false ELSE Contains(str_remove_accent(upper(Unite#119730)), ME) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(Code médecin#119731)), ME)) THEN false ELSE Contains(str_remove_accent(upper(Code médecin#119731)), ME) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(Nom médecin#119732)), ME)) THEN false ELSE Contains(str_remove_accent(upper(Nom médecin#119732)), ME) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(Prénom médecin#119733)), ME)) THEN false ELSE Contains(str_remove_accent(upper(Prénom médecin#119733)), ME) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(Nom document biologie#119734)), ME)) THEN false ELSE Contains(str_remove_accent(upper(Nom document biologie#119734)), ME) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(Nom complet document biologie#119735)), ME)) THEN false ELSE Contains(str_remove_accent(upper(Nom complet document biologie#119735)), ME) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(Venue#119736)), ME)) THEN false ELSE Contains(str_remove_accent(upper(Venue#119736)), ME) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_create(CH Butel))), ME)) THEN false ELSE Contains(str_remove_accent(upper(str_create(CH Butel))), ME) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_extract_by_str(Code examen Biologie#119727, _, RIGHT))), ME)) THEN false ELSE Contains(str_remove_accent(upper(str_extract_by_str(Code examen Biologie#119727, _, RIGHT))), ME) END)

(6) Project [codegen id : 2]
Output: []
Input [12]: [IPP#119723, Code établissement#119724, Lib établissement#119725, Code examen Biologie#119727, Libellé  examen Biologie#119728, Unite#119730, Code médecin#119731, Nom médecin#119732, Prénom médecin#119733, Nom document biologie#119734, Nom complet document biologie#119735, Venue#119736]

(7) Scan JDBCRelation((SELECT "IPP", "Code établissement", "Lib établissement", "Date prélévement", "Code examen Biologie", "Libellé  examen Biologie", "Résultat (numérique)", "Unite", "Code médecin", "Nom médecin", "Prénom médecin", "Nom document biologie", "Nom complet document biologie", "Venue", "Borne basse", "Borne haute" FROM "public"."biologie_etb_lin") as x) [numPartitions=1]  [codegen id : 3]
Output [12]: [IPP#119888, Code établissement#119889, Lib établissement#119890, Code examen Biologie#119892, Libellé  examen Biologie#119893, Unite#119895, Code médecin#119896, Nom médecin#119897, Prénom médecin#119898, Nom document biologie#119899, Nom complet document biologie#119900, Venue#119901]
ReadSchema: struct<IPP:string,Code établissement:string,Lib établissement:string,Code examen Biologie:string,Libellé  examen Biologie:string,Unite:string,Code médecin:string,Nom médecin:string,Prénom médecin:string,Nom document biologie:string,Nom complet document biologie:string,Venue:string>

(8) Filter [codegen id : 3]
Input [12]: [IPP#119888, Code établissement#119889, Lib établissement#119890, Code examen Biologie#119892, Libellé  examen Biologie#119893, Unite#119895, Code médecin#119896, Nom médecin#119897, Prénom médecin#119898, Nom document biologie#119899, Nom complet document biologie#119900, Venue#119901]
Condition : (((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(IPP#119888)), ME)) THEN false ELSE Contains(str_remove_accent(upper(IPP#119888)), ME) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(Code établissement#119889)), ME)) THEN false ELSE Contains(str_remove_accent(upper(Code établissement#119889)), ME) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(Lib établissement#119890)), ME)) THEN false ELSE Contains(str_remove_accent(upper(Lib établissement#119890)), ME) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(Code examen Biologie#119892)), ME)) THEN false ELSE Contains(str_remove_accent(upper(Code examen Biologie#119892)), ME) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(Libellé  examen Biologie#119893)), ME)) THEN false ELSE Contains(str_remove_accent(upper(Libellé  examen Biologie#119893)), ME) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(Unite#119895)), ME)) THEN false ELSE Contains(str_remove_accent(upper(Unite#119895)), ME) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(Code médecin#119896)), ME)) THEN false ELSE Contains(str_remove_accent(upper(Code médecin#119896)), ME) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(Nom médecin#119897)), ME)) THEN false ELSE Contains(str_remove_accent(upper(Nom médecin#119897)), ME) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(Prénom médecin#119898)), ME)) THEN false ELSE Contains(str_remove_accent(upper(Prénom médecin#119898)), ME) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(Nom document biologie#119899)), ME)) THEN false ELSE Contains(str_remove_accent(upper(Nom document biologie#119899)), ME) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(Nom complet document biologie#119900)), ME)) THEN false ELSE Contains(str_remove_accent(upper(Nom complet document biologie#119900)), ME) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(Venue#119901)), ME)) THEN false ELSE Contains(str_remove_accent(upper(Venue#119901)), ME) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_create(Etb Linet))), ME)) THEN false ELSE Contains(str_remove_accent(upper(str_create(Etb Linet))), ME) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_extract_by_str(Code examen Biologie#119892, _, RIGHT))), ME)) THEN false ELSE Contains(str_remove_accent(upper(str_extract_by_str(Code examen Biologie#119892, _, RIGHT))), ME) END)

(9) Project [codegen id : 3]
Output: []
Input [12]: [IPP#119888, Code établissement#119889, Lib établissement#119890, Code examen Biologie#119892, Libellé  examen Biologie#119893, Unite#119895, Code médecin#119896, Nom médecin#119897, Prénom médecin#119898, Nom document biologie#119899, Nom complet document biologie#119900, Venue#119901]

(10) Union

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

(12) Exchange
Input [1]: [count#120229L]
Arguments: SinglePartition, ENSURE_REQUIREMENTS, [plan_id=9315]

(13) ShuffleQueryStage
Output [1]: [count#120229L]
Arguments: 0

(14) HashAggregate [codegen id : 5]
Input [1]: [count#120229L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#120179L]
Results [1]: [count(1)#120179L AS COL_e69b0432-2035-4fce-8dcd-3d4d13a8f2b0#120181L]

(15) Filter
Input [12]: [IPP#119558, Code établissement#119559, Lib établissement#119560, Code examen Biologie#119562, Libellé  examen Biologie#119563, Unite#119565, Code médecin#119566, Nom médecin#119567, Prénom médecin#119568, Nom document biologie#119569, Nom complet document biologie#119570, Venue#119571]
Condition : (((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(IPP#119558)), ME)) THEN false ELSE Contains(str_remove_accent(upper(IPP#119558)), ME) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(Code établissement#119559)), ME)) THEN false ELSE Contains(str_remove_accent(upper(Code établissement#119559)), ME) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(Lib établissement#119560)), ME)) THEN false ELSE Contains(str_remove_accent(upper(Lib établissement#119560)), ME) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(Code examen Biologie#119562)), ME)) THEN false ELSE Contains(str_remove_accent(upper(Code examen Biologie#119562)), ME) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(Libellé  examen Biologie#119563)), ME)) THEN false ELSE Contains(str_remove_accent(upper(Libellé  examen Biologie#119563)), ME) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(Unite#119565)), ME)) THEN false ELSE Contains(str_remove_accent(upper(Unite#119565)), ME) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(Code médecin#119566)), ME)) THEN false ELSE Contains(str_remove_accent(upper(Code médecin#119566)), ME) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(Nom médecin#119567)), ME)) THEN false ELSE Contains(str_remove_accent(upper(Nom médecin#119567)), ME) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(Prénom médecin#119568)), ME)) THEN false ELSE Contains(str_remove_accent(upper(Prénom médecin#119568)), ME) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(Nom document biologie#119569)), ME)) THEN false ELSE Contains(str_remove_accent(upper(Nom document biologie#119569)), ME) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(Nom complet document biologie#119570)), ME)) THEN false ELSE Contains(str_remove_accent(upper(Nom complet document biologie#119570)), ME) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(Venue#119571)), ME)) THEN false ELSE Contains(str_remove_accent(upper(Venue#119571)), ME) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_create(CH St Agnès))), ME)) THEN false ELSE Contains(str_remove_accent(upper(str_create(CH St Agnès))), ME) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_extract_by_str(Code examen Biologie#119562, _, RIGHT))), ME)) THEN false ELSE Contains(str_remove_accent(upper(str_extract_by_str(Code examen Biologie#119562, _, RIGHT))), ME) END)

(16) Project
Output: []
Input [12]: [IPP#119558, Code établissement#119559, Lib établissement#119560, Code examen Biologie#119562, Libellé  examen Biologie#119563, Unite#119565, Code médecin#119566, Nom médecin#119567, Prénom médecin#119568, Nom document biologie#119569, Nom complet document biologie#119570, Venue#119571]

(17) Filter
Input [12]: [IPP#119723, Code établissement#119724, Lib établissement#119725, Code examen Biologie#119727, Libellé  examen Biologie#119728, Unite#119730, Code médecin#119731, Nom médecin#119732, Prénom médecin#119733, Nom document biologie#119734, Nom complet document biologie#119735, Venue#119736]
Condition : (((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(IPP#119723)), ME)) THEN false ELSE Contains(str_remove_accent(upper(IPP#119723)), ME) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(Code établissement#119724)), ME)) THEN false ELSE Contains(str_remove_accent(upper(Code établissement#119724)), ME) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(Lib établissement#119725)), ME)) THEN false ELSE Contains(str_remove_accent(upper(Lib établissement#119725)), ME) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(Code examen Biologie#119727)), ME)) THEN false ELSE Contains(str_remove_accent(upper(Code examen Biologie#119727)), ME) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(Libellé  examen Biologie#119728)), ME)) THEN false ELSE Contains(str_remove_accent(upper(Libellé  examen Biologie#119728)), ME) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(Unite#119730)), ME)) THEN false ELSE Contains(str_remove_accent(upper(Unite#119730)), ME) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(Code médecin#119731)), ME)) THEN false ELSE Contains(str_remove_accent(upper(Code médecin#119731)), ME) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(Nom médecin#119732)), ME)) THEN false ELSE Contains(str_remove_accent(upper(Nom médecin#119732)), ME) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(Prénom médecin#119733)), ME)) THEN false ELSE Contains(str_remove_accent(upper(Prénom médecin#119733)), ME) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(Nom document biologie#119734)), ME)) THEN false ELSE Contains(str_remove_accent(upper(Nom document biologie#119734)), ME) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(Nom complet document biologie#119735)), ME)) THEN false ELSE Contains(str_remove_accent(upper(Nom complet document biologie#119735)), ME) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(Venue#119736)), ME)) THEN false ELSE Contains(str_remove_accent(upper(Venue#119736)), ME) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_create(CH Butel))), ME)) THEN false ELSE Contains(str_remove_accent(upper(str_create(CH Butel))), ME) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_extract_by_str(Code examen Biologie#119727, _, RIGHT))), ME)) THEN false ELSE Contains(str_remove_accent(upper(str_extract_by_str(Code examen Biologie#119727, _, RIGHT))), ME) END)

(18) Project
Output: []
Input [12]: [IPP#119723, Code établissement#119724, Lib établissement#119725, Code examen Biologie#119727, Libellé  examen Biologie#119728, Unite#119730, Code médecin#119731, Nom médecin#119732, Prénom médecin#119733, Nom document biologie#119734, Nom complet document biologie#119735, Venue#119736]

(19) Union

(20) HashAggregate
Input: []
Keys: []
Functions [1]: [partial_count(1)]
Aggregate Attributes [1]: [count#120228L]
Results [1]: [count#120229L]

(21) Exchange
Input [1]: [count#120229L]
Arguments: SinglePartition, ENSURE_REQUIREMENTS, [plan_id=9284]

(22) HashAggregate
Input [1]: [count#120229L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#120179L]
Results [1]: [count(1)#120179L AS COL_e69b0432-2035-4fce-8dcd-3d4d13a8f2b0#120181L]

(23) AdaptiveSparkPlan
Output [1]: [COL_e69b0432-2035-4fce-8dcd-3d4d13a8f2b0#120181L]
Arguments: isFinalPlan=true

SQL / DataFrame Properties

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