hdh-spark-job - Details for Query 1353

Submitted Time: 2026/10/23 13:28:05
Duration: 0.7 s
Succeeded Jobs: 1352 1355

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 1953.0: task 1703)) 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 1953.0: task 1703)) 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 1953.0: task 1703))"]; subgraph cluster4 { isCluster="true"; label="WholeStageCodegen (3)\n \nduration: total (min, med, max (stageId: taskId))\n69 ms (34 ms, 35 ms, 35 ms (stage 1953.0: task 1704))"; 5 [labelType="html" label="HashAggregate time in aggregation build total (min, med, max (stageId: taskId)) 68 ms (34 ms, 34 ms, 34 ms (stage 1953.0: task 1703)) number of output rows: 2"]; } 6 [labelType="html" label=" Union "]; subgraph cluster7 { isCluster="true"; label="WholeStageCodegen (1)\n \nduration: 34 ms"; 8 [labelType="html" label=" Project "]; 9 [labelType="html" label="Filter number of output rows: 0"]; 10 [labelType="html" label="Scan JDBCRelation((SELECT \"vn_numeve\", \"vn_typeve\", \"vn_action\", \"vn_traite\", \"vn_dateve\", \"vn_heueve\", \"vn_numdos\", \"vn_numdem\", \"vn_numpco\", \"vn_numcot\", \"vn_numcr\", \"vn_numfus\", \"vn_numexa\", \"vn_datmaj\", \"vn_coduti\", \"vn_codsit\", \"vn_comment\", \"vn_numdrv\", \"vn_flmanu\", \"vn_datmajmanu\", \"vn_heumajmanu\", \"vn_sta_env\", \"vn_numdos_dest\", \"vn_numdem_dest\", \"vn_sigma\", \"vn_numresa\", \"vn_numpan\", \"vn_xmldata\", \"vn_nummcr\", \"vn_numstu\", \"vn_numcde\", \"vn_numlcd\", \"vn_nummvt\" FROM \"xplore\".\"h_even\") as x) [numPartitions=1] number of output rows: 1,145"]; } subgraph cluster11 { isCluster="true"; label="WholeStageCodegen (2)\n \nduration: 34 ms"; 12 [labelType="html" label=" Project "]; 13 [labelType="html" label="Filter number of output rows: 0"]; 14 [labelType="html" label="Scan JDBCRelation((SELECT \"vn_numeve\", \"vn_typeve\", \"vn_action\", \"vn_traite\", \"vn_dateve\", \"vn_heueve\", \"vn_numdos\", \"vn_numdem\", \"vn_numpco\", \"vn_numcot\", \"vn_numcr\", \"vn_numfus\", \"vn_numexa\", \"vn_datmaj\", \"vn_coduti\", \"vn_codsit\", \"vn_comment\", \"vn_numdrv\", \"vn_flmanu\", \"vn_datmajmanu\", \"vn_heumajmanu\", \"vn_sta_env\", \"vn_numdos_dest\", \"vn_numdem_dest\", \"vn_sigma\", \"vn_numresa\", \"vn_numpan\", \"vn_xmldata\", \"vn_nummcr\", \"vn_numstu\", \"vn_numcde\", \"vn_numlcd\", \"vn_nummvt\" FROM \"xplore2\".\"h_even\") as x) [numPartitions=1] number of output rows: 1,145"]; } 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=36323]

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

WholeStageCodegen (3)

Union

Project

