hdh-spark-job - Details for Query 1357

Submitted Time: 2026/10/23 13:28:07
Duration: 0.5 s
Succeeded Jobs: 1358 1359

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 1963.0: task 1712)) 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 1963.0: task 1712)) 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 1963.0: task 1712))"]; subgraph cluster4 { isCluster="true"; label="WholeStageCodegen (3)\n \nduration: total (min, med, max (stageId: taskId))\n162 ms (64 ms, 98 ms, 98 ms (stage 1963.0: task 1712))"; 5 [labelType="html" label="HashAggregate time in aggregation build total (min, med, max (stageId: taskId)) 162 ms (64 ms, 98 ms, 98 ms (stage 1963.0: task 1712)) number of output rows: 2"]; } 6 [labelType="html" label=" Union "]; subgraph cluster7 { isCluster="true"; label="WholeStageCodegen (1)\n \nduration: 64 ms"; 8 [labelType="html" label=" Project "]; 9 [labelType="html" label="Filter number of output rows: 0"]; 10 [labelType="html" label="Scan JDBCRelation((SELECT \"mr_numstu\", \"mr_numser\", \"mr_numima\", \"mr_n_ima\", \"mr_sopuid\", \"mr_n_acq\", \"mr_datima\", \"mr_heuima\", \"mr_part10\", \"mr_nb_vig\", \"mr_imaeff\", \"mr_dateff\", \"mr_heueff\", \"mr_comm_1\", \"mr_rappro\", \"mr_numdos\", \"mr_numdem\", \"mr_lieu\", \"mr_numcd\", \"mr_sel_di\", \"mr_repert\", \"mr_nomfic\", \"mr_reso_x\", \"mr_reso_y\", \"mr_taific\", \"mr_datmaj\", \"mr_heumaj\", \"mr_coduti\", \"mr_sopclass\", \"mr_reject\", \"mr_hide\", \"mr_bits_alloc\", \"mr_n_echo\", \"mr_cachedir\", \"mr_markup_id\", \"mr_img_pos\", \"mr_img_ori\", \"mr_pix_spacing\", \"mr_later\" FROM \"xplore\".\"h_image\") as x) [numPartitions=1] number of output rows: 1,100"]; } subgraph cluster11 { isCluster="true"; label="WholeStageCodegen (2)\n \nduration: 98 ms"; 12 [labelType="html" label=" Project "]; 13 [labelType="html" label="Filter number of output rows: 0"]; 14 [labelType="html" label="Scan JDBCRelation((SELECT \"mr_numstu\", \"mr_numser\", \"mr_numima\", \"mr_n_ima\", \"mr_sopuid\", \"mr_n_acq\", \"mr_datima\", \"mr_heuima\", \"mr_part10\", \"mr_nb_vig\", \"mr_imaeff\", \"mr_dateff\", \"mr_heueff\", \"mr_comm_1\", \"mr_rappro\", \"mr_numdos\", \"mr_numdem\", \"mr_lieu\", \"mr_numcd\", \"mr_sel_di\", \"mr_repert\", \"mr_nomfic\", \"mr_reso_x\", \"mr_reso_y\", \"mr_taific\", \"mr_datmaj\", \"mr_heumaj\", \"mr_coduti\", \"mr_sopclass\", \"mr_reject\", \"mr_hide\", \"mr_bits_alloc\", \"mr_n_echo\", \"mr_cachedir\", \"mr_markup_id\", \"mr_img_pos\", \"mr_img_ori\", \"mr_pix_spacing\", \"mr_later\" FROM \"xplore2\".\"h_image\") as x) [numPartitions=1] number of output rows: 1,100"]; } 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=36463]

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

WholeStageCodegen (3)

Union

Project

