hdh-spark-job - Details for Query 1391

Submitted Time: 2026/10/23 13:28:34
Duration: 0.7 s
Succeeded Jobs: 1386 1389

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 2006.0: task 1752)) 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 2006.0: task 1752)) 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 2006.0: task 1752))"]; subgraph cluster4 { isCluster="true"; label="WholeStageCodegen (3)\n \nduration: total (min, med, max (stageId: taskId))\n25 ms (12 ms, 13 ms, 13 ms (stage 2006.0: task 1752))"; 5 [labelType="html" label="HashAggregate time in aggregation build total (min, med, max (stageId: taskId)) 25 ms (12 ms, 13 ms, 13 ms (stage 2006.0: task 1752)) 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: 12 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=37524]

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

WholeStageCodegen (3)

Union

Project

Filter (((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(xa_codexa#701529)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_codexa#701529)), MAIN) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_lib30#701530)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_lib30#701530)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_libuti#701531)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_libuti#701531)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_typexa#701532)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_typexa#701532)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_contra#701533)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_contra#701533)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_durava#701534)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_durava#701534)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_durpen#701535)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_durpen#701535)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_durapr#701536)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_durapr#701536)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_durtot#701537)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_durtot#701537)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_durmed#701538)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_durmed#701538)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_protoc#701539)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_protoc#701539)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_datmaj#701540)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_datmaj#701540)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_coduti#701541)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_coduti#701541)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_codpro#701542)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_codpro#701542)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_coulstd#701543)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_coulstd#701543)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_couleur#701544)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_couleur#701544)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flmedobl#701545)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flmedobl#701545)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flatsobl#701546)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flatsobl#701546)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flvalplanif#701547)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flvalplanif#701547)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flvalaccueil#701548)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flvalaccueil#701548)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_nivvcr#701549)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_nivvcr#701549)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flrtcclq#701550)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flrtcclq#701550)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_fllabochaud#701551)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_fllabochaud#701551)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_datede#701552)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_datede#701552)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_datefi#701553)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_datefi#701553)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flgrpjour#701554)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flgrpjour#701554)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_primai#701555)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_primai#701555)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_codpros#701556)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_codpros#701556)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_codconv#701557)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_codconv#701557)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_later#701558)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_later#701558)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_incidence#701559)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_incidence#701559)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_position#701560)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_position#701560)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flgrve#701561)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flgrve#701561)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flexainj#701562)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flexainj#701562)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_contrapat#701563)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_contrapat#701563)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flprore#701564)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flprore#701564)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flcacheinet#701565)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flcacheinet#701565)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flnocot#701566)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flnocot#701566)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_codadm#701567)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_codadm#701567)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flgrvi#701568)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flgrvi#701568)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_reganas#701569)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_reganas#701569)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flrecist#701570)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flrecist#701570)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flnocr#701571)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flnocr#701571)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_icd#701572)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_icd#701572)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_type_icd#701573)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_type_icd#701573)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flrecist_ec#701574)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flrecist_ec#701574)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_codloinc#701575)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_codloinc#701575)), 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#701529,xa_lib30#701530,xa_libuti#701531,xa_typexa#701532,xa_contra#701533,xa_durava#701534,xa_durpen#701535,xa_durapr#701536,xa_durtot#701537,xa_durmed#701538,xa_protoc#701539,xa_datmaj#701540,xa_coduti#701541,xa_codpro#701542,xa_coulstd#701543,xa_couleur#701544,xa_flmedobl#701545,xa_flatsobl#701546,xa_flvalplanif#701547,xa_flvalaccueil#701548,xa_nivvcr#701549,xa_flrtcclq#701550,xa_fllabochaud#701551,xa_datede#701552,... 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#702333)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_codexa#702333)), MAIN) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_lib30#702334)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_lib30#702334)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_libuti#702335)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_libuti#702335)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_typexa#702336)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_typexa#702336)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_contra#702337)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_contra#702337)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_durava#702338)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_durava#702338)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_durpen#702339)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_durpen#702339)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_durapr#702340)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_durapr#702340)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_durtot#702341)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_durtot#702341)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_durmed#702342)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_durmed#702342)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_protoc#702343)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_protoc#702343)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_datmaj#702344)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_datmaj#702344)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_coduti#702345)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_coduti#702345)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_codpro#702346)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_codpro#702346)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_coulstd#702347)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_coulstd#702347)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_couleur#702348)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_couleur#702348)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flmedobl#702349)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flmedobl#702349)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flatsobl#702350)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flatsobl#702350)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flvalplanif#702351)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flvalplanif#702351)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flvalaccueil#702352)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flvalaccueil#702352)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_nivvcr#702353)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_nivvcr#702353)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flrtcclq#702354)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flrtcclq#702354)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_fllabochaud#702355)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_fllabochaud#702355)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_datede#702356)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_datede#702356)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_datefi#702357)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_datefi#702357)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flgrpjour#702358)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flgrpjour#702358)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_primai#702359)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_primai#702359)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_codpros#702360)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_codpros#702360)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_codconv#702361)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_codconv#702361)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_later#702362)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_later#702362)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_incidence#702363)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_incidence#702363)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_position#702364)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_position#702364)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flgrve#702365)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flgrve#702365)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flexainj#702366)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flexainj#702366)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_contrapat#702367)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_contrapat#702367)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flprore#702368)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flprore#702368)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flcacheinet#702369)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flcacheinet#702369)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flnocot#702370)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flnocot#702370)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_codadm#702371)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_codadm#702371)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flgrvi#702372)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flgrvi#702372)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_reganas#702373)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_reganas#702373)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flrecist#702374)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flrecist#702374)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flnocr#702375)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flnocr#702375)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_icd#702376)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_icd#702376)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_type_icd#702377)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_type_icd#702377)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flrecist_ec#702378)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flrecist_ec#702378)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_codloinc#702379)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_codloinc#702379)), 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#702333,xa_lib30#702334,xa_libuti#702335,xa_typexa#702336,xa_contra#702337,xa_durava#702338,xa_durpen#702339,xa_durapr#702340,xa_durtot#702341,xa_durmed#702342,xa_protoc#702343,xa_datmaj#702344,xa_coduti#702345,xa_codpro#702346,xa_coulstd#702347,xa_couleur#702348,xa_flmedobl#702349,xa_flatsobl#702350,xa_flvalplanif#702351,xa_flvalaccueil#702352,xa_nivvcr#702353,xa_flrtcclq#702354,xa_fllabochaud#702355,xa_datede#702356,... 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#701529, xa_lib30#701530, xa_libuti#701531, xa_typexa#701532, xa_contra#701533, xa_durava#701534, xa_durpen#701535, xa_durapr#701536, xa_durtot#701537, xa_durmed#701538, xa_protoc#701539, xa_datmaj#701540, xa_coduti#701541, xa_codpro#701542, xa_coulstd#701543, xa_couleur#701544, xa_flmedobl#701545, xa_flatsobl#701546, xa_flvalplanif#701547, xa_flvalaccueil#701548, xa_nivvcr#701549, xa_flrtcclq#701550, xa_fllabochaud#701551, xa_datede#701552, xa_datefi#701553, xa_flgrpjour#701554, xa_primai#701555, xa_codpros#701556, xa_codconv#701557, xa_later#701558, xa_incidence#701559, xa_position#701560, xa_flgrve#701561, xa_flexainj#701562, xa_contrapat#701563, xa_flprore#701564, xa_flcacheinet#701565, xa_flnocot#701566, xa_codadm#701567, xa_flgrvi#701568, xa_reganas#701569, xa_flrecist#701570, xa_flnocr#701571, xa_icd#701572, xa_type_icd#701573, xa_flrecist_ec#701574, xa_codloinc#701575]
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#701529, xa_lib30#701530, xa_libuti#701531, xa_typexa#701532, xa_contra#701533, xa_durava#701534, xa_durpen#701535, xa_durapr#701536, xa_durtot#701537, xa_durmed#701538, xa_protoc#701539, xa_datmaj#701540, xa_coduti#701541, xa_codpro#701542, xa_coulstd#701543, xa_couleur#701544, xa_flmedobl#701545, xa_flatsobl#701546, xa_flvalplanif#701547, xa_flvalaccueil#701548, xa_nivvcr#701549, xa_flrtcclq#701550, xa_fllabochaud#701551, xa_datede#701552, xa_datefi#701553, xa_flgrpjour#701554, xa_primai#701555, xa_codpros#701556, xa_codconv#701557, xa_later#701558, xa_incidence#701559, xa_position#701560, xa_flgrve#701561, xa_flexainj#701562, xa_contrapat#701563, xa_flprore#701564, xa_flcacheinet#701565, xa_flnocot#701566, xa_codadm#701567, xa_flgrvi#701568, xa_reganas#701569, xa_flrecist#701570, xa_flnocr#701571, xa_icd#701572, xa_type_icd#701573, xa_flrecist_ec#701574, xa_codloinc#701575]
Condition : (((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(xa_codexa#701529)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_codexa#701529)), MAIN) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_lib30#701530)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_lib30#701530)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_libuti#701531)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_libuti#701531)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_typexa#701532)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_typexa#701532)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_contra#701533)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_contra#701533)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_durava#701534)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_durava#701534)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_durpen#701535)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_durpen#701535)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_durapr#701536)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_durapr#701536)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_durtot#701537)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_durtot#701537)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_durmed#701538)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_durmed#701538)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_protoc#701539)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_protoc#701539)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_datmaj#701540)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_datmaj#701540)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_coduti#701541)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_coduti#701541)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_codpro#701542)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_codpro#701542)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_coulstd#701543)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_coulstd#701543)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_couleur#701544)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_couleur#701544)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flmedobl#701545)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flmedobl#701545)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flatsobl#701546)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flatsobl#701546)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flvalplanif#701547)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flvalplanif#701547)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flvalaccueil#701548)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flvalaccueil#701548)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_nivvcr#701549)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_nivvcr#701549)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flrtcclq#701550)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flrtcclq#701550)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_fllabochaud#701551)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_fllabochaud#701551)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_datede#701552)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_datede#701552)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_datefi#701553)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_datefi#701553)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flgrpjour#701554)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flgrpjour#701554)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_primai#701555)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_primai#701555)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_codpros#701556)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_codpros#701556)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_codconv#701557)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_codconv#701557)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_later#701558)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_later#701558)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_incidence#701559)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_incidence#701559)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_position#701560)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_position#701560)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flgrve#701561)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flgrve#701561)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flexainj#701562)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flexainj#701562)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_contrapat#701563)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_contrapat#701563)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flprore#701564)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flprore#701564)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flcacheinet#701565)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flcacheinet#701565)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flnocot#701566)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flnocot#701566)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_codadm#701567)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_codadm#701567)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flgrvi#701568)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flgrvi#701568)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_reganas#701569)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_reganas#701569)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flrecist#701570)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flrecist#701570)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flnocr#701571)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flnocr#701571)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_icd#701572)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_icd#701572)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_type_icd#701573)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_type_icd#701573)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flrecist_ec#701574)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flrecist_ec#701574)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_codloinc#701575)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_codloinc#701575)), 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#701529, xa_lib30#701530, xa_libuti#701531, xa_typexa#701532, xa_contra#701533, xa_durava#701534, xa_durpen#701535, xa_durapr#701536, xa_durtot#701537, xa_durmed#701538, xa_protoc#701539, xa_datmaj#701540, xa_coduti#701541, xa_codpro#701542, xa_coulstd#701543, xa_couleur#701544, xa_flmedobl#701545, xa_flatsobl#701546, xa_flvalplanif#701547, xa_flvalaccueil#701548, xa_nivvcr#701549, xa_flrtcclq#701550, xa_fllabochaud#701551, xa_datede#701552, xa_datefi#701553, xa_flgrpjour#701554, xa_primai#701555, xa_codpros#701556, xa_codconv#701557, xa_later#701558, xa_incidence#701559, xa_position#701560, xa_flgrve#701561, xa_flexainj#701562, xa_contrapat#701563, xa_flprore#701564, xa_flcacheinet#701565, xa_flnocot#701566, xa_codadm#701567, xa_flgrvi#701568, xa_reganas#701569, xa_flrecist#701570, xa_flnocr#701571, xa_icd#701572, xa_type_icd#701573, xa_flrecist_ec#701574, xa_codloinc#701575]

(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#702333, xa_lib30#702334, xa_libuti#702335, xa_typexa#702336, xa_contra#702337, xa_durava#702338, xa_durpen#702339, xa_durapr#702340, xa_durtot#702341, xa_durmed#702342, xa_protoc#702343, xa_datmaj#702344, xa_coduti#702345, xa_codpro#702346, xa_coulstd#702347, xa_couleur#702348, xa_flmedobl#702349, xa_flatsobl#702350, xa_flvalplanif#702351, xa_flvalaccueil#702352, xa_nivvcr#702353, xa_flrtcclq#702354, xa_fllabochaud#702355, xa_datede#702356, xa_datefi#702357, xa_flgrpjour#702358, xa_primai#702359, xa_codpros#702360, xa_codconv#702361, xa_later#702362, xa_incidence#702363, xa_position#702364, xa_flgrve#702365, xa_flexainj#702366, xa_contrapat#702367, xa_flprore#702368, xa_flcacheinet#702369, xa_flnocot#702370, xa_codadm#702371, xa_flgrvi#702372, xa_reganas#702373, xa_flrecist#702374, xa_flnocr#702375, xa_icd#702376, xa_type_icd#702377, xa_flrecist_ec#702378, xa_codloinc#702379]
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#702333, xa_lib30#702334, xa_libuti#702335, xa_typexa#702336, xa_contra#702337, xa_durava#702338, xa_durpen#702339, xa_durapr#702340, xa_durtot#702341, xa_durmed#702342, xa_protoc#702343, xa_datmaj#702344, xa_coduti#702345, xa_codpro#702346, xa_coulstd#702347, xa_couleur#702348, xa_flmedobl#702349, xa_flatsobl#702350, xa_flvalplanif#702351, xa_flvalaccueil#702352, xa_nivvcr#702353, xa_flrtcclq#702354, xa_fllabochaud#702355, xa_datede#702356, xa_datefi#702357, xa_flgrpjour#702358, xa_primai#702359, xa_codpros#702360, xa_codconv#702361, xa_later#702362, xa_incidence#702363, xa_position#702364, xa_flgrve#702365, xa_flexainj#702366, xa_contrapat#702367, xa_flprore#702368, xa_flcacheinet#702369, xa_flnocot#702370, xa_codadm#702371, xa_flgrvi#702372, xa_reganas#702373, xa_flrecist#702374, xa_flnocr#702375, xa_icd#702376, xa_type_icd#702377, xa_flrecist_ec#702378, xa_codloinc#702379]
Condition : (((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(xa_codexa#702333)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_codexa#702333)), MAIN) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_lib30#702334)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_lib30#702334)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_libuti#702335)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_libuti#702335)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_typexa#702336)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_typexa#702336)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_contra#702337)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_contra#702337)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_durava#702338)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_durava#702338)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_durpen#702339)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_durpen#702339)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_durapr#702340)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_durapr#702340)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_durtot#702341)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_durtot#702341)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_durmed#702342)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_durmed#702342)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_protoc#702343)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_protoc#702343)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_datmaj#702344)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_datmaj#702344)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_coduti#702345)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_coduti#702345)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_codpro#702346)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_codpro#702346)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_coulstd#702347)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_coulstd#702347)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_couleur#702348)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_couleur#702348)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flmedobl#702349)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flmedobl#702349)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flatsobl#702350)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flatsobl#702350)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flvalplanif#702351)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flvalplanif#702351)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flvalaccueil#702352)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flvalaccueil#702352)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_nivvcr#702353)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_nivvcr#702353)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flrtcclq#702354)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flrtcclq#702354)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_fllabochaud#702355)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_fllabochaud#702355)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_datede#702356)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_datede#702356)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_datefi#702357)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_datefi#702357)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flgrpjour#702358)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flgrpjour#702358)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_primai#702359)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_primai#702359)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_codpros#702360)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_codpros#702360)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_codconv#702361)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_codconv#702361)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_later#702362)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_later#702362)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_incidence#702363)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_incidence#702363)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_position#702364)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_position#702364)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flgrve#702365)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flgrve#702365)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flexainj#702366)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flexainj#702366)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_contrapat#702367)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_contrapat#702367)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flprore#702368)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flprore#702368)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flcacheinet#702369)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flcacheinet#702369)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flnocot#702370)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flnocot#702370)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_codadm#702371)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_codadm#702371)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flgrvi#702372)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flgrvi#702372)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_reganas#702373)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_reganas#702373)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flrecist#702374)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flrecist#702374)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flnocr#702375)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flnocr#702375)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_icd#702376)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_icd#702376)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_type_icd#702377)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_type_icd#702377)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flrecist_ec#702378)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_flrecist_ec#702378)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_codloinc#702379)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(xa_codloinc#702379)), 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#702333, xa_lib30#702334, xa_libuti#702335, xa_typexa#702336, xa_contra#702337, xa_durava#702338, xa_durpen#702339, xa_durapr#702340, xa_durtot#702341, xa_durmed#702342, xa_protoc#702343, xa_datmaj#702344, xa_coduti#702345, xa_codpro#702346, xa_coulstd#702347, xa_couleur#702348, xa_flmedobl#702349, xa_flatsobl#702350, xa_flvalplanif#702351, xa_flvalaccueil#702352, xa_nivvcr#702353, xa_flrtcclq#702354, xa_fllabochaud#702355, xa_datede#702356, xa_datefi#702357, xa_flgrpjour#702358, xa_primai#702359, xa_codpros#702360, xa_codconv#702361, xa_later#702362, xa_incidence#702363, xa_position#702364, xa_flgrve#702365, xa_flexainj#702366, xa_contrapat#702367, xa_flprore#702368, xa_flcacheinet#702369, xa_flnocot#702370, xa_codadm#702371, xa_flgrvi#702372, xa_reganas#702373, xa_flrecist#702374, xa_flnocr#702375, xa_icd#702376, xa_type_icd#702377, xa_flrecist_ec#702378, xa_codloinc#702379]

(7) Union

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

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

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

(11) HashAggregate [codegen id : 4]
Input [1]: [count#704201L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#704005L]
Results [1]: [count(1)#704005L AS count#704006L]

(12) Union

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

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

(15) HashAggregate
Input [1]: [count#704201L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#704005L]
Results [1]: [count(1)#704005L AS count#704006L]

(16) AdaptiveSparkPlan
Output [1]: [count#704006L]
Arguments: isFinalPlan=true

SQL / DataFrame Properties

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