hdh-spark-job - Details for Query 617

Submitted Time: 2026/10/21 21:32:58
Duration: 0.8 s
Succeeded Jobs: 555

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

digraph G { 0 [labelType="html" label=" CollectLimit "]; subgraph cluster1 { isCluster="true"; label="WholeStageCodegen (1)\n \nduration: 9 ms"; 2 [labelType="html" label=" Project "]; 3 [labelType="html" label="Filter number of output rows: 5"]; 4 [labelType="html" label="ColumnarToRow number of output rows: 9 number of input batches: 1"]; } 5 [labelType="html" label="Scan parquet number of files read: 1 scan time: 8 ms metadata time: 0 ms size of files read: 23.8 KiB number of output rows: 9"]; 2->0; 3->2; 4->3; 5->4; }

CollectLimit 1500

Project [ST_NUMSTU_438260#128353 AS COL_F76F4CDE_E0D3_4FF1_A7D5_EED85C8B91F4#128743, ST_STU_ID_438261#128370 AS COL_8B493886_724B_4EDD_8F49_B6BB2E19668F#128744, ST_NUM_ID_438262#128354 AS COL_A55E3D6D_8CDE_4222_8FF1_ECC443E564AE#128745, ST_DATSTU_438263#128318 AS COL_C3B2BF6D_7B79_41F7_8EC6_52923A43CE6E#128746, ST_HEUSTU_438264#128328 AS COL_2CC438CE_3722_40AA_BF00_DC0425042340#128747, ST_MODALI_438265#128336 AS COL_132EC637_02C1_4CDC_B903_0BF75D86C3C7#128748, ST_FABRIQ_438266#128321 AS COL_8EC6E90A_7E8B_45A1_8A44_AE7B6FBAC71E#128749, ST_INSTIT_438267#128330 AS COL_242974CB_F9E0_40F5_8A8C_E3CE85281528#128750, ST_NOMDIC_438268#128344 AS COL_4FF428FC_3ECA_45FF_B6C7_E134C4E2DDB1#128751, ST_PNODIC_438269#128359 AS COL_52739C85_3489_41DE_94F4_E9D86B1F9112#128752, ST_D_NDIC_438270#128320 AS COL_8C97B9CF_F60A_4C43_A826_A3A5B21280D4#128753, ST_NB_SER_438271#128342 AS COL_1429265F_ED3F_4449_899C_95CC089232CB#128754, ST_NB_ACQ_438272#128337 AS COL_96A9B28E_2555_41A5_897C_4F1D56C89227#128755, ST_NB_IMA_438273#128340 AS COL_31CCA989_25E9_45C8_89D8_5AAAEDD7E6EB#128756, ST_NB_FIC_438274#128338 AS COL_304232C9_8AAC_4C8E_B1D2_1C851DD9723D#128757, ST_STUEFF_438275#128369 AS COL_CB736FBE_8A15_463B_A868_A7ABAB8AB425#128758, ST_DATEFF_438276#128316 AS COL_EBE1E448_E893_46AE_87D5_3659CC827B1C#128759, ST_HEUEFF_438277#128326 AS COL_AD1EE721_5D12_48B0_9F61_A35A42FA6D33#128760, ST_COMM_1_438278#128313 AS COL_EB30D5F0_1EF5_4FD3_B050_86FA885A88B6#128761, ST_COMM_2_438279#128314 AS COL_D9263A35_FF5A_4A7A_80DB_61CCE5774AD8#128762, ST_DROIT_438280#128319 AS COL_7FB1E95A_5A2E_4DDA_A44A_4BACAD5F7950#128763, ST_RAPPRO_438281#128361 AS COL_A53C203B_5DE1_49C2_BDB5_227C613F960E#128764, ST_NUMDOS_438282#128347 AS COL_61399AFB_D97E_4A4E_8D17_793054946775#128765, ST_NUMDEM_438283#128346 AS COL_6938C2EA_4AAA_4BF2_ADAC_76FA3320D3C0#128766, ... 49 more fields]

Filter ((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(ST_NUMSTU_438260#128353)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_NUMSTU_438260#128353)), MARX) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_STU_ID_438261#128370)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_STU_ID_438261#128370)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_NUM_ID_438262#128354)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_NUM_ID_438262#128354)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_DATSTU_438263#128318)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_DATSTU_438263#128318)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_HEUSTU_438264#128328)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_HEUSTU_438264#128328)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_MODALI_438265#128336)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_MODALI_438265#128336)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_FABRIQ_438266#128321)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_FABRIQ_438266#128321)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_INSTIT_438267#128330)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_INSTIT_438267#128330)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_NOMDIC_438268#128344)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_NOMDIC_438268#128344)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_PNODIC_438269#128359)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_PNODIC_438269#128359)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_D_NDIC_438270#128320)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_D_NDIC_438270#128320)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_NB_SER_438271#128342)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_NB_SER_438271#128342)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_NB_ACQ_438272#128337)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_NB_ACQ_438272#128337)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_NB_IMA_438273#128340)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_NB_IMA_438273#128340)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_NB_FIC_438274#128338)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_NB_FIC_438274#128338)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_STUEFF_438275#128369)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_STUEFF_438275#128369)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_DATEFF_438276#128316)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_DATEFF_438276#128316)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_HEUEFF_438277#128326)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_HEUEFF_438277#128326)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_COMM_1_438278#128313)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_COMM_1_438278#128313)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_COMM_2_438279#128314)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_COMM_2_438279#128314)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_DROIT_438280#128319)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_DROIT_438280#128319)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_RAPPRO_438281#128361)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_RAPPRO_438281#128361)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_NUMDOS_438282#128347)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_NUMDOS_438282#128347)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_NUMDEM_438283#128346)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_NUMDEM_438283#128346)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_NUMPER_438284#128349)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_NUMPER_438284#128349)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_DATMAJ_438285#128317)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_DATMAJ_438285#128317)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_HEUMAJ_438286#128327)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_HEUMAJ_438286#128327)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_CODUTI_438287#128312)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_CODUTI_438287#128312)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_PAT_ID_438288#128357)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_PAT_ID_438288#128357)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_ACCNUM_438289#128305)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_ACCNUM_438289#128305)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_REFPHY_438290#128365)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_REFPHY_438290#128365)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_STUDSC_438291#128368)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_STUDSC_438291#128368)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_PATSEX_438292#128356)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_PATSEX_438292#128356)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_REAPHY_438293#128364)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_REAPHY_438293#128364)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_PERPHY_438294#128358)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_PERPHY_438294#128358)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_OPERAT_438295#128355)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_OPERAT_438295#128355)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_TAIFIC_438296#128373)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_TAIFIC_438296#128373)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_NUMEXA_438297#128348)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_NUMEXA_438297#128348)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_FLCD_438298#128322)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_FLCD_438298#128322)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_LIEU_438299#128334)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_LIEU_438299#128334)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_NUMCD_438300#128345)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_NUMCD_438300#128345)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_SVCDEM_438301#128372)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_SVCDEM_438301#128372)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_NB_SER_H_438302#128343)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_NB_SER_H_438302#128343)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_NB_FIC_H_438303#128339)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_NB_FIC_H_438303#128339)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_NB_IMA_H_438304#128341)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_NB_IMA_H_438304#128341)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_TAIFIC_H_438305#128374)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_TAIFIC_H_438305#128374)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_LOCKED_438306#128335)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_LOCKED_438306#128335)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_FLMANU_438307#128324)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_FLMANU_438307#128324)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_NUMPER_ORI_438308#128350)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_NUMPER_ORI_438308#128350)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_KEYWORD_438309#128333)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_KEYWORD_438309#128333)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_READ_438310#128363)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_READ_438310#128363)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_URGEN_438311#128377)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_URGEN_438311#128377)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_STA_PPS_438312#128367)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_STA_PPS_438312#128367)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_SOP_UID_438313#128366)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_SOP_UID_438313#128366)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_CODCLI_438314#128309)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_CODCLI_438314#128309)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_CODSIT_438315#128311)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_CODSIT_438315#128311)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_INS_438316#128331)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_INS_438316#128331)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_CACHE_438317#128307)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_CACHE_438317#128307)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_INS_OID_438318#128332)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_INS_OID_438318#128332)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_HIDDEN_438319#128329)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_HIDDEN_438319#128329)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_RAPPRO_MANU_438320#128362)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_RAPPRO_MANU_438320#128362)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_CODSER_438321#128310)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_CODSER_438321#128310)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_ADM_ID_438322#128306)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_ADM_ID_438322#128306)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_FLDCD_438323#128323)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_FLDCD_438323#128323)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_TAILLE_438324#128375)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_TAILLE_438324#128375)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_POIDS_438325#128360)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_POIDS_438325#128360)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_CODCHK_438326#128308)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_CODCHK_438326#128308)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_DATCHK_438327#128315)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_DATCHK_438327#128315)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_HEUCHK_438328#128325)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_HEUCHK_438328#128325)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_TYPNAT_438329#128376)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_TYPNAT_438329#128376)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_NUMPER_SEC_438330#128352)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_NUMPER_SEC_438330#128352)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_NUMPER_ORI_S_438331#128351)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_NUMPER_ORI_S_438331#128351)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_STU_ID_ORI_438332#128371)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_STU_ID_ORI_438332#128371)), MARX) END)

ColumnarToRow

WholeStageCodegen (1)

FileScan parquet [ST_ACCNUM_438289#128305,ST_ADM_ID_438322#128306,ST_CACHE_438317#128307,ST_CODCHK_438326#128308,ST_CODCLI_438314#128309,ST_CODSER_438321#128310,ST_CODSIT_438315#128311,ST_CODUTI_438287#128312,ST_COMM_1_438278#128313,ST_COMM_2_438279#128314,ST_DATCHK_438327#128315,ST_DATEFF_438276#128316,ST_DATMAJ_438285#128317,ST_DATSTU_438263#128318,ST_DROIT_438280#128319,ST_D_NDIC_438270#128320,ST_FABRIQ_438266#128321,ST_FLCD_438298#128322,ST_FLDCD_438323#128323,ST_FLMANU_438307#128324,ST_HEUCHK_438328#128325,ST_HEUEFF_438277#128326,ST_HEUMAJ_438286#128327,ST_HEUSTU_438264#128328,... 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 ==
CollectLimit (5)
+- * Project (4)
   +- * Filter (3)
      +- * ColumnarToRow (2)
         +- Scan parquet  (1)


(1) Scan parquet 
Output [73]: [ST_ACCNUM_438289#128305, ST_ADM_ID_438322#128306, ST_CACHE_438317#128307, ST_CODCHK_438326#128308, ST_CODCLI_438314#128309, ST_CODSER_438321#128310, ST_CODSIT_438315#128311, ST_CODUTI_438287#128312, ST_COMM_1_438278#128313, ST_COMM_2_438279#128314, ST_DATCHK_438327#128315, ST_DATEFF_438276#128316, ST_DATMAJ_438285#128317, ST_DATSTU_438263#128318, ST_DROIT_438280#128319, ST_D_NDIC_438270#128320, ST_FABRIQ_438266#128321, ST_FLCD_438298#128322, ST_FLDCD_438323#128323, ST_FLMANU_438307#128324, ST_HEUCHK_438328#128325, ST_HEUEFF_438277#128326, ST_HEUMAJ_438286#128327, ST_HEUSTU_438264#128328, ST_HIDDEN_438319#128329, ST_INSTIT_438267#128330, ST_INS_438316#128331, ST_INS_OID_438318#128332, ST_KEYWORD_438309#128333, ST_LIEU_438299#128334, ST_LOCKED_438306#128335, ST_MODALI_438265#128336, ST_NB_ACQ_438272#128337, ST_NB_FIC_438274#128338, ST_NB_FIC_H_438303#128339, ST_NB_IMA_438273#128340, ST_NB_IMA_H_438304#128341, ST_NB_SER_438271#128342, ST_NB_SER_H_438302#128343, ST_NOMDIC_438268#128344, ST_NUMCD_438300#128345, ST_NUMDEM_438283#128346, ST_NUMDOS_438282#128347, ST_NUMEXA_438297#128348, ST_NUMPER_438284#128349, ST_NUMPER_ORI_438308#128350, ST_NUMPER_ORI_S_438331#128351, ST_NUMPER_SEC_438330#128352, ST_NUMSTU_438260#128353, ST_NUM_ID_438262#128354, ST_OPERAT_438295#128355, ST_PATSEX_438292#128356, ST_PAT_ID_438288#128357, ST_PERPHY_438294#128358, ST_PNODIC_438269#128359, ST_POIDS_438325#128360, ST_RAPPRO_438281#128361, ST_RAPPRO_MANU_438320#128362, ST_READ_438310#128363, ST_REAPHY_438293#128364, ST_REFPHY_438290#128365, ST_SOP_UID_438313#128366, ST_STA_PPS_438312#128367, ST_STUDSC_438291#128368, ST_STUEFF_438275#128369, ST_STU_ID_438261#128370, ST_STU_ID_ORI_438332#128371, ST_SVCDEM_438301#128372, ST_TAIFIC_438296#128373, ST_TAIFIC_H_438305#128374, ST_TAILLE_438324#128375, ST_TYPNAT_438329#128376, ST_URGEN_438311#128377]
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#128305, ST_ADM_ID_438322#128306, ST_CACHE_438317#128307, ST_CODCHK_438326#128308, ST_CODCLI_438314#128309, ST_CODSER_438321#128310, ST_CODSIT_438315#128311, ST_CODUTI_438287#128312, ST_COMM_1_438278#128313, ST_COMM_2_438279#128314, ST_DATCHK_438327#128315, ST_DATEFF_438276#128316, ST_DATMAJ_438285#128317, ST_DATSTU_438263#128318, ST_DROIT_438280#128319, ST_D_NDIC_438270#128320, ST_FABRIQ_438266#128321, ST_FLCD_438298#128322, ST_FLDCD_438323#128323, ST_FLMANU_438307#128324, ST_HEUCHK_438328#128325, ST_HEUEFF_438277#128326, ST_HEUMAJ_438286#128327, ST_HEUSTU_438264#128328, ST_HIDDEN_438319#128329, ST_INSTIT_438267#128330, ST_INS_438316#128331, ST_INS_OID_438318#128332, ST_KEYWORD_438309#128333, ST_LIEU_438299#128334, ST_LOCKED_438306#128335, ST_MODALI_438265#128336, ST_NB_ACQ_438272#128337, ST_NB_FIC_438274#128338, ST_NB_FIC_H_438303#128339, ST_NB_IMA_438273#128340, ST_NB_IMA_H_438304#128341, ST_NB_SER_438271#128342, ST_NB_SER_H_438302#128343, ST_NOMDIC_438268#128344, ST_NUMCD_438300#128345, ST_NUMDEM_438283#128346, ST_NUMDOS_438282#128347, ST_NUMEXA_438297#128348, ST_NUMPER_438284#128349, ST_NUMPER_ORI_438308#128350, ST_NUMPER_ORI_S_438331#128351, ST_NUMPER_SEC_438330#128352, ST_NUMSTU_438260#128353, ST_NUM_ID_438262#128354, ST_OPERAT_438295#128355, ST_PATSEX_438292#128356, ST_PAT_ID_438288#128357, ST_PERPHY_438294#128358, ST_PNODIC_438269#128359, ST_POIDS_438325#128360, ST_RAPPRO_438281#128361, ST_RAPPRO_MANU_438320#128362, ST_READ_438310#128363, ST_REAPHY_438293#128364, ST_REFPHY_438290#128365, ST_SOP_UID_438313#128366, ST_STA_PPS_438312#128367, ST_STUDSC_438291#128368, ST_STUEFF_438275#128369, ST_STU_ID_438261#128370, ST_STU_ID_ORI_438332#128371, ST_SVCDEM_438301#128372, ST_TAIFIC_438296#128373, ST_TAIFIC_H_438305#128374, ST_TAILLE_438324#128375, ST_TYPNAT_438329#128376, ST_URGEN_438311#128377]

(3) Filter [codegen id : 1]
Input [73]: [ST_ACCNUM_438289#128305, ST_ADM_ID_438322#128306, ST_CACHE_438317#128307, ST_CODCHK_438326#128308, ST_CODCLI_438314#128309, ST_CODSER_438321#128310, ST_CODSIT_438315#128311, ST_CODUTI_438287#128312, ST_COMM_1_438278#128313, ST_COMM_2_438279#128314, ST_DATCHK_438327#128315, ST_DATEFF_438276#128316, ST_DATMAJ_438285#128317, ST_DATSTU_438263#128318, ST_DROIT_438280#128319, ST_D_NDIC_438270#128320, ST_FABRIQ_438266#128321, ST_FLCD_438298#128322, ST_FLDCD_438323#128323, ST_FLMANU_438307#128324, ST_HEUCHK_438328#128325, ST_HEUEFF_438277#128326, ST_HEUMAJ_438286#128327, ST_HEUSTU_438264#128328, ST_HIDDEN_438319#128329, ST_INSTIT_438267#128330, ST_INS_438316#128331, ST_INS_OID_438318#128332, ST_KEYWORD_438309#128333, ST_LIEU_438299#128334, ST_LOCKED_438306#128335, ST_MODALI_438265#128336, ST_NB_ACQ_438272#128337, ST_NB_FIC_438274#128338, ST_NB_FIC_H_438303#128339, ST_NB_IMA_438273#128340, ST_NB_IMA_H_438304#128341, ST_NB_SER_438271#128342, ST_NB_SER_H_438302#128343, ST_NOMDIC_438268#128344, ST_NUMCD_438300#128345, ST_NUMDEM_438283#128346, ST_NUMDOS_438282#128347, ST_NUMEXA_438297#128348, ST_NUMPER_438284#128349, ST_NUMPER_ORI_438308#128350, ST_NUMPER_ORI_S_438331#128351, ST_NUMPER_SEC_438330#128352, ST_NUMSTU_438260#128353, ST_NUM_ID_438262#128354, ST_OPERAT_438295#128355, ST_PATSEX_438292#128356, ST_PAT_ID_438288#128357, ST_PERPHY_438294#128358, ST_PNODIC_438269#128359, ST_POIDS_438325#128360, ST_RAPPRO_438281#128361, ST_RAPPRO_MANU_438320#128362, ST_READ_438310#128363, ST_REAPHY_438293#128364, ST_REFPHY_438290#128365, ST_SOP_UID_438313#128366, ST_STA_PPS_438312#128367, ST_STUDSC_438291#128368, ST_STUEFF_438275#128369, ST_STU_ID_438261#128370, ST_STU_ID_ORI_438332#128371, ST_SVCDEM_438301#128372, ST_TAIFIC_438296#128373, ST_TAIFIC_H_438305#128374, ST_TAILLE_438324#128375, ST_TYPNAT_438329#128376, ST_URGEN_438311#128377]
Condition : ((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(ST_NUMSTU_438260#128353)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_NUMSTU_438260#128353)), MARX) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_STU_ID_438261#128370)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_STU_ID_438261#128370)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_NUM_ID_438262#128354)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_NUM_ID_438262#128354)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_DATSTU_438263#128318)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_DATSTU_438263#128318)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_HEUSTU_438264#128328)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_HEUSTU_438264#128328)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_MODALI_438265#128336)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_MODALI_438265#128336)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_FABRIQ_438266#128321)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_FABRIQ_438266#128321)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_INSTIT_438267#128330)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_INSTIT_438267#128330)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_NOMDIC_438268#128344)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_NOMDIC_438268#128344)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_PNODIC_438269#128359)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_PNODIC_438269#128359)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_D_NDIC_438270#128320)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_D_NDIC_438270#128320)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_NB_SER_438271#128342)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_NB_SER_438271#128342)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_NB_ACQ_438272#128337)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_NB_ACQ_438272#128337)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_NB_IMA_438273#128340)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_NB_IMA_438273#128340)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_NB_FIC_438274#128338)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_NB_FIC_438274#128338)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_STUEFF_438275#128369)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_STUEFF_438275#128369)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_DATEFF_438276#128316)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_DATEFF_438276#128316)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_HEUEFF_438277#128326)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_HEUEFF_438277#128326)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_COMM_1_438278#128313)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_COMM_1_438278#128313)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_COMM_2_438279#128314)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_COMM_2_438279#128314)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_DROIT_438280#128319)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_DROIT_438280#128319)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_RAPPRO_438281#128361)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_RAPPRO_438281#128361)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_NUMDOS_438282#128347)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_NUMDOS_438282#128347)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_NUMDEM_438283#128346)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_NUMDEM_438283#128346)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_NUMPER_438284#128349)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_NUMPER_438284#128349)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_DATMAJ_438285#128317)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_DATMAJ_438285#128317)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_HEUMAJ_438286#128327)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_HEUMAJ_438286#128327)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_CODUTI_438287#128312)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_CODUTI_438287#128312)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_PAT_ID_438288#128357)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_PAT_ID_438288#128357)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_ACCNUM_438289#128305)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_ACCNUM_438289#128305)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_REFPHY_438290#128365)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_REFPHY_438290#128365)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_STUDSC_438291#128368)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_STUDSC_438291#128368)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_PATSEX_438292#128356)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_PATSEX_438292#128356)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_REAPHY_438293#128364)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_REAPHY_438293#128364)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_PERPHY_438294#128358)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_PERPHY_438294#128358)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_OPERAT_438295#128355)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_OPERAT_438295#128355)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_TAIFIC_438296#128373)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_TAIFIC_438296#128373)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_NUMEXA_438297#128348)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_NUMEXA_438297#128348)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_FLCD_438298#128322)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_FLCD_438298#128322)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_LIEU_438299#128334)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_LIEU_438299#128334)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_NUMCD_438300#128345)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_NUMCD_438300#128345)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_SVCDEM_438301#128372)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_SVCDEM_438301#128372)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_NB_SER_H_438302#128343)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_NB_SER_H_438302#128343)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_NB_FIC_H_438303#128339)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_NB_FIC_H_438303#128339)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_NB_IMA_H_438304#128341)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_NB_IMA_H_438304#128341)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_TAIFIC_H_438305#128374)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_TAIFIC_H_438305#128374)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_LOCKED_438306#128335)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_LOCKED_438306#128335)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_FLMANU_438307#128324)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_FLMANU_438307#128324)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_NUMPER_ORI_438308#128350)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_NUMPER_ORI_438308#128350)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_KEYWORD_438309#128333)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_KEYWORD_438309#128333)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_READ_438310#128363)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_READ_438310#128363)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_URGEN_438311#128377)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_URGEN_438311#128377)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_STA_PPS_438312#128367)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_STA_PPS_438312#128367)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_SOP_UID_438313#128366)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_SOP_UID_438313#128366)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_CODCLI_438314#128309)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_CODCLI_438314#128309)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_CODSIT_438315#128311)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_CODSIT_438315#128311)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_INS_438316#128331)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_INS_438316#128331)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_CACHE_438317#128307)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_CACHE_438317#128307)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_INS_OID_438318#128332)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_INS_OID_438318#128332)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_HIDDEN_438319#128329)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_HIDDEN_438319#128329)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_RAPPRO_MANU_438320#128362)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_RAPPRO_MANU_438320#128362)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_CODSER_438321#128310)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_CODSER_438321#128310)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_ADM_ID_438322#128306)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_ADM_ID_438322#128306)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_FLDCD_438323#128323)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_FLDCD_438323#128323)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_TAILLE_438324#128375)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_TAILLE_438324#128375)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_POIDS_438325#128360)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_POIDS_438325#128360)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_CODCHK_438326#128308)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_CODCHK_438326#128308)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_DATCHK_438327#128315)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_DATCHK_438327#128315)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_HEUCHK_438328#128325)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_HEUCHK_438328#128325)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_TYPNAT_438329#128376)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_TYPNAT_438329#128376)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_NUMPER_SEC_438330#128352)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_NUMPER_SEC_438330#128352)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_NUMPER_ORI_S_438331#128351)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_NUMPER_ORI_S_438331#128351)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(ST_STU_ID_ORI_438332#128371)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(ST_STU_ID_ORI_438332#128371)), MARX) END)

(4) Project [codegen id : 1]
Output [73]: [ST_NUMSTU_438260#128353 AS COL_F76F4CDE_E0D3_4FF1_A7D5_EED85C8B91F4#128743, ST_STU_ID_438261#128370 AS COL_8B493886_724B_4EDD_8F49_B6BB2E19668F#128744, ST_NUM_ID_438262#128354 AS COL_A55E3D6D_8CDE_4222_8FF1_ECC443E564AE#128745, ST_DATSTU_438263#128318 AS COL_C3B2BF6D_7B79_41F7_8EC6_52923A43CE6E#128746, ST_HEUSTU_438264#128328 AS COL_2CC438CE_3722_40AA_BF00_DC0425042340#128747, ST_MODALI_438265#128336 AS COL_132EC637_02C1_4CDC_B903_0BF75D86C3C7#128748, ST_FABRIQ_438266#128321 AS COL_8EC6E90A_7E8B_45A1_8A44_AE7B6FBAC71E#128749, ST_INSTIT_438267#128330 AS COL_242974CB_F9E0_40F5_8A8C_E3CE85281528#128750, ST_NOMDIC_438268#128344 AS COL_4FF428FC_3ECA_45FF_B6C7_E134C4E2DDB1#128751, ST_PNODIC_438269#128359 AS COL_52739C85_3489_41DE_94F4_E9D86B1F9112#128752, ST_D_NDIC_438270#128320 AS COL_8C97B9CF_F60A_4C43_A826_A3A5B21280D4#128753, ST_NB_SER_438271#128342 AS COL_1429265F_ED3F_4449_899C_95CC089232CB#128754, ST_NB_ACQ_438272#128337 AS COL_96A9B28E_2555_41A5_897C_4F1D56C89227#128755, ST_NB_IMA_438273#128340 AS COL_31CCA989_25E9_45C8_89D8_5AAAEDD7E6EB#128756, ST_NB_FIC_438274#128338 AS COL_304232C9_8AAC_4C8E_B1D2_1C851DD9723D#128757, ST_STUEFF_438275#128369 AS COL_CB736FBE_8A15_463B_A868_A7ABAB8AB425#128758, ST_DATEFF_438276#128316 AS COL_EBE1E448_E893_46AE_87D5_3659CC827B1C#128759, ST_HEUEFF_438277#128326 AS COL_AD1EE721_5D12_48B0_9F61_A35A42FA6D33#128760, ST_COMM_1_438278#128313 AS COL_EB30D5F0_1EF5_4FD3_B050_86FA885A88B6#128761, ST_COMM_2_438279#128314 AS COL_D9263A35_FF5A_4A7A_80DB_61CCE5774AD8#128762, ST_DROIT_438280#128319 AS COL_7FB1E95A_5A2E_4DDA_A44A_4BACAD5F7950#128763, ST_RAPPRO_438281#128361 AS COL_A53C203B_5DE1_49C2_BDB5_227C613F960E#128764, ST_NUMDOS_438282#128347 AS COL_61399AFB_D97E_4A4E_8D17_793054946775#128765, ST_NUMDEM_438283#128346 AS COL_6938C2EA_4AAA_4BF2_ADAC_76FA3320D3C0#128766, ST_NUMPER_438284#128349 AS COL_19E6E730_915E_4194_9710_F2BC4836D991#128767, ST_DATMAJ_438285#128317 AS COL_6485FFB5_24AB_4B1A_9AA4_EAD6BA1ED536#128768, ST_HEUMAJ_438286#128327 AS COL_D593EA72_032C_4A6C_9E76_98AA26145F9A#128769, ST_CODUTI_438287#128312 AS COL_66555087_3BB8_47FD_989F_9973019480B7#128770, ST_PAT_ID_438288#128357 AS COL_040680DF_80BB_4DCA_BE97_C5B5D8EE203D#128771, ST_ACCNUM_438289#128305 AS COL_9A42DAAF_938D_45EA_8D73_4B8FE2ED61BA#128772, ST_REFPHY_438290#128365 AS COL_199CCE33_2DCD_4135_BC16_A7D36D9963DD#128773, ST_STUDSC_438291#128368 AS COL_B3EF601D_1D44_445F_8BD5_B94C76490CAD#128774, ST_PATSEX_438292#128356 AS COL_6282D1EC_62E5_4391_B644_FD9CD42113D8#128775, ST_REAPHY_438293#128364 AS COL_53BA29A6_5CC3_4EFB_B894_E8908950EB2D#128776, ST_PERPHY_438294#128358 AS COL_B81D0247_6AE9_4879_97C5_4431A29CA0AB#128777, ST_OPERAT_438295#128355 AS COL_41878192_EA55_4CAE_85F1_1AFD1D8AA4F4#128778, ST_TAIFIC_438296#128373 AS COL_A3D06D18_9988_4CDF_9AE8_9FD06099CECE#128779, ST_NUMEXA_438297#128348 AS COL_BAD37149_78BE_475A_B1F3_CBC4993726A1#128780, ST_FLCD_438298#128322 AS COL_C583FE5C_08F3_4D42_93FC_6911EE5C0BA9#128781, ST_LIEU_438299#128334 AS COL_242C4AC5_EC3A_4730_8E8B_E4AAF6AA4F34#128782, ST_NUMCD_438300#128345 AS COL_AE752CF9_0FF7_45B9_8DF3_88490BD819A9#128783, ST_SVCDEM_438301#128372 AS COL_E91256EA_6106_4655_8F4E_9C72170E77B0#128784, ST_NB_SER_H_438302#128343 AS COL_2AE09594_38DF_4212_8032_F0A3E3651CDE#128785, ST_NB_FIC_H_438303#128339 AS COL_582754C6_F327_4303_BCE2_988BF710904A#128786, ST_NB_IMA_H_438304#128341 AS COL_9A3E7A5B_8CDB_4666_99E8_22B0494B7E08#128787, ST_TAIFIC_H_438305#128374 AS COL_C4897CF2_DB72_421C_885E_9957684DAF22#128788, ST_LOCKED_438306#128335 AS COL_209B2E74_9619_4461_BA8F_E548067D8ECB#128789, ST_FLMANU_438307#128324 AS COL_320A92E3_42A7_4254_B644_04BF1866C0A0#128790, ST_NUMPER_ORI_438308#128350 AS COL_F98BD2C7_4847_4A5E_A3FD_31107EA7962E#128791, ST_KEYWORD_438309#128333 AS COL_A69B92ED_7AA3_4E67_B7A3_6372CF121159#128792, ST_READ_438310#128363 AS COL_988D57A5_1BC8_4A36_911B_1C2EB46B9FF0#128793, ST_URGEN_438311#128377 AS COL_E5A23031_DD37_4EB0_B7F2_79A721F4A5CB#128794, ST_STA_PPS_438312#128367 AS COL_5DD6A3F7_846A_40E7_A5E2_56AF1F14609E#128795, ST_SOP_UID_438313#128366 AS COL_C70983CA_83EE_4F84_B003_F7686597C7BF#128796, ST_CODCLI_438314#128309 AS COL_473CEF1C_7FF7_44D9_91A1_2BCE87EA2578#128797, ST_CODSIT_438315#128311 AS COL_490B0F9A_C913_4C58_BCEF_47C0AD966F2E#128798, ST_INS_438316#128331 AS COL_7FFE4180_950A_40A3_8D1A_E68144A1366E#128799, ST_CACHE_438317#128307 AS COL_3995623E_218D_45D3_B114_299FA39835C2#128800, ST_INS_OID_438318#128332 AS COL_845F43B0_BFEA_4F0B_8B76_7FA016E6B163#128801, ST_HIDDEN_438319#128329 AS COL_F1D32F45_5AE7_463D_BC54_3E13068A5CF6#128802, ST_RAPPRO_MANU_438320#128362 AS COL_1B8A908B_4BDB_452C_B6B8_5B2C8E862D05#128803, ST_CODSER_438321#128310 AS COL_7023FEE8_9989_4C68_8FD8_5E00336EFD1E#128804, ST_ADM_ID_438322#128306 AS COL_5C51B33B_EB74_46BC_A924_7C78B0BD32D9#128805, ST_FLDCD_438323#128323 AS COL_85C241C5_3C06_46F4_A9EE_AA0C5F71D8A2#128806, ST_TAILLE_438324#128375 AS COL_61D4FA05_0BDA_40E4_BD0D_701DAEEF63E3#128807, ST_POIDS_438325#128360 AS COL_B034FD3E_A781_4452_AF18_EDCEB65BE3A4#128808, ST_CODCHK_438326#128308 AS COL_62B3F15A_2979_41BE_A4F7_285FCD66AC44#128809, ST_DATCHK_438327#128315 AS COL_DE708545_8072_4146_8E71_A7208802EBD4#128810, ST_HEUCHK_438328#128325 AS COL_5784EB9F_5158_4DCE_9320_0BBD70D67F2D#128811, ST_TYPNAT_438329#128376 AS COL_6200051D_5FBB_462A_9476_C83657E089B6#128812, ST_NUMPER_SEC_438330#128352 AS COL_5694825B_7D98_4523_BEC3_2FC55AE80E4E#128813, ST_NUMPER_ORI_S_438331#128351 AS COL_C273E0A6_C532_4B61_966B_8DF280291D26#128814, ST_STU_ID_ORI_438332#128371 AS COL_0AEEAE8B_44EA_4A3C_B6F5_0CFFB43CFB00#128815]
Input [73]: [ST_ACCNUM_438289#128305, ST_ADM_ID_438322#128306, ST_CACHE_438317#128307, ST_CODCHK_438326#128308, ST_CODCLI_438314#128309, ST_CODSER_438321#128310, ST_CODSIT_438315#128311, ST_CODUTI_438287#128312, ST_COMM_1_438278#128313, ST_COMM_2_438279#128314, ST_DATCHK_438327#128315, ST_DATEFF_438276#128316, ST_DATMAJ_438285#128317, ST_DATSTU_438263#128318, ST_DROIT_438280#128319, ST_D_NDIC_438270#128320, ST_FABRIQ_438266#128321, ST_FLCD_438298#128322, ST_FLDCD_438323#128323, ST_FLMANU_438307#128324, ST_HEUCHK_438328#128325, ST_HEUEFF_438277#128326, ST_HEUMAJ_438286#128327, ST_HEUSTU_438264#128328, ST_HIDDEN_438319#128329, ST_INSTIT_438267#128330, ST_INS_438316#128331, ST_INS_OID_438318#128332, ST_KEYWORD_438309#128333, ST_LIEU_438299#128334, ST_LOCKED_438306#128335, ST_MODALI_438265#128336, ST_NB_ACQ_438272#128337, ST_NB_FIC_438274#128338, ST_NB_FIC_H_438303#128339, ST_NB_IMA_438273#128340, ST_NB_IMA_H_438304#128341, ST_NB_SER_438271#128342, ST_NB_SER_H_438302#128343, ST_NOMDIC_438268#128344, ST_NUMCD_438300#128345, ST_NUMDEM_438283#128346, ST_NUMDOS_438282#128347, ST_NUMEXA_438297#128348, ST_NUMPER_438284#128349, ST_NUMPER_ORI_438308#128350, ST_NUMPER_ORI_S_438331#128351, ST_NUMPER_SEC_438330#128352, ST_NUMSTU_438260#128353, ST_NUM_ID_438262#128354, ST_OPERAT_438295#128355, ST_PATSEX_438292#128356, ST_PAT_ID_438288#128357, ST_PERPHY_438294#128358, ST_PNODIC_438269#128359, ST_POIDS_438325#128360, ST_RAPPRO_438281#128361, ST_RAPPRO_MANU_438320#128362, ST_READ_438310#128363, ST_REAPHY_438293#128364, ST_REFPHY_438290#128365, ST_SOP_UID_438313#128366, ST_STA_PPS_438312#128367, ST_STUDSC_438291#128368, ST_STUEFF_438275#128369, ST_STU_ID_438261#128370, ST_STU_ID_ORI_438332#128371, ST_SVCDEM_438301#128372, ST_TAIFIC_438296#128373, ST_TAIFIC_H_438305#128374, ST_TAILLE_438324#128375, ST_TYPNAT_438329#128376, ST_URGEN_438311#128377]

(5) CollectLimit
Input [73]: [COL_F76F4CDE_E0D3_4FF1_A7D5_EED85C8B91F4#128743, COL_8B493886_724B_4EDD_8F49_B6BB2E19668F#128744, COL_A55E3D6D_8CDE_4222_8FF1_ECC443E564AE#128745, COL_C3B2BF6D_7B79_41F7_8EC6_52923A43CE6E#128746, COL_2CC438CE_3722_40AA_BF00_DC0425042340#128747, COL_132EC637_02C1_4CDC_B903_0BF75D86C3C7#128748, COL_8EC6E90A_7E8B_45A1_8A44_AE7B6FBAC71E#128749, COL_242974CB_F9E0_40F5_8A8C_E3CE85281528#128750, COL_4FF428FC_3ECA_45FF_B6C7_E134C4E2DDB1#128751, COL_52739C85_3489_41DE_94F4_E9D86B1F9112#128752, COL_8C97B9CF_F60A_4C43_A826_A3A5B21280D4#128753, COL_1429265F_ED3F_4449_899C_95CC089232CB#128754, COL_96A9B28E_2555_41A5_897C_4F1D56C89227#128755, COL_31CCA989_25E9_45C8_89D8_5AAAEDD7E6EB#128756, COL_304232C9_8AAC_4C8E_B1D2_1C851DD9723D#128757, COL_CB736FBE_8A15_463B_A868_A7ABAB8AB425#128758, COL_EBE1E448_E893_46AE_87D5_3659CC827B1C#128759, COL_AD1EE721_5D12_48B0_9F61_A35A42FA6D33#128760, COL_EB30D5F0_1EF5_4FD3_B050_86FA885A88B6#128761, COL_D9263A35_FF5A_4A7A_80DB_61CCE5774AD8#128762, COL_7FB1E95A_5A2E_4DDA_A44A_4BACAD5F7950#128763, COL_A53C203B_5DE1_49C2_BDB5_227C613F960E#128764, COL_61399AFB_D97E_4A4E_8D17_793054946775#128765, COL_6938C2EA_4AAA_4BF2_ADAC_76FA3320D3C0#128766, COL_19E6E730_915E_4194_9710_F2BC4836D991#128767, COL_6485FFB5_24AB_4B1A_9AA4_EAD6BA1ED536#128768, COL_D593EA72_032C_4A6C_9E76_98AA26145F9A#128769, COL_66555087_3BB8_47FD_989F_9973019480B7#128770, COL_040680DF_80BB_4DCA_BE97_C5B5D8EE203D#128771, COL_9A42DAAF_938D_45EA_8D73_4B8FE2ED61BA#128772, COL_199CCE33_2DCD_4135_BC16_A7D36D9963DD#128773, COL_B3EF601D_1D44_445F_8BD5_B94C76490CAD#128774, COL_6282D1EC_62E5_4391_B644_FD9CD42113D8#128775, COL_53BA29A6_5CC3_4EFB_B894_E8908950EB2D#128776, COL_B81D0247_6AE9_4879_97C5_4431A29CA0AB#128777, COL_41878192_EA55_4CAE_85F1_1AFD1D8AA4F4#128778, COL_A3D06D18_9988_4CDF_9AE8_9FD06099CECE#128779, COL_BAD37149_78BE_475A_B1F3_CBC4993726A1#128780, COL_C583FE5C_08F3_4D42_93FC_6911EE5C0BA9#128781, COL_242C4AC5_EC3A_4730_8E8B_E4AAF6AA4F34#128782, COL_AE752CF9_0FF7_45B9_8DF3_88490BD819A9#128783, COL_E91256EA_6106_4655_8F4E_9C72170E77B0#128784, COL_2AE09594_38DF_4212_8032_F0A3E3651CDE#128785, COL_582754C6_F327_4303_BCE2_988BF710904A#128786, COL_9A3E7A5B_8CDB_4666_99E8_22B0494B7E08#128787, COL_C4897CF2_DB72_421C_885E_9957684DAF22#128788, COL_209B2E74_9619_4461_BA8F_E548067D8ECB#128789, COL_320A92E3_42A7_4254_B644_04BF1866C0A0#128790, COL_F98BD2C7_4847_4A5E_A3FD_31107EA7962E#128791, COL_A69B92ED_7AA3_4E67_B7A3_6372CF121159#128792, COL_988D57A5_1BC8_4A36_911B_1C2EB46B9FF0#128793, COL_E5A23031_DD37_4EB0_B7F2_79A721F4A5CB#128794, COL_5DD6A3F7_846A_40E7_A5E2_56AF1F14609E#128795, COL_C70983CA_83EE_4F84_B003_F7686597C7BF#128796, COL_473CEF1C_7FF7_44D9_91A1_2BCE87EA2578#128797, COL_490B0F9A_C913_4C58_BCEF_47C0AD966F2E#128798, COL_7FFE4180_950A_40A3_8D1A_E68144A1366E#128799, COL_3995623E_218D_45D3_B114_299FA39835C2#128800, COL_845F43B0_BFEA_4F0B_8B76_7FA016E6B163#128801, COL_F1D32F45_5AE7_463D_BC54_3E13068A5CF6#128802, COL_1B8A908B_4BDB_452C_B6B8_5B2C8E862D05#128803, COL_7023FEE8_9989_4C68_8FD8_5E00336EFD1E#128804, COL_5C51B33B_EB74_46BC_A924_7C78B0BD32D9#128805, COL_85C241C5_3C06_46F4_A9EE_AA0C5F71D8A2#128806, COL_61D4FA05_0BDA_40E4_BD0D_701DAEEF63E3#128807, COL_B034FD3E_A781_4452_AF18_EDCEB65BE3A4#128808, COL_62B3F15A_2979_41BE_A4F7_285FCD66AC44#128809, COL_DE708545_8072_4146_8E71_A7208802EBD4#128810, COL_5784EB9F_5158_4DCE_9320_0BBD70D67F2D#128811, COL_6200051D_5FBB_462A_9476_C83657E089B6#128812, COL_5694825B_7D98_4523_BEC3_2FC55AE80E4E#128813, COL_C273E0A6_C532_4B61_966B_8DF280291D26#128814, COL_0AEEAE8B_44EA_4A3C_B6F5_0CFFB43CFB00#128815]
Arguments: 1500

SQL / DataFrame Properties

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