hdh-spark-job - Details for Query 1425

Submitted Time: 2026/10/23 13:29:11
Duration: 0.6 s
Succeeded Jobs: 1418 1420

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 (4)\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: 2 local merged chunks fetched: 0 shuffle write time total (min, med, max (stageId: taskId)) 0 ms (0 ms, 0 ms, 0 ms (stage 2058.0: task 1797)) 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: 2 local bytes read: 118.0 B fetch wait time: 0 ms remote bytes read: 0.0 B merged fetch fallback count: 0 local blocks read: 2 remote merged chunks fetched: 0 remote blocks read: 0 data size total (min, med, max (stageId: taskId)) 32.0 B (16.0 B, 16.0 B, 16.0 B (stage 2058.0: task 1797)) 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)) 118.0 B (59.0 B, 59.0 B, 59.0 B (stage 2058.0: task 1797))"]; subgraph cluster4 { isCluster="true"; label="WholeStageCodegen (3)\n \nduration: total (min, med, max (stageId: taskId))\n37 ms (14 ms, 23 ms, 23 ms (stage 2058.0: task 1796))"; 5 [labelType="html" label="HashAggregate time in aggregation build total (min, med, max (stageId: taskId)) 36 ms (14 ms, 22 ms, 22 ms (stage 2058.0: task 1796)) number of output rows: 2"]; } 6 [labelType="html" label=" Union "]; subgraph cluster7 { isCluster="true"; label="WholeStageCodegen (1)\n \nduration: 22 ms"; 8 [labelType="html" label=" Project "]; 9 [labelType="html" label="Filter number of output rows: 3"]; 10 [labelType="html" label="Scan JDBCRelation((SELECT \"xa_codexa\", \"xa_lib30\", \"xa_libuti\", \"xa_typexa\", \"xa_contra\", \"xa_durava\", \"xa_durpen\", \"xa_durapr\", \"xa_durtot\", \"xa_durmed\", \"xa_protoc\", \"xa_datmaj\", \"xa_coduti\", \"xa_codpro\", \"xa_coulstd\", \"xa_couleur\", \"xa_flmedobl\", \"xa_flatsobl\", \"xa_flvalplanif\", \"xa_flvalaccueil\", \"xa_nivvcr\", \"xa_flrtcclq\", \"xa_fllabochaud\", \"xa_datede\", \"xa_datefi\", \"xa_flgrpjour\", \"xa_primai\", \"xa_codpros\", \"xa_codconv\", \"xa_later\", \"xa_incidence\", \"xa_position\", \"xa_flgrve\", \"xa_flexainj\", \"xa_contrapat\", \"xa_flprore\", \"xa_flcacheinet\", \"xa_flnocot\", \"xa_codadm\", \"xa_flgrvi\", \"xa_reganas\", \"xa_flrecist\", \"xa_flnocr\", \"xa_icd\", \"xa_type_icd\", \"xa_flrecist_ec\", \"xa_codloinc\" FROM \"xplore\".\"h_examen\") as x) [numPartitions=1] number of output rows: 253"]; } subgraph cluster11 { isCluster="true"; label="WholeStageCodegen (2)\n \nduration: 14 ms"; 12 [labelType="html" label=" Project "]; 13 [labelType="html" label="Filter number of output rows: 3"]; 14 [labelType="html" label="Scan JDBCRelation((SELECT \"xa_codexa\", \"xa_lib30\", \"xa_libuti\", \"xa_typexa\", \"xa_contra\", \"xa_durava\", \"xa_durpen\", \"xa_durapr\", \"xa_durtot\", \"xa_durmed\", \"xa_protoc\", \"xa_datmaj\", \"xa_coduti\", \"xa_codpro\", \"xa_coulstd\", \"xa_couleur\", \"xa_flmedobl\", \"xa_flatsobl\", \"xa_flvalplanif\", \"xa_flvalaccueil\", \"xa_nivvcr\", \"xa_flrtcclq\", \"xa_fllabochaud\", \"xa_datede\", \"xa_datefi\", \"xa_flgrpjour\", \"xa_primai\", \"xa_codpros\", \"xa_codconv\", \"xa_later\", \"xa_incidence\", \"xa_position\", \"xa_flgrve\", \"xa_flexainj\", \"xa_contrapat\", \"xa_flprore\", \"xa_flcacheinet\", \"xa_flnocot\", \"xa_codadm\", \"xa_flgrvi\", \"xa_reganas\", \"xa_flrecist\", \"xa_flnocr\", \"xa_icd\", \"xa_type_icd\", \"xa_flrecist_ec\", \"xa_codloinc\" FROM \"xplore2\".\"h_examen\") as x) [numPartitions=1] number of output rows: 253"]; } 2->0; 3->2; 5->3; 6->5; 8->6; 9->8; 10->9; 12->6; 13->12; 14->13; }

