hdh-spark-job - Details for Query 675

Submitted Time: 2026/10/21 21:34:28
Duration: 3 s
Succeeded Jobs: 640 658

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: 56.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: 56.0 B"]; subgraph cluster4 { isCluster="true"; label="WholeStageCodegen (1)\n \nduration: 1.9 s"; 5 [labelType="html" label="HashAggregate time in aggregation build: 1.9 s number of output rows: 1"]; 6 [labelType="html" label=" Project "]; 7 [labelType="html" label="Filter number of output rows: 0"]; 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=13694]

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

Project

Filter ((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NUMEXA_437692#144191)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_NUMEXA_437692#144191)), MARX) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NUMDOS_437693#144190)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_NUMDOS_437693#144190)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NUMDEM_437694#144189)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_NUMDEM_437694#144189)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_TYPEXA_437695#144220)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_TYPEXA_437695#144220)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_CODEXA_437696#144142)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_CODEXA_437696#144142)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_EXAACC_437697#144165)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_EXAACC_437697#144165)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_LIBEXA_437698#144181)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_LIBEXA_437698#144181)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_CODAPP_437699#144140)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_CODAPP_437699#144140)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NUMSAL_437700#144200)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_NUMSAL_437700#144200)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_CODPER_437701#144145)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_CODPER_437701#144145)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_CODRAD_437702#144149)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_CODRAD_437702#144149)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_CODPRO_437703#144147)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_CODPRO_437703#144147)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_M_AM_I_437704#144184)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_M_AM_I_437704#144184)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_AG_ON_437705#144136)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_AG_ON_437705#144136)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_DATEXA_437706#144157)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_DATEXA_437706#144157)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_HEUEXA_437707#144174)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_HEUEXA_437707#144174)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_HEUSAL_437708#144178)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_HEUSAL_437708#144178)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_HEUFIN_437709#144175)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_HEUFIN_437709#144175)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_DURTOT_437710#144164)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_DURTOT_437710#144164)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_DURAVA_437711#144162)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_DURAVA_437711#144162)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_DURPEN_437712#144163)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_DURPEN_437712#144163)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_DURAPR_437713#144161)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_DURAPR_437713#144161)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_DATARR_437714#144156)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_DATARR_437714#144156)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_HEUARR_437715#144172)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_HEUARR_437715#144172)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_HEUD_E_437716#144173)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_HEUD_E_437716#144173)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_HEUF_E_437717#144177)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_HEUF_E_437717#144177)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_CODSIT_437718#144150)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_CODSIT_437718#144150)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_DATMAJ_437719#144160)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_DATMAJ_437719#144160)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_CODUTI_437720#144151)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_CODUTI_437720#144151)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NUMSAT_437721#144201)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_NUMSAT_437721#144201)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_AFFECT_437722#144135)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_AFFECT_437722#144135)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_STU_ID_437723#144214)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_STU_ID_437723#144214)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_STA_PPS_437724#144213)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_STA_PPS_437724#144213)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_SOP_UID_437725#144211)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_SOP_UID_437725#144211)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NUMGRP_437726#144193)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_NUMGRP_437726#144193)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_CARRDV_437727#144139)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_CARRDV_437727#144139)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_SANSCR_437728#144209)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_SANSCR_437728#144209)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_CODATS_437729#144141)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_CODATS_437729#144141)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_STABCD_437730#144212)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_STABCD_437730#144212)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_TYPESCLQ_437731#144219)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_TYPESCLQ_437731#144219)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_TYPBCD_437732#144218)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_TYPBCD_437732#144218)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_CODPRX_437733#144148)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_CODPRX_437733#144148)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_FLPLAN_437734#144169)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_FLPLAN_437734#144169)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_AVAILABLE_437735#144138)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_AVAILABLE_437735#144138)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_AETITLE_437736#144134)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_AETITLE_437736#144134)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_SECONDAIRE_437737#144210)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_SECONDAIRE_437737#144210)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_MEDNUC_437738#144182)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_MEDNUC_437738#144182)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_FLTBDI_437739#144170)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_FLTBDI_437739#144170)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_CODFVU_437740#144143)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_CODFVU_437740#144143)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_DATFVU_437741#144159)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_DATFVU_437741#144159)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_HEUFVU_437742#144176)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_HEUFVU_437742#144176)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_SUSPENS_437743#144216)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_SUSPENS_437743#144216)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_ACADOS_437744#144130)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_ACADOS_437744#144130)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_ACAPUB_437745#144133)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_ACAPUB_437745#144133)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_ACAMED_437746#144132)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_ACAMED_437746#144132)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_ACALIB_437747#144131)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_ACALIB_437747#144131)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_LATER_437748#144180)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_LATER_437748#144180)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_POSITION_437749#144207)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_POSITION_437749#144207)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_INCIDENCE_437750#144179)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_INCIDENCE_437750#144179)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NUMPDT_437751#144196)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_NUMPDT_437751#144196)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NUMORD_437752#144195)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_NUMORD_437752#144195)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_TRSTAT_437753#144217)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_TRSTAT_437753#144217)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_ORGANE_437754#144205)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_ORGANE_437754#144205)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_HEUAPP_437755#144171)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_HEUAPP_437755#144171)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_ORIRDV_437756#144206)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_ORIRDV_437756#144206)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_CODVAC_437757#144153)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_CODVAC_437757#144153)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_CODVACA_437758#144152)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_CODVACA_437758#144152)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NUMXUS_437759#144204)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_NUMXUS_437759#144204)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NUMEXA_ORI_437760#144192)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_NUMEXA_ORI_437760#144192)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_EXACOT_437761#144166)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_EXACOT_437761#144166)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_FLNOCOT_437762#144168)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_FLNOCOT_437762#144168)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_ALARMES_437763#144137)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_ALARMES_437763#144137)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_MODAL_AET_437764#144183)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_MODAL_AET_437764#144183)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NUMPRORE_437765#144197)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_NUMPRORE_437765#144197)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_COMPRORE_437766#144155)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_COMPRORE_437766#144155)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NUMRVX_437767#144199)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_NUMRVX_437767#144199)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NOSEQ_437768#144188)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_NOSEQ_437768#144188)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_DATFIN_437769#144158)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_DATFIN_437769#144158)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NUMRESA_437770#144198)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_NUMRESA_437770#144198)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_FHIRID_437771#144167)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_FHIRID_437771#144167)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_REGANA_437772#144208)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_REGANA_437772#144208)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NB_SER_437773#144187)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_NB_SER_437773#144187)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NB_FIC_437774#144185)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_NB_FIC_437774#144185)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NB_IMG_KEY_437775#144186)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_NB_IMG_KEY_437775#144186)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_STU_ID_ORI_437776#144215)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_STU_ID_ORI_437776#144215)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_CODPER_PRORE_437777#144146)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_CODPER_PRORE_437777#144146)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NUMSEANCE_437778#144202)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_NUMSEANCE_437778#144202)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NUMORDSEANCE_437779#144194)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_NUMORDSEANCE_437779#144194)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NUMTRT_437780#144203)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_NUMTRT_437780#144203)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_COMMENT_437781#144154)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_COMMENT_437781#144154)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_CODLOINC_437782#144144)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_CODLOINC_437782#144144)), MARX) END)

ColumnarToRow

WholeStageCodegen (1)

FileScan parquet [ET_ACADOS_437744#144130,ET_ACALIB_437747#144131,ET_ACAMED_437746#144132,ET_ACAPUB_437745#144133,ET_AETITLE_437736#144134,ET_AFFECT_437722#144135,ET_AG_ON_437705#144136,ET_ALARMES_437763#144137,ET_AVAILABLE_437735#144138,ET_CARRDV_437727#144139,ET_CODAPP_437699#144140,ET_CODATS_437729#144141,ET_CODEXA_437696#144142,ET_CODFVU_437740#144143,ET_CODLOINC_437782#144144,ET_CODPER_437701#144145,ET_CODPER_PRORE_437777#144146,ET_CODPRO_437703#144147,ET_CODPRX_437733#144148,ET_CODRAD_437702#144149,ET_CODSIT_437718#144150,ET_CODUTI_437720#144151,ET_CODVACA_437758#144152,ET_CODVAC_437757#144153,... 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#144130, ET_ACALIB_437747#144131, ET_ACAMED_437746#144132, ET_ACAPUB_437745#144133, ET_AETITLE_437736#144134, ET_AFFECT_437722#144135, ET_AG_ON_437705#144136, ET_ALARMES_437763#144137, ET_AVAILABLE_437735#144138, ET_CARRDV_437727#144139, ET_CODAPP_437699#144140, ET_CODATS_437729#144141, ET_CODEXA_437696#144142, ET_CODFVU_437740#144143, ET_CODLOINC_437782#144144, ET_CODPER_437701#144145, ET_CODPER_PRORE_437777#144146, ET_CODPRO_437703#144147, ET_CODPRX_437733#144148, ET_CODRAD_437702#144149, ET_CODSIT_437718#144150, ET_CODUTI_437720#144151, ET_CODVACA_437758#144152, ET_CODVAC_437757#144153, ET_COMMENT_437781#144154, ET_COMPRORE_437766#144155, ET_DATARR_437714#144156, ET_DATEXA_437706#144157, ET_DATFIN_437769#144158, ET_DATFVU_437741#144159, ET_DATMAJ_437719#144160, ET_DURAPR_437713#144161, ET_DURAVA_437711#144162, ET_DURPEN_437712#144163, ET_DURTOT_437710#144164, ET_EXAACC_437697#144165, ET_EXACOT_437761#144166, ET_FHIRID_437771#144167, ET_FLNOCOT_437762#144168, ET_FLPLAN_437734#144169, ET_FLTBDI_437739#144170, ET_HEUAPP_437755#144171, ET_HEUARR_437715#144172, ET_HEUD_E_437716#144173, ET_HEUEXA_437707#144174, ET_HEUFIN_437709#144175, ET_HEUFVU_437742#144176, ET_HEUF_E_437717#144177, ET_HEUSAL_437708#144178, ET_INCIDENCE_437750#144179, ET_LATER_437748#144180, ET_LIBEXA_437698#144181, ET_MEDNUC_437738#144182, ET_MODAL_AET_437764#144183, ET_M_AM_I_437704#144184, ET_NB_FIC_437774#144185, ET_NB_IMG_KEY_437775#144186, ET_NB_SER_437773#144187, ET_NOSEQ_437768#144188, ET_NUMDEM_437694#144189, ET_NUMDOS_437693#144190, ET_NUMEXA_437692#144191, ET_NUMEXA_ORI_437760#144192, ET_NUMGRP_437726#144193, ET_NUMORDSEANCE_437779#144194, ET_NUMORD_437752#144195, ET_NUMPDT_437751#144196, ET_NUMPRORE_437765#144197, ET_NUMRESA_437770#144198, ET_NUMRVX_437767#144199, ET_NUMSAL_437700#144200, ET_NUMSAT_437721#144201, ET_NUMSEANCE_437778#144202, ET_NUMTRT_437780#144203, ET_NUMXUS_437759#144204, ET_ORGANE_437754#144205, ET_ORIRDV_437756#144206, ET_POSITION_437749#144207, ET_REGANA_437772#144208, ET_SANSCR_437728#144209, ET_SECONDAIRE_437737#144210, ET_SOP_UID_437725#144211, ET_STABCD_437730#144212, ET_STA_PPS_437724#144213, ET_STU_ID_437723#144214, ET_STU_ID_ORI_437776#144215, ET_SUSPENS_437743#144216, ET_TRSTAT_437753#144217, ET_TYPBCD_437732#144218, ET_TYPESCLQ_437731#144219, ET_TYPEXA_437695#144220]
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#144130, ET_ACALIB_437747#144131, ET_ACAMED_437746#144132, ET_ACAPUB_437745#144133, ET_AETITLE_437736#144134, ET_AFFECT_437722#144135, ET_AG_ON_437705#144136, ET_ALARMES_437763#144137, ET_AVAILABLE_437735#144138, ET_CARRDV_437727#144139, ET_CODAPP_437699#144140, ET_CODATS_437729#144141, ET_CODEXA_437696#144142, ET_CODFVU_437740#144143, ET_CODLOINC_437782#144144, ET_CODPER_437701#144145, ET_CODPER_PRORE_437777#144146, ET_CODPRO_437703#144147, ET_CODPRX_437733#144148, ET_CODRAD_437702#144149, ET_CODSIT_437718#144150, ET_CODUTI_437720#144151, ET_CODVACA_437758#144152, ET_CODVAC_437757#144153, ET_COMMENT_437781#144154, ET_COMPRORE_437766#144155, ET_DATARR_437714#144156, ET_DATEXA_437706#144157, ET_DATFIN_437769#144158, ET_DATFVU_437741#144159, ET_DATMAJ_437719#144160, ET_DURAPR_437713#144161, ET_DURAVA_437711#144162, ET_DURPEN_437712#144163, ET_DURTOT_437710#144164, ET_EXAACC_437697#144165, ET_EXACOT_437761#144166, ET_FHIRID_437771#144167, ET_FLNOCOT_437762#144168, ET_FLPLAN_437734#144169, ET_FLTBDI_437739#144170, ET_HEUAPP_437755#144171, ET_HEUARR_437715#144172, ET_HEUD_E_437716#144173, ET_HEUEXA_437707#144174, ET_HEUFIN_437709#144175, ET_HEUFVU_437742#144176, ET_HEUF_E_437717#144177, ET_HEUSAL_437708#144178, ET_INCIDENCE_437750#144179, ET_LATER_437748#144180, ET_LIBEXA_437698#144181, ET_MEDNUC_437738#144182, ET_MODAL_AET_437764#144183, ET_M_AM_I_437704#144184, ET_NB_FIC_437774#144185, ET_NB_IMG_KEY_437775#144186, ET_NB_SER_437773#144187, ET_NOSEQ_437768#144188, ET_NUMDEM_437694#144189, ET_NUMDOS_437693#144190, ET_NUMEXA_437692#144191, ET_NUMEXA_ORI_437760#144192, ET_NUMGRP_437726#144193, ET_NUMORDSEANCE_437779#144194, ET_NUMORD_437752#144195, ET_NUMPDT_437751#144196, ET_NUMPRORE_437765#144197, ET_NUMRESA_437770#144198, ET_NUMRVX_437767#144199, ET_NUMSAL_437700#144200, ET_NUMSAT_437721#144201, ET_NUMSEANCE_437778#144202, ET_NUMTRT_437780#144203, ET_NUMXUS_437759#144204, ET_ORGANE_437754#144205, ET_ORIRDV_437756#144206, ET_POSITION_437749#144207, ET_REGANA_437772#144208, ET_SANSCR_437728#144209, ET_SECONDAIRE_437737#144210, ET_SOP_UID_437725#144211, ET_STABCD_437730#144212, ET_STA_PPS_437724#144213, ET_STU_ID_437723#144214, ET_STU_ID_ORI_437776#144215, ET_SUSPENS_437743#144216, ET_TRSTAT_437753#144217, ET_TYPBCD_437732#144218, ET_TYPESCLQ_437731#144219, ET_TYPEXA_437695#144220]

(3) Filter [codegen id : 1]
Input [91]: [ET_ACADOS_437744#144130, ET_ACALIB_437747#144131, ET_ACAMED_437746#144132, ET_ACAPUB_437745#144133, ET_AETITLE_437736#144134, ET_AFFECT_437722#144135, ET_AG_ON_437705#144136, ET_ALARMES_437763#144137, ET_AVAILABLE_437735#144138, ET_CARRDV_437727#144139, ET_CODAPP_437699#144140, ET_CODATS_437729#144141, ET_CODEXA_437696#144142, ET_CODFVU_437740#144143, ET_CODLOINC_437782#144144, ET_CODPER_437701#144145, ET_CODPER_PRORE_437777#144146, ET_CODPRO_437703#144147, ET_CODPRX_437733#144148, ET_CODRAD_437702#144149, ET_CODSIT_437718#144150, ET_CODUTI_437720#144151, ET_CODVACA_437758#144152, ET_CODVAC_437757#144153, ET_COMMENT_437781#144154, ET_COMPRORE_437766#144155, ET_DATARR_437714#144156, ET_DATEXA_437706#144157, ET_DATFIN_437769#144158, ET_DATFVU_437741#144159, ET_DATMAJ_437719#144160, ET_DURAPR_437713#144161, ET_DURAVA_437711#144162, ET_DURPEN_437712#144163, ET_DURTOT_437710#144164, ET_EXAACC_437697#144165, ET_EXACOT_437761#144166, ET_FHIRID_437771#144167, ET_FLNOCOT_437762#144168, ET_FLPLAN_437734#144169, ET_FLTBDI_437739#144170, ET_HEUAPP_437755#144171, ET_HEUARR_437715#144172, ET_HEUD_E_437716#144173, ET_HEUEXA_437707#144174, ET_HEUFIN_437709#144175, ET_HEUFVU_437742#144176, ET_HEUF_E_437717#144177, ET_HEUSAL_437708#144178, ET_INCIDENCE_437750#144179, ET_LATER_437748#144180, ET_LIBEXA_437698#144181, ET_MEDNUC_437738#144182, ET_MODAL_AET_437764#144183, ET_M_AM_I_437704#144184, ET_NB_FIC_437774#144185, ET_NB_IMG_KEY_437775#144186, ET_NB_SER_437773#144187, ET_NOSEQ_437768#144188, ET_NUMDEM_437694#144189, ET_NUMDOS_437693#144190, ET_NUMEXA_437692#144191, ET_NUMEXA_ORI_437760#144192, ET_NUMGRP_437726#144193, ET_NUMORDSEANCE_437779#144194, ET_NUMORD_437752#144195, ET_NUMPDT_437751#144196, ET_NUMPRORE_437765#144197, ET_NUMRESA_437770#144198, ET_NUMRVX_437767#144199, ET_NUMSAL_437700#144200, ET_NUMSAT_437721#144201, ET_NUMSEANCE_437778#144202, ET_NUMTRT_437780#144203, ET_NUMXUS_437759#144204, ET_ORGANE_437754#144205, ET_ORIRDV_437756#144206, ET_POSITION_437749#144207, ET_REGANA_437772#144208, ET_SANSCR_437728#144209, ET_SECONDAIRE_437737#144210, ET_SOP_UID_437725#144211, ET_STABCD_437730#144212, ET_STA_PPS_437724#144213, ET_STU_ID_437723#144214, ET_STU_ID_ORI_437776#144215, ET_SUSPENS_437743#144216, ET_TRSTAT_437753#144217, ET_TYPBCD_437732#144218, ET_TYPESCLQ_437731#144219, ET_TYPEXA_437695#144220]
Condition : ((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NUMEXA_437692#144191)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_NUMEXA_437692#144191)), MARX) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NUMDOS_437693#144190)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_NUMDOS_437693#144190)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NUMDEM_437694#144189)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_NUMDEM_437694#144189)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_TYPEXA_437695#144220)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_TYPEXA_437695#144220)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_CODEXA_437696#144142)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_CODEXA_437696#144142)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_EXAACC_437697#144165)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_EXAACC_437697#144165)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_LIBEXA_437698#144181)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_LIBEXA_437698#144181)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_CODAPP_437699#144140)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_CODAPP_437699#144140)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NUMSAL_437700#144200)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_NUMSAL_437700#144200)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_CODPER_437701#144145)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_CODPER_437701#144145)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_CODRAD_437702#144149)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_CODRAD_437702#144149)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_CODPRO_437703#144147)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_CODPRO_437703#144147)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_M_AM_I_437704#144184)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_M_AM_I_437704#144184)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_AG_ON_437705#144136)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_AG_ON_437705#144136)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_DATEXA_437706#144157)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_DATEXA_437706#144157)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_HEUEXA_437707#144174)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_HEUEXA_437707#144174)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_HEUSAL_437708#144178)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_HEUSAL_437708#144178)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_HEUFIN_437709#144175)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_HEUFIN_437709#144175)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_DURTOT_437710#144164)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_DURTOT_437710#144164)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_DURAVA_437711#144162)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_DURAVA_437711#144162)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_DURPEN_437712#144163)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_DURPEN_437712#144163)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_DURAPR_437713#144161)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_DURAPR_437713#144161)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_DATARR_437714#144156)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_DATARR_437714#144156)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_HEUARR_437715#144172)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_HEUARR_437715#144172)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_HEUD_E_437716#144173)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_HEUD_E_437716#144173)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_HEUF_E_437717#144177)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_HEUF_E_437717#144177)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_CODSIT_437718#144150)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_CODSIT_437718#144150)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_DATMAJ_437719#144160)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_DATMAJ_437719#144160)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_CODUTI_437720#144151)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_CODUTI_437720#144151)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NUMSAT_437721#144201)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_NUMSAT_437721#144201)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_AFFECT_437722#144135)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_AFFECT_437722#144135)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_STU_ID_437723#144214)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_STU_ID_437723#144214)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_STA_PPS_437724#144213)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_STA_PPS_437724#144213)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_SOP_UID_437725#144211)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_SOP_UID_437725#144211)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NUMGRP_437726#144193)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_NUMGRP_437726#144193)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_CARRDV_437727#144139)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_CARRDV_437727#144139)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_SANSCR_437728#144209)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_SANSCR_437728#144209)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_CODATS_437729#144141)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_CODATS_437729#144141)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_STABCD_437730#144212)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_STABCD_437730#144212)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_TYPESCLQ_437731#144219)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_TYPESCLQ_437731#144219)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_TYPBCD_437732#144218)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_TYPBCD_437732#144218)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_CODPRX_437733#144148)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_CODPRX_437733#144148)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_FLPLAN_437734#144169)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_FLPLAN_437734#144169)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_AVAILABLE_437735#144138)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_AVAILABLE_437735#144138)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_AETITLE_437736#144134)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_AETITLE_437736#144134)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_SECONDAIRE_437737#144210)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_SECONDAIRE_437737#144210)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_MEDNUC_437738#144182)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_MEDNUC_437738#144182)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_FLTBDI_437739#144170)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_FLTBDI_437739#144170)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_CODFVU_437740#144143)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_CODFVU_437740#144143)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_DATFVU_437741#144159)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_DATFVU_437741#144159)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_HEUFVU_437742#144176)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_HEUFVU_437742#144176)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_SUSPENS_437743#144216)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_SUSPENS_437743#144216)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_ACADOS_437744#144130)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_ACADOS_437744#144130)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_ACAPUB_437745#144133)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_ACAPUB_437745#144133)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_ACAMED_437746#144132)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_ACAMED_437746#144132)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_ACALIB_437747#144131)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_ACALIB_437747#144131)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_LATER_437748#144180)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_LATER_437748#144180)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_POSITION_437749#144207)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_POSITION_437749#144207)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_INCIDENCE_437750#144179)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_INCIDENCE_437750#144179)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NUMPDT_437751#144196)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_NUMPDT_437751#144196)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NUMORD_437752#144195)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_NUMORD_437752#144195)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_TRSTAT_437753#144217)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_TRSTAT_437753#144217)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_ORGANE_437754#144205)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_ORGANE_437754#144205)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_HEUAPP_437755#144171)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_HEUAPP_437755#144171)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_ORIRDV_437756#144206)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_ORIRDV_437756#144206)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_CODVAC_437757#144153)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_CODVAC_437757#144153)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_CODVACA_437758#144152)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_CODVACA_437758#144152)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NUMXUS_437759#144204)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_NUMXUS_437759#144204)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NUMEXA_ORI_437760#144192)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_NUMEXA_ORI_437760#144192)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_EXACOT_437761#144166)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_EXACOT_437761#144166)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_FLNOCOT_437762#144168)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_FLNOCOT_437762#144168)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_ALARMES_437763#144137)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_ALARMES_437763#144137)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_MODAL_AET_437764#144183)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_MODAL_AET_437764#144183)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NUMPRORE_437765#144197)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_NUMPRORE_437765#144197)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_COMPRORE_437766#144155)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_COMPRORE_437766#144155)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NUMRVX_437767#144199)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_NUMRVX_437767#144199)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NOSEQ_437768#144188)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_NOSEQ_437768#144188)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_DATFIN_437769#144158)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_DATFIN_437769#144158)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NUMRESA_437770#144198)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_NUMRESA_437770#144198)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_FHIRID_437771#144167)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_FHIRID_437771#144167)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_REGANA_437772#144208)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_REGANA_437772#144208)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NB_SER_437773#144187)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_NB_SER_437773#144187)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NB_FIC_437774#144185)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_NB_FIC_437774#144185)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NB_IMG_KEY_437775#144186)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_NB_IMG_KEY_437775#144186)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_STU_ID_ORI_437776#144215)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_STU_ID_ORI_437776#144215)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_CODPER_PRORE_437777#144146)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_CODPER_PRORE_437777#144146)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NUMSEANCE_437778#144202)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_NUMSEANCE_437778#144202)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NUMORDSEANCE_437779#144194)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_NUMORDSEANCE_437779#144194)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NUMTRT_437780#144203)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_NUMTRT_437780#144203)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_COMMENT_437781#144154)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_COMMENT_437781#144154)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_CODLOINC_437782#144144)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_CODLOINC_437782#144144)), MARX) END)

(4) Project [codegen id : 1]
Output: []
Input [91]: [ET_ACADOS_437744#144130, ET_ACALIB_437747#144131, ET_ACAMED_437746#144132, ET_ACAPUB_437745#144133, ET_AETITLE_437736#144134, ET_AFFECT_437722#144135, ET_AG_ON_437705#144136, ET_ALARMES_437763#144137, ET_AVAILABLE_437735#144138, ET_CARRDV_437727#144139, ET_CODAPP_437699#144140, ET_CODATS_437729#144141, ET_CODEXA_437696#144142, ET_CODFVU_437740#144143, ET_CODLOINC_437782#144144, ET_CODPER_437701#144145, ET_CODPER_PRORE_437777#144146, ET_CODPRO_437703#144147, ET_CODPRX_437733#144148, ET_CODRAD_437702#144149, ET_CODSIT_437718#144150, ET_CODUTI_437720#144151, ET_CODVACA_437758#144152, ET_CODVAC_437757#144153, ET_COMMENT_437781#144154, ET_COMPRORE_437766#144155, ET_DATARR_437714#144156, ET_DATEXA_437706#144157, ET_DATFIN_437769#144158, ET_DATFVU_437741#144159, ET_DATMAJ_437719#144160, ET_DURAPR_437713#144161, ET_DURAVA_437711#144162, ET_DURPEN_437712#144163, ET_DURTOT_437710#144164, ET_EXAACC_437697#144165, ET_EXACOT_437761#144166, ET_FHIRID_437771#144167, ET_FLNOCOT_437762#144168, ET_FLPLAN_437734#144169, ET_FLTBDI_437739#144170, ET_HEUAPP_437755#144171, ET_HEUARR_437715#144172, ET_HEUD_E_437716#144173, ET_HEUEXA_437707#144174, ET_HEUFIN_437709#144175, ET_HEUFVU_437742#144176, ET_HEUF_E_437717#144177, ET_HEUSAL_437708#144178, ET_INCIDENCE_437750#144179, ET_LATER_437748#144180, ET_LIBEXA_437698#144181, ET_MEDNUC_437738#144182, ET_MODAL_AET_437764#144183, ET_M_AM_I_437704#144184, ET_NB_FIC_437774#144185, ET_NB_IMG_KEY_437775#144186, ET_NB_SER_437773#144187, ET_NOSEQ_437768#144188, ET_NUMDEM_437694#144189, ET_NUMDOS_437693#144190, ET_NUMEXA_437692#144191, ET_NUMEXA_ORI_437760#144192, ET_NUMGRP_437726#144193, ET_NUMORDSEANCE_437779#144194, ET_NUMORD_437752#144195, ET_NUMPDT_437751#144196, ET_NUMPRORE_437765#144197, ET_NUMRESA_437770#144198, ET_NUMRVX_437767#144199, ET_NUMSAL_437700#144200, ET_NUMSAT_437721#144201, ET_NUMSEANCE_437778#144202, ET_NUMTRT_437780#144203, ET_NUMXUS_437759#144204, ET_ORGANE_437754#144205, ET_ORIRDV_437756#144206, ET_POSITION_437749#144207, ET_REGANA_437772#144208, ET_SANSCR_437728#144209, ET_SECONDAIRE_437737#144210, ET_SOP_UID_437725#144211, ET_STABCD_437730#144212, ET_STA_PPS_437724#144213, ET_STU_ID_437723#144214, ET_STU_ID_ORI_437776#144215, ET_SUSPENS_437743#144216, ET_TRSTAT_437753#144217, ET_TYPBCD_437732#144218, ET_TYPESCLQ_437731#144219, ET_TYPEXA_437695#144220]

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

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

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

(8) HashAggregate [codegen id : 2]
Input [1]: [count#145884L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#144858L]
Results [1]: [count(1)#144858L AS COL_2e882b96-f2a2-4e35-846f-ec1530b487f0#144860L]

(9) Filter
Input [91]: [ET_ACADOS_437744#144130, ET_ACALIB_437747#144131, ET_ACAMED_437746#144132, ET_ACAPUB_437745#144133, ET_AETITLE_437736#144134, ET_AFFECT_437722#144135, ET_AG_ON_437705#144136, ET_ALARMES_437763#144137, ET_AVAILABLE_437735#144138, ET_CARRDV_437727#144139, ET_CODAPP_437699#144140, ET_CODATS_437729#144141, ET_CODEXA_437696#144142, ET_CODFVU_437740#144143, ET_CODLOINC_437782#144144, ET_CODPER_437701#144145, ET_CODPER_PRORE_437777#144146, ET_CODPRO_437703#144147, ET_CODPRX_437733#144148, ET_CODRAD_437702#144149, ET_CODSIT_437718#144150, ET_CODUTI_437720#144151, ET_CODVACA_437758#144152, ET_CODVAC_437757#144153, ET_COMMENT_437781#144154, ET_COMPRORE_437766#144155, ET_DATARR_437714#144156, ET_DATEXA_437706#144157, ET_DATFIN_437769#144158, ET_DATFVU_437741#144159, ET_DATMAJ_437719#144160, ET_DURAPR_437713#144161, ET_DURAVA_437711#144162, ET_DURPEN_437712#144163, ET_DURTOT_437710#144164, ET_EXAACC_437697#144165, ET_EXACOT_437761#144166, ET_FHIRID_437771#144167, ET_FLNOCOT_437762#144168, ET_FLPLAN_437734#144169, ET_FLTBDI_437739#144170, ET_HEUAPP_437755#144171, ET_HEUARR_437715#144172, ET_HEUD_E_437716#144173, ET_HEUEXA_437707#144174, ET_HEUFIN_437709#144175, ET_HEUFVU_437742#144176, ET_HEUF_E_437717#144177, ET_HEUSAL_437708#144178, ET_INCIDENCE_437750#144179, ET_LATER_437748#144180, ET_LIBEXA_437698#144181, ET_MEDNUC_437738#144182, ET_MODAL_AET_437764#144183, ET_M_AM_I_437704#144184, ET_NB_FIC_437774#144185, ET_NB_IMG_KEY_437775#144186, ET_NB_SER_437773#144187, ET_NOSEQ_437768#144188, ET_NUMDEM_437694#144189, ET_NUMDOS_437693#144190, ET_NUMEXA_437692#144191, ET_NUMEXA_ORI_437760#144192, ET_NUMGRP_437726#144193, ET_NUMORDSEANCE_437779#144194, ET_NUMORD_437752#144195, ET_NUMPDT_437751#144196, ET_NUMPRORE_437765#144197, ET_NUMRESA_437770#144198, ET_NUMRVX_437767#144199, ET_NUMSAL_437700#144200, ET_NUMSAT_437721#144201, ET_NUMSEANCE_437778#144202, ET_NUMTRT_437780#144203, ET_NUMXUS_437759#144204, ET_ORGANE_437754#144205, ET_ORIRDV_437756#144206, ET_POSITION_437749#144207, ET_REGANA_437772#144208, ET_SANSCR_437728#144209, ET_SECONDAIRE_437737#144210, ET_SOP_UID_437725#144211, ET_STABCD_437730#144212, ET_STA_PPS_437724#144213, ET_STU_ID_437723#144214, ET_STU_ID_ORI_437776#144215, ET_SUSPENS_437743#144216, ET_TRSTAT_437753#144217, ET_TYPBCD_437732#144218, ET_TYPESCLQ_437731#144219, ET_TYPEXA_437695#144220]
Condition : ((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NUMEXA_437692#144191)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_NUMEXA_437692#144191)), MARX) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NUMDOS_437693#144190)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_NUMDOS_437693#144190)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NUMDEM_437694#144189)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_NUMDEM_437694#144189)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_TYPEXA_437695#144220)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_TYPEXA_437695#144220)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_CODEXA_437696#144142)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_CODEXA_437696#144142)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_EXAACC_437697#144165)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_EXAACC_437697#144165)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_LIBEXA_437698#144181)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_LIBEXA_437698#144181)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_CODAPP_437699#144140)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_CODAPP_437699#144140)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NUMSAL_437700#144200)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_NUMSAL_437700#144200)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_CODPER_437701#144145)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_CODPER_437701#144145)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_CODRAD_437702#144149)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_CODRAD_437702#144149)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_CODPRO_437703#144147)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_CODPRO_437703#144147)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_M_AM_I_437704#144184)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_M_AM_I_437704#144184)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_AG_ON_437705#144136)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_AG_ON_437705#144136)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_DATEXA_437706#144157)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_DATEXA_437706#144157)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_HEUEXA_437707#144174)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_HEUEXA_437707#144174)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_HEUSAL_437708#144178)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_HEUSAL_437708#144178)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_HEUFIN_437709#144175)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_HEUFIN_437709#144175)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_DURTOT_437710#144164)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_DURTOT_437710#144164)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_DURAVA_437711#144162)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_DURAVA_437711#144162)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_DURPEN_437712#144163)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_DURPEN_437712#144163)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_DURAPR_437713#144161)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_DURAPR_437713#144161)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_DATARR_437714#144156)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_DATARR_437714#144156)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_HEUARR_437715#144172)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_HEUARR_437715#144172)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_HEUD_E_437716#144173)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_HEUD_E_437716#144173)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_HEUF_E_437717#144177)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_HEUF_E_437717#144177)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_CODSIT_437718#144150)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_CODSIT_437718#144150)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_DATMAJ_437719#144160)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_DATMAJ_437719#144160)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_CODUTI_437720#144151)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_CODUTI_437720#144151)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NUMSAT_437721#144201)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_NUMSAT_437721#144201)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_AFFECT_437722#144135)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_AFFECT_437722#144135)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_STU_ID_437723#144214)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_STU_ID_437723#144214)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_STA_PPS_437724#144213)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_STA_PPS_437724#144213)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_SOP_UID_437725#144211)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_SOP_UID_437725#144211)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NUMGRP_437726#144193)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_NUMGRP_437726#144193)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_CARRDV_437727#144139)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_CARRDV_437727#144139)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_SANSCR_437728#144209)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_SANSCR_437728#144209)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_CODATS_437729#144141)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_CODATS_437729#144141)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_STABCD_437730#144212)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_STABCD_437730#144212)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_TYPESCLQ_437731#144219)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_TYPESCLQ_437731#144219)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_TYPBCD_437732#144218)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_TYPBCD_437732#144218)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_CODPRX_437733#144148)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_CODPRX_437733#144148)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_FLPLAN_437734#144169)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_FLPLAN_437734#144169)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_AVAILABLE_437735#144138)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_AVAILABLE_437735#144138)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_AETITLE_437736#144134)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_AETITLE_437736#144134)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_SECONDAIRE_437737#144210)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_SECONDAIRE_437737#144210)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_MEDNUC_437738#144182)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_MEDNUC_437738#144182)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_FLTBDI_437739#144170)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_FLTBDI_437739#144170)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_CODFVU_437740#144143)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_CODFVU_437740#144143)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_DATFVU_437741#144159)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_DATFVU_437741#144159)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_HEUFVU_437742#144176)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_HEUFVU_437742#144176)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_SUSPENS_437743#144216)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_SUSPENS_437743#144216)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_ACADOS_437744#144130)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_ACADOS_437744#144130)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_ACAPUB_437745#144133)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_ACAPUB_437745#144133)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_ACAMED_437746#144132)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_ACAMED_437746#144132)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_ACALIB_437747#144131)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_ACALIB_437747#144131)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_LATER_437748#144180)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_LATER_437748#144180)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_POSITION_437749#144207)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_POSITION_437749#144207)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_INCIDENCE_437750#144179)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_INCIDENCE_437750#144179)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NUMPDT_437751#144196)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_NUMPDT_437751#144196)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NUMORD_437752#144195)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_NUMORD_437752#144195)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_TRSTAT_437753#144217)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_TRSTAT_437753#144217)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_ORGANE_437754#144205)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_ORGANE_437754#144205)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_HEUAPP_437755#144171)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_HEUAPP_437755#144171)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_ORIRDV_437756#144206)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_ORIRDV_437756#144206)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_CODVAC_437757#144153)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_CODVAC_437757#144153)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_CODVACA_437758#144152)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_CODVACA_437758#144152)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NUMXUS_437759#144204)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_NUMXUS_437759#144204)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NUMEXA_ORI_437760#144192)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_NUMEXA_ORI_437760#144192)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_EXACOT_437761#144166)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_EXACOT_437761#144166)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_FLNOCOT_437762#144168)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_FLNOCOT_437762#144168)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_ALARMES_437763#144137)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_ALARMES_437763#144137)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_MODAL_AET_437764#144183)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_MODAL_AET_437764#144183)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NUMPRORE_437765#144197)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_NUMPRORE_437765#144197)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_COMPRORE_437766#144155)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_COMPRORE_437766#144155)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NUMRVX_437767#144199)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_NUMRVX_437767#144199)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NOSEQ_437768#144188)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_NOSEQ_437768#144188)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_DATFIN_437769#144158)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_DATFIN_437769#144158)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NUMRESA_437770#144198)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_NUMRESA_437770#144198)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_FHIRID_437771#144167)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_FHIRID_437771#144167)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_REGANA_437772#144208)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_REGANA_437772#144208)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NB_SER_437773#144187)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_NB_SER_437773#144187)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NB_FIC_437774#144185)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_NB_FIC_437774#144185)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NB_IMG_KEY_437775#144186)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_NB_IMG_KEY_437775#144186)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_STU_ID_ORI_437776#144215)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_STU_ID_ORI_437776#144215)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_CODPER_PRORE_437777#144146)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_CODPER_PRORE_437777#144146)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NUMSEANCE_437778#144202)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_NUMSEANCE_437778#144202)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NUMORDSEANCE_437779#144194)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_NUMORDSEANCE_437779#144194)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NUMTRT_437780#144203)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_NUMTRT_437780#144203)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_COMMENT_437781#144154)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_COMMENT_437781#144154)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_CODLOINC_437782#144144)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_CODLOINC_437782#144144)), MARX) END)

(10) Project
Output: []
Input [91]: [ET_ACADOS_437744#144130, ET_ACALIB_437747#144131, ET_ACAMED_437746#144132, ET_ACAPUB_437745#144133, ET_AETITLE_437736#144134, ET_AFFECT_437722#144135, ET_AG_ON_437705#144136, ET_ALARMES_437763#144137, ET_AVAILABLE_437735#144138, ET_CARRDV_437727#144139, ET_CODAPP_437699#144140, ET_CODATS_437729#144141, ET_CODEXA_437696#144142, ET_CODFVU_437740#144143, ET_CODLOINC_437782#144144, ET_CODPER_437701#144145, ET_CODPER_PRORE_437777#144146, ET_CODPRO_437703#144147, ET_CODPRX_437733#144148, ET_CODRAD_437702#144149, ET_CODSIT_437718#144150, ET_CODUTI_437720#144151, ET_CODVACA_437758#144152, ET_CODVAC_437757#144153, ET_COMMENT_437781#144154, ET_COMPRORE_437766#144155, ET_DATARR_437714#144156, ET_DATEXA_437706#144157, ET_DATFIN_437769#144158, ET_DATFVU_437741#144159, ET_DATMAJ_437719#144160, ET_DURAPR_437713#144161, ET_DURAVA_437711#144162, ET_DURPEN_437712#144163, ET_DURTOT_437710#144164, ET_EXAACC_437697#144165, ET_EXACOT_437761#144166, ET_FHIRID_437771#144167, ET_FLNOCOT_437762#144168, ET_FLPLAN_437734#144169, ET_FLTBDI_437739#144170, ET_HEUAPP_437755#144171, ET_HEUARR_437715#144172, ET_HEUD_E_437716#144173, ET_HEUEXA_437707#144174, ET_HEUFIN_437709#144175, ET_HEUFVU_437742#144176, ET_HEUF_E_437717#144177, ET_HEUSAL_437708#144178, ET_INCIDENCE_437750#144179, ET_LATER_437748#144180, ET_LIBEXA_437698#144181, ET_MEDNUC_437738#144182, ET_MODAL_AET_437764#144183, ET_M_AM_I_437704#144184, ET_NB_FIC_437774#144185, ET_NB_IMG_KEY_437775#144186, ET_NB_SER_437773#144187, ET_NOSEQ_437768#144188, ET_NUMDEM_437694#144189, ET_NUMDOS_437693#144190, ET_NUMEXA_437692#144191, ET_NUMEXA_ORI_437760#144192, ET_NUMGRP_437726#144193, ET_NUMORDSEANCE_437779#144194, ET_NUMORD_437752#144195, ET_NUMPDT_437751#144196, ET_NUMPRORE_437765#144197, ET_NUMRESA_437770#144198, ET_NUMRVX_437767#144199, ET_NUMSAL_437700#144200, ET_NUMSAT_437721#144201, ET_NUMSEANCE_437778#144202, ET_NUMTRT_437780#144203, ET_NUMXUS_437759#144204, ET_ORGANE_437754#144205, ET_ORIRDV_437756#144206, ET_POSITION_437749#144207, ET_REGANA_437772#144208, ET_SANSCR_437728#144209, ET_SECONDAIRE_437737#144210, ET_SOP_UID_437725#144211, ET_STABCD_437730#144212, ET_STA_PPS_437724#144213, ET_STU_ID_437723#144214, ET_STU_ID_ORI_437776#144215, ET_SUSPENS_437743#144216, ET_TRSTAT_437753#144217, ET_TYPBCD_437732#144218, ET_TYPESCLQ_437731#144219, ET_TYPEXA_437695#144220]

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

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

(13) HashAggregate
Input [1]: [count#145884L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#144858L]
Results [1]: [count(1)#144858L AS COL_2e882b96-f2a2-4e35-846f-ec1530b487f0#144860L]

(14) AdaptiveSparkPlan
Output [1]: [COL_2e882b96-f2a2-4e35-846f-ec1530b487f0#144860L]
Arguments: isFinalPlan=true

SQL / DataFrame Properties

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