hdh-spark-job - Details for Query 739

Submitted Time: 2026/10/21 21:36:48
Duration: 1 s
Succeeded Jobs: 732 736

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

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

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

Project

Filter ((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(ST_NUMSTU_438260#160825)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_NUMSTU_438260#160825)), A63000893163) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_STU_ID_438261#160842)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_STU_ID_438261#160842)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_NUM_ID_438262#160826)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_NUM_ID_438262#160826)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_DATSTU_438263#160790)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_DATSTU_438263#160790)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_HEUSTU_438264#160800)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_HEUSTU_438264#160800)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_MODALI_438265#160808)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_MODALI_438265#160808)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_FABRIQ_438266#160793)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_FABRIQ_438266#160793)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_INSTIT_438267#160802)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_INSTIT_438267#160802)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_NOMDIC_438268#160816)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_NOMDIC_438268#160816)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_PNODIC_438269#160831)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_PNODIC_438269#160831)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_D_NDIC_438270#160792)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_D_NDIC_438270#160792)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_NB_SER_438271#160814)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_NB_SER_438271#160814)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_NB_ACQ_438272#160809)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_NB_ACQ_438272#160809)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_NB_IMA_438273#160812)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_NB_IMA_438273#160812)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_NB_FIC_438274#160810)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_NB_FIC_438274#160810)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_STUEFF_438275#160841)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_STUEFF_438275#160841)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_DATEFF_438276#160788)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_DATEFF_438276#160788)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_HEUEFF_438277#160798)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_HEUEFF_438277#160798)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_COMM_1_438278#160785)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_COMM_1_438278#160785)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_COMM_2_438279#160786)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_COMM_2_438279#160786)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_DROIT_438280#160791)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_DROIT_438280#160791)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_RAPPRO_438281#160833)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_RAPPRO_438281#160833)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_NUMDOS_438282#160819)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_NUMDOS_438282#160819)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_NUMDEM_438283#160818)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_NUMDEM_438283#160818)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_NUMPER_438284#160821)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_NUMPER_438284#160821)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_DATMAJ_438285#160789)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_DATMAJ_438285#160789)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_HEUMAJ_438286#160799)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_HEUMAJ_438286#160799)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_CODUTI_438287#160784)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_CODUTI_438287#160784)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_PAT_ID_438288#160829)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_PAT_ID_438288#160829)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_ACCNUM_438289#160777)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_ACCNUM_438289#160777)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_REFPHY_438290#160837)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_REFPHY_438290#160837)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_STUDSC_438291#160840)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_STUDSC_438291#160840)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_PATSEX_438292#160828)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_PATSEX_438292#160828)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_REAPHY_438293#160836)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_REAPHY_438293#160836)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_PERPHY_438294#160830)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_PERPHY_438294#160830)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_OPERAT_438295#160827)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_OPERAT_438295#160827)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_TAIFIC_438296#160845)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_TAIFIC_438296#160845)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_NUMEXA_438297#160820)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_NUMEXA_438297#160820)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_FLCD_438298#160794)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_FLCD_438298#160794)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_LIEU_438299#160806)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_LIEU_438299#160806)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_NUMCD_438300#160817)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_NUMCD_438300#160817)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_SVCDEM_438301#160844)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_SVCDEM_438301#160844)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_NB_SER_H_438302#160815)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_NB_SER_H_438302#160815)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_NB_FIC_H_438303#160811)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_NB_FIC_H_438303#160811)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_NB_IMA_H_438304#160813)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_NB_IMA_H_438304#160813)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_TAIFIC_H_438305#160846)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_TAIFIC_H_438305#160846)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_LOCKED_438306#160807)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_LOCKED_438306#160807)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_FLMANU_438307#160796)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_FLMANU_438307#160796)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_NUMPER_ORI_438308#160822)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_NUMPER_ORI_438308#160822)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_KEYWORD_438309#160805)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_KEYWORD_438309#160805)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_READ_438310#160835)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_READ_438310#160835)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_URGEN_438311#160849)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_URGEN_438311#160849)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_STA_PPS_438312#160839)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_STA_PPS_438312#160839)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_SOP_UID_438313#160838)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_SOP_UID_438313#160838)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_CODCLI_438314#160781)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_CODCLI_438314#160781)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_CODSIT_438315#160783)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_CODSIT_438315#160783)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_INS_438316#160803)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_INS_438316#160803)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_CACHE_438317#160779)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_CACHE_438317#160779)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_INS_OID_438318#160804)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_INS_OID_438318#160804)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_HIDDEN_438319#160801)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_HIDDEN_438319#160801)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_RAPPRO_MANU_438320#160834)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_RAPPRO_MANU_438320#160834)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_CODSER_438321#160782)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_CODSER_438321#160782)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_ADM_ID_438322#160778)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_ADM_ID_438322#160778)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_FLDCD_438323#160795)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_FLDCD_438323#160795)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_TAILLE_438324#160847)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_TAILLE_438324#160847)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_POIDS_438325#160832)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_POIDS_438325#160832)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_CODCHK_438326#160780)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_CODCHK_438326#160780)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_DATCHK_438327#160787)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_DATCHK_438327#160787)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_HEUCHK_438328#160797)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_HEUCHK_438328#160797)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_TYPNAT_438329#160848)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_TYPNAT_438329#160848)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_NUMPER_SEC_438330#160824)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_NUMPER_SEC_438330#160824)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_NUMPER_ORI_S_438331#160823)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_NUMPER_ORI_S_438331#160823)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_STU_ID_ORI_438332#160843)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_STU_ID_ORI_438332#160843)), A63000893163) END)

ColumnarToRow

WholeStageCodegen (1)

FileScan parquet [ST_ACCNUM_438289#160777,ST_ADM_ID_438322#160778,ST_CACHE_438317#160779,ST_CODCHK_438326#160780,ST_CODCLI_438314#160781,ST_CODSER_438321#160782,ST_CODSIT_438315#160783,ST_CODUTI_438287#160784,ST_COMM_1_438278#160785,ST_COMM_2_438279#160786,ST_DATCHK_438327#160787,ST_DATEFF_438276#160788,ST_DATMAJ_438285#160789,ST_DATSTU_438263#160790,ST_DROIT_438280#160791,ST_D_NDIC_438270#160792,ST_FABRIQ_438266#160793,ST_FLCD_438298#160794,ST_FLDCD_438323#160795,ST_FLMANU_438307#160796,ST_HEUCHK_438328#160797,ST_HEUEFF_438277#160798,ST_HEUMAJ_438286#160799,ST_HEUSTU_438264#160800,... 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#160777, ST_ADM_ID_438322#160778, ST_CACHE_438317#160779, ST_CODCHK_438326#160780, ST_CODCLI_438314#160781, ST_CODSER_438321#160782, ST_CODSIT_438315#160783, ST_CODUTI_438287#160784, ST_COMM_1_438278#160785, ST_COMM_2_438279#160786, ST_DATCHK_438327#160787, ST_DATEFF_438276#160788, ST_DATMAJ_438285#160789, ST_DATSTU_438263#160790, ST_DROIT_438280#160791, ST_D_NDIC_438270#160792, ST_FABRIQ_438266#160793, ST_FLCD_438298#160794, ST_FLDCD_438323#160795, ST_FLMANU_438307#160796, ST_HEUCHK_438328#160797, ST_HEUEFF_438277#160798, ST_HEUMAJ_438286#160799, ST_HEUSTU_438264#160800, ST_HIDDEN_438319#160801, ST_INSTIT_438267#160802, ST_INS_438316#160803, ST_INS_OID_438318#160804, ST_KEYWORD_438309#160805, ST_LIEU_438299#160806, ST_LOCKED_438306#160807, ST_MODALI_438265#160808, ST_NB_ACQ_438272#160809, ST_NB_FIC_438274#160810, ST_NB_FIC_H_438303#160811, ST_NB_IMA_438273#160812, ST_NB_IMA_H_438304#160813, ST_NB_SER_438271#160814, ST_NB_SER_H_438302#160815, ST_NOMDIC_438268#160816, ST_NUMCD_438300#160817, ST_NUMDEM_438283#160818, ST_NUMDOS_438282#160819, ST_NUMEXA_438297#160820, ST_NUMPER_438284#160821, ST_NUMPER_ORI_438308#160822, ST_NUMPER_ORI_S_438331#160823, ST_NUMPER_SEC_438330#160824, ST_NUMSTU_438260#160825, ST_NUM_ID_438262#160826, ST_OPERAT_438295#160827, ST_PATSEX_438292#160828, ST_PAT_ID_438288#160829, ST_PERPHY_438294#160830, ST_PNODIC_438269#160831, ST_POIDS_438325#160832, ST_RAPPRO_438281#160833, ST_RAPPRO_MANU_438320#160834, ST_READ_438310#160835, ST_REAPHY_438293#160836, ST_REFPHY_438290#160837, ST_SOP_UID_438313#160838, ST_STA_PPS_438312#160839, ST_STUDSC_438291#160840, ST_STUEFF_438275#160841, ST_STU_ID_438261#160842, ST_STU_ID_ORI_438332#160843, ST_SVCDEM_438301#160844, ST_TAIFIC_438296#160845, ST_TAIFIC_H_438305#160846, ST_TAILLE_438324#160847, ST_TYPNAT_438329#160848, ST_URGEN_438311#160849]
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#160777, ST_ADM_ID_438322#160778, ST_CACHE_438317#160779, ST_CODCHK_438326#160780, ST_CODCLI_438314#160781, ST_CODSER_438321#160782, ST_CODSIT_438315#160783, ST_CODUTI_438287#160784, ST_COMM_1_438278#160785, ST_COMM_2_438279#160786, ST_DATCHK_438327#160787, ST_DATEFF_438276#160788, ST_DATMAJ_438285#160789, ST_DATSTU_438263#160790, ST_DROIT_438280#160791, ST_D_NDIC_438270#160792, ST_FABRIQ_438266#160793, ST_FLCD_438298#160794, ST_FLDCD_438323#160795, ST_FLMANU_438307#160796, ST_HEUCHK_438328#160797, ST_HEUEFF_438277#160798, ST_HEUMAJ_438286#160799, ST_HEUSTU_438264#160800, ST_HIDDEN_438319#160801, ST_INSTIT_438267#160802, ST_INS_438316#160803, ST_INS_OID_438318#160804, ST_KEYWORD_438309#160805, ST_LIEU_438299#160806, ST_LOCKED_438306#160807, ST_MODALI_438265#160808, ST_NB_ACQ_438272#160809, ST_NB_FIC_438274#160810, ST_NB_FIC_H_438303#160811, ST_NB_IMA_438273#160812, ST_NB_IMA_H_438304#160813, ST_NB_SER_438271#160814, ST_NB_SER_H_438302#160815, ST_NOMDIC_438268#160816, ST_NUMCD_438300#160817, ST_NUMDEM_438283#160818, ST_NUMDOS_438282#160819, ST_NUMEXA_438297#160820, ST_NUMPER_438284#160821, ST_NUMPER_ORI_438308#160822, ST_NUMPER_ORI_S_438331#160823, ST_NUMPER_SEC_438330#160824, ST_NUMSTU_438260#160825, ST_NUM_ID_438262#160826, ST_OPERAT_438295#160827, ST_PATSEX_438292#160828, ST_PAT_ID_438288#160829, ST_PERPHY_438294#160830, ST_PNODIC_438269#160831, ST_POIDS_438325#160832, ST_RAPPRO_438281#160833, ST_RAPPRO_MANU_438320#160834, ST_READ_438310#160835, ST_REAPHY_438293#160836, ST_REFPHY_438290#160837, ST_SOP_UID_438313#160838, ST_STA_PPS_438312#160839, ST_STUDSC_438291#160840, ST_STUEFF_438275#160841, ST_STU_ID_438261#160842, ST_STU_ID_ORI_438332#160843, ST_SVCDEM_438301#160844, ST_TAIFIC_438296#160845, ST_TAIFIC_H_438305#160846, ST_TAILLE_438324#160847, ST_TYPNAT_438329#160848, ST_URGEN_438311#160849]

(3) Filter [codegen id : 1]
Input [73]: [ST_ACCNUM_438289#160777, ST_ADM_ID_438322#160778, ST_CACHE_438317#160779, ST_CODCHK_438326#160780, ST_CODCLI_438314#160781, ST_CODSER_438321#160782, ST_CODSIT_438315#160783, ST_CODUTI_438287#160784, ST_COMM_1_438278#160785, ST_COMM_2_438279#160786, ST_DATCHK_438327#160787, ST_DATEFF_438276#160788, ST_DATMAJ_438285#160789, ST_DATSTU_438263#160790, ST_DROIT_438280#160791, ST_D_NDIC_438270#160792, ST_FABRIQ_438266#160793, ST_FLCD_438298#160794, ST_FLDCD_438323#160795, ST_FLMANU_438307#160796, ST_HEUCHK_438328#160797, ST_HEUEFF_438277#160798, ST_HEUMAJ_438286#160799, ST_HEUSTU_438264#160800, ST_HIDDEN_438319#160801, ST_INSTIT_438267#160802, ST_INS_438316#160803, ST_INS_OID_438318#160804, ST_KEYWORD_438309#160805, ST_LIEU_438299#160806, ST_LOCKED_438306#160807, ST_MODALI_438265#160808, ST_NB_ACQ_438272#160809, ST_NB_FIC_438274#160810, ST_NB_FIC_H_438303#160811, ST_NB_IMA_438273#160812, ST_NB_IMA_H_438304#160813, ST_NB_SER_438271#160814, ST_NB_SER_H_438302#160815, ST_NOMDIC_438268#160816, ST_NUMCD_438300#160817, ST_NUMDEM_438283#160818, ST_NUMDOS_438282#160819, ST_NUMEXA_438297#160820, ST_NUMPER_438284#160821, ST_NUMPER_ORI_438308#160822, ST_NUMPER_ORI_S_438331#160823, ST_NUMPER_SEC_438330#160824, ST_NUMSTU_438260#160825, ST_NUM_ID_438262#160826, ST_OPERAT_438295#160827, ST_PATSEX_438292#160828, ST_PAT_ID_438288#160829, ST_PERPHY_438294#160830, ST_PNODIC_438269#160831, ST_POIDS_438325#160832, ST_RAPPRO_438281#160833, ST_RAPPRO_MANU_438320#160834, ST_READ_438310#160835, ST_REAPHY_438293#160836, ST_REFPHY_438290#160837, ST_SOP_UID_438313#160838, ST_STA_PPS_438312#160839, ST_STUDSC_438291#160840, ST_STUEFF_438275#160841, ST_STU_ID_438261#160842, ST_STU_ID_ORI_438332#160843, ST_SVCDEM_438301#160844, ST_TAIFIC_438296#160845, ST_TAIFIC_H_438305#160846, ST_TAILLE_438324#160847, ST_TYPNAT_438329#160848, ST_URGEN_438311#160849]
Condition : ((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(ST_NUMSTU_438260#160825)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_NUMSTU_438260#160825)), A63000893163) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_STU_ID_438261#160842)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_STU_ID_438261#160842)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_NUM_ID_438262#160826)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_NUM_ID_438262#160826)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_DATSTU_438263#160790)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_DATSTU_438263#160790)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_HEUSTU_438264#160800)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_HEUSTU_438264#160800)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_MODALI_438265#160808)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_MODALI_438265#160808)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_FABRIQ_438266#160793)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_FABRIQ_438266#160793)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_INSTIT_438267#160802)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_INSTIT_438267#160802)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_NOMDIC_438268#160816)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_NOMDIC_438268#160816)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_PNODIC_438269#160831)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_PNODIC_438269#160831)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_D_NDIC_438270#160792)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_D_NDIC_438270#160792)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_NB_SER_438271#160814)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_NB_SER_438271#160814)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_NB_ACQ_438272#160809)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_NB_ACQ_438272#160809)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_NB_IMA_438273#160812)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_NB_IMA_438273#160812)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_NB_FIC_438274#160810)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_NB_FIC_438274#160810)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_STUEFF_438275#160841)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_STUEFF_438275#160841)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_DATEFF_438276#160788)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_DATEFF_438276#160788)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_HEUEFF_438277#160798)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_HEUEFF_438277#160798)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_COMM_1_438278#160785)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_COMM_1_438278#160785)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_COMM_2_438279#160786)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_COMM_2_438279#160786)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_DROIT_438280#160791)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_DROIT_438280#160791)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_RAPPRO_438281#160833)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_RAPPRO_438281#160833)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_NUMDOS_438282#160819)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_NUMDOS_438282#160819)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_NUMDEM_438283#160818)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_NUMDEM_438283#160818)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_NUMPER_438284#160821)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_NUMPER_438284#160821)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_DATMAJ_438285#160789)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_DATMAJ_438285#160789)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_HEUMAJ_438286#160799)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_HEUMAJ_438286#160799)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_CODUTI_438287#160784)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_CODUTI_438287#160784)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_PAT_ID_438288#160829)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_PAT_ID_438288#160829)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_ACCNUM_438289#160777)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_ACCNUM_438289#160777)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_REFPHY_438290#160837)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_REFPHY_438290#160837)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_STUDSC_438291#160840)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_STUDSC_438291#160840)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_PATSEX_438292#160828)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_PATSEX_438292#160828)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_REAPHY_438293#160836)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_REAPHY_438293#160836)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_PERPHY_438294#160830)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_PERPHY_438294#160830)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_OPERAT_438295#160827)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_OPERAT_438295#160827)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_TAIFIC_438296#160845)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_TAIFIC_438296#160845)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_NUMEXA_438297#160820)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_NUMEXA_438297#160820)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_FLCD_438298#160794)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_FLCD_438298#160794)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_LIEU_438299#160806)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_LIEU_438299#160806)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_NUMCD_438300#160817)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_NUMCD_438300#160817)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_SVCDEM_438301#160844)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_SVCDEM_438301#160844)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_NB_SER_H_438302#160815)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_NB_SER_H_438302#160815)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_NB_FIC_H_438303#160811)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_NB_FIC_H_438303#160811)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_NB_IMA_H_438304#160813)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_NB_IMA_H_438304#160813)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_TAIFIC_H_438305#160846)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_TAIFIC_H_438305#160846)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_LOCKED_438306#160807)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_LOCKED_438306#160807)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_FLMANU_438307#160796)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_FLMANU_438307#160796)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_NUMPER_ORI_438308#160822)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_NUMPER_ORI_438308#160822)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_KEYWORD_438309#160805)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_KEYWORD_438309#160805)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_READ_438310#160835)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_READ_438310#160835)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_URGEN_438311#160849)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_URGEN_438311#160849)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_STA_PPS_438312#160839)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_STA_PPS_438312#160839)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_SOP_UID_438313#160838)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_SOP_UID_438313#160838)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_CODCLI_438314#160781)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_CODCLI_438314#160781)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_CODSIT_438315#160783)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_CODSIT_438315#160783)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_INS_438316#160803)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_INS_438316#160803)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_CACHE_438317#160779)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_CACHE_438317#160779)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_INS_OID_438318#160804)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_INS_OID_438318#160804)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_HIDDEN_438319#160801)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_HIDDEN_438319#160801)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_RAPPRO_MANU_438320#160834)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_RAPPRO_MANU_438320#160834)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_CODSER_438321#160782)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_CODSER_438321#160782)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_ADM_ID_438322#160778)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_ADM_ID_438322#160778)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_FLDCD_438323#160795)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_FLDCD_438323#160795)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_TAILLE_438324#160847)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_TAILLE_438324#160847)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_POIDS_438325#160832)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_POIDS_438325#160832)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_CODCHK_438326#160780)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_CODCHK_438326#160780)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_DATCHK_438327#160787)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_DATCHK_438327#160787)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_HEUCHK_438328#160797)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_HEUCHK_438328#160797)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_TYPNAT_438329#160848)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_TYPNAT_438329#160848)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_NUMPER_SEC_438330#160824)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_NUMPER_SEC_438330#160824)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_NUMPER_ORI_S_438331#160823)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_NUMPER_ORI_S_438331#160823)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_STU_ID_ORI_438332#160843)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_STU_ID_ORI_438332#160843)), A63000893163) END)

(4) Project [codegen id : 1]
Output: []
Input [73]: [ST_ACCNUM_438289#160777, ST_ADM_ID_438322#160778, ST_CACHE_438317#160779, ST_CODCHK_438326#160780, ST_CODCLI_438314#160781, ST_CODSER_438321#160782, ST_CODSIT_438315#160783, ST_CODUTI_438287#160784, ST_COMM_1_438278#160785, ST_COMM_2_438279#160786, ST_DATCHK_438327#160787, ST_DATEFF_438276#160788, ST_DATMAJ_438285#160789, ST_DATSTU_438263#160790, ST_DROIT_438280#160791, ST_D_NDIC_438270#160792, ST_FABRIQ_438266#160793, ST_FLCD_438298#160794, ST_FLDCD_438323#160795, ST_FLMANU_438307#160796, ST_HEUCHK_438328#160797, ST_HEUEFF_438277#160798, ST_HEUMAJ_438286#160799, ST_HEUSTU_438264#160800, ST_HIDDEN_438319#160801, ST_INSTIT_438267#160802, ST_INS_438316#160803, ST_INS_OID_438318#160804, ST_KEYWORD_438309#160805, ST_LIEU_438299#160806, ST_LOCKED_438306#160807, ST_MODALI_438265#160808, ST_NB_ACQ_438272#160809, ST_NB_FIC_438274#160810, ST_NB_FIC_H_438303#160811, ST_NB_IMA_438273#160812, ST_NB_IMA_H_438304#160813, ST_NB_SER_438271#160814, ST_NB_SER_H_438302#160815, ST_NOMDIC_438268#160816, ST_NUMCD_438300#160817, ST_NUMDEM_438283#160818, ST_NUMDOS_438282#160819, ST_NUMEXA_438297#160820, ST_NUMPER_438284#160821, ST_NUMPER_ORI_438308#160822, ST_NUMPER_ORI_S_438331#160823, ST_NUMPER_SEC_438330#160824, ST_NUMSTU_438260#160825, ST_NUM_ID_438262#160826, ST_OPERAT_438295#160827, ST_PATSEX_438292#160828, ST_PAT_ID_438288#160829, ST_PERPHY_438294#160830, ST_PNODIC_438269#160831, ST_POIDS_438325#160832, ST_RAPPRO_438281#160833, ST_RAPPRO_MANU_438320#160834, ST_READ_438310#160835, ST_REAPHY_438293#160836, ST_REFPHY_438290#160837, ST_SOP_UID_438313#160838, ST_STA_PPS_438312#160839, ST_STUDSC_438291#160840, ST_STUEFF_438275#160841, ST_STU_ID_438261#160842, ST_STU_ID_ORI_438332#160843, ST_SVCDEM_438301#160844, ST_TAIFIC_438296#160845, ST_TAIFIC_H_438305#160846, ST_TAILLE_438324#160847, ST_TYPNAT_438329#160848, ST_URGEN_438311#160849]

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

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

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

(8) HashAggregate [codegen id : 2]
Input [1]: [count#163708L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#163313L]
Results [1]: [count(1)#163313L AS COL_487babc8-e0bb-4e5c-b5ec-f503476fc144#163315L]

(9) Filter
Input [73]: [ST_ACCNUM_438289#160777, ST_ADM_ID_438322#160778, ST_CACHE_438317#160779, ST_CODCHK_438326#160780, ST_CODCLI_438314#160781, ST_CODSER_438321#160782, ST_CODSIT_438315#160783, ST_CODUTI_438287#160784, ST_COMM_1_438278#160785, ST_COMM_2_438279#160786, ST_DATCHK_438327#160787, ST_DATEFF_438276#160788, ST_DATMAJ_438285#160789, ST_DATSTU_438263#160790, ST_DROIT_438280#160791, ST_D_NDIC_438270#160792, ST_FABRIQ_438266#160793, ST_FLCD_438298#160794, ST_FLDCD_438323#160795, ST_FLMANU_438307#160796, ST_HEUCHK_438328#160797, ST_HEUEFF_438277#160798, ST_HEUMAJ_438286#160799, ST_HEUSTU_438264#160800, ST_HIDDEN_438319#160801, ST_INSTIT_438267#160802, ST_INS_438316#160803, ST_INS_OID_438318#160804, ST_KEYWORD_438309#160805, ST_LIEU_438299#160806, ST_LOCKED_438306#160807, ST_MODALI_438265#160808, ST_NB_ACQ_438272#160809, ST_NB_FIC_438274#160810, ST_NB_FIC_H_438303#160811, ST_NB_IMA_438273#160812, ST_NB_IMA_H_438304#160813, ST_NB_SER_438271#160814, ST_NB_SER_H_438302#160815, ST_NOMDIC_438268#160816, ST_NUMCD_438300#160817, ST_NUMDEM_438283#160818, ST_NUMDOS_438282#160819, ST_NUMEXA_438297#160820, ST_NUMPER_438284#160821, ST_NUMPER_ORI_438308#160822, ST_NUMPER_ORI_S_438331#160823, ST_NUMPER_SEC_438330#160824, ST_NUMSTU_438260#160825, ST_NUM_ID_438262#160826, ST_OPERAT_438295#160827, ST_PATSEX_438292#160828, ST_PAT_ID_438288#160829, ST_PERPHY_438294#160830, ST_PNODIC_438269#160831, ST_POIDS_438325#160832, ST_RAPPRO_438281#160833, ST_RAPPRO_MANU_438320#160834, ST_READ_438310#160835, ST_REAPHY_438293#160836, ST_REFPHY_438290#160837, ST_SOP_UID_438313#160838, ST_STA_PPS_438312#160839, ST_STUDSC_438291#160840, ST_STUEFF_438275#160841, ST_STU_ID_438261#160842, ST_STU_ID_ORI_438332#160843, ST_SVCDEM_438301#160844, ST_TAIFIC_438296#160845, ST_TAIFIC_H_438305#160846, ST_TAILLE_438324#160847, ST_TYPNAT_438329#160848, ST_URGEN_438311#160849]
Condition : ((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(ST_NUMSTU_438260#160825)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_NUMSTU_438260#160825)), A63000893163) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_STU_ID_438261#160842)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_STU_ID_438261#160842)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_NUM_ID_438262#160826)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_NUM_ID_438262#160826)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_DATSTU_438263#160790)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_DATSTU_438263#160790)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_HEUSTU_438264#160800)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_HEUSTU_438264#160800)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_MODALI_438265#160808)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_MODALI_438265#160808)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_FABRIQ_438266#160793)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_FABRIQ_438266#160793)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_INSTIT_438267#160802)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_INSTIT_438267#160802)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_NOMDIC_438268#160816)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_NOMDIC_438268#160816)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_PNODIC_438269#160831)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_PNODIC_438269#160831)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_D_NDIC_438270#160792)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_D_NDIC_438270#160792)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_NB_SER_438271#160814)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_NB_SER_438271#160814)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_NB_ACQ_438272#160809)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_NB_ACQ_438272#160809)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_NB_IMA_438273#160812)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_NB_IMA_438273#160812)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_NB_FIC_438274#160810)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_NB_FIC_438274#160810)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_STUEFF_438275#160841)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_STUEFF_438275#160841)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_DATEFF_438276#160788)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_DATEFF_438276#160788)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_HEUEFF_438277#160798)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_HEUEFF_438277#160798)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_COMM_1_438278#160785)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_COMM_1_438278#160785)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_COMM_2_438279#160786)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_COMM_2_438279#160786)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_DROIT_438280#160791)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_DROIT_438280#160791)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_RAPPRO_438281#160833)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_RAPPRO_438281#160833)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_NUMDOS_438282#160819)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_NUMDOS_438282#160819)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_NUMDEM_438283#160818)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_NUMDEM_438283#160818)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_NUMPER_438284#160821)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_NUMPER_438284#160821)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_DATMAJ_438285#160789)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_DATMAJ_438285#160789)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_HEUMAJ_438286#160799)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_HEUMAJ_438286#160799)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_CODUTI_438287#160784)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_CODUTI_438287#160784)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_PAT_ID_438288#160829)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_PAT_ID_438288#160829)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_ACCNUM_438289#160777)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_ACCNUM_438289#160777)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_REFPHY_438290#160837)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_REFPHY_438290#160837)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_STUDSC_438291#160840)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_STUDSC_438291#160840)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_PATSEX_438292#160828)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_PATSEX_438292#160828)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_REAPHY_438293#160836)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_REAPHY_438293#160836)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_PERPHY_438294#160830)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_PERPHY_438294#160830)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_OPERAT_438295#160827)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_OPERAT_438295#160827)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_TAIFIC_438296#160845)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_TAIFIC_438296#160845)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_NUMEXA_438297#160820)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_NUMEXA_438297#160820)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_FLCD_438298#160794)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_FLCD_438298#160794)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_LIEU_438299#160806)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_LIEU_438299#160806)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_NUMCD_438300#160817)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_NUMCD_438300#160817)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_SVCDEM_438301#160844)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_SVCDEM_438301#160844)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_NB_SER_H_438302#160815)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_NB_SER_H_438302#160815)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_NB_FIC_H_438303#160811)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_NB_FIC_H_438303#160811)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_NB_IMA_H_438304#160813)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_NB_IMA_H_438304#160813)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_TAIFIC_H_438305#160846)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_TAIFIC_H_438305#160846)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_LOCKED_438306#160807)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_LOCKED_438306#160807)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_FLMANU_438307#160796)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_FLMANU_438307#160796)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_NUMPER_ORI_438308#160822)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_NUMPER_ORI_438308#160822)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_KEYWORD_438309#160805)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_KEYWORD_438309#160805)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_READ_438310#160835)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_READ_438310#160835)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_URGEN_438311#160849)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_URGEN_438311#160849)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_STA_PPS_438312#160839)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_STA_PPS_438312#160839)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_SOP_UID_438313#160838)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_SOP_UID_438313#160838)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_CODCLI_438314#160781)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_CODCLI_438314#160781)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_CODSIT_438315#160783)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_CODSIT_438315#160783)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_INS_438316#160803)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_INS_438316#160803)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_CACHE_438317#160779)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_CACHE_438317#160779)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_INS_OID_438318#160804)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_INS_OID_438318#160804)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_HIDDEN_438319#160801)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_HIDDEN_438319#160801)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_RAPPRO_MANU_438320#160834)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_RAPPRO_MANU_438320#160834)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_CODSER_438321#160782)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_CODSER_438321#160782)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_ADM_ID_438322#160778)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_ADM_ID_438322#160778)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_FLDCD_438323#160795)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_FLDCD_438323#160795)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_TAILLE_438324#160847)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_TAILLE_438324#160847)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_POIDS_438325#160832)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_POIDS_438325#160832)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_CODCHK_438326#160780)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_CODCHK_438326#160780)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_DATCHK_438327#160787)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_DATCHK_438327#160787)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_HEUCHK_438328#160797)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_HEUCHK_438328#160797)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_TYPNAT_438329#160848)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_TYPNAT_438329#160848)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_NUMPER_SEC_438330#160824)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_NUMPER_SEC_438330#160824)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_NUMPER_ORI_S_438331#160823)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_NUMPER_ORI_S_438331#160823)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_STU_ID_ORI_438332#160843)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(ST_STU_ID_ORI_438332#160843)), A63000893163) END)

(10) Project
Output: []
Input [73]: [ST_ACCNUM_438289#160777, ST_ADM_ID_438322#160778, ST_CACHE_438317#160779, ST_CODCHK_438326#160780, ST_CODCLI_438314#160781, ST_CODSER_438321#160782, ST_CODSIT_438315#160783, ST_CODUTI_438287#160784, ST_COMM_1_438278#160785, ST_COMM_2_438279#160786, ST_DATCHK_438327#160787, ST_DATEFF_438276#160788, ST_DATMAJ_438285#160789, ST_DATSTU_438263#160790, ST_DROIT_438280#160791, ST_D_NDIC_438270#160792, ST_FABRIQ_438266#160793, ST_FLCD_438298#160794, ST_FLDCD_438323#160795, ST_FLMANU_438307#160796, ST_HEUCHK_438328#160797, ST_HEUEFF_438277#160798, ST_HEUMAJ_438286#160799, ST_HEUSTU_438264#160800, ST_HIDDEN_438319#160801, ST_INSTIT_438267#160802, ST_INS_438316#160803, ST_INS_OID_438318#160804, ST_KEYWORD_438309#160805, ST_LIEU_438299#160806, ST_LOCKED_438306#160807, ST_MODALI_438265#160808, ST_NB_ACQ_438272#160809, ST_NB_FIC_438274#160810, ST_NB_FIC_H_438303#160811, ST_NB_IMA_438273#160812, ST_NB_IMA_H_438304#160813, ST_NB_SER_438271#160814, ST_NB_SER_H_438302#160815, ST_NOMDIC_438268#160816, ST_NUMCD_438300#160817, ST_NUMDEM_438283#160818, ST_NUMDOS_438282#160819, ST_NUMEXA_438297#160820, ST_NUMPER_438284#160821, ST_NUMPER_ORI_438308#160822, ST_NUMPER_ORI_S_438331#160823, ST_NUMPER_SEC_438330#160824, ST_NUMSTU_438260#160825, ST_NUM_ID_438262#160826, ST_OPERAT_438295#160827, ST_PATSEX_438292#160828, ST_PAT_ID_438288#160829, ST_PERPHY_438294#160830, ST_PNODIC_438269#160831, ST_POIDS_438325#160832, ST_RAPPRO_438281#160833, ST_RAPPRO_MANU_438320#160834, ST_READ_438310#160835, ST_REAPHY_438293#160836, ST_REFPHY_438290#160837, ST_SOP_UID_438313#160838, ST_STA_PPS_438312#160839, ST_STUDSC_438291#160840, ST_STUEFF_438275#160841, ST_STU_ID_438261#160842, ST_STU_ID_ORI_438332#160843, ST_SVCDEM_438301#160844, ST_TAIFIC_438296#160845, ST_TAIFIC_H_438305#160846, ST_TAILLE_438324#160847, ST_TYPNAT_438329#160848, ST_URGEN_438311#160849]

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

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

(13) HashAggregate
Input [1]: [count#163708L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#163313L]
Results [1]: [count(1)#163313L AS COL_487babc8-e0bb-4e5c-b5ec-f503476fc144#163315L]

(14) AdaptiveSparkPlan
Output [1]: [COL_487babc8-e0bb-4e5c-b5ec-f503476fc144#163315L]
Arguments: isFinalPlan=true

SQL / DataFrame Properties

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