hdh-spark-job - Details for Query 1298

Submitted Time: 2026/10/23 13:26:27
Duration: 4 s
Succeeded Jobs: 1297 1302

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

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

WholeStageCodegen (3)

Union

Project

Filter (((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(vn_numeve#630982)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(vn_numeve#630982)), MARX) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_typeve#630983)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(vn_typeve#630983)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_action#630984)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(vn_action#630984)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_traite#630985)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(vn_traite#630985)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_dateve#630986)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(vn_dateve#630986)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_heueve#630987)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(vn_heueve#630987)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_numdos#630988)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(vn_numdos#630988)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_numdem#630989)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(vn_numdem#630989)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_numpco#630990)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(vn_numpco#630990)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_numcot#630991)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(vn_numcot#630991)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_numcr#630992)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(vn_numcr#630992)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_numfus#630993)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(vn_numfus#630993)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_numexa#630994)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(vn_numexa#630994)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_datmaj#630995)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(vn_datmaj#630995)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_coduti#630996)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(vn_coduti#630996)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_codsit#630997)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(vn_codsit#630997)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_comment#630998)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(vn_comment#630998)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_numdrv#630999)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(vn_numdrv#630999)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_flmanu#631000)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(vn_flmanu#631000)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_datmajmanu#631001)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(vn_datmajmanu#631001)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_heumajmanu#631002)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(vn_heumajmanu#631002)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_sta_env#631003)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(vn_sta_env#631003)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_numdos_dest#631004)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(vn_numdos_dest#631004)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_numdem_dest#631005)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(vn_numdem_dest#631005)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_sigma#631006)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(vn_sigma#631006)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_numresa#631007)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(vn_numresa#631007)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_numpan#631008)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(vn_numpan#631008)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_xmldata#631009)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(vn_xmldata#631009)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_nummcr#631010)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(vn_nummcr#631010)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_numstu#631011)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(vn_numstu#631011)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_numcde#631012)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(vn_numcde#631012)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_numlcd#631013)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(vn_numlcd#631013)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_nummvt#631014)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(vn_nummvt#631014)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_create(Cab_A))), MARX)) THEN false ELSE Contains(str_remove_accent(upper(str_create(Cab_A))), MARX) END)

Scan JDBCRelation((SELECT "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#630982,vn_typeve#630983,vn_action#630984,vn_traite#630985,vn_dateve#630986,vn_heueve#630987,vn_numdos#630988,vn_numdem#630989,vn_numpco#630990,vn_numcot#630991,vn_numcr#630992,vn_numfus#630993,vn_numexa#630994,vn_datmaj#630995,vn_coduti#630996,vn_codsit#630997,vn_comment#630998,vn_numdrv#630999,vn_flmanu#631000,vn_datmajmanu#631001,vn_heumajmanu#631002,vn_sta_env#631003,vn_numdos_dest#631004,vn_numdem_dest#631005,... 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#631577)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(vn_numeve#631577)), MARX) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_typeve#631578)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(vn_typeve#631578)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_action#631579)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(vn_action#631579)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_traite#631580)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(vn_traite#631580)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_dateve#631581)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(vn_dateve#631581)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_heueve#631582)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(vn_heueve#631582)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_numdos#631583)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(vn_numdos#631583)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_numdem#631584)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(vn_numdem#631584)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_numpco#631585)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(vn_numpco#631585)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_numcot#631586)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(vn_numcot#631586)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_numcr#631587)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(vn_numcr#631587)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_numfus#631588)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(vn_numfus#631588)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_numexa#631589)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(vn_numexa#631589)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_datmaj#631590)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(vn_datmaj#631590)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_coduti#631591)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(vn_coduti#631591)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_codsit#631592)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(vn_codsit#631592)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_comment#631593)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(vn_comment#631593)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_numdrv#631594)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(vn_numdrv#631594)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_flmanu#631595)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(vn_flmanu#631595)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_datmajmanu#631596)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(vn_datmajmanu#631596)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_heumajmanu#631597)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(vn_heumajmanu#631597)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_sta_env#631598)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(vn_sta_env#631598)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_numdos_dest#631599)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(vn_numdos_dest#631599)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_numdem_dest#631600)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(vn_numdem_dest#631600)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_sigma#631601)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(vn_sigma#631601)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_numresa#631602)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(vn_numresa#631602)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_numpan#631603)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(vn_numpan#631603)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_xmldata#631604)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(vn_xmldata#631604)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_nummcr#631605)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(vn_nummcr#631605)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_numstu#631606)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(vn_numstu#631606)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_numcde#631607)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(vn_numcde#631607)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_numlcd#631608)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(vn_numlcd#631608)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_nummvt#631609)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(vn_nummvt#631609)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_create(Cab_B))), MARX)) THEN false ELSE Contains(str_remove_accent(upper(str_create(Cab_B))), MARX) END)

Scan JDBCRelation((SELECT "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#631577,vn_typeve#631578,vn_action#631579,vn_traite#631580,vn_dateve#631581,vn_heueve#631582,vn_numdos#631583,vn_numdem#631584,vn_numpco#631585,vn_numcot#631586,vn_numcr#631587,vn_numfus#631588,vn_numexa#631589,vn_datmaj#631590,vn_coduti#631591,vn_codsit#631592,vn_comment#631593,vn_numdrv#631594,vn_flmanu#631595,vn_datmajmanu#631596,vn_heumajmanu#631597,vn_sta_env#631598,vn_numdos_dest#631599,vn_numdem_dest#631600,... 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#630982, vn_typeve#630983, vn_action#630984, vn_traite#630985, vn_dateve#630986, vn_heueve#630987, vn_numdos#630988, vn_numdem#630989, vn_numpco#630990, vn_numcot#630991, vn_numcr#630992, vn_numfus#630993, vn_numexa#630994, vn_datmaj#630995, vn_coduti#630996, vn_codsit#630997, vn_comment#630998, vn_numdrv#630999, vn_flmanu#631000, vn_datmajmanu#631001, vn_heumajmanu#631002, vn_sta_env#631003, vn_numdos_dest#631004, vn_numdem_dest#631005, vn_sigma#631006, vn_numresa#631007, vn_numpan#631008, vn_xmldata#631009, vn_nummcr#631010, vn_numstu#631011, vn_numcde#631012, vn_numlcd#631013, vn_nummvt#631014]
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#630982, vn_typeve#630983, vn_action#630984, vn_traite#630985, vn_dateve#630986, vn_heueve#630987, vn_numdos#630988, vn_numdem#630989, vn_numpco#630990, vn_numcot#630991, vn_numcr#630992, vn_numfus#630993, vn_numexa#630994, vn_datmaj#630995, vn_coduti#630996, vn_codsit#630997, vn_comment#630998, vn_numdrv#630999, vn_flmanu#631000, vn_datmajmanu#631001, vn_heumajmanu#631002, vn_sta_env#631003, vn_numdos_dest#631004, vn_numdem_dest#631005, vn_sigma#631006, vn_numresa#631007, vn_numpan#631008, vn_xmldata#631009, vn_nummcr#631010, vn_numstu#631011, vn_numcde#631012, vn_numlcd#631013, vn_nummvt#631014]
Condition : (((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(vn_numeve#630982)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(vn_numeve#630982)), MARX) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_typeve#630983)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(vn_typeve#630983)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_action#630984)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(vn_action#630984)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_traite#630985)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(vn_traite#630985)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_dateve#630986)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(vn_dateve#630986)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_heueve#630987)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(vn_heueve#630987)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_numdos#630988)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(vn_numdos#630988)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_numdem#630989)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(vn_numdem#630989)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_numpco#630990)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(vn_numpco#630990)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_numcot#630991)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(vn_numcot#630991)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_numcr#630992)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(vn_numcr#630992)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_numfus#630993)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(vn_numfus#630993)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_numexa#630994)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(vn_numexa#630994)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_datmaj#630995)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(vn_datmaj#630995)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_coduti#630996)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(vn_coduti#630996)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_codsit#630997)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(vn_codsit#630997)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_comment#630998)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(vn_comment#630998)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_numdrv#630999)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(vn_numdrv#630999)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_flmanu#631000)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(vn_flmanu#631000)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_datmajmanu#631001)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(vn_datmajmanu#631001)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_heumajmanu#631002)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(vn_heumajmanu#631002)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_sta_env#631003)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(vn_sta_env#631003)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_numdos_dest#631004)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(vn_numdos_dest#631004)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_numdem_dest#631005)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(vn_numdem_dest#631005)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_sigma#631006)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(vn_sigma#631006)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_numresa#631007)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(vn_numresa#631007)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_numpan#631008)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(vn_numpan#631008)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_xmldata#631009)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(vn_xmldata#631009)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_nummcr#631010)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(vn_nummcr#631010)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_numstu#631011)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(vn_numstu#631011)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_numcde#631012)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(vn_numcde#631012)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_numlcd#631013)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(vn_numlcd#631013)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_nummvt#631014)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(vn_nummvt#631014)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_create(Cab_A))), MARX)) THEN false ELSE Contains(str_remove_accent(upper(str_create(Cab_A))), MARX) END)

(3) Project [codegen id : 1]
Output: []
Input [33]: [vn_numeve#630982, vn_typeve#630983, vn_action#630984, vn_traite#630985, vn_dateve#630986, vn_heueve#630987, vn_numdos#630988, vn_numdem#630989, vn_numpco#630990, vn_numcot#630991, vn_numcr#630992, vn_numfus#630993, vn_numexa#630994, vn_datmaj#630995, vn_coduti#630996, vn_codsit#630997, vn_comment#630998, vn_numdrv#630999, vn_flmanu#631000, vn_datmajmanu#631001, vn_heumajmanu#631002, vn_sta_env#631003, vn_numdos_dest#631004, vn_numdem_dest#631005, vn_sigma#631006, vn_numresa#631007, vn_numpan#631008, vn_xmldata#631009, vn_nummcr#631010, vn_numstu#631011, vn_numcde#631012, vn_numlcd#631013, vn_nummvt#631014]

(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#631577, vn_typeve#631578, vn_action#631579, vn_traite#631580, vn_dateve#631581, vn_heueve#631582, vn_numdos#631583, vn_numdem#631584, vn_numpco#631585, vn_numcot#631586, vn_numcr#631587, vn_numfus#631588, vn_numexa#631589, vn_datmaj#631590, vn_coduti#631591, vn_codsit#631592, vn_comment#631593, vn_numdrv#631594, vn_flmanu#631595, vn_datmajmanu#631596, vn_heumajmanu#631597, vn_sta_env#631598, vn_numdos_dest#631599, vn_numdem_dest#631600, vn_sigma#631601, vn_numresa#631602, vn_numpan#631603, vn_xmldata#631604, vn_nummcr#631605, vn_numstu#631606, vn_numcde#631607, vn_numlcd#631608, vn_nummvt#631609]
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#631577, vn_typeve#631578, vn_action#631579, vn_traite#631580, vn_dateve#631581, vn_heueve#631582, vn_numdos#631583, vn_numdem#631584, vn_numpco#631585, vn_numcot#631586, vn_numcr#631587, vn_numfus#631588, vn_numexa#631589, vn_datmaj#631590, vn_coduti#631591, vn_codsit#631592, vn_comment#631593, vn_numdrv#631594, vn_flmanu#631595, vn_datmajmanu#631596, vn_heumajmanu#631597, vn_sta_env#631598, vn_numdos_dest#631599, vn_numdem_dest#631600, vn_sigma#631601, vn_numresa#631602, vn_numpan#631603, vn_xmldata#631604, vn_nummcr#631605, vn_numstu#631606, vn_numcde#631607, vn_numlcd#631608, vn_nummvt#631609]
Condition : (((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(vn_numeve#631577)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(vn_numeve#631577)), MARX) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_typeve#631578)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(vn_typeve#631578)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_action#631579)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(vn_action#631579)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_traite#631580)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(vn_traite#631580)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_dateve#631581)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(vn_dateve#631581)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_heueve#631582)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(vn_heueve#631582)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_numdos#631583)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(vn_numdos#631583)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_numdem#631584)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(vn_numdem#631584)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_numpco#631585)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(vn_numpco#631585)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_numcot#631586)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(vn_numcot#631586)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_numcr#631587)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(vn_numcr#631587)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_numfus#631588)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(vn_numfus#631588)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_numexa#631589)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(vn_numexa#631589)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_datmaj#631590)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(vn_datmaj#631590)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_coduti#631591)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(vn_coduti#631591)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_codsit#631592)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(vn_codsit#631592)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_comment#631593)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(vn_comment#631593)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_numdrv#631594)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(vn_numdrv#631594)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_flmanu#631595)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(vn_flmanu#631595)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_datmajmanu#631596)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(vn_datmajmanu#631596)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_heumajmanu#631597)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(vn_heumajmanu#631597)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_sta_env#631598)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(vn_sta_env#631598)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_numdos_dest#631599)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(vn_numdos_dest#631599)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_numdem_dest#631600)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(vn_numdem_dest#631600)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_sigma#631601)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(vn_sigma#631601)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_numresa#631602)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(vn_numresa#631602)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_numpan#631603)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(vn_numpan#631603)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_xmldata#631604)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(vn_xmldata#631604)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_nummcr#631605)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(vn_nummcr#631605)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_numstu#631606)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(vn_numstu#631606)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_numcde#631607)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(vn_numcde#631607)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_numlcd#631608)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(vn_numlcd#631608)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(vn_nummvt#631609)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(vn_nummvt#631609)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_create(Cab_B))), MARX)) THEN false ELSE Contains(str_remove_accent(upper(str_create(Cab_B))), MARX) END)

(6) Project [codegen id : 2]
Output: []
Input [33]: [vn_numeve#631577, vn_typeve#631578, vn_action#631579, vn_traite#631580, vn_dateve#631581, vn_heueve#631582, vn_numdos#631583, vn_numdem#631584, vn_numpco#631585, vn_numcot#631586, vn_numcr#631587, vn_numfus#631588, vn_numexa#631589, vn_datmaj#631590, vn_coduti#631591, vn_codsit#631592, vn_comment#631593, vn_numdrv#631594, vn_flmanu#631595, vn_datmajmanu#631596, vn_heumajmanu#631597, vn_sta_env#631598, vn_numdos_dest#631599, vn_numdem_dest#631600, vn_sigma#631601, vn_numresa#631602, vn_numpan#631603, vn_xmldata#631604, vn_nummcr#631605, vn_numstu#631606, vn_numcde#631607, vn_numlcd#631608, vn_nummvt#631609]

(7) Union

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

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

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

(11) HashAggregate [codegen id : 4]
Input [1]: [count#632290L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#632214L]
Results [1]: [count(1)#632214L AS COL_e4a6013c-07c8-486f-bc8d-7b59376249d4#632216L]

(12) Union

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

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

(15) HashAggregate
Input [1]: [count#632290L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#632214L]
Results [1]: [count(1)#632214L AS COL_e4a6013c-07c8-486f-bc8d-7b59376249d4#632216L]

(16) AdaptiveSparkPlan
Output [1]: [COL_e4a6013c-07c8-486f-bc8d-7b59376249d4#632216L]
Arguments: isFinalPlan=true

SQL / DataFrame Properties

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