hdh-spark-job - Details for Query 1337

Submitted Time: 2026/10/23 13:28:01
Duration: 4 s
Succeeded Jobs: 1340 1345

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: 2 local merged chunks fetched: 0 shuffle write time total (min, med, max (stageId: taskId)) 1 ms (0 ms, 0 ms, 0 ms (stage 1932.0: task 1686)) 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: 2 local bytes read: 112.0 B fetch wait time: 0 ms remote bytes read: 0.0 B merged fetch fallback count: 0 local blocks read: 2 remote merged chunks fetched: 0 remote blocks read: 0 data size total (min, med, max (stageId: taskId)) 32.0 B (16.0 B, 16.0 B, 16.0 B (stage 1932.0: task 1687)) 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 total (min, med, max (stageId: taskId)) 112.0 B (56.0 B, 56.0 B, 56.0 B (stage 1932.0: task 1687))"]; subgraph cluster4 { isCluster="true"; label="WholeStageCodegen (1)\n \nduration: total (min, med, max (stageId: taskId))\n22 ms (11 ms, 11 ms, 11 ms (stage 1932.0: task 1687))"; 5 [labelType="html" label="HashAggregate time in aggregation build total (min, med, max (stageId: taskId)) 20 ms (10 ms, 10 ms, 10 ms (stage 1932.0: task 1687)) number of output rows: 2"]; 6 [labelType="html" label=" Project "]; 7 [labelType="html" label="Filter number of output rows: 0"]; 8 [labelType="html" label="ColumnarToRow number of output rows: 18 number of input batches: 2"]; } 9 [labelType="html" label="Scan parquet number of files read: 2 scan time total (min, med, max (stageId: taskId)) 17 ms (8 ms, 9 ms, 9 ms (stage 1932.0: task 1687)) metadata time: 0 ms size of files read: 48.2 KiB number of output rows: 18"]; 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=35759]

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

Project

