hdh-spark-job - Details for Query 1410

Submitted Time: 2026/10/23 13:29:09
Duration: 0.7 s
Succeeded Jobs: 1409 1412

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 2044.0: task 1784)) 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 2044.0: task 1783)) 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 2044.0: task 1783))"]; subgraph cluster4 { isCluster="true"; label="WholeStageCodegen (3)\n \nduration: total (min, med, max (stageId: taskId))\n68 ms (34 ms, 34 ms, 34 ms (stage 2044.0: task 1783))"; 5 [labelType="html" label="HashAggregate time in aggregation build total (min, med, max (stageId: taskId)) 68 ms (34 ms, 34 ms, 34 ms (stage 2044.0: task 1783)) 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=38227]

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

WholeStageCodegen (3)

Union

Project

Filter (((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(vn_numeve#708284)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_numeve#708284)), MAIN) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_typeve#708285)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_typeve#708285)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_action#708286)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_action#708286)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_traite#708287)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_traite#708287)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_dateve#708288)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_dateve#708288)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_heueve#708289)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_heueve#708289)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_numdos#708290)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_numdos#708290)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_numdem#708291)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_numdem#708291)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_numpco#708292)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_numpco#708292)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_numcot#708293)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_numcot#708293)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_numcr#708294)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_numcr#708294)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_numfus#708295)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_numfus#708295)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_numexa#708296)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_numexa#708296)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_datmaj#708297)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_datmaj#708297)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_coduti#708298)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_coduti#708298)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_codsit#708299)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_codsit#708299)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_comment#708300)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_comment#708300)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_numdrv#708301)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_numdrv#708301)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_flmanu#708302)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_flmanu#708302)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_datmajmanu#708303)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_datmajmanu#708303)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_heumajmanu#708304)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_heumajmanu#708304)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_sta_env#708305)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_sta_env#708305)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_numdos_dest#708306)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_numdos_dest#708306)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_numdem_dest#708307)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_numdem_dest#708307)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_sigma#708308)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_sigma#708308)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_numresa#708309)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_numresa#708309)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_numpan#708310)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_numpan#708310)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_xmldata#708311)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_xmldata#708311)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_nummcr#708312)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_nummcr#708312)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_numstu#708313)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_numstu#708313)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_numcde#708314)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_numcde#708314)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_numlcd#708315)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_numlcd#708315)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_nummvt#708316)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_nummvt#708316)), 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#708284,vn_typeve#708285,vn_action#708286,vn_traite#708287,vn_dateve#708288,vn_heueve#708289,vn_numdos#708290,vn_numdem#708291,vn_numpco#708292,vn_numcot#708293,vn_numcr#708294,vn_numfus#708295,vn_numexa#708296,vn_datmaj#708297,vn_coduti#708298,vn_codsit#708299,vn_comment#708300,vn_numdrv#708301,vn_flmanu#708302,vn_datmajmanu#708303,vn_heumajmanu#708304,vn_sta_env#708305,vn_numdos_dest#708306,vn_numdem_dest#708307,... 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#709037)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_numeve#709037)), MAIN) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_typeve#709038)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_typeve#709038)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_action#709039)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_action#709039)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_traite#709040)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_traite#709040)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_dateve#709041)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_dateve#709041)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_heueve#709042)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_heueve#709042)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_numdos#709043)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_numdos#709043)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_numdem#709044)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_numdem#709044)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_numpco#709045)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_numpco#709045)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_numcot#709046)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_numcot#709046)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_numcr#709047)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_numcr#709047)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_numfus#709048)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_numfus#709048)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_numexa#709049)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_numexa#709049)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_datmaj#709050)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_datmaj#709050)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_coduti#709051)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_coduti#709051)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_codsit#709052)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_codsit#709052)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_comment#709053)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_comment#709053)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_numdrv#709054)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_numdrv#709054)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_flmanu#709055)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_flmanu#709055)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_datmajmanu#709056)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_datmajmanu#709056)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_heumajmanu#709057)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_heumajmanu#709057)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_sta_env#709058)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_sta_env#709058)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_numdos_dest#709059)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_numdos_dest#709059)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_numdem_dest#709060)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_numdem_dest#709060)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_sigma#709061)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_sigma#709061)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_numresa#709062)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_numresa#709062)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_numpan#709063)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_numpan#709063)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_xmldata#709064)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_xmldata#709064)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_nummcr#709065)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_nummcr#709065)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_numstu#709066)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_numstu#709066)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_numcde#709067)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_numcde#709067)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_numlcd#709068)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_numlcd#709068)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_nummvt#709069)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_nummvt#709069)), 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#709037,vn_typeve#709038,vn_action#709039,vn_traite#709040,vn_dateve#709041,vn_heueve#709042,vn_numdos#709043,vn_numdem#709044,vn_numpco#709045,vn_numcot#709046,vn_numcr#709047,vn_numfus#709048,vn_numexa#709049,vn_datmaj#709050,vn_coduti#709051,vn_codsit#709052,vn_comment#709053,vn_numdrv#709054,vn_flmanu#709055,vn_datmajmanu#709056,vn_heumajmanu#709057,vn_sta_env#709058,vn_numdos_dest#709059,vn_numdem_dest#709060,... 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#708284, vn_typeve#708285, vn_action#708286, vn_traite#708287, vn_dateve#708288, vn_heueve#708289, vn_numdos#708290, vn_numdem#708291, vn_numpco#708292, vn_numcot#708293, vn_numcr#708294, vn_numfus#708295, vn_numexa#708296, vn_datmaj#708297, vn_coduti#708298, vn_codsit#708299, vn_comment#708300, vn_numdrv#708301, vn_flmanu#708302, vn_datmajmanu#708303, vn_heumajmanu#708304, vn_sta_env#708305, vn_numdos_dest#708306, vn_numdem_dest#708307, vn_sigma#708308, vn_numresa#708309, vn_numpan#708310, vn_xmldata#708311, vn_nummcr#708312, vn_numstu#708313, vn_numcde#708314, vn_numlcd#708315, vn_nummvt#708316]
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#708284, vn_typeve#708285, vn_action#708286, vn_traite#708287, vn_dateve#708288, vn_heueve#708289, vn_numdos#708290, vn_numdem#708291, vn_numpco#708292, vn_numcot#708293, vn_numcr#708294, vn_numfus#708295, vn_numexa#708296, vn_datmaj#708297, vn_coduti#708298, vn_codsit#708299, vn_comment#708300, vn_numdrv#708301, vn_flmanu#708302, vn_datmajmanu#708303, vn_heumajmanu#708304, vn_sta_env#708305, vn_numdos_dest#708306, vn_numdem_dest#708307, vn_sigma#708308, vn_numresa#708309, vn_numpan#708310, vn_xmldata#708311, vn_nummcr#708312, vn_numstu#708313, vn_numcde#708314, vn_numlcd#708315, vn_nummvt#708316]
Condition : (((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(vn_numeve#708284)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_numeve#708284)), MAIN) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_typeve#708285)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_typeve#708285)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_action#708286)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_action#708286)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_traite#708287)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_traite#708287)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_dateve#708288)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_dateve#708288)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_heueve#708289)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_heueve#708289)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_numdos#708290)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_numdos#708290)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_numdem#708291)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_numdem#708291)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_numpco#708292)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_numpco#708292)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_numcot#708293)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_numcot#708293)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_numcr#708294)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_numcr#708294)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_numfus#708295)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_numfus#708295)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_numexa#708296)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_numexa#708296)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_datmaj#708297)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_datmaj#708297)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_coduti#708298)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_coduti#708298)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_codsit#708299)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_codsit#708299)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_comment#708300)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_comment#708300)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_numdrv#708301)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_numdrv#708301)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_flmanu#708302)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_flmanu#708302)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_datmajmanu#708303)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_datmajmanu#708303)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_heumajmanu#708304)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_heumajmanu#708304)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_sta_env#708305)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_sta_env#708305)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_numdos_dest#708306)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_numdos_dest#708306)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_numdem_dest#708307)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_numdem_dest#708307)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_sigma#708308)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_sigma#708308)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_numresa#708309)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_numresa#708309)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_numpan#708310)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_numpan#708310)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_xmldata#708311)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_xmldata#708311)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_nummcr#708312)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_nummcr#708312)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_numstu#708313)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_numstu#708313)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_numcde#708314)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_numcde#708314)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_numlcd#708315)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_numlcd#708315)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_nummvt#708316)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_nummvt#708316)), 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#708284, vn_typeve#708285, vn_action#708286, vn_traite#708287, vn_dateve#708288, vn_heueve#708289, vn_numdos#708290, vn_numdem#708291, vn_numpco#708292, vn_numcot#708293, vn_numcr#708294, vn_numfus#708295, vn_numexa#708296, vn_datmaj#708297, vn_coduti#708298, vn_codsit#708299, vn_comment#708300, vn_numdrv#708301, vn_flmanu#708302, vn_datmajmanu#708303, vn_heumajmanu#708304, vn_sta_env#708305, vn_numdos_dest#708306, vn_numdem_dest#708307, vn_sigma#708308, vn_numresa#708309, vn_numpan#708310, vn_xmldata#708311, vn_nummcr#708312, vn_numstu#708313, vn_numcde#708314, vn_numlcd#708315, vn_nummvt#708316]

(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#709037, vn_typeve#709038, vn_action#709039, vn_traite#709040, vn_dateve#709041, vn_heueve#709042, vn_numdos#709043, vn_numdem#709044, vn_numpco#709045, vn_numcot#709046, vn_numcr#709047, vn_numfus#709048, vn_numexa#709049, vn_datmaj#709050, vn_coduti#709051, vn_codsit#709052, vn_comment#709053, vn_numdrv#709054, vn_flmanu#709055, vn_datmajmanu#709056, vn_heumajmanu#709057, vn_sta_env#709058, vn_numdos_dest#709059, vn_numdem_dest#709060, vn_sigma#709061, vn_numresa#709062, vn_numpan#709063, vn_xmldata#709064, vn_nummcr#709065, vn_numstu#709066, vn_numcde#709067, vn_numlcd#709068, vn_nummvt#709069]
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#709037, vn_typeve#709038, vn_action#709039, vn_traite#709040, vn_dateve#709041, vn_heueve#709042, vn_numdos#709043, vn_numdem#709044, vn_numpco#709045, vn_numcot#709046, vn_numcr#709047, vn_numfus#709048, vn_numexa#709049, vn_datmaj#709050, vn_coduti#709051, vn_codsit#709052, vn_comment#709053, vn_numdrv#709054, vn_flmanu#709055, vn_datmajmanu#709056, vn_heumajmanu#709057, vn_sta_env#709058, vn_numdos_dest#709059, vn_numdem_dest#709060, vn_sigma#709061, vn_numresa#709062, vn_numpan#709063, vn_xmldata#709064, vn_nummcr#709065, vn_numstu#709066, vn_numcde#709067, vn_numlcd#709068, vn_nummvt#709069]
Condition : (((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(vn_numeve#709037)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_numeve#709037)), MAIN) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_typeve#709038)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_typeve#709038)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_action#709039)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_action#709039)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_traite#709040)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_traite#709040)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_dateve#709041)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_dateve#709041)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_heueve#709042)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_heueve#709042)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_numdos#709043)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_numdos#709043)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_numdem#709044)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_numdem#709044)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_numpco#709045)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_numpco#709045)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_numcot#709046)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_numcot#709046)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_numcr#709047)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_numcr#709047)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_numfus#709048)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_numfus#709048)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_numexa#709049)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_numexa#709049)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_datmaj#709050)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_datmaj#709050)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_coduti#709051)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_coduti#709051)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_codsit#709052)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_codsit#709052)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_comment#709053)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_comment#709053)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_numdrv#709054)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_numdrv#709054)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_flmanu#709055)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_flmanu#709055)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_datmajmanu#709056)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_datmajmanu#709056)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_heumajmanu#709057)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_heumajmanu#709057)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_sta_env#709058)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_sta_env#709058)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_numdos_dest#709059)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_numdos_dest#709059)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_numdem_dest#709060)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_numdem_dest#709060)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_sigma#709061)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_sigma#709061)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_numresa#709062)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_numresa#709062)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_numpan#709063)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_numpan#709063)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_xmldata#709064)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_xmldata#709064)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_nummcr#709065)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_nummcr#709065)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_numstu#709066)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_numstu#709066)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_numcde#709067)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_numcde#709067)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_numlcd#709068)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_numlcd#709068)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_nummvt#709069)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(vn_nummvt#709069)), 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#709037, vn_typeve#709038, vn_action#709039, vn_traite#709040, vn_dateve#709041, vn_heueve#709042, vn_numdos#709043, vn_numdem#709044, vn_numpco#709045, vn_numcot#709046, vn_numcr#709047, vn_numfus#709048, vn_numexa#709049, vn_datmaj#709050, vn_coduti#709051, vn_codsit#709052, vn_comment#709053, vn_numdrv#709054, vn_flmanu#709055, vn_datmajmanu#709056, vn_heumajmanu#709057, vn_sta_env#709058, vn_numdos_dest#709059, vn_numdem_dest#709060, vn_sigma#709061, vn_numresa#709062, vn_numpan#709063, vn_xmldata#709064, vn_nummcr#709065, vn_numstu#709066, vn_numcde#709067, vn_numlcd#709068, vn_nummvt#709069]

(7) Union

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

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

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

(11) HashAggregate [codegen id : 4]
Input [1]: [count#710803L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#709935L]
Results [1]: [count(1)#709935L AS COL_0802a3b5-3342-454d-9d12-ccc0c3d9eb86#709937L]

(12) Union

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

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

(15) HashAggregate
Input [1]: [count#710803L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#709935L]
Results [1]: [count(1)#709935L AS COL_0802a3b5-3342-454d-9d12-ccc0c3d9eb86#709937L]

(16) AdaptiveSparkPlan
Output [1]: [COL_0802a3b5-3342-454d-9d12-ccc0c3d9eb86#709937L]
Arguments: isFinalPlan=true

SQL / DataFrame Properties

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