hdh-spark-job - Details for Query 747

Submitted Time: 2026/10/21 21:36:50
Duration: 4 s
Succeeded Jobs: 743 752

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 (2)\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: 1 local merged chunks fetched: 0 shuffle write time: 0 ms 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: 1 local bytes read: 59.0 B fetch wait time: 0 ms remote bytes read: 0.0 B merged fetch fallback count: 0 local blocks read: 1 remote merged chunks fetched: 0 remote blocks read: 0 data size: 16.0 B 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: 59.0 B"]; subgraph cluster4 { isCluster="true"; label="WholeStageCodegen (1)\n \nduration: 1.7 s"; 5 [labelType="html" label="HashAggregate time in aggregation build: 1.7 s number of output rows: 1"]; 6 [labelType="html" label=" Project "]; 7 [labelType="html" label="Filter number of output rows: 1"]; 8 [labelType="html" label="ColumnarToRow number of output rows: 34,851 number of input batches: 9"]; } 9 [labelType="html" label="Scan parquet number of files read: 1 scan time: 23 ms metadata time: 0 ms size of files read: 1014.0 KiB number of output rows: 34,851"]; 2->0; 3->2; 5->3; 6->5; 7->6; 8->7; 9->8; }

AdaptiveSparkPlan isFinalPlan=true

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

WholeStageCodegen (2)

Exchange SinglePartition, ENSURE_REQUIREMENTS, [plan_id=15485]

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

Project

