hdh-spark-job - Details for Query 1460

Submitted Time: 2026/10/23 13:29:38
Duration: 1 s
Succeeded Jobs: 1456 1460

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

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

WholeStageCodegen (3)

Union

Project

Filter ((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(un_codser#746386)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_codser#746386)), MAIN) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_lib30#746387)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_lib30#746387)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_libco#746388)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_libco#746388)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_serv#746389)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_serv#746389)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_nature#746390)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_nature#746390)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_valid#746391)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_valid#746391)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_uf_dem#746392)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_uf_dem#746392)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_uf_exe#746393)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_uf_exe#746393)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_uf_loc#746394)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_uf_loc#746394)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_telbur#746395)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_telbur#746395)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_fax#746396)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_fax#746396)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_e_mail#746397)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_e_mail#746397)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_envadm#746398)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_envadm#746398)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_lieu_s#746399)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_lieu_s#746399)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_coduti#746400)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_coduti#746400)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_datmaj#746401)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_datmaj#746401)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_codsit#746402)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_codsit#746402)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_modtrt#746403)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_modtrt#746403)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_dispre#746404)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_dispre#746404)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_codsoc#746405)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_codsoc#746405)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_numcpt_a#746406)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_numcpt_a#746406)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_numcpt_f#746407)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_numcpt_f#746407)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_numcpt_c#746408)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_numcpt_c#746408)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_chefser#746409)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_chefser#746409)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_datede#746410)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_datede#746410)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_datefi#746411)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_datefi#746411)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_comment#746412)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_comment#746412)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_flicpt#746413)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_flicpt#746413)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_xml_p_cpta#746414)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_xml_p_cpta#746414)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_numprf#746415)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_numprf#746415)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_cscpt#746416)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_cscpt#746416)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_csana#746417)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_csana#746417)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_codadm#746418)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_codadm#746418)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_mod_envoi#746419)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_mod_envoi#746419)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_adr_1#746420)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_adr_1#746420)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_adr_2#746421)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_adr_2#746421)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_adr_3#746422)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_adr_3#746422)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_codpos#746423)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_codpos#746423)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_ville#746424)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_ville#746424)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_pays#746425)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_pays#746425)), 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#746386,un_lib30#746387,un_libco#746388,un_serv#746389,un_nature#746390,un_valid#746391,un_uf_dem#746392,un_uf_exe#746393,un_uf_loc#746394,un_telbur#746395,un_fax#746396,un_e_mail#746397,un_envadm#746398,un_lieu_s#746399,un_coduti#746400,un_datmaj#746401,un_codsit#746402,un_modtrt#746403,un_dispre#746404,un_codsoc#746405,un_numcpt_a#746406,un_numcpt_f#746407,un_numcpt_c#746408,un_chefser#746409,... 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#746836)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_codser#746836)), MAIN) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_lib30#746837)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_lib30#746837)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_libco#746838)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_libco#746838)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_serv#746839)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_serv#746839)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_nature#746840)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_nature#746840)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_valid#746841)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_valid#746841)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_uf_dem#746842)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_uf_dem#746842)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_uf_exe#746843)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_uf_exe#746843)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_uf_loc#746844)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_uf_loc#746844)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_telbur#746845)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_telbur#746845)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_fax#746846)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_fax#746846)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_e_mail#746847)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_e_mail#746847)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_envadm#746848)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_envadm#746848)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_lieu_s#746849)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_lieu_s#746849)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_coduti#746850)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_coduti#746850)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_datmaj#746851)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_datmaj#746851)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_codsit#746852)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_codsit#746852)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_modtrt#746853)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_modtrt#746853)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_dispre#746854)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_dispre#746854)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_codsoc#746855)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_codsoc#746855)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_numcpt_a#746856)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_numcpt_a#746856)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_numcpt_f#746857)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_numcpt_f#746857)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_numcpt_c#746858)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_numcpt_c#746858)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_chefser#746859)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_chefser#746859)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_datede#746860)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_datede#746860)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_datefi#746861)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_datefi#746861)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_comment#746862)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_comment#746862)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_flicpt#746863)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_flicpt#746863)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_xml_p_cpta#746864)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_xml_p_cpta#746864)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_numprf#746865)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_numprf#746865)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_cscpt#746866)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_cscpt#746866)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_csana#746867)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_csana#746867)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_codadm#746868)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_codadm#746868)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_mod_envoi#746869)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_mod_envoi#746869)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_adr_1#746870)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_adr_1#746870)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_adr_2#746871)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_adr_2#746871)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_adr_3#746872)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_adr_3#746872)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_codpos#746873)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_codpos#746873)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_ville#746874)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_ville#746874)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_pays#746875)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_pays#746875)), 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#746836,un_lib30#746837,un_libco#746838,un_serv#746839,un_nature#746840,un_valid#746841,un_uf_dem#746842,un_uf_exe#746843,un_uf_loc#746844,un_telbur#746845,un_fax#746846,un_e_mail#746847,un_envadm#746848,un_lieu_s#746849,un_coduti#746850,un_datmaj#746851,un_codsit#746852,un_modtrt#746853,un_dispre#746854,un_codsoc#746855,un_numcpt_a#746856,un_numcpt_f#746857,un_numcpt_c#746858,un_chefser#746859,... 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#746386, un_lib30#746387, un_libco#746388, un_serv#746389, un_nature#746390, un_valid#746391, un_uf_dem#746392, un_uf_exe#746393, un_uf_loc#746394, un_telbur#746395, un_fax#746396, un_e_mail#746397, un_envadm#746398, un_lieu_s#746399, un_coduti#746400, un_datmaj#746401, un_codsit#746402, un_modtrt#746403, un_dispre#746404, un_codsoc#746405, un_numcpt_a#746406, un_numcpt_f#746407, un_numcpt_c#746408, un_chefser#746409, un_datede#746410, un_datefi#746411, un_comment#746412, un_flicpt#746413, un_xml_p_cpta#746414, un_numprf#746415, un_cscpt#746416, un_csana#746417, un_codadm#746418, un_mod_envoi#746419, un_adr_1#746420, un_adr_2#746421, un_adr_3#746422, un_codpos#746423, un_ville#746424, un_pays#746425]
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#746386, un_lib30#746387, un_libco#746388, un_serv#746389, un_nature#746390, un_valid#746391, un_uf_dem#746392, un_uf_exe#746393, un_uf_loc#746394, un_telbur#746395, un_fax#746396, un_e_mail#746397, un_envadm#746398, un_lieu_s#746399, un_coduti#746400, un_datmaj#746401, un_codsit#746402, un_modtrt#746403, un_dispre#746404, un_codsoc#746405, un_numcpt_a#746406, un_numcpt_f#746407, un_numcpt_c#746408, un_chefser#746409, un_datede#746410, un_datefi#746411, un_comment#746412, un_flicpt#746413, un_xml_p_cpta#746414, un_numprf#746415, un_cscpt#746416, un_csana#746417, un_codadm#746418, un_mod_envoi#746419, un_adr_1#746420, un_adr_2#746421, un_adr_3#746422, un_codpos#746423, un_ville#746424, un_pays#746425]
Condition : ((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(un_codser#746386)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_codser#746386)), MAIN) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_lib30#746387)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_lib30#746387)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_libco#746388)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_libco#746388)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_serv#746389)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_serv#746389)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_nature#746390)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_nature#746390)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_valid#746391)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_valid#746391)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_uf_dem#746392)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_uf_dem#746392)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_uf_exe#746393)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_uf_exe#746393)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_uf_loc#746394)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_uf_loc#746394)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_telbur#746395)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_telbur#746395)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_fax#746396)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_fax#746396)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_e_mail#746397)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_e_mail#746397)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_envadm#746398)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_envadm#746398)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_lieu_s#746399)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_lieu_s#746399)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_coduti#746400)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_coduti#746400)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_datmaj#746401)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_datmaj#746401)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_codsit#746402)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_codsit#746402)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_modtrt#746403)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_modtrt#746403)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_dispre#746404)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_dispre#746404)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_codsoc#746405)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_codsoc#746405)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_numcpt_a#746406)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_numcpt_a#746406)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_numcpt_f#746407)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_numcpt_f#746407)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_numcpt_c#746408)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_numcpt_c#746408)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_chefser#746409)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_chefser#746409)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_datede#746410)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_datede#746410)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_datefi#746411)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_datefi#746411)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_comment#746412)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_comment#746412)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_flicpt#746413)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_flicpt#746413)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_xml_p_cpta#746414)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_xml_p_cpta#746414)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_numprf#746415)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_numprf#746415)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_cscpt#746416)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_cscpt#746416)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_csana#746417)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_csana#746417)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_codadm#746418)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_codadm#746418)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_mod_envoi#746419)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_mod_envoi#746419)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_adr_1#746420)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_adr_1#746420)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_adr_2#746421)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_adr_2#746421)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_adr_3#746422)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_adr_3#746422)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_codpos#746423)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_codpos#746423)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_ville#746424)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_ville#746424)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_pays#746425)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_pays#746425)), 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#746386, un_lib30#746387, un_libco#746388, un_serv#746389, un_nature#746390, un_valid#746391, un_uf_dem#746392, un_uf_exe#746393, un_uf_loc#746394, un_telbur#746395, un_fax#746396, un_e_mail#746397, un_envadm#746398, un_lieu_s#746399, un_coduti#746400, un_datmaj#746401, un_codsit#746402, un_modtrt#746403, un_dispre#746404, un_codsoc#746405, un_numcpt_a#746406, un_numcpt_f#746407, un_numcpt_c#746408, un_chefser#746409, un_datede#746410, un_datefi#746411, un_comment#746412, un_flicpt#746413, un_xml_p_cpta#746414, un_numprf#746415, un_cscpt#746416, un_csana#746417, un_codadm#746418, un_mod_envoi#746419, un_adr_1#746420, un_adr_2#746421, un_adr_3#746422, un_codpos#746423, un_ville#746424, un_pays#746425]

(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#746836, un_lib30#746837, un_libco#746838, un_serv#746839, un_nature#746840, un_valid#746841, un_uf_dem#746842, un_uf_exe#746843, un_uf_loc#746844, un_telbur#746845, un_fax#746846, un_e_mail#746847, un_envadm#746848, un_lieu_s#746849, un_coduti#746850, un_datmaj#746851, un_codsit#746852, un_modtrt#746853, un_dispre#746854, un_codsoc#746855, un_numcpt_a#746856, un_numcpt_f#746857, un_numcpt_c#746858, un_chefser#746859, un_datede#746860, un_datefi#746861, un_comment#746862, un_flicpt#746863, un_xml_p_cpta#746864, un_numprf#746865, un_cscpt#746866, un_csana#746867, un_codadm#746868, un_mod_envoi#746869, un_adr_1#746870, un_adr_2#746871, un_adr_3#746872, un_codpos#746873, un_ville#746874, un_pays#746875]
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#746836, un_lib30#746837, un_libco#746838, un_serv#746839, un_nature#746840, un_valid#746841, un_uf_dem#746842, un_uf_exe#746843, un_uf_loc#746844, un_telbur#746845, un_fax#746846, un_e_mail#746847, un_envadm#746848, un_lieu_s#746849, un_coduti#746850, un_datmaj#746851, un_codsit#746852, un_modtrt#746853, un_dispre#746854, un_codsoc#746855, un_numcpt_a#746856, un_numcpt_f#746857, un_numcpt_c#746858, un_chefser#746859, un_datede#746860, un_datefi#746861, un_comment#746862, un_flicpt#746863, un_xml_p_cpta#746864, un_numprf#746865, un_cscpt#746866, un_csana#746867, un_codadm#746868, un_mod_envoi#746869, un_adr_1#746870, un_adr_2#746871, un_adr_3#746872, un_codpos#746873, un_ville#746874, un_pays#746875]
Condition : ((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(un_codser#746836)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_codser#746836)), MAIN) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_lib30#746837)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_lib30#746837)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_libco#746838)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_libco#746838)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_serv#746839)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_serv#746839)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_nature#746840)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_nature#746840)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_valid#746841)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_valid#746841)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_uf_dem#746842)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_uf_dem#746842)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_uf_exe#746843)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_uf_exe#746843)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_uf_loc#746844)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_uf_loc#746844)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_telbur#746845)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_telbur#746845)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_fax#746846)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_fax#746846)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_e_mail#746847)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_e_mail#746847)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_envadm#746848)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_envadm#746848)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_lieu_s#746849)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_lieu_s#746849)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_coduti#746850)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_coduti#746850)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_datmaj#746851)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_datmaj#746851)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_codsit#746852)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_codsit#746852)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_modtrt#746853)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_modtrt#746853)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_dispre#746854)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_dispre#746854)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_codsoc#746855)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_codsoc#746855)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_numcpt_a#746856)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_numcpt_a#746856)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_numcpt_f#746857)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_numcpt_f#746857)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_numcpt_c#746858)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_numcpt_c#746858)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_chefser#746859)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_chefser#746859)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_datede#746860)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_datede#746860)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_datefi#746861)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_datefi#746861)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_comment#746862)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_comment#746862)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_flicpt#746863)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_flicpt#746863)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_xml_p_cpta#746864)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_xml_p_cpta#746864)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_numprf#746865)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_numprf#746865)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_cscpt#746866)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_cscpt#746866)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_csana#746867)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_csana#746867)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_codadm#746868)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_codadm#746868)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_mod_envoi#746869)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_mod_envoi#746869)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_adr_1#746870)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_adr_1#746870)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_adr_2#746871)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_adr_2#746871)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_adr_3#746872)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_adr_3#746872)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_codpos#746873)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_codpos#746873)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_ville#746874)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_ville#746874)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_pays#746875)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_pays#746875)), 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#746836, un_lib30#746837, un_libco#746838, un_serv#746839, un_nature#746840, un_valid#746841, un_uf_dem#746842, un_uf_exe#746843, un_uf_loc#746844, un_telbur#746845, un_fax#746846, un_e_mail#746847, un_envadm#746848, un_lieu_s#746849, un_coduti#746850, un_datmaj#746851, un_codsit#746852, un_modtrt#746853, un_dispre#746854, un_codsoc#746855, un_numcpt_a#746856, un_numcpt_f#746857, un_numcpt_c#746858, un_chefser#746859, un_datede#746860, un_datefi#746861, un_comment#746862, un_flicpt#746863, un_xml_p_cpta#746864, un_numprf#746865, un_cscpt#746866, un_csana#746867, un_codadm#746868, un_mod_envoi#746869, un_adr_1#746870, un_adr_2#746871, un_adr_3#746872, un_codpos#746873, un_ville#746874, un_pays#746875]

(7) Union

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

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

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

(11) HashAggregate [codegen id : 4]
Input [1]: [count#747621L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#747531L]
Results [1]: [count(1)#747531L AS COL_457ee768-2440-4712-9622-d76f617b3152#747533L]

(12) Union

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

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

(15) HashAggregate
Input [1]: [count#747621L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#747531L]
Results [1]: [count(1)#747531L AS COL_457ee768-2440-4712-9622-d76f617b3152#747533L]

(16) AdaptiveSparkPlan
Output [1]: [COL_457ee768-2440-4712-9622-d76f617b3152#747533L]
Arguments: isFinalPlan=true

SQL / DataFrame Properties

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