hdh-spark-job - Details for Query 1304

Submitted Time: 2026/10/23 13:26:31
Duration: 0.7 s
Succeeded Jobs: 1306 1308

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)) 2 ms (0 ms, 2 ms, 2 ms (stage 1880.0: task 1638)) remote merged bytes read: 0.0 B local merged blocks fetched: 0 corrupt merged block chunks: 0 remote merged reqs duration: 0 ms remote merged blocks fetched: 0 records read: 2 local bytes read: 118.0 B fetch wait time: 0 ms remote bytes read: 0.0 B merged fetch fallback count: 0 local blocks read: 2 remote merged chunks fetched: 0 remote blocks read: 0 data size total (min, med, max (stageId: taskId)) 32.0 B (16.0 B, 16.0 B, 16.0 B (stage 1880.0: task 1637)) local merged bytes read: 0.0 B number of partitions: 1 remote reqs duration: 0 ms remote bytes read to disk: 0.0 B shuffle bytes written total (min, med, max (stageId: taskId)) 118.0 B (59.0 B, 59.0 B, 59.0 B (stage 1880.0: task 1637))"]; subgraph cluster4 { isCluster="true"; label="WholeStageCodegen (3)\n \nduration: total (min, med, max (stageId: taskId))\n6 ms (3 ms, 3 ms, 3 ms (stage 1880.0: task 1637))"; 5 [labelType="html" label="HashAggregate time in aggregation build total (min, med, max (stageId: taskId)) 5 ms (2 ms, 3 ms, 3 ms (stage 1880.0: task 1637)) number of output rows: 2"]; } 6 [labelType="html" label=" Union "]; subgraph cluster7 { isCluster="true"; label="WholeStageCodegen (1)\n \nduration: 3 ms"; 8 [labelType="html" label=" Project "]; 9 [labelType="html" label="Filter number of output rows: 78"]; 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: 3 ms"; 12 [labelType="html" label=" Project "]; 13 [labelType="html" label="Filter number of output rows: 78"]; 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=34675]

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

WholeStageCodegen (3)

Union

Project

