hdh-spark-job - Details for Query 1415

Submitted Time: 2026/10/23 13:29:10
Duration: 0.6 s
Succeeded Jobs: 1414 1415

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 2052.0: task 1791)) 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 2052.0: task 1790)) 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 2052.0: task 1790))"]; subgraph cluster4 { isCluster="true"; label="WholeStageCodegen (3)\n \nduration: total (min, med, max (stageId: taskId))\n9 ms (4 ms, 5 ms, 5 ms (stage 2052.0: task 1790))"; 5 [labelType="html" label="HashAggregate time in aggregation build total (min, med, max (stageId: taskId)) 9 ms (4 ms, 5 ms, 5 ms (stage 2052.0: task 1790)) number of output rows: 2"]; } 6 [labelType="html" label=" Union "]; subgraph cluster7 { isCluster="true"; label="WholeStageCodegen (1)\n \nduration: 5 ms"; 8 [labelType="html" label=" Project "]; 9 [labelType="html" label="Filter number of output rows: 0"]; 10 [labelType="html" label="Scan JDBCRelation((SELECT \"un_codser\", \"un_lib30\", \"un_libco\", \"un_serv\", \"un_nature\", \"un_valid\", \"un_uf_dem\", \"un_uf_exe\", \"un_uf_loc\", \"un_telbur\", \"un_fax\", \"un_e_mail\", \"un_envadm\", \"un_lieu_s\", \"un_coduti\", \"un_datmaj\", \"un_codsit\", \"un_modtrt\", \"un_dispre\", \"un_codsoc\", \"un_numcpt_a\", \"un_numcpt_f\", \"un_numcpt_c\", \"un_chefser\", \"un_datede\", \"un_datefi\", \"un_comment\", \"un_flicpt\", \"un_xml_p_cpta\", \"un_numprf\", \"un_cscpt\", \"un_csana\", \"un_codadm\", \"un_mod_envoi\", \"un_adr_1\", \"un_adr_2\", \"un_adr_3\", \"un_codpos\", \"un_ville\", \"un_pays\" FROM \"xplore\".\"h_unit\") as x) [numPartitions=1] number of output rows: 80"]; } subgraph cluster11 { isCluster="true"; label="WholeStageCodegen (2)\n \nduration: 4 ms"; 12 [labelType="html" label=" Project "]; 13 [labelType="html" label="Filter number of output rows: 0"]; 14 [labelType="html" label="Scan JDBCRelation((SELECT \"un_codser\", \"un_lib30\", \"un_libco\", \"un_serv\", \"un_nature\", \"un_valid\", \"un_uf_dem\", \"un_uf_exe\", \"un_uf_loc\", \"un_telbur\", \"un_fax\", \"un_e_mail\", \"un_envadm\", \"un_lieu_s\", \"un_coduti\", \"un_datmaj\", \"un_codsit\", \"un_modtrt\", \"un_dispre\", \"un_codsoc\", \"un_numcpt_a\", \"un_numcpt_f\", \"un_numcpt_c\", \"un_chefser\", \"un_datede\", \"un_datefi\", \"un_comment\", \"un_flicpt\", \"un_xml_p_cpta\", \"un_numprf\", \"un_cscpt\", \"un_csana\", \"un_codadm\", \"un_mod_envoi\", \"un_adr_1\", \"un_adr_2\", \"un_adr_3\", \"un_codpos\", \"un_ville\", \"un_pays\" FROM \"xplore2\".\"h_unit\") as x) [numPartitions=1] number of output rows: 80"]; } 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=38399]

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

WholeStageCodegen (3)

Union

Project

