hdh-spark-job - Details for Query 1309

Submitted Time: 2026/10/23 13:26:32
Duration: 0.7 s
Succeeded Jobs: 1311 1312

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 1888.0: task 1644)) 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: 112.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 1888.0: task 1644)) 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)) 112.0 B (56.0 B, 56.0 B, 56.0 B (stage 1888.0: task 1644))"]; subgraph cluster4 { isCluster="true"; label="WholeStageCodegen (3)\n \nduration: total (min, med, max (stageId: taskId))\n25 ms (12 ms, 13 ms, 13 ms (stage 1888.0: task 1644))"; 5 [labelType="html" label="HashAggregate time in aggregation build total (min, med, max (stageId: taskId)) 24 ms (12 ms, 12 ms, 12 ms (stage 1888.0: task 1644)) number of output rows: 2"]; } 6 [labelType="html" label=" Union "]; subgraph cluster7 { isCluster="true"; label="WholeStageCodegen (1)\n \nduration: 12 ms"; 8 [labelType="html" label=" Project "]; 9 [labelType="html" label="Filter number of output rows: 0"]; 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: 0"]; 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=34835]

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

WholeStageCodegen (3)

Union

Project

Filter (((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(xa_codexa#636749)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(xa_codexa#636749)), MARX) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_lib30#636750)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(xa_lib30#636750)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_libuti#636751)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(xa_libuti#636751)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_typexa#636752)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(xa_typexa#636752)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_contra#636753)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(xa_contra#636753)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_durava#636754)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(xa_durava#636754)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_durpen#636755)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(xa_durpen#636755)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_durapr#636756)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(xa_durapr#636756)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_durtot#636757)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(xa_durtot#636757)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_durmed#636758)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(xa_durmed#636758)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_protoc#636759)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(xa_protoc#636759)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_datmaj#636760)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(xa_datmaj#636760)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_coduti#636761)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(xa_coduti#636761)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_codpro#636762)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(xa_codpro#636762)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_coulstd#636763)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(xa_coulstd#636763)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_couleur#636764)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(xa_couleur#636764)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flmedobl#636765)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(xa_flmedobl#636765)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flatsobl#636766)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(xa_flatsobl#636766)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flvalplanif#636767)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(xa_flvalplanif#636767)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flvalaccueil#636768)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(xa_flvalaccueil#636768)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_nivvcr#636769)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(xa_nivvcr#636769)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flrtcclq#636770)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(xa_flrtcclq#636770)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_fllabochaud#636771)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(xa_fllabochaud#636771)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_datede#636772)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(xa_datede#636772)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_datefi#636773)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(xa_datefi#636773)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flgrpjour#636774)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(xa_flgrpjour#636774)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_primai#636775)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(xa_primai#636775)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_codpros#636776)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(xa_codpros#636776)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_codconv#636777)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(xa_codconv#636777)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_later#636778)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(xa_later#636778)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_incidence#636779)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(xa_incidence#636779)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_position#636780)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(xa_position#636780)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flgrve#636781)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(xa_flgrve#636781)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flexainj#636782)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(xa_flexainj#636782)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_contrapat#636783)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(xa_contrapat#636783)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flprore#636784)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(xa_flprore#636784)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flcacheinet#636785)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(xa_flcacheinet#636785)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flnocot#636786)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(xa_flnocot#636786)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_codadm#636787)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(xa_codadm#636787)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flgrvi#636788)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(xa_flgrvi#636788)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_reganas#636789)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(xa_reganas#636789)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flrecist#636790)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(xa_flrecist#636790)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flnocr#636791)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(xa_flnocr#636791)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_icd#636792)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(xa_icd#636792)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_type_icd#636793)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(xa_type_icd#636793)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flrecist_ec#636794)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(xa_flrecist_ec#636794)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_codloinc#636795)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(xa_codloinc#636795)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_create(Cab_A))), MARX)) THEN false ELSE Contains(str_remove_accent(upper(str_create(Cab_A))), MARX) 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#636749,xa_lib30#636750,xa_libuti#636751,xa_typexa#636752,xa_contra#636753,xa_durava#636754,xa_durpen#636755,xa_durapr#636756,xa_durtot#636757,xa_durmed#636758,xa_protoc#636759,xa_datmaj#636760,xa_coduti#636761,xa_codpro#636762,xa_coulstd#636763,xa_couleur#636764,xa_flmedobl#636765,xa_flatsobl#636766,xa_flvalplanif#636767,xa_flvalaccueil#636768,xa_nivvcr#636769,xa_flrtcclq#636770,xa_fllabochaud#636771,xa_datede#636772,... 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#637175)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(xa_codexa#637175)), MARX) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_lib30#637176)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(xa_lib30#637176)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_libuti#637177)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(xa_libuti#637177)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_typexa#637178)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(xa_typexa#637178)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_contra#637179)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(xa_contra#637179)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_durava#637180)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(xa_durava#637180)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_durpen#637181)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(xa_durpen#637181)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_durapr#637182)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(xa_durapr#637182)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_durtot#637183)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(xa_durtot#637183)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_durmed#637184)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(xa_durmed#637184)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_protoc#637185)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(xa_protoc#637185)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_datmaj#637186)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(xa_datmaj#637186)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_coduti#637187)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(xa_coduti#637187)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_codpro#637188)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(xa_codpro#637188)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_coulstd#637189)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(xa_coulstd#637189)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_couleur#637190)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(xa_couleur#637190)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flmedobl#637191)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(xa_flmedobl#637191)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flatsobl#637192)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(xa_flatsobl#637192)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flvalplanif#637193)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(xa_flvalplanif#637193)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flvalaccueil#637194)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(xa_flvalaccueil#637194)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_nivvcr#637195)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(xa_nivvcr#637195)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flrtcclq#637196)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(xa_flrtcclq#637196)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_fllabochaud#637197)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(xa_fllabochaud#637197)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_datede#637198)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(xa_datede#637198)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_datefi#637199)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(xa_datefi#637199)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flgrpjour#637200)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(xa_flgrpjour#637200)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_primai#637201)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(xa_primai#637201)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_codpros#637202)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(xa_codpros#637202)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_codconv#637203)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(xa_codconv#637203)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_later#637204)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(xa_later#637204)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_incidence#637205)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(xa_incidence#637205)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_position#637206)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(xa_position#637206)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flgrve#637207)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(xa_flgrve#637207)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flexainj#637208)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(xa_flexainj#637208)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_contrapat#637209)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(xa_contrapat#637209)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flprore#637210)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(xa_flprore#637210)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flcacheinet#637211)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(xa_flcacheinet#637211)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flnocot#637212)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(xa_flnocot#637212)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_codadm#637213)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(xa_codadm#637213)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flgrvi#637214)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(xa_flgrvi#637214)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_reganas#637215)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(xa_reganas#637215)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flrecist#637216)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(xa_flrecist#637216)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flnocr#637217)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(xa_flnocr#637217)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_icd#637218)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(xa_icd#637218)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_type_icd#637219)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(xa_type_icd#637219)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flrecist_ec#637220)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(xa_flrecist_ec#637220)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_codloinc#637221)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(xa_codloinc#637221)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_create(Cab_B))), MARX)) THEN false ELSE Contains(str_remove_accent(upper(str_create(Cab_B))), MARX) 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#637175,xa_lib30#637176,xa_libuti#637177,xa_typexa#637178,xa_contra#637179,xa_durava#637180,xa_durpen#637181,xa_durapr#637182,xa_durtot#637183,xa_durmed#637184,xa_protoc#637185,xa_datmaj#637186,xa_coduti#637187,xa_codpro#637188,xa_coulstd#637189,xa_couleur#637190,xa_flmedobl#637191,xa_flatsobl#637192,xa_flvalplanif#637193,xa_flvalaccueil#637194,xa_nivvcr#637195,xa_flrtcclq#637196,xa_fllabochaud#637197,xa_datede#637198,... 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#636749, xa_lib30#636750, xa_libuti#636751, xa_typexa#636752, xa_contra#636753, xa_durava#636754, xa_durpen#636755, xa_durapr#636756, xa_durtot#636757, xa_durmed#636758, xa_protoc#636759, xa_datmaj#636760, xa_coduti#636761, xa_codpro#636762, xa_coulstd#636763, xa_couleur#636764, xa_flmedobl#636765, xa_flatsobl#636766, xa_flvalplanif#636767, xa_flvalaccueil#636768, xa_nivvcr#636769, xa_flrtcclq#636770, xa_fllabochaud#636771, xa_datede#636772, xa_datefi#636773, xa_flgrpjour#636774, xa_primai#636775, xa_codpros#636776, xa_codconv#636777, xa_later#636778, xa_incidence#636779, xa_position#636780, xa_flgrve#636781, xa_flexainj#636782, xa_contrapat#636783, xa_flprore#636784, xa_flcacheinet#636785, xa_flnocot#636786, xa_codadm#636787, xa_flgrvi#636788, xa_reganas#636789, xa_flrecist#636790, xa_flnocr#636791, xa_icd#636792, xa_type_icd#636793, xa_flrecist_ec#636794, xa_codloinc#636795]
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#636749, xa_lib30#636750, xa_libuti#636751, xa_typexa#636752, xa_contra#636753, xa_durava#636754, xa_durpen#636755, xa_durapr#636756, xa_durtot#636757, xa_durmed#636758, xa_protoc#636759, xa_datmaj#636760, xa_coduti#636761, xa_codpro#636762, xa_coulstd#636763, xa_couleur#636764, xa_flmedobl#636765, xa_flatsobl#636766, xa_flvalplanif#636767, xa_flvalaccueil#636768, xa_nivvcr#636769, xa_flrtcclq#636770, xa_fllabochaud#636771, xa_datede#636772, xa_datefi#636773, xa_flgrpjour#636774, xa_primai#636775, xa_codpros#636776, xa_codconv#636777, xa_later#636778, xa_incidence#636779, xa_position#636780, xa_flgrve#636781, xa_flexainj#636782, xa_contrapat#636783, xa_flprore#636784, xa_flcacheinet#636785, xa_flnocot#636786, xa_codadm#636787, xa_flgrvi#636788, xa_reganas#636789, xa_flrecist#636790, xa_flnocr#636791, xa_icd#636792, xa_type_icd#636793, xa_flrecist_ec#636794, xa_codloinc#636795]
Condition : (((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(xa_codexa#636749)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(xa_codexa#636749)), MARX) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_lib30#636750)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(xa_lib30#636750)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_libuti#636751)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(xa_libuti#636751)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_typexa#636752)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(xa_typexa#636752)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_contra#636753)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(xa_contra#636753)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_durava#636754)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(xa_durava#636754)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_durpen#636755)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(xa_durpen#636755)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_durapr#636756)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(xa_durapr#636756)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_durtot#636757)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(xa_durtot#636757)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_durmed#636758)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(xa_durmed#636758)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_protoc#636759)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(xa_protoc#636759)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_datmaj#636760)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(xa_datmaj#636760)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_coduti#636761)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(xa_coduti#636761)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_codpro#636762)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(xa_codpro#636762)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_coulstd#636763)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(xa_coulstd#636763)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_couleur#636764)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(xa_couleur#636764)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flmedobl#636765)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(xa_flmedobl#636765)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flatsobl#636766)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(xa_flatsobl#636766)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flvalplanif#636767)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(xa_flvalplanif#636767)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flvalaccueil#636768)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(xa_flvalaccueil#636768)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_nivvcr#636769)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(xa_nivvcr#636769)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flrtcclq#636770)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(xa_flrtcclq#636770)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_fllabochaud#636771)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(xa_fllabochaud#636771)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_datede#636772)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(xa_datede#636772)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_datefi#636773)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(xa_datefi#636773)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flgrpjour#636774)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(xa_flgrpjour#636774)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_primai#636775)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(xa_primai#636775)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_codpros#636776)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(xa_codpros#636776)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_codconv#636777)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(xa_codconv#636777)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_later#636778)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(xa_later#636778)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_incidence#636779)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(xa_incidence#636779)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_position#636780)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(xa_position#636780)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flgrve#636781)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(xa_flgrve#636781)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flexainj#636782)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(xa_flexainj#636782)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_contrapat#636783)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(xa_contrapat#636783)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flprore#636784)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(xa_flprore#636784)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flcacheinet#636785)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(xa_flcacheinet#636785)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flnocot#636786)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(xa_flnocot#636786)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_codadm#636787)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(xa_codadm#636787)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flgrvi#636788)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(xa_flgrvi#636788)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_reganas#636789)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(xa_reganas#636789)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flrecist#636790)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(xa_flrecist#636790)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flnocr#636791)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(xa_flnocr#636791)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_icd#636792)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(xa_icd#636792)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_type_icd#636793)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(xa_type_icd#636793)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flrecist_ec#636794)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(xa_flrecist_ec#636794)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_codloinc#636795)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(xa_codloinc#636795)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_create(Cab_A))), MARX)) THEN false ELSE Contains(str_remove_accent(upper(str_create(Cab_A))), MARX) END)

(3) Project [codegen id : 1]
Output: []
Input [47]: [xa_codexa#636749, xa_lib30#636750, xa_libuti#636751, xa_typexa#636752, xa_contra#636753, xa_durava#636754, xa_durpen#636755, xa_durapr#636756, xa_durtot#636757, xa_durmed#636758, xa_protoc#636759, xa_datmaj#636760, xa_coduti#636761, xa_codpro#636762, xa_coulstd#636763, xa_couleur#636764, xa_flmedobl#636765, xa_flatsobl#636766, xa_flvalplanif#636767, xa_flvalaccueil#636768, xa_nivvcr#636769, xa_flrtcclq#636770, xa_fllabochaud#636771, xa_datede#636772, xa_datefi#636773, xa_flgrpjour#636774, xa_primai#636775, xa_codpros#636776, xa_codconv#636777, xa_later#636778, xa_incidence#636779, xa_position#636780, xa_flgrve#636781, xa_flexainj#636782, xa_contrapat#636783, xa_flprore#636784, xa_flcacheinet#636785, xa_flnocot#636786, xa_codadm#636787, xa_flgrvi#636788, xa_reganas#636789, xa_flrecist#636790, xa_flnocr#636791, xa_icd#636792, xa_type_icd#636793, xa_flrecist_ec#636794, xa_codloinc#636795]

(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#637175, xa_lib30#637176, xa_libuti#637177, xa_typexa#637178, xa_contra#637179, xa_durava#637180, xa_durpen#637181, xa_durapr#637182, xa_durtot#637183, xa_durmed#637184, xa_protoc#637185, xa_datmaj#637186, xa_coduti#637187, xa_codpro#637188, xa_coulstd#637189, xa_couleur#637190, xa_flmedobl#637191, xa_flatsobl#637192, xa_flvalplanif#637193, xa_flvalaccueil#637194, xa_nivvcr#637195, xa_flrtcclq#637196, xa_fllabochaud#637197, xa_datede#637198, xa_datefi#637199, xa_flgrpjour#637200, xa_primai#637201, xa_codpros#637202, xa_codconv#637203, xa_later#637204, xa_incidence#637205, xa_position#637206, xa_flgrve#637207, xa_flexainj#637208, xa_contrapat#637209, xa_flprore#637210, xa_flcacheinet#637211, xa_flnocot#637212, xa_codadm#637213, xa_flgrvi#637214, xa_reganas#637215, xa_flrecist#637216, xa_flnocr#637217, xa_icd#637218, xa_type_icd#637219, xa_flrecist_ec#637220, xa_codloinc#637221]
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#637175, xa_lib30#637176, xa_libuti#637177, xa_typexa#637178, xa_contra#637179, xa_durava#637180, xa_durpen#637181, xa_durapr#637182, xa_durtot#637183, xa_durmed#637184, xa_protoc#637185, xa_datmaj#637186, xa_coduti#637187, xa_codpro#637188, xa_coulstd#637189, xa_couleur#637190, xa_flmedobl#637191, xa_flatsobl#637192, xa_flvalplanif#637193, xa_flvalaccueil#637194, xa_nivvcr#637195, xa_flrtcclq#637196, xa_fllabochaud#637197, xa_datede#637198, xa_datefi#637199, xa_flgrpjour#637200, xa_primai#637201, xa_codpros#637202, xa_codconv#637203, xa_later#637204, xa_incidence#637205, xa_position#637206, xa_flgrve#637207, xa_flexainj#637208, xa_contrapat#637209, xa_flprore#637210, xa_flcacheinet#637211, xa_flnocot#637212, xa_codadm#637213, xa_flgrvi#637214, xa_reganas#637215, xa_flrecist#637216, xa_flnocr#637217, xa_icd#637218, xa_type_icd#637219, xa_flrecist_ec#637220, xa_codloinc#637221]
Condition : (((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(xa_codexa#637175)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(xa_codexa#637175)), MARX) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_lib30#637176)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(xa_lib30#637176)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_libuti#637177)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(xa_libuti#637177)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_typexa#637178)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(xa_typexa#637178)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_contra#637179)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(xa_contra#637179)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_durava#637180)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(xa_durava#637180)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_durpen#637181)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(xa_durpen#637181)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_durapr#637182)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(xa_durapr#637182)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_durtot#637183)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(xa_durtot#637183)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_durmed#637184)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(xa_durmed#637184)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_protoc#637185)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(xa_protoc#637185)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_datmaj#637186)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(xa_datmaj#637186)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_coduti#637187)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(xa_coduti#637187)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_codpro#637188)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(xa_codpro#637188)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_coulstd#637189)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(xa_coulstd#637189)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_couleur#637190)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(xa_couleur#637190)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flmedobl#637191)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(xa_flmedobl#637191)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flatsobl#637192)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(xa_flatsobl#637192)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flvalplanif#637193)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(xa_flvalplanif#637193)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flvalaccueil#637194)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(xa_flvalaccueil#637194)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_nivvcr#637195)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(xa_nivvcr#637195)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flrtcclq#637196)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(xa_flrtcclq#637196)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_fllabochaud#637197)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(xa_fllabochaud#637197)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_datede#637198)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(xa_datede#637198)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_datefi#637199)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(xa_datefi#637199)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flgrpjour#637200)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(xa_flgrpjour#637200)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_primai#637201)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(xa_primai#637201)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_codpros#637202)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(xa_codpros#637202)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_codconv#637203)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(xa_codconv#637203)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_later#637204)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(xa_later#637204)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_incidence#637205)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(xa_incidence#637205)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_position#637206)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(xa_position#637206)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flgrve#637207)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(xa_flgrve#637207)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flexainj#637208)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(xa_flexainj#637208)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_contrapat#637209)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(xa_contrapat#637209)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flprore#637210)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(xa_flprore#637210)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flcacheinet#637211)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(xa_flcacheinet#637211)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flnocot#637212)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(xa_flnocot#637212)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_codadm#637213)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(xa_codadm#637213)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flgrvi#637214)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(xa_flgrvi#637214)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_reganas#637215)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(xa_reganas#637215)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flrecist#637216)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(xa_flrecist#637216)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flnocr#637217)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(xa_flnocr#637217)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_icd#637218)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(xa_icd#637218)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_type_icd#637219)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(xa_type_icd#637219)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_flrecist_ec#637220)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(xa_flrecist_ec#637220)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(xa_codloinc#637221)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(xa_codloinc#637221)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_create(Cab_B))), MARX)) THEN false ELSE Contains(str_remove_accent(upper(str_create(Cab_B))), MARX) END)

(6) Project [codegen id : 2]
Output: []
Input [47]: [xa_codexa#637175, xa_lib30#637176, xa_libuti#637177, xa_typexa#637178, xa_contra#637179, xa_durava#637180, xa_durpen#637181, xa_durapr#637182, xa_durtot#637183, xa_durmed#637184, xa_protoc#637185, xa_datmaj#637186, xa_coduti#637187, xa_codpro#637188, xa_coulstd#637189, xa_couleur#637190, xa_flmedobl#637191, xa_flatsobl#637192, xa_flvalplanif#637193, xa_flvalaccueil#637194, xa_nivvcr#637195, xa_flrtcclq#637196, xa_fllabochaud#637197, xa_datede#637198, xa_datefi#637199, xa_flgrpjour#637200, xa_primai#637201, xa_codpros#637202, xa_codconv#637203, xa_later#637204, xa_incidence#637205, xa_position#637206, xa_flgrve#637207, xa_flexainj#637208, xa_contrapat#637209, xa_flprore#637210, xa_flcacheinet#637211, xa_flnocot#637212, xa_codadm#637213, xa_flgrvi#637214, xa_reganas#637215, xa_flrecist#637216, xa_flnocr#637217, xa_icd#637218, xa_type_icd#637219, xa_flrecist_ec#637220, xa_codloinc#637221]

(7) Union

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

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

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

(11) HashAggregate [codegen id : 4]
Input [1]: [count#638089L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#637985L]
Results [1]: [count(1)#637985L AS COL_44ff0310-0ff4-4c3f-b54c-76341a11a4ac#637987L]

(12) Union

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

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

(15) HashAggregate
Input [1]: [count#638089L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#637985L]
Results [1]: [count(1)#637985L AS COL_44ff0310-0ff4-4c3f-b54c-76341a11a4ac#637987L]

(16) AdaptiveSparkPlan
Output [1]: [COL_44ff0310-0ff4-4c3f-b54c-76341a11a4ac#637987L]
Arguments: isFinalPlan=true

SQL / DataFrame Properties

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