Filter ((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(un_codser#632293)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(un_codser#632293)), MARX) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_lib30#632294)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(un_lib30#632294)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_libco#632295)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(un_libco#632295)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_serv#632296)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(un_serv#632296)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_nature#632297)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(un_nature#632297)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_valid#632298)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(un_valid#632298)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_uf_dem#632299)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(un_uf_dem#632299)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_uf_exe#632300)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(un_uf_exe#632300)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_uf_loc#632301)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(un_uf_loc#632301)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_telbur#632302)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(un_telbur#632302)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_fax#632303)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(un_fax#632303)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_e_mail#632304)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(un_e_mail#632304)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_envadm#632305)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(un_envadm#632305)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_lieu_s#632306)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(un_lieu_s#632306)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_coduti#632307)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(un_coduti#632307)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_datmaj#632308)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(un_datmaj#632308)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_codsit#632309)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(un_codsit#632309)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_modtrt#632310)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(un_modtrt#632310)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_dispre#632311)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(un_dispre#632311)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_codsoc#632312)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(un_codsoc#632312)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_numcpt_a#632313)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(un_numcpt_a#632313)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_numcpt_f#632314)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(un_numcpt_f#632314)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_numcpt_c#632315)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(un_numcpt_c#632315)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_chefser#632316)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(un_chefser#632316)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_datede#632317)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(un_datede#632317)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_datefi#632318)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(un_datefi#632318)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_comment#632319)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(un_comment#632319)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_flicpt#632320)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(un_flicpt#632320)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_xml_p_cpta#632321)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(un_xml_p_cpta#632321)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_numprf#632322)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(un_numprf#632322)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_cscpt#632323)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(un_cscpt#632323)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_csana#632324)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(un_csana#632324)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_codadm#632325)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(un_codadm#632325)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_mod_envoi#632326)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(un_mod_envoi#632326)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_adr_1#632327)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(un_adr_1#632327)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_adr_2#632328)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(un_adr_2#632328)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_adr_3#632329)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(un_adr_3#632329)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_codpos#632330)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(un_codpos#632330)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_ville#632331)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(un_ville#632331)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_pays#632332)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(un_pays#632332)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_create(Cab_A))), MARX)) THEN false ELSE Contains(str_remove_accent(upper(str_create(Cab_A))), MARX) END)

Scan JDBCRelation((SELECT "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#632293,un_lib30#632294,un_libco#632295,un_serv#632296,un_nature#632297,un_valid#632298,un_uf_dem#632299,un_uf_exe#632300,un_uf_loc#632301,un_telbur#632302,un_fax#632303,un_e_mail#632304,un_envadm#632305,un_lieu_s#632306,un_coduti#632307,un_datmaj#632308,un_codsit#632309,un_modtrt#632310,un_dispre#632311,un_codsoc#632312,un_numcpt_a#632313,un_numcpt_f#632314,un_numcpt_c#632315,un_chefser#632316,... 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#633448)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(un_codser#633448)), MARX) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_lib30#633449)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(un_lib30#633449)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_libco#633450)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(un_libco#633450)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_serv#633451)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(un_serv#633451)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_nature#633452)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(un_nature#633452)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_valid#633453)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(un_valid#633453)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_uf_dem#633454)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(un_uf_dem#633454)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_uf_exe#633455)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(un_uf_exe#633455)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_uf_loc#633456)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(un_uf_loc#633456)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_telbur#633457)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(un_telbur#633457)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_fax#633458)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(un_fax#633458)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_e_mail#633459)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(un_e_mail#633459)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_envadm#633460)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(un_envadm#633460)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_lieu_s#633461)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(un_lieu_s#633461)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_coduti#633462)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(un_coduti#633462)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_datmaj#633463)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(un_datmaj#633463)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_codsit#633464)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(un_codsit#633464)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_modtrt#633465)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(un_modtrt#633465)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_dispre#633466)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(un_dispre#633466)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_codsoc#633467)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(un_codsoc#633467)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_numcpt_a#633468)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(un_numcpt_a#633468)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_numcpt_f#633469)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(un_numcpt_f#633469)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_numcpt_c#633470)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(un_numcpt_c#633470)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_chefser#633471)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(un_chefser#633471)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_datede#633472)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(un_datede#633472)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_datefi#633473)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(un_datefi#633473)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_comment#633474)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(un_comment#633474)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_flicpt#633475)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(un_flicpt#633475)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_xml_p_cpta#633476)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(un_xml_p_cpta#633476)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_numprf#633477)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(un_numprf#633477)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_cscpt#633478)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(un_cscpt#633478)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_csana#633479)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(un_csana#633479)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_codadm#633480)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(un_codadm#633480)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_mod_envoi#633481)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(un_mod_envoi#633481)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_adr_1#633482)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(un_adr_1#633482)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_adr_2#633483)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(un_adr_2#633483)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_adr_3#633484)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(un_adr_3#633484)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_codpos#633485)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(un_codpos#633485)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_ville#633486)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(un_ville#633486)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_pays#633487)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(un_pays#633487)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_create(Cab_B))), MARX)) THEN false ELSE Contains(str_remove_accent(upper(str_create(Cab_B))), MARX) END)

Scan JDBCRelation((SELECT "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#633448,un_lib30#633449,un_libco#633450,un_serv#633451,un_nature#633452,un_valid#633453,un_uf_dem#633454,un_uf_exe#633455,un_uf_loc#633456,un_telbur#633457,un_fax#633458,un_e_mail#633459,un_envadm#633460,un_lieu_s#633461,un_coduti#633462,un_datmaj#633463,un_codsit#633464,un_modtrt#633465,un_dispre#633466,un_codsoc#633467,un_numcpt_a#633468,un_numcpt_f#633469,un_numcpt_c#633470,un_chefser#633471,... 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#632293, un_lib30#632294, un_libco#632295, un_serv#632296, un_nature#632297, un_valid#632298, un_uf_dem#632299, un_uf_exe#632300, un_uf_loc#632301, un_telbur#632302, un_fax#632303, un_e_mail#632304, un_envadm#632305, un_lieu_s#632306, un_coduti#632307, un_datmaj#632308, un_codsit#632309, un_modtrt#632310, un_dispre#632311, un_codsoc#632312, un_numcpt_a#632313, un_numcpt_f#632314, un_numcpt_c#632315, un_chefser#632316, un_datede#632317, un_datefi#632318, un_comment#632319, un_flicpt#632320, un_xml_p_cpta#632321, un_numprf#632322, un_cscpt#632323, un_csana#632324, un_codadm#632325, un_mod_envoi#632326, un_adr_1#632327, un_adr_2#632328, un_adr_3#632329, un_codpos#632330, un_ville#632331, un_pays#632332]
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#632293, un_lib30#632294, un_libco#632295, un_serv#632296, un_nature#632297, un_valid#632298, un_uf_dem#632299, un_uf_exe#632300, un_uf_loc#632301, un_telbur#632302, un_fax#632303, un_e_mail#632304, un_envadm#632305, un_lieu_s#632306, un_coduti#632307, un_datmaj#632308, un_codsit#632309, un_modtrt#632310, un_dispre#632311, un_codsoc#632312, un_numcpt_a#632313, un_numcpt_f#632314, un_numcpt_c#632315, un_chefser#632316, un_datede#632317, un_datefi#632318, un_comment#632319, un_flicpt#632320, un_xml_p_cpta#632321, un_numprf#632322, un_cscpt#632323, un_csana#632324, un_codadm#632325, un_mod_envoi#632326, un_adr_1#632327, un_adr_2#632328, un_adr_3#632329, un_codpos#632330, un_ville#632331, un_pays#632332]
Condition : ((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(un_codser#632293)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(un_codser#632293)), MARX) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_lib30#632294)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(un_lib30#632294)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_libco#632295)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(un_libco#632295)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_serv#632296)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(un_serv#632296)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_nature#632297)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(un_nature#632297)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_valid#632298)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(un_valid#632298)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_uf_dem#632299)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(un_uf_dem#632299)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_uf_exe#632300)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(un_uf_exe#632300)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_uf_loc#632301)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(un_uf_loc#632301)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_telbur#632302)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(un_telbur#632302)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_fax#632303)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(un_fax#632303)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_e_mail#632304)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(un_e_mail#632304)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_envadm#632305)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(un_envadm#632305)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_lieu_s#632306)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(un_lieu_s#632306)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_coduti#632307)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(un_coduti#632307)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_datmaj#632308)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(un_datmaj#632308)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_codsit#632309)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(un_codsit#632309)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_modtrt#632310)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(un_modtrt#632310)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_dispre#632311)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(un_dispre#632311)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_codsoc#632312)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(un_codsoc#632312)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_numcpt_a#632313)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(un_numcpt_a#632313)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_numcpt_f#632314)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(un_numcpt_f#632314)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_numcpt_c#632315)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(un_numcpt_c#632315)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_chefser#632316)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(un_chefser#632316)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_datede#632317)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(un_datede#632317)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_datefi#632318)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(un_datefi#632318)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_comment#632319)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(un_comment#632319)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_flicpt#632320)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(un_flicpt#632320)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_xml_p_cpta#632321)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(un_xml_p_cpta#632321)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_numprf#632322)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(un_numprf#632322)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_cscpt#632323)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(un_cscpt#632323)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_csana#632324)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(un_csana#632324)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_codadm#632325)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(un_codadm#632325)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_mod_envoi#632326)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(un_mod_envoi#632326)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_adr_1#632327)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(un_adr_1#632327)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_adr_2#632328)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(un_adr_2#632328)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_adr_3#632329)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(un_adr_3#632329)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_codpos#632330)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(un_codpos#632330)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_ville#632331)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(un_ville#632331)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_pays#632332)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(un_pays#632332)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_create(Cab_A))), MARX)) THEN false ELSE Contains(str_remove_accent(upper(str_create(Cab_A))), MARX) END)

(3) Project [codegen id : 1]
Output: []
Input [40]: [un_codser#632293, un_lib30#632294, un_libco#632295, un_serv#632296, un_nature#632297, un_valid#632298, un_uf_dem#632299, un_uf_exe#632300, un_uf_loc#632301, un_telbur#632302, un_fax#632303, un_e_mail#632304, un_envadm#632305, un_lieu_s#632306, un_coduti#632307, un_datmaj#632308, un_codsit#632309, un_modtrt#632310, un_dispre#632311, un_codsoc#632312, un_numcpt_a#632313, un_numcpt_f#632314, un_numcpt_c#632315, un_chefser#632316, un_datede#632317, un_datefi#632318, un_comment#632319, un_flicpt#632320, un_xml_p_cpta#632321, un_numprf#632322, un_cscpt#632323, un_csana#632324, un_codadm#632325, un_mod_envoi#632326, un_adr_1#632327, un_adr_2#632328, un_adr_3#632329, un_codpos#632330, un_ville#632331, un_pays#632332]

(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#633448, un_lib30#633449, un_libco#633450, un_serv#633451, un_nature#633452, un_valid#633453, un_uf_dem#633454, un_uf_exe#633455, un_uf_loc#633456, un_telbur#633457, un_fax#633458, un_e_mail#633459, un_envadm#633460, un_lieu_s#633461, un_coduti#633462, un_datmaj#633463, un_codsit#633464, un_modtrt#633465, un_dispre#633466, un_codsoc#633467, un_numcpt_a#633468, un_numcpt_f#633469, un_numcpt_c#633470, un_chefser#633471, un_datede#633472, un_datefi#633473, un_comment#633474, un_flicpt#633475, un_xml_p_cpta#633476, un_numprf#633477, un_cscpt#633478, un_csana#633479, un_codadm#633480, un_mod_envoi#633481, un_adr_1#633482, un_adr_2#633483, un_adr_3#633484, un_codpos#633485, un_ville#633486, un_pays#633487]
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#633448, un_lib30#633449, un_libco#633450, un_serv#633451, un_nature#633452, un_valid#633453, un_uf_dem#633454, un_uf_exe#633455, un_uf_loc#633456, un_telbur#633457, un_fax#633458, un_e_mail#633459, un_envadm#633460, un_lieu_s#633461, un_coduti#633462, un_datmaj#633463, un_codsit#633464, un_modtrt#633465, un_dispre#633466, un_codsoc#633467, un_numcpt_a#633468, un_numcpt_f#633469, un_numcpt_c#633470, un_chefser#633471, un_datede#633472, un_datefi#633473, un_comment#633474, un_flicpt#633475, un_xml_p_cpta#633476, un_numprf#633477, un_cscpt#633478, un_csana#633479, un_codadm#633480, un_mod_envoi#633481, un_adr_1#633482, un_adr_2#633483, un_adr_3#633484, un_codpos#633485, un_ville#633486, un_pays#633487]
Condition : ((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(un_codser#633448)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(un_codser#633448)), MARX) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_lib30#633449)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(un_lib30#633449)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_libco#633450)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(un_libco#633450)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_serv#633451)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(un_serv#633451)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_nature#633452)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(un_nature#633452)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_valid#633453)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(un_valid#633453)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_uf_dem#633454)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(un_uf_dem#633454)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_uf_exe#633455)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(un_uf_exe#633455)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_uf_loc#633456)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(un_uf_loc#633456)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_telbur#633457)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(un_telbur#633457)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_fax#633458)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(un_fax#633458)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_e_mail#633459)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(un_e_mail#633459)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_envadm#633460)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(un_envadm#633460)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_lieu_s#633461)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(un_lieu_s#633461)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_coduti#633462)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(un_coduti#633462)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_datmaj#633463)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(un_datmaj#633463)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_codsit#633464)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(un_codsit#633464)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_modtrt#633465)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(un_modtrt#633465)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_dispre#633466)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(un_dispre#633466)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_codsoc#633467)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(un_codsoc#633467)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_numcpt_a#633468)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(un_numcpt_a#633468)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_numcpt_f#633469)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(un_numcpt_f#633469)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_numcpt_c#633470)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(un_numcpt_c#633470)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_chefser#633471)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(un_chefser#633471)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_datede#633472)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(un_datede#633472)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_datefi#633473)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(un_datefi#633473)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_comment#633474)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(un_comment#633474)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_flicpt#633475)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(un_flicpt#633475)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_xml_p_cpta#633476)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(un_xml_p_cpta#633476)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_numprf#633477)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(un_numprf#633477)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_cscpt#633478)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(un_cscpt#633478)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_csana#633479)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(un_csana#633479)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_codadm#633480)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(un_codadm#633480)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_mod_envoi#633481)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(un_mod_envoi#633481)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_adr_1#633482)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(un_adr_1#633482)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_adr_2#633483)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(un_adr_2#633483)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_adr_3#633484)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(un_adr_3#633484)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_codpos#633485)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(un_codpos#633485)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_ville#633486)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(un_ville#633486)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_pays#633487)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(un_pays#633487)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_create(Cab_B))), MARX)) THEN false ELSE Contains(str_remove_accent(upper(str_create(Cab_B))), MARX) END)

(6) Project [codegen id : 2]
Output: []
Input [40]: [un_codser#633448, un_lib30#633449, un_libco#633450, un_serv#633451, un_nature#633452, un_valid#633453, un_uf_dem#633454, un_uf_exe#633455, un_uf_loc#633456, un_telbur#633457, un_fax#633458, un_e_mail#633459, un_envadm#633460, un_lieu_s#633461, un_coduti#633462, un_datmaj#633463, un_codsit#633464, un_modtrt#633465, un_dispre#633466, un_codsoc#633467, un_numcpt_a#633468, un_numcpt_f#633469, un_numcpt_c#633470, un_chefser#633471, un_datede#633472, un_datefi#633473, un_comment#633474, un_flicpt#633475, un_xml_p_cpta#633476, un_numprf#633477, un_cscpt#633478, un_csana#633479, un_codadm#633480, un_mod_envoi#633481, un_adr_1#633482, un_adr_2#633483, un_adr_3#633484, un_codpos#633485, un_ville#633486, un_pays#633487]

(7) Union

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

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

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

(11) HashAggregate [codegen id : 4]
Input [1]: [count#635505L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#635366L]
Results [1]: [count(1)#635366L AS COL_36ac82b8-adfb-48cf-89d4-ad86d351bdcd#635370L]

(12) Union

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

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

(15) HashAggregate
Input [1]: [count#635505L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#635366L]
Results [1]: [count(1)#635366L AS COL_36ac82b8-adfb-48cf-89d4-ad86d351bdcd#635370L]

(16) AdaptiveSparkPlan
Output [1]: [COL_36ac82b8-adfb-48cf-89d4-ad86d351bdcd#635370L]
Arguments: isFinalPlan=true

SQL / DataFrame Properties

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