hdh-spark-job - Details for Query 1368

Submitted Time: 2026/10/23 13:28:08
Duration: 2 s
Succeeded Jobs: 1364 1367

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 1972.0: task 1720)) 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 1972.0: task 1720)) 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 1972.0: task 1720))"]; subgraph cluster4 { isCluster="true"; label="WholeStageCodegen (3)\n \nduration: total (min, med, max (stageId: taskId))\n26 ms (13 ms, 13 ms, 13 ms (stage 1972.0: task 1720))"; 5 [labelType="html" label="HashAggregate time in aggregation build total (min, med, max (stageId: taskId)) 25 ms (12 ms, 13 ms, 13 ms (stage 1972.0: task 1720)) number of output rows: 2"]; } 6 [labelType="html" label=" Union "]; subgraph cluster7 { isCluster="true"; label="WholeStageCodegen (1)\n \nduration: 13 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: 13 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=36787]

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

WholeStageCodegen (3)

Union

Project

Filter (((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(xa_codexa#677124)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_codexa#677124)), MAIN) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_lib30#677125)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_lib30#677125)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_libuti#677126)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_libuti#677126)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_typexa#677127)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_typexa#677127)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_contra#677128)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_contra#677128)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_durava#677129)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_durava#677129)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_durpen#677130)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_durpen#677130)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_durapr#677131)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_durapr#677131)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_durtot#677132)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_durtot#677132)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_durmed#677133)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_durmed#677133)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_protoc#677134)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_protoc#677134)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_datmaj#677135)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_datmaj#677135)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_coduti#677136)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_coduti#677136)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_codpro#677137)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_codpro#677137)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_coulstd#677138)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_coulstd#677138)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_couleur#677139)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_couleur#677139)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flmedobl#677140)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flmedobl#677140)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flatsobl#677141)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flatsobl#677141)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flvalplanif#677142)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flvalplanif#677142)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flvalaccueil#677143)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flvalaccueil#677143)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_nivvcr#677144)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_nivvcr#677144)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flrtcclq#677145)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flrtcclq#677145)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_fllabochaud#677146)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_fllabochaud#677146)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_datede#677147)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_datede#677147)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_datefi#677148)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_datefi#677148)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flgrpjour#677149)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flgrpjour#677149)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_primai#677150)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_primai#677150)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_codpros#677151)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_codpros#677151)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_codconv#677152)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_codconv#677152)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_later#677153)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_later#677153)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_incidence#677154)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_incidence#677154)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_position#677155)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_position#677155)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flgrve#677156)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flgrve#677156)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flexainj#677157)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flexainj#677157)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_contrapat#677158)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_contrapat#677158)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flprore#677159)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flprore#677159)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flcacheinet#677160)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flcacheinet#677160)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flnocot#677161)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flnocot#677161)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_codadm#677162)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_codadm#677162)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flgrvi#677163)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flgrvi#677163)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_reganas#677164)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_reganas#677164)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flrecist#677165)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flrecist#677165)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flnocr#677166)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flnocr#677166)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_icd#677167)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_icd#677167)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_type_icd#677168)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_type_icd#677168)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flrecist_ec#677169)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flrecist_ec#677169)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_codloinc#677170)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_codloinc#677170)), 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#677124,xa_lib30#677125,xa_libuti#677126,xa_typexa#677127,xa_contra#677128,xa_durava#677129,xa_durpen#677130,xa_durapr#677131,xa_durtot#677132,xa_durmed#677133,xa_protoc#677134,xa_datmaj#677135,xa_coduti#677136,xa_codpro#677137,xa_coulstd#677138,xa_couleur#677139,xa_flmedobl#677140,xa_flatsobl#677141,xa_flvalplanif#677142,xa_flvalaccueil#677143,xa_nivvcr#677144,xa_flrtcclq#677145,xa_fllabochaud#677146,xa_datede#677147,... 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#677550)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_codexa#677550)), MAIN) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_lib30#677551)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_lib30#677551)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_libuti#677552)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_libuti#677552)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_typexa#677553)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_typexa#677553)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_contra#677554)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_contra#677554)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_durava#677555)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_durava#677555)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_durpen#677556)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_durpen#677556)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_durapr#677557)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_durapr#677557)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_durtot#677558)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_durtot#677558)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_durmed#677559)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_durmed#677559)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_protoc#677560)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_protoc#677560)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_datmaj#677561)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_datmaj#677561)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_coduti#677562)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_coduti#677562)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_codpro#677563)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_codpro#677563)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_coulstd#677564)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_coulstd#677564)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_couleur#677565)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_couleur#677565)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flmedobl#677566)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flmedobl#677566)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flatsobl#677567)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flatsobl#677567)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flvalplanif#677568)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flvalplanif#677568)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flvalaccueil#677569)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flvalaccueil#677569)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_nivvcr#677570)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_nivvcr#677570)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flrtcclq#677571)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flrtcclq#677571)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_fllabochaud#677572)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_fllabochaud#677572)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_datede#677573)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_datede#677573)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_datefi#677574)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_datefi#677574)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flgrpjour#677575)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flgrpjour#677575)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_primai#677576)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_primai#677576)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_codpros#677577)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_codpros#677577)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_codconv#677578)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_codconv#677578)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_later#677579)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_later#677579)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_incidence#677580)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_incidence#677580)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_position#677581)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_position#677581)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flgrve#677582)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flgrve#677582)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flexainj#677583)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flexainj#677583)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_contrapat#677584)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_contrapat#677584)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flprore#677585)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flprore#677585)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flcacheinet#677586)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flcacheinet#677586)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flnocot#677587)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flnocot#677587)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_codadm#677588)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_codadm#677588)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flgrvi#677589)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flgrvi#677589)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_reganas#677590)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_reganas#677590)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flrecist#677591)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flrecist#677591)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flnocr#677592)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flnocr#677592)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_icd#677593)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_icd#677593)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_type_icd#677594)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_type_icd#677594)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flrecist_ec#677595)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flrecist_ec#677595)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_codloinc#677596)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_codloinc#677596)), 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#677550,xa_lib30#677551,xa_libuti#677552,xa_typexa#677553,xa_contra#677554,xa_durava#677555,xa_durpen#677556,xa_durapr#677557,xa_durtot#677558,xa_durmed#677559,xa_protoc#677560,xa_datmaj#677561,xa_coduti#677562,xa_codpro#677563,xa_coulstd#677564,xa_couleur#677565,xa_flmedobl#677566,xa_flatsobl#677567,xa_flvalplanif#677568,xa_flvalaccueil#677569,xa_nivvcr#677570,xa_flrtcclq#677571,xa_fllabochaud#677572,xa_datede#677573,... 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#677124, xa_lib30#677125, xa_libuti#677126, xa_typexa#677127, xa_contra#677128, xa_durava#677129, xa_durpen#677130, xa_durapr#677131, xa_durtot#677132, xa_durmed#677133, xa_protoc#677134, xa_datmaj#677135, xa_coduti#677136, xa_codpro#677137, xa_coulstd#677138, xa_couleur#677139, xa_flmedobl#677140, xa_flatsobl#677141, xa_flvalplanif#677142, xa_flvalaccueil#677143, xa_nivvcr#677144, xa_flrtcclq#677145, xa_fllabochaud#677146, xa_datede#677147, xa_datefi#677148, xa_flgrpjour#677149, xa_primai#677150, xa_codpros#677151, xa_codconv#677152, xa_later#677153, xa_incidence#677154, xa_position#677155, xa_flgrve#677156, xa_flexainj#677157, xa_contrapat#677158, xa_flprore#677159, xa_flcacheinet#677160, xa_flnocot#677161, xa_codadm#677162, xa_flgrvi#677163, xa_reganas#677164, xa_flrecist#677165, xa_flnocr#677166, xa_icd#677167, xa_type_icd#677168, xa_flrecist_ec#677169, xa_codloinc#677170]
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#677124, xa_lib30#677125, xa_libuti#677126, xa_typexa#677127, xa_contra#677128, xa_durava#677129, xa_durpen#677130, xa_durapr#677131, xa_durtot#677132, xa_durmed#677133, xa_protoc#677134, xa_datmaj#677135, xa_coduti#677136, xa_codpro#677137, xa_coulstd#677138, xa_couleur#677139, xa_flmedobl#677140, xa_flatsobl#677141, xa_flvalplanif#677142, xa_flvalaccueil#677143, xa_nivvcr#677144, xa_flrtcclq#677145, xa_fllabochaud#677146, xa_datede#677147, xa_datefi#677148, xa_flgrpjour#677149, xa_primai#677150, xa_codpros#677151, xa_codconv#677152, xa_later#677153, xa_incidence#677154, xa_position#677155, xa_flgrve#677156, xa_flexainj#677157, xa_contrapat#677158, xa_flprore#677159, xa_flcacheinet#677160, xa_flnocot#677161, xa_codadm#677162, xa_flgrvi#677163, xa_reganas#677164, xa_flrecist#677165, xa_flnocr#677166, xa_icd#677167, xa_type_icd#677168, xa_flrecist_ec#677169, xa_codloinc#677170]
Condition : (((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(xa_codexa#677124)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_codexa#677124)), MAIN) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_lib30#677125)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_lib30#677125)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_libuti#677126)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_libuti#677126)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_typexa#677127)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_typexa#677127)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_contra#677128)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_contra#677128)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_durava#677129)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_durava#677129)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_durpen#677130)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_durpen#677130)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_durapr#677131)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_durapr#677131)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_durtot#677132)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_durtot#677132)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_durmed#677133)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_durmed#677133)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_protoc#677134)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_protoc#677134)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_datmaj#677135)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_datmaj#677135)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_coduti#677136)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_coduti#677136)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_codpro#677137)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_codpro#677137)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_coulstd#677138)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_coulstd#677138)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_couleur#677139)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_couleur#677139)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flmedobl#677140)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flmedobl#677140)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flatsobl#677141)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flatsobl#677141)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flvalplanif#677142)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flvalplanif#677142)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flvalaccueil#677143)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flvalaccueil#677143)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_nivvcr#677144)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_nivvcr#677144)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flrtcclq#677145)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flrtcclq#677145)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_fllabochaud#677146)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_fllabochaud#677146)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_datede#677147)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_datede#677147)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_datefi#677148)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_datefi#677148)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flgrpjour#677149)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flgrpjour#677149)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_primai#677150)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_primai#677150)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_codpros#677151)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_codpros#677151)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_codconv#677152)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_codconv#677152)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_later#677153)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_later#677153)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_incidence#677154)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_incidence#677154)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_position#677155)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_position#677155)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flgrve#677156)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flgrve#677156)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flexainj#677157)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flexainj#677157)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_contrapat#677158)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_contrapat#677158)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flprore#677159)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flprore#677159)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flcacheinet#677160)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flcacheinet#677160)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flnocot#677161)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flnocot#677161)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_codadm#677162)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_codadm#677162)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flgrvi#677163)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flgrvi#677163)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_reganas#677164)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_reganas#677164)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flrecist#677165)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flrecist#677165)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flnocr#677166)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flnocr#677166)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_icd#677167)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_icd#677167)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_type_icd#677168)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_type_icd#677168)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flrecist_ec#677169)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flrecist_ec#677169)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_codloinc#677170)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_codloinc#677170)), 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#677124, xa_lib30#677125, xa_libuti#677126, xa_typexa#677127, xa_contra#677128, xa_durava#677129, xa_durpen#677130, xa_durapr#677131, xa_durtot#677132, xa_durmed#677133, xa_protoc#677134, xa_datmaj#677135, xa_coduti#677136, xa_codpro#677137, xa_coulstd#677138, xa_couleur#677139, xa_flmedobl#677140, xa_flatsobl#677141, xa_flvalplanif#677142, xa_flvalaccueil#677143, xa_nivvcr#677144, xa_flrtcclq#677145, xa_fllabochaud#677146, xa_datede#677147, xa_datefi#677148, xa_flgrpjour#677149, xa_primai#677150, xa_codpros#677151, xa_codconv#677152, xa_later#677153, xa_incidence#677154, xa_position#677155, xa_flgrve#677156, xa_flexainj#677157, xa_contrapat#677158, xa_flprore#677159, xa_flcacheinet#677160, xa_flnocot#677161, xa_codadm#677162, xa_flgrvi#677163, xa_reganas#677164, xa_flrecist#677165, xa_flnocr#677166, xa_icd#677167, xa_type_icd#677168, xa_flrecist_ec#677169, xa_codloinc#677170]

(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#677550, xa_lib30#677551, xa_libuti#677552, xa_typexa#677553, xa_contra#677554, xa_durava#677555, xa_durpen#677556, xa_durapr#677557, xa_durtot#677558, xa_durmed#677559, xa_protoc#677560, xa_datmaj#677561, xa_coduti#677562, xa_codpro#677563, xa_coulstd#677564, xa_couleur#677565, xa_flmedobl#677566, xa_flatsobl#677567, xa_flvalplanif#677568, xa_flvalaccueil#677569, xa_nivvcr#677570, xa_flrtcclq#677571, xa_fllabochaud#677572, xa_datede#677573, xa_datefi#677574, xa_flgrpjour#677575, xa_primai#677576, xa_codpros#677577, xa_codconv#677578, xa_later#677579, xa_incidence#677580, xa_position#677581, xa_flgrve#677582, xa_flexainj#677583, xa_contrapat#677584, xa_flprore#677585, xa_flcacheinet#677586, xa_flnocot#677587, xa_codadm#677588, xa_flgrvi#677589, xa_reganas#677590, xa_flrecist#677591, xa_flnocr#677592, xa_icd#677593, xa_type_icd#677594, xa_flrecist_ec#677595, xa_codloinc#677596]
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#677550, xa_lib30#677551, xa_libuti#677552, xa_typexa#677553, xa_contra#677554, xa_durava#677555, xa_durpen#677556, xa_durapr#677557, xa_durtot#677558, xa_durmed#677559, xa_protoc#677560, xa_datmaj#677561, xa_coduti#677562, xa_codpro#677563, xa_coulstd#677564, xa_couleur#677565, xa_flmedobl#677566, xa_flatsobl#677567, xa_flvalplanif#677568, xa_flvalaccueil#677569, xa_nivvcr#677570, xa_flrtcclq#677571, xa_fllabochaud#677572, xa_datede#677573, xa_datefi#677574, xa_flgrpjour#677575, xa_primai#677576, xa_codpros#677577, xa_codconv#677578, xa_later#677579, xa_incidence#677580, xa_position#677581, xa_flgrve#677582, xa_flexainj#677583, xa_contrapat#677584, xa_flprore#677585, xa_flcacheinet#677586, xa_flnocot#677587, xa_codadm#677588, xa_flgrvi#677589, xa_reganas#677590, xa_flrecist#677591, xa_flnocr#677592, xa_icd#677593, xa_type_icd#677594, xa_flrecist_ec#677595, xa_codloinc#677596]
Condition : (((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(xa_codexa#677550)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_codexa#677550)), MAIN) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_lib30#677551)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_lib30#677551)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_libuti#677552)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_libuti#677552)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_typexa#677553)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_typexa#677553)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_contra#677554)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_contra#677554)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_durava#677555)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_durava#677555)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_durpen#677556)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_durpen#677556)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_durapr#677557)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_durapr#677557)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_durtot#677558)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_durtot#677558)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_durmed#677559)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_durmed#677559)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_protoc#677560)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_protoc#677560)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_datmaj#677561)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_datmaj#677561)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_coduti#677562)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_coduti#677562)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_codpro#677563)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_codpro#677563)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_coulstd#677564)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_coulstd#677564)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_couleur#677565)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_couleur#677565)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flmedobl#677566)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flmedobl#677566)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flatsobl#677567)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flatsobl#677567)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flvalplanif#677568)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flvalplanif#677568)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flvalaccueil#677569)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flvalaccueil#677569)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_nivvcr#677570)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_nivvcr#677570)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flrtcclq#677571)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flrtcclq#677571)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_fllabochaud#677572)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_fllabochaud#677572)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_datede#677573)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_datede#677573)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_datefi#677574)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_datefi#677574)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flgrpjour#677575)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flgrpjour#677575)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_primai#677576)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_primai#677576)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_codpros#677577)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_codpros#677577)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_codconv#677578)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_codconv#677578)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_later#677579)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_later#677579)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_incidence#677580)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_incidence#677580)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_position#677581)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_position#677581)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flgrve#677582)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flgrve#677582)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flexainj#677583)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flexainj#677583)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_contrapat#677584)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_contrapat#677584)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flprore#677585)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flprore#677585)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flcacheinet#677586)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flcacheinet#677586)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flnocot#677587)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flnocot#677587)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_codadm#677588)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_codadm#677588)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flgrvi#677589)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flgrvi#677589)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_reganas#677590)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_reganas#677590)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flrecist#677591)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flrecist#677591)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flnocr#677592)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flnocr#677592)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_icd#677593)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_icd#677593)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_type_icd#677594)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_type_icd#677594)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flrecist_ec#677595)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flrecist_ec#677595)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_codloinc#677596)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_codloinc#677596)), 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#677550, xa_lib30#677551, xa_libuti#677552, xa_typexa#677553, xa_contra#677554, xa_durava#677555, xa_durpen#677556, xa_durapr#677557, xa_durtot#677558, xa_durmed#677559, xa_protoc#677560, xa_datmaj#677561, xa_coduti#677562, xa_codpro#677563, xa_coulstd#677564, xa_couleur#677565, xa_flmedobl#677566, xa_flatsobl#677567, xa_flvalplanif#677568, xa_flvalaccueil#677569, xa_nivvcr#677570, xa_flrtcclq#677571, xa_fllabochaud#677572, xa_datede#677573, xa_datefi#677574, xa_flgrpjour#677575, xa_primai#677576, xa_codpros#677577, xa_codconv#677578, xa_later#677579, xa_incidence#677580, xa_position#677581, xa_flgrve#677582, xa_flexainj#677583, xa_contrapat#677584, xa_flprore#677585, xa_flcacheinet#677586, xa_flnocot#677587, xa_codadm#677588, xa_flgrvi#677589, xa_reganas#677590, xa_flrecist#677591, xa_flnocr#677592, xa_icd#677593, xa_type_icd#677594, xa_flrecist_ec#677595, xa_codloinc#677596]

(7) Union

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

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

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

(11) HashAggregate [codegen id : 4]
Input [1]: [count#679472L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#678364L]
Results [1]: [count(1)#678364L AS COL_5a60648a-26fe-4ace-b855-688dc60d5dfe#678366L]

(12) Union

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

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

(15) HashAggregate
Input [1]: [count#679472L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#678364L]
Results [1]: [count(1)#678364L AS COL_5a60648a-26fe-4ace-b855-688dc60d5dfe#678366L]

(16) AdaptiveSparkPlan
Output [1]: [COL_5a60648a-26fe-4ace-b855-688dc60d5dfe#678366L]
Arguments: isFinalPlan=true

SQL / DataFrame Properties

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