Filter ((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NUMEXA_437692#164361)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_NUMEXA_437692#164361)), A63000893163) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NUMDOS_437693#164360)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_NUMDOS_437693#164360)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NUMDEM_437694#164359)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_NUMDEM_437694#164359)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_TYPEXA_437695#164390)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_TYPEXA_437695#164390)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_CODEXA_437696#164312)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_CODEXA_437696#164312)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_EXAACC_437697#164335)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_EXAACC_437697#164335)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_LIBEXA_437698#164351)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_LIBEXA_437698#164351)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_CODAPP_437699#164310)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_CODAPP_437699#164310)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NUMSAL_437700#164370)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_NUMSAL_437700#164370)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_CODPER_437701#164315)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_CODPER_437701#164315)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_CODRAD_437702#164319)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_CODRAD_437702#164319)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_CODPRO_437703#164317)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_CODPRO_437703#164317)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_M_AM_I_437704#164354)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_M_AM_I_437704#164354)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_AG_ON_437705#164306)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_AG_ON_437705#164306)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_DATEXA_437706#164327)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_DATEXA_437706#164327)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_HEUEXA_437707#164344)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_HEUEXA_437707#164344)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_HEUSAL_437708#164348)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_HEUSAL_437708#164348)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_HEUFIN_437709#164345)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_HEUFIN_437709#164345)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_DURTOT_437710#164334)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_DURTOT_437710#164334)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_DURAVA_437711#164332)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_DURAVA_437711#164332)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_DURPEN_437712#164333)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_DURPEN_437712#164333)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_DURAPR_437713#164331)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_DURAPR_437713#164331)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_DATARR_437714#164326)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_DATARR_437714#164326)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_HEUARR_437715#164342)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_HEUARR_437715#164342)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_HEUD_E_437716#164343)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_HEUD_E_437716#164343)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_HEUF_E_437717#164347)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_HEUF_E_437717#164347)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_CODSIT_437718#164320)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_CODSIT_437718#164320)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_DATMAJ_437719#164330)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_DATMAJ_437719#164330)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_CODUTI_437720#164321)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_CODUTI_437720#164321)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NUMSAT_437721#164371)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_NUMSAT_437721#164371)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_AFFECT_437722#164305)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_AFFECT_437722#164305)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_STU_ID_437723#164384)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_STU_ID_437723#164384)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_STA_PPS_437724#164383)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_STA_PPS_437724#164383)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_SOP_UID_437725#164381)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_SOP_UID_437725#164381)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NUMGRP_437726#164363)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_NUMGRP_437726#164363)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_CARRDV_437727#164309)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_CARRDV_437727#164309)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_SANSCR_437728#164379)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_SANSCR_437728#164379)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_CODATS_437729#164311)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_CODATS_437729#164311)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_STABCD_437730#164382)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_STABCD_437730#164382)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_TYPESCLQ_437731#164389)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_TYPESCLQ_437731#164389)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_TYPBCD_437732#164388)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_TYPBCD_437732#164388)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_CODPRX_437733#164318)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_CODPRX_437733#164318)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_FLPLAN_437734#164339)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_FLPLAN_437734#164339)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_AVAILABLE_437735#164308)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_AVAILABLE_437735#164308)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_AETITLE_437736#164304)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_AETITLE_437736#164304)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_SECONDAIRE_437737#164380)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_SECONDAIRE_437737#164380)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_MEDNUC_437738#164352)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_MEDNUC_437738#164352)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_FLTBDI_437739#164340)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_FLTBDI_437739#164340)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_CODFVU_437740#164313)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_CODFVU_437740#164313)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_DATFVU_437741#164329)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_DATFVU_437741#164329)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_HEUFVU_437742#164346)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_HEUFVU_437742#164346)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_SUSPENS_437743#164386)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_SUSPENS_437743#164386)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_ACADOS_437744#164300)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_ACADOS_437744#164300)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_ACAPUB_437745#164303)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_ACAPUB_437745#164303)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_ACAMED_437746#164302)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_ACAMED_437746#164302)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_ACALIB_437747#164301)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_ACALIB_437747#164301)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_LATER_437748#164350)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_LATER_437748#164350)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_POSITION_437749#164377)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_POSITION_437749#164377)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_INCIDENCE_437750#164349)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_INCIDENCE_437750#164349)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NUMPDT_437751#164366)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_NUMPDT_437751#164366)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NUMORD_437752#164365)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_NUMORD_437752#164365)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_TRSTAT_437753#164387)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_TRSTAT_437753#164387)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_ORGANE_437754#164375)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_ORGANE_437754#164375)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_HEUAPP_437755#164341)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_HEUAPP_437755#164341)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_ORIRDV_437756#164376)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_ORIRDV_437756#164376)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_CODVAC_437757#164323)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_CODVAC_437757#164323)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_CODVACA_437758#164322)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_CODVACA_437758#164322)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NUMXUS_437759#164374)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_NUMXUS_437759#164374)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NUMEXA_ORI_437760#164362)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_NUMEXA_ORI_437760#164362)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_EXACOT_437761#164336)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_EXACOT_437761#164336)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_FLNOCOT_437762#164338)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_FLNOCOT_437762#164338)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_ALARMES_437763#164307)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_ALARMES_437763#164307)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_MODAL_AET_437764#164353)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_MODAL_AET_437764#164353)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NUMPRORE_437765#164367)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_NUMPRORE_437765#164367)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_COMPRORE_437766#164325)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_COMPRORE_437766#164325)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NUMRVX_437767#164369)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_NUMRVX_437767#164369)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NOSEQ_437768#164358)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_NOSEQ_437768#164358)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_DATFIN_437769#164328)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_DATFIN_437769#164328)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NUMRESA_437770#164368)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_NUMRESA_437770#164368)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_FHIRID_437771#164337)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_FHIRID_437771#164337)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_REGANA_437772#164378)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_REGANA_437772#164378)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NB_SER_437773#164357)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_NB_SER_437773#164357)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NB_FIC_437774#164355)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_NB_FIC_437774#164355)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NB_IMG_KEY_437775#164356)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_NB_IMG_KEY_437775#164356)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_STU_ID_ORI_437776#164385)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_STU_ID_ORI_437776#164385)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_CODPER_PRORE_437777#164316)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_CODPER_PRORE_437777#164316)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NUMSEANCE_437778#164372)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_NUMSEANCE_437778#164372)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NUMORDSEANCE_437779#164364)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_NUMORDSEANCE_437779#164364)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NUMTRT_437780#164373)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_NUMTRT_437780#164373)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_COMMENT_437781#164324)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_COMMENT_437781#164324)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_CODLOINC_437782#164314)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_CODLOINC_437782#164314)), A63000893163) END)

ColumnarToRow

WholeStageCodegen (1)

FileScan parquet [ET_ACADOS_437744#164300,ET_ACALIB_437747#164301,ET_ACAMED_437746#164302,ET_ACAPUB_437745#164303,ET_AETITLE_437736#164304,ET_AFFECT_437722#164305,ET_AG_ON_437705#164306,ET_ALARMES_437763#164307,ET_AVAILABLE_437735#164308,ET_CARRDV_437727#164309,ET_CODAPP_437699#164310,ET_CODATS_437729#164311,ET_CODEXA_437696#164312,ET_CODFVU_437740#164313,ET_CODLOINC_437782#164314,ET_CODPER_437701#164315,ET_CODPER_PRORE_437777#164316,ET_CODPRO_437703#164317,ET_CODPRX_437733#164318,ET_CODRAD_437702#164319,ET_CODSIT_437718#164320,ET_CODUTI_437720#164321,ET_CODVACA_437758#164322,ET_CODVAC_437757#164323,... 67 more fields] Batched: true, DataFilters: [((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((CASE W..., Format: Parquet, Location: InMemoryFileIndex(1 paths)[file:/data/output/cache/parquet/uet/H_DETEXA_437691], PartitionFilters: [], PushedFilters: [], ReadSchema: struct<ET_ACADOS_437744:string,ET_ACALIB_437747:string,ET_ACAMED_437746:string,ET_ACAPUB_437745:s...

Details

== Physical Plan ==
AdaptiveSparkPlan (14)
+- == Final Plan ==
   * HashAggregate (8)
   +- ShuffleQueryStage (7), Statistics(sizeInBytes=16.0 B, rowCount=1)
      +- Exchange (6)
         +- * HashAggregate (5)
            +- * Project (4)
               +- * Filter (3)
                  +- * ColumnarToRow (2)
                     +- Scan parquet  (1)
+- == Initial Plan ==
   HashAggregate (13)
   +- Exchange (12)
      +- HashAggregate (11)
         +- Project (10)
            +- Filter (9)
               +- Scan parquet  (1)


(1) Scan parquet 
Output [91]: [ET_ACADOS_437744#164300, ET_ACALIB_437747#164301, ET_ACAMED_437746#164302, ET_ACAPUB_437745#164303, ET_AETITLE_437736#164304, ET_AFFECT_437722#164305, ET_AG_ON_437705#164306, ET_ALARMES_437763#164307, ET_AVAILABLE_437735#164308, ET_CARRDV_437727#164309, ET_CODAPP_437699#164310, ET_CODATS_437729#164311, ET_CODEXA_437696#164312, ET_CODFVU_437740#164313, ET_CODLOINC_437782#164314, ET_CODPER_437701#164315, ET_CODPER_PRORE_437777#164316, ET_CODPRO_437703#164317, ET_CODPRX_437733#164318, ET_CODRAD_437702#164319, ET_CODSIT_437718#164320, ET_CODUTI_437720#164321, ET_CODVACA_437758#164322, ET_CODVAC_437757#164323, ET_COMMENT_437781#164324, ET_COMPRORE_437766#164325, ET_DATARR_437714#164326, ET_DATEXA_437706#164327, ET_DATFIN_437769#164328, ET_DATFVU_437741#164329, ET_DATMAJ_437719#164330, ET_DURAPR_437713#164331, ET_DURAVA_437711#164332, ET_DURPEN_437712#164333, ET_DURTOT_437710#164334, ET_EXAACC_437697#164335, ET_EXACOT_437761#164336, ET_FHIRID_437771#164337, ET_FLNOCOT_437762#164338, ET_FLPLAN_437734#164339, ET_FLTBDI_437739#164340, ET_HEUAPP_437755#164341, ET_HEUARR_437715#164342, ET_HEUD_E_437716#164343, ET_HEUEXA_437707#164344, ET_HEUFIN_437709#164345, ET_HEUFVU_437742#164346, ET_HEUF_E_437717#164347, ET_HEUSAL_437708#164348, ET_INCIDENCE_437750#164349, ET_LATER_437748#164350, ET_LIBEXA_437698#164351, ET_MEDNUC_437738#164352, ET_MODAL_AET_437764#164353, ET_M_AM_I_437704#164354, ET_NB_FIC_437774#164355, ET_NB_IMG_KEY_437775#164356, ET_NB_SER_437773#164357, ET_NOSEQ_437768#164358, ET_NUMDEM_437694#164359, ET_NUMDOS_437693#164360, ET_NUMEXA_437692#164361, ET_NUMEXA_ORI_437760#164362, ET_NUMGRP_437726#164363, ET_NUMORDSEANCE_437779#164364, ET_NUMORD_437752#164365, ET_NUMPDT_437751#164366, ET_NUMPRORE_437765#164367, ET_NUMRESA_437770#164368, ET_NUMRVX_437767#164369, ET_NUMSAL_437700#164370, ET_NUMSAT_437721#164371, ET_NUMSEANCE_437778#164372, ET_NUMTRT_437780#164373, ET_NUMXUS_437759#164374, ET_ORGANE_437754#164375, ET_ORIRDV_437756#164376, ET_POSITION_437749#164377, ET_REGANA_437772#164378, ET_SANSCR_437728#164379, ET_SECONDAIRE_437737#164380, ET_SOP_UID_437725#164381, ET_STABCD_437730#164382, ET_STA_PPS_437724#164383, ET_STU_ID_437723#164384, ET_STU_ID_ORI_437776#164385, ET_SUSPENS_437743#164386, ET_TRSTAT_437753#164387, ET_TYPBCD_437732#164388, ET_TYPESCLQ_437731#164389, ET_TYPEXA_437695#164390]
Batched: true
Location: InMemoryFileIndex [file:/data/output/cache/parquet/uet/H_DETEXA_437691]
ReadSchema: struct<ET_ACADOS_437744:string,ET_ACALIB_437747:string,ET_ACAMED_437746:string,ET_ACAPUB_437745:string,ET_AETITLE_437736:string,ET_AFFECT_437722:string,ET_AG_ON_437705:string,ET_ALARMES_437763:string,ET_AVAILABLE_437735:string,ET_CARRDV_437727:string,ET_CODAPP_437699:string,ET_CODATS_437729:string,ET_CODEXA_437696:string,ET_CODFVU_437740:string,ET_CODLOINC_437782:string,ET_CODPER_437701:string,ET_CODPER_PRORE_437777:string,ET_CODPRO_437703:string,ET_CODPRX_437733:string,ET_CODRAD_437702:string,ET_CODSIT_437718:string,ET_CODUTI_437720:string,ET_CODVACA_437758:string,ET_CODVAC_437757:string,ET_COMMENT_437781:string,ET_COMPRORE_437766:string,ET_DATARR_437714:string,ET_DATEXA_437706:string,ET_DATFIN_437769:string,ET_DATFVU_437741:string,ET_DATMAJ_437719:string,ET_DURAPR_437713:string,ET_DURAVA_437711:string,ET_DURPEN_437712:string,ET_DURTOT_437710:string,ET_EXAACC_437697:string,ET_EXACOT_437761:string,ET_FHIRID_437771:string,ET_FLNOCOT_437762:string,ET_FLPLAN_437734:string,ET_FLTBDI_437739:string,ET_HEUAPP_437755:string,ET_HEUARR_437715:string,ET_HEUD_E_437716:string,ET_HEUEXA_437707:string,ET_HEUFIN_437709:string,ET_HEUFVU_437742:string,ET_HEUF_E_437717:string,ET_HEUSAL_437708:string,ET_INCIDENCE_437750:string,ET_LATER_437748:string,ET_LIBEXA_437698:string,ET_MEDNUC_437738:string,ET_MODAL_AET_437764:string,ET_M_AM_I_437704:string,ET_NB_FIC_437774:string,ET_NB_IMG_KEY_437775:string,ET_NB_SER_437773:string,ET_NOSEQ_437768:string,ET_NUMDEM_437694:string,ET_NUMDOS_437693:string,ET_NUMEXA_437692:string,ET_NUMEXA_ORI_437760:string,ET_NUMGRP_437726:string,ET_NUMORDSEANCE_437779:string,ET_NUMORD_437752:string,ET_NUMPDT_437751:string,ET_NUMPRORE_437765:string,ET_NUMRESA_437770:string,ET_NUMRVX_437767:string,ET_NUMSAL_437700:string,ET_NUMSAT_437721:string,ET_NUMSEANCE_437778:string,ET_NUMTRT_437780:string,ET_NUMXUS_437759:string,ET_ORGANE_437754:string,ET_ORIRDV_437756:string,ET_POSITION_437749:string,ET_REGANA_437772:string,ET_SANSCR_437728:string,ET_SECONDAIRE_437737:string,ET_SOP_UID_437725:string,ET_STABCD_437730:string,ET_STA_PPS_437724:string,ET_STU_ID_437723:string,ET_STU_ID_ORI_437776:string,ET_SUSPENS_437743:string,ET_TRSTAT_437753:string,ET_TYPBCD_437732:string,ET_TYPESCLQ_437731:string,ET_TYPEXA_437695:string>

(2) ColumnarToRow [codegen id : 1]
Input [91]: [ET_ACADOS_437744#164300, ET_ACALIB_437747#164301, ET_ACAMED_437746#164302, ET_ACAPUB_437745#164303, ET_AETITLE_437736#164304, ET_AFFECT_437722#164305, ET_AG_ON_437705#164306, ET_ALARMES_437763#164307, ET_AVAILABLE_437735#164308, ET_CARRDV_437727#164309, ET_CODAPP_437699#164310, ET_CODATS_437729#164311, ET_CODEXA_437696#164312, ET_CODFVU_437740#164313, ET_CODLOINC_437782#164314, ET_CODPER_437701#164315, ET_CODPER_PRORE_437777#164316, ET_CODPRO_437703#164317, ET_CODPRX_437733#164318, ET_CODRAD_437702#164319, ET_CODSIT_437718#164320, ET_CODUTI_437720#164321, ET_CODVACA_437758#164322, ET_CODVAC_437757#164323, ET_COMMENT_437781#164324, ET_COMPRORE_437766#164325, ET_DATARR_437714#164326, ET_DATEXA_437706#164327, ET_DATFIN_437769#164328, ET_DATFVU_437741#164329, ET_DATMAJ_437719#164330, ET_DURAPR_437713#164331, ET_DURAVA_437711#164332, ET_DURPEN_437712#164333, ET_DURTOT_437710#164334, ET_EXAACC_437697#164335, ET_EXACOT_437761#164336, ET_FHIRID_437771#164337, ET_FLNOCOT_437762#164338, ET_FLPLAN_437734#164339, ET_FLTBDI_437739#164340, ET_HEUAPP_437755#164341, ET_HEUARR_437715#164342, ET_HEUD_E_437716#164343, ET_HEUEXA_437707#164344, ET_HEUFIN_437709#164345, ET_HEUFVU_437742#164346, ET_HEUF_E_437717#164347, ET_HEUSAL_437708#164348, ET_INCIDENCE_437750#164349, ET_LATER_437748#164350, ET_LIBEXA_437698#164351, ET_MEDNUC_437738#164352, ET_MODAL_AET_437764#164353, ET_M_AM_I_437704#164354, ET_NB_FIC_437774#164355, ET_NB_IMG_KEY_437775#164356, ET_NB_SER_437773#164357, ET_NOSEQ_437768#164358, ET_NUMDEM_437694#164359, ET_NUMDOS_437693#164360, ET_NUMEXA_437692#164361, ET_NUMEXA_ORI_437760#164362, ET_NUMGRP_437726#164363, ET_NUMORDSEANCE_437779#164364, ET_NUMORD_437752#164365, ET_NUMPDT_437751#164366, ET_NUMPRORE_437765#164367, ET_NUMRESA_437770#164368, ET_NUMRVX_437767#164369, ET_NUMSAL_437700#164370, ET_NUMSAT_437721#164371, ET_NUMSEANCE_437778#164372, ET_NUMTRT_437780#164373, ET_NUMXUS_437759#164374, ET_ORGANE_437754#164375, ET_ORIRDV_437756#164376, ET_POSITION_437749#164377, ET_REGANA_437772#164378, ET_SANSCR_437728#164379, ET_SECONDAIRE_437737#164380, ET_SOP_UID_437725#164381, ET_STABCD_437730#164382, ET_STA_PPS_437724#164383, ET_STU_ID_437723#164384, ET_STU_ID_ORI_437776#164385, ET_SUSPENS_437743#164386, ET_TRSTAT_437753#164387, ET_TYPBCD_437732#164388, ET_TYPESCLQ_437731#164389, ET_TYPEXA_437695#164390]

(3) Filter [codegen id : 1]
Input [91]: [ET_ACADOS_437744#164300, ET_ACALIB_437747#164301, ET_ACAMED_437746#164302, ET_ACAPUB_437745#164303, ET_AETITLE_437736#164304, ET_AFFECT_437722#164305, ET_AG_ON_437705#164306, ET_ALARMES_437763#164307, ET_AVAILABLE_437735#164308, ET_CARRDV_437727#164309, ET_CODAPP_437699#164310, ET_CODATS_437729#164311, ET_CODEXA_437696#164312, ET_CODFVU_437740#164313, ET_CODLOINC_437782#164314, ET_CODPER_437701#164315, ET_CODPER_PRORE_437777#164316, ET_CODPRO_437703#164317, ET_CODPRX_437733#164318, ET_CODRAD_437702#164319, ET_CODSIT_437718#164320, ET_CODUTI_437720#164321, ET_CODVACA_437758#164322, ET_CODVAC_437757#164323, ET_COMMENT_437781#164324, ET_COMPRORE_437766#164325, ET_DATARR_437714#164326, ET_DATEXA_437706#164327, ET_DATFIN_437769#164328, ET_DATFVU_437741#164329, ET_DATMAJ_437719#164330, ET_DURAPR_437713#164331, ET_DURAVA_437711#164332, ET_DURPEN_437712#164333, ET_DURTOT_437710#164334, ET_EXAACC_437697#164335, ET_EXACOT_437761#164336, ET_FHIRID_437771#164337, ET_FLNOCOT_437762#164338, ET_FLPLAN_437734#164339, ET_FLTBDI_437739#164340, ET_HEUAPP_437755#164341, ET_HEUARR_437715#164342, ET_HEUD_E_437716#164343, ET_HEUEXA_437707#164344, ET_HEUFIN_437709#164345, ET_HEUFVU_437742#164346, ET_HEUF_E_437717#164347, ET_HEUSAL_437708#164348, ET_INCIDENCE_437750#164349, ET_LATER_437748#164350, ET_LIBEXA_437698#164351, ET_MEDNUC_437738#164352, ET_MODAL_AET_437764#164353, ET_M_AM_I_437704#164354, ET_NB_FIC_437774#164355, ET_NB_IMG_KEY_437775#164356, ET_NB_SER_437773#164357, ET_NOSEQ_437768#164358, ET_NUMDEM_437694#164359, ET_NUMDOS_437693#164360, ET_NUMEXA_437692#164361, ET_NUMEXA_ORI_437760#164362, ET_NUMGRP_437726#164363, ET_NUMORDSEANCE_437779#164364, ET_NUMORD_437752#164365, ET_NUMPDT_437751#164366, ET_NUMPRORE_437765#164367, ET_NUMRESA_437770#164368, ET_NUMRVX_437767#164369, ET_NUMSAL_437700#164370, ET_NUMSAT_437721#164371, ET_NUMSEANCE_437778#164372, ET_NUMTRT_437780#164373, ET_NUMXUS_437759#164374, ET_ORGANE_437754#164375, ET_ORIRDV_437756#164376, ET_POSITION_437749#164377, ET_REGANA_437772#164378, ET_SANSCR_437728#164379, ET_SECONDAIRE_437737#164380, ET_SOP_UID_437725#164381, ET_STABCD_437730#164382, ET_STA_PPS_437724#164383, ET_STU_ID_437723#164384, ET_STU_ID_ORI_437776#164385, ET_SUSPENS_437743#164386, ET_TRSTAT_437753#164387, ET_TYPBCD_437732#164388, ET_TYPESCLQ_437731#164389, ET_TYPEXA_437695#164390]
Condition : ((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NUMEXA_437692#164361)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_NUMEXA_437692#164361)), A63000893163) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NUMDOS_437693#164360)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_NUMDOS_437693#164360)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NUMDEM_437694#164359)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_NUMDEM_437694#164359)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_TYPEXA_437695#164390)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_TYPEXA_437695#164390)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_CODEXA_437696#164312)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_CODEXA_437696#164312)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_EXAACC_437697#164335)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_EXAACC_437697#164335)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_LIBEXA_437698#164351)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_LIBEXA_437698#164351)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_CODAPP_437699#164310)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_CODAPP_437699#164310)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NUMSAL_437700#164370)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_NUMSAL_437700#164370)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_CODPER_437701#164315)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_CODPER_437701#164315)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_CODRAD_437702#164319)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_CODRAD_437702#164319)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_CODPRO_437703#164317)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_CODPRO_437703#164317)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_M_AM_I_437704#164354)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_M_AM_I_437704#164354)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_AG_ON_437705#164306)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_AG_ON_437705#164306)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_DATEXA_437706#164327)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_DATEXA_437706#164327)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_HEUEXA_437707#164344)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_HEUEXA_437707#164344)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_HEUSAL_437708#164348)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_HEUSAL_437708#164348)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_HEUFIN_437709#164345)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_HEUFIN_437709#164345)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_DURTOT_437710#164334)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_DURTOT_437710#164334)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_DURAVA_437711#164332)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_DURAVA_437711#164332)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_DURPEN_437712#164333)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_DURPEN_437712#164333)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_DURAPR_437713#164331)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_DURAPR_437713#164331)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_DATARR_437714#164326)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_DATARR_437714#164326)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_HEUARR_437715#164342)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_HEUARR_437715#164342)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_HEUD_E_437716#164343)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_HEUD_E_437716#164343)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_HEUF_E_437717#164347)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_HEUF_E_437717#164347)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_CODSIT_437718#164320)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_CODSIT_437718#164320)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_DATMAJ_437719#164330)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_DATMAJ_437719#164330)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_CODUTI_437720#164321)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_CODUTI_437720#164321)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NUMSAT_437721#164371)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_NUMSAT_437721#164371)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_AFFECT_437722#164305)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_AFFECT_437722#164305)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_STU_ID_437723#164384)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_STU_ID_437723#164384)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_STA_PPS_437724#164383)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_STA_PPS_437724#164383)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_SOP_UID_437725#164381)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_SOP_UID_437725#164381)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NUMGRP_437726#164363)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_NUMGRP_437726#164363)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_CARRDV_437727#164309)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_CARRDV_437727#164309)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_SANSCR_437728#164379)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_SANSCR_437728#164379)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_CODATS_437729#164311)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_CODATS_437729#164311)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_STABCD_437730#164382)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_STABCD_437730#164382)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_TYPESCLQ_437731#164389)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_TYPESCLQ_437731#164389)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_TYPBCD_437732#164388)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_TYPBCD_437732#164388)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_CODPRX_437733#164318)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_CODPRX_437733#164318)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_FLPLAN_437734#164339)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_FLPLAN_437734#164339)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_AVAILABLE_437735#164308)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_AVAILABLE_437735#164308)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_AETITLE_437736#164304)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_AETITLE_437736#164304)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_SECONDAIRE_437737#164380)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_SECONDAIRE_437737#164380)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_MEDNUC_437738#164352)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_MEDNUC_437738#164352)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_FLTBDI_437739#164340)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_FLTBDI_437739#164340)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_CODFVU_437740#164313)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_CODFVU_437740#164313)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_DATFVU_437741#164329)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_DATFVU_437741#164329)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_HEUFVU_437742#164346)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_HEUFVU_437742#164346)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_SUSPENS_437743#164386)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_SUSPENS_437743#164386)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_ACADOS_437744#164300)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_ACADOS_437744#164300)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_ACAPUB_437745#164303)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_ACAPUB_437745#164303)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_ACAMED_437746#164302)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_ACAMED_437746#164302)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_ACALIB_437747#164301)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_ACALIB_437747#164301)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_LATER_437748#164350)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_LATER_437748#164350)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_POSITION_437749#164377)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_POSITION_437749#164377)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_INCIDENCE_437750#164349)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_INCIDENCE_437750#164349)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NUMPDT_437751#164366)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_NUMPDT_437751#164366)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NUMORD_437752#164365)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_NUMORD_437752#164365)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_TRSTAT_437753#164387)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_TRSTAT_437753#164387)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_ORGANE_437754#164375)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_ORGANE_437754#164375)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_HEUAPP_437755#164341)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_HEUAPP_437755#164341)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_ORIRDV_437756#164376)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_ORIRDV_437756#164376)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_CODVAC_437757#164323)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_CODVAC_437757#164323)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_CODVACA_437758#164322)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_CODVACA_437758#164322)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NUMXUS_437759#164374)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_NUMXUS_437759#164374)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NUMEXA_ORI_437760#164362)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_NUMEXA_ORI_437760#164362)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_EXACOT_437761#164336)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_EXACOT_437761#164336)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_FLNOCOT_437762#164338)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_FLNOCOT_437762#164338)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_ALARMES_437763#164307)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_ALARMES_437763#164307)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_MODAL_AET_437764#164353)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_MODAL_AET_437764#164353)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NUMPRORE_437765#164367)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_NUMPRORE_437765#164367)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_COMPRORE_437766#164325)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_COMPRORE_437766#164325)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NUMRVX_437767#164369)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_NUMRVX_437767#164369)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NOSEQ_437768#164358)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_NOSEQ_437768#164358)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_DATFIN_437769#164328)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_DATFIN_437769#164328)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NUMRESA_437770#164368)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_NUMRESA_437770#164368)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_FHIRID_437771#164337)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_FHIRID_437771#164337)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_REGANA_437772#164378)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_REGANA_437772#164378)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NB_SER_437773#164357)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_NB_SER_437773#164357)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NB_FIC_437774#164355)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_NB_FIC_437774#164355)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NB_IMG_KEY_437775#164356)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_NB_IMG_KEY_437775#164356)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_STU_ID_ORI_437776#164385)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_STU_ID_ORI_437776#164385)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_CODPER_PRORE_437777#164316)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_CODPER_PRORE_437777#164316)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NUMSEANCE_437778#164372)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_NUMSEANCE_437778#164372)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NUMORDSEANCE_437779#164364)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_NUMORDSEANCE_437779#164364)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NUMTRT_437780#164373)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_NUMTRT_437780#164373)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_COMMENT_437781#164324)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_COMMENT_437781#164324)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_CODLOINC_437782#164314)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_CODLOINC_437782#164314)), A63000893163) END)

(4) Project [codegen id : 1]
Output: []
Input [91]: [ET_ACADOS_437744#164300, ET_ACALIB_437747#164301, ET_ACAMED_437746#164302, ET_ACAPUB_437745#164303, ET_AETITLE_437736#164304, ET_AFFECT_437722#164305, ET_AG_ON_437705#164306, ET_ALARMES_437763#164307, ET_AVAILABLE_437735#164308, ET_CARRDV_437727#164309, ET_CODAPP_437699#164310, ET_CODATS_437729#164311, ET_CODEXA_437696#164312, ET_CODFVU_437740#164313, ET_CODLOINC_437782#164314, ET_CODPER_437701#164315, ET_CODPER_PRORE_437777#164316, ET_CODPRO_437703#164317, ET_CODPRX_437733#164318, ET_CODRAD_437702#164319, ET_CODSIT_437718#164320, ET_CODUTI_437720#164321, ET_CODVACA_437758#164322, ET_CODVAC_437757#164323, ET_COMMENT_437781#164324, ET_COMPRORE_437766#164325, ET_DATARR_437714#164326, ET_DATEXA_437706#164327, ET_DATFIN_437769#164328, ET_DATFVU_437741#164329, ET_DATMAJ_437719#164330, ET_DURAPR_437713#164331, ET_DURAVA_437711#164332, ET_DURPEN_437712#164333, ET_DURTOT_437710#164334, ET_EXAACC_437697#164335, ET_EXACOT_437761#164336, ET_FHIRID_437771#164337, ET_FLNOCOT_437762#164338, ET_FLPLAN_437734#164339, ET_FLTBDI_437739#164340, ET_HEUAPP_437755#164341, ET_HEUARR_437715#164342, ET_HEUD_E_437716#164343, ET_HEUEXA_437707#164344, ET_HEUFIN_437709#164345, ET_HEUFVU_437742#164346, ET_HEUF_E_437717#164347, ET_HEUSAL_437708#164348, ET_INCIDENCE_437750#164349, ET_LATER_437748#164350, ET_LIBEXA_437698#164351, ET_MEDNUC_437738#164352, ET_MODAL_AET_437764#164353, ET_M_AM_I_437704#164354, ET_NB_FIC_437774#164355, ET_NB_IMG_KEY_437775#164356, ET_NB_SER_437773#164357, ET_NOSEQ_437768#164358, ET_NUMDEM_437694#164359, ET_NUMDOS_437693#164360, ET_NUMEXA_437692#164361, ET_NUMEXA_ORI_437760#164362, ET_NUMGRP_437726#164363, ET_NUMORDSEANCE_437779#164364, ET_NUMORD_437752#164365, ET_NUMPDT_437751#164366, ET_NUMPRORE_437765#164367, ET_NUMRESA_437770#164368, ET_NUMRVX_437767#164369, ET_NUMSAL_437700#164370, ET_NUMSAT_437721#164371, ET_NUMSEANCE_437778#164372, ET_NUMTRT_437780#164373, ET_NUMXUS_437759#164374, ET_ORGANE_437754#164375, ET_ORIRDV_437756#164376, ET_POSITION_437749#164377, ET_REGANA_437772#164378, ET_SANSCR_437728#164379, ET_SECONDAIRE_437737#164380, ET_SOP_UID_437725#164381, ET_STABCD_437730#164382, ET_STA_PPS_437724#164383, ET_STU_ID_437723#164384, ET_STU_ID_ORI_437776#164385, ET_SUSPENS_437743#164386, ET_TRSTAT_437753#164387, ET_TYPBCD_437732#164388, ET_TYPESCLQ_437731#164389, ET_TYPEXA_437695#164390]

(5) HashAggregate [codegen id : 1]
Input: []
Keys: []
Functions [1]: [partial_count(1)]
Aggregate Attributes [1]: [count#165215L]
Results [1]: [count#165216L]

(6) Exchange
Input [1]: [count#165216L]
Arguments: SinglePartition, ENSURE_REQUIREMENTS, [plan_id=15485]

(7) ShuffleQueryStage
Output [1]: [count#165216L]
Arguments: 0

(8) HashAggregate [codegen id : 2]
Input [1]: [count#165216L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#165117L]
Results [1]: [count(1)#165117L AS COL_e0e7aa0c-8786-44ae-95fd-65b8d75da32e#165119L]

(9) Filter
Input [91]: [ET_ACADOS_437744#164300, ET_ACALIB_437747#164301, ET_ACAMED_437746#164302, ET_ACAPUB_437745#164303, ET_AETITLE_437736#164304, ET_AFFECT_437722#164305, ET_AG_ON_437705#164306, ET_ALARMES_437763#164307, ET_AVAILABLE_437735#164308, ET_CARRDV_437727#164309, ET_CODAPP_437699#164310, ET_CODATS_437729#164311, ET_CODEXA_437696#164312, ET_CODFVU_437740#164313, ET_CODLOINC_437782#164314, ET_CODPER_437701#164315, ET_CODPER_PRORE_437777#164316, ET_CODPRO_437703#164317, ET_CODPRX_437733#164318, ET_CODRAD_437702#164319, ET_CODSIT_437718#164320, ET_CODUTI_437720#164321, ET_CODVACA_437758#164322, ET_CODVAC_437757#164323, ET_COMMENT_437781#164324, ET_COMPRORE_437766#164325, ET_DATARR_437714#164326, ET_DATEXA_437706#164327, ET_DATFIN_437769#164328, ET_DATFVU_437741#164329, ET_DATMAJ_437719#164330, ET_DURAPR_437713#164331, ET_DURAVA_437711#164332, ET_DURPEN_437712#164333, ET_DURTOT_437710#164334, ET_EXAACC_437697#164335, ET_EXACOT_437761#164336, ET_FHIRID_437771#164337, ET_FLNOCOT_437762#164338, ET_FLPLAN_437734#164339, ET_FLTBDI_437739#164340, ET_HEUAPP_437755#164341, ET_HEUARR_437715#164342, ET_HEUD_E_437716#164343, ET_HEUEXA_437707#164344, ET_HEUFIN_437709#164345, ET_HEUFVU_437742#164346, ET_HEUF_E_437717#164347, ET_HEUSAL_437708#164348, ET_INCIDENCE_437750#164349, ET_LATER_437748#164350, ET_LIBEXA_437698#164351, ET_MEDNUC_437738#164352, ET_MODAL_AET_437764#164353, ET_M_AM_I_437704#164354, ET_NB_FIC_437774#164355, ET_NB_IMG_KEY_437775#164356, ET_NB_SER_437773#164357, ET_NOSEQ_437768#164358, ET_NUMDEM_437694#164359, ET_NUMDOS_437693#164360, ET_NUMEXA_437692#164361, ET_NUMEXA_ORI_437760#164362, ET_NUMGRP_437726#164363, ET_NUMORDSEANCE_437779#164364, ET_NUMORD_437752#164365, ET_NUMPDT_437751#164366, ET_NUMPRORE_437765#164367, ET_NUMRESA_437770#164368, ET_NUMRVX_437767#164369, ET_NUMSAL_437700#164370, ET_NUMSAT_437721#164371, ET_NUMSEANCE_437778#164372, ET_NUMTRT_437780#164373, ET_NUMXUS_437759#164374, ET_ORGANE_437754#164375, ET_ORIRDV_437756#164376, ET_POSITION_437749#164377, ET_REGANA_437772#164378, ET_SANSCR_437728#164379, ET_SECONDAIRE_437737#164380, ET_SOP_UID_437725#164381, ET_STABCD_437730#164382, ET_STA_PPS_437724#164383, ET_STU_ID_437723#164384, ET_STU_ID_ORI_437776#164385, ET_SUSPENS_437743#164386, ET_TRSTAT_437753#164387, ET_TYPBCD_437732#164388, ET_TYPESCLQ_437731#164389, ET_TYPEXA_437695#164390]
Condition : ((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NUMEXA_437692#164361)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_NUMEXA_437692#164361)), A63000893163) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NUMDOS_437693#164360)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_NUMDOS_437693#164360)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NUMDEM_437694#164359)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_NUMDEM_437694#164359)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_TYPEXA_437695#164390)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_TYPEXA_437695#164390)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_CODEXA_437696#164312)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_CODEXA_437696#164312)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_EXAACC_437697#164335)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_EXAACC_437697#164335)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_LIBEXA_437698#164351)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_LIBEXA_437698#164351)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_CODAPP_437699#164310)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_CODAPP_437699#164310)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NUMSAL_437700#164370)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_NUMSAL_437700#164370)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_CODPER_437701#164315)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_CODPER_437701#164315)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_CODRAD_437702#164319)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_CODRAD_437702#164319)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_CODPRO_437703#164317)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_CODPRO_437703#164317)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_M_AM_I_437704#164354)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_M_AM_I_437704#164354)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_AG_ON_437705#164306)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_AG_ON_437705#164306)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_DATEXA_437706#164327)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_DATEXA_437706#164327)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_HEUEXA_437707#164344)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_HEUEXA_437707#164344)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_HEUSAL_437708#164348)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_HEUSAL_437708#164348)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_HEUFIN_437709#164345)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_HEUFIN_437709#164345)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_DURTOT_437710#164334)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_DURTOT_437710#164334)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_DURAVA_437711#164332)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_DURAVA_437711#164332)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_DURPEN_437712#164333)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_DURPEN_437712#164333)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_DURAPR_437713#164331)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_DURAPR_437713#164331)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_DATARR_437714#164326)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_DATARR_437714#164326)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_HEUARR_437715#164342)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_HEUARR_437715#164342)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_HEUD_E_437716#164343)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_HEUD_E_437716#164343)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_HEUF_E_437717#164347)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_HEUF_E_437717#164347)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_CODSIT_437718#164320)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_CODSIT_437718#164320)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_DATMAJ_437719#164330)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_DATMAJ_437719#164330)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_CODUTI_437720#164321)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_CODUTI_437720#164321)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NUMSAT_437721#164371)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_NUMSAT_437721#164371)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_AFFECT_437722#164305)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_AFFECT_437722#164305)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_STU_ID_437723#164384)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_STU_ID_437723#164384)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_STA_PPS_437724#164383)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_STA_PPS_437724#164383)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_SOP_UID_437725#164381)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_SOP_UID_437725#164381)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NUMGRP_437726#164363)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_NUMGRP_437726#164363)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_CARRDV_437727#164309)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_CARRDV_437727#164309)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_SANSCR_437728#164379)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_SANSCR_437728#164379)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_CODATS_437729#164311)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_CODATS_437729#164311)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_STABCD_437730#164382)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_STABCD_437730#164382)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_TYPESCLQ_437731#164389)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_TYPESCLQ_437731#164389)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_TYPBCD_437732#164388)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_TYPBCD_437732#164388)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_CODPRX_437733#164318)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_CODPRX_437733#164318)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_FLPLAN_437734#164339)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_FLPLAN_437734#164339)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_AVAILABLE_437735#164308)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_AVAILABLE_437735#164308)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_AETITLE_437736#164304)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_AETITLE_437736#164304)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_SECONDAIRE_437737#164380)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_SECONDAIRE_437737#164380)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_MEDNUC_437738#164352)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_MEDNUC_437738#164352)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_FLTBDI_437739#164340)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_FLTBDI_437739#164340)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_CODFVU_437740#164313)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_CODFVU_437740#164313)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_DATFVU_437741#164329)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_DATFVU_437741#164329)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_HEUFVU_437742#164346)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_HEUFVU_437742#164346)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_SUSPENS_437743#164386)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_SUSPENS_437743#164386)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_ACADOS_437744#164300)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_ACADOS_437744#164300)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_ACAPUB_437745#164303)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_ACAPUB_437745#164303)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_ACAMED_437746#164302)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_ACAMED_437746#164302)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_ACALIB_437747#164301)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_ACALIB_437747#164301)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_LATER_437748#164350)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_LATER_437748#164350)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_POSITION_437749#164377)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_POSITION_437749#164377)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_INCIDENCE_437750#164349)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_INCIDENCE_437750#164349)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NUMPDT_437751#164366)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_NUMPDT_437751#164366)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NUMORD_437752#164365)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_NUMORD_437752#164365)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_TRSTAT_437753#164387)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_TRSTAT_437753#164387)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_ORGANE_437754#164375)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_ORGANE_437754#164375)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_HEUAPP_437755#164341)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_HEUAPP_437755#164341)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_ORIRDV_437756#164376)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_ORIRDV_437756#164376)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_CODVAC_437757#164323)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_CODVAC_437757#164323)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_CODVACA_437758#164322)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_CODVACA_437758#164322)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NUMXUS_437759#164374)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_NUMXUS_437759#164374)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NUMEXA_ORI_437760#164362)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_NUMEXA_ORI_437760#164362)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_EXACOT_437761#164336)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_EXACOT_437761#164336)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_FLNOCOT_437762#164338)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_FLNOCOT_437762#164338)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_ALARMES_437763#164307)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_ALARMES_437763#164307)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_MODAL_AET_437764#164353)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_MODAL_AET_437764#164353)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NUMPRORE_437765#164367)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_NUMPRORE_437765#164367)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_COMPRORE_437766#164325)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_COMPRORE_437766#164325)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NUMRVX_437767#164369)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_NUMRVX_437767#164369)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NOSEQ_437768#164358)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_NOSEQ_437768#164358)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_DATFIN_437769#164328)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_DATFIN_437769#164328)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NUMRESA_437770#164368)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_NUMRESA_437770#164368)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_FHIRID_437771#164337)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_FHIRID_437771#164337)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_REGANA_437772#164378)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_REGANA_437772#164378)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NB_SER_437773#164357)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_NB_SER_437773#164357)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NB_FIC_437774#164355)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_NB_FIC_437774#164355)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NB_IMG_KEY_437775#164356)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_NB_IMG_KEY_437775#164356)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_STU_ID_ORI_437776#164385)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_STU_ID_ORI_437776#164385)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_CODPER_PRORE_437777#164316)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_CODPER_PRORE_437777#164316)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NUMSEANCE_437778#164372)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_NUMSEANCE_437778#164372)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NUMORDSEANCE_437779#164364)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_NUMORDSEANCE_437779#164364)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NUMTRT_437780#164373)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_NUMTRT_437780#164373)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_COMMENT_437781#164324)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_COMMENT_437781#164324)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_CODLOINC_437782#164314)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ET_CODLOINC_437782#164314)), A63000893163) END)

(10) Project
Output: []
Input [91]: [ET_ACADOS_437744#164300, ET_ACALIB_437747#164301, ET_ACAMED_437746#164302, ET_ACAPUB_437745#164303, ET_AETITLE_437736#164304, ET_AFFECT_437722#164305, ET_AG_ON_437705#164306, ET_ALARMES_437763#164307, ET_AVAILABLE_437735#164308, ET_CARRDV_437727#164309, ET_CODAPP_437699#164310, ET_CODATS_437729#164311, ET_CODEXA_437696#164312, ET_CODFVU_437740#164313, ET_CODLOINC_437782#164314, ET_CODPER_437701#164315, ET_CODPER_PRORE_437777#164316, ET_CODPRO_437703#164317, ET_CODPRX_437733#164318, ET_CODRAD_437702#164319, ET_CODSIT_437718#164320, ET_CODUTI_437720#164321, ET_CODVACA_437758#164322, ET_CODVAC_437757#164323, ET_COMMENT_437781#164324, ET_COMPRORE_437766#164325, ET_DATARR_437714#164326, ET_DATEXA_437706#164327, ET_DATFIN_437769#164328, ET_DATFVU_437741#164329, ET_DATMAJ_437719#164330, ET_DURAPR_437713#164331, ET_DURAVA_437711#164332, ET_DURPEN_437712#164333, ET_DURTOT_437710#164334, ET_EXAACC_437697#164335, ET_EXACOT_437761#164336, ET_FHIRID_437771#164337, ET_FLNOCOT_437762#164338, ET_FLPLAN_437734#164339, ET_FLTBDI_437739#164340, ET_HEUAPP_437755#164341, ET_HEUARR_437715#164342, ET_HEUD_E_437716#164343, ET_HEUEXA_437707#164344, ET_HEUFIN_437709#164345, ET_HEUFVU_437742#164346, ET_HEUF_E_437717#164347, ET_HEUSAL_437708#164348, ET_INCIDENCE_437750#164349, ET_LATER_437748#164350, ET_LIBEXA_437698#164351, ET_MEDNUC_437738#164352, ET_MODAL_AET_437764#164353, ET_M_AM_I_437704#164354, ET_NB_FIC_437774#164355, ET_NB_IMG_KEY_437775#164356, ET_NB_SER_437773#164357, ET_NOSEQ_437768#164358, ET_NUMDEM_437694#164359, ET_NUMDOS_437693#164360, ET_NUMEXA_437692#164361, ET_NUMEXA_ORI_437760#164362, ET_NUMGRP_437726#164363, ET_NUMORDSEANCE_437779#164364, ET_NUMORD_437752#164365, ET_NUMPDT_437751#164366, ET_NUMPRORE_437765#164367, ET_NUMRESA_437770#164368, ET_NUMRVX_437767#164369, ET_NUMSAL_437700#164370, ET_NUMSAT_437721#164371, ET_NUMSEANCE_437778#164372, ET_NUMTRT_437780#164373, ET_NUMXUS_437759#164374, ET_ORGANE_437754#164375, ET_ORIRDV_437756#164376, ET_POSITION_437749#164377, ET_REGANA_437772#164378, ET_SANSCR_437728#164379, ET_SECONDAIRE_437737#164380, ET_SOP_UID_437725#164381, ET_STABCD_437730#164382, ET_STA_PPS_437724#164383, ET_STU_ID_437723#164384, ET_STU_ID_ORI_437776#164385, ET_SUSPENS_437743#164386, ET_TRSTAT_437753#164387, ET_TYPBCD_437732#164388, ET_TYPESCLQ_437731#164389, ET_TYPEXA_437695#164390]

(11) HashAggregate
Input: []
Keys: []
Functions [1]: [partial_count(1)]
Aggregate Attributes [1]: [count#165215L]
Results [1]: [count#165216L]

(12) Exchange
Input [1]: [count#165216L]
Arguments: SinglePartition, ENSURE_REQUIREMENTS, [plan_id=15465]

(13) HashAggregate
Input [1]: [count#165216L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#165117L]
Results [1]: [count(1)#165117L AS COL_e0e7aa0c-8786-44ae-95fd-65b8d75da32e#165119L]

(14) AdaptiveSparkPlan
Output [1]: [COL_e0e7aa0c-8786-44ae-95fd-65b8d75da32e#165119L]
Arguments: isFinalPlan=true

SQL / DataFrame Properties

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