hdh-spark-job - Details for Query 647

Submitted Time: 2026/10/21 21:34:16
Duration: 1.0 s
Succeeded Jobs: 605 608

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: 505 ms"; 5 [labelType="html" label="HashAggregate time in aggregation build: 504 ms number of output rows: 1"]; 6 [labelType="html" label=" Project "]; 7 [labelType="html" label="Filter number of output rows: 34,851"]; 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: 24 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=12960]

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

Project

Filter ((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NUMEXA_437692#134826)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_NUMEXA_437692#134826)), ) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NUMDOS_437693#134825)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_NUMDOS_437693#134825)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NUMDEM_437694#134824)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_NUMDEM_437694#134824)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_TYPEXA_437695#134855)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_TYPEXA_437695#134855)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_CODEXA_437696#134777)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_CODEXA_437696#134777)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_EXAACC_437697#134800)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_EXAACC_437697#134800)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_LIBEXA_437698#134816)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_LIBEXA_437698#134816)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_CODAPP_437699#134775)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_CODAPP_437699#134775)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NUMSAL_437700#134835)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_NUMSAL_437700#134835)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_CODPER_437701#134780)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_CODPER_437701#134780)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_CODRAD_437702#134784)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_CODRAD_437702#134784)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_CODPRO_437703#134782)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_CODPRO_437703#134782)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_M_AM_I_437704#134819)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_M_AM_I_437704#134819)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_AG_ON_437705#134771)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_AG_ON_437705#134771)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_DATEXA_437706#134792)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_DATEXA_437706#134792)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_HEUEXA_437707#134809)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_HEUEXA_437707#134809)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_HEUSAL_437708#134813)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_HEUSAL_437708#134813)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_HEUFIN_437709#134810)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_HEUFIN_437709#134810)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_DURTOT_437710#134799)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_DURTOT_437710#134799)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_DURAVA_437711#134797)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_DURAVA_437711#134797)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_DURPEN_437712#134798)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_DURPEN_437712#134798)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_DURAPR_437713#134796)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_DURAPR_437713#134796)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_DATARR_437714#134791)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_DATARR_437714#134791)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_HEUARR_437715#134807)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_HEUARR_437715#134807)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_HEUD_E_437716#134808)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_HEUD_E_437716#134808)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_HEUF_E_437717#134812)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_HEUF_E_437717#134812)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_CODSIT_437718#134785)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_CODSIT_437718#134785)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_DATMAJ_437719#134795)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_DATMAJ_437719#134795)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_CODUTI_437720#134786)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_CODUTI_437720#134786)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NUMSAT_437721#134836)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_NUMSAT_437721#134836)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_AFFECT_437722#134770)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_AFFECT_437722#134770)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_STU_ID_437723#134849)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_STU_ID_437723#134849)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_STA_PPS_437724#134848)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_STA_PPS_437724#134848)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_SOP_UID_437725#134846)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_SOP_UID_437725#134846)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NUMGRP_437726#134828)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_NUMGRP_437726#134828)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_CARRDV_437727#134774)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_CARRDV_437727#134774)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_SANSCR_437728#134844)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_SANSCR_437728#134844)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_CODATS_437729#134776)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_CODATS_437729#134776)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_STABCD_437730#134847)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_STABCD_437730#134847)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_TYPESCLQ_437731#134854)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_TYPESCLQ_437731#134854)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_TYPBCD_437732#134853)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_TYPBCD_437732#134853)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_CODPRX_437733#134783)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_CODPRX_437733#134783)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_FLPLAN_437734#134804)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_FLPLAN_437734#134804)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_AVAILABLE_437735#134773)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_AVAILABLE_437735#134773)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_AETITLE_437736#134769)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_AETITLE_437736#134769)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_SECONDAIRE_437737#134845)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_SECONDAIRE_437737#134845)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_MEDNUC_437738#134817)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_MEDNUC_437738#134817)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_FLTBDI_437739#134805)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_FLTBDI_437739#134805)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_CODFVU_437740#134778)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_CODFVU_437740#134778)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_DATFVU_437741#134794)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_DATFVU_437741#134794)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_HEUFVU_437742#134811)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_HEUFVU_437742#134811)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_SUSPENS_437743#134851)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_SUSPENS_437743#134851)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_ACADOS_437744#134765)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_ACADOS_437744#134765)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_ACAPUB_437745#134768)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_ACAPUB_437745#134768)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_ACAMED_437746#134767)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_ACAMED_437746#134767)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_ACALIB_437747#134766)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_ACALIB_437747#134766)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_LATER_437748#134815)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_LATER_437748#134815)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_POSITION_437749#134842)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_POSITION_437749#134842)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_INCIDENCE_437750#134814)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_INCIDENCE_437750#134814)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NUMPDT_437751#134831)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_NUMPDT_437751#134831)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NUMORD_437752#134830)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_NUMORD_437752#134830)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_TRSTAT_437753#134852)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_TRSTAT_437753#134852)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_ORGANE_437754#134840)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_ORGANE_437754#134840)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_HEUAPP_437755#134806)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_HEUAPP_437755#134806)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_ORIRDV_437756#134841)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_ORIRDV_437756#134841)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_CODVAC_437757#134788)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_CODVAC_437757#134788)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_CODVACA_437758#134787)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_CODVACA_437758#134787)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NUMXUS_437759#134839)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_NUMXUS_437759#134839)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NUMEXA_ORI_437760#134827)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_NUMEXA_ORI_437760#134827)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_EXACOT_437761#134801)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_EXACOT_437761#134801)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_FLNOCOT_437762#134803)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_FLNOCOT_437762#134803)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_ALARMES_437763#134772)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_ALARMES_437763#134772)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_MODAL_AET_437764#134818)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_MODAL_AET_437764#134818)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NUMPRORE_437765#134832)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_NUMPRORE_437765#134832)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_COMPRORE_437766#134790)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_COMPRORE_437766#134790)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NUMRVX_437767#134834)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_NUMRVX_437767#134834)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NOSEQ_437768#134823)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_NOSEQ_437768#134823)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_DATFIN_437769#134793)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_DATFIN_437769#134793)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NUMRESA_437770#134833)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_NUMRESA_437770#134833)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_FHIRID_437771#134802)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_FHIRID_437771#134802)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_REGANA_437772#134843)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_REGANA_437772#134843)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NB_SER_437773#134822)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_NB_SER_437773#134822)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NB_FIC_437774#134820)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_NB_FIC_437774#134820)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NB_IMG_KEY_437775#134821)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_NB_IMG_KEY_437775#134821)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_STU_ID_ORI_437776#134850)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_STU_ID_ORI_437776#134850)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_CODPER_PRORE_437777#134781)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_CODPER_PRORE_437777#134781)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NUMSEANCE_437778#134837)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_NUMSEANCE_437778#134837)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NUMORDSEANCE_437779#134829)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_NUMORDSEANCE_437779#134829)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NUMTRT_437780#134838)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_NUMTRT_437780#134838)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_COMMENT_437781#134789)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_COMMENT_437781#134789)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_CODLOINC_437782#134779)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_CODLOINC_437782#134779)), ) END)

ColumnarToRow

WholeStageCodegen (1)

FileScan parquet [ET_ACADOS_437744#134765,ET_ACALIB_437747#134766,ET_ACAMED_437746#134767,ET_ACAPUB_437745#134768,ET_AETITLE_437736#134769,ET_AFFECT_437722#134770,ET_AG_ON_437705#134771,ET_ALARMES_437763#134772,ET_AVAILABLE_437735#134773,ET_CARRDV_437727#134774,ET_CODAPP_437699#134775,ET_CODATS_437729#134776,ET_CODEXA_437696#134777,ET_CODFVU_437740#134778,ET_CODLOINC_437782#134779,ET_CODPER_437701#134780,ET_CODPER_PRORE_437777#134781,ET_CODPRO_437703#134782,ET_CODPRX_437733#134783,ET_CODRAD_437702#134784,ET_CODSIT_437718#134785,ET_CODUTI_437720#134786,ET_CODVACA_437758#134787,ET_CODVAC_437757#134788,... 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#134765, ET_ACALIB_437747#134766, ET_ACAMED_437746#134767, ET_ACAPUB_437745#134768, ET_AETITLE_437736#134769, ET_AFFECT_437722#134770, ET_AG_ON_437705#134771, ET_ALARMES_437763#134772, ET_AVAILABLE_437735#134773, ET_CARRDV_437727#134774, ET_CODAPP_437699#134775, ET_CODATS_437729#134776, ET_CODEXA_437696#134777, ET_CODFVU_437740#134778, ET_CODLOINC_437782#134779, ET_CODPER_437701#134780, ET_CODPER_PRORE_437777#134781, ET_CODPRO_437703#134782, ET_CODPRX_437733#134783, ET_CODRAD_437702#134784, ET_CODSIT_437718#134785, ET_CODUTI_437720#134786, ET_CODVACA_437758#134787, ET_CODVAC_437757#134788, ET_COMMENT_437781#134789, ET_COMPRORE_437766#134790, ET_DATARR_437714#134791, ET_DATEXA_437706#134792, ET_DATFIN_437769#134793, ET_DATFVU_437741#134794, ET_DATMAJ_437719#134795, ET_DURAPR_437713#134796, ET_DURAVA_437711#134797, ET_DURPEN_437712#134798, ET_DURTOT_437710#134799, ET_EXAACC_437697#134800, ET_EXACOT_437761#134801, ET_FHIRID_437771#134802, ET_FLNOCOT_437762#134803, ET_FLPLAN_437734#134804, ET_FLTBDI_437739#134805, ET_HEUAPP_437755#134806, ET_HEUARR_437715#134807, ET_HEUD_E_437716#134808, ET_HEUEXA_437707#134809, ET_HEUFIN_437709#134810, ET_HEUFVU_437742#134811, ET_HEUF_E_437717#134812, ET_HEUSAL_437708#134813, ET_INCIDENCE_437750#134814, ET_LATER_437748#134815, ET_LIBEXA_437698#134816, ET_MEDNUC_437738#134817, ET_MODAL_AET_437764#134818, ET_M_AM_I_437704#134819, ET_NB_FIC_437774#134820, ET_NB_IMG_KEY_437775#134821, ET_NB_SER_437773#134822, ET_NOSEQ_437768#134823, ET_NUMDEM_437694#134824, ET_NUMDOS_437693#134825, ET_NUMEXA_437692#134826, ET_NUMEXA_ORI_437760#134827, ET_NUMGRP_437726#134828, ET_NUMORDSEANCE_437779#134829, ET_NUMORD_437752#134830, ET_NUMPDT_437751#134831, ET_NUMPRORE_437765#134832, ET_NUMRESA_437770#134833, ET_NUMRVX_437767#134834, ET_NUMSAL_437700#134835, ET_NUMSAT_437721#134836, ET_NUMSEANCE_437778#134837, ET_NUMTRT_437780#134838, ET_NUMXUS_437759#134839, ET_ORGANE_437754#134840, ET_ORIRDV_437756#134841, ET_POSITION_437749#134842, ET_REGANA_437772#134843, ET_SANSCR_437728#134844, ET_SECONDAIRE_437737#134845, ET_SOP_UID_437725#134846, ET_STABCD_437730#134847, ET_STA_PPS_437724#134848, ET_STU_ID_437723#134849, ET_STU_ID_ORI_437776#134850, ET_SUSPENS_437743#134851, ET_TRSTAT_437753#134852, ET_TYPBCD_437732#134853, ET_TYPESCLQ_437731#134854, ET_TYPEXA_437695#134855]
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#134765, ET_ACALIB_437747#134766, ET_ACAMED_437746#134767, ET_ACAPUB_437745#134768, ET_AETITLE_437736#134769, ET_AFFECT_437722#134770, ET_AG_ON_437705#134771, ET_ALARMES_437763#134772, ET_AVAILABLE_437735#134773, ET_CARRDV_437727#134774, ET_CODAPP_437699#134775, ET_CODATS_437729#134776, ET_CODEXA_437696#134777, ET_CODFVU_437740#134778, ET_CODLOINC_437782#134779, ET_CODPER_437701#134780, ET_CODPER_PRORE_437777#134781, ET_CODPRO_437703#134782, ET_CODPRX_437733#134783, ET_CODRAD_437702#134784, ET_CODSIT_437718#134785, ET_CODUTI_437720#134786, ET_CODVACA_437758#134787, ET_CODVAC_437757#134788, ET_COMMENT_437781#134789, ET_COMPRORE_437766#134790, ET_DATARR_437714#134791, ET_DATEXA_437706#134792, ET_DATFIN_437769#134793, ET_DATFVU_437741#134794, ET_DATMAJ_437719#134795, ET_DURAPR_437713#134796, ET_DURAVA_437711#134797, ET_DURPEN_437712#134798, ET_DURTOT_437710#134799, ET_EXAACC_437697#134800, ET_EXACOT_437761#134801, ET_FHIRID_437771#134802, ET_FLNOCOT_437762#134803, ET_FLPLAN_437734#134804, ET_FLTBDI_437739#134805, ET_HEUAPP_437755#134806, ET_HEUARR_437715#134807, ET_HEUD_E_437716#134808, ET_HEUEXA_437707#134809, ET_HEUFIN_437709#134810, ET_HEUFVU_437742#134811, ET_HEUF_E_437717#134812, ET_HEUSAL_437708#134813, ET_INCIDENCE_437750#134814, ET_LATER_437748#134815, ET_LIBEXA_437698#134816, ET_MEDNUC_437738#134817, ET_MODAL_AET_437764#134818, ET_M_AM_I_437704#134819, ET_NB_FIC_437774#134820, ET_NB_IMG_KEY_437775#134821, ET_NB_SER_437773#134822, ET_NOSEQ_437768#134823, ET_NUMDEM_437694#134824, ET_NUMDOS_437693#134825, ET_NUMEXA_437692#134826, ET_NUMEXA_ORI_437760#134827, ET_NUMGRP_437726#134828, ET_NUMORDSEANCE_437779#134829, ET_NUMORD_437752#134830, ET_NUMPDT_437751#134831, ET_NUMPRORE_437765#134832, ET_NUMRESA_437770#134833, ET_NUMRVX_437767#134834, ET_NUMSAL_437700#134835, ET_NUMSAT_437721#134836, ET_NUMSEANCE_437778#134837, ET_NUMTRT_437780#134838, ET_NUMXUS_437759#134839, ET_ORGANE_437754#134840, ET_ORIRDV_437756#134841, ET_POSITION_437749#134842, ET_REGANA_437772#134843, ET_SANSCR_437728#134844, ET_SECONDAIRE_437737#134845, ET_SOP_UID_437725#134846, ET_STABCD_437730#134847, ET_STA_PPS_437724#134848, ET_STU_ID_437723#134849, ET_STU_ID_ORI_437776#134850, ET_SUSPENS_437743#134851, ET_TRSTAT_437753#134852, ET_TYPBCD_437732#134853, ET_TYPESCLQ_437731#134854, ET_TYPEXA_437695#134855]

(3) Filter [codegen id : 1]
Input [91]: [ET_ACADOS_437744#134765, ET_ACALIB_437747#134766, ET_ACAMED_437746#134767, ET_ACAPUB_437745#134768, ET_AETITLE_437736#134769, ET_AFFECT_437722#134770, ET_AG_ON_437705#134771, ET_ALARMES_437763#134772, ET_AVAILABLE_437735#134773, ET_CARRDV_437727#134774, ET_CODAPP_437699#134775, ET_CODATS_437729#134776, ET_CODEXA_437696#134777, ET_CODFVU_437740#134778, ET_CODLOINC_437782#134779, ET_CODPER_437701#134780, ET_CODPER_PRORE_437777#134781, ET_CODPRO_437703#134782, ET_CODPRX_437733#134783, ET_CODRAD_437702#134784, ET_CODSIT_437718#134785, ET_CODUTI_437720#134786, ET_CODVACA_437758#134787, ET_CODVAC_437757#134788, ET_COMMENT_437781#134789, ET_COMPRORE_437766#134790, ET_DATARR_437714#134791, ET_DATEXA_437706#134792, ET_DATFIN_437769#134793, ET_DATFVU_437741#134794, ET_DATMAJ_437719#134795, ET_DURAPR_437713#134796, ET_DURAVA_437711#134797, ET_DURPEN_437712#134798, ET_DURTOT_437710#134799, ET_EXAACC_437697#134800, ET_EXACOT_437761#134801, ET_FHIRID_437771#134802, ET_FLNOCOT_437762#134803, ET_FLPLAN_437734#134804, ET_FLTBDI_437739#134805, ET_HEUAPP_437755#134806, ET_HEUARR_437715#134807, ET_HEUD_E_437716#134808, ET_HEUEXA_437707#134809, ET_HEUFIN_437709#134810, ET_HEUFVU_437742#134811, ET_HEUF_E_437717#134812, ET_HEUSAL_437708#134813, ET_INCIDENCE_437750#134814, ET_LATER_437748#134815, ET_LIBEXA_437698#134816, ET_MEDNUC_437738#134817, ET_MODAL_AET_437764#134818, ET_M_AM_I_437704#134819, ET_NB_FIC_437774#134820, ET_NB_IMG_KEY_437775#134821, ET_NB_SER_437773#134822, ET_NOSEQ_437768#134823, ET_NUMDEM_437694#134824, ET_NUMDOS_437693#134825, ET_NUMEXA_437692#134826, ET_NUMEXA_ORI_437760#134827, ET_NUMGRP_437726#134828, ET_NUMORDSEANCE_437779#134829, ET_NUMORD_437752#134830, ET_NUMPDT_437751#134831, ET_NUMPRORE_437765#134832, ET_NUMRESA_437770#134833, ET_NUMRVX_437767#134834, ET_NUMSAL_437700#134835, ET_NUMSAT_437721#134836, ET_NUMSEANCE_437778#134837, ET_NUMTRT_437780#134838, ET_NUMXUS_437759#134839, ET_ORGANE_437754#134840, ET_ORIRDV_437756#134841, ET_POSITION_437749#134842, ET_REGANA_437772#134843, ET_SANSCR_437728#134844, ET_SECONDAIRE_437737#134845, ET_SOP_UID_437725#134846, ET_STABCD_437730#134847, ET_STA_PPS_437724#134848, ET_STU_ID_437723#134849, ET_STU_ID_ORI_437776#134850, ET_SUSPENS_437743#134851, ET_TRSTAT_437753#134852, ET_TYPBCD_437732#134853, ET_TYPESCLQ_437731#134854, ET_TYPEXA_437695#134855]
Condition : ((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NUMEXA_437692#134826)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_NUMEXA_437692#134826)), ) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NUMDOS_437693#134825)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_NUMDOS_437693#134825)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NUMDEM_437694#134824)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_NUMDEM_437694#134824)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_TYPEXA_437695#134855)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_TYPEXA_437695#134855)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_CODEXA_437696#134777)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_CODEXA_437696#134777)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_EXAACC_437697#134800)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_EXAACC_437697#134800)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_LIBEXA_437698#134816)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_LIBEXA_437698#134816)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_CODAPP_437699#134775)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_CODAPP_437699#134775)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NUMSAL_437700#134835)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_NUMSAL_437700#134835)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_CODPER_437701#134780)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_CODPER_437701#134780)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_CODRAD_437702#134784)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_CODRAD_437702#134784)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_CODPRO_437703#134782)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_CODPRO_437703#134782)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_M_AM_I_437704#134819)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_M_AM_I_437704#134819)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_AG_ON_437705#134771)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_AG_ON_437705#134771)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_DATEXA_437706#134792)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_DATEXA_437706#134792)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_HEUEXA_437707#134809)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_HEUEXA_437707#134809)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_HEUSAL_437708#134813)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_HEUSAL_437708#134813)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_HEUFIN_437709#134810)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_HEUFIN_437709#134810)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_DURTOT_437710#134799)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_DURTOT_437710#134799)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_DURAVA_437711#134797)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_DURAVA_437711#134797)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_DURPEN_437712#134798)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_DURPEN_437712#134798)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_DURAPR_437713#134796)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_DURAPR_437713#134796)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_DATARR_437714#134791)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_DATARR_437714#134791)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_HEUARR_437715#134807)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_HEUARR_437715#134807)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_HEUD_E_437716#134808)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_HEUD_E_437716#134808)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_HEUF_E_437717#134812)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_HEUF_E_437717#134812)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_CODSIT_437718#134785)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_CODSIT_437718#134785)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_DATMAJ_437719#134795)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_DATMAJ_437719#134795)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_CODUTI_437720#134786)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_CODUTI_437720#134786)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NUMSAT_437721#134836)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_NUMSAT_437721#134836)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_AFFECT_437722#134770)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_AFFECT_437722#134770)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_STU_ID_437723#134849)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_STU_ID_437723#134849)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_STA_PPS_437724#134848)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_STA_PPS_437724#134848)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_SOP_UID_437725#134846)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_SOP_UID_437725#134846)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NUMGRP_437726#134828)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_NUMGRP_437726#134828)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_CARRDV_437727#134774)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_CARRDV_437727#134774)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_SANSCR_437728#134844)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_SANSCR_437728#134844)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_CODATS_437729#134776)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_CODATS_437729#134776)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_STABCD_437730#134847)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_STABCD_437730#134847)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_TYPESCLQ_437731#134854)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_TYPESCLQ_437731#134854)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_TYPBCD_437732#134853)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_TYPBCD_437732#134853)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_CODPRX_437733#134783)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_CODPRX_437733#134783)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_FLPLAN_437734#134804)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_FLPLAN_437734#134804)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_AVAILABLE_437735#134773)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_AVAILABLE_437735#134773)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_AETITLE_437736#134769)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_AETITLE_437736#134769)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_SECONDAIRE_437737#134845)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_SECONDAIRE_437737#134845)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_MEDNUC_437738#134817)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_MEDNUC_437738#134817)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_FLTBDI_437739#134805)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_FLTBDI_437739#134805)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_CODFVU_437740#134778)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_CODFVU_437740#134778)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_DATFVU_437741#134794)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_DATFVU_437741#134794)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_HEUFVU_437742#134811)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_HEUFVU_437742#134811)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_SUSPENS_437743#134851)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_SUSPENS_437743#134851)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_ACADOS_437744#134765)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_ACADOS_437744#134765)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_ACAPUB_437745#134768)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_ACAPUB_437745#134768)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_ACAMED_437746#134767)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_ACAMED_437746#134767)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_ACALIB_437747#134766)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_ACALIB_437747#134766)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_LATER_437748#134815)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_LATER_437748#134815)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_POSITION_437749#134842)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_POSITION_437749#134842)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_INCIDENCE_437750#134814)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_INCIDENCE_437750#134814)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NUMPDT_437751#134831)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_NUMPDT_437751#134831)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NUMORD_437752#134830)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_NUMORD_437752#134830)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_TRSTAT_437753#134852)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_TRSTAT_437753#134852)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_ORGANE_437754#134840)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_ORGANE_437754#134840)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_HEUAPP_437755#134806)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_HEUAPP_437755#134806)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_ORIRDV_437756#134841)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_ORIRDV_437756#134841)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_CODVAC_437757#134788)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_CODVAC_437757#134788)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_CODVACA_437758#134787)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_CODVACA_437758#134787)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NUMXUS_437759#134839)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_NUMXUS_437759#134839)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NUMEXA_ORI_437760#134827)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_NUMEXA_ORI_437760#134827)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_EXACOT_437761#134801)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_EXACOT_437761#134801)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_FLNOCOT_437762#134803)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_FLNOCOT_437762#134803)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_ALARMES_437763#134772)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_ALARMES_437763#134772)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_MODAL_AET_437764#134818)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_MODAL_AET_437764#134818)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NUMPRORE_437765#134832)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_NUMPRORE_437765#134832)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_COMPRORE_437766#134790)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_COMPRORE_437766#134790)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NUMRVX_437767#134834)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_NUMRVX_437767#134834)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NOSEQ_437768#134823)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_NOSEQ_437768#134823)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_DATFIN_437769#134793)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_DATFIN_437769#134793)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NUMRESA_437770#134833)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_NUMRESA_437770#134833)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_FHIRID_437771#134802)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_FHIRID_437771#134802)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_REGANA_437772#134843)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_REGANA_437772#134843)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NB_SER_437773#134822)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_NB_SER_437773#134822)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NB_FIC_437774#134820)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_NB_FIC_437774#134820)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NB_IMG_KEY_437775#134821)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_NB_IMG_KEY_437775#134821)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_STU_ID_ORI_437776#134850)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_STU_ID_ORI_437776#134850)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_CODPER_PRORE_437777#134781)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_CODPER_PRORE_437777#134781)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NUMSEANCE_437778#134837)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_NUMSEANCE_437778#134837)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NUMORDSEANCE_437779#134829)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_NUMORDSEANCE_437779#134829)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NUMTRT_437780#134838)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_NUMTRT_437780#134838)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_COMMENT_437781#134789)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_COMMENT_437781#134789)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_CODLOINC_437782#134779)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_CODLOINC_437782#134779)), ) END)

(4) Project [codegen id : 1]
Output: []
Input [91]: [ET_ACADOS_437744#134765, ET_ACALIB_437747#134766, ET_ACAMED_437746#134767, ET_ACAPUB_437745#134768, ET_AETITLE_437736#134769, ET_AFFECT_437722#134770, ET_AG_ON_437705#134771, ET_ALARMES_437763#134772, ET_AVAILABLE_437735#134773, ET_CARRDV_437727#134774, ET_CODAPP_437699#134775, ET_CODATS_437729#134776, ET_CODEXA_437696#134777, ET_CODFVU_437740#134778, ET_CODLOINC_437782#134779, ET_CODPER_437701#134780, ET_CODPER_PRORE_437777#134781, ET_CODPRO_437703#134782, ET_CODPRX_437733#134783, ET_CODRAD_437702#134784, ET_CODSIT_437718#134785, ET_CODUTI_437720#134786, ET_CODVACA_437758#134787, ET_CODVAC_437757#134788, ET_COMMENT_437781#134789, ET_COMPRORE_437766#134790, ET_DATARR_437714#134791, ET_DATEXA_437706#134792, ET_DATFIN_437769#134793, ET_DATFVU_437741#134794, ET_DATMAJ_437719#134795, ET_DURAPR_437713#134796, ET_DURAVA_437711#134797, ET_DURPEN_437712#134798, ET_DURTOT_437710#134799, ET_EXAACC_437697#134800, ET_EXACOT_437761#134801, ET_FHIRID_437771#134802, ET_FLNOCOT_437762#134803, ET_FLPLAN_437734#134804, ET_FLTBDI_437739#134805, ET_HEUAPP_437755#134806, ET_HEUARR_437715#134807, ET_HEUD_E_437716#134808, ET_HEUEXA_437707#134809, ET_HEUFIN_437709#134810, ET_HEUFVU_437742#134811, ET_HEUF_E_437717#134812, ET_HEUSAL_437708#134813, ET_INCIDENCE_437750#134814, ET_LATER_437748#134815, ET_LIBEXA_437698#134816, ET_MEDNUC_437738#134817, ET_MODAL_AET_437764#134818, ET_M_AM_I_437704#134819, ET_NB_FIC_437774#134820, ET_NB_IMG_KEY_437775#134821, ET_NB_SER_437773#134822, ET_NOSEQ_437768#134823, ET_NUMDEM_437694#134824, ET_NUMDOS_437693#134825, ET_NUMEXA_437692#134826, ET_NUMEXA_ORI_437760#134827, ET_NUMGRP_437726#134828, ET_NUMORDSEANCE_437779#134829, ET_NUMORD_437752#134830, ET_NUMPDT_437751#134831, ET_NUMPRORE_437765#134832, ET_NUMRESA_437770#134833, ET_NUMRVX_437767#134834, ET_NUMSAL_437700#134835, ET_NUMSAT_437721#134836, ET_NUMSEANCE_437778#134837, ET_NUMTRT_437780#134838, ET_NUMXUS_437759#134839, ET_ORGANE_437754#134840, ET_ORIRDV_437756#134841, ET_POSITION_437749#134842, ET_REGANA_437772#134843, ET_SANSCR_437728#134844, ET_SECONDAIRE_437737#134845, ET_SOP_UID_437725#134846, ET_STABCD_437730#134847, ET_STA_PPS_437724#134848, ET_STU_ID_437723#134849, ET_STU_ID_ORI_437776#134850, ET_SUSPENS_437743#134851, ET_TRSTAT_437753#134852, ET_TYPBCD_437732#134853, ET_TYPESCLQ_437731#134854, ET_TYPEXA_437695#134855]

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

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

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

(8) HashAggregate [codegen id : 2]
Input [1]: [count#136057L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#135950L]
Results [1]: [count(1)#135950L AS COL_cd48698a-b33e-4aa8-9b02-f1740ecc71d6#135952L]

(9) Filter
Input [91]: [ET_ACADOS_437744#134765, ET_ACALIB_437747#134766, ET_ACAMED_437746#134767, ET_ACAPUB_437745#134768, ET_AETITLE_437736#134769, ET_AFFECT_437722#134770, ET_AG_ON_437705#134771, ET_ALARMES_437763#134772, ET_AVAILABLE_437735#134773, ET_CARRDV_437727#134774, ET_CODAPP_437699#134775, ET_CODATS_437729#134776, ET_CODEXA_437696#134777, ET_CODFVU_437740#134778, ET_CODLOINC_437782#134779, ET_CODPER_437701#134780, ET_CODPER_PRORE_437777#134781, ET_CODPRO_437703#134782, ET_CODPRX_437733#134783, ET_CODRAD_437702#134784, ET_CODSIT_437718#134785, ET_CODUTI_437720#134786, ET_CODVACA_437758#134787, ET_CODVAC_437757#134788, ET_COMMENT_437781#134789, ET_COMPRORE_437766#134790, ET_DATARR_437714#134791, ET_DATEXA_437706#134792, ET_DATFIN_437769#134793, ET_DATFVU_437741#134794, ET_DATMAJ_437719#134795, ET_DURAPR_437713#134796, ET_DURAVA_437711#134797, ET_DURPEN_437712#134798, ET_DURTOT_437710#134799, ET_EXAACC_437697#134800, ET_EXACOT_437761#134801, ET_FHIRID_437771#134802, ET_FLNOCOT_437762#134803, ET_FLPLAN_437734#134804, ET_FLTBDI_437739#134805, ET_HEUAPP_437755#134806, ET_HEUARR_437715#134807, ET_HEUD_E_437716#134808, ET_HEUEXA_437707#134809, ET_HEUFIN_437709#134810, ET_HEUFVU_437742#134811, ET_HEUF_E_437717#134812, ET_HEUSAL_437708#134813, ET_INCIDENCE_437750#134814, ET_LATER_437748#134815, ET_LIBEXA_437698#134816, ET_MEDNUC_437738#134817, ET_MODAL_AET_437764#134818, ET_M_AM_I_437704#134819, ET_NB_FIC_437774#134820, ET_NB_IMG_KEY_437775#134821, ET_NB_SER_437773#134822, ET_NOSEQ_437768#134823, ET_NUMDEM_437694#134824, ET_NUMDOS_437693#134825, ET_NUMEXA_437692#134826, ET_NUMEXA_ORI_437760#134827, ET_NUMGRP_437726#134828, ET_NUMORDSEANCE_437779#134829, ET_NUMORD_437752#134830, ET_NUMPDT_437751#134831, ET_NUMPRORE_437765#134832, ET_NUMRESA_437770#134833, ET_NUMRVX_437767#134834, ET_NUMSAL_437700#134835, ET_NUMSAT_437721#134836, ET_NUMSEANCE_437778#134837, ET_NUMTRT_437780#134838, ET_NUMXUS_437759#134839, ET_ORGANE_437754#134840, ET_ORIRDV_437756#134841, ET_POSITION_437749#134842, ET_REGANA_437772#134843, ET_SANSCR_437728#134844, ET_SECONDAIRE_437737#134845, ET_SOP_UID_437725#134846, ET_STABCD_437730#134847, ET_STA_PPS_437724#134848, ET_STU_ID_437723#134849, ET_STU_ID_ORI_437776#134850, ET_SUSPENS_437743#134851, ET_TRSTAT_437753#134852, ET_TYPBCD_437732#134853, ET_TYPESCLQ_437731#134854, ET_TYPEXA_437695#134855]
Condition : ((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NUMEXA_437692#134826)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_NUMEXA_437692#134826)), ) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NUMDOS_437693#134825)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_NUMDOS_437693#134825)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NUMDEM_437694#134824)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_NUMDEM_437694#134824)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_TYPEXA_437695#134855)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_TYPEXA_437695#134855)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_CODEXA_437696#134777)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_CODEXA_437696#134777)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_EXAACC_437697#134800)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_EXAACC_437697#134800)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_LIBEXA_437698#134816)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_LIBEXA_437698#134816)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_CODAPP_437699#134775)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_CODAPP_437699#134775)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NUMSAL_437700#134835)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_NUMSAL_437700#134835)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_CODPER_437701#134780)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_CODPER_437701#134780)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_CODRAD_437702#134784)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_CODRAD_437702#134784)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_CODPRO_437703#134782)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_CODPRO_437703#134782)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_M_AM_I_437704#134819)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_M_AM_I_437704#134819)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_AG_ON_437705#134771)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_AG_ON_437705#134771)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_DATEXA_437706#134792)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_DATEXA_437706#134792)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_HEUEXA_437707#134809)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_HEUEXA_437707#134809)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_HEUSAL_437708#134813)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_HEUSAL_437708#134813)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_HEUFIN_437709#134810)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_HEUFIN_437709#134810)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_DURTOT_437710#134799)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_DURTOT_437710#134799)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_DURAVA_437711#134797)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_DURAVA_437711#134797)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_DURPEN_437712#134798)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_DURPEN_437712#134798)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_DURAPR_437713#134796)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_DURAPR_437713#134796)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_DATARR_437714#134791)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_DATARR_437714#134791)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_HEUARR_437715#134807)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_HEUARR_437715#134807)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_HEUD_E_437716#134808)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_HEUD_E_437716#134808)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_HEUF_E_437717#134812)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_HEUF_E_437717#134812)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_CODSIT_437718#134785)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_CODSIT_437718#134785)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_DATMAJ_437719#134795)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_DATMAJ_437719#134795)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_CODUTI_437720#134786)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_CODUTI_437720#134786)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NUMSAT_437721#134836)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_NUMSAT_437721#134836)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_AFFECT_437722#134770)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_AFFECT_437722#134770)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_STU_ID_437723#134849)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_STU_ID_437723#134849)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_STA_PPS_437724#134848)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_STA_PPS_437724#134848)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_SOP_UID_437725#134846)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_SOP_UID_437725#134846)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NUMGRP_437726#134828)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_NUMGRP_437726#134828)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_CARRDV_437727#134774)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_CARRDV_437727#134774)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_SANSCR_437728#134844)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_SANSCR_437728#134844)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_CODATS_437729#134776)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_CODATS_437729#134776)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_STABCD_437730#134847)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_STABCD_437730#134847)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_TYPESCLQ_437731#134854)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_TYPESCLQ_437731#134854)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_TYPBCD_437732#134853)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_TYPBCD_437732#134853)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_CODPRX_437733#134783)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_CODPRX_437733#134783)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_FLPLAN_437734#134804)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_FLPLAN_437734#134804)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_AVAILABLE_437735#134773)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_AVAILABLE_437735#134773)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_AETITLE_437736#134769)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_AETITLE_437736#134769)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_SECONDAIRE_437737#134845)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_SECONDAIRE_437737#134845)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_MEDNUC_437738#134817)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_MEDNUC_437738#134817)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_FLTBDI_437739#134805)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_FLTBDI_437739#134805)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_CODFVU_437740#134778)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_CODFVU_437740#134778)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_DATFVU_437741#134794)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_DATFVU_437741#134794)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_HEUFVU_437742#134811)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_HEUFVU_437742#134811)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_SUSPENS_437743#134851)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_SUSPENS_437743#134851)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_ACADOS_437744#134765)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_ACADOS_437744#134765)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_ACAPUB_437745#134768)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_ACAPUB_437745#134768)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_ACAMED_437746#134767)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_ACAMED_437746#134767)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_ACALIB_437747#134766)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_ACALIB_437747#134766)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_LATER_437748#134815)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_LATER_437748#134815)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_POSITION_437749#134842)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_POSITION_437749#134842)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_INCIDENCE_437750#134814)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_INCIDENCE_437750#134814)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NUMPDT_437751#134831)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_NUMPDT_437751#134831)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NUMORD_437752#134830)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_NUMORD_437752#134830)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_TRSTAT_437753#134852)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_TRSTAT_437753#134852)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_ORGANE_437754#134840)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_ORGANE_437754#134840)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_HEUAPP_437755#134806)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_HEUAPP_437755#134806)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_ORIRDV_437756#134841)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_ORIRDV_437756#134841)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_CODVAC_437757#134788)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_CODVAC_437757#134788)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_CODVACA_437758#134787)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_CODVACA_437758#134787)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NUMXUS_437759#134839)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_NUMXUS_437759#134839)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NUMEXA_ORI_437760#134827)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_NUMEXA_ORI_437760#134827)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_EXACOT_437761#134801)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_EXACOT_437761#134801)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_FLNOCOT_437762#134803)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_FLNOCOT_437762#134803)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_ALARMES_437763#134772)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_ALARMES_437763#134772)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_MODAL_AET_437764#134818)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_MODAL_AET_437764#134818)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NUMPRORE_437765#134832)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_NUMPRORE_437765#134832)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_COMPRORE_437766#134790)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_COMPRORE_437766#134790)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NUMRVX_437767#134834)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_NUMRVX_437767#134834)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NOSEQ_437768#134823)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_NOSEQ_437768#134823)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_DATFIN_437769#134793)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_DATFIN_437769#134793)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NUMRESA_437770#134833)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_NUMRESA_437770#134833)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_FHIRID_437771#134802)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_FHIRID_437771#134802)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_REGANA_437772#134843)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_REGANA_437772#134843)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NB_SER_437773#134822)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_NB_SER_437773#134822)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NB_FIC_437774#134820)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_NB_FIC_437774#134820)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NB_IMG_KEY_437775#134821)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_NB_IMG_KEY_437775#134821)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_STU_ID_ORI_437776#134850)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_STU_ID_ORI_437776#134850)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_CODPER_PRORE_437777#134781)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_CODPER_PRORE_437777#134781)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NUMSEANCE_437778#134837)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_NUMSEANCE_437778#134837)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NUMORDSEANCE_437779#134829)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_NUMORDSEANCE_437779#134829)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NUMTRT_437780#134838)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_NUMTRT_437780#134838)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_COMMENT_437781#134789)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_COMMENT_437781#134789)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_CODLOINC_437782#134779)), )) THEN false ELSE Contains(str_remove_accent(upper(ET_CODLOINC_437782#134779)), ) END)

(10) Project
Output: []
Input [91]: [ET_ACADOS_437744#134765, ET_ACALIB_437747#134766, ET_ACAMED_437746#134767, ET_ACAPUB_437745#134768, ET_AETITLE_437736#134769, ET_AFFECT_437722#134770, ET_AG_ON_437705#134771, ET_ALARMES_437763#134772, ET_AVAILABLE_437735#134773, ET_CARRDV_437727#134774, ET_CODAPP_437699#134775, ET_CODATS_437729#134776, ET_CODEXA_437696#134777, ET_CODFVU_437740#134778, ET_CODLOINC_437782#134779, ET_CODPER_437701#134780, ET_CODPER_PRORE_437777#134781, ET_CODPRO_437703#134782, ET_CODPRX_437733#134783, ET_CODRAD_437702#134784, ET_CODSIT_437718#134785, ET_CODUTI_437720#134786, ET_CODVACA_437758#134787, ET_CODVAC_437757#134788, ET_COMMENT_437781#134789, ET_COMPRORE_437766#134790, ET_DATARR_437714#134791, ET_DATEXA_437706#134792, ET_DATFIN_437769#134793, ET_DATFVU_437741#134794, ET_DATMAJ_437719#134795, ET_DURAPR_437713#134796, ET_DURAVA_437711#134797, ET_DURPEN_437712#134798, ET_DURTOT_437710#134799, ET_EXAACC_437697#134800, ET_EXACOT_437761#134801, ET_FHIRID_437771#134802, ET_FLNOCOT_437762#134803, ET_FLPLAN_437734#134804, ET_FLTBDI_437739#134805, ET_HEUAPP_437755#134806, ET_HEUARR_437715#134807, ET_HEUD_E_437716#134808, ET_HEUEXA_437707#134809, ET_HEUFIN_437709#134810, ET_HEUFVU_437742#134811, ET_HEUF_E_437717#134812, ET_HEUSAL_437708#134813, ET_INCIDENCE_437750#134814, ET_LATER_437748#134815, ET_LIBEXA_437698#134816, ET_MEDNUC_437738#134817, ET_MODAL_AET_437764#134818, ET_M_AM_I_437704#134819, ET_NB_FIC_437774#134820, ET_NB_IMG_KEY_437775#134821, ET_NB_SER_437773#134822, ET_NOSEQ_437768#134823, ET_NUMDEM_437694#134824, ET_NUMDOS_437693#134825, ET_NUMEXA_437692#134826, ET_NUMEXA_ORI_437760#134827, ET_NUMGRP_437726#134828, ET_NUMORDSEANCE_437779#134829, ET_NUMORD_437752#134830, ET_NUMPDT_437751#134831, ET_NUMPRORE_437765#134832, ET_NUMRESA_437770#134833, ET_NUMRVX_437767#134834, ET_NUMSAL_437700#134835, ET_NUMSAT_437721#134836, ET_NUMSEANCE_437778#134837, ET_NUMTRT_437780#134838, ET_NUMXUS_437759#134839, ET_ORGANE_437754#134840, ET_ORIRDV_437756#134841, ET_POSITION_437749#134842, ET_REGANA_437772#134843, ET_SANSCR_437728#134844, ET_SECONDAIRE_437737#134845, ET_SOP_UID_437725#134846, ET_STABCD_437730#134847, ET_STA_PPS_437724#134848, ET_STU_ID_437723#134849, ET_STU_ID_ORI_437776#134850, ET_SUSPENS_437743#134851, ET_TRSTAT_437753#134852, ET_TYPBCD_437732#134853, ET_TYPESCLQ_437731#134854, ET_TYPEXA_437695#134855]

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

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

(13) HashAggregate
Input [1]: [count#136057L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#135950L]
Results [1]: [count(1)#135950L AS COL_cd48698a-b33e-4aa8-9b02-f1740ecc71d6#135952L]

(14) AdaptiveSparkPlan
Output [1]: [COL_cd48698a-b33e-4aa8-9b02-f1740ecc71d6#135952L]
Arguments: isFinalPlan=true

SQL / DataFrame Properties

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