hdh-spark-job - Details for Query 615

Submitted Time: 2026/10/21 21:32:58
Duration: 0.4 s
Succeeded Jobs: 553 554

Show the Stage ID and Task ID that corresponds to the max metric

digraph G { 0 [labelType="html" label=" AdaptiveSparkPlan "]; subgraph cluster1 { isCluster="true"; label="WholeStageCodegen (2)\n \nduration: 0 ms"; 2 [labelType="html" label="HashAggregate time in aggregation build: 0 ms number of output rows: 1"]; } 3 [labelType="html" label="Exchange shuffle records written: 1 local merged chunks fetched: 0 shuffle write time: 0 ms remote merged bytes read: 0.0 B local merged blocks fetched: 0 corrupt merged block chunks: 0 remote merged reqs duration: 0 ms remote merged blocks fetched: 0 records read: 1 local bytes read: 59.0 B fetch wait time: 0 ms remote bytes read: 0.0 B merged fetch fallback count: 0 local blocks read: 1 remote merged chunks fetched: 0 remote blocks read: 0 data size: 16.0 B local merged bytes read: 0.0 B number of partitions: 1 remote reqs duration: 0 ms remote bytes read to disk: 0.0 B shuffle bytes written: 59.0 B"]; subgraph cluster4 { isCluster="true"; label="WholeStageCodegen (1)\n \nduration: 9 ms"; 5 [labelType="html" label="HashAggregate time in aggregation build: 8 ms number of output rows: 1"]; 6 [labelType="html" label=" Project "]; 7 [labelType="html" label="Filter number of output rows: 5"]; 8 [labelType="html" label="ColumnarToRow number of output rows: 9 number of input batches: 1"]; } 9 [labelType="html" label="Scan parquet number of files read: 1 scan time: 8 ms metadata time: 0 ms size of files read: 23.8 KiB number of output rows: 9"]; 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=12188]

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

Project