Filter (((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(mr_numstu#671335)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(mr_numstu#671335)), MAIN) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(mr_numser#671336)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(mr_numser#671336)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(mr_numima#671337)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(mr_numima#671337)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(mr_n_ima#671338)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(mr_n_ima#671338)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(mr_sopuid#671339)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(mr_sopuid#671339)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(mr_n_acq#671340)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(mr_n_acq#671340)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(mr_datima#671341)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(mr_datima#671341)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(mr_heuima#671342)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(mr_heuima#671342)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(mr_part10#671343)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(mr_part10#671343)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(mr_nb_vig#671344)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(mr_nb_vig#671344)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(mr_imaeff#671345)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(mr_imaeff#671345)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(mr_dateff#671346)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(mr_dateff#671346)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(mr_heueff#671347)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(mr_heueff#671347)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(mr_comm_1#671348)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(mr_comm_1#671348)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(mr_rappro#671349)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(mr_rappro#671349)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(mr_numdos#671350)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(mr_numdos#671350)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(mr_numdem#671351)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(mr_numdem#671351)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(mr_lieu#671352)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(mr_lieu#671352)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(mr_numcd#671353)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(mr_numcd#671353)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(mr_sel_di#671354)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(mr_sel_di#671354)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(mr_repert#671355)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(mr_repert#671355)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(mr_nomfic#671356)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(mr_nomfic#671356)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(mr_reso_x#671357)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(mr_reso_x#671357)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(mr_reso_y#671358)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(mr_reso_y#671358)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(mr_taific#671359)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(mr_taific#671359)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(mr_datmaj#671360)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(mr_datmaj#671360)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(mr_heumaj#671361)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(mr_heumaj#671361)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(mr_coduti#671362)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(mr_coduti#671362)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(mr_sopclass#671363)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(mr_sopclass#671363)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(mr_reject#671364)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(mr_reject#671364)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(mr_hide#671365)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(mr_hide#671365)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(mr_bits_alloc#671366)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(mr_bits_alloc#671366)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(mr_n_echo#671367)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(mr_n_echo#671367)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(mr_cachedir#671368)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(mr_cachedir#671368)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(mr_markup_id#671369)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(mr_markup_id#671369)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(mr_img_pos#671370)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(mr_img_pos#671370)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(mr_img_ori#671371)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(mr_img_ori#671371)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(mr_pix_spacing#671372)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(mr_pix_spacing#671372)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(mr_later#671373)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(mr_later#671373)), 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 "mr_numstu", "mr_numser", "mr_numima", "mr_n_ima", "mr_sopuid", "mr_n_acq", "mr_datima", "mr_heuima", "mr_part10", "mr_nb_vig", "mr_imaeff", "mr_dateff", "mr_heueff", "mr_comm_1", "mr_rappro", "mr_numdos", "mr_numdem", "mr_lieu", "mr_numcd", "mr_sel_di", "mr_repert", "mr_nomfic", "mr_reso_x", "mr_reso_y", "mr_taific", "mr_datmaj", "mr_heumaj", "mr_coduti", "mr_sopclass", "mr_reject", "mr_hide", "mr_bits_alloc", "mr_n_echo", "mr_cachedir", "mr_markup_id", "mr_img_pos", "mr_img_ori", "mr_pix_spacing", "mr_later" FROM "xplore"."h_image") as x) [numPartitions=1] [mr_numstu#671335,mr_numser#671336,mr_numima#671337,mr_n_ima#671338,mr_sopuid#671339,mr_n_acq#671340,mr_datima#671341,mr_heuima#671342,mr_part10#671343,mr_nb_vig#671344,mr_imaeff#671345,mr_dateff#671346,mr_heueff#671347,mr_comm_1#671348,mr_rappro#671349,mr_numdos#671350,mr_numdem#671351,mr_lieu#671352,mr_numcd#671353,mr_sel_di#671354,mr_repert#671355,mr_nomfic#671356,mr_reso_x#671357,mr_reso_y#671358,... 15 more fields] PushedFilters: [], ReadSchema: struct<mr_numstu:string,mr_numser:string,mr_numima:string,mr_n_ima:string,mr_sopuid:string,mr_n_a...

WholeStageCodegen (1)

Project

Filter (((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(mr_numstu#671689)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(mr_numstu#671689)), MAIN) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(mr_numser#671690)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(mr_numser#671690)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(mr_numima#671691)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(mr_numima#671691)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(mr_n_ima#671692)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(mr_n_ima#671692)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(mr_sopuid#671693)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(mr_sopuid#671693)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(mr_n_acq#671694)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(mr_n_acq#671694)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(mr_datima#671695)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(mr_datima#671695)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(mr_heuima#671696)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(mr_heuima#671696)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(mr_part10#671697)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(mr_part10#671697)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(mr_nb_vig#671698)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(mr_nb_vig#671698)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(mr_imaeff#671699)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(mr_imaeff#671699)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(mr_dateff#671700)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(mr_dateff#671700)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(mr_heueff#671701)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(mr_heueff#671701)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(mr_comm_1#671702)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(mr_comm_1#671702)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(mr_rappro#671703)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(mr_rappro#671703)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(mr_numdos#671704)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(mr_numdos#671704)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(mr_numdem#671705)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(mr_numdem#671705)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(mr_lieu#671706)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(mr_lieu#671706)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(mr_numcd#671707)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(mr_numcd#671707)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(mr_sel_di#671708)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(mr_sel_di#671708)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(mr_repert#671709)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(mr_repert#671709)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(mr_nomfic#671710)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(mr_nomfic#671710)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(mr_reso_x#671711)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(mr_reso_x#671711)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(mr_reso_y#671712)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(mr_reso_y#671712)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(mr_taific#671713)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(mr_taific#671713)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(mr_datmaj#671714)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(mr_datmaj#671714)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(mr_heumaj#671715)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(mr_heumaj#671715)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(mr_coduti#671716)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(mr_coduti#671716)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(mr_sopclass#671717)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(mr_sopclass#671717)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(mr_reject#671718)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(mr_reject#671718)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(mr_hide#671719)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(mr_hide#671719)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(mr_bits_alloc#671720)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(mr_bits_alloc#671720)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(mr_n_echo#671721)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(mr_n_echo#671721)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(mr_cachedir#671722)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(mr_cachedir#671722)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(mr_markup_id#671723)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(mr_markup_id#671723)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(mr_img_pos#671724)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(mr_img_pos#671724)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(mr_img_ori#671725)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(mr_img_ori#671725)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(mr_pix_spacing#671726)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(mr_pix_spacing#671726)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(mr_later#671727)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(mr_later#671727)), 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 "mr_numstu", "mr_numser", "mr_numima", "mr_n_ima", "mr_sopuid", "mr_n_acq", "mr_datima", "mr_heuima", "mr_part10", "mr_nb_vig", "mr_imaeff", "mr_dateff", "mr_heueff", "mr_comm_1", "mr_rappro", "mr_numdos", "mr_numdem", "mr_lieu", "mr_numcd", "mr_sel_di", "mr_repert", "mr_nomfic", "mr_reso_x", "mr_reso_y", "mr_taific", "mr_datmaj", "mr_heumaj", "mr_coduti", "mr_sopclass", "mr_reject", "mr_hide", "mr_bits_alloc", "mr_n_echo", "mr_cachedir", "mr_markup_id", "mr_img_pos", "mr_img_ori", "mr_pix_spacing", "mr_later" FROM "xplore2"."h_image") as x) [numPartitions=1] [mr_numstu#671689,mr_numser#671690,mr_numima#671691,mr_n_ima#671692,mr_sopuid#671693,mr_n_acq#671694,mr_datima#671695,mr_heuima#671696,mr_part10#671697,mr_nb_vig#671698,mr_imaeff#671699,mr_dateff#671700,mr_heueff#671701,mr_comm_1#671702,mr_rappro#671703,mr_numdos#671704,mr_numdem#671705,mr_lieu#671706,mr_numcd#671707,mr_sel_di#671708,mr_repert#671709,mr_nomfic#671710,mr_reso_x#671711,mr_reso_y#671712,... 15 more fields] PushedFilters: [], ReadSchema: struct<mr_numstu:string,mr_numser:string,mr_numima:string,mr_n_ima:string,mr_sopuid:string,mr_n_a...

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 "mr_numstu", "mr_numser", "mr_numima", "mr_n_ima", "mr_sopuid", "mr_n_acq", "mr_datima", "mr_heuima", "mr_part10", "mr_nb_vig", "mr_imaeff", "mr_dateff", "mr_heueff", "mr_comm_1", "mr_rappro", "mr_numdos", "mr_numdem", "mr_lieu", "mr_numcd", "mr_sel_di", "mr_repert", "mr_nomfic", "mr_reso_x", "mr_reso_y", "mr_taific", "mr_datmaj", "mr_heumaj", "mr_coduti", "mr_sopclass", "mr_reject", "mr_hide", "mr_bits_alloc", "mr_n_echo", "mr_cachedir", "mr_markup_id", "mr_img_pos", "mr_img_ori", "mr_pix_spacing", "mr_later" FROM "xplore"."h_image") as x) [numPartitions=1]  (1)
               +- * Project (6)
                  +- * Filter (5)
                     +- * Scan JDBCRelation((SELECT "mr_numstu", "mr_numser", "mr_numima", "mr_n_ima", "mr_sopuid", "mr_n_acq", "mr_datima", "mr_heuima", "mr_part10", "mr_nb_vig", "mr_imaeff", "mr_dateff", "mr_heueff", "mr_comm_1", "mr_rappro", "mr_numdos", "mr_numdem", "mr_lieu", "mr_numcd", "mr_sel_di", "mr_repert", "mr_nomfic", "mr_reso_x", "mr_reso_y", "mr_taific", "mr_datmaj", "mr_heumaj", "mr_coduti", "mr_sopclass", "mr_reject", "mr_hide", "mr_bits_alloc", "mr_n_echo", "mr_cachedir", "mr_markup_id", "mr_img_pos", "mr_img_ori", "mr_pix_spacing", "mr_later" FROM "xplore2"."h_image") as x) [numPartitions=1]  (4)
+- == Initial Plan ==
   HashAggregate (15)
   +- Exchange (14)
      +- HashAggregate (13)
         +- Union (12)
            :- Project (3)
            :  +- Filter (2)
            :     +- Scan JDBCRelation((SELECT "mr_numstu", "mr_numser", "mr_numima", "mr_n_ima", "mr_sopuid", "mr_n_acq", "mr_datima", "mr_heuima", "mr_part10", "mr_nb_vig", "mr_imaeff", "mr_dateff", "mr_heueff", "mr_comm_1", "mr_rappro", "mr_numdos", "mr_numdem", "mr_lieu", "mr_numcd", "mr_sel_di", "mr_repert", "mr_nomfic", "mr_reso_x", "mr_reso_y", "mr_taific", "mr_datmaj", "mr_heumaj", "mr_coduti", "mr_sopclass", "mr_reject", "mr_hide", "mr_bits_alloc", "mr_n_echo", "mr_cachedir", "mr_markup_id", "mr_img_pos", "mr_img_ori", "mr_pix_spacing", "mr_later" FROM "xplore"."h_image") as x) [numPartitions=1]  (1)
            +- Project (6)
               +- Filter (5)
                  +- Scan JDBCRelation((SELECT "mr_numstu", "mr_numser", "mr_numima", "mr_n_ima", "mr_sopuid", "mr_n_acq", "mr_datima", "mr_heuima", "mr_part10", "mr_nb_vig", "mr_imaeff", "mr_dateff", "mr_heueff", "mr_comm_1", "mr_rappro", "mr_numdos", "mr_numdem", "mr_lieu", "mr_numcd", "mr_sel_di", "mr_repert", "mr_nomfic", "mr_reso_x", "mr_reso_y", "mr_taific", "mr_datmaj", "mr_heumaj", "mr_coduti", "mr_sopclass", "mr_reject", "mr_hide", "mr_bits_alloc", "mr_n_echo", "mr_cachedir", "mr_markup_id", "mr_img_pos", "mr_img_ori", "mr_pix_spacing", "mr_later" FROM "xplore2"."h_image") as x) [numPartitions=1]  (4)


(1) Scan JDBCRelation((SELECT "mr_numstu", "mr_numser", "mr_numima", "mr_n_ima", "mr_sopuid", "mr_n_acq", "mr_datima", "mr_heuima", "mr_part10", "mr_nb_vig", "mr_imaeff", "mr_dateff", "mr_heueff", "mr_comm_1", "mr_rappro", "mr_numdos", "mr_numdem", "mr_lieu", "mr_numcd", "mr_sel_di", "mr_repert", "mr_nomfic", "mr_reso_x", "mr_reso_y", "mr_taific", "mr_datmaj", "mr_heumaj", "mr_coduti", "mr_sopclass", "mr_reject", "mr_hide", "mr_bits_alloc", "mr_n_echo", "mr_cachedir", "mr_markup_id", "mr_img_pos", "mr_img_ori", "mr_pix_spacing", "mr_later" FROM "xplore"."h_image") as x) [numPartitions=1]  [codegen id : 1]
Output [39]: [mr_numstu#671335, mr_numser#671336, mr_numima#671337, mr_n_ima#671338, mr_sopuid#671339, mr_n_acq#671340, mr_datima#671341, mr_heuima#671342, mr_part10#671343, mr_nb_vig#671344, mr_imaeff#671345, mr_dateff#671346, mr_heueff#671347, mr_comm_1#671348, mr_rappro#671349, mr_numdos#671350, mr_numdem#671351, mr_lieu#671352, mr_numcd#671353, mr_sel_di#671354, mr_repert#671355, mr_nomfic#671356, mr_reso_x#671357, mr_reso_y#671358, mr_taific#671359, mr_datmaj#671360, mr_heumaj#671361, mr_coduti#671362, mr_sopclass#671363, mr_reject#671364, mr_hide#671365, mr_bits_alloc#671366, mr_n_echo#671367, mr_cachedir#671368, mr_markup_id#671369, mr_img_pos#671370, mr_img_ori#671371, mr_pix_spacing#671372, mr_later#671373]
ReadSchema: struct<mr_numstu:string,mr_numser:string,mr_numima:string,mr_n_ima:string,mr_sopuid:string,mr_n_acq:string,mr_datima:string,mr_heuima:string,mr_part10:string,mr_nb_vig:string,mr_imaeff:string,mr_dateff:string,mr_heueff:string,mr_comm_1:string,mr_rappro:string,mr_numdos:string,mr_numdem:string,mr_lieu:string,mr_numcd:string,mr_sel_di:string,mr_repert:string,mr_nomfic:string,mr_reso_x:string,mr_reso_y:string,mr_taific:string,mr_datmaj:string,mr_heumaj:string,mr_coduti:string,mr_sopclass:string,mr_reject:string,mr_hide:string,mr_bits_alloc:string,mr_n_echo:string,mr_cachedir:string,mr_markup_id:string,mr_img_pos:string,mr_img_ori:string,mr_pix_spacing:string,mr_later:string>

(2) Filter [codegen id : 1]
Input [39]: [mr_numstu#671335, mr_numser#671336, mr_numima#671337, mr_n_ima#671338, mr_sopuid#671339, mr_n_acq#671340, mr_datima#671341, mr_heuima#671342, mr_part10#671343, mr_nb_vig#671344, mr_imaeff#671345, mr_dateff#671346, mr_heueff#671347, mr_comm_1#671348, mr_rappro#671349, mr_numdos#671350, mr_numdem#671351, mr_lieu#671352, mr_numcd#671353, mr_sel_di#671354, mr_repert#671355, mr_nomfic#671356, mr_reso_x#671357, mr_reso_y#671358, mr_taific#671359, mr_datmaj#671360, mr_heumaj#671361, mr_coduti#671362, mr_sopclass#671363, mr_reject#671364, mr_hide#671365, mr_bits_alloc#671366, mr_n_echo#671367, mr_cachedir#671368, mr_markup_id#671369, mr_img_pos#671370, mr_img_ori#671371, mr_pix_spacing#671372, mr_later#671373]
Condition : (((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(mr_numstu#671335)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(mr_numstu#671335)), MAIN) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(mr_numser#671336)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(mr_numser#671336)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(mr_numima#671337)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(mr_numima#671337)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(mr_n_ima#671338)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(mr_n_ima#671338)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(mr_sopuid#671339)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(mr_sopuid#671339)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(mr_n_acq#671340)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(mr_n_acq#671340)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(mr_datima#671341)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(mr_datima#671341)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(mr_heuima#671342)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(mr_heuima#671342)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(mr_part10#671343)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(mr_part10#671343)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(mr_nb_vig#671344)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(mr_nb_vig#671344)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(mr_imaeff#671345)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(mr_imaeff#671345)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(mr_dateff#671346)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(mr_dateff#671346)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(mr_heueff#671347)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(mr_heueff#671347)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(mr_comm_1#671348)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(mr_comm_1#671348)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(mr_rappro#671349)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(mr_rappro#671349)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(mr_numdos#671350)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(mr_numdos#671350)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(mr_numdem#671351)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(mr_numdem#671351)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(mr_lieu#671352)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(mr_lieu#671352)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(mr_numcd#671353)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(mr_numcd#671353)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(mr_sel_di#671354)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(mr_sel_di#671354)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(mr_repert#671355)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(mr_repert#671355)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(mr_nomfic#671356)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(mr_nomfic#671356)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(mr_reso_x#671357)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(mr_reso_x#671357)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(mr_reso_y#671358)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(mr_reso_y#671358)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(mr_taific#671359)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(mr_taific#671359)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(mr_datmaj#671360)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(mr_datmaj#671360)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(mr_heumaj#671361)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(mr_heumaj#671361)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(mr_coduti#671362)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(mr_coduti#671362)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(mr_sopclass#671363)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(mr_sopclass#671363)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(mr_reject#671364)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(mr_reject#671364)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(mr_hide#671365)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(mr_hide#671365)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(mr_bits_alloc#671366)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(mr_bits_alloc#671366)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(mr_n_echo#671367)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(mr_n_echo#671367)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(mr_cachedir#671368)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(mr_cachedir#671368)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(mr_markup_id#671369)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(mr_markup_id#671369)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(mr_img_pos#671370)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(mr_img_pos#671370)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(mr_img_ori#671371)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(mr_img_ori#671371)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(mr_pix_spacing#671372)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(mr_pix_spacing#671372)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(mr_later#671373)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(mr_later#671373)), 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 [39]: [mr_numstu#671335, mr_numser#671336, mr_numima#671337, mr_n_ima#671338, mr_sopuid#671339, mr_n_acq#671340, mr_datima#671341, mr_heuima#671342, mr_part10#671343, mr_nb_vig#671344, mr_imaeff#671345, mr_dateff#671346, mr_heueff#671347, mr_comm_1#671348, mr_rappro#671349, mr_numdos#671350, mr_numdem#671351, mr_lieu#671352, mr_numcd#671353, mr_sel_di#671354, mr_repert#671355, mr_nomfic#671356, mr_reso_x#671357, mr_reso_y#671358, mr_taific#671359, mr_datmaj#671360, mr_heumaj#671361, mr_coduti#671362, mr_sopclass#671363, mr_reject#671364, mr_hide#671365, mr_bits_alloc#671366, mr_n_echo#671367, mr_cachedir#671368, mr_markup_id#671369, mr_img_pos#671370, mr_img_ori#671371, mr_pix_spacing#671372, mr_later#671373]

(4) Scan JDBCRelation((SELECT "mr_numstu", "mr_numser", "mr_numima", "mr_n_ima", "mr_sopuid", "mr_n_acq", "mr_datima", "mr_heuima", "mr_part10", "mr_nb_vig", "mr_imaeff", "mr_dateff", "mr_heueff", "mr_comm_1", "mr_rappro", "mr_numdos", "mr_numdem", "mr_lieu", "mr_numcd", "mr_sel_di", "mr_repert", "mr_nomfic", "mr_reso_x", "mr_reso_y", "mr_taific", "mr_datmaj", "mr_heumaj", "mr_coduti", "mr_sopclass", "mr_reject", "mr_hide", "mr_bits_alloc", "mr_n_echo", "mr_cachedir", "mr_markup_id", "mr_img_pos", "mr_img_ori", "mr_pix_spacing", "mr_later" FROM "xplore2"."h_image") as x) [numPartitions=1]  [codegen id : 2]
Output [39]: [mr_numstu#671689, mr_numser#671690, mr_numima#671691, mr_n_ima#671692, mr_sopuid#671693, mr_n_acq#671694, mr_datima#671695, mr_heuima#671696, mr_part10#671697, mr_nb_vig#671698, mr_imaeff#671699, mr_dateff#671700, mr_heueff#671701, mr_comm_1#671702, mr_rappro#671703, mr_numdos#671704, mr_numdem#671705, mr_lieu#671706, mr_numcd#671707, mr_sel_di#671708, mr_repert#671709, mr_nomfic#671710, mr_reso_x#671711, mr_reso_y#671712, mr_taific#671713, mr_datmaj#671714, mr_heumaj#671715, mr_coduti#671716, mr_sopclass#671717, mr_reject#671718, mr_hide#671719, mr_bits_alloc#671720, mr_n_echo#671721, mr_cachedir#671722, mr_markup_id#671723, mr_img_pos#671724, mr_img_ori#671725, mr_pix_spacing#671726, mr_later#671727]
ReadSchema: struct<mr_numstu:string,mr_numser:string,mr_numima:string,mr_n_ima:string,mr_sopuid:string,mr_n_acq:string,mr_datima:string,mr_heuima:string,mr_part10:string,mr_nb_vig:string,mr_imaeff:string,mr_dateff:string,mr_heueff:string,mr_comm_1:string,mr_rappro:string,mr_numdos:string,mr_numdem:string,mr_lieu:string,mr_numcd:string,mr_sel_di:string,mr_repert:string,mr_nomfic:string,mr_reso_x:string,mr_reso_y:string,mr_taific:string,mr_datmaj:string,mr_heumaj:string,mr_coduti:string,mr_sopclass:string,mr_reject:string,mr_hide:string,mr_bits_alloc:string,mr_n_echo:string,mr_cachedir:string,mr_markup_id:string,mr_img_pos:string,mr_img_ori:string,mr_pix_spacing:string,mr_later:string>

(5) Filter [codegen id : 2]
Input [39]: [mr_numstu#671689, mr_numser#671690, mr_numima#671691, mr_n_ima#671692, mr_sopuid#671693, mr_n_acq#671694, mr_datima#671695, mr_heuima#671696, mr_part10#671697, mr_nb_vig#671698, mr_imaeff#671699, mr_dateff#671700, mr_heueff#671701, mr_comm_1#671702, mr_rappro#671703, mr_numdos#671704, mr_numdem#671705, mr_lieu#671706, mr_numcd#671707, mr_sel_di#671708, mr_repert#671709, mr_nomfic#671710, mr_reso_x#671711, mr_reso_y#671712, mr_taific#671713, mr_datmaj#671714, mr_heumaj#671715, mr_coduti#671716, mr_sopclass#671717, mr_reject#671718, mr_hide#671719, mr_bits_alloc#671720, mr_n_echo#671721, mr_cachedir#671722, mr_markup_id#671723, mr_img_pos#671724, mr_img_ori#671725, mr_pix_spacing#671726, mr_later#671727]
Condition : (((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(mr_numstu#671689)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(mr_numstu#671689)), MAIN) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(mr_numser#671690)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(mr_numser#671690)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(mr_numima#671691)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(mr_numima#671691)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(mr_n_ima#671692)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(mr_n_ima#671692)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(mr_sopuid#671693)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(mr_sopuid#671693)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(mr_n_acq#671694)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(mr_n_acq#671694)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(mr_datima#671695)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(mr_datima#671695)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(mr_heuima#671696)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(mr_heuima#671696)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(mr_part10#671697)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(mr_part10#671697)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(mr_nb_vig#671698)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(mr_nb_vig#671698)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(mr_imaeff#671699)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(mr_imaeff#671699)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(mr_dateff#671700)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(mr_dateff#671700)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(mr_heueff#671701)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(mr_heueff#671701)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(mr_comm_1#671702)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(mr_comm_1#671702)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(mr_rappro#671703)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(mr_rappro#671703)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(mr_numdos#671704)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(mr_numdos#671704)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(mr_numdem#671705)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(mr_numdem#671705)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(mr_lieu#671706)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(mr_lieu#671706)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(mr_numcd#671707)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(mr_numcd#671707)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(mr_sel_di#671708)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(mr_sel_di#671708)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(mr_repert#671709)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(mr_repert#671709)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(mr_nomfic#671710)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(mr_nomfic#671710)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(mr_reso_x#671711)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(mr_reso_x#671711)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(mr_reso_y#671712)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(mr_reso_y#671712)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(mr_taific#671713)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(mr_taific#671713)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(mr_datmaj#671714)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(mr_datmaj#671714)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(mr_heumaj#671715)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(mr_heumaj#671715)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(mr_coduti#671716)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(mr_coduti#671716)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(mr_sopclass#671717)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(mr_sopclass#671717)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(mr_reject#671718)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(mr_reject#671718)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(mr_hide#671719)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(mr_hide#671719)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(mr_bits_alloc#671720)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(mr_bits_alloc#671720)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(mr_n_echo#671721)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(mr_n_echo#671721)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(mr_cachedir#671722)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(mr_cachedir#671722)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(mr_markup_id#671723)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(mr_markup_id#671723)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(mr_img_pos#671724)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(mr_img_pos#671724)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(mr_img_ori#671725)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(mr_img_ori#671725)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(mr_pix_spacing#671726)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(mr_pix_spacing#671726)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(mr_later#671727)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(mr_later#671727)), 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 [39]: [mr_numstu#671689, mr_numser#671690, mr_numima#671691, mr_n_ima#671692, mr_sopuid#671693, mr_n_acq#671694, mr_datima#671695, mr_heuima#671696, mr_part10#671697, mr_nb_vig#671698, mr_imaeff#671699, mr_dateff#671700, mr_heueff#671701, mr_comm_1#671702, mr_rappro#671703, mr_numdos#671704, mr_numdem#671705, mr_lieu#671706, mr_numcd#671707, mr_sel_di#671708, mr_repert#671709, mr_nomfic#671710, mr_reso_x#671711, mr_reso_y#671712, mr_taific#671713, mr_datmaj#671714, mr_heumaj#671715, mr_coduti#671716, mr_sopclass#671717, mr_reject#671718, mr_hide#671719, mr_bits_alloc#671720, mr_n_echo#671721, mr_cachedir#671722, mr_markup_id#671723, mr_img_pos#671724, mr_img_ori#671725, mr_pix_spacing#671726, mr_later#671727]

(7) Union

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

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

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

(11) HashAggregate [codegen id : 4]
Input [1]: [count#673851L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#672717L]
Results [1]: [count(1)#672717L AS COL_e00adb54-096f-4246-a5bd-110c02d60081#672719L]

(12) Union

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

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

(15) HashAggregate
Input [1]: [count#673851L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#672717L]
Results [1]: [count(1)#672717L AS COL_e00adb54-096f-4246-a5bd-110c02d60081#672719L]

(16) AdaptiveSparkPlan
Output [1]: [COL_e00adb54-096f-4246-a5bd-110c02d60081#672719L]
Arguments: isFinalPlan=true

SQL / DataFrame Properties

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