Filter ((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(un_codser#711257)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_codser#711257)), MAIN) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_lib30#711258)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_lib30#711258)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_libco#711259)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_libco#711259)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_serv#711260)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_serv#711260)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_nature#711261)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_nature#711261)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_valid#711262)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_valid#711262)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_uf_dem#711263)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_uf_dem#711263)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_uf_exe#711264)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_uf_exe#711264)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_uf_loc#711265)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_uf_loc#711265)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_telbur#711266)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_telbur#711266)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_fax#711267)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_fax#711267)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_e_mail#711268)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_e_mail#711268)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_envadm#711269)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_envadm#711269)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_lieu_s#711270)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_lieu_s#711270)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_coduti#711271)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_coduti#711271)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_datmaj#711272)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_datmaj#711272)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_codsit#711273)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_codsit#711273)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_modtrt#711274)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_modtrt#711274)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_dispre#711275)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_dispre#711275)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_codsoc#711276)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_codsoc#711276)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_numcpt_a#711277)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_numcpt_a#711277)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_numcpt_f#711278)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_numcpt_f#711278)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_numcpt_c#711279)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_numcpt_c#711279)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_chefser#711280)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_chefser#711280)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_datede#711281)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_datede#711281)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_datefi#711282)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_datefi#711282)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_comment#711283)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_comment#711283)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_flicpt#711284)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_flicpt#711284)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_xml_p_cpta#711285)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_xml_p_cpta#711285)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_numprf#711286)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_numprf#711286)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_cscpt#711287)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_cscpt#711287)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_csana#711288)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_csana#711288)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_codadm#711289)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_codadm#711289)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_mod_envoi#711290)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_mod_envoi#711290)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_adr_1#711291)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_adr_1#711291)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_adr_2#711292)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_adr_2#711292)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_adr_3#711293)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_adr_3#711293)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_codpos#711294)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_codpos#711294)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_ville#711295)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_ville#711295)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_pays#711296)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_pays#711296)), 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 "un_codser", "un_lib30", "un_libco", "un_serv", "un_nature", "un_valid", "un_uf_dem", "un_uf_exe", "un_uf_loc", "un_telbur", "un_fax", "un_e_mail", "un_envadm", "un_lieu_s", "un_coduti", "un_datmaj", "un_codsit", "un_modtrt", "un_dispre", "un_codsoc", "un_numcpt_a", "un_numcpt_f", "un_numcpt_c", "un_chefser", "un_datede", "un_datefi", "un_comment", "un_flicpt", "un_xml_p_cpta", "un_numprf", "un_cscpt", "un_csana", "un_codadm", "un_mod_envoi", "un_adr_1", "un_adr_2", "un_adr_3", "un_codpos", "un_ville", "un_pays" FROM "xplore"."h_unit") as x) [numPartitions=1] [un_codser#711257,un_lib30#711258,un_libco#711259,un_serv#711260,un_nature#711261,un_valid#711262,un_uf_dem#711263,un_uf_exe#711264,un_uf_loc#711265,un_telbur#711266,un_fax#711267,un_e_mail#711268,un_envadm#711269,un_lieu_s#711270,un_coduti#711271,un_datmaj#711272,un_codsit#711273,un_modtrt#711274,un_dispre#711275,un_codsoc#711276,un_numcpt_a#711277,un_numcpt_f#711278,un_numcpt_c#711279,un_chefser#711280,... 16 more fields] PushedFilters: [], ReadSchema: struct<un_codser:string,un_lib30:string,un_libco:string,un_serv:string,un_nature:string,un_valid:...

WholeStageCodegen (1)

Project

Filter ((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(un_codser#711620)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_codser#711620)), MAIN) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_lib30#711621)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_lib30#711621)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_libco#711622)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_libco#711622)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_serv#711623)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_serv#711623)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_nature#711624)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_nature#711624)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_valid#711625)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_valid#711625)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_uf_dem#711626)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_uf_dem#711626)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_uf_exe#711627)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_uf_exe#711627)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_uf_loc#711628)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_uf_loc#711628)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_telbur#711629)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_telbur#711629)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_fax#711630)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_fax#711630)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_e_mail#711631)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_e_mail#711631)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_envadm#711632)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_envadm#711632)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_lieu_s#711633)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_lieu_s#711633)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_coduti#711634)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_coduti#711634)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_datmaj#711635)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_datmaj#711635)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_codsit#711636)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_codsit#711636)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_modtrt#711637)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_modtrt#711637)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_dispre#711638)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_dispre#711638)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_codsoc#711639)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_codsoc#711639)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_numcpt_a#711640)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_numcpt_a#711640)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_numcpt_f#711641)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_numcpt_f#711641)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_numcpt_c#711642)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_numcpt_c#711642)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_chefser#711643)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_chefser#711643)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_datede#711644)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_datede#711644)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_datefi#711645)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_datefi#711645)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_comment#711646)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_comment#711646)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_flicpt#711647)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_flicpt#711647)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_xml_p_cpta#711648)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_xml_p_cpta#711648)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_numprf#711649)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_numprf#711649)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_cscpt#711650)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_cscpt#711650)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_csana#711651)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_csana#711651)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_codadm#711652)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_codadm#711652)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_mod_envoi#711653)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_mod_envoi#711653)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_adr_1#711654)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_adr_1#711654)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_adr_2#711655)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_adr_2#711655)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_adr_3#711656)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_adr_3#711656)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_codpos#711657)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_codpos#711657)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_ville#711658)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_ville#711658)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_pays#711659)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_pays#711659)), 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 "un_codser", "un_lib30", "un_libco", "un_serv", "un_nature", "un_valid", "un_uf_dem", "un_uf_exe", "un_uf_loc", "un_telbur", "un_fax", "un_e_mail", "un_envadm", "un_lieu_s", "un_coduti", "un_datmaj", "un_codsit", "un_modtrt", "un_dispre", "un_codsoc", "un_numcpt_a", "un_numcpt_f", "un_numcpt_c", "un_chefser", "un_datede", "un_datefi", "un_comment", "un_flicpt", "un_xml_p_cpta", "un_numprf", "un_cscpt", "un_csana", "un_codadm", "un_mod_envoi", "un_adr_1", "un_adr_2", "un_adr_3", "un_codpos", "un_ville", "un_pays" FROM "xplore2"."h_unit") as x) [numPartitions=1] [un_codser#711620,un_lib30#711621,un_libco#711622,un_serv#711623,un_nature#711624,un_valid#711625,un_uf_dem#711626,un_uf_exe#711627,un_uf_loc#711628,un_telbur#711629,un_fax#711630,un_e_mail#711631,un_envadm#711632,un_lieu_s#711633,un_coduti#711634,un_datmaj#711635,un_codsit#711636,un_modtrt#711637,un_dispre#711638,un_codsoc#711639,un_numcpt_a#711640,un_numcpt_f#711641,un_numcpt_c#711642,un_chefser#711643,... 16 more fields] PushedFilters: [], ReadSchema: struct<un_codser:string,un_lib30:string,un_libco:string,un_serv:string,un_nature:string,un_valid:...

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 "un_codser", "un_lib30", "un_libco", "un_serv", "un_nature", "un_valid", "un_uf_dem", "un_uf_exe", "un_uf_loc", "un_telbur", "un_fax", "un_e_mail", "un_envadm", "un_lieu_s", "un_coduti", "un_datmaj", "un_codsit", "un_modtrt", "un_dispre", "un_codsoc", "un_numcpt_a", "un_numcpt_f", "un_numcpt_c", "un_chefser", "un_datede", "un_datefi", "un_comment", "un_flicpt", "un_xml_p_cpta", "un_numprf", "un_cscpt", "un_csana", "un_codadm", "un_mod_envoi", "un_adr_1", "un_adr_2", "un_adr_3", "un_codpos", "un_ville", "un_pays" FROM "xplore"."h_unit") as x) [numPartitions=1]  (1)
               +- * Project (6)
                  +- * Filter (5)
                     +- * Scan JDBCRelation((SELECT "un_codser", "un_lib30", "un_libco", "un_serv", "un_nature", "un_valid", "un_uf_dem", "un_uf_exe", "un_uf_loc", "un_telbur", "un_fax", "un_e_mail", "un_envadm", "un_lieu_s", "un_coduti", "un_datmaj", "un_codsit", "un_modtrt", "un_dispre", "un_codsoc", "un_numcpt_a", "un_numcpt_f", "un_numcpt_c", "un_chefser", "un_datede", "un_datefi", "un_comment", "un_flicpt", "un_xml_p_cpta", "un_numprf", "un_cscpt", "un_csana", "un_codadm", "un_mod_envoi", "un_adr_1", "un_adr_2", "un_adr_3", "un_codpos", "un_ville", "un_pays" FROM "xplore2"."h_unit") as x) [numPartitions=1]  (4)
+- == Initial Plan ==
   HashAggregate (15)
   +- Exchange (14)
      +- HashAggregate (13)
         +- Union (12)
            :- Project (3)
            :  +- Filter (2)
            :     +- Scan JDBCRelation((SELECT "un_codser", "un_lib30", "un_libco", "un_serv", "un_nature", "un_valid", "un_uf_dem", "un_uf_exe", "un_uf_loc", "un_telbur", "un_fax", "un_e_mail", "un_envadm", "un_lieu_s", "un_coduti", "un_datmaj", "un_codsit", "un_modtrt", "un_dispre", "un_codsoc", "un_numcpt_a", "un_numcpt_f", "un_numcpt_c", "un_chefser", "un_datede", "un_datefi", "un_comment", "un_flicpt", "un_xml_p_cpta", "un_numprf", "un_cscpt", "un_csana", "un_codadm", "un_mod_envoi", "un_adr_1", "un_adr_2", "un_adr_3", "un_codpos", "un_ville", "un_pays" FROM "xplore"."h_unit") as x) [numPartitions=1]  (1)
            +- Project (6)
               +- Filter (5)
                  +- Scan JDBCRelation((SELECT "un_codser", "un_lib30", "un_libco", "un_serv", "un_nature", "un_valid", "un_uf_dem", "un_uf_exe", "un_uf_loc", "un_telbur", "un_fax", "un_e_mail", "un_envadm", "un_lieu_s", "un_coduti", "un_datmaj", "un_codsit", "un_modtrt", "un_dispre", "un_codsoc", "un_numcpt_a", "un_numcpt_f", "un_numcpt_c", "un_chefser", "un_datede", "un_datefi", "un_comment", "un_flicpt", "un_xml_p_cpta", "un_numprf", "un_cscpt", "un_csana", "un_codadm", "un_mod_envoi", "un_adr_1", "un_adr_2", "un_adr_3", "un_codpos", "un_ville", "un_pays" FROM "xplore2"."h_unit") as x) [numPartitions=1]  (4)


(1) Scan JDBCRelation((SELECT "un_codser", "un_lib30", "un_libco", "un_serv", "un_nature", "un_valid", "un_uf_dem", "un_uf_exe", "un_uf_loc", "un_telbur", "un_fax", "un_e_mail", "un_envadm", "un_lieu_s", "un_coduti", "un_datmaj", "un_codsit", "un_modtrt", "un_dispre", "un_codsoc", "un_numcpt_a", "un_numcpt_f", "un_numcpt_c", "un_chefser", "un_datede", "un_datefi", "un_comment", "un_flicpt", "un_xml_p_cpta", "un_numprf", "un_cscpt", "un_csana", "un_codadm", "un_mod_envoi", "un_adr_1", "un_adr_2", "un_adr_3", "un_codpos", "un_ville", "un_pays" FROM "xplore"."h_unit") as x) [numPartitions=1]  [codegen id : 1]
Output [40]: [un_codser#711257, un_lib30#711258, un_libco#711259, un_serv#711260, un_nature#711261, un_valid#711262, un_uf_dem#711263, un_uf_exe#711264, un_uf_loc#711265, un_telbur#711266, un_fax#711267, un_e_mail#711268, un_envadm#711269, un_lieu_s#711270, un_coduti#711271, un_datmaj#711272, un_codsit#711273, un_modtrt#711274, un_dispre#711275, un_codsoc#711276, un_numcpt_a#711277, un_numcpt_f#711278, un_numcpt_c#711279, un_chefser#711280, un_datede#711281, un_datefi#711282, un_comment#711283, un_flicpt#711284, un_xml_p_cpta#711285, un_numprf#711286, un_cscpt#711287, un_csana#711288, un_codadm#711289, un_mod_envoi#711290, un_adr_1#711291, un_adr_2#711292, un_adr_3#711293, un_codpos#711294, un_ville#711295, un_pays#711296]
ReadSchema: struct<un_codser:string,un_lib30:string,un_libco:string,un_serv:string,un_nature:string,un_valid:string,un_uf_dem:string,un_uf_exe:string,un_uf_loc:string,un_telbur:string,un_fax:string,un_e_mail:string,un_envadm:string,un_lieu_s:string,un_coduti:string,un_datmaj:string,un_codsit:string,un_modtrt:string,un_dispre:string,un_codsoc:string,un_numcpt_a:string,un_numcpt_f:string,un_numcpt_c:string,un_chefser:string,un_datede:string,un_datefi:string,un_comment:string,un_flicpt:string,un_xml_p_cpta:string,un_numprf:string,un_cscpt:string,un_csana:string,un_codadm:string,un_mod_envoi:string,un_adr_1:string,un_adr_2:string,un_adr_3:string,un_codpos:string,un_ville:string,un_pays:string>

(2) Filter [codegen id : 1]
Input [40]: [un_codser#711257, un_lib30#711258, un_libco#711259, un_serv#711260, un_nature#711261, un_valid#711262, un_uf_dem#711263, un_uf_exe#711264, un_uf_loc#711265, un_telbur#711266, un_fax#711267, un_e_mail#711268, un_envadm#711269, un_lieu_s#711270, un_coduti#711271, un_datmaj#711272, un_codsit#711273, un_modtrt#711274, un_dispre#711275, un_codsoc#711276, un_numcpt_a#711277, un_numcpt_f#711278, un_numcpt_c#711279, un_chefser#711280, un_datede#711281, un_datefi#711282, un_comment#711283, un_flicpt#711284, un_xml_p_cpta#711285, un_numprf#711286, un_cscpt#711287, un_csana#711288, un_codadm#711289, un_mod_envoi#711290, un_adr_1#711291, un_adr_2#711292, un_adr_3#711293, un_codpos#711294, un_ville#711295, un_pays#711296]
Condition : ((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(un_codser#711257)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_codser#711257)), MAIN) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_lib30#711258)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_lib30#711258)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_libco#711259)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_libco#711259)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_serv#711260)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_serv#711260)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_nature#711261)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_nature#711261)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_valid#711262)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_valid#711262)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_uf_dem#711263)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_uf_dem#711263)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_uf_exe#711264)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_uf_exe#711264)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_uf_loc#711265)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_uf_loc#711265)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_telbur#711266)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_telbur#711266)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_fax#711267)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_fax#711267)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_e_mail#711268)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_e_mail#711268)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_envadm#711269)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_envadm#711269)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_lieu_s#711270)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_lieu_s#711270)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_coduti#711271)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_coduti#711271)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_datmaj#711272)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_datmaj#711272)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_codsit#711273)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_codsit#711273)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_modtrt#711274)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_modtrt#711274)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_dispre#711275)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_dispre#711275)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_codsoc#711276)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_codsoc#711276)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_numcpt_a#711277)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_numcpt_a#711277)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_numcpt_f#711278)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_numcpt_f#711278)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_numcpt_c#711279)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_numcpt_c#711279)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_chefser#711280)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_chefser#711280)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_datede#711281)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_datede#711281)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_datefi#711282)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_datefi#711282)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_comment#711283)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_comment#711283)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_flicpt#711284)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_flicpt#711284)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_xml_p_cpta#711285)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_xml_p_cpta#711285)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_numprf#711286)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_numprf#711286)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_cscpt#711287)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_cscpt#711287)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_csana#711288)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_csana#711288)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_codadm#711289)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_codadm#711289)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_mod_envoi#711290)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_mod_envoi#711290)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_adr_1#711291)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_adr_1#711291)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_adr_2#711292)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_adr_2#711292)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_adr_3#711293)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_adr_3#711293)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_codpos#711294)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_codpos#711294)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_ville#711295)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_ville#711295)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_pays#711296)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_pays#711296)), 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 [40]: [un_codser#711257, un_lib30#711258, un_libco#711259, un_serv#711260, un_nature#711261, un_valid#711262, un_uf_dem#711263, un_uf_exe#711264, un_uf_loc#711265, un_telbur#711266, un_fax#711267, un_e_mail#711268, un_envadm#711269, un_lieu_s#711270, un_coduti#711271, un_datmaj#711272, un_codsit#711273, un_modtrt#711274, un_dispre#711275, un_codsoc#711276, un_numcpt_a#711277, un_numcpt_f#711278, un_numcpt_c#711279, un_chefser#711280, un_datede#711281, un_datefi#711282, un_comment#711283, un_flicpt#711284, un_xml_p_cpta#711285, un_numprf#711286, un_cscpt#711287, un_csana#711288, un_codadm#711289, un_mod_envoi#711290, un_adr_1#711291, un_adr_2#711292, un_adr_3#711293, un_codpos#711294, un_ville#711295, un_pays#711296]

(4) Scan JDBCRelation((SELECT "un_codser", "un_lib30", "un_libco", "un_serv", "un_nature", "un_valid", "un_uf_dem", "un_uf_exe", "un_uf_loc", "un_telbur", "un_fax", "un_e_mail", "un_envadm", "un_lieu_s", "un_coduti", "un_datmaj", "un_codsit", "un_modtrt", "un_dispre", "un_codsoc", "un_numcpt_a", "un_numcpt_f", "un_numcpt_c", "un_chefser", "un_datede", "un_datefi", "un_comment", "un_flicpt", "un_xml_p_cpta", "un_numprf", "un_cscpt", "un_csana", "un_codadm", "un_mod_envoi", "un_adr_1", "un_adr_2", "un_adr_3", "un_codpos", "un_ville", "un_pays" FROM "xplore2"."h_unit") as x) [numPartitions=1]  [codegen id : 2]
Output [40]: [un_codser#711620, un_lib30#711621, un_libco#711622, un_serv#711623, un_nature#711624, un_valid#711625, un_uf_dem#711626, un_uf_exe#711627, un_uf_loc#711628, un_telbur#711629, un_fax#711630, un_e_mail#711631, un_envadm#711632, un_lieu_s#711633, un_coduti#711634, un_datmaj#711635, un_codsit#711636, un_modtrt#711637, un_dispre#711638, un_codsoc#711639, un_numcpt_a#711640, un_numcpt_f#711641, un_numcpt_c#711642, un_chefser#711643, un_datede#711644, un_datefi#711645, un_comment#711646, un_flicpt#711647, un_xml_p_cpta#711648, un_numprf#711649, un_cscpt#711650, un_csana#711651, un_codadm#711652, un_mod_envoi#711653, un_adr_1#711654, un_adr_2#711655, un_adr_3#711656, un_codpos#711657, un_ville#711658, un_pays#711659]
ReadSchema: struct<un_codser:string,un_lib30:string,un_libco:string,un_serv:string,un_nature:string,un_valid:string,un_uf_dem:string,un_uf_exe:string,un_uf_loc:string,un_telbur:string,un_fax:string,un_e_mail:string,un_envadm:string,un_lieu_s:string,un_coduti:string,un_datmaj:string,un_codsit:string,un_modtrt:string,un_dispre:string,un_codsoc:string,un_numcpt_a:string,un_numcpt_f:string,un_numcpt_c:string,un_chefser:string,un_datede:string,un_datefi:string,un_comment:string,un_flicpt:string,un_xml_p_cpta:string,un_numprf:string,un_cscpt:string,un_csana:string,un_codadm:string,un_mod_envoi:string,un_adr_1:string,un_adr_2:string,un_adr_3:string,un_codpos:string,un_ville:string,un_pays:string>

(5) Filter [codegen id : 2]
Input [40]: [un_codser#711620, un_lib30#711621, un_libco#711622, un_serv#711623, un_nature#711624, un_valid#711625, un_uf_dem#711626, un_uf_exe#711627, un_uf_loc#711628, un_telbur#711629, un_fax#711630, un_e_mail#711631, un_envadm#711632, un_lieu_s#711633, un_coduti#711634, un_datmaj#711635, un_codsit#711636, un_modtrt#711637, un_dispre#711638, un_codsoc#711639, un_numcpt_a#711640, un_numcpt_f#711641, un_numcpt_c#711642, un_chefser#711643, un_datede#711644, un_datefi#711645, un_comment#711646, un_flicpt#711647, un_xml_p_cpta#711648, un_numprf#711649, un_cscpt#711650, un_csana#711651, un_codadm#711652, un_mod_envoi#711653, un_adr_1#711654, un_adr_2#711655, un_adr_3#711656, un_codpos#711657, un_ville#711658, un_pays#711659]
Condition : ((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(un_codser#711620)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_codser#711620)), MAIN) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_lib30#711621)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_lib30#711621)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_libco#711622)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_libco#711622)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_serv#711623)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_serv#711623)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_nature#711624)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_nature#711624)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_valid#711625)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_valid#711625)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_uf_dem#711626)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_uf_dem#711626)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_uf_exe#711627)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_uf_exe#711627)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_uf_loc#711628)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_uf_loc#711628)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_telbur#711629)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_telbur#711629)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_fax#711630)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_fax#711630)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_e_mail#711631)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_e_mail#711631)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_envadm#711632)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_envadm#711632)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_lieu_s#711633)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_lieu_s#711633)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_coduti#711634)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_coduti#711634)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_datmaj#711635)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_datmaj#711635)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_codsit#711636)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_codsit#711636)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_modtrt#711637)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_modtrt#711637)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_dispre#711638)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_dispre#711638)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_codsoc#711639)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_codsoc#711639)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_numcpt_a#711640)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_numcpt_a#711640)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_numcpt_f#711641)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_numcpt_f#711641)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_numcpt_c#711642)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_numcpt_c#711642)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_chefser#711643)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_chefser#711643)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_datede#711644)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_datede#711644)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_datefi#711645)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_datefi#711645)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_comment#711646)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_comment#711646)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_flicpt#711647)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_flicpt#711647)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_xml_p_cpta#711648)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_xml_p_cpta#711648)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_numprf#711649)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_numprf#711649)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_cscpt#711650)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_cscpt#711650)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_csana#711651)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_csana#711651)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_codadm#711652)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_codadm#711652)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_mod_envoi#711653)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_mod_envoi#711653)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_adr_1#711654)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_adr_1#711654)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_adr_2#711655)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_adr_2#711655)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_adr_3#711656)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_adr_3#711656)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_codpos#711657)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_codpos#711657)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_ville#711658)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_ville#711658)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_pays#711659)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_pays#711659)), 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 [40]: [un_codser#711620, un_lib30#711621, un_libco#711622, un_serv#711623, un_nature#711624, un_valid#711625, un_uf_dem#711626, un_uf_exe#711627, un_uf_loc#711628, un_telbur#711629, un_fax#711630, un_e_mail#711631, un_envadm#711632, un_lieu_s#711633, un_coduti#711634, un_datmaj#711635, un_codsit#711636, un_modtrt#711637, un_dispre#711638, un_codsoc#711639, un_numcpt_a#711640, un_numcpt_f#711641, un_numcpt_c#711642, un_chefser#711643, un_datede#711644, un_datefi#711645, un_comment#711646, un_flicpt#711647, un_xml_p_cpta#711648, un_numprf#711649, un_cscpt#711650, un_csana#711651, un_codadm#711652, un_mod_envoi#711653, un_adr_1#711654, un_adr_2#711655, un_adr_3#711656, un_codpos#711657, un_ville#711658, un_pays#711659]

(7) Union

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

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

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

(11) HashAggregate [codegen id : 4]
Input [1]: [count#712401L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#712311L]
Results [1]: [count(1)#712311L AS COL_90de34d9-320e-4264-b409-6bda290e51c0#712313L]

(12) Union

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

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

(15) HashAggregate
Input [1]: [count#712401L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#712311L]
Results [1]: [count(1)#712311L AS COL_90de34d9-320e-4264-b409-6bda290e51c0#712313L]

(16) AdaptiveSparkPlan
Output [1]: [COL_90de34d9-320e-4264-b409-6bda290e51c0#712313L]
Arguments: isFinalPlan=true

SQL / DataFrame Properties

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