Filter ((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(ST_NUMSTU_438260#127691)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_NUMSTU_438260#127691)), MARX) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_STU_ID_438261#127708)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_STU_ID_438261#127708)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_NUM_ID_438262#127692)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_NUM_ID_438262#127692)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_DATSTU_438263#127656)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_DATSTU_438263#127656)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_HEUSTU_438264#127666)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_HEUSTU_438264#127666)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_MODALI_438265#127674)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_MODALI_438265#127674)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_FABRIQ_438266#127659)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_FABRIQ_438266#127659)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_INSTIT_438267#127668)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_INSTIT_438267#127668)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_NOMDIC_438268#127682)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_NOMDIC_438268#127682)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_PNODIC_438269#127697)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_PNODIC_438269#127697)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_D_NDIC_438270#127658)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_D_NDIC_438270#127658)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_NB_SER_438271#127680)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_NB_SER_438271#127680)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_NB_ACQ_438272#127675)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_NB_ACQ_438272#127675)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_NB_IMA_438273#127678)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_NB_IMA_438273#127678)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_NB_FIC_438274#127676)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_NB_FIC_438274#127676)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_STUEFF_438275#127707)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_STUEFF_438275#127707)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_DATEFF_438276#127654)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_DATEFF_438276#127654)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_HEUEFF_438277#127664)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_HEUEFF_438277#127664)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_COMM_1_438278#127651)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_COMM_1_438278#127651)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_COMM_2_438279#127652)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_COMM_2_438279#127652)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_DROIT_438280#127657)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_DROIT_438280#127657)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_RAPPRO_438281#127699)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_RAPPRO_438281#127699)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_NUMDOS_438282#127685)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_NUMDOS_438282#127685)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_NUMDEM_438283#127684)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_NUMDEM_438283#127684)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_NUMPER_438284#127687)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_NUMPER_438284#127687)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_DATMAJ_438285#127655)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_DATMAJ_438285#127655)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_HEUMAJ_438286#127665)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_HEUMAJ_438286#127665)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_CODUTI_438287#127650)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_CODUTI_438287#127650)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_PAT_ID_438288#127695)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_PAT_ID_438288#127695)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_ACCNUM_438289#127643)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_ACCNUM_438289#127643)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_REFPHY_438290#127703)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_REFPHY_438290#127703)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_STUDSC_438291#127706)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_STUDSC_438291#127706)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_PATSEX_438292#127694)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_PATSEX_438292#127694)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_REAPHY_438293#127702)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_REAPHY_438293#127702)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_PERPHY_438294#127696)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_PERPHY_438294#127696)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_OPERAT_438295#127693)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_OPERAT_438295#127693)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_TAIFIC_438296#127711)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_TAIFIC_438296#127711)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_NUMEXA_438297#127686)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_NUMEXA_438297#127686)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_FLCD_438298#127660)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_FLCD_438298#127660)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_LIEU_438299#127672)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_LIEU_438299#127672)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_NUMCD_438300#127683)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_NUMCD_438300#127683)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_SVCDEM_438301#127710)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_SVCDEM_438301#127710)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_NB_SER_H_438302#127681)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_NB_SER_H_438302#127681)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_NB_FIC_H_438303#127677)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_NB_FIC_H_438303#127677)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_NB_IMA_H_438304#127679)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_NB_IMA_H_438304#127679)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_TAIFIC_H_438305#127712)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_TAIFIC_H_438305#127712)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_LOCKED_438306#127673)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_LOCKED_438306#127673)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_FLMANU_438307#127662)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_FLMANU_438307#127662)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_NUMPER_ORI_438308#127688)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_NUMPER_ORI_438308#127688)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_KEYWORD_438309#127671)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_KEYWORD_438309#127671)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_READ_438310#127701)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_READ_438310#127701)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_URGEN_438311#127715)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_URGEN_438311#127715)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_STA_PPS_438312#127705)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_STA_PPS_438312#127705)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_SOP_UID_438313#127704)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_SOP_UID_438313#127704)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_CODCLI_438314#127647)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_CODCLI_438314#127647)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_CODSIT_438315#127649)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_CODSIT_438315#127649)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_INS_438316#127669)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_INS_438316#127669)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_CACHE_438317#127645)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_CACHE_438317#127645)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_INS_OID_438318#127670)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_INS_OID_438318#127670)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_HIDDEN_438319#127667)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_HIDDEN_438319#127667)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_RAPPRO_MANU_438320#127700)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_RAPPRO_MANU_438320#127700)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_CODSER_438321#127648)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_CODSER_438321#127648)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_ADM_ID_438322#127644)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_ADM_ID_438322#127644)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_FLDCD_438323#127661)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_FLDCD_438323#127661)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_TAILLE_438324#127713)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_TAILLE_438324#127713)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_POIDS_438325#127698)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_POIDS_438325#127698)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_CODCHK_438326#127646)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_CODCHK_438326#127646)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_DATCHK_438327#127653)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_DATCHK_438327#127653)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_HEUCHK_438328#127663)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_HEUCHK_438328#127663)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_TYPNAT_438329#127714)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_TYPNAT_438329#127714)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_NUMPER_SEC_438330#127690)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_NUMPER_SEC_438330#127690)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_NUMPER_ORI_S_438331#127689)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_NUMPER_ORI_S_438331#127689)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_STU_ID_ORI_438332#127709)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_STU_ID_ORI_438332#127709)), MARX) END)

ColumnarToRow

WholeStageCodegen (1)

FileScan parquet [ST_ACCNUM_438289#127643,ST_ADM_ID_438322#127644,ST_CACHE_438317#127645,ST_CODCHK_438326#127646,ST_CODCLI_438314#127647,ST_CODSER_438321#127648,ST_CODSIT_438315#127649,ST_CODUTI_438287#127650,ST_COMM_1_438278#127651,ST_COMM_2_438279#127652,ST_DATCHK_438327#127653,ST_DATEFF_438276#127654,ST_DATMAJ_438285#127655,ST_DATSTU_438263#127656,ST_DROIT_438280#127657,ST_D_NDIC_438270#127658,ST_FABRIQ_438266#127659,ST_FLCD_438298#127660,ST_FLDCD_438323#127661,ST_FLMANU_438307#127662,ST_HEUCHK_438328#127663,ST_HEUEFF_438277#127664,ST_HEUMAJ_438286#127665,ST_HEUSTU_438264#127666,... 49 more fields] Batched: true, DataFilters: [((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contain..., Format: Parquet, Location: InMemoryFileIndex(1 paths)[file:/data/output/cache/parquet/uet/H_STUDY_438259], PartitionFilters: [], PushedFilters: [], ReadSchema: struct<ST_ACCNUM_438289:string,ST_ADM_ID_438322:string,ST_CACHE_438317:string,ST_CODCHK_438326:st...

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 [73]: [ST_ACCNUM_438289#127643, ST_ADM_ID_438322#127644, ST_CACHE_438317#127645, ST_CODCHK_438326#127646, ST_CODCLI_438314#127647, ST_CODSER_438321#127648, ST_CODSIT_438315#127649, ST_CODUTI_438287#127650, ST_COMM_1_438278#127651, ST_COMM_2_438279#127652, ST_DATCHK_438327#127653, ST_DATEFF_438276#127654, ST_DATMAJ_438285#127655, ST_DATSTU_438263#127656, ST_DROIT_438280#127657, ST_D_NDIC_438270#127658, ST_FABRIQ_438266#127659, ST_FLCD_438298#127660, ST_FLDCD_438323#127661, ST_FLMANU_438307#127662, ST_HEUCHK_438328#127663, ST_HEUEFF_438277#127664, ST_HEUMAJ_438286#127665, ST_HEUSTU_438264#127666, ST_HIDDEN_438319#127667, ST_INSTIT_438267#127668, ST_INS_438316#127669, ST_INS_OID_438318#127670, ST_KEYWORD_438309#127671, ST_LIEU_438299#127672, ST_LOCKED_438306#127673, ST_MODALI_438265#127674, ST_NB_ACQ_438272#127675, ST_NB_FIC_438274#127676, ST_NB_FIC_H_438303#127677, ST_NB_IMA_438273#127678, ST_NB_IMA_H_438304#127679, ST_NB_SER_438271#127680, ST_NB_SER_H_438302#127681, ST_NOMDIC_438268#127682, ST_NUMCD_438300#127683, ST_NUMDEM_438283#127684, ST_NUMDOS_438282#127685, ST_NUMEXA_438297#127686, ST_NUMPER_438284#127687, ST_NUMPER_ORI_438308#127688, ST_NUMPER_ORI_S_438331#127689, ST_NUMPER_SEC_438330#127690, ST_NUMSTU_438260#127691, ST_NUM_ID_438262#127692, ST_OPERAT_438295#127693, ST_PATSEX_438292#127694, ST_PAT_ID_438288#127695, ST_PERPHY_438294#127696, ST_PNODIC_438269#127697, ST_POIDS_438325#127698, ST_RAPPRO_438281#127699, ST_RAPPRO_MANU_438320#127700, ST_READ_438310#127701, ST_REAPHY_438293#127702, ST_REFPHY_438290#127703, ST_SOP_UID_438313#127704, ST_STA_PPS_438312#127705, ST_STUDSC_438291#127706, ST_STUEFF_438275#127707, ST_STU_ID_438261#127708, ST_STU_ID_ORI_438332#127709, ST_SVCDEM_438301#127710, ST_TAIFIC_438296#127711, ST_TAIFIC_H_438305#127712, ST_TAILLE_438324#127713, ST_TYPNAT_438329#127714, ST_URGEN_438311#127715]
Batched: true
Location: InMemoryFileIndex [file:/data/output/cache/parquet/uet/H_STUDY_438259]
ReadSchema: struct<ST_ACCNUM_438289:string,ST_ADM_ID_438322:string,ST_CACHE_438317:string,ST_CODCHK_438326:string,ST_CODCLI_438314:string,ST_CODSER_438321:string,ST_CODSIT_438315:string,ST_CODUTI_438287:string,ST_COMM_1_438278:string,ST_COMM_2_438279:string,ST_DATCHK_438327:string,ST_DATEFF_438276:string,ST_DATMAJ_438285:string,ST_DATSTU_438263:string,ST_DROIT_438280:string,ST_D_NDIC_438270:string,ST_FABRIQ_438266:string,ST_FLCD_438298:string,ST_FLDCD_438323:string,ST_FLMANU_438307:string,ST_HEUCHK_438328:string,ST_HEUEFF_438277:string,ST_HEUMAJ_438286:string,ST_HEUSTU_438264:string,ST_HIDDEN_438319:string,ST_INSTIT_438267:string,ST_INS_438316:string,ST_INS_OID_438318:string,ST_KEYWORD_438309:string,ST_LIEU_438299:string,ST_LOCKED_438306:string,ST_MODALI_438265:string,ST_NB_ACQ_438272:string,ST_NB_FIC_438274:string,ST_NB_FIC_H_438303:string,ST_NB_IMA_438273:string,ST_NB_IMA_H_438304:string,ST_NB_SER_438271:string,ST_NB_SER_H_438302:string,ST_NOMDIC_438268:string,ST_NUMCD_438300:string,ST_NUMDEM_438283:string,ST_NUMDOS_438282:string,ST_NUMEXA_438297:string,ST_NUMPER_438284:string,ST_NUMPER_ORI_438308:string,ST_NUMPER_ORI_S_438331:string,ST_NUMPER_SEC_438330:string,ST_NUMSTU_438260:string,ST_NUM_ID_438262:string,ST_OPERAT_438295:string,ST_PATSEX_438292:string,ST_PAT_ID_438288:string,ST_PERPHY_438294:string,ST_PNODIC_438269:string,ST_POIDS_438325:string,ST_RAPPRO_438281:string,ST_RAPPRO_MANU_438320:string,ST_READ_438310:string,ST_REAPHY_438293:string,ST_REFPHY_438290:string,ST_SOP_UID_438313:string,ST_STA_PPS_438312:string,ST_STUDSC_438291:string,ST_STUEFF_438275:string,ST_STU_ID_438261:string,ST_STU_ID_ORI_438332:string,ST_SVCDEM_438301:string,ST_TAIFIC_438296:string,ST_TAIFIC_H_438305:string,ST_TAILLE_438324:string,ST_TYPNAT_438329:string,ST_URGEN_438311:string>

(2) ColumnarToRow [codegen id : 1]
Input [73]: [ST_ACCNUM_438289#127643, ST_ADM_ID_438322#127644, ST_CACHE_438317#127645, ST_CODCHK_438326#127646, ST_CODCLI_438314#127647, ST_CODSER_438321#127648, ST_CODSIT_438315#127649, ST_CODUTI_438287#127650, ST_COMM_1_438278#127651, ST_COMM_2_438279#127652, ST_DATCHK_438327#127653, ST_DATEFF_438276#127654, ST_DATMAJ_438285#127655, ST_DATSTU_438263#127656, ST_DROIT_438280#127657, ST_D_NDIC_438270#127658, ST_FABRIQ_438266#127659, ST_FLCD_438298#127660, ST_FLDCD_438323#127661, ST_FLMANU_438307#127662, ST_HEUCHK_438328#127663, ST_HEUEFF_438277#127664, ST_HEUMAJ_438286#127665, ST_HEUSTU_438264#127666, ST_HIDDEN_438319#127667, ST_INSTIT_438267#127668, ST_INS_438316#127669, ST_INS_OID_438318#127670, ST_KEYWORD_438309#127671, ST_LIEU_438299#127672, ST_LOCKED_438306#127673, ST_MODALI_438265#127674, ST_NB_ACQ_438272#127675, ST_NB_FIC_438274#127676, ST_NB_FIC_H_438303#127677, ST_NB_IMA_438273#127678, ST_NB_IMA_H_438304#127679, ST_NB_SER_438271#127680, ST_NB_SER_H_438302#127681, ST_NOMDIC_438268#127682, ST_NUMCD_438300#127683, ST_NUMDEM_438283#127684, ST_NUMDOS_438282#127685, ST_NUMEXA_438297#127686, ST_NUMPER_438284#127687, ST_NUMPER_ORI_438308#127688, ST_NUMPER_ORI_S_438331#127689, ST_NUMPER_SEC_438330#127690, ST_NUMSTU_438260#127691, ST_NUM_ID_438262#127692, ST_OPERAT_438295#127693, ST_PATSEX_438292#127694, ST_PAT_ID_438288#127695, ST_PERPHY_438294#127696, ST_PNODIC_438269#127697, ST_POIDS_438325#127698, ST_RAPPRO_438281#127699, ST_RAPPRO_MANU_438320#127700, ST_READ_438310#127701, ST_REAPHY_438293#127702, ST_REFPHY_438290#127703, ST_SOP_UID_438313#127704, ST_STA_PPS_438312#127705, ST_STUDSC_438291#127706, ST_STUEFF_438275#127707, ST_STU_ID_438261#127708, ST_STU_ID_ORI_438332#127709, ST_SVCDEM_438301#127710, ST_TAIFIC_438296#127711, ST_TAIFIC_H_438305#127712, ST_TAILLE_438324#127713, ST_TYPNAT_438329#127714, ST_URGEN_438311#127715]

(3) Filter [codegen id : 1]
Input [73]: [ST_ACCNUM_438289#127643, ST_ADM_ID_438322#127644, ST_CACHE_438317#127645, ST_CODCHK_438326#127646, ST_CODCLI_438314#127647, ST_CODSER_438321#127648, ST_CODSIT_438315#127649, ST_CODUTI_438287#127650, ST_COMM_1_438278#127651, ST_COMM_2_438279#127652, ST_DATCHK_438327#127653, ST_DATEFF_438276#127654, ST_DATMAJ_438285#127655, ST_DATSTU_438263#127656, ST_DROIT_438280#127657, ST_D_NDIC_438270#127658, ST_FABRIQ_438266#127659, ST_FLCD_438298#127660, ST_FLDCD_438323#127661, ST_FLMANU_438307#127662, ST_HEUCHK_438328#127663, ST_HEUEFF_438277#127664, ST_HEUMAJ_438286#127665, ST_HEUSTU_438264#127666, ST_HIDDEN_438319#127667, ST_INSTIT_438267#127668, ST_INS_438316#127669, ST_INS_OID_438318#127670, ST_KEYWORD_438309#127671, ST_LIEU_438299#127672, ST_LOCKED_438306#127673, ST_MODALI_438265#127674, ST_NB_ACQ_438272#127675, ST_NB_FIC_438274#127676, ST_NB_FIC_H_438303#127677, ST_NB_IMA_438273#127678, ST_NB_IMA_H_438304#127679, ST_NB_SER_438271#127680, ST_NB_SER_H_438302#127681, ST_NOMDIC_438268#127682, ST_NUMCD_438300#127683, ST_NUMDEM_438283#127684, ST_NUMDOS_438282#127685, ST_NUMEXA_438297#127686, ST_NUMPER_438284#127687, ST_NUMPER_ORI_438308#127688, ST_NUMPER_ORI_S_438331#127689, ST_NUMPER_SEC_438330#127690, ST_NUMSTU_438260#127691, ST_NUM_ID_438262#127692, ST_OPERAT_438295#127693, ST_PATSEX_438292#127694, ST_PAT_ID_438288#127695, ST_PERPHY_438294#127696, ST_PNODIC_438269#127697, ST_POIDS_438325#127698, ST_RAPPRO_438281#127699, ST_RAPPRO_MANU_438320#127700, ST_READ_438310#127701, ST_REAPHY_438293#127702, ST_REFPHY_438290#127703, ST_SOP_UID_438313#127704, ST_STA_PPS_438312#127705, ST_STUDSC_438291#127706, ST_STUEFF_438275#127707, ST_STU_ID_438261#127708, ST_STU_ID_ORI_438332#127709, ST_SVCDEM_438301#127710, ST_TAIFIC_438296#127711, ST_TAIFIC_H_438305#127712, ST_TAILLE_438324#127713, ST_TYPNAT_438329#127714, ST_URGEN_438311#127715]
Condition : ((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(ST_NUMSTU_438260#127691)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_NUMSTU_438260#127691)), MARX) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_STU_ID_438261#127708)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_STU_ID_438261#127708)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_NUM_ID_438262#127692)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_NUM_ID_438262#127692)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_DATSTU_438263#127656)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_DATSTU_438263#127656)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_HEUSTU_438264#127666)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_HEUSTU_438264#127666)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_MODALI_438265#127674)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_MODALI_438265#127674)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_FABRIQ_438266#127659)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_FABRIQ_438266#127659)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_INSTIT_438267#127668)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_INSTIT_438267#127668)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_NOMDIC_438268#127682)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_NOMDIC_438268#127682)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_PNODIC_438269#127697)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_PNODIC_438269#127697)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_D_NDIC_438270#127658)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_D_NDIC_438270#127658)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_NB_SER_438271#127680)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_NB_SER_438271#127680)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_NB_ACQ_438272#127675)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_NB_ACQ_438272#127675)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_NB_IMA_438273#127678)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_NB_IMA_438273#127678)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_NB_FIC_438274#127676)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_NB_FIC_438274#127676)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_STUEFF_438275#127707)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_STUEFF_438275#127707)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_DATEFF_438276#127654)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_DATEFF_438276#127654)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_HEUEFF_438277#127664)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_HEUEFF_438277#127664)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_COMM_1_438278#127651)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_COMM_1_438278#127651)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_COMM_2_438279#127652)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_COMM_2_438279#127652)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_DROIT_438280#127657)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_DROIT_438280#127657)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_RAPPRO_438281#127699)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_RAPPRO_438281#127699)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_NUMDOS_438282#127685)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_NUMDOS_438282#127685)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_NUMDEM_438283#127684)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_NUMDEM_438283#127684)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_NUMPER_438284#127687)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_NUMPER_438284#127687)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_DATMAJ_438285#127655)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_DATMAJ_438285#127655)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_HEUMAJ_438286#127665)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_HEUMAJ_438286#127665)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_CODUTI_438287#127650)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_CODUTI_438287#127650)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_PAT_ID_438288#127695)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_PAT_ID_438288#127695)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_ACCNUM_438289#127643)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_ACCNUM_438289#127643)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_REFPHY_438290#127703)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_REFPHY_438290#127703)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_STUDSC_438291#127706)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_STUDSC_438291#127706)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_PATSEX_438292#127694)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_PATSEX_438292#127694)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_REAPHY_438293#127702)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_REAPHY_438293#127702)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_PERPHY_438294#127696)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_PERPHY_438294#127696)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_OPERAT_438295#127693)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_OPERAT_438295#127693)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_TAIFIC_438296#127711)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_TAIFIC_438296#127711)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_NUMEXA_438297#127686)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_NUMEXA_438297#127686)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_FLCD_438298#127660)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_FLCD_438298#127660)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_LIEU_438299#127672)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_LIEU_438299#127672)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_NUMCD_438300#127683)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_NUMCD_438300#127683)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_SVCDEM_438301#127710)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_SVCDEM_438301#127710)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_NB_SER_H_438302#127681)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_NB_SER_H_438302#127681)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_NB_FIC_H_438303#127677)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_NB_FIC_H_438303#127677)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_NB_IMA_H_438304#127679)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_NB_IMA_H_438304#127679)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_TAIFIC_H_438305#127712)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_TAIFIC_H_438305#127712)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_LOCKED_438306#127673)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_LOCKED_438306#127673)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_FLMANU_438307#127662)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_FLMANU_438307#127662)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_NUMPER_ORI_438308#127688)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_NUMPER_ORI_438308#127688)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_KEYWORD_438309#127671)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_KEYWORD_438309#127671)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_READ_438310#127701)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_READ_438310#127701)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_URGEN_438311#127715)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_URGEN_438311#127715)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_STA_PPS_438312#127705)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_STA_PPS_438312#127705)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_SOP_UID_438313#127704)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_SOP_UID_438313#127704)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_CODCLI_438314#127647)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_CODCLI_438314#127647)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_CODSIT_438315#127649)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_CODSIT_438315#127649)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_INS_438316#127669)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_INS_438316#127669)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_CACHE_438317#127645)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_CACHE_438317#127645)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_INS_OID_438318#127670)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_INS_OID_438318#127670)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_HIDDEN_438319#127667)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_HIDDEN_438319#127667)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_RAPPRO_MANU_438320#127700)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_RAPPRO_MANU_438320#127700)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_CODSER_438321#127648)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_CODSER_438321#127648)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_ADM_ID_438322#127644)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_ADM_ID_438322#127644)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_FLDCD_438323#127661)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_FLDCD_438323#127661)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_TAILLE_438324#127713)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_TAILLE_438324#127713)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_POIDS_438325#127698)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_POIDS_438325#127698)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_CODCHK_438326#127646)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_CODCHK_438326#127646)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_DATCHK_438327#127653)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_DATCHK_438327#127653)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_HEUCHK_438328#127663)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_HEUCHK_438328#127663)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_TYPNAT_438329#127714)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_TYPNAT_438329#127714)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_NUMPER_SEC_438330#127690)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_NUMPER_SEC_438330#127690)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_NUMPER_ORI_S_438331#127689)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_NUMPER_ORI_S_438331#127689)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_STU_ID_ORI_438332#127709)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_STU_ID_ORI_438332#127709)), MARX) END)

(4) Project [codegen id : 1]
Output: []
Input [73]: [ST_ACCNUM_438289#127643, ST_ADM_ID_438322#127644, ST_CACHE_438317#127645, ST_CODCHK_438326#127646, ST_CODCLI_438314#127647, ST_CODSER_438321#127648, ST_CODSIT_438315#127649, ST_CODUTI_438287#127650, ST_COMM_1_438278#127651, ST_COMM_2_438279#127652, ST_DATCHK_438327#127653, ST_DATEFF_438276#127654, ST_DATMAJ_438285#127655, ST_DATSTU_438263#127656, ST_DROIT_438280#127657, ST_D_NDIC_438270#127658, ST_FABRIQ_438266#127659, ST_FLCD_438298#127660, ST_FLDCD_438323#127661, ST_FLMANU_438307#127662, ST_HEUCHK_438328#127663, ST_HEUEFF_438277#127664, ST_HEUMAJ_438286#127665, ST_HEUSTU_438264#127666, ST_HIDDEN_438319#127667, ST_INSTIT_438267#127668, ST_INS_438316#127669, ST_INS_OID_438318#127670, ST_KEYWORD_438309#127671, ST_LIEU_438299#127672, ST_LOCKED_438306#127673, ST_MODALI_438265#127674, ST_NB_ACQ_438272#127675, ST_NB_FIC_438274#127676, ST_NB_FIC_H_438303#127677, ST_NB_IMA_438273#127678, ST_NB_IMA_H_438304#127679, ST_NB_SER_438271#127680, ST_NB_SER_H_438302#127681, ST_NOMDIC_438268#127682, ST_NUMCD_438300#127683, ST_NUMDEM_438283#127684, ST_NUMDOS_438282#127685, ST_NUMEXA_438297#127686, ST_NUMPER_438284#127687, ST_NUMPER_ORI_438308#127688, ST_NUMPER_ORI_S_438331#127689, ST_NUMPER_SEC_438330#127690, ST_NUMSTU_438260#127691, ST_NUM_ID_438262#127692, ST_OPERAT_438295#127693, ST_PATSEX_438292#127694, ST_PAT_ID_438288#127695, ST_PERPHY_438294#127696, ST_PNODIC_438269#127697, ST_POIDS_438325#127698, ST_RAPPRO_438281#127699, ST_RAPPRO_MANU_438320#127700, ST_READ_438310#127701, ST_REAPHY_438293#127702, ST_REFPHY_438290#127703, ST_SOP_UID_438313#127704, ST_STA_PPS_438312#127705, ST_STUDSC_438291#127706, ST_STUEFF_438275#127707, ST_STU_ID_438261#127708, ST_STU_ID_ORI_438332#127709, ST_SVCDEM_438301#127710, ST_TAIFIC_438296#127711, ST_TAIFIC_H_438305#127712, ST_TAILLE_438324#127713, ST_TYPNAT_438329#127714, ST_URGEN_438311#127715]

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

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

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

(8) HashAggregate [codegen id : 2]
Input [1]: [count#128304L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#128300L]
Results [1]: [count(1)#128300L AS count#128301L]

(9) Filter
Input [73]: [ST_ACCNUM_438289#127643, ST_ADM_ID_438322#127644, ST_CACHE_438317#127645, ST_CODCHK_438326#127646, ST_CODCLI_438314#127647, ST_CODSER_438321#127648, ST_CODSIT_438315#127649, ST_CODUTI_438287#127650, ST_COMM_1_438278#127651, ST_COMM_2_438279#127652, ST_DATCHK_438327#127653, ST_DATEFF_438276#127654, ST_DATMAJ_438285#127655, ST_DATSTU_438263#127656, ST_DROIT_438280#127657, ST_D_NDIC_438270#127658, ST_FABRIQ_438266#127659, ST_FLCD_438298#127660, ST_FLDCD_438323#127661, ST_FLMANU_438307#127662, ST_HEUCHK_438328#127663, ST_HEUEFF_438277#127664, ST_HEUMAJ_438286#127665, ST_HEUSTU_438264#127666, ST_HIDDEN_438319#127667, ST_INSTIT_438267#127668, ST_INS_438316#127669, ST_INS_OID_438318#127670, ST_KEYWORD_438309#127671, ST_LIEU_438299#127672, ST_LOCKED_438306#127673, ST_MODALI_438265#127674, ST_NB_ACQ_438272#127675, ST_NB_FIC_438274#127676, ST_NB_FIC_H_438303#127677, ST_NB_IMA_438273#127678, ST_NB_IMA_H_438304#127679, ST_NB_SER_438271#127680, ST_NB_SER_H_438302#127681, ST_NOMDIC_438268#127682, ST_NUMCD_438300#127683, ST_NUMDEM_438283#127684, ST_NUMDOS_438282#127685, ST_NUMEXA_438297#127686, ST_NUMPER_438284#127687, ST_NUMPER_ORI_438308#127688, ST_NUMPER_ORI_S_438331#127689, ST_NUMPER_SEC_438330#127690, ST_NUMSTU_438260#127691, ST_NUM_ID_438262#127692, ST_OPERAT_438295#127693, ST_PATSEX_438292#127694, ST_PAT_ID_438288#127695, ST_PERPHY_438294#127696, ST_PNODIC_438269#127697, ST_POIDS_438325#127698, ST_RAPPRO_438281#127699, ST_RAPPRO_MANU_438320#127700, ST_READ_438310#127701, ST_REAPHY_438293#127702, ST_REFPHY_438290#127703, ST_SOP_UID_438313#127704, ST_STA_PPS_438312#127705, ST_STUDSC_438291#127706, ST_STUEFF_438275#127707, ST_STU_ID_438261#127708, ST_STU_ID_ORI_438332#127709, ST_SVCDEM_438301#127710, ST_TAIFIC_438296#127711, ST_TAIFIC_H_438305#127712, ST_TAILLE_438324#127713, ST_TYPNAT_438329#127714, ST_URGEN_438311#127715]
Condition : ((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(ST_NUMSTU_438260#127691)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_NUMSTU_438260#127691)), MARX) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_STU_ID_438261#127708)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_STU_ID_438261#127708)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_NUM_ID_438262#127692)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_NUM_ID_438262#127692)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_DATSTU_438263#127656)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_DATSTU_438263#127656)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_HEUSTU_438264#127666)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_HEUSTU_438264#127666)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_MODALI_438265#127674)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_MODALI_438265#127674)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_FABRIQ_438266#127659)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_FABRIQ_438266#127659)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_INSTIT_438267#127668)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_INSTIT_438267#127668)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_NOMDIC_438268#127682)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_NOMDIC_438268#127682)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_PNODIC_438269#127697)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_PNODIC_438269#127697)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_D_NDIC_438270#127658)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_D_NDIC_438270#127658)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_NB_SER_438271#127680)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_NB_SER_438271#127680)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_NB_ACQ_438272#127675)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_NB_ACQ_438272#127675)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_NB_IMA_438273#127678)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_NB_IMA_438273#127678)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_NB_FIC_438274#127676)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_NB_FIC_438274#127676)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_STUEFF_438275#127707)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_STUEFF_438275#127707)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_DATEFF_438276#127654)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_DATEFF_438276#127654)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_HEUEFF_438277#127664)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_HEUEFF_438277#127664)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_COMM_1_438278#127651)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_COMM_1_438278#127651)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_COMM_2_438279#127652)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_COMM_2_438279#127652)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_DROIT_438280#127657)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_DROIT_438280#127657)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_RAPPRO_438281#127699)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_RAPPRO_438281#127699)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_NUMDOS_438282#127685)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_NUMDOS_438282#127685)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_NUMDEM_438283#127684)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_NUMDEM_438283#127684)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_NUMPER_438284#127687)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_NUMPER_438284#127687)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_DATMAJ_438285#127655)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_DATMAJ_438285#127655)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_HEUMAJ_438286#127665)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_HEUMAJ_438286#127665)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_CODUTI_438287#127650)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_CODUTI_438287#127650)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_PAT_ID_438288#127695)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_PAT_ID_438288#127695)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_ACCNUM_438289#127643)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_ACCNUM_438289#127643)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_REFPHY_438290#127703)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_REFPHY_438290#127703)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_STUDSC_438291#127706)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_STUDSC_438291#127706)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_PATSEX_438292#127694)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_PATSEX_438292#127694)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_REAPHY_438293#127702)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_REAPHY_438293#127702)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_PERPHY_438294#127696)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_PERPHY_438294#127696)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_OPERAT_438295#127693)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_OPERAT_438295#127693)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_TAIFIC_438296#127711)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_TAIFIC_438296#127711)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_NUMEXA_438297#127686)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_NUMEXA_438297#127686)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_FLCD_438298#127660)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_FLCD_438298#127660)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_LIEU_438299#127672)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_LIEU_438299#127672)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_NUMCD_438300#127683)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_NUMCD_438300#127683)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_SVCDEM_438301#127710)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_SVCDEM_438301#127710)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_NB_SER_H_438302#127681)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_NB_SER_H_438302#127681)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_NB_FIC_H_438303#127677)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_NB_FIC_H_438303#127677)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_NB_IMA_H_438304#127679)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_NB_IMA_H_438304#127679)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_TAIFIC_H_438305#127712)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_TAIFIC_H_438305#127712)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_LOCKED_438306#127673)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_LOCKED_438306#127673)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_FLMANU_438307#127662)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_FLMANU_438307#127662)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_NUMPER_ORI_438308#127688)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_NUMPER_ORI_438308#127688)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_KEYWORD_438309#127671)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_KEYWORD_438309#127671)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_READ_438310#127701)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_READ_438310#127701)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_URGEN_438311#127715)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_URGEN_438311#127715)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_STA_PPS_438312#127705)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_STA_PPS_438312#127705)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_SOP_UID_438313#127704)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_SOP_UID_438313#127704)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_CODCLI_438314#127647)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_CODCLI_438314#127647)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_CODSIT_438315#127649)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_CODSIT_438315#127649)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_INS_438316#127669)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_INS_438316#127669)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_CACHE_438317#127645)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_CACHE_438317#127645)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_INS_OID_438318#127670)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_INS_OID_438318#127670)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_HIDDEN_438319#127667)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_HIDDEN_438319#127667)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_RAPPRO_MANU_438320#127700)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_RAPPRO_MANU_438320#127700)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_CODSER_438321#127648)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_CODSER_438321#127648)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_ADM_ID_438322#127644)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_ADM_ID_438322#127644)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_FLDCD_438323#127661)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_FLDCD_438323#127661)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_TAILLE_438324#127713)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_TAILLE_438324#127713)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_POIDS_438325#127698)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_POIDS_438325#127698)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_CODCHK_438326#127646)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_CODCHK_438326#127646)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_DATCHK_438327#127653)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_DATCHK_438327#127653)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_HEUCHK_438328#127663)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_HEUCHK_438328#127663)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_TYPNAT_438329#127714)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_TYPNAT_438329#127714)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_NUMPER_SEC_438330#127690)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_NUMPER_SEC_438330#127690)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_NUMPER_ORI_S_438331#127689)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_NUMPER_ORI_S_438331#127689)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_STU_ID_ORI_438332#127709)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_STU_ID_ORI_438332#127709)), MARX) END)

(10) Project
Output: []
Input [73]: [ST_ACCNUM_438289#127643, ST_ADM_ID_438322#127644, ST_CACHE_438317#127645, ST_CODCHK_438326#127646, ST_CODCLI_438314#127647, ST_CODSER_438321#127648, ST_CODSIT_438315#127649, ST_CODUTI_438287#127650, ST_COMM_1_438278#127651, ST_COMM_2_438279#127652, ST_DATCHK_438327#127653, ST_DATEFF_438276#127654, ST_DATMAJ_438285#127655, ST_DATSTU_438263#127656, ST_DROIT_438280#127657, ST_D_NDIC_438270#127658, ST_FABRIQ_438266#127659, ST_FLCD_438298#127660, ST_FLDCD_438323#127661, ST_FLMANU_438307#127662, ST_HEUCHK_438328#127663, ST_HEUEFF_438277#127664, ST_HEUMAJ_438286#127665, ST_HEUSTU_438264#127666, ST_HIDDEN_438319#127667, ST_INSTIT_438267#127668, ST_INS_438316#127669, ST_INS_OID_438318#127670, ST_KEYWORD_438309#127671, ST_LIEU_438299#127672, ST_LOCKED_438306#127673, ST_MODALI_438265#127674, ST_NB_ACQ_438272#127675, ST_NB_FIC_438274#127676, ST_NB_FIC_H_438303#127677, ST_NB_IMA_438273#127678, ST_NB_IMA_H_438304#127679, ST_NB_SER_438271#127680, ST_NB_SER_H_438302#127681, ST_NOMDIC_438268#127682, ST_NUMCD_438300#127683, ST_NUMDEM_438283#127684, ST_NUMDOS_438282#127685, ST_NUMEXA_438297#127686, ST_NUMPER_438284#127687, ST_NUMPER_ORI_438308#127688, ST_NUMPER_ORI_S_438331#127689, ST_NUMPER_SEC_438330#127690, ST_NUMSTU_438260#127691, ST_NUM_ID_438262#127692, ST_OPERAT_438295#127693, ST_PATSEX_438292#127694, ST_PAT_ID_438288#127695, ST_PERPHY_438294#127696, ST_PNODIC_438269#127697, ST_POIDS_438325#127698, ST_RAPPRO_438281#127699, ST_RAPPRO_MANU_438320#127700, ST_READ_438310#127701, ST_REAPHY_438293#127702, ST_REFPHY_438290#127703, ST_SOP_UID_438313#127704, ST_STA_PPS_438312#127705, ST_STUDSC_438291#127706, ST_STUEFF_438275#127707, ST_STU_ID_438261#127708, ST_STU_ID_ORI_438332#127709, ST_SVCDEM_438301#127710, ST_TAIFIC_438296#127711, ST_TAIFIC_H_438305#127712, ST_TAILLE_438324#127713, ST_TYPNAT_438329#127714, ST_URGEN_438311#127715]

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

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

(13) HashAggregate
Input [1]: [count#128304L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#128300L]
Results [1]: [count(1)#128300L AS count#128301L]

(14) AdaptiveSparkPlan
Output [1]: [count#128301L]
Arguments: isFinalPlan=true

SQL / DataFrame Properties

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