hdh-spark-job - Details for Query 1355

Submitted Time: 2026/10/23 13:28:07
Duration: 0.5 s
Succeeded Jobs: 1356 1357

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 1960.0: task 1709)) 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 1960.0: task 1709)) 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 1960.0: task 1709))"]; subgraph cluster4 { isCluster="true"; label="WholeStageCodegen (3)\n \nduration: total (min, med, max (stageId: taskId))\n9 ms (4 ms, 5 ms, 5 ms (stage 1960.0: task 1709))"; 5 [labelType="html" label="HashAggregate time in aggregation build total (min, med, max (stageId: taskId)) 9 ms (4 ms, 5 ms, 5 ms (stage 1960.0: task 1709)) 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: 5 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=36396]

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

WholeStageCodegen (3)

Union

Project

Filter ((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(un_codser#670188)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_codser#670188)), MAIN) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_lib30#670189)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_lib30#670189)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_libco#670190)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_libco#670190)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_serv#670191)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_serv#670191)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_nature#670192)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_nature#670192)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_valid#670193)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_valid#670193)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_uf_dem#670194)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_uf_dem#670194)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_uf_exe#670195)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_uf_exe#670195)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_uf_loc#670196)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_uf_loc#670196)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_telbur#670197)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_telbur#670197)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_fax#670198)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_fax#670198)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_e_mail#670199)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_e_mail#670199)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_envadm#670200)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_envadm#670200)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_lieu_s#670201)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_lieu_s#670201)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_coduti#670202)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_coduti#670202)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_datmaj#670203)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_datmaj#670203)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_codsit#670204)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_codsit#670204)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_modtrt#670205)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_modtrt#670205)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_dispre#670206)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_dispre#670206)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_codsoc#670207)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_codsoc#670207)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_numcpt_a#670208)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_numcpt_a#670208)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_numcpt_f#670209)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_numcpt_f#670209)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_numcpt_c#670210)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_numcpt_c#670210)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_chefser#670211)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_chefser#670211)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_datede#670212)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_datede#670212)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_datefi#670213)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_datefi#670213)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_comment#670214)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_comment#670214)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_flicpt#670215)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_flicpt#670215)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_xml_p_cpta#670216)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_xml_p_cpta#670216)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_numprf#670217)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_numprf#670217)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_cscpt#670218)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_cscpt#670218)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_csana#670219)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_csana#670219)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_codadm#670220)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_codadm#670220)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_mod_envoi#670221)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_mod_envoi#670221)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_adr_1#670222)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_adr_1#670222)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_adr_2#670223)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_adr_2#670223)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_adr_3#670224)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_adr_3#670224)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_codpos#670225)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_codpos#670225)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_ville#670226)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_ville#670226)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_pays#670227)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_pays#670227)), 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#670188,un_lib30#670189,un_libco#670190,un_serv#670191,un_nature#670192,un_valid#670193,un_uf_dem#670194,un_uf_exe#670195,un_uf_loc#670196,un_telbur#670197,un_fax#670198,un_e_mail#670199,un_envadm#670200,un_lieu_s#670201,un_coduti#670202,un_datmaj#670203,un_codsit#670204,un_modtrt#670205,un_dispre#670206,un_codsoc#670207,un_numcpt_a#670208,un_numcpt_f#670209,un_numcpt_c#670210,un_chefser#670211,... 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#670551)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_codser#670551)), MAIN) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_lib30#670552)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_lib30#670552)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_libco#670553)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_libco#670553)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_serv#670554)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_serv#670554)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_nature#670555)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_nature#670555)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_valid#670556)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_valid#670556)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_uf_dem#670557)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_uf_dem#670557)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_uf_exe#670558)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_uf_exe#670558)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_uf_loc#670559)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_uf_loc#670559)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_telbur#670560)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_telbur#670560)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_fax#670561)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_fax#670561)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_e_mail#670562)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_e_mail#670562)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_envadm#670563)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_envadm#670563)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_lieu_s#670564)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_lieu_s#670564)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_coduti#670565)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_coduti#670565)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_datmaj#670566)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_datmaj#670566)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_codsit#670567)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_codsit#670567)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_modtrt#670568)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_modtrt#670568)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_dispre#670569)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_dispre#670569)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_codsoc#670570)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_codsoc#670570)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_numcpt_a#670571)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_numcpt_a#670571)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_numcpt_f#670572)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_numcpt_f#670572)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_numcpt_c#670573)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_numcpt_c#670573)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_chefser#670574)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_chefser#670574)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_datede#670575)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_datede#670575)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_datefi#670576)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_datefi#670576)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_comment#670577)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_comment#670577)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_flicpt#670578)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_flicpt#670578)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_xml_p_cpta#670579)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_xml_p_cpta#670579)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_numprf#670580)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_numprf#670580)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_cscpt#670581)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_cscpt#670581)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_csana#670582)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_csana#670582)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_codadm#670583)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_codadm#670583)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_mod_envoi#670584)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_mod_envoi#670584)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_adr_1#670585)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_adr_1#670585)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_adr_2#670586)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_adr_2#670586)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_adr_3#670587)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_adr_3#670587)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_codpos#670588)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_codpos#670588)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_ville#670589)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_ville#670589)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_pays#670590)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_pays#670590)), 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#670551,un_lib30#670552,un_libco#670553,un_serv#670554,un_nature#670555,un_valid#670556,un_uf_dem#670557,un_uf_exe#670558,un_uf_loc#670559,un_telbur#670560,un_fax#670561,un_e_mail#670562,un_envadm#670563,un_lieu_s#670564,un_coduti#670565,un_datmaj#670566,un_codsit#670567,un_modtrt#670568,un_dispre#670569,un_codsoc#670570,un_numcpt_a#670571,un_numcpt_f#670572,un_numcpt_c#670573,un_chefser#670574,... 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#670188, un_lib30#670189, un_libco#670190, un_serv#670191, un_nature#670192, un_valid#670193, un_uf_dem#670194, un_uf_exe#670195, un_uf_loc#670196, un_telbur#670197, un_fax#670198, un_e_mail#670199, un_envadm#670200, un_lieu_s#670201, un_coduti#670202, un_datmaj#670203, un_codsit#670204, un_modtrt#670205, un_dispre#670206, un_codsoc#670207, un_numcpt_a#670208, un_numcpt_f#670209, un_numcpt_c#670210, un_chefser#670211, un_datede#670212, un_datefi#670213, un_comment#670214, un_flicpt#670215, un_xml_p_cpta#670216, un_numprf#670217, un_cscpt#670218, un_csana#670219, un_codadm#670220, un_mod_envoi#670221, un_adr_1#670222, un_adr_2#670223, un_adr_3#670224, un_codpos#670225, un_ville#670226, un_pays#670227]
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#670188, un_lib30#670189, un_libco#670190, un_serv#670191, un_nature#670192, un_valid#670193, un_uf_dem#670194, un_uf_exe#670195, un_uf_loc#670196, un_telbur#670197, un_fax#670198, un_e_mail#670199, un_envadm#670200, un_lieu_s#670201, un_coduti#670202, un_datmaj#670203, un_codsit#670204, un_modtrt#670205, un_dispre#670206, un_codsoc#670207, un_numcpt_a#670208, un_numcpt_f#670209, un_numcpt_c#670210, un_chefser#670211, un_datede#670212, un_datefi#670213, un_comment#670214, un_flicpt#670215, un_xml_p_cpta#670216, un_numprf#670217, un_cscpt#670218, un_csana#670219, un_codadm#670220, un_mod_envoi#670221, un_adr_1#670222, un_adr_2#670223, un_adr_3#670224, un_codpos#670225, un_ville#670226, un_pays#670227]
Condition : ((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(un_codser#670188)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_codser#670188)), MAIN) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_lib30#670189)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_lib30#670189)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_libco#670190)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_libco#670190)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_serv#670191)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_serv#670191)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_nature#670192)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_nature#670192)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_valid#670193)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_valid#670193)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_uf_dem#670194)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_uf_dem#670194)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_uf_exe#670195)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_uf_exe#670195)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_uf_loc#670196)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_uf_loc#670196)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_telbur#670197)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_telbur#670197)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_fax#670198)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_fax#670198)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_e_mail#670199)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_e_mail#670199)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_envadm#670200)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_envadm#670200)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_lieu_s#670201)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_lieu_s#670201)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_coduti#670202)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_coduti#670202)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_datmaj#670203)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_datmaj#670203)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_codsit#670204)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_codsit#670204)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_modtrt#670205)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_modtrt#670205)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_dispre#670206)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_dispre#670206)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_codsoc#670207)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_codsoc#670207)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_numcpt_a#670208)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_numcpt_a#670208)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_numcpt_f#670209)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_numcpt_f#670209)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_numcpt_c#670210)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_numcpt_c#670210)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_chefser#670211)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_chefser#670211)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_datede#670212)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_datede#670212)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_datefi#670213)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_datefi#670213)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_comment#670214)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_comment#670214)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_flicpt#670215)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_flicpt#670215)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_xml_p_cpta#670216)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_xml_p_cpta#670216)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_numprf#670217)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_numprf#670217)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_cscpt#670218)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_cscpt#670218)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_csana#670219)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_csana#670219)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_codadm#670220)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_codadm#670220)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_mod_envoi#670221)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_mod_envoi#670221)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_adr_1#670222)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_adr_1#670222)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_adr_2#670223)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_adr_2#670223)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_adr_3#670224)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_adr_3#670224)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_codpos#670225)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_codpos#670225)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_ville#670226)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_ville#670226)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_pays#670227)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_pays#670227)), 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#670188, un_lib30#670189, un_libco#670190, un_serv#670191, un_nature#670192, un_valid#670193, un_uf_dem#670194, un_uf_exe#670195, un_uf_loc#670196, un_telbur#670197, un_fax#670198, un_e_mail#670199, un_envadm#670200, un_lieu_s#670201, un_coduti#670202, un_datmaj#670203, un_codsit#670204, un_modtrt#670205, un_dispre#670206, un_codsoc#670207, un_numcpt_a#670208, un_numcpt_f#670209, un_numcpt_c#670210, un_chefser#670211, un_datede#670212, un_datefi#670213, un_comment#670214, un_flicpt#670215, un_xml_p_cpta#670216, un_numprf#670217, un_cscpt#670218, un_csana#670219, un_codadm#670220, un_mod_envoi#670221, un_adr_1#670222, un_adr_2#670223, un_adr_3#670224, un_codpos#670225, un_ville#670226, un_pays#670227]

(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#670551, un_lib30#670552, un_libco#670553, un_serv#670554, un_nature#670555, un_valid#670556, un_uf_dem#670557, un_uf_exe#670558, un_uf_loc#670559, un_telbur#670560, un_fax#670561, un_e_mail#670562, un_envadm#670563, un_lieu_s#670564, un_coduti#670565, un_datmaj#670566, un_codsit#670567, un_modtrt#670568, un_dispre#670569, un_codsoc#670570, un_numcpt_a#670571, un_numcpt_f#670572, un_numcpt_c#670573, un_chefser#670574, un_datede#670575, un_datefi#670576, un_comment#670577, un_flicpt#670578, un_xml_p_cpta#670579, un_numprf#670580, un_cscpt#670581, un_csana#670582, un_codadm#670583, un_mod_envoi#670584, un_adr_1#670585, un_adr_2#670586, un_adr_3#670587, un_codpos#670588, un_ville#670589, un_pays#670590]
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#670551, un_lib30#670552, un_libco#670553, un_serv#670554, un_nature#670555, un_valid#670556, un_uf_dem#670557, un_uf_exe#670558, un_uf_loc#670559, un_telbur#670560, un_fax#670561, un_e_mail#670562, un_envadm#670563, un_lieu_s#670564, un_coduti#670565, un_datmaj#670566, un_codsit#670567, un_modtrt#670568, un_dispre#670569, un_codsoc#670570, un_numcpt_a#670571, un_numcpt_f#670572, un_numcpt_c#670573, un_chefser#670574, un_datede#670575, un_datefi#670576, un_comment#670577, un_flicpt#670578, un_xml_p_cpta#670579, un_numprf#670580, un_cscpt#670581, un_csana#670582, un_codadm#670583, un_mod_envoi#670584, un_adr_1#670585, un_adr_2#670586, un_adr_3#670587, un_codpos#670588, un_ville#670589, un_pays#670590]
Condition : ((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(un_codser#670551)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_codser#670551)), MAIN) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_lib30#670552)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_lib30#670552)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_libco#670553)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_libco#670553)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_serv#670554)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_serv#670554)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_nature#670555)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_nature#670555)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_valid#670556)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_valid#670556)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_uf_dem#670557)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_uf_dem#670557)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_uf_exe#670558)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_uf_exe#670558)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_uf_loc#670559)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_uf_loc#670559)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_telbur#670560)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_telbur#670560)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_fax#670561)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_fax#670561)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_e_mail#670562)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_e_mail#670562)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_envadm#670563)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_envadm#670563)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_lieu_s#670564)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_lieu_s#670564)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_coduti#670565)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_coduti#670565)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_datmaj#670566)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_datmaj#670566)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_codsit#670567)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_codsit#670567)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_modtrt#670568)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_modtrt#670568)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_dispre#670569)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_dispre#670569)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_codsoc#670570)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_codsoc#670570)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_numcpt_a#670571)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_numcpt_a#670571)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_numcpt_f#670572)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_numcpt_f#670572)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_numcpt_c#670573)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_numcpt_c#670573)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_chefser#670574)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_chefser#670574)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_datede#670575)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_datede#670575)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_datefi#670576)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_datefi#670576)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_comment#670577)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_comment#670577)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_flicpt#670578)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_flicpt#670578)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_xml_p_cpta#670579)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_xml_p_cpta#670579)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_numprf#670580)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_numprf#670580)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_cscpt#670581)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_cscpt#670581)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_csana#670582)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_csana#670582)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_codadm#670583)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_codadm#670583)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_mod_envoi#670584)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_mod_envoi#670584)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_adr_1#670585)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_adr_1#670585)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_adr_2#670586)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_adr_2#670586)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_adr_3#670587)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_adr_3#670587)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_codpos#670588)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_codpos#670588)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_ville#670589)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_ville#670589)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(un_pays#670590)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(un_pays#670590)), 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#670551, un_lib30#670552, un_libco#670553, un_serv#670554, un_nature#670555, un_valid#670556, un_uf_dem#670557, un_uf_exe#670558, un_uf_loc#670559, un_telbur#670560, un_fax#670561, un_e_mail#670562, un_envadm#670563, un_lieu_s#670564, un_coduti#670565, un_datmaj#670566, un_codsit#670567, un_modtrt#670568, un_dispre#670569, un_codsoc#670570, un_numcpt_a#670571, un_numcpt_f#670572, un_numcpt_c#670573, un_chefser#670574, un_datede#670575, un_datefi#670576, un_comment#670577, un_flicpt#670578, un_xml_p_cpta#670579, un_numprf#670580, un_cscpt#670581, un_csana#670582, un_codadm#670583, un_mod_envoi#670584, un_adr_1#670585, un_adr_2#670586, un_adr_3#670587, un_codpos#670588, un_ville#670589, un_pays#670590]

(7) Union

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

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

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

(11) HashAggregate [codegen id : 4]
Input [1]: [count#671332L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#671242L]
Results [1]: [count(1)#671242L AS COL_1e37c0fe-6f3b-4575-8a5b-a41a1390442e#671244L]

(12) Union

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

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

(15) HashAggregate
Input [1]: [count#671332L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#671242L]
Results [1]: [count(1)#671242L AS COL_1e37c0fe-6f3b-4575-8a5b-a41a1390442e#671244L]

(16) AdaptiveSparkPlan
Output [1]: [COL_1e37c0fe-6f3b-4575-8a5b-a41a1390442e#671244L]
Arguments: isFinalPlan=true

SQL / DataFrame Properties

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