hdh-spark-job - Details for Query 581

Submitted Time: 2026/10/21 21:31:41
Duration: 5 s
Succeeded Jobs: 503 513

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: 1 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: 2.0 s"; 5 [labelType="html" label="HashAggregate time in aggregation build: 2.0 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: 44 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=11306]

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

Project

Filter ((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NUMEXA_437692#116353)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_NUMEXA_437692#116353)), MARX) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NUMDOS_437693#116352)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_NUMDOS_437693#116352)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NUMDEM_437694#116351)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_NUMDEM_437694#116351)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_TYPEXA_437695#116382)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_TYPEXA_437695#116382)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_CODEXA_437696#116304)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_CODEXA_437696#116304)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_EXAACC_437697#116327)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_EXAACC_437697#116327)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_LIBEXA_437698#116343)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_LIBEXA_437698#116343)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_CODAPP_437699#116302)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_CODAPP_437699#116302)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NUMSAL_437700#116362)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_NUMSAL_437700#116362)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_CODPER_437701#116307)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_CODPER_437701#116307)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_CODRAD_437702#116311)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_CODRAD_437702#116311)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_CODPRO_437703#116309)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_CODPRO_437703#116309)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_M_AM_I_437704#116346)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_M_AM_I_437704#116346)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_AG_ON_437705#116298)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_AG_ON_437705#116298)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_DATEXA_437706#116319)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_DATEXA_437706#116319)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_HEUEXA_437707#116336)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_HEUEXA_437707#116336)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_HEUSAL_437708#116340)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_HEUSAL_437708#116340)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_HEUFIN_437709#116337)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_HEUFIN_437709#116337)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_DURTOT_437710#116326)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_DURTOT_437710#116326)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_DURAVA_437711#116324)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_DURAVA_437711#116324)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_DURPEN_437712#116325)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_DURPEN_437712#116325)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_DURAPR_437713#116323)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_DURAPR_437713#116323)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_DATARR_437714#116318)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_DATARR_437714#116318)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_HEUARR_437715#116334)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_HEUARR_437715#116334)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_HEUD_E_437716#116335)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_HEUD_E_437716#116335)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_HEUF_E_437717#116339)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_HEUF_E_437717#116339)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_CODSIT_437718#116312)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_CODSIT_437718#116312)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_DATMAJ_437719#116322)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_DATMAJ_437719#116322)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_CODUTI_437720#116313)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_CODUTI_437720#116313)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NUMSAT_437721#116363)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_NUMSAT_437721#116363)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_AFFECT_437722#116297)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_AFFECT_437722#116297)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_STU_ID_437723#116376)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_STU_ID_437723#116376)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_STA_PPS_437724#116375)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_STA_PPS_437724#116375)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_SOP_UID_437725#116373)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_SOP_UID_437725#116373)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NUMGRP_437726#116355)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_NUMGRP_437726#116355)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_CARRDV_437727#116301)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_CARRDV_437727#116301)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_SANSCR_437728#116371)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_SANSCR_437728#116371)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_CODATS_437729#116303)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_CODATS_437729#116303)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_STABCD_437730#116374)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_STABCD_437730#116374)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_TYPESCLQ_437731#116381)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_TYPESCLQ_437731#116381)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_TYPBCD_437732#116380)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_TYPBCD_437732#116380)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_CODPRX_437733#116310)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_CODPRX_437733#116310)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_FLPLAN_437734#116331)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_FLPLAN_437734#116331)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_AVAILABLE_437735#116300)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_AVAILABLE_437735#116300)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_AETITLE_437736#116296)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_AETITLE_437736#116296)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_SECONDAIRE_437737#116372)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_SECONDAIRE_437737#116372)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_MEDNUC_437738#116344)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_MEDNUC_437738#116344)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_FLTBDI_437739#116332)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_FLTBDI_437739#116332)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_CODFVU_437740#116305)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_CODFVU_437740#116305)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_DATFVU_437741#116321)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_DATFVU_437741#116321)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_HEUFVU_437742#116338)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_HEUFVU_437742#116338)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_SUSPENS_437743#116378)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_SUSPENS_437743#116378)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_ACADOS_437744#116292)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_ACADOS_437744#116292)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_ACAPUB_437745#116295)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_ACAPUB_437745#116295)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_ACAMED_437746#116294)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_ACAMED_437746#116294)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_ACALIB_437747#116293)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_ACALIB_437747#116293)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_LATER_437748#116342)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_LATER_437748#116342)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_POSITION_437749#116369)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_POSITION_437749#116369)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_INCIDENCE_437750#116341)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_INCIDENCE_437750#116341)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NUMPDT_437751#116358)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_NUMPDT_437751#116358)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NUMORD_437752#116357)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_NUMORD_437752#116357)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_TRSTAT_437753#116379)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_TRSTAT_437753#116379)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_ORGANE_437754#116367)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_ORGANE_437754#116367)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_HEUAPP_437755#116333)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_HEUAPP_437755#116333)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_ORIRDV_437756#116368)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_ORIRDV_437756#116368)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_CODVAC_437757#116315)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_CODVAC_437757#116315)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_CODVACA_437758#116314)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_CODVACA_437758#116314)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NUMXUS_437759#116366)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_NUMXUS_437759#116366)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NUMEXA_ORI_437760#116354)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_NUMEXA_ORI_437760#116354)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_EXACOT_437761#116328)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_EXACOT_437761#116328)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_FLNOCOT_437762#116330)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_FLNOCOT_437762#116330)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_ALARMES_437763#116299)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_ALARMES_437763#116299)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_MODAL_AET_437764#116345)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_MODAL_AET_437764#116345)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NUMPRORE_437765#116359)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_NUMPRORE_437765#116359)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_COMPRORE_437766#116317)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_COMPRORE_437766#116317)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NUMRVX_437767#116361)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_NUMRVX_437767#116361)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NOSEQ_437768#116350)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_NOSEQ_437768#116350)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_DATFIN_437769#116320)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_DATFIN_437769#116320)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NUMRESA_437770#116360)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_NUMRESA_437770#116360)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_FHIRID_437771#116329)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_FHIRID_437771#116329)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_REGANA_437772#116370)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_REGANA_437772#116370)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NB_SER_437773#116349)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_NB_SER_437773#116349)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NB_FIC_437774#116347)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_NB_FIC_437774#116347)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NB_IMG_KEY_437775#116348)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_NB_IMG_KEY_437775#116348)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_STU_ID_ORI_437776#116377)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_STU_ID_ORI_437776#116377)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_CODPER_PRORE_437777#116308)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_CODPER_PRORE_437777#116308)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NUMSEANCE_437778#116364)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_NUMSEANCE_437778#116364)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NUMORDSEANCE_437779#116356)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_NUMORDSEANCE_437779#116356)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NUMTRT_437780#116365)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_NUMTRT_437780#116365)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_COMMENT_437781#116316)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_COMMENT_437781#116316)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_CODLOINC_437782#116306)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_CODLOINC_437782#116306)), MARX) END)

ColumnarToRow

WholeStageCodegen (1)

FileScan parquet [ET_ACADOS_437744#116292,ET_ACALIB_437747#116293,ET_ACAMED_437746#116294,ET_ACAPUB_437745#116295,ET_AETITLE_437736#116296,ET_AFFECT_437722#116297,ET_AG_ON_437705#116298,ET_ALARMES_437763#116299,ET_AVAILABLE_437735#116300,ET_CARRDV_437727#116301,ET_CODAPP_437699#116302,ET_CODATS_437729#116303,ET_CODEXA_437696#116304,ET_CODFVU_437740#116305,ET_CODLOINC_437782#116306,ET_CODPER_437701#116307,ET_CODPER_PRORE_437777#116308,ET_CODPRO_437703#116309,ET_CODPRX_437733#116310,ET_CODRAD_437702#116311,ET_CODSIT_437718#116312,ET_CODUTI_437720#116313,ET_CODVACA_437758#116314,ET_CODVAC_437757#116315,... 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#116292, ET_ACALIB_437747#116293, ET_ACAMED_437746#116294, ET_ACAPUB_437745#116295, ET_AETITLE_437736#116296, ET_AFFECT_437722#116297, ET_AG_ON_437705#116298, ET_ALARMES_437763#116299, ET_AVAILABLE_437735#116300, ET_CARRDV_437727#116301, ET_CODAPP_437699#116302, ET_CODATS_437729#116303, ET_CODEXA_437696#116304, ET_CODFVU_437740#116305, ET_CODLOINC_437782#116306, ET_CODPER_437701#116307, ET_CODPER_PRORE_437777#116308, ET_CODPRO_437703#116309, ET_CODPRX_437733#116310, ET_CODRAD_437702#116311, ET_CODSIT_437718#116312, ET_CODUTI_437720#116313, ET_CODVACA_437758#116314, ET_CODVAC_437757#116315, ET_COMMENT_437781#116316, ET_COMPRORE_437766#116317, ET_DATARR_437714#116318, ET_DATEXA_437706#116319, ET_DATFIN_437769#116320, ET_DATFVU_437741#116321, ET_DATMAJ_437719#116322, ET_DURAPR_437713#116323, ET_DURAVA_437711#116324, ET_DURPEN_437712#116325, ET_DURTOT_437710#116326, ET_EXAACC_437697#116327, ET_EXACOT_437761#116328, ET_FHIRID_437771#116329, ET_FLNOCOT_437762#116330, ET_FLPLAN_437734#116331, ET_FLTBDI_437739#116332, ET_HEUAPP_437755#116333, ET_HEUARR_437715#116334, ET_HEUD_E_437716#116335, ET_HEUEXA_437707#116336, ET_HEUFIN_437709#116337, ET_HEUFVU_437742#116338, ET_HEUF_E_437717#116339, ET_HEUSAL_437708#116340, ET_INCIDENCE_437750#116341, ET_LATER_437748#116342, ET_LIBEXA_437698#116343, ET_MEDNUC_437738#116344, ET_MODAL_AET_437764#116345, ET_M_AM_I_437704#116346, ET_NB_FIC_437774#116347, ET_NB_IMG_KEY_437775#116348, ET_NB_SER_437773#116349, ET_NOSEQ_437768#116350, ET_NUMDEM_437694#116351, ET_NUMDOS_437693#116352, ET_NUMEXA_437692#116353, ET_NUMEXA_ORI_437760#116354, ET_NUMGRP_437726#116355, ET_NUMORDSEANCE_437779#116356, ET_NUMORD_437752#116357, ET_NUMPDT_437751#116358, ET_NUMPRORE_437765#116359, ET_NUMRESA_437770#116360, ET_NUMRVX_437767#116361, ET_NUMSAL_437700#116362, ET_NUMSAT_437721#116363, ET_NUMSEANCE_437778#116364, ET_NUMTRT_437780#116365, ET_NUMXUS_437759#116366, ET_ORGANE_437754#116367, ET_ORIRDV_437756#116368, ET_POSITION_437749#116369, ET_REGANA_437772#116370, ET_SANSCR_437728#116371, ET_SECONDAIRE_437737#116372, ET_SOP_UID_437725#116373, ET_STABCD_437730#116374, ET_STA_PPS_437724#116375, ET_STU_ID_437723#116376, ET_STU_ID_ORI_437776#116377, ET_SUSPENS_437743#116378, ET_TRSTAT_437753#116379, ET_TYPBCD_437732#116380, ET_TYPESCLQ_437731#116381, ET_TYPEXA_437695#116382]
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#116292, ET_ACALIB_437747#116293, ET_ACAMED_437746#116294, ET_ACAPUB_437745#116295, ET_AETITLE_437736#116296, ET_AFFECT_437722#116297, ET_AG_ON_437705#116298, ET_ALARMES_437763#116299, ET_AVAILABLE_437735#116300, ET_CARRDV_437727#116301, ET_CODAPP_437699#116302, ET_CODATS_437729#116303, ET_CODEXA_437696#116304, ET_CODFVU_437740#116305, ET_CODLOINC_437782#116306, ET_CODPER_437701#116307, ET_CODPER_PRORE_437777#116308, ET_CODPRO_437703#116309, ET_CODPRX_437733#116310, ET_CODRAD_437702#116311, ET_CODSIT_437718#116312, ET_CODUTI_437720#116313, ET_CODVACA_437758#116314, ET_CODVAC_437757#116315, ET_COMMENT_437781#116316, ET_COMPRORE_437766#116317, ET_DATARR_437714#116318, ET_DATEXA_437706#116319, ET_DATFIN_437769#116320, ET_DATFVU_437741#116321, ET_DATMAJ_437719#116322, ET_DURAPR_437713#116323, ET_DURAVA_437711#116324, ET_DURPEN_437712#116325, ET_DURTOT_437710#116326, ET_EXAACC_437697#116327, ET_EXACOT_437761#116328, ET_FHIRID_437771#116329, ET_FLNOCOT_437762#116330, ET_FLPLAN_437734#116331, ET_FLTBDI_437739#116332, ET_HEUAPP_437755#116333, ET_HEUARR_437715#116334, ET_HEUD_E_437716#116335, ET_HEUEXA_437707#116336, ET_HEUFIN_437709#116337, ET_HEUFVU_437742#116338, ET_HEUF_E_437717#116339, ET_HEUSAL_437708#116340, ET_INCIDENCE_437750#116341, ET_LATER_437748#116342, ET_LIBEXA_437698#116343, ET_MEDNUC_437738#116344, ET_MODAL_AET_437764#116345, ET_M_AM_I_437704#116346, ET_NB_FIC_437774#116347, ET_NB_IMG_KEY_437775#116348, ET_NB_SER_437773#116349, ET_NOSEQ_437768#116350, ET_NUMDEM_437694#116351, ET_NUMDOS_437693#116352, ET_NUMEXA_437692#116353, ET_NUMEXA_ORI_437760#116354, ET_NUMGRP_437726#116355, ET_NUMORDSEANCE_437779#116356, ET_NUMORD_437752#116357, ET_NUMPDT_437751#116358, ET_NUMPRORE_437765#116359, ET_NUMRESA_437770#116360, ET_NUMRVX_437767#116361, ET_NUMSAL_437700#116362, ET_NUMSAT_437721#116363, ET_NUMSEANCE_437778#116364, ET_NUMTRT_437780#116365, ET_NUMXUS_437759#116366, ET_ORGANE_437754#116367, ET_ORIRDV_437756#116368, ET_POSITION_437749#116369, ET_REGANA_437772#116370, ET_SANSCR_437728#116371, ET_SECONDAIRE_437737#116372, ET_SOP_UID_437725#116373, ET_STABCD_437730#116374, ET_STA_PPS_437724#116375, ET_STU_ID_437723#116376, ET_STU_ID_ORI_437776#116377, ET_SUSPENS_437743#116378, ET_TRSTAT_437753#116379, ET_TYPBCD_437732#116380, ET_TYPESCLQ_437731#116381, ET_TYPEXA_437695#116382]

(3) Filter [codegen id : 1]
Input [91]: [ET_ACADOS_437744#116292, ET_ACALIB_437747#116293, ET_ACAMED_437746#116294, ET_ACAPUB_437745#116295, ET_AETITLE_437736#116296, ET_AFFECT_437722#116297, ET_AG_ON_437705#116298, ET_ALARMES_437763#116299, ET_AVAILABLE_437735#116300, ET_CARRDV_437727#116301, ET_CODAPP_437699#116302, ET_CODATS_437729#116303, ET_CODEXA_437696#116304, ET_CODFVU_437740#116305, ET_CODLOINC_437782#116306, ET_CODPER_437701#116307, ET_CODPER_PRORE_437777#116308, ET_CODPRO_437703#116309, ET_CODPRX_437733#116310, ET_CODRAD_437702#116311, ET_CODSIT_437718#116312, ET_CODUTI_437720#116313, ET_CODVACA_437758#116314, ET_CODVAC_437757#116315, ET_COMMENT_437781#116316, ET_COMPRORE_437766#116317, ET_DATARR_437714#116318, ET_DATEXA_437706#116319, ET_DATFIN_437769#116320, ET_DATFVU_437741#116321, ET_DATMAJ_437719#116322, ET_DURAPR_437713#116323, ET_DURAVA_437711#116324, ET_DURPEN_437712#116325, ET_DURTOT_437710#116326, ET_EXAACC_437697#116327, ET_EXACOT_437761#116328, ET_FHIRID_437771#116329, ET_FLNOCOT_437762#116330, ET_FLPLAN_437734#116331, ET_FLTBDI_437739#116332, ET_HEUAPP_437755#116333, ET_HEUARR_437715#116334, ET_HEUD_E_437716#116335, ET_HEUEXA_437707#116336, ET_HEUFIN_437709#116337, ET_HEUFVU_437742#116338, ET_HEUF_E_437717#116339, ET_HEUSAL_437708#116340, ET_INCIDENCE_437750#116341, ET_LATER_437748#116342, ET_LIBEXA_437698#116343, ET_MEDNUC_437738#116344, ET_MODAL_AET_437764#116345, ET_M_AM_I_437704#116346, ET_NB_FIC_437774#116347, ET_NB_IMG_KEY_437775#116348, ET_NB_SER_437773#116349, ET_NOSEQ_437768#116350, ET_NUMDEM_437694#116351, ET_NUMDOS_437693#116352, ET_NUMEXA_437692#116353, ET_NUMEXA_ORI_437760#116354, ET_NUMGRP_437726#116355, ET_NUMORDSEANCE_437779#116356, ET_NUMORD_437752#116357, ET_NUMPDT_437751#116358, ET_NUMPRORE_437765#116359, ET_NUMRESA_437770#116360, ET_NUMRVX_437767#116361, ET_NUMSAL_437700#116362, ET_NUMSAT_437721#116363, ET_NUMSEANCE_437778#116364, ET_NUMTRT_437780#116365, ET_NUMXUS_437759#116366, ET_ORGANE_437754#116367, ET_ORIRDV_437756#116368, ET_POSITION_437749#116369, ET_REGANA_437772#116370, ET_SANSCR_437728#116371, ET_SECONDAIRE_437737#116372, ET_SOP_UID_437725#116373, ET_STABCD_437730#116374, ET_STA_PPS_437724#116375, ET_STU_ID_437723#116376, ET_STU_ID_ORI_437776#116377, ET_SUSPENS_437743#116378, ET_TRSTAT_437753#116379, ET_TYPBCD_437732#116380, ET_TYPESCLQ_437731#116381, ET_TYPEXA_437695#116382]
Condition : ((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NUMEXA_437692#116353)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_NUMEXA_437692#116353)), MARX) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NUMDOS_437693#116352)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_NUMDOS_437693#116352)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NUMDEM_437694#116351)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_NUMDEM_437694#116351)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_TYPEXA_437695#116382)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_TYPEXA_437695#116382)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_CODEXA_437696#116304)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_CODEXA_437696#116304)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_EXAACC_437697#116327)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_EXAACC_437697#116327)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_LIBEXA_437698#116343)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_LIBEXA_437698#116343)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_CODAPP_437699#116302)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_CODAPP_437699#116302)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NUMSAL_437700#116362)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_NUMSAL_437700#116362)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_CODPER_437701#116307)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_CODPER_437701#116307)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_CODRAD_437702#116311)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_CODRAD_437702#116311)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_CODPRO_437703#116309)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_CODPRO_437703#116309)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_M_AM_I_437704#116346)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_M_AM_I_437704#116346)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_AG_ON_437705#116298)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_AG_ON_437705#116298)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_DATEXA_437706#116319)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_DATEXA_437706#116319)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_HEUEXA_437707#116336)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_HEUEXA_437707#116336)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_HEUSAL_437708#116340)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_HEUSAL_437708#116340)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_HEUFIN_437709#116337)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_HEUFIN_437709#116337)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_DURTOT_437710#116326)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_DURTOT_437710#116326)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_DURAVA_437711#116324)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_DURAVA_437711#116324)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_DURPEN_437712#116325)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_DURPEN_437712#116325)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_DURAPR_437713#116323)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_DURAPR_437713#116323)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_DATARR_437714#116318)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_DATARR_437714#116318)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_HEUARR_437715#116334)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_HEUARR_437715#116334)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_HEUD_E_437716#116335)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_HEUD_E_437716#116335)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_HEUF_E_437717#116339)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_HEUF_E_437717#116339)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_CODSIT_437718#116312)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_CODSIT_437718#116312)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_DATMAJ_437719#116322)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_DATMAJ_437719#116322)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_CODUTI_437720#116313)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_CODUTI_437720#116313)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NUMSAT_437721#116363)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_NUMSAT_437721#116363)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_AFFECT_437722#116297)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_AFFECT_437722#116297)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_STU_ID_437723#116376)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_STU_ID_437723#116376)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_STA_PPS_437724#116375)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_STA_PPS_437724#116375)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_SOP_UID_437725#116373)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_SOP_UID_437725#116373)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NUMGRP_437726#116355)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_NUMGRP_437726#116355)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_CARRDV_437727#116301)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_CARRDV_437727#116301)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_SANSCR_437728#116371)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_SANSCR_437728#116371)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_CODATS_437729#116303)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_CODATS_437729#116303)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_STABCD_437730#116374)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_STABCD_437730#116374)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_TYPESCLQ_437731#116381)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_TYPESCLQ_437731#116381)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_TYPBCD_437732#116380)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_TYPBCD_437732#116380)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_CODPRX_437733#116310)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_CODPRX_437733#116310)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_FLPLAN_437734#116331)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_FLPLAN_437734#116331)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_AVAILABLE_437735#116300)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_AVAILABLE_437735#116300)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_AETITLE_437736#116296)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_AETITLE_437736#116296)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_SECONDAIRE_437737#116372)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_SECONDAIRE_437737#116372)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_MEDNUC_437738#116344)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_MEDNUC_437738#116344)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_FLTBDI_437739#116332)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_FLTBDI_437739#116332)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_CODFVU_437740#116305)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_CODFVU_437740#116305)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_DATFVU_437741#116321)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_DATFVU_437741#116321)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_HEUFVU_437742#116338)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_HEUFVU_437742#116338)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_SUSPENS_437743#116378)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_SUSPENS_437743#116378)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_ACADOS_437744#116292)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_ACADOS_437744#116292)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_ACAPUB_437745#116295)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_ACAPUB_437745#116295)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_ACAMED_437746#116294)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_ACAMED_437746#116294)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_ACALIB_437747#116293)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_ACALIB_437747#116293)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_LATER_437748#116342)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_LATER_437748#116342)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_POSITION_437749#116369)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_POSITION_437749#116369)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_INCIDENCE_437750#116341)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_INCIDENCE_437750#116341)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NUMPDT_437751#116358)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_NUMPDT_437751#116358)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NUMORD_437752#116357)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_NUMORD_437752#116357)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_TRSTAT_437753#116379)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_TRSTAT_437753#116379)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_ORGANE_437754#116367)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_ORGANE_437754#116367)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_HEUAPP_437755#116333)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_HEUAPP_437755#116333)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_ORIRDV_437756#116368)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_ORIRDV_437756#116368)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_CODVAC_437757#116315)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_CODVAC_437757#116315)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_CODVACA_437758#116314)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_CODVACA_437758#116314)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NUMXUS_437759#116366)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_NUMXUS_437759#116366)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NUMEXA_ORI_437760#116354)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_NUMEXA_ORI_437760#116354)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_EXACOT_437761#116328)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_EXACOT_437761#116328)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_FLNOCOT_437762#116330)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_FLNOCOT_437762#116330)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_ALARMES_437763#116299)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_ALARMES_437763#116299)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_MODAL_AET_437764#116345)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_MODAL_AET_437764#116345)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NUMPRORE_437765#116359)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_NUMPRORE_437765#116359)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_COMPRORE_437766#116317)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_COMPRORE_437766#116317)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NUMRVX_437767#116361)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_NUMRVX_437767#116361)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NOSEQ_437768#116350)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_NOSEQ_437768#116350)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_DATFIN_437769#116320)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_DATFIN_437769#116320)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NUMRESA_437770#116360)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_NUMRESA_437770#116360)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_FHIRID_437771#116329)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_FHIRID_437771#116329)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_REGANA_437772#116370)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_REGANA_437772#116370)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NB_SER_437773#116349)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_NB_SER_437773#116349)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NB_FIC_437774#116347)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_NB_FIC_437774#116347)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NB_IMG_KEY_437775#116348)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_NB_IMG_KEY_437775#116348)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_STU_ID_ORI_437776#116377)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_STU_ID_ORI_437776#116377)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_CODPER_PRORE_437777#116308)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_CODPER_PRORE_437777#116308)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NUMSEANCE_437778#116364)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_NUMSEANCE_437778#116364)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NUMORDSEANCE_437779#116356)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_NUMORDSEANCE_437779#116356)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NUMTRT_437780#116365)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_NUMTRT_437780#116365)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_COMMENT_437781#116316)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_COMMENT_437781#116316)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_CODLOINC_437782#116306)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_CODLOINC_437782#116306)), MARX) END)

(4) Project [codegen id : 1]
Output: []
Input [91]: [ET_ACADOS_437744#116292, ET_ACALIB_437747#116293, ET_ACAMED_437746#116294, ET_ACAPUB_437745#116295, ET_AETITLE_437736#116296, ET_AFFECT_437722#116297, ET_AG_ON_437705#116298, ET_ALARMES_437763#116299, ET_AVAILABLE_437735#116300, ET_CARRDV_437727#116301, ET_CODAPP_437699#116302, ET_CODATS_437729#116303, ET_CODEXA_437696#116304, ET_CODFVU_437740#116305, ET_CODLOINC_437782#116306, ET_CODPER_437701#116307, ET_CODPER_PRORE_437777#116308, ET_CODPRO_437703#116309, ET_CODPRX_437733#116310, ET_CODRAD_437702#116311, ET_CODSIT_437718#116312, ET_CODUTI_437720#116313, ET_CODVACA_437758#116314, ET_CODVAC_437757#116315, ET_COMMENT_437781#116316, ET_COMPRORE_437766#116317, ET_DATARR_437714#116318, ET_DATEXA_437706#116319, ET_DATFIN_437769#116320, ET_DATFVU_437741#116321, ET_DATMAJ_437719#116322, ET_DURAPR_437713#116323, ET_DURAVA_437711#116324, ET_DURPEN_437712#116325, ET_DURTOT_437710#116326, ET_EXAACC_437697#116327, ET_EXACOT_437761#116328, ET_FHIRID_437771#116329, ET_FLNOCOT_437762#116330, ET_FLPLAN_437734#116331, ET_FLTBDI_437739#116332, ET_HEUAPP_437755#116333, ET_HEUARR_437715#116334, ET_HEUD_E_437716#116335, ET_HEUEXA_437707#116336, ET_HEUFIN_437709#116337, ET_HEUFVU_437742#116338, ET_HEUF_E_437717#116339, ET_HEUSAL_437708#116340, ET_INCIDENCE_437750#116341, ET_LATER_437748#116342, ET_LIBEXA_437698#116343, ET_MEDNUC_437738#116344, ET_MODAL_AET_437764#116345, ET_M_AM_I_437704#116346, ET_NB_FIC_437774#116347, ET_NB_IMG_KEY_437775#116348, ET_NB_SER_437773#116349, ET_NOSEQ_437768#116350, ET_NUMDEM_437694#116351, ET_NUMDOS_437693#116352, ET_NUMEXA_437692#116353, ET_NUMEXA_ORI_437760#116354, ET_NUMGRP_437726#116355, ET_NUMORDSEANCE_437779#116356, ET_NUMORD_437752#116357, ET_NUMPDT_437751#116358, ET_NUMPRORE_437765#116359, ET_NUMRESA_437770#116360, ET_NUMRVX_437767#116361, ET_NUMSAL_437700#116362, ET_NUMSAT_437721#116363, ET_NUMSEANCE_437778#116364, ET_NUMTRT_437780#116365, ET_NUMXUS_437759#116366, ET_ORGANE_437754#116367, ET_ORIRDV_437756#116368, ET_POSITION_437749#116369, ET_REGANA_437772#116370, ET_SANSCR_437728#116371, ET_SECONDAIRE_437737#116372, ET_SOP_UID_437725#116373, ET_STABCD_437730#116374, ET_STA_PPS_437724#116375, ET_STU_ID_437723#116376, ET_STU_ID_ORI_437776#116377, ET_SUSPENS_437743#116378, ET_TRSTAT_437753#116379, ET_TYPBCD_437732#116380, ET_TYPESCLQ_437731#116381, ET_TYPEXA_437695#116382]

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

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

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

(8) HashAggregate [codegen id : 2]
Input [1]: [count#118934L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#117852L]
Results [1]: [count(1)#117852L AS COL_2280a8a1-7a67-47b8-acb2-8c5156ad8c56#117854L]

(9) Filter
Input [91]: [ET_ACADOS_437744#116292, ET_ACALIB_437747#116293, ET_ACAMED_437746#116294, ET_ACAPUB_437745#116295, ET_AETITLE_437736#116296, ET_AFFECT_437722#116297, ET_AG_ON_437705#116298, ET_ALARMES_437763#116299, ET_AVAILABLE_437735#116300, ET_CARRDV_437727#116301, ET_CODAPP_437699#116302, ET_CODATS_437729#116303, ET_CODEXA_437696#116304, ET_CODFVU_437740#116305, ET_CODLOINC_437782#116306, ET_CODPER_437701#116307, ET_CODPER_PRORE_437777#116308, ET_CODPRO_437703#116309, ET_CODPRX_437733#116310, ET_CODRAD_437702#116311, ET_CODSIT_437718#116312, ET_CODUTI_437720#116313, ET_CODVACA_437758#116314, ET_CODVAC_437757#116315, ET_COMMENT_437781#116316, ET_COMPRORE_437766#116317, ET_DATARR_437714#116318, ET_DATEXA_437706#116319, ET_DATFIN_437769#116320, ET_DATFVU_437741#116321, ET_DATMAJ_437719#116322, ET_DURAPR_437713#116323, ET_DURAVA_437711#116324, ET_DURPEN_437712#116325, ET_DURTOT_437710#116326, ET_EXAACC_437697#116327, ET_EXACOT_437761#116328, ET_FHIRID_437771#116329, ET_FLNOCOT_437762#116330, ET_FLPLAN_437734#116331, ET_FLTBDI_437739#116332, ET_HEUAPP_437755#116333, ET_HEUARR_437715#116334, ET_HEUD_E_437716#116335, ET_HEUEXA_437707#116336, ET_HEUFIN_437709#116337, ET_HEUFVU_437742#116338, ET_HEUF_E_437717#116339, ET_HEUSAL_437708#116340, ET_INCIDENCE_437750#116341, ET_LATER_437748#116342, ET_LIBEXA_437698#116343, ET_MEDNUC_437738#116344, ET_MODAL_AET_437764#116345, ET_M_AM_I_437704#116346, ET_NB_FIC_437774#116347, ET_NB_IMG_KEY_437775#116348, ET_NB_SER_437773#116349, ET_NOSEQ_437768#116350, ET_NUMDEM_437694#116351, ET_NUMDOS_437693#116352, ET_NUMEXA_437692#116353, ET_NUMEXA_ORI_437760#116354, ET_NUMGRP_437726#116355, ET_NUMORDSEANCE_437779#116356, ET_NUMORD_437752#116357, ET_NUMPDT_437751#116358, ET_NUMPRORE_437765#116359, ET_NUMRESA_437770#116360, ET_NUMRVX_437767#116361, ET_NUMSAL_437700#116362, ET_NUMSAT_437721#116363, ET_NUMSEANCE_437778#116364, ET_NUMTRT_437780#116365, ET_NUMXUS_437759#116366, ET_ORGANE_437754#116367, ET_ORIRDV_437756#116368, ET_POSITION_437749#116369, ET_REGANA_437772#116370, ET_SANSCR_437728#116371, ET_SECONDAIRE_437737#116372, ET_SOP_UID_437725#116373, ET_STABCD_437730#116374, ET_STA_PPS_437724#116375, ET_STU_ID_437723#116376, ET_STU_ID_ORI_437776#116377, ET_SUSPENS_437743#116378, ET_TRSTAT_437753#116379, ET_TYPBCD_437732#116380, ET_TYPESCLQ_437731#116381, ET_TYPEXA_437695#116382]
Condition : ((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NUMEXA_437692#116353)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_NUMEXA_437692#116353)), MARX) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NUMDOS_437693#116352)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_NUMDOS_437693#116352)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NUMDEM_437694#116351)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_NUMDEM_437694#116351)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_TYPEXA_437695#116382)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_TYPEXA_437695#116382)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_CODEXA_437696#116304)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_CODEXA_437696#116304)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_EXAACC_437697#116327)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_EXAACC_437697#116327)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_LIBEXA_437698#116343)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_LIBEXA_437698#116343)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_CODAPP_437699#116302)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_CODAPP_437699#116302)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NUMSAL_437700#116362)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_NUMSAL_437700#116362)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_CODPER_437701#116307)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_CODPER_437701#116307)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_CODRAD_437702#116311)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_CODRAD_437702#116311)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_CODPRO_437703#116309)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_CODPRO_437703#116309)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_M_AM_I_437704#116346)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_M_AM_I_437704#116346)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_AG_ON_437705#116298)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_AG_ON_437705#116298)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_DATEXA_437706#116319)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_DATEXA_437706#116319)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_HEUEXA_437707#116336)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_HEUEXA_437707#116336)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_HEUSAL_437708#116340)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_HEUSAL_437708#116340)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_HEUFIN_437709#116337)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_HEUFIN_437709#116337)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_DURTOT_437710#116326)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_DURTOT_437710#116326)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_DURAVA_437711#116324)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_DURAVA_437711#116324)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_DURPEN_437712#116325)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_DURPEN_437712#116325)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_DURAPR_437713#116323)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_DURAPR_437713#116323)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_DATARR_437714#116318)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_DATARR_437714#116318)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_HEUARR_437715#116334)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_HEUARR_437715#116334)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_HEUD_E_437716#116335)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_HEUD_E_437716#116335)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_HEUF_E_437717#116339)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_HEUF_E_437717#116339)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_CODSIT_437718#116312)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_CODSIT_437718#116312)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_DATMAJ_437719#116322)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_DATMAJ_437719#116322)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_CODUTI_437720#116313)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_CODUTI_437720#116313)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NUMSAT_437721#116363)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_NUMSAT_437721#116363)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_AFFECT_437722#116297)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_AFFECT_437722#116297)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_STU_ID_437723#116376)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_STU_ID_437723#116376)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_STA_PPS_437724#116375)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_STA_PPS_437724#116375)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_SOP_UID_437725#116373)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_SOP_UID_437725#116373)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NUMGRP_437726#116355)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_NUMGRP_437726#116355)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_CARRDV_437727#116301)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_CARRDV_437727#116301)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_SANSCR_437728#116371)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_SANSCR_437728#116371)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_CODATS_437729#116303)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_CODATS_437729#116303)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_STABCD_437730#116374)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_STABCD_437730#116374)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_TYPESCLQ_437731#116381)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_TYPESCLQ_437731#116381)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_TYPBCD_437732#116380)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_TYPBCD_437732#116380)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_CODPRX_437733#116310)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_CODPRX_437733#116310)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_FLPLAN_437734#116331)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_FLPLAN_437734#116331)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_AVAILABLE_437735#116300)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_AVAILABLE_437735#116300)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_AETITLE_437736#116296)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_AETITLE_437736#116296)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_SECONDAIRE_437737#116372)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_SECONDAIRE_437737#116372)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_MEDNUC_437738#116344)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_MEDNUC_437738#116344)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_FLTBDI_437739#116332)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_FLTBDI_437739#116332)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_CODFVU_437740#116305)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_CODFVU_437740#116305)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_DATFVU_437741#116321)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_DATFVU_437741#116321)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_HEUFVU_437742#116338)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_HEUFVU_437742#116338)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_SUSPENS_437743#116378)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_SUSPENS_437743#116378)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_ACADOS_437744#116292)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_ACADOS_437744#116292)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_ACAPUB_437745#116295)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_ACAPUB_437745#116295)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_ACAMED_437746#116294)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_ACAMED_437746#116294)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_ACALIB_437747#116293)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_ACALIB_437747#116293)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_LATER_437748#116342)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_LATER_437748#116342)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_POSITION_437749#116369)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_POSITION_437749#116369)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_INCIDENCE_437750#116341)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_INCIDENCE_437750#116341)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NUMPDT_437751#116358)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_NUMPDT_437751#116358)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NUMORD_437752#116357)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_NUMORD_437752#116357)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_TRSTAT_437753#116379)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_TRSTAT_437753#116379)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_ORGANE_437754#116367)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_ORGANE_437754#116367)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_HEUAPP_437755#116333)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_HEUAPP_437755#116333)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_ORIRDV_437756#116368)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_ORIRDV_437756#116368)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_CODVAC_437757#116315)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_CODVAC_437757#116315)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_CODVACA_437758#116314)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_CODVACA_437758#116314)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NUMXUS_437759#116366)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_NUMXUS_437759#116366)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NUMEXA_ORI_437760#116354)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_NUMEXA_ORI_437760#116354)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_EXACOT_437761#116328)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_EXACOT_437761#116328)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_FLNOCOT_437762#116330)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_FLNOCOT_437762#116330)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_ALARMES_437763#116299)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_ALARMES_437763#116299)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_MODAL_AET_437764#116345)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_MODAL_AET_437764#116345)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NUMPRORE_437765#116359)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_NUMPRORE_437765#116359)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_COMPRORE_437766#116317)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_COMPRORE_437766#116317)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NUMRVX_437767#116361)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_NUMRVX_437767#116361)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NOSEQ_437768#116350)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_NOSEQ_437768#116350)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_DATFIN_437769#116320)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_DATFIN_437769#116320)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NUMRESA_437770#116360)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_NUMRESA_437770#116360)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_FHIRID_437771#116329)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_FHIRID_437771#116329)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_REGANA_437772#116370)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_REGANA_437772#116370)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NB_SER_437773#116349)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_NB_SER_437773#116349)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NB_FIC_437774#116347)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_NB_FIC_437774#116347)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NB_IMG_KEY_437775#116348)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_NB_IMG_KEY_437775#116348)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_STU_ID_ORI_437776#116377)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_STU_ID_ORI_437776#116377)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_CODPER_PRORE_437777#116308)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_CODPER_PRORE_437777#116308)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NUMSEANCE_437778#116364)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_NUMSEANCE_437778#116364)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NUMORDSEANCE_437779#116356)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_NUMORDSEANCE_437779#116356)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_NUMTRT_437780#116365)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_NUMTRT_437780#116365)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_COMMENT_437781#116316)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_COMMENT_437781#116316)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ET_CODLOINC_437782#116306)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ET_CODLOINC_437782#116306)), MARX) END)

(10) Project
Output: []
Input [91]: [ET_ACADOS_437744#116292, ET_ACALIB_437747#116293, ET_ACAMED_437746#116294, ET_ACAPUB_437745#116295, ET_AETITLE_437736#116296, ET_AFFECT_437722#116297, ET_AG_ON_437705#116298, ET_ALARMES_437763#116299, ET_AVAILABLE_437735#116300, ET_CARRDV_437727#116301, ET_CODAPP_437699#116302, ET_CODATS_437729#116303, ET_CODEXA_437696#116304, ET_CODFVU_437740#116305, ET_CODLOINC_437782#116306, ET_CODPER_437701#116307, ET_CODPER_PRORE_437777#116308, ET_CODPRO_437703#116309, ET_CODPRX_437733#116310, ET_CODRAD_437702#116311, ET_CODSIT_437718#116312, ET_CODUTI_437720#116313, ET_CODVACA_437758#116314, ET_CODVAC_437757#116315, ET_COMMENT_437781#116316, ET_COMPRORE_437766#116317, ET_DATARR_437714#116318, ET_DATEXA_437706#116319, ET_DATFIN_437769#116320, ET_DATFVU_437741#116321, ET_DATMAJ_437719#116322, ET_DURAPR_437713#116323, ET_DURAVA_437711#116324, ET_DURPEN_437712#116325, ET_DURTOT_437710#116326, ET_EXAACC_437697#116327, ET_EXACOT_437761#116328, ET_FHIRID_437771#116329, ET_FLNOCOT_437762#116330, ET_FLPLAN_437734#116331, ET_FLTBDI_437739#116332, ET_HEUAPP_437755#116333, ET_HEUARR_437715#116334, ET_HEUD_E_437716#116335, ET_HEUEXA_437707#116336, ET_HEUFIN_437709#116337, ET_HEUFVU_437742#116338, ET_HEUF_E_437717#116339, ET_HEUSAL_437708#116340, ET_INCIDENCE_437750#116341, ET_LATER_437748#116342, ET_LIBEXA_437698#116343, ET_MEDNUC_437738#116344, ET_MODAL_AET_437764#116345, ET_M_AM_I_437704#116346, ET_NB_FIC_437774#116347, ET_NB_IMG_KEY_437775#116348, ET_NB_SER_437773#116349, ET_NOSEQ_437768#116350, ET_NUMDEM_437694#116351, ET_NUMDOS_437693#116352, ET_NUMEXA_437692#116353, ET_NUMEXA_ORI_437760#116354, ET_NUMGRP_437726#116355, ET_NUMORDSEANCE_437779#116356, ET_NUMORD_437752#116357, ET_NUMPDT_437751#116358, ET_NUMPRORE_437765#116359, ET_NUMRESA_437770#116360, ET_NUMRVX_437767#116361, ET_NUMSAL_437700#116362, ET_NUMSAT_437721#116363, ET_NUMSEANCE_437778#116364, ET_NUMTRT_437780#116365, ET_NUMXUS_437759#116366, ET_ORGANE_437754#116367, ET_ORIRDV_437756#116368, ET_POSITION_437749#116369, ET_REGANA_437772#116370, ET_SANSCR_437728#116371, ET_SECONDAIRE_437737#116372, ET_SOP_UID_437725#116373, ET_STABCD_437730#116374, ET_STA_PPS_437724#116375, ET_STU_ID_437723#116376, ET_STU_ID_ORI_437776#116377, ET_SUSPENS_437743#116378, ET_TRSTAT_437753#116379, ET_TYPBCD_437732#116380, ET_TYPESCLQ_437731#116381, ET_TYPEXA_437695#116382]

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

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

(13) HashAggregate
Input [1]: [count#118934L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#117852L]
Results [1]: [count(1)#117852L AS COL_2280a8a1-7a67-47b8-acb2-8c5156ad8c56#117854L]

(14) AdaptiveSparkPlan
Output [1]: [COL_2280a8a1-7a67-47b8-acb2-8c5156ad8c56#117854L]
Arguments: isFinalPlan=true

SQL / DataFrame Properties

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