Filter (((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(ST_NUMSTU_438260#664686)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_NUMSTU_438260#664686)), MAIN) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_STU_ID_438261#664703)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_STU_ID_438261#664703)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_NUM_ID_438262#664687)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_NUM_ID_438262#664687)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_DATSTU_438263#664651)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_DATSTU_438263#664651)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_HEUSTU_438264#664661)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_HEUSTU_438264#664661)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_MODALI_438265#664669)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_MODALI_438265#664669)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_FABRIQ_438266#664654)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_FABRIQ_438266#664654)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_INSTIT_438267#664663)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_INSTIT_438267#664663)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_NOMDIC_438268#664677)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_NOMDIC_438268#664677)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_PNODIC_438269#664692)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_PNODIC_438269#664692)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_D_NDIC_438270#664653)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_D_NDIC_438270#664653)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_NB_SER_438271#664675)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_NB_SER_438271#664675)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_NB_ACQ_438272#664670)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_NB_ACQ_438272#664670)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_NB_IMA_438273#664673)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_NB_IMA_438273#664673)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_NB_FIC_438274#664671)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_NB_FIC_438274#664671)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_STUEFF_438275#664702)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_STUEFF_438275#664702)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_DATEFF_438276#664649)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_DATEFF_438276#664649)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_HEUEFF_438277#664659)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_HEUEFF_438277#664659)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_COMM_1_438278#664646)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_COMM_1_438278#664646)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_COMM_2_438279#664647)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_COMM_2_438279#664647)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_DROIT_438280#664652)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_DROIT_438280#664652)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_RAPPRO_438281#664694)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_RAPPRO_438281#664694)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_NUMDOS_438282#664680)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_NUMDOS_438282#664680)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_NUMDEM_438283#664679)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_NUMDEM_438283#664679)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_NUMPER_438284#664682)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_NUMPER_438284#664682)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_DATMAJ_438285#664650)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_DATMAJ_438285#664650)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_HEUMAJ_438286#664660)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_HEUMAJ_438286#664660)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_CODUTI_438287#664645)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_CODUTI_438287#664645)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_PAT_ID_438288#664690)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_PAT_ID_438288#664690)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_ACCNUM_438289#664638)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_ACCNUM_438289#664638)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_REFPHY_438290#664698)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_REFPHY_438290#664698)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_STUDSC_438291#664701)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_STUDSC_438291#664701)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_PATSEX_438292#664689)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_PATSEX_438292#664689)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_REAPHY_438293#664697)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_REAPHY_438293#664697)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_PERPHY_438294#664691)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_PERPHY_438294#664691)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_OPERAT_438295#664688)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_OPERAT_438295#664688)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_TAIFIC_438296#664706)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_TAIFIC_438296#664706)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_NUMEXA_438297#664681)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_NUMEXA_438297#664681)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_FLCD_438298#664655)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_FLCD_438298#664655)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_LIEU_438299#664667)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_LIEU_438299#664667)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_NUMCD_438300#664678)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_NUMCD_438300#664678)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_SVCDEM_438301#664705)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_SVCDEM_438301#664705)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_NB_SER_H_438302#664676)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_NB_SER_H_438302#664676)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_NB_FIC_H_438303#664672)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_NB_FIC_H_438303#664672)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_NB_IMA_H_438304#664674)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_NB_IMA_H_438304#664674)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_TAIFIC_H_438305#664707)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_TAIFIC_H_438305#664707)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_LOCKED_438306#664668)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_LOCKED_438306#664668)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_FLMANU_438307#664657)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_FLMANU_438307#664657)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_NUMPER_ORI_438308#664683)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_NUMPER_ORI_438308#664683)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_KEYWORD_438309#664666)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_KEYWORD_438309#664666)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_READ_438310#664696)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_READ_438310#664696)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_URGEN_438311#664710)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_URGEN_438311#664710)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_STA_PPS_438312#664700)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_STA_PPS_438312#664700)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_SOP_UID_438313#664699)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_SOP_UID_438313#664699)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_CODCLI_438314#664642)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_CODCLI_438314#664642)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_CODSIT_438315#664644)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_CODSIT_438315#664644)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_INS_438316#664664)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_INS_438316#664664)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_CACHE_438317#664640)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_CACHE_438317#664640)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_INS_OID_438318#664665)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_INS_OID_438318#664665)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_HIDDEN_438319#664662)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_HIDDEN_438319#664662)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_RAPPRO_MANU_438320#664695)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_RAPPRO_MANU_438320#664695)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_CODSER_438321#664643)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_CODSER_438321#664643)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_ADM_ID_438322#664639)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_ADM_ID_438322#664639)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_FLDCD_438323#664656)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_FLDCD_438323#664656)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_TAILLE_438324#664708)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_TAILLE_438324#664708)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_POIDS_438325#664693)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_POIDS_438325#664693)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_CODCHK_438326#664641)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_CODCHK_438326#664641)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_DATCHK_438327#664648)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_DATCHK_438327#664648)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_HEUCHK_438328#664658)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_HEUCHK_438328#664658)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_TYPNAT_438329#664709)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_TYPNAT_438329#664709)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_NUMPER_SEC_438330#664685)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_NUMPER_SEC_438330#664685)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_NUMPER_ORI_S_438331#664684)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_NUMPER_ORI_S_438331#664684)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_STU_ID_ORI_438332#664704)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_STU_ID_ORI_438332#664704)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ORIGINE_440154#664637)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ORIGINE_440154#664637)), MAIN) END)

ColumnarToRow

WholeStageCodegen (1)

FileScan parquet [ORIGINE_440154#664637,ST_ACCNUM_438289#664638,ST_ADM_ID_438322#664639,ST_CACHE_438317#664640,ST_CODCHK_438326#664641,ST_CODCLI_438314#664642,ST_CODSER_438321#664643,ST_CODSIT_438315#664644,ST_CODUTI_438287#664645,ST_COMM_1_438278#664646,ST_COMM_2_438279#664647,ST_DATCHK_438327#664648,ST_DATEFF_438276#664649,ST_DATMAJ_438285#664650,ST_DATSTU_438263#664651,ST_DROIT_438280#664652,ST_D_NDIC_438270#664653,ST_FABRIQ_438266#664654,ST_FLCD_438298#664655,ST_FLDCD_438323#664656,ST_FLMANU_438307#664657,ST_HEUCHK_438328#664658,ST_HEUEFF_438277#664659,ST_HEUMAJ_438286#664660,... 50 more fields] Batched: true, DataFilters: [(((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contai..., Format: Parquet, Location: InMemoryFileIndex(1 paths)[file:/data/output/cache/parquet/uet/H_STUDY_438259], PartitionFilters: [], PushedFilters: [], ReadSchema: struct<ORIGINE_440154:string,ST_ACCNUM_438289:string,ST_ADM_ID_438322:string,ST_CACHE_438317:stri...

Details

== Physical Plan ==
AdaptiveSparkPlan (14)
+- == Final Plan ==
   * HashAggregate (8)
   +- ShuffleQueryStage (7), Statistics(sizeInBytes=32.0 B, rowCount=2)
      +- 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 [74]: [ORIGINE_440154#664637, ST_ACCNUM_438289#664638, ST_ADM_ID_438322#664639, ST_CACHE_438317#664640, ST_CODCHK_438326#664641, ST_CODCLI_438314#664642, ST_CODSER_438321#664643, ST_CODSIT_438315#664644, ST_CODUTI_438287#664645, ST_COMM_1_438278#664646, ST_COMM_2_438279#664647, ST_DATCHK_438327#664648, ST_DATEFF_438276#664649, ST_DATMAJ_438285#664650, ST_DATSTU_438263#664651, ST_DROIT_438280#664652, ST_D_NDIC_438270#664653, ST_FABRIQ_438266#664654, ST_FLCD_438298#664655, ST_FLDCD_438323#664656, ST_FLMANU_438307#664657, ST_HEUCHK_438328#664658, ST_HEUEFF_438277#664659, ST_HEUMAJ_438286#664660, ST_HEUSTU_438264#664661, ST_HIDDEN_438319#664662, ST_INSTIT_438267#664663, ST_INS_438316#664664, ST_INS_OID_438318#664665, ST_KEYWORD_438309#664666, ST_LIEU_438299#664667, ST_LOCKED_438306#664668, ST_MODALI_438265#664669, ST_NB_ACQ_438272#664670, ST_NB_FIC_438274#664671, ST_NB_FIC_H_438303#664672, ST_NB_IMA_438273#664673, ST_NB_IMA_H_438304#664674, ST_NB_SER_438271#664675, ST_NB_SER_H_438302#664676, ST_NOMDIC_438268#664677, ST_NUMCD_438300#664678, ST_NUMDEM_438283#664679, ST_NUMDOS_438282#664680, ST_NUMEXA_438297#664681, ST_NUMPER_438284#664682, ST_NUMPER_ORI_438308#664683, ST_NUMPER_ORI_S_438331#664684, ST_NUMPER_SEC_438330#664685, ST_NUMSTU_438260#664686, ST_NUM_ID_438262#664687, ST_OPERAT_438295#664688, ST_PATSEX_438292#664689, ST_PAT_ID_438288#664690, ST_PERPHY_438294#664691, ST_PNODIC_438269#664692, ST_POIDS_438325#664693, ST_RAPPRO_438281#664694, ST_RAPPRO_MANU_438320#664695, ST_READ_438310#664696, ST_REAPHY_438293#664697, ST_REFPHY_438290#664698, ST_SOP_UID_438313#664699, ST_STA_PPS_438312#664700, ST_STUDSC_438291#664701, ST_STUEFF_438275#664702, ST_STU_ID_438261#664703, ST_STU_ID_ORI_438332#664704, ST_SVCDEM_438301#664705, ST_TAIFIC_438296#664706, ST_TAIFIC_H_438305#664707, ST_TAILLE_438324#664708, ST_TYPNAT_438329#664709, ST_URGEN_438311#664710]
Batched: true
Location: InMemoryFileIndex [file:/data/output/cache/parquet/uet/H_STUDY_438259]
ReadSchema: struct<ORIGINE_440154:string,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 [74]: [ORIGINE_440154#664637, ST_ACCNUM_438289#664638, ST_ADM_ID_438322#664639, ST_CACHE_438317#664640, ST_CODCHK_438326#664641, ST_CODCLI_438314#664642, ST_CODSER_438321#664643, ST_CODSIT_438315#664644, ST_CODUTI_438287#664645, ST_COMM_1_438278#664646, ST_COMM_2_438279#664647, ST_DATCHK_438327#664648, ST_DATEFF_438276#664649, ST_DATMAJ_438285#664650, ST_DATSTU_438263#664651, ST_DROIT_438280#664652, ST_D_NDIC_438270#664653, ST_FABRIQ_438266#664654, ST_FLCD_438298#664655, ST_FLDCD_438323#664656, ST_FLMANU_438307#664657, ST_HEUCHK_438328#664658, ST_HEUEFF_438277#664659, ST_HEUMAJ_438286#664660, ST_HEUSTU_438264#664661, ST_HIDDEN_438319#664662, ST_INSTIT_438267#664663, ST_INS_438316#664664, ST_INS_OID_438318#664665, ST_KEYWORD_438309#664666, ST_LIEU_438299#664667, ST_LOCKED_438306#664668, ST_MODALI_438265#664669, ST_NB_ACQ_438272#664670, ST_NB_FIC_438274#664671, ST_NB_FIC_H_438303#664672, ST_NB_IMA_438273#664673, ST_NB_IMA_H_438304#664674, ST_NB_SER_438271#664675, ST_NB_SER_H_438302#664676, ST_NOMDIC_438268#664677, ST_NUMCD_438300#664678, ST_NUMDEM_438283#664679, ST_NUMDOS_438282#664680, ST_NUMEXA_438297#664681, ST_NUMPER_438284#664682, ST_NUMPER_ORI_438308#664683, ST_NUMPER_ORI_S_438331#664684, ST_NUMPER_SEC_438330#664685, ST_NUMSTU_438260#664686, ST_NUM_ID_438262#664687, ST_OPERAT_438295#664688, ST_PATSEX_438292#664689, ST_PAT_ID_438288#664690, ST_PERPHY_438294#664691, ST_PNODIC_438269#664692, ST_POIDS_438325#664693, ST_RAPPRO_438281#664694, ST_RAPPRO_MANU_438320#664695, ST_READ_438310#664696, ST_REAPHY_438293#664697, ST_REFPHY_438290#664698, ST_SOP_UID_438313#664699, ST_STA_PPS_438312#664700, ST_STUDSC_438291#664701, ST_STUEFF_438275#664702, ST_STU_ID_438261#664703, ST_STU_ID_ORI_438332#664704, ST_SVCDEM_438301#664705, ST_TAIFIC_438296#664706, ST_TAIFIC_H_438305#664707, ST_TAILLE_438324#664708, ST_TYPNAT_438329#664709, ST_URGEN_438311#664710]

(3) Filter [codegen id : 1]
Input [74]: [ORIGINE_440154#664637, ST_ACCNUM_438289#664638, ST_ADM_ID_438322#664639, ST_CACHE_438317#664640, ST_CODCHK_438326#664641, ST_CODCLI_438314#664642, ST_CODSER_438321#664643, ST_CODSIT_438315#664644, ST_CODUTI_438287#664645, ST_COMM_1_438278#664646, ST_COMM_2_438279#664647, ST_DATCHK_438327#664648, ST_DATEFF_438276#664649, ST_DATMAJ_438285#664650, ST_DATSTU_438263#664651, ST_DROIT_438280#664652, ST_D_NDIC_438270#664653, ST_FABRIQ_438266#664654, ST_FLCD_438298#664655, ST_FLDCD_438323#664656, ST_FLMANU_438307#664657, ST_HEUCHK_438328#664658, ST_HEUEFF_438277#664659, ST_HEUMAJ_438286#664660, ST_HEUSTU_438264#664661, ST_HIDDEN_438319#664662, ST_INSTIT_438267#664663, ST_INS_438316#664664, ST_INS_OID_438318#664665, ST_KEYWORD_438309#664666, ST_LIEU_438299#664667, ST_LOCKED_438306#664668, ST_MODALI_438265#664669, ST_NB_ACQ_438272#664670, ST_NB_FIC_438274#664671, ST_NB_FIC_H_438303#664672, ST_NB_IMA_438273#664673, ST_NB_IMA_H_438304#664674, ST_NB_SER_438271#664675, ST_NB_SER_H_438302#664676, ST_NOMDIC_438268#664677, ST_NUMCD_438300#664678, ST_NUMDEM_438283#664679, ST_NUMDOS_438282#664680, ST_NUMEXA_438297#664681, ST_NUMPER_438284#664682, ST_NUMPER_ORI_438308#664683, ST_NUMPER_ORI_S_438331#664684, ST_NUMPER_SEC_438330#664685, ST_NUMSTU_438260#664686, ST_NUM_ID_438262#664687, ST_OPERAT_438295#664688, ST_PATSEX_438292#664689, ST_PAT_ID_438288#664690, ST_PERPHY_438294#664691, ST_PNODIC_438269#664692, ST_POIDS_438325#664693, ST_RAPPRO_438281#664694, ST_RAPPRO_MANU_438320#664695, ST_READ_438310#664696, ST_REAPHY_438293#664697, ST_REFPHY_438290#664698, ST_SOP_UID_438313#664699, ST_STA_PPS_438312#664700, ST_STUDSC_438291#664701, ST_STUEFF_438275#664702, ST_STU_ID_438261#664703, ST_STU_ID_ORI_438332#664704, ST_SVCDEM_438301#664705, ST_TAIFIC_438296#664706, ST_TAIFIC_H_438305#664707, ST_TAILLE_438324#664708, ST_TYPNAT_438329#664709, ST_URGEN_438311#664710]
Condition : (((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(ST_NUMSTU_438260#664686)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_NUMSTU_438260#664686)), MAIN) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_STU_ID_438261#664703)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_STU_ID_438261#664703)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_NUM_ID_438262#664687)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_NUM_ID_438262#664687)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_DATSTU_438263#664651)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_DATSTU_438263#664651)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_HEUSTU_438264#664661)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_HEUSTU_438264#664661)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_MODALI_438265#664669)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_MODALI_438265#664669)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_FABRIQ_438266#664654)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_FABRIQ_438266#664654)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_INSTIT_438267#664663)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_INSTIT_438267#664663)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_NOMDIC_438268#664677)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_NOMDIC_438268#664677)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_PNODIC_438269#664692)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_PNODIC_438269#664692)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_D_NDIC_438270#664653)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_D_NDIC_438270#664653)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_NB_SER_438271#664675)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_NB_SER_438271#664675)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_NB_ACQ_438272#664670)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_NB_ACQ_438272#664670)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_NB_IMA_438273#664673)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_NB_IMA_438273#664673)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_NB_FIC_438274#664671)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_NB_FIC_438274#664671)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_STUEFF_438275#664702)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_STUEFF_438275#664702)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_DATEFF_438276#664649)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_DATEFF_438276#664649)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_HEUEFF_438277#664659)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_HEUEFF_438277#664659)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_COMM_1_438278#664646)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_COMM_1_438278#664646)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_COMM_2_438279#664647)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_COMM_2_438279#664647)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_DROIT_438280#664652)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_DROIT_438280#664652)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_RAPPRO_438281#664694)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_RAPPRO_438281#664694)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_NUMDOS_438282#664680)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_NUMDOS_438282#664680)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_NUMDEM_438283#664679)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_NUMDEM_438283#664679)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_NUMPER_438284#664682)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_NUMPER_438284#664682)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_DATMAJ_438285#664650)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_DATMAJ_438285#664650)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_HEUMAJ_438286#664660)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_HEUMAJ_438286#664660)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_CODUTI_438287#664645)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_CODUTI_438287#664645)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_PAT_ID_438288#664690)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_PAT_ID_438288#664690)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_ACCNUM_438289#664638)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_ACCNUM_438289#664638)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_REFPHY_438290#664698)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_REFPHY_438290#664698)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_STUDSC_438291#664701)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_STUDSC_438291#664701)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_PATSEX_438292#664689)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_PATSEX_438292#664689)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_REAPHY_438293#664697)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_REAPHY_438293#664697)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_PERPHY_438294#664691)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_PERPHY_438294#664691)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_OPERAT_438295#664688)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_OPERAT_438295#664688)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_TAIFIC_438296#664706)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_TAIFIC_438296#664706)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_NUMEXA_438297#664681)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_NUMEXA_438297#664681)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_FLCD_438298#664655)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_FLCD_438298#664655)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_LIEU_438299#664667)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_LIEU_438299#664667)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_NUMCD_438300#664678)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_NUMCD_438300#664678)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_SVCDEM_438301#664705)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_SVCDEM_438301#664705)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_NB_SER_H_438302#664676)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_NB_SER_H_438302#664676)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_NB_FIC_H_438303#664672)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_NB_FIC_H_438303#664672)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_NB_IMA_H_438304#664674)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_NB_IMA_H_438304#664674)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_TAIFIC_H_438305#664707)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_TAIFIC_H_438305#664707)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_LOCKED_438306#664668)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_LOCKED_438306#664668)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_FLMANU_438307#664657)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_FLMANU_438307#664657)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_NUMPER_ORI_438308#664683)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_NUMPER_ORI_438308#664683)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_KEYWORD_438309#664666)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_KEYWORD_438309#664666)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_READ_438310#664696)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_READ_438310#664696)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_URGEN_438311#664710)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_URGEN_438311#664710)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_STA_PPS_438312#664700)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_STA_PPS_438312#664700)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_SOP_UID_438313#664699)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_SOP_UID_438313#664699)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_CODCLI_438314#664642)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_CODCLI_438314#664642)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_CODSIT_438315#664644)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_CODSIT_438315#664644)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_INS_438316#664664)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_INS_438316#664664)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_CACHE_438317#664640)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_CACHE_438317#664640)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_INS_OID_438318#664665)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_INS_OID_438318#664665)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_HIDDEN_438319#664662)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_HIDDEN_438319#664662)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_RAPPRO_MANU_438320#664695)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_RAPPRO_MANU_438320#664695)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_CODSER_438321#664643)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_CODSER_438321#664643)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_ADM_ID_438322#664639)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_ADM_ID_438322#664639)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_FLDCD_438323#664656)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_FLDCD_438323#664656)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_TAILLE_438324#664708)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_TAILLE_438324#664708)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_POIDS_438325#664693)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_POIDS_438325#664693)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_CODCHK_438326#664641)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_CODCHK_438326#664641)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_DATCHK_438327#664648)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_DATCHK_438327#664648)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_HEUCHK_438328#664658)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_HEUCHK_438328#664658)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_TYPNAT_438329#664709)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_TYPNAT_438329#664709)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_NUMPER_SEC_438330#664685)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_NUMPER_SEC_438330#664685)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_NUMPER_ORI_S_438331#664684)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_NUMPER_ORI_S_438331#664684)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_STU_ID_ORI_438332#664704)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_STU_ID_ORI_438332#664704)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ORIGINE_440154#664637)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ORIGINE_440154#664637)), MAIN) END)

(4) Project [codegen id : 1]
Output: []
Input [74]: [ORIGINE_440154#664637, ST_ACCNUM_438289#664638, ST_ADM_ID_438322#664639, ST_CACHE_438317#664640, ST_CODCHK_438326#664641, ST_CODCLI_438314#664642, ST_CODSER_438321#664643, ST_CODSIT_438315#664644, ST_CODUTI_438287#664645, ST_COMM_1_438278#664646, ST_COMM_2_438279#664647, ST_DATCHK_438327#664648, ST_DATEFF_438276#664649, ST_DATMAJ_438285#664650, ST_DATSTU_438263#664651, ST_DROIT_438280#664652, ST_D_NDIC_438270#664653, ST_FABRIQ_438266#664654, ST_FLCD_438298#664655, ST_FLDCD_438323#664656, ST_FLMANU_438307#664657, ST_HEUCHK_438328#664658, ST_HEUEFF_438277#664659, ST_HEUMAJ_438286#664660, ST_HEUSTU_438264#664661, ST_HIDDEN_438319#664662, ST_INSTIT_438267#664663, ST_INS_438316#664664, ST_INS_OID_438318#664665, ST_KEYWORD_438309#664666, ST_LIEU_438299#664667, ST_LOCKED_438306#664668, ST_MODALI_438265#664669, ST_NB_ACQ_438272#664670, ST_NB_FIC_438274#664671, ST_NB_FIC_H_438303#664672, ST_NB_IMA_438273#664673, ST_NB_IMA_H_438304#664674, ST_NB_SER_438271#664675, ST_NB_SER_H_438302#664676, ST_NOMDIC_438268#664677, ST_NUMCD_438300#664678, ST_NUMDEM_438283#664679, ST_NUMDOS_438282#664680, ST_NUMEXA_438297#664681, ST_NUMPER_438284#664682, ST_NUMPER_ORI_438308#664683, ST_NUMPER_ORI_S_438331#664684, ST_NUMPER_SEC_438330#664685, ST_NUMSTU_438260#664686, ST_NUM_ID_438262#664687, ST_OPERAT_438295#664688, ST_PATSEX_438292#664689, ST_PAT_ID_438288#664690, ST_PERPHY_438294#664691, ST_PNODIC_438269#664692, ST_POIDS_438325#664693, ST_RAPPRO_438281#664694, ST_RAPPRO_MANU_438320#664695, ST_READ_438310#664696, ST_REAPHY_438293#664697, ST_REFPHY_438290#664698, ST_SOP_UID_438313#664699, ST_STA_PPS_438312#664700, ST_STUDSC_438291#664701, ST_STUEFF_438275#664702, ST_STU_ID_438261#664703, ST_STU_ID_ORI_438332#664704, ST_SVCDEM_438301#664705, ST_TAIFIC_438296#664706, ST_TAIFIC_H_438305#664707, ST_TAILLE_438324#664708, ST_TYPNAT_438329#664709, ST_URGEN_438311#664710]

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

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

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

(8) HashAggregate [codegen id : 2]
Input [1]: [count#665311L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#665229L]
Results [1]: [count(1)#665229L AS COL_168cc58a-7e09-4e29-8ce2-09ddfdd78c7c#665231L]

(9) Filter
Input [74]: [ORIGINE_440154#664637, ST_ACCNUM_438289#664638, ST_ADM_ID_438322#664639, ST_CACHE_438317#664640, ST_CODCHK_438326#664641, ST_CODCLI_438314#664642, ST_CODSER_438321#664643, ST_CODSIT_438315#664644, ST_CODUTI_438287#664645, ST_COMM_1_438278#664646, ST_COMM_2_438279#664647, ST_DATCHK_438327#664648, ST_DATEFF_438276#664649, ST_DATMAJ_438285#664650, ST_DATSTU_438263#664651, ST_DROIT_438280#664652, ST_D_NDIC_438270#664653, ST_FABRIQ_438266#664654, ST_FLCD_438298#664655, ST_FLDCD_438323#664656, ST_FLMANU_438307#664657, ST_HEUCHK_438328#664658, ST_HEUEFF_438277#664659, ST_HEUMAJ_438286#664660, ST_HEUSTU_438264#664661, ST_HIDDEN_438319#664662, ST_INSTIT_438267#664663, ST_INS_438316#664664, ST_INS_OID_438318#664665, ST_KEYWORD_438309#664666, ST_LIEU_438299#664667, ST_LOCKED_438306#664668, ST_MODALI_438265#664669, ST_NB_ACQ_438272#664670, ST_NB_FIC_438274#664671, ST_NB_FIC_H_438303#664672, ST_NB_IMA_438273#664673, ST_NB_IMA_H_438304#664674, ST_NB_SER_438271#664675, ST_NB_SER_H_438302#664676, ST_NOMDIC_438268#664677, ST_NUMCD_438300#664678, ST_NUMDEM_438283#664679, ST_NUMDOS_438282#664680, ST_NUMEXA_438297#664681, ST_NUMPER_438284#664682, ST_NUMPER_ORI_438308#664683, ST_NUMPER_ORI_S_438331#664684, ST_NUMPER_SEC_438330#664685, ST_NUMSTU_438260#664686, ST_NUM_ID_438262#664687, ST_OPERAT_438295#664688, ST_PATSEX_438292#664689, ST_PAT_ID_438288#664690, ST_PERPHY_438294#664691, ST_PNODIC_438269#664692, ST_POIDS_438325#664693, ST_RAPPRO_438281#664694, ST_RAPPRO_MANU_438320#664695, ST_READ_438310#664696, ST_REAPHY_438293#664697, ST_REFPHY_438290#664698, ST_SOP_UID_438313#664699, ST_STA_PPS_438312#664700, ST_STUDSC_438291#664701, ST_STUEFF_438275#664702, ST_STU_ID_438261#664703, ST_STU_ID_ORI_438332#664704, ST_SVCDEM_438301#664705, ST_TAIFIC_438296#664706, ST_TAIFIC_H_438305#664707, ST_TAILLE_438324#664708, ST_TYPNAT_438329#664709, ST_URGEN_438311#664710]
Condition : (((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(ST_NUMSTU_438260#664686)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_NUMSTU_438260#664686)), MAIN) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_STU_ID_438261#664703)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_STU_ID_438261#664703)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_NUM_ID_438262#664687)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_NUM_ID_438262#664687)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_DATSTU_438263#664651)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_DATSTU_438263#664651)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_HEUSTU_438264#664661)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_HEUSTU_438264#664661)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_MODALI_438265#664669)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_MODALI_438265#664669)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_FABRIQ_438266#664654)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_FABRIQ_438266#664654)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_INSTIT_438267#664663)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_INSTIT_438267#664663)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_NOMDIC_438268#664677)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_NOMDIC_438268#664677)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_PNODIC_438269#664692)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_PNODIC_438269#664692)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_D_NDIC_438270#664653)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_D_NDIC_438270#664653)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_NB_SER_438271#664675)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_NB_SER_438271#664675)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_NB_ACQ_438272#664670)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_NB_ACQ_438272#664670)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_NB_IMA_438273#664673)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_NB_IMA_438273#664673)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_NB_FIC_438274#664671)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_NB_FIC_438274#664671)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_STUEFF_438275#664702)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_STUEFF_438275#664702)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_DATEFF_438276#664649)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_DATEFF_438276#664649)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_HEUEFF_438277#664659)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_HEUEFF_438277#664659)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_COMM_1_438278#664646)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_COMM_1_438278#664646)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_COMM_2_438279#664647)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_COMM_2_438279#664647)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_DROIT_438280#664652)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_DROIT_438280#664652)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_RAPPRO_438281#664694)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_RAPPRO_438281#664694)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_NUMDOS_438282#664680)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_NUMDOS_438282#664680)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_NUMDEM_438283#664679)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_NUMDEM_438283#664679)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_NUMPER_438284#664682)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_NUMPER_438284#664682)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_DATMAJ_438285#664650)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_DATMAJ_438285#664650)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_HEUMAJ_438286#664660)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_HEUMAJ_438286#664660)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_CODUTI_438287#664645)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_CODUTI_438287#664645)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_PAT_ID_438288#664690)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_PAT_ID_438288#664690)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_ACCNUM_438289#664638)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_ACCNUM_438289#664638)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_REFPHY_438290#664698)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_REFPHY_438290#664698)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_STUDSC_438291#664701)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_STUDSC_438291#664701)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_PATSEX_438292#664689)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_PATSEX_438292#664689)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_REAPHY_438293#664697)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_REAPHY_438293#664697)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_PERPHY_438294#664691)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_PERPHY_438294#664691)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_OPERAT_438295#664688)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_OPERAT_438295#664688)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_TAIFIC_438296#664706)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_TAIFIC_438296#664706)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_NUMEXA_438297#664681)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_NUMEXA_438297#664681)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_FLCD_438298#664655)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_FLCD_438298#664655)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_LIEU_438299#664667)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_LIEU_438299#664667)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_NUMCD_438300#664678)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_NUMCD_438300#664678)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_SVCDEM_438301#664705)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_SVCDEM_438301#664705)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_NB_SER_H_438302#664676)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_NB_SER_H_438302#664676)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_NB_FIC_H_438303#664672)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_NB_FIC_H_438303#664672)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_NB_IMA_H_438304#664674)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_NB_IMA_H_438304#664674)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_TAIFIC_H_438305#664707)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_TAIFIC_H_438305#664707)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_LOCKED_438306#664668)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_LOCKED_438306#664668)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_FLMANU_438307#664657)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_FLMANU_438307#664657)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_NUMPER_ORI_438308#664683)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_NUMPER_ORI_438308#664683)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_KEYWORD_438309#664666)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_KEYWORD_438309#664666)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_READ_438310#664696)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_READ_438310#664696)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_URGEN_438311#664710)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_URGEN_438311#664710)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_STA_PPS_438312#664700)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_STA_PPS_438312#664700)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_SOP_UID_438313#664699)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_SOP_UID_438313#664699)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_CODCLI_438314#664642)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_CODCLI_438314#664642)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_CODSIT_438315#664644)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_CODSIT_438315#664644)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_INS_438316#664664)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_INS_438316#664664)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_CACHE_438317#664640)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_CACHE_438317#664640)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_INS_OID_438318#664665)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_INS_OID_438318#664665)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_HIDDEN_438319#664662)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_HIDDEN_438319#664662)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_RAPPRO_MANU_438320#664695)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_RAPPRO_MANU_438320#664695)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_CODSER_438321#664643)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_CODSER_438321#664643)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_ADM_ID_438322#664639)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_ADM_ID_438322#664639)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_FLDCD_438323#664656)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_FLDCD_438323#664656)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_TAILLE_438324#664708)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_TAILLE_438324#664708)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_POIDS_438325#664693)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_POIDS_438325#664693)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_CODCHK_438326#664641)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_CODCHK_438326#664641)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_DATCHK_438327#664648)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_DATCHK_438327#664648)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_HEUCHK_438328#664658)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_HEUCHK_438328#664658)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_TYPNAT_438329#664709)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_TYPNAT_438329#664709)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_NUMPER_SEC_438330#664685)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_NUMPER_SEC_438330#664685)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_NUMPER_ORI_S_438331#664684)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_NUMPER_ORI_S_438331#664684)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_STU_ID_ORI_438332#664704)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ST_STU_ID_ORI_438332#664704)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ORIGINE_440154#664637)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(ORIGINE_440154#664637)), MAIN) END)

(10) Project
Output: []
Input [74]: [ORIGINE_440154#664637, ST_ACCNUM_438289#664638, ST_ADM_ID_438322#664639, ST_CACHE_438317#664640, ST_CODCHK_438326#664641, ST_CODCLI_438314#664642, ST_CODSER_438321#664643, ST_CODSIT_438315#664644, ST_CODUTI_438287#664645, ST_COMM_1_438278#664646, ST_COMM_2_438279#664647, ST_DATCHK_438327#664648, ST_DATEFF_438276#664649, ST_DATMAJ_438285#664650, ST_DATSTU_438263#664651, ST_DROIT_438280#664652, ST_D_NDIC_438270#664653, ST_FABRIQ_438266#664654, ST_FLCD_438298#664655, ST_FLDCD_438323#664656, ST_FLMANU_438307#664657, ST_HEUCHK_438328#664658, ST_HEUEFF_438277#664659, ST_HEUMAJ_438286#664660, ST_HEUSTU_438264#664661, ST_HIDDEN_438319#664662, ST_INSTIT_438267#664663, ST_INS_438316#664664, ST_INS_OID_438318#664665, ST_KEYWORD_438309#664666, ST_LIEU_438299#664667, ST_LOCKED_438306#664668, ST_MODALI_438265#664669, ST_NB_ACQ_438272#664670, ST_NB_FIC_438274#664671, ST_NB_FIC_H_438303#664672, ST_NB_IMA_438273#664673, ST_NB_IMA_H_438304#664674, ST_NB_SER_438271#664675, ST_NB_SER_H_438302#664676, ST_NOMDIC_438268#664677, ST_NUMCD_438300#664678, ST_NUMDEM_438283#664679, ST_NUMDOS_438282#664680, ST_NUMEXA_438297#664681, ST_NUMPER_438284#664682, ST_NUMPER_ORI_438308#664683, ST_NUMPER_ORI_S_438331#664684, ST_NUMPER_SEC_438330#664685, ST_NUMSTU_438260#664686, ST_NUM_ID_438262#664687, ST_OPERAT_438295#664688, ST_PATSEX_438292#664689, ST_PAT_ID_438288#664690, ST_PERPHY_438294#664691, ST_PNODIC_438269#664692, ST_POIDS_438325#664693, ST_RAPPRO_438281#664694, ST_RAPPRO_MANU_438320#664695, ST_READ_438310#664696, ST_REAPHY_438293#664697, ST_REFPHY_438290#664698, ST_SOP_UID_438313#664699, ST_STA_PPS_438312#664700, ST_STUDSC_438291#664701, ST_STUEFF_438275#664702, ST_STU_ID_438261#664703, ST_STU_ID_ORI_438332#664704, ST_SVCDEM_438301#664705, ST_TAIFIC_438296#664706, ST_TAIFIC_H_438305#664707, ST_TAILLE_438324#664708, ST_TYPNAT_438329#664709, ST_URGEN_438311#664710]

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

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

(13) HashAggregate
Input [1]: [count#665311L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#665229L]
Results [1]: [count(1)#665229L AS COL_168cc58a-7e09-4e29-8ce2-09ddfdd78c7c#665231L]

(14) AdaptiveSparkPlan
Output [1]: [COL_168cc58a-7e09-4e29-8ce2-09ddfdd78c7c#665231L]
Arguments: isFinalPlan=true

SQL / DataFrame Properties

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