AdaptiveSparkPlan isFinalPlan=true

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

WholeStageCodegen (4)

Exchange SinglePartition, ENSURE_REQUIREMENTS, [plan_id=38706]

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

WholeStageCodegen (3)

Union

Project

Filter (((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(xa_codexa#716216)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_codexa#716216)), MAIN) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_lib30#716217)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_lib30#716217)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_libuti#716218)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_libuti#716218)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_typexa#716219)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_typexa#716219)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_contra#716220)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_contra#716220)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_durava#716221)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_durava#716221)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_durpen#716222)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_durpen#716222)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_durapr#716223)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_durapr#716223)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_durtot#716224)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_durtot#716224)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_durmed#716225)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_durmed#716225)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_protoc#716226)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_protoc#716226)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_datmaj#716227)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_datmaj#716227)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_coduti#716228)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_coduti#716228)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_codpro#716229)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_codpro#716229)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_coulstd#716230)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_coulstd#716230)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_couleur#716231)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_couleur#716231)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flmedobl#716232)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flmedobl#716232)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flatsobl#716233)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flatsobl#716233)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flvalplanif#716234)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flvalplanif#716234)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flvalaccueil#716235)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flvalaccueil#716235)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_nivvcr#716236)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_nivvcr#716236)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flrtcclq#716237)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flrtcclq#716237)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_fllabochaud#716238)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_fllabochaud#716238)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_datede#716239)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_datede#716239)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_datefi#716240)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_datefi#716240)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flgrpjour#716241)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flgrpjour#716241)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_primai#716242)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_primai#716242)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_codpros#716243)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_codpros#716243)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_codconv#716244)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_codconv#716244)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_later#716245)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_later#716245)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_incidence#716246)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_incidence#716246)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_position#716247)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_position#716247)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flgrve#716248)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flgrve#716248)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flexainj#716249)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flexainj#716249)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_contrapat#716250)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_contrapat#716250)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flprore#716251)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flprore#716251)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flcacheinet#716252)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flcacheinet#716252)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flnocot#716253)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flnocot#716253)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_codadm#716254)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_codadm#716254)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flgrvi#716255)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flgrvi#716255)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_reganas#716256)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_reganas#716256)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flrecist#716257)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flrecist#716257)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flnocr#716258)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flnocr#716258)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_icd#716259)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_icd#716259)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_type_icd#716260)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_type_icd#716260)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flrecist_ec#716261)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flrecist_ec#716261)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_codloinc#716262)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_codloinc#716262)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_create(Cab_A))), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(str_create(Cab_A))), MAIN) END)

Scan JDBCRelation((SELECT "xa_codexa", "xa_lib30", "xa_libuti", "xa_typexa", "xa_contra", "xa_durava", "xa_durpen", "xa_durapr", "xa_durtot", "xa_durmed", "xa_protoc", "xa_datmaj", "xa_coduti", "xa_codpro", "xa_coulstd", "xa_couleur", "xa_flmedobl", "xa_flatsobl", "xa_flvalplanif", "xa_flvalaccueil", "xa_nivvcr", "xa_flrtcclq", "xa_fllabochaud", "xa_datede", "xa_datefi", "xa_flgrpjour", "xa_primai", "xa_codpros", "xa_codconv", "xa_later", "xa_incidence", "xa_position", "xa_flgrve", "xa_flexainj", "xa_contrapat", "xa_flprore", "xa_flcacheinet", "xa_flnocot", "xa_codadm", "xa_flgrvi", "xa_reganas", "xa_flrecist", "xa_flnocr", "xa_icd", "xa_type_icd", "xa_flrecist_ec", "xa_codloinc" FROM "xplore"."h_examen") as x) [numPartitions=1] [xa_codexa#716216,xa_lib30#716217,xa_libuti#716218,xa_typexa#716219,xa_contra#716220,xa_durava#716221,xa_durpen#716222,xa_durapr#716223,xa_durtot#716224,xa_durmed#716225,xa_protoc#716226,xa_datmaj#716227,xa_coduti#716228,xa_codpro#716229,xa_coulstd#716230,xa_couleur#716231,xa_flmedobl#716232,xa_flatsobl#716233,xa_flvalplanif#716234,xa_flvalaccueil#716235,xa_nivvcr#716236,xa_flrtcclq#716237,xa_fllabochaud#716238,xa_datede#716239,... 23 more fields] PushedFilters: [], ReadSchema: struct<xa_codexa:string,xa_lib30:string,xa_libuti:string,xa_typexa:string,xa_contra:string,xa_dur...

WholeStageCodegen (1)

Project

Filter (((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(xa_codexa#716848)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_codexa#716848)), MAIN) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_lib30#716849)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_lib30#716849)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_libuti#716850)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_libuti#716850)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_typexa#716851)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_typexa#716851)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_contra#716852)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_contra#716852)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_durava#716853)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_durava#716853)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_durpen#716854)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_durpen#716854)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_durapr#716855)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_durapr#716855)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_durtot#716856)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_durtot#716856)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_durmed#716857)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_durmed#716857)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_protoc#716858)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_protoc#716858)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_datmaj#716859)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_datmaj#716859)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_coduti#716860)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_coduti#716860)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_codpro#716861)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_codpro#716861)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_coulstd#716862)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_coulstd#716862)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_couleur#716863)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_couleur#716863)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flmedobl#716864)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flmedobl#716864)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flatsobl#716865)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flatsobl#716865)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flvalplanif#716866)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flvalplanif#716866)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flvalaccueil#716867)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flvalaccueil#716867)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_nivvcr#716868)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_nivvcr#716868)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flrtcclq#716869)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flrtcclq#716869)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_fllabochaud#716870)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_fllabochaud#716870)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_datede#716871)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_datede#716871)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_datefi#716872)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_datefi#716872)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flgrpjour#716873)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flgrpjour#716873)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_primai#716874)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_primai#716874)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_codpros#716875)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_codpros#716875)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_codconv#716876)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_codconv#716876)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_later#716877)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_later#716877)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_incidence#716878)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_incidence#716878)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_position#716879)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_position#716879)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flgrve#716880)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flgrve#716880)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flexainj#716881)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flexainj#716881)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_contrapat#716882)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_contrapat#716882)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flprore#716883)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flprore#716883)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flcacheinet#716884)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flcacheinet#716884)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flnocot#716885)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flnocot#716885)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_codadm#716886)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_codadm#716886)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flgrvi#716887)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flgrvi#716887)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_reganas#716888)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_reganas#716888)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flrecist#716889)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flrecist#716889)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flnocr#716890)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flnocr#716890)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_icd#716891)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_icd#716891)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_type_icd#716892)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_type_icd#716892)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flrecist_ec#716893)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flrecist_ec#716893)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_codloinc#716894)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_codloinc#716894)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_create(Cab_B))), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(str_create(Cab_B))), MAIN) END)

Scan JDBCRelation((SELECT "xa_codexa", "xa_lib30", "xa_libuti", "xa_typexa", "xa_contra", "xa_durava", "xa_durpen", "xa_durapr", "xa_durtot", "xa_durmed", "xa_protoc", "xa_datmaj", "xa_coduti", "xa_codpro", "xa_coulstd", "xa_couleur", "xa_flmedobl", "xa_flatsobl", "xa_flvalplanif", "xa_flvalaccueil", "xa_nivvcr", "xa_flrtcclq", "xa_fllabochaud", "xa_datede", "xa_datefi", "xa_flgrpjour", "xa_primai", "xa_codpros", "xa_codconv", "xa_later", "xa_incidence", "xa_position", "xa_flgrve", "xa_flexainj", "xa_contrapat", "xa_flprore", "xa_flcacheinet", "xa_flnocot", "xa_codadm", "xa_flgrvi", "xa_reganas", "xa_flrecist", "xa_flnocr", "xa_icd", "xa_type_icd", "xa_flrecist_ec", "xa_codloinc" FROM "xplore2"."h_examen") as x) [numPartitions=1] [xa_codexa#716848,xa_lib30#716849,xa_libuti#716850,xa_typexa#716851,xa_contra#716852,xa_durava#716853,xa_durpen#716854,xa_durapr#716855,xa_durtot#716856,xa_durmed#716857,xa_protoc#716858,xa_datmaj#716859,xa_coduti#716860,xa_codpro#716861,xa_coulstd#716862,xa_couleur#716863,xa_flmedobl#716864,xa_flatsobl#716865,xa_flvalplanif#716866,xa_flvalaccueil#716867,xa_nivvcr#716868,xa_flrtcclq#716869,xa_fllabochaud#716870,xa_datede#716871,... 23 more fields] PushedFilters: [], ReadSchema: struct<xa_codexa:string,xa_lib30:string,xa_libuti:string,xa_typexa:string,xa_contra:string,xa_dur...

WholeStageCodegen (2)

Details

== Physical Plan ==
AdaptiveSparkPlan (16)
+- == Final Plan ==
   * HashAggregate (11)
   +- ShuffleQueryStage (10), Statistics(sizeInBytes=32.0 B, rowCount=2)
      +- Exchange (9)
         +- * HashAggregate (8)
            +- Union (7)
               :- * Project (3)
               :  +- * Filter (2)
               :     +- * Scan JDBCRelation((SELECT "xa_codexa", "xa_lib30", "xa_libuti", "xa_typexa", "xa_contra", "xa_durava", "xa_durpen", "xa_durapr", "xa_durtot", "xa_durmed", "xa_protoc", "xa_datmaj", "xa_coduti", "xa_codpro", "xa_coulstd", "xa_couleur", "xa_flmedobl", "xa_flatsobl", "xa_flvalplanif", "xa_flvalaccueil", "xa_nivvcr", "xa_flrtcclq", "xa_fllabochaud", "xa_datede", "xa_datefi", "xa_flgrpjour", "xa_primai", "xa_codpros", "xa_codconv", "xa_later", "xa_incidence", "xa_position", "xa_flgrve", "xa_flexainj", "xa_contrapat", "xa_flprore", "xa_flcacheinet", "xa_flnocot", "xa_codadm", "xa_flgrvi", "xa_reganas", "xa_flrecist", "xa_flnocr", "xa_icd", "xa_type_icd", "xa_flrecist_ec", "xa_codloinc" FROM "xplore"."h_examen") as x) [numPartitions=1]  (1)
               +- * Project (6)
                  +- * Filter (5)
                     +- * Scan JDBCRelation((SELECT "xa_codexa", "xa_lib30", "xa_libuti", "xa_typexa", "xa_contra", "xa_durava", "xa_durpen", "xa_durapr", "xa_durtot", "xa_durmed", "xa_protoc", "xa_datmaj", "xa_coduti", "xa_codpro", "xa_coulstd", "xa_couleur", "xa_flmedobl", "xa_flatsobl", "xa_flvalplanif", "xa_flvalaccueil", "xa_nivvcr", "xa_flrtcclq", "xa_fllabochaud", "xa_datede", "xa_datefi", "xa_flgrpjour", "xa_primai", "xa_codpros", "xa_codconv", "xa_later", "xa_incidence", "xa_position", "xa_flgrve", "xa_flexainj", "xa_contrapat", "xa_flprore", "xa_flcacheinet", "xa_flnocot", "xa_codadm", "xa_flgrvi", "xa_reganas", "xa_flrecist", "xa_flnocr", "xa_icd", "xa_type_icd", "xa_flrecist_ec", "xa_codloinc" FROM "xplore2"."h_examen") as x) [numPartitions=1]  (4)
+- == Initial Plan ==
   HashAggregate (15)
   +- Exchange (14)
      +- HashAggregate (13)
         +- Union (12)
            :- Project (3)
            :  +- Filter (2)
            :     +- Scan JDBCRelation((SELECT "xa_codexa", "xa_lib30", "xa_libuti", "xa_typexa", "xa_contra", "xa_durava", "xa_durpen", "xa_durapr", "xa_durtot", "xa_durmed", "xa_protoc", "xa_datmaj", "xa_coduti", "xa_codpro", "xa_coulstd", "xa_couleur", "xa_flmedobl", "xa_flatsobl", "xa_flvalplanif", "xa_flvalaccueil", "xa_nivvcr", "xa_flrtcclq", "xa_fllabochaud", "xa_datede", "xa_datefi", "xa_flgrpjour", "xa_primai", "xa_codpros", "xa_codconv", "xa_later", "xa_incidence", "xa_position", "xa_flgrve", "xa_flexainj", "xa_contrapat", "xa_flprore", "xa_flcacheinet", "xa_flnocot", "xa_codadm", "xa_flgrvi", "xa_reganas", "xa_flrecist", "xa_flnocr", "xa_icd", "xa_type_icd", "xa_flrecist_ec", "xa_codloinc" FROM "xplore"."h_examen") as x) [numPartitions=1]  (1)
            +- Project (6)
               +- Filter (5)
                  +- Scan JDBCRelation((SELECT "xa_codexa", "xa_lib30", "xa_libuti", "xa_typexa", "xa_contra", "xa_durava", "xa_durpen", "xa_durapr", "xa_durtot", "xa_durmed", "xa_protoc", "xa_datmaj", "xa_coduti", "xa_codpro", "xa_coulstd", "xa_couleur", "xa_flmedobl", "xa_flatsobl", "xa_flvalplanif", "xa_flvalaccueil", "xa_nivvcr", "xa_flrtcclq", "xa_fllabochaud", "xa_datede", "xa_datefi", "xa_flgrpjour", "xa_primai", "xa_codpros", "xa_codconv", "xa_later", "xa_incidence", "xa_position", "xa_flgrve", "xa_flexainj", "xa_contrapat", "xa_flprore", "xa_flcacheinet", "xa_flnocot", "xa_codadm", "xa_flgrvi", "xa_reganas", "xa_flrecist", "xa_flnocr", "xa_icd", "xa_type_icd", "xa_flrecist_ec", "xa_codloinc" FROM "xplore2"."h_examen") as x) [numPartitions=1]  (4)


(1) Scan JDBCRelation((SELECT "xa_codexa", "xa_lib30", "xa_libuti", "xa_typexa", "xa_contra", "xa_durava", "xa_durpen", "xa_durapr", "xa_durtot", "xa_durmed", "xa_protoc", "xa_datmaj", "xa_coduti", "xa_codpro", "xa_coulstd", "xa_couleur", "xa_flmedobl", "xa_flatsobl", "xa_flvalplanif", "xa_flvalaccueil", "xa_nivvcr", "xa_flrtcclq", "xa_fllabochaud", "xa_datede", "xa_datefi", "xa_flgrpjour", "xa_primai", "xa_codpros", "xa_codconv", "xa_later", "xa_incidence", "xa_position", "xa_flgrve", "xa_flexainj", "xa_contrapat", "xa_flprore", "xa_flcacheinet", "xa_flnocot", "xa_codadm", "xa_flgrvi", "xa_reganas", "xa_flrecist", "xa_flnocr", "xa_icd", "xa_type_icd", "xa_flrecist_ec", "xa_codloinc" FROM "xplore"."h_examen") as x) [numPartitions=1]  [codegen id : 1]
Output [47]: [xa_codexa#716216, xa_lib30#716217, xa_libuti#716218, xa_typexa#716219, xa_contra#716220, xa_durava#716221, xa_durpen#716222, xa_durapr#716223, xa_durtot#716224, xa_durmed#716225, xa_protoc#716226, xa_datmaj#716227, xa_coduti#716228, xa_codpro#716229, xa_coulstd#716230, xa_couleur#716231, xa_flmedobl#716232, xa_flatsobl#716233, xa_flvalplanif#716234, xa_flvalaccueil#716235, xa_nivvcr#716236, xa_flrtcclq#716237, xa_fllabochaud#716238, xa_datede#716239, xa_datefi#716240, xa_flgrpjour#716241, xa_primai#716242, xa_codpros#716243, xa_codconv#716244, xa_later#716245, xa_incidence#716246, xa_position#716247, xa_flgrve#716248, xa_flexainj#716249, xa_contrapat#716250, xa_flprore#716251, xa_flcacheinet#716252, xa_flnocot#716253, xa_codadm#716254, xa_flgrvi#716255, xa_reganas#716256, xa_flrecist#716257, xa_flnocr#716258, xa_icd#716259, xa_type_icd#716260, xa_flrecist_ec#716261, xa_codloinc#716262]
ReadSchema: struct<xa_codexa:string,xa_lib30:string,xa_libuti:string,xa_typexa:string,xa_contra:string,xa_durava:string,xa_durpen:string,xa_durapr:string,xa_durtot:string,xa_durmed:string,xa_protoc:string,xa_datmaj:string,xa_coduti:string,xa_codpro:string,xa_coulstd:string,xa_couleur:string,xa_flmedobl:string,xa_flatsobl:string,xa_flvalplanif:string,xa_flvalaccueil:string,xa_nivvcr:string,xa_flrtcclq:string,xa_fllabochaud:string,xa_datede:string,xa_datefi:string,xa_flgrpjour:string,xa_primai:string,xa_codpros:string,xa_codconv:string,xa_later:string,xa_incidence:string,xa_position:string,xa_flgrve:string,xa_flexainj:string,xa_contrapat:string,xa_flprore:string,xa_flcacheinet:string,xa_flnocot:string,xa_codadm:string,xa_flgrvi:string,xa_reganas:string,xa_flrecist:string,xa_flnocr:string,xa_icd:string,xa_type_icd:string,xa_flrecist_ec:string,xa_codloinc:string>

(2) Filter [codegen id : 1]
Input [47]: [xa_codexa#716216, xa_lib30#716217, xa_libuti#716218, xa_typexa#716219, xa_contra#716220, xa_durava#716221, xa_durpen#716222, xa_durapr#716223, xa_durtot#716224, xa_durmed#716225, xa_protoc#716226, xa_datmaj#716227, xa_coduti#716228, xa_codpro#716229, xa_coulstd#716230, xa_couleur#716231, xa_flmedobl#716232, xa_flatsobl#716233, xa_flvalplanif#716234, xa_flvalaccueil#716235, xa_nivvcr#716236, xa_flrtcclq#716237, xa_fllabochaud#716238, xa_datede#716239, xa_datefi#716240, xa_flgrpjour#716241, xa_primai#716242, xa_codpros#716243, xa_codconv#716244, xa_later#716245, xa_incidence#716246, xa_position#716247, xa_flgrve#716248, xa_flexainj#716249, xa_contrapat#716250, xa_flprore#716251, xa_flcacheinet#716252, xa_flnocot#716253, xa_codadm#716254, xa_flgrvi#716255, xa_reganas#716256, xa_flrecist#716257, xa_flnocr#716258, xa_icd#716259, xa_type_icd#716260, xa_flrecist_ec#716261, xa_codloinc#716262]
Condition : (((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(xa_codexa#716216)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_codexa#716216)), MAIN) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_lib30#716217)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_lib30#716217)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_libuti#716218)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_libuti#716218)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_typexa#716219)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_typexa#716219)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_contra#716220)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_contra#716220)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_durava#716221)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_durava#716221)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_durpen#716222)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_durpen#716222)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_durapr#716223)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_durapr#716223)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_durtot#716224)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_durtot#716224)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_durmed#716225)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_durmed#716225)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_protoc#716226)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_protoc#716226)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_datmaj#716227)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_datmaj#716227)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_coduti#716228)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_coduti#716228)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_codpro#716229)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_codpro#716229)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_coulstd#716230)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_coulstd#716230)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_couleur#716231)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_couleur#716231)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flmedobl#716232)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flmedobl#716232)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flatsobl#716233)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flatsobl#716233)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flvalplanif#716234)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flvalplanif#716234)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flvalaccueil#716235)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flvalaccueil#716235)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_nivvcr#716236)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_nivvcr#716236)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flrtcclq#716237)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flrtcclq#716237)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_fllabochaud#716238)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_fllabochaud#716238)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_datede#716239)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_datede#716239)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_datefi#716240)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_datefi#716240)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flgrpjour#716241)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flgrpjour#716241)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_primai#716242)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_primai#716242)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_codpros#716243)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_codpros#716243)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_codconv#716244)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_codconv#716244)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_later#716245)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_later#716245)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_incidence#716246)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_incidence#716246)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_position#716247)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_position#716247)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flgrve#716248)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flgrve#716248)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flexainj#716249)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flexainj#716249)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_contrapat#716250)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_contrapat#716250)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flprore#716251)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flprore#716251)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flcacheinet#716252)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flcacheinet#716252)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flnocot#716253)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flnocot#716253)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_codadm#716254)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_codadm#716254)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flgrvi#716255)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flgrvi#716255)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_reganas#716256)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_reganas#716256)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flrecist#716257)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flrecist#716257)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flnocr#716258)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flnocr#716258)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_icd#716259)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_icd#716259)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_type_icd#716260)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_type_icd#716260)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flrecist_ec#716261)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flrecist_ec#716261)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_codloinc#716262)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_codloinc#716262)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_create(Cab_A))), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(str_create(Cab_A))), MAIN) END)

(3) Project [codegen id : 1]
Output: []
Input [47]: [xa_codexa#716216, xa_lib30#716217, xa_libuti#716218, xa_typexa#716219, xa_contra#716220, xa_durava#716221, xa_durpen#716222, xa_durapr#716223, xa_durtot#716224, xa_durmed#716225, xa_protoc#716226, xa_datmaj#716227, xa_coduti#716228, xa_codpro#716229, xa_coulstd#716230, xa_couleur#716231, xa_flmedobl#716232, xa_flatsobl#716233, xa_flvalplanif#716234, xa_flvalaccueil#716235, xa_nivvcr#716236, xa_flrtcclq#716237, xa_fllabochaud#716238, xa_datede#716239, xa_datefi#716240, xa_flgrpjour#716241, xa_primai#716242, xa_codpros#716243, xa_codconv#716244, xa_later#716245, xa_incidence#716246, xa_position#716247, xa_flgrve#716248, xa_flexainj#716249, xa_contrapat#716250, xa_flprore#716251, xa_flcacheinet#716252, xa_flnocot#716253, xa_codadm#716254, xa_flgrvi#716255, xa_reganas#716256, xa_flrecist#716257, xa_flnocr#716258, xa_icd#716259, xa_type_icd#716260, xa_flrecist_ec#716261, xa_codloinc#716262]

(4) Scan JDBCRelation((SELECT "xa_codexa", "xa_lib30", "xa_libuti", "xa_typexa", "xa_contra", "xa_durava", "xa_durpen", "xa_durapr", "xa_durtot", "xa_durmed", "xa_protoc", "xa_datmaj", "xa_coduti", "xa_codpro", "xa_coulstd", "xa_couleur", "xa_flmedobl", "xa_flatsobl", "xa_flvalplanif", "xa_flvalaccueil", "xa_nivvcr", "xa_flrtcclq", "xa_fllabochaud", "xa_datede", "xa_datefi", "xa_flgrpjour", "xa_primai", "xa_codpros", "xa_codconv", "xa_later", "xa_incidence", "xa_position", "xa_flgrve", "xa_flexainj", "xa_contrapat", "xa_flprore", "xa_flcacheinet", "xa_flnocot", "xa_codadm", "xa_flgrvi", "xa_reganas", "xa_flrecist", "xa_flnocr", "xa_icd", "xa_type_icd", "xa_flrecist_ec", "xa_codloinc" FROM "xplore2"."h_examen") as x) [numPartitions=1]  [codegen id : 2]
Output [47]: [xa_codexa#716848, xa_lib30#716849, xa_libuti#716850, xa_typexa#716851, xa_contra#716852, xa_durava#716853, xa_durpen#716854, xa_durapr#716855, xa_durtot#716856, xa_durmed#716857, xa_protoc#716858, xa_datmaj#716859, xa_coduti#716860, xa_codpro#716861, xa_coulstd#716862, xa_couleur#716863, xa_flmedobl#716864, xa_flatsobl#716865, xa_flvalplanif#716866, xa_flvalaccueil#716867, xa_nivvcr#716868, xa_flrtcclq#716869, xa_fllabochaud#716870, xa_datede#716871, xa_datefi#716872, xa_flgrpjour#716873, xa_primai#716874, xa_codpros#716875, xa_codconv#716876, xa_later#716877, xa_incidence#716878, xa_position#716879, xa_flgrve#716880, xa_flexainj#716881, xa_contrapat#716882, xa_flprore#716883, xa_flcacheinet#716884, xa_flnocot#716885, xa_codadm#716886, xa_flgrvi#716887, xa_reganas#716888, xa_flrecist#716889, xa_flnocr#716890, xa_icd#716891, xa_type_icd#716892, xa_flrecist_ec#716893, xa_codloinc#716894]
ReadSchema: struct<xa_codexa:string,xa_lib30:string,xa_libuti:string,xa_typexa:string,xa_contra:string,xa_durava:string,xa_durpen:string,xa_durapr:string,xa_durtot:string,xa_durmed:string,xa_protoc:string,xa_datmaj:string,xa_coduti:string,xa_codpro:string,xa_coulstd:string,xa_couleur:string,xa_flmedobl:string,xa_flatsobl:string,xa_flvalplanif:string,xa_flvalaccueil:string,xa_nivvcr:string,xa_flrtcclq:string,xa_fllabochaud:string,xa_datede:string,xa_datefi:string,xa_flgrpjour:string,xa_primai:string,xa_codpros:string,xa_codconv:string,xa_later:string,xa_incidence:string,xa_position:string,xa_flgrve:string,xa_flexainj:string,xa_contrapat:string,xa_flprore:string,xa_flcacheinet:string,xa_flnocot:string,xa_codadm:string,xa_flgrvi:string,xa_reganas:string,xa_flrecist:string,xa_flnocr:string,xa_icd:string,xa_type_icd:string,xa_flrecist_ec:string,xa_codloinc:string>

(5) Filter [codegen id : 2]
Input [47]: [xa_codexa#716848, xa_lib30#716849, xa_libuti#716850, xa_typexa#716851, xa_contra#716852, xa_durava#716853, xa_durpen#716854, xa_durapr#716855, xa_durtot#716856, xa_durmed#716857, xa_protoc#716858, xa_datmaj#716859, xa_coduti#716860, xa_codpro#716861, xa_coulstd#716862, xa_couleur#716863, xa_flmedobl#716864, xa_flatsobl#716865, xa_flvalplanif#716866, xa_flvalaccueil#716867, xa_nivvcr#716868, xa_flrtcclq#716869, xa_fllabochaud#716870, xa_datede#716871, xa_datefi#716872, xa_flgrpjour#716873, xa_primai#716874, xa_codpros#716875, xa_codconv#716876, xa_later#716877, xa_incidence#716878, xa_position#716879, xa_flgrve#716880, xa_flexainj#716881, xa_contrapat#716882, xa_flprore#716883, xa_flcacheinet#716884, xa_flnocot#716885, xa_codadm#716886, xa_flgrvi#716887, xa_reganas#716888, xa_flrecist#716889, xa_flnocr#716890, xa_icd#716891, xa_type_icd#716892, xa_flrecist_ec#716893, xa_codloinc#716894]
Condition : (((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(xa_codexa#716848)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_codexa#716848)), MAIN) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_lib30#716849)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_lib30#716849)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_libuti#716850)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_libuti#716850)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_typexa#716851)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_typexa#716851)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_contra#716852)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_contra#716852)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_durava#716853)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_durava#716853)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_durpen#716854)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_durpen#716854)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_durapr#716855)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_durapr#716855)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_durtot#716856)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_durtot#716856)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_durmed#716857)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_durmed#716857)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_protoc#716858)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_protoc#716858)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_datmaj#716859)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_datmaj#716859)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_coduti#716860)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_coduti#716860)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_codpro#716861)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_codpro#716861)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_coulstd#716862)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_coulstd#716862)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_couleur#716863)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_couleur#716863)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flmedobl#716864)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flmedobl#716864)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flatsobl#716865)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flatsobl#716865)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flvalplanif#716866)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flvalplanif#716866)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flvalaccueil#716867)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flvalaccueil#716867)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_nivvcr#716868)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_nivvcr#716868)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flrtcclq#716869)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flrtcclq#716869)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_fllabochaud#716870)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_fllabochaud#716870)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_datede#716871)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_datede#716871)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_datefi#716872)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_datefi#716872)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flgrpjour#716873)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flgrpjour#716873)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_primai#716874)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_primai#716874)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_codpros#716875)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_codpros#716875)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_codconv#716876)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_codconv#716876)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_later#716877)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_later#716877)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_incidence#716878)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_incidence#716878)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_position#716879)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_position#716879)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flgrve#716880)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flgrve#716880)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flexainj#716881)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flexainj#716881)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_contrapat#716882)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_contrapat#716882)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flprore#716883)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flprore#716883)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flcacheinet#716884)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flcacheinet#716884)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flnocot#716885)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flnocot#716885)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_codadm#716886)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_codadm#716886)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flgrvi#716887)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flgrvi#716887)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_reganas#716888)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_reganas#716888)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flrecist#716889)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flrecist#716889)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flnocr#716890)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flnocr#716890)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_icd#716891)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_icd#716891)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_type_icd#716892)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_type_icd#716892)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flrecist_ec#716893)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flrecist_ec#716893)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_codloinc#716894)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_codloinc#716894)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_create(Cab_B))), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(str_create(Cab_B))), MAIN) END)

(6) Project [codegen id : 2]
Output: []
Input [47]: [xa_codexa#716848, xa_lib30#716849, xa_libuti#716850, xa_typexa#716851, xa_contra#716852, xa_durava#716853, xa_durpen#716854, xa_durapr#716855, xa_durtot#716856, xa_durmed#716857, xa_protoc#716858, xa_datmaj#716859, xa_coduti#716860, xa_codpro#716861, xa_coulstd#716862, xa_couleur#716863, xa_flmedobl#716864, xa_flatsobl#716865, xa_flvalplanif#716866, xa_flvalaccueil#716867, xa_nivvcr#716868, xa_flrtcclq#716869, xa_fllabochaud#716870, xa_datede#716871, xa_datefi#716872, xa_flgrpjour#716873, xa_primai#716874, xa_codpros#716875, xa_codconv#716876, xa_later#716877, xa_incidence#716878, xa_position#716879, xa_flgrve#716880, xa_flexainj#716881, xa_contrapat#716882, xa_flprore#716883, xa_flcacheinet#716884, xa_flnocot#716885, xa_codadm#716886, xa_flgrvi#716887, xa_reganas#716888, xa_flrecist#716889, xa_flnocr#716890, xa_icd#716891, xa_type_icd#716892, xa_flrecist_ec#716893, xa_codloinc#716894]

(7) Union

(8) HashAggregate [codegen id : 3]
Input: []
Keys: []
Functions [1]: [partial_count(1)]
Aggregate Attributes [1]: [count#719864L]
Results [1]: [count#719865L]

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

(10) ShuffleQueryStage
Output [1]: [count#719865L]
Arguments: 0

(11) HashAggregate [codegen id : 4]
Input [1]: [count#719865L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#718568L]
Results [1]: [count(1)#718568L AS COL_4f89b262-8977-4731-a980-7ce456bb43fc#718570L]

(12) Union

(13) HashAggregate
Input: []
Keys: []
Functions [1]: [partial_count(1)]
Aggregate Attributes [1]: [count#719864L]
Results [1]: [count#719865L]

(14) Exchange
Input [1]: [count#719865L]
Arguments: SinglePartition, ENSURE_REQUIREMENTS, [plan_id=38686]

(15) HashAggregate
Input [1]: [count#719865L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#718568L]
Results [1]: [count(1)#718568L AS COL_4f89b262-8977-4731-a980-7ce456bb43fc#718570L]

(16) AdaptiveSparkPlan
Output [1]: [COL_4f89b262-8977-4731-a980-7ce456bb43fc#718570L]
Arguments: isFinalPlan=true

SQL / DataFrame Properties

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