Filter (((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(vn_numeve#667597)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_numeve#667597)), MAIN) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_typeve#667598)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_typeve#667598)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_action#667599)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_action#667599)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_traite#667600)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_traite#667600)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_dateve#667601)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_dateve#667601)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_heueve#667602)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_heueve#667602)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_numdos#667603)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_numdos#667603)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_numdem#667604)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_numdem#667604)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_numpco#667605)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_numpco#667605)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_numcot#667606)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_numcot#667606)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_numcr#667607)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_numcr#667607)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_numfus#667608)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_numfus#667608)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_numexa#667609)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_numexa#667609)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_datmaj#667610)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_datmaj#667610)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_coduti#667611)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_coduti#667611)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_codsit#667612)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_codsit#667612)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_comment#667613)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_comment#667613)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_numdrv#667614)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_numdrv#667614)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_flmanu#667615)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_flmanu#667615)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_datmajmanu#667616)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_datmajmanu#667616)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_heumajmanu#667617)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_heumajmanu#667617)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_sta_env#667618)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_sta_env#667618)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_numdos_dest#667619)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_numdos_dest#667619)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_numdem_dest#667620)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_numdem_dest#667620)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_sigma#667621)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_sigma#667621)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_numresa#667622)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_numresa#667622)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_numpan#667623)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_numpan#667623)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_xmldata#667624)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_xmldata#667624)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_nummcr#667625)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_nummcr#667625)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_numstu#667626)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_numstu#667626)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_numcde#667627)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_numcde#667627)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_numlcd#667628)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_numlcd#667628)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_nummvt#667629)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_nummvt#667629)), 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 "vn_numeve", "vn_typeve", "vn_action", "vn_traite", "vn_dateve", "vn_heueve", "vn_numdos", "vn_numdem", "vn_numpco", "vn_numcot", "vn_numcr", "vn_numfus", "vn_numexa", "vn_datmaj", "vn_coduti", "vn_codsit", "vn_comment", "vn_numdrv", "vn_flmanu", "vn_datmajmanu", "vn_heumajmanu", "vn_sta_env", "vn_numdos_dest", "vn_numdem_dest", "vn_sigma", "vn_numresa", "vn_numpan", "vn_xmldata", "vn_nummcr", "vn_numstu", "vn_numcde", "vn_numlcd", "vn_nummvt" FROM "xplore"."h_even") as x) [numPartitions=1] [vn_numeve#667597,vn_typeve#667598,vn_action#667599,vn_traite#667600,vn_dateve#667601,vn_heueve#667602,vn_numdos#667603,vn_numdem#667604,vn_numpco#667605,vn_numcot#667606,vn_numcr#667607,vn_numfus#667608,vn_numexa#667609,vn_datmaj#667610,vn_coduti#667611,vn_codsit#667612,vn_comment#667613,vn_numdrv#667614,vn_flmanu#667615,vn_datmajmanu#667616,vn_heumajmanu#667617,vn_sta_env#667618,vn_numdos_dest#667619,vn_numdem_dest#667620,... 9 more fields] PushedFilters: [], ReadSchema: struct<vn_numeve:string,vn_typeve:string,vn_action:string,vn_traite:string,vn_dateve:string,vn_he...

WholeStageCodegen (1)

Project

Filter (((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(vn_numeve#668851)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_numeve#668851)), MAIN) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_typeve#668852)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_typeve#668852)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_action#668853)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_action#668853)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_traite#668854)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_traite#668854)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_dateve#668855)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_dateve#668855)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_heueve#668856)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_heueve#668856)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_numdos#668857)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_numdos#668857)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_numdem#668858)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_numdem#668858)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_numpco#668859)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_numpco#668859)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_numcot#668860)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_numcot#668860)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_numcr#668861)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_numcr#668861)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_numfus#668862)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_numfus#668862)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_numexa#668863)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_numexa#668863)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_datmaj#668864)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_datmaj#668864)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_coduti#668865)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_coduti#668865)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_codsit#668866)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_codsit#668866)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_comment#668867)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_comment#668867)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_numdrv#668868)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_numdrv#668868)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_flmanu#668869)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_flmanu#668869)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_datmajmanu#668870)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_datmajmanu#668870)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_heumajmanu#668871)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_heumajmanu#668871)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_sta_env#668872)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_sta_env#668872)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_numdos_dest#668873)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_numdos_dest#668873)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_numdem_dest#668874)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_numdem_dest#668874)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_sigma#668875)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_sigma#668875)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_numresa#668876)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_numresa#668876)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_numpan#668877)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_numpan#668877)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_xmldata#668878)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_xmldata#668878)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_nummcr#668879)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_nummcr#668879)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_numstu#668880)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_numstu#668880)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_numcde#668881)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_numcde#668881)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_numlcd#668882)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_numlcd#668882)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_nummvt#668883)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_nummvt#668883)), 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 "vn_numeve", "vn_typeve", "vn_action", "vn_traite", "vn_dateve", "vn_heueve", "vn_numdos", "vn_numdem", "vn_numpco", "vn_numcot", "vn_numcr", "vn_numfus", "vn_numexa", "vn_datmaj", "vn_coduti", "vn_codsit", "vn_comment", "vn_numdrv", "vn_flmanu", "vn_datmajmanu", "vn_heumajmanu", "vn_sta_env", "vn_numdos_dest", "vn_numdem_dest", "vn_sigma", "vn_numresa", "vn_numpan", "vn_xmldata", "vn_nummcr", "vn_numstu", "vn_numcde", "vn_numlcd", "vn_nummvt" FROM "xplore2"."h_even") as x) [numPartitions=1] [vn_numeve#668851,vn_typeve#668852,vn_action#668853,vn_traite#668854,vn_dateve#668855,vn_heueve#668856,vn_numdos#668857,vn_numdem#668858,vn_numpco#668859,vn_numcot#668860,vn_numcr#668861,vn_numfus#668862,vn_numexa#668863,vn_datmaj#668864,vn_coduti#668865,vn_codsit#668866,vn_comment#668867,vn_numdrv#668868,vn_flmanu#668869,vn_datmajmanu#668870,vn_heumajmanu#668871,vn_sta_env#668872,vn_numdos_dest#668873,vn_numdem_dest#668874,... 9 more fields] PushedFilters: [], ReadSchema: struct<vn_numeve:string,vn_typeve:string,vn_action:string,vn_traite:string,vn_dateve:string,vn_he...

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 "vn_numeve", "vn_typeve", "vn_action", "vn_traite", "vn_dateve", "vn_heueve", "vn_numdos", "vn_numdem", "vn_numpco", "vn_numcot", "vn_numcr", "vn_numfus", "vn_numexa", "vn_datmaj", "vn_coduti", "vn_codsit", "vn_comment", "vn_numdrv", "vn_flmanu", "vn_datmajmanu", "vn_heumajmanu", "vn_sta_env", "vn_numdos_dest", "vn_numdem_dest", "vn_sigma", "vn_numresa", "vn_numpan", "vn_xmldata", "vn_nummcr", "vn_numstu", "vn_numcde", "vn_numlcd", "vn_nummvt" FROM "xplore"."h_even") as x) [numPartitions=1]  (1)
               +- * Project (6)
                  +- * Filter (5)
                     +- * Scan JDBCRelation((SELECT "vn_numeve", "vn_typeve", "vn_action", "vn_traite", "vn_dateve", "vn_heueve", "vn_numdos", "vn_numdem", "vn_numpco", "vn_numcot", "vn_numcr", "vn_numfus", "vn_numexa", "vn_datmaj", "vn_coduti", "vn_codsit", "vn_comment", "vn_numdrv", "vn_flmanu", "vn_datmajmanu", "vn_heumajmanu", "vn_sta_env", "vn_numdos_dest", "vn_numdem_dest", "vn_sigma", "vn_numresa", "vn_numpan", "vn_xmldata", "vn_nummcr", "vn_numstu", "vn_numcde", "vn_numlcd", "vn_nummvt" FROM "xplore2"."h_even") as x) [numPartitions=1]  (4)
+- == Initial Plan ==
   HashAggregate (15)
   +- Exchange (14)
      +- HashAggregate (13)
         +- Union (12)
            :- Project (3)
            :  +- Filter (2)
            :     +- Scan JDBCRelation((SELECT "vn_numeve", "vn_typeve", "vn_action", "vn_traite", "vn_dateve", "vn_heueve", "vn_numdos", "vn_numdem", "vn_numpco", "vn_numcot", "vn_numcr", "vn_numfus", "vn_numexa", "vn_datmaj", "vn_coduti", "vn_codsit", "vn_comment", "vn_numdrv", "vn_flmanu", "vn_datmajmanu", "vn_heumajmanu", "vn_sta_env", "vn_numdos_dest", "vn_numdem_dest", "vn_sigma", "vn_numresa", "vn_numpan", "vn_xmldata", "vn_nummcr", "vn_numstu", "vn_numcde", "vn_numlcd", "vn_nummvt" FROM "xplore"."h_even") as x) [numPartitions=1]  (1)
            +- Project (6)
               +- Filter (5)
                  +- Scan JDBCRelation((SELECT "vn_numeve", "vn_typeve", "vn_action", "vn_traite", "vn_dateve", "vn_heueve", "vn_numdos", "vn_numdem", "vn_numpco", "vn_numcot", "vn_numcr", "vn_numfus", "vn_numexa", "vn_datmaj", "vn_coduti", "vn_codsit", "vn_comment", "vn_numdrv", "vn_flmanu", "vn_datmajmanu", "vn_heumajmanu", "vn_sta_env", "vn_numdos_dest", "vn_numdem_dest", "vn_sigma", "vn_numresa", "vn_numpan", "vn_xmldata", "vn_nummcr", "vn_numstu", "vn_numcde", "vn_numlcd", "vn_nummvt" FROM "xplore2"."h_even") as x) [numPartitions=1]  (4)


(1) Scan JDBCRelation((SELECT "vn_numeve", "vn_typeve", "vn_action", "vn_traite", "vn_dateve", "vn_heueve", "vn_numdos", "vn_numdem", "vn_numpco", "vn_numcot", "vn_numcr", "vn_numfus", "vn_numexa", "vn_datmaj", "vn_coduti", "vn_codsit", "vn_comment", "vn_numdrv", "vn_flmanu", "vn_datmajmanu", "vn_heumajmanu", "vn_sta_env", "vn_numdos_dest", "vn_numdem_dest", "vn_sigma", "vn_numresa", "vn_numpan", "vn_xmldata", "vn_nummcr", "vn_numstu", "vn_numcde", "vn_numlcd", "vn_nummvt" FROM "xplore"."h_even") as x) [numPartitions=1]  [codegen id : 1]
Output [33]: [vn_numeve#667597, vn_typeve#667598, vn_action#667599, vn_traite#667600, vn_dateve#667601, vn_heueve#667602, vn_numdos#667603, vn_numdem#667604, vn_numpco#667605, vn_numcot#667606, vn_numcr#667607, vn_numfus#667608, vn_numexa#667609, vn_datmaj#667610, vn_coduti#667611, vn_codsit#667612, vn_comment#667613, vn_numdrv#667614, vn_flmanu#667615, vn_datmajmanu#667616, vn_heumajmanu#667617, vn_sta_env#667618, vn_numdos_dest#667619, vn_numdem_dest#667620, vn_sigma#667621, vn_numresa#667622, vn_numpan#667623, vn_xmldata#667624, vn_nummcr#667625, vn_numstu#667626, vn_numcde#667627, vn_numlcd#667628, vn_nummvt#667629]
ReadSchema: struct<vn_numeve:string,vn_typeve:string,vn_action:string,vn_traite:string,vn_dateve:string,vn_heueve:string,vn_numdos:string,vn_numdem:string,vn_numpco:string,vn_numcot:string,vn_numcr:string,vn_numfus:string,vn_numexa:string,vn_datmaj:string,vn_coduti:string,vn_codsit:string,vn_comment:string,vn_numdrv:string,vn_flmanu:string,vn_datmajmanu:string,vn_heumajmanu:string,vn_sta_env:string,vn_numdos_dest:string,vn_numdem_dest:string,vn_sigma:string,vn_numresa:string,vn_numpan:string,vn_xmldata:string,vn_nummcr:string,vn_numstu:string,vn_numcde:string,vn_numlcd:string,vn_nummvt:string>

(2) Filter [codegen id : 1]
Input [33]: [vn_numeve#667597, vn_typeve#667598, vn_action#667599, vn_traite#667600, vn_dateve#667601, vn_heueve#667602, vn_numdos#667603, vn_numdem#667604, vn_numpco#667605, vn_numcot#667606, vn_numcr#667607, vn_numfus#667608, vn_numexa#667609, vn_datmaj#667610, vn_coduti#667611, vn_codsit#667612, vn_comment#667613, vn_numdrv#667614, vn_flmanu#667615, vn_datmajmanu#667616, vn_heumajmanu#667617, vn_sta_env#667618, vn_numdos_dest#667619, vn_numdem_dest#667620, vn_sigma#667621, vn_numresa#667622, vn_numpan#667623, vn_xmldata#667624, vn_nummcr#667625, vn_numstu#667626, vn_numcde#667627, vn_numlcd#667628, vn_nummvt#667629]
Condition : (((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(vn_numeve#667597)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_numeve#667597)), MAIN) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_typeve#667598)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_typeve#667598)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_action#667599)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_action#667599)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_traite#667600)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_traite#667600)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_dateve#667601)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_dateve#667601)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_heueve#667602)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_heueve#667602)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_numdos#667603)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_numdos#667603)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_numdem#667604)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_numdem#667604)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_numpco#667605)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_numpco#667605)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_numcot#667606)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_numcot#667606)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_numcr#667607)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_numcr#667607)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_numfus#667608)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_numfus#667608)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_numexa#667609)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_numexa#667609)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_datmaj#667610)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_datmaj#667610)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_coduti#667611)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_coduti#667611)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_codsit#667612)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_codsit#667612)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_comment#667613)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_comment#667613)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_numdrv#667614)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_numdrv#667614)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_flmanu#667615)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_flmanu#667615)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_datmajmanu#667616)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_datmajmanu#667616)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_heumajmanu#667617)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_heumajmanu#667617)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_sta_env#667618)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_sta_env#667618)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_numdos_dest#667619)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_numdos_dest#667619)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_numdem_dest#667620)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_numdem_dest#667620)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_sigma#667621)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_sigma#667621)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_numresa#667622)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_numresa#667622)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_numpan#667623)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_numpan#667623)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_xmldata#667624)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_xmldata#667624)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_nummcr#667625)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_nummcr#667625)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_numstu#667626)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_numstu#667626)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_numcde#667627)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_numcde#667627)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_numlcd#667628)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_numlcd#667628)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_nummvt#667629)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_nummvt#667629)), 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 [33]: [vn_numeve#667597, vn_typeve#667598, vn_action#667599, vn_traite#667600, vn_dateve#667601, vn_heueve#667602, vn_numdos#667603, vn_numdem#667604, vn_numpco#667605, vn_numcot#667606, vn_numcr#667607, vn_numfus#667608, vn_numexa#667609, vn_datmaj#667610, vn_coduti#667611, vn_codsit#667612, vn_comment#667613, vn_numdrv#667614, vn_flmanu#667615, vn_datmajmanu#667616, vn_heumajmanu#667617, vn_sta_env#667618, vn_numdos_dest#667619, vn_numdem_dest#667620, vn_sigma#667621, vn_numresa#667622, vn_numpan#667623, vn_xmldata#667624, vn_nummcr#667625, vn_numstu#667626, vn_numcde#667627, vn_numlcd#667628, vn_nummvt#667629]

(4) Scan JDBCRelation((SELECT "vn_numeve", "vn_typeve", "vn_action", "vn_traite", "vn_dateve", "vn_heueve", "vn_numdos", "vn_numdem", "vn_numpco", "vn_numcot", "vn_numcr", "vn_numfus", "vn_numexa", "vn_datmaj", "vn_coduti", "vn_codsit", "vn_comment", "vn_numdrv", "vn_flmanu", "vn_datmajmanu", "vn_heumajmanu", "vn_sta_env", "vn_numdos_dest", "vn_numdem_dest", "vn_sigma", "vn_numresa", "vn_numpan", "vn_xmldata", "vn_nummcr", "vn_numstu", "vn_numcde", "vn_numlcd", "vn_nummvt" FROM "xplore2"."h_even") as x) [numPartitions=1]  [codegen id : 2]
Output [33]: [vn_numeve#668851, vn_typeve#668852, vn_action#668853, vn_traite#668854, vn_dateve#668855, vn_heueve#668856, vn_numdos#668857, vn_numdem#668858, vn_numpco#668859, vn_numcot#668860, vn_numcr#668861, vn_numfus#668862, vn_numexa#668863, vn_datmaj#668864, vn_coduti#668865, vn_codsit#668866, vn_comment#668867, vn_numdrv#668868, vn_flmanu#668869, vn_datmajmanu#668870, vn_heumajmanu#668871, vn_sta_env#668872, vn_numdos_dest#668873, vn_numdem_dest#668874, vn_sigma#668875, vn_numresa#668876, vn_numpan#668877, vn_xmldata#668878, vn_nummcr#668879, vn_numstu#668880, vn_numcde#668881, vn_numlcd#668882, vn_nummvt#668883]
ReadSchema: struct<vn_numeve:string,vn_typeve:string,vn_action:string,vn_traite:string,vn_dateve:string,vn_heueve:string,vn_numdos:string,vn_numdem:string,vn_numpco:string,vn_numcot:string,vn_numcr:string,vn_numfus:string,vn_numexa:string,vn_datmaj:string,vn_coduti:string,vn_codsit:string,vn_comment:string,vn_numdrv:string,vn_flmanu:string,vn_datmajmanu:string,vn_heumajmanu:string,vn_sta_env:string,vn_numdos_dest:string,vn_numdem_dest:string,vn_sigma:string,vn_numresa:string,vn_numpan:string,vn_xmldata:string,vn_nummcr:string,vn_numstu:string,vn_numcde:string,vn_numlcd:string,vn_nummvt:string>

(5) Filter [codegen id : 2]
Input [33]: [vn_numeve#668851, vn_typeve#668852, vn_action#668853, vn_traite#668854, vn_dateve#668855, vn_heueve#668856, vn_numdos#668857, vn_numdem#668858, vn_numpco#668859, vn_numcot#668860, vn_numcr#668861, vn_numfus#668862, vn_numexa#668863, vn_datmaj#668864, vn_coduti#668865, vn_codsit#668866, vn_comment#668867, vn_numdrv#668868, vn_flmanu#668869, vn_datmajmanu#668870, vn_heumajmanu#668871, vn_sta_env#668872, vn_numdos_dest#668873, vn_numdem_dest#668874, vn_sigma#668875, vn_numresa#668876, vn_numpan#668877, vn_xmldata#668878, vn_nummcr#668879, vn_numstu#668880, vn_numcde#668881, vn_numlcd#668882, vn_nummvt#668883]
Condition : (((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(vn_numeve#668851)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_numeve#668851)), MAIN) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_typeve#668852)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_typeve#668852)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_action#668853)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_action#668853)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_traite#668854)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_traite#668854)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_dateve#668855)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_dateve#668855)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_heueve#668856)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_heueve#668856)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_numdos#668857)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_numdos#668857)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_numdem#668858)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_numdem#668858)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_numpco#668859)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_numpco#668859)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_numcot#668860)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_numcot#668860)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_numcr#668861)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_numcr#668861)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_numfus#668862)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_numfus#668862)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_numexa#668863)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_numexa#668863)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_datmaj#668864)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_datmaj#668864)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_coduti#668865)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_coduti#668865)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_codsit#668866)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_codsit#668866)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_comment#668867)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_comment#668867)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_numdrv#668868)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_numdrv#668868)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_flmanu#668869)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_flmanu#668869)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_datmajmanu#668870)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_datmajmanu#668870)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_heumajmanu#668871)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_heumajmanu#668871)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_sta_env#668872)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_sta_env#668872)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_numdos_dest#668873)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_numdos_dest#668873)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_numdem_dest#668874)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_numdem_dest#668874)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_sigma#668875)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_sigma#668875)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_numresa#668876)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_numresa#668876)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_numpan#668877)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_numpan#668877)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_xmldata#668878)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_xmldata#668878)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_nummcr#668879)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_nummcr#668879)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_numstu#668880)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_numstu#668880)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_numcde#668881)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_numcde#668881)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_numlcd#668882)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_numlcd#668882)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_nummvt#668883)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_nummvt#668883)), 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 [33]: [vn_numeve#668851, vn_typeve#668852, vn_action#668853, vn_traite#668854, vn_dateve#668855, vn_heueve#668856, vn_numdos#668857, vn_numdem#668858, vn_numpco#668859, vn_numcot#668860, vn_numcr#668861, vn_numfus#668862, vn_numexa#668863, vn_datmaj#668864, vn_coduti#668865, vn_codsit#668866, vn_comment#668867, vn_numdrv#668868, vn_flmanu#668869, vn_datmajmanu#668870, vn_heumajmanu#668871, vn_sta_env#668872, vn_numdos_dest#668873, vn_numdem_dest#668874, vn_sigma#668875, vn_numresa#668876, vn_numpan#668877, vn_xmldata#668878, vn_nummcr#668879, vn_numstu#668880, vn_numcde#668881, vn_numlcd#668882, vn_nummvt#668883]

(7) Union

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

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

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

(11) HashAggregate [codegen id : 4]
Input [1]: [count#670185L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#670101L]
Results [1]: [count(1)#670101L AS COL_b495f591-c1d5-4d62-b8a1-a01983499def#670103L]

(12) Union

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

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

(15) HashAggregate
Input [1]: [count#670185L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#670101L]
Results [1]: [count(1)#670101L AS COL_b495f591-c1d5-4d62-b8a1-a01983499def#670103L]

(16) AdaptiveSparkPlan
Output [1]: [COL_b495f591-c1d5-4d62-b8a1-a01983499def#670103L]
Arguments: isFinalPlan=true

SQL / DataFrame Properties

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