hdh-spark-job - Details for Query 621

Submitted Time: 2026/10/21 21:33:38
Duration: 3 s
Succeeded Jobs: 559 561

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

digraph G { 0 [labelType="html" label=" CollectLimit "]; 1 [labelType="html" label=" Project "]; 2 [labelType="html" label="Filter number of output rows: 5"]; 3 [labelType="html" label="Scan parquet number of output rows: 17,658 number of files read: 1 metadata time: 0 ms size of files read: 4.5 MiB"]; 1->0; 2->1; 3->2; }

CollectLimit 1500

Project [CR_NUMCR_437325#130004 AS COL_2F91B5DB_079F_4007_8BBD_243DBA39EB8E#130586, CR_NUMDOS_437326#130007 AS COL_84DD70B2_7B79_492E_B0F4_F66E498F43D3#130587, CR_NOMDIC_437327#130001 AS COL_E3EE4BB2_7210_45F2_8B35_A032FB991B5D#130588, CR_NUMDEM_437328#130006 AS COL_E6184484_AF0B_4CD0_AB1C_A6384D23894D#130589, CR_NUMEXA_437329#130009 AS COL_7FD1AF9F_CA3E_4BB6_A332_30E20CFE349B#130590, CR_TYPDOC_437330#130044 AS COL_9858EDE6_855D_4522_B367_CE86D407FA1D#130591, CR_PRIOR_437331#130018 AS COL_F617F1AB_8500_4B96_8248_17029707DD6F#130592, CR_NOMDCR_437332#130000 AS COL_87EE67A0_4424_47D5_8584_0A55967CACF4#130593, CR_TAIDCR_437333#130040 AS COL_F87F69C4_4CF4_46EF_826D_4553225669FA#130594, CR_DURDCR_437334#129971 AS COL_8E101077_1161_4F3F_B5E5_76C5FC2B405D#130595, CR_POSDCR_437335#130017 AS COL_F55B34B1_B4A1_46C5_9877_B1786A37E194#130596, CR_NOMDOS_437336#130002 AS COL_5294B4F8_17C6_4E4A_858F_0B62BDBB8D88#130597, CR_FOR_CR_437337#129978 AS COL_BD8EA799_C46A_4567_AEE6_2FBEE19A043C#130598, CR_CR_437338#129954 AS COL_A424645F_FC5F_48DA_A88D_2F986BF0A6D4#130599, CR_STATDIC_437339#130028 AS COL_C270B0E8_6D76_466E_A97C_DB7F6E593944#130600, CR_STATSM_437340#130029 AS COL_D26522E4_E641_442D_B0BE_189CB276280D#130601, CR_STATCR_437341#130027 AS COL_BDF321A4_7AB2_4724_A531_D7291599C407#130602, CR_CODDIC_437342#129943 AS COL_54C55853_7E31_4B13_A724_A42C1A4EDEBC#130603, CR_CONTEXT_437343#129953 AS COL_1BDF04DB_C91D_4BD8_85C8_B48A03406BB5#130604, CR_DATDIC_437344#129957 AS COL_B4DD9C4C_11DF_4CA1_87E0_C76ED85E5C1D#130605, CR_HEUDIC_437345#129981 AS COL_250169E8_981D_4998_A0C2_1F9CBA240794#130606, CR_HEUI_D_437346#129983 AS COL_4A08FC67_7743_4048_9446_DB3F3BB9B98E#130607, CR_HEUI_F_437347#129984 AS COL_18D3C547_569A_4684_A4A1_3EBFE8482A5B#130608, CR_CODSEC_437348#129948 AS COL_A5FFE858_64A8_40F5_8F72_E64A836D3A56#130609, ... 84 more fields]

Filter (((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(CR_NUMCR_437325#130004)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_NUMCR_437325#130004)), MARX) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_NUMDOS_437326#130007)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_NUMDOS_437326#130007)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_NOMDIC_437327#130001)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_NOMDIC_437327#130001)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_NUMDEM_437328#130006)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_NUMDEM_437328#130006)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_NUMEXA_437329#130009)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_NUMEXA_437329#130009)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_TYPDOC_437330#130044)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_TYPDOC_437330#130044)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_PRIOR_437331#130018)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_PRIOR_437331#130018)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_NOMDCR_437332#130000)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_NOMDCR_437332#130000)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_TAIDCR_437333#130040)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_TAIDCR_437333#130040)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_DURDCR_437334#129971)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_DURDCR_437334#129971)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_POSDCR_437335#130017)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_POSDCR_437335#130017)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_NOMDOS_437336#130002)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_NOMDOS_437336#130002)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_FOR_CR_437337#129978)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_FOR_CR_437337#129978)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_CR_437338#129954)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_CR_437338#129954)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_STATDIC_437339#130028)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_STATDIC_437339#130028)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_STATSM_437340#130029)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_STATSM_437340#130029)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_STATCR_437341#130027)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_STATCR_437341#130027)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_CODDIC_437342#129943)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_CODDIC_437342#129943)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_CONTEXT_437343#129953)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_CONTEXT_437343#129953)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_DATDIC_437344#129957)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_DATDIC_437344#129957)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_HEUDIC_437345#129981)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_HEUDIC_437345#129981)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_HEUI_D_437346#129983)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_HEUI_D_437346#129983)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_HEUI_F_437347#129984)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_HEUI_F_437347#129984)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_CODSEC_437348#129948)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_CODSEC_437348#129948)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_DATSEC_437349#129963)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_DATSEC_437349#129963)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_HEUSEC_437350#129987)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_HEUSEC_437350#129987)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_CODVCR_437351#129952)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_CODVCR_437351#129952)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_DATVCR_437352#129965)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_DATVCR_437352#129965)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_HEUVCR_437353#129989)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_HEUVCR_437353#129989)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_CODDCR_437354#129942)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_CODDCR_437354#129942)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_DATDCR_437355#129956)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_DATDCR_437355#129956)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_HEUDCR_437356#129980)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_HEUDCR_437356#129980)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_DAT_EFF_D_437357#129968)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_DAT_EFF_D_437357#129968)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_DAT_EFF_W_437358#129969)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_DAT_EFF_W_437358#129969)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_CODUTI_437359#129951)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_CODUTI_437359#129951)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_DATMAJ_437360#129960)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_DATMAJ_437360#129960)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_CODSIT_437361#129949)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_CODSIT_437361#129949)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_SECTRA_437362#130023)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_SECTRA_437362#130023)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_TYPCR_437363#130042)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_TYPCR_437363#130042)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_CODSUP_437364#129950)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_CODSUP_437364#129950)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_NIVVCR_437365#129999)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_NIVVCR_437365#129999)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_NUMVCR_437366#130012)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_NUMVCR_437366#130012)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_NB_COR_437367#129997)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_NB_COR_437367#129997)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_DATSUP_437368#129964)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_DATSUP_437368#129964)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_HEUSUP_437369#129988)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_HEUSUP_437369#129988)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_FLARCH_437370#129972)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_FLARCH_437370#129972)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_STAEXT_437371#130026)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_STAEXT_437371#130026)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_FLIMPR_437372#129974)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_FLIMPR_437372#129974)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_LOCKCR_437373#129994)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_LOCKCR_437373#129994)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_CODMCR_437374#129947)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_CODMCR_437374#129947)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_DATMCR_437375#129961)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_DATMCR_437375#129961)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_HEUMCR_437376#129986)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_HEUMCR_437376#129986)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_CODACC_437377#129940)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_CODACC_437377#129940)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_MOTPAS_437378#129995)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_MOTPAS_437378#129995)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_LIBCO_437379#129993)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_LIBCO_437379#129993)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_SUBDIC_437380#130037)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_SUBDIC_437380#130037)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_SUBDIR_437381#130038)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_SUBDIR_437381#130038)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_NUMPRT_437382#130011)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_NUMPRT_437382#130011)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_STA_ENV_PRT_437383#130033)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_STA_ENV_PRT_437383#130033)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_STA_RET_PRO_437384#130036)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_STA_RET_PRO_437384#130036)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_STA_ENV_FRA_437385#130032)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_STA_ENV_FRA_437385#130032)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_STA_RET_FRA_437386#130035)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_STA_RET_FRA_437386#130035)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_CODCLI_437387#129941)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_CODCLI_437387#129941)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_PRI_DIC_437388#130019)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_PRI_DIC_437388#130019)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_DAT_DIC_TRA_437389#129967)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_DAT_DIC_TRA_437389#129967)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_HEU_DIC_TRA_437390#129991)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_HEU_DIC_TRA_437390#129991)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_CODFRA_437391#129945)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_CODFRA_437391#129945)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_SECEXT_437392#130022)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_SECEXT_437392#130022)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_STATUT_EXT_437393#130030)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_STATUT_EXT_437393#130030)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_SIMP_JOB_ID_437394#130024)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_SIMP_JOB_ID_437394#130024)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_DAT_CR_INT_437395#129966)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_DAT_CR_INT_437395#129966)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_HEU_CR_INT_437396#129990)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_HEU_CR_INT_437396#129990)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_DELAI_TOTAL_437397#129970)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_DELAI_TOTAL_437397#129970)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_NB_LIGNE_EXT_437398#129998)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_NB_LIGNE_EXT_437398#129998)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_NB_CAR_EXT_437399#129996)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_NB_CAR_EXT_437399#129996)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_NOMEXT_437400#130003)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_NOMEXT_437400#130003)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_SUBEXT_437401#130039)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_SUBEXT_437401#130039)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_FLTBDI_437402#129976)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_FLTBDI_437402#129976)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_TYPDIC_437403#130043)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_TYPDIC_437403#130043)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_STA_ENV_ACK_437404#130031)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_STA_ENV_ACK_437404#130031)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_STA_RET_ACK_437405#130034)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_STA_RET_ACK_437405#130034)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_TAILLE_DIC_437406#130041)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_TAILLE_DIC_437406#130041)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_CHKSUM_DIC_437407#129939)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_CHKSUM_DIC_437407#129939)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_DATMAIL_437408#129959)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_DATMAIL_437408#129959)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_HEUMAIL_437409#129985)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_HEUMAIL_437409#129985)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_CODMAIL_437410#129946)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_CODMAIL_437410#129946)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_STADMP_437411#130025)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_STADMP_437411#130025)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_CODDMP_437412#129944)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_CODDMP_437412#129944)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_DATDMP_437413#129958)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_DATDMP_437413#129958)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_HEUDMP_437414#129982)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_HEUDMP_437414#129982)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_OIDDMP_437415#130013)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_OIDDMP_437415#130013)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_VISDMP_437416#130045)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_VISDMP_437416#130045)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_SCNPAT_437417#130021)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_SCNPAT_437417#130021)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_DATSCN_437418#129962)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_DATSCN_437418#129962)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_NUMMCR_437419#130010)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_NUMMCR_437419#130010)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_NUMCR_CLOUD_437420#130005)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_NUMCR_CLOUD_437420#130005)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_NUMDRV_437421#130008)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_NUMDRV_437421#130008)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_FLARCH_D_437422#129973)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_FLARCH_D_437422#129973)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_REFEXT_437423#130020)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_REFEXT_437423#130020)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_ANNONCE_437424#129938)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_ANNONCE_437424#129938)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_PERIPH_437425#130016)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_PERIPH_437425#130016)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_DATCRE_437426#129955)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_DATCRE_437426#129955)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_HEUCRE_437427#129979)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_HEUCRE_437427#129979)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_ORIGINE_437428#130015)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_ORIGINE_437428#130015)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_OID_437429#130014)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_OID_437429#130014)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_FLORDO_437430#129975)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_FLORDO_437430#129975)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_IDCDA_437431#129992)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_IDCDA_437431#129992)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_FLTR_437432#129977)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_FLTR_437432#129977)), MARX) END)

FileScan parquet [CR_ANNONCE_437424#129938,CR_CHKSUM_DIC_437407#129939,CR_CODACC_437377#129940,CR_CODCLI_437387#129941,CR_CODDCR_437354#129942,CR_CODDIC_437342#129943,CR_CODDMP_437412#129944,CR_CODFRA_437391#129945,CR_CODMAIL_437410#129946,CR_CODMCR_437374#129947,CR_CODSEC_437348#129948,CR_CODSIT_437361#129949,CR_CODSUP_437364#129950,CR_CODUTI_437359#129951,CR_CODVCR_437351#129952,CR_CONTEXT_437343#129953,CR_CR_437338#129954,CR_DATCRE_437426#129955,CR_DATDCR_437355#129956,CR_DATDIC_437344#129957,CR_DATDMP_437413#129958,CR_DATMAIL_437408#129959,CR_DATMAJ_437360#129960,CR_DATMCR_437375#129961,... 84 more fields] Batched: false, DataFilters: [((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((..., Format: Parquet, Location: InMemoryFileIndex(1 paths)[file:/data/output/cache/parquet/uet/H_CR_437324], PartitionFilters: [], PushedFilters: [], ReadSchema: struct<CR_ANNONCE_437424:string,CR_CHKSUM_DIC_437407:string,CR_CODACC_437377:string,CR_CODCLI_437...

Details

== Physical Plan ==
CollectLimit (4)
+- Project (3)
   +- Filter (2)
      +- Scan parquet  (1)


(1) Scan parquet 
Output [108]: [CR_ANNONCE_437424#129938, CR_CHKSUM_DIC_437407#129939, CR_CODACC_437377#129940, CR_CODCLI_437387#129941, CR_CODDCR_437354#129942, CR_CODDIC_437342#129943, CR_CODDMP_437412#129944, CR_CODFRA_437391#129945, CR_CODMAIL_437410#129946, CR_CODMCR_437374#129947, CR_CODSEC_437348#129948, CR_CODSIT_437361#129949, CR_CODSUP_437364#129950, CR_CODUTI_437359#129951, CR_CODVCR_437351#129952, CR_CONTEXT_437343#129953, CR_CR_437338#129954, CR_DATCRE_437426#129955, CR_DATDCR_437355#129956, CR_DATDIC_437344#129957, CR_DATDMP_437413#129958, CR_DATMAIL_437408#129959, CR_DATMAJ_437360#129960, CR_DATMCR_437375#129961, CR_DATSCN_437418#129962, CR_DATSEC_437349#129963, CR_DATSUP_437368#129964, CR_DATVCR_437352#129965, CR_DAT_CR_INT_437395#129966, CR_DAT_DIC_TRA_437389#129967, CR_DAT_EFF_D_437357#129968, CR_DAT_EFF_W_437358#129969, CR_DELAI_TOTAL_437397#129970, CR_DURDCR_437334#129971, CR_FLARCH_437370#129972, CR_FLARCH_D_437422#129973, CR_FLIMPR_437372#129974, CR_FLORDO_437430#129975, CR_FLTBDI_437402#129976, CR_FLTR_437432#129977, CR_FOR_CR_437337#129978, CR_HEUCRE_437427#129979, CR_HEUDCR_437356#129980, CR_HEUDIC_437345#129981, CR_HEUDMP_437414#129982, CR_HEUI_D_437346#129983, CR_HEUI_F_437347#129984, CR_HEUMAIL_437409#129985, CR_HEUMCR_437376#129986, CR_HEUSEC_437350#129987, CR_HEUSUP_437369#129988, CR_HEUVCR_437353#129989, CR_HEU_CR_INT_437396#129990, CR_HEU_DIC_TRA_437390#129991, CR_IDCDA_437431#129992, CR_LIBCO_437379#129993, CR_LOCKCR_437373#129994, CR_MOTPAS_437378#129995, CR_NB_CAR_EXT_437399#129996, CR_NB_COR_437367#129997, CR_NB_LIGNE_EXT_437398#129998, CR_NIVVCR_437365#129999, CR_NOMDCR_437332#130000, CR_NOMDIC_437327#130001, CR_NOMDOS_437336#130002, CR_NOMEXT_437400#130003, CR_NUMCR_437325#130004, CR_NUMCR_CLOUD_437420#130005, CR_NUMDEM_437328#130006, CR_NUMDOS_437326#130007, CR_NUMDRV_437421#130008, CR_NUMEXA_437329#130009, CR_NUMMCR_437419#130010, CR_NUMPRT_437382#130011, CR_NUMVCR_437366#130012, CR_OIDDMP_437415#130013, CR_OID_437429#130014, CR_ORIGINE_437428#130015, CR_PERIPH_437425#130016, CR_POSDCR_437335#130017, CR_PRIOR_437331#130018, CR_PRI_DIC_437388#130019, CR_REFEXT_437423#130020, CR_SCNPAT_437417#130021, CR_SECEXT_437392#130022, CR_SECTRA_437362#130023, CR_SIMP_JOB_ID_437394#130024, CR_STADMP_437411#130025, CR_STAEXT_437371#130026, CR_STATCR_437341#130027, CR_STATDIC_437339#130028, CR_STATSM_437340#130029, CR_STATUT_EXT_437393#130030, CR_STA_ENV_ACK_437404#130031, CR_STA_ENV_FRA_437385#130032, CR_STA_ENV_PRT_437383#130033, CR_STA_RET_ACK_437405#130034, CR_STA_RET_FRA_437386#130035, CR_STA_RET_PRO_437384#130036, CR_SUBDIC_437380#130037, CR_SUBDIR_437381#130038, CR_SUBEXT_437401#130039, CR_TAIDCR_437333#130040, CR_TAILLE_DIC_437406#130041, CR_TYPCR_437363#130042, CR_TYPDIC_437403#130043, CR_TYPDOC_437330#130044, CR_VISDMP_437416#130045]
Batched: false
Location: InMemoryFileIndex [file:/data/output/cache/parquet/uet/H_CR_437324]
ReadSchema: struct<CR_ANNONCE_437424:string,CR_CHKSUM_DIC_437407:string,CR_CODACC_437377:string,CR_CODCLI_437387:string,CR_CODDCR_437354:string,CR_CODDIC_437342:string,CR_CODDMP_437412:string,CR_CODFRA_437391:string,CR_CODMAIL_437410:string,CR_CODMCR_437374:string,CR_CODSEC_437348:string,CR_CODSIT_437361:string,CR_CODSUP_437364:string,CR_CODUTI_437359:string,CR_CODVCR_437351:string,CR_CONTEXT_437343:string,CR_CR_437338:string,CR_DATCRE_437426:string,CR_DATDCR_437355:string,CR_DATDIC_437344:string,CR_DATDMP_437413:string,CR_DATMAIL_437408:string,CR_DATMAJ_437360:string,CR_DATMCR_437375:string,CR_DATSCN_437418:string,CR_DATSEC_437349:string,CR_DATSUP_437368:string,CR_DATVCR_437352:string,CR_DAT_CR_INT_437395:string,CR_DAT_DIC_TRA_437389:string,CR_DAT_EFF_D_437357:string,CR_DAT_EFF_W_437358:string,CR_DELAI_TOTAL_437397:string,CR_DURDCR_437334:string,CR_FLARCH_437370:string,CR_FLARCH_D_437422:string,CR_FLIMPR_437372:string,CR_FLORDO_437430:string,CR_FLTBDI_437402:string,CR_FLTR_437432:string,CR_FOR_CR_437337:string,CR_HEUCRE_437427:string,CR_HEUDCR_437356:string,CR_HEUDIC_437345:string,CR_HEUDMP_437414:string,CR_HEUI_D_437346:string,CR_HEUI_F_437347:string,CR_HEUMAIL_437409:string,CR_HEUMCR_437376:string,CR_HEUSEC_437350:string,CR_HEUSUP_437369:string,CR_HEUVCR_437353:string,CR_HEU_CR_INT_437396:string,CR_HEU_DIC_TRA_437390:string,CR_IDCDA_437431:string,CR_LIBCO_437379:string,CR_LOCKCR_437373:string,CR_MOTPAS_437378:string,CR_NB_CAR_EXT_437399:string,CR_NB_COR_437367:string,CR_NB_LIGNE_EXT_437398:string,CR_NIVVCR_437365:string,CR_NOMDCR_437332:string,CR_NOMDIC_437327:string,CR_NOMDOS_437336:string,CR_NOMEXT_437400:string,CR_NUMCR_437325:string,CR_NUMCR_CLOUD_437420:string,CR_NUMDEM_437328:string,CR_NUMDOS_437326:string,CR_NUMDRV_437421:string,CR_NUMEXA_437329:string,CR_NUMMCR_437419:string,CR_NUMPRT_437382:string,CR_NUMVCR_437366:string,CR_OIDDMP_437415:string,CR_OID_437429:string,CR_ORIGINE_437428:string,CR_PERIPH_437425:string,CR_POSDCR_437335:string,CR_PRIOR_437331:string,CR_PRI_DIC_437388:string,CR_REFEXT_437423:string,CR_SCNPAT_437417:string,CR_SECEXT_437392:string,CR_SECTRA_437362:string,CR_SIMP_JOB_ID_437394:string,CR_STADMP_437411:string,CR_STAEXT_437371:string,CR_STATCR_437341:string,CR_STATDIC_437339:string,CR_STATSM_437340:string,CR_STATUT_EXT_437393:string,CR_STA_ENV_ACK_437404:string,CR_STA_ENV_FRA_437385:string,CR_STA_ENV_PRT_437383:string,CR_STA_RET_ACK_437405:string,CR_STA_RET_FRA_437386:string,CR_STA_RET_PRO_437384:string,CR_SUBDIC_437380:string,CR_SUBDIR_437381:string,CR_SUBEXT_437401:string,CR_TAIDCR_437333:string,CR_TAILLE_DIC_437406:string,CR_TYPCR_437363:string,CR_TYPDIC_437403:string,CR_TYPDOC_437330:string,CR_VISDMP_437416:string>

(2) Filter
Input [108]: [CR_ANNONCE_437424#129938, CR_CHKSUM_DIC_437407#129939, CR_CODACC_437377#129940, CR_CODCLI_437387#129941, CR_CODDCR_437354#129942, CR_CODDIC_437342#129943, CR_CODDMP_437412#129944, CR_CODFRA_437391#129945, CR_CODMAIL_437410#129946, CR_CODMCR_437374#129947, CR_CODSEC_437348#129948, CR_CODSIT_437361#129949, CR_CODSUP_437364#129950, CR_CODUTI_437359#129951, CR_CODVCR_437351#129952, CR_CONTEXT_437343#129953, CR_CR_437338#129954, CR_DATCRE_437426#129955, CR_DATDCR_437355#129956, CR_DATDIC_437344#129957, CR_DATDMP_437413#129958, CR_DATMAIL_437408#129959, CR_DATMAJ_437360#129960, CR_DATMCR_437375#129961, CR_DATSCN_437418#129962, CR_DATSEC_437349#129963, CR_DATSUP_437368#129964, CR_DATVCR_437352#129965, CR_DAT_CR_INT_437395#129966, CR_DAT_DIC_TRA_437389#129967, CR_DAT_EFF_D_437357#129968, CR_DAT_EFF_W_437358#129969, CR_DELAI_TOTAL_437397#129970, CR_DURDCR_437334#129971, CR_FLARCH_437370#129972, CR_FLARCH_D_437422#129973, CR_FLIMPR_437372#129974, CR_FLORDO_437430#129975, CR_FLTBDI_437402#129976, CR_FLTR_437432#129977, CR_FOR_CR_437337#129978, CR_HEUCRE_437427#129979, CR_HEUDCR_437356#129980, CR_HEUDIC_437345#129981, CR_HEUDMP_437414#129982, CR_HEUI_D_437346#129983, CR_HEUI_F_437347#129984, CR_HEUMAIL_437409#129985, CR_HEUMCR_437376#129986, CR_HEUSEC_437350#129987, CR_HEUSUP_437369#129988, CR_HEUVCR_437353#129989, CR_HEU_CR_INT_437396#129990, CR_HEU_DIC_TRA_437390#129991, CR_IDCDA_437431#129992, CR_LIBCO_437379#129993, CR_LOCKCR_437373#129994, CR_MOTPAS_437378#129995, CR_NB_CAR_EXT_437399#129996, CR_NB_COR_437367#129997, CR_NB_LIGNE_EXT_437398#129998, CR_NIVVCR_437365#129999, CR_NOMDCR_437332#130000, CR_NOMDIC_437327#130001, CR_NOMDOS_437336#130002, CR_NOMEXT_437400#130003, CR_NUMCR_437325#130004, CR_NUMCR_CLOUD_437420#130005, CR_NUMDEM_437328#130006, CR_NUMDOS_437326#130007, CR_NUMDRV_437421#130008, CR_NUMEXA_437329#130009, CR_NUMMCR_437419#130010, CR_NUMPRT_437382#130011, CR_NUMVCR_437366#130012, CR_OIDDMP_437415#130013, CR_OID_437429#130014, CR_ORIGINE_437428#130015, CR_PERIPH_437425#130016, CR_POSDCR_437335#130017, CR_PRIOR_437331#130018, CR_PRI_DIC_437388#130019, CR_REFEXT_437423#130020, CR_SCNPAT_437417#130021, CR_SECEXT_437392#130022, CR_SECTRA_437362#130023, CR_SIMP_JOB_ID_437394#130024, CR_STADMP_437411#130025, CR_STAEXT_437371#130026, CR_STATCR_437341#130027, CR_STATDIC_437339#130028, CR_STATSM_437340#130029, CR_STATUT_EXT_437393#130030, CR_STA_ENV_ACK_437404#130031, CR_STA_ENV_FRA_437385#130032, CR_STA_ENV_PRT_437383#130033, CR_STA_RET_ACK_437405#130034, CR_STA_RET_FRA_437386#130035, CR_STA_RET_PRO_437384#130036, CR_SUBDIC_437380#130037, CR_SUBDIR_437381#130038, CR_SUBEXT_437401#130039, CR_TAIDCR_437333#130040, CR_TAILLE_DIC_437406#130041, CR_TYPCR_437363#130042, CR_TYPDIC_437403#130043, CR_TYPDOC_437330#130044, CR_VISDMP_437416#130045]
Condition : (((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(CR_NUMCR_437325#130004)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_NUMCR_437325#130004)), MARX) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_NUMDOS_437326#130007)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_NUMDOS_437326#130007)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_NOMDIC_437327#130001)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_NOMDIC_437327#130001)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_NUMDEM_437328#130006)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_NUMDEM_437328#130006)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_NUMEXA_437329#130009)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_NUMEXA_437329#130009)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_TYPDOC_437330#130044)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_TYPDOC_437330#130044)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_PRIOR_437331#130018)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_PRIOR_437331#130018)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_NOMDCR_437332#130000)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_NOMDCR_437332#130000)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_TAIDCR_437333#130040)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_TAIDCR_437333#130040)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_DURDCR_437334#129971)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_DURDCR_437334#129971)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_POSDCR_437335#130017)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_POSDCR_437335#130017)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_NOMDOS_437336#130002)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_NOMDOS_437336#130002)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_FOR_CR_437337#129978)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_FOR_CR_437337#129978)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_CR_437338#129954)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_CR_437338#129954)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_STATDIC_437339#130028)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_STATDIC_437339#130028)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_STATSM_437340#130029)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_STATSM_437340#130029)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_STATCR_437341#130027)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_STATCR_437341#130027)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_CODDIC_437342#129943)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_CODDIC_437342#129943)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_CONTEXT_437343#129953)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_CONTEXT_437343#129953)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_DATDIC_437344#129957)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_DATDIC_437344#129957)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_HEUDIC_437345#129981)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_HEUDIC_437345#129981)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_HEUI_D_437346#129983)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_HEUI_D_437346#129983)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_HEUI_F_437347#129984)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_HEUI_F_437347#129984)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_CODSEC_437348#129948)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_CODSEC_437348#129948)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_DATSEC_437349#129963)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_DATSEC_437349#129963)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_HEUSEC_437350#129987)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_HEUSEC_437350#129987)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_CODVCR_437351#129952)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_CODVCR_437351#129952)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_DATVCR_437352#129965)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_DATVCR_437352#129965)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_HEUVCR_437353#129989)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_HEUVCR_437353#129989)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_CODDCR_437354#129942)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_CODDCR_437354#129942)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_DATDCR_437355#129956)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_DATDCR_437355#129956)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_HEUDCR_437356#129980)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_HEUDCR_437356#129980)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_DAT_EFF_D_437357#129968)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_DAT_EFF_D_437357#129968)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_DAT_EFF_W_437358#129969)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_DAT_EFF_W_437358#129969)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_CODUTI_437359#129951)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_CODUTI_437359#129951)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_DATMAJ_437360#129960)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_DATMAJ_437360#129960)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_CODSIT_437361#129949)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_CODSIT_437361#129949)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_SECTRA_437362#130023)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_SECTRA_437362#130023)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_TYPCR_437363#130042)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_TYPCR_437363#130042)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_CODSUP_437364#129950)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_CODSUP_437364#129950)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_NIVVCR_437365#129999)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_NIVVCR_437365#129999)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_NUMVCR_437366#130012)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_NUMVCR_437366#130012)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_NB_COR_437367#129997)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_NB_COR_437367#129997)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_DATSUP_437368#129964)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_DATSUP_437368#129964)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_HEUSUP_437369#129988)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_HEUSUP_437369#129988)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_FLARCH_437370#129972)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_FLARCH_437370#129972)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_STAEXT_437371#130026)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_STAEXT_437371#130026)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_FLIMPR_437372#129974)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_FLIMPR_437372#129974)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_LOCKCR_437373#129994)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_LOCKCR_437373#129994)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_CODMCR_437374#129947)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_CODMCR_437374#129947)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_DATMCR_437375#129961)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_DATMCR_437375#129961)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_HEUMCR_437376#129986)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_HEUMCR_437376#129986)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_CODACC_437377#129940)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_CODACC_437377#129940)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_MOTPAS_437378#129995)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_MOTPAS_437378#129995)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_LIBCO_437379#129993)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_LIBCO_437379#129993)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_SUBDIC_437380#130037)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_SUBDIC_437380#130037)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_SUBDIR_437381#130038)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_SUBDIR_437381#130038)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_NUMPRT_437382#130011)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_NUMPRT_437382#130011)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_STA_ENV_PRT_437383#130033)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_STA_ENV_PRT_437383#130033)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_STA_RET_PRO_437384#130036)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_STA_RET_PRO_437384#130036)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_STA_ENV_FRA_437385#130032)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_STA_ENV_FRA_437385#130032)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_STA_RET_FRA_437386#130035)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_STA_RET_FRA_437386#130035)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_CODCLI_437387#129941)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_CODCLI_437387#129941)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_PRI_DIC_437388#130019)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_PRI_DIC_437388#130019)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_DAT_DIC_TRA_437389#129967)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_DAT_DIC_TRA_437389#129967)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_HEU_DIC_TRA_437390#129991)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_HEU_DIC_TRA_437390#129991)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_CODFRA_437391#129945)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_CODFRA_437391#129945)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_SECEXT_437392#130022)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_SECEXT_437392#130022)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_STATUT_EXT_437393#130030)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_STATUT_EXT_437393#130030)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_SIMP_JOB_ID_437394#130024)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_SIMP_JOB_ID_437394#130024)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_DAT_CR_INT_437395#129966)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_DAT_CR_INT_437395#129966)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_HEU_CR_INT_437396#129990)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_HEU_CR_INT_437396#129990)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_DELAI_TOTAL_437397#129970)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_DELAI_TOTAL_437397#129970)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_NB_LIGNE_EXT_437398#129998)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_NB_LIGNE_EXT_437398#129998)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_NB_CAR_EXT_437399#129996)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_NB_CAR_EXT_437399#129996)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_NOMEXT_437400#130003)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_NOMEXT_437400#130003)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_SUBEXT_437401#130039)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_SUBEXT_437401#130039)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_FLTBDI_437402#129976)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_FLTBDI_437402#129976)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_TYPDIC_437403#130043)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_TYPDIC_437403#130043)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_STA_ENV_ACK_437404#130031)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_STA_ENV_ACK_437404#130031)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_STA_RET_ACK_437405#130034)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_STA_RET_ACK_437405#130034)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_TAILLE_DIC_437406#130041)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_TAILLE_DIC_437406#130041)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_CHKSUM_DIC_437407#129939)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_CHKSUM_DIC_437407#129939)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_DATMAIL_437408#129959)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_DATMAIL_437408#129959)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_HEUMAIL_437409#129985)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_HEUMAIL_437409#129985)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_CODMAIL_437410#129946)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_CODMAIL_437410#129946)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_STADMP_437411#130025)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_STADMP_437411#130025)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_CODDMP_437412#129944)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_CODDMP_437412#129944)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_DATDMP_437413#129958)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_DATDMP_437413#129958)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_HEUDMP_437414#129982)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_HEUDMP_437414#129982)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_OIDDMP_437415#130013)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_OIDDMP_437415#130013)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_VISDMP_437416#130045)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_VISDMP_437416#130045)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_SCNPAT_437417#130021)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_SCNPAT_437417#130021)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_DATSCN_437418#129962)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_DATSCN_437418#129962)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_NUMMCR_437419#130010)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_NUMMCR_437419#130010)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_NUMCR_CLOUD_437420#130005)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_NUMCR_CLOUD_437420#130005)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_NUMDRV_437421#130008)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_NUMDRV_437421#130008)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_FLARCH_D_437422#129973)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_FLARCH_D_437422#129973)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_REFEXT_437423#130020)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_REFEXT_437423#130020)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_ANNONCE_437424#129938)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_ANNONCE_437424#129938)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_PERIPH_437425#130016)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_PERIPH_437425#130016)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_DATCRE_437426#129955)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_DATCRE_437426#129955)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_HEUCRE_437427#129979)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_HEUCRE_437427#129979)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_ORIGINE_437428#130015)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_ORIGINE_437428#130015)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_OID_437429#130014)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_OID_437429#130014)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_FLORDO_437430#129975)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_FLORDO_437430#129975)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_IDCDA_437431#129992)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_IDCDA_437431#129992)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_FLTR_437432#129977)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_FLTR_437432#129977)), MARX) END)

(3) Project
Output [108]: [CR_NUMCR_437325#130004 AS COL_2F91B5DB_079F_4007_8BBD_243DBA39EB8E#130586, CR_NUMDOS_437326#130007 AS COL_84DD70B2_7B79_492E_B0F4_F66E498F43D3#130587, CR_NOMDIC_437327#130001 AS COL_E3EE4BB2_7210_45F2_8B35_A032FB991B5D#130588, CR_NUMDEM_437328#130006 AS COL_E6184484_AF0B_4CD0_AB1C_A6384D23894D#130589, CR_NUMEXA_437329#130009 AS COL_7FD1AF9F_CA3E_4BB6_A332_30E20CFE349B#130590, CR_TYPDOC_437330#130044 AS COL_9858EDE6_855D_4522_B367_CE86D407FA1D#130591, CR_PRIOR_437331#130018 AS COL_F617F1AB_8500_4B96_8248_17029707DD6F#130592, CR_NOMDCR_437332#130000 AS COL_87EE67A0_4424_47D5_8584_0A55967CACF4#130593, CR_TAIDCR_437333#130040 AS COL_F87F69C4_4CF4_46EF_826D_4553225669FA#130594, CR_DURDCR_437334#129971 AS COL_8E101077_1161_4F3F_B5E5_76C5FC2B405D#130595, CR_POSDCR_437335#130017 AS COL_F55B34B1_B4A1_46C5_9877_B1786A37E194#130596, CR_NOMDOS_437336#130002 AS COL_5294B4F8_17C6_4E4A_858F_0B62BDBB8D88#130597, CR_FOR_CR_437337#129978 AS COL_BD8EA799_C46A_4567_AEE6_2FBEE19A043C#130598, CR_CR_437338#129954 AS COL_A424645F_FC5F_48DA_A88D_2F986BF0A6D4#130599, CR_STATDIC_437339#130028 AS COL_C270B0E8_6D76_466E_A97C_DB7F6E593944#130600, CR_STATSM_437340#130029 AS COL_D26522E4_E641_442D_B0BE_189CB276280D#130601, CR_STATCR_437341#130027 AS COL_BDF321A4_7AB2_4724_A531_D7291599C407#130602, CR_CODDIC_437342#129943 AS COL_54C55853_7E31_4B13_A724_A42C1A4EDEBC#130603, CR_CONTEXT_437343#129953 AS COL_1BDF04DB_C91D_4BD8_85C8_B48A03406BB5#130604, CR_DATDIC_437344#129957 AS COL_B4DD9C4C_11DF_4CA1_87E0_C76ED85E5C1D#130605, CR_HEUDIC_437345#129981 AS COL_250169E8_981D_4998_A0C2_1F9CBA240794#130606, CR_HEUI_D_437346#129983 AS COL_4A08FC67_7743_4048_9446_DB3F3BB9B98E#130607, CR_HEUI_F_437347#129984 AS COL_18D3C547_569A_4684_A4A1_3EBFE8482A5B#130608, CR_CODSEC_437348#129948 AS COL_A5FFE858_64A8_40F5_8F72_E64A836D3A56#130609, CR_DATSEC_437349#129963 AS COL_317C9FDE_EB1E_46FC_A9F5_206D5D2D3D96#130610, CR_HEUSEC_437350#129987 AS COL_E7E8F442_5BF6_479E_9496_40C107A48BF9#130611, CR_CODVCR_437351#129952 AS COL_6AD618B7_DC97_4649_9C79_E95FD069C5DA#130612, CR_DATVCR_437352#129965 AS COL_E1C48615_09D9_46F5_B82F_0694349F274B#130613, CR_HEUVCR_437353#129989 AS COL_63356D2A_19E4_4674_BDBF_AA6E2AFB7F60#130614, CR_CODDCR_437354#129942 AS COL_FC1F9F6A_A98B_4737_8B71_BFBAA8DBAB0A#130615, CR_DATDCR_437355#129956 AS COL_89EEEB1F_23AC_4324_A42D_C6AC7F671485#130616, CR_HEUDCR_437356#129980 AS COL_6A90FF7E_92FF_4879_BEBA_81A2EC5F6EA3#130617, CR_DAT_EFF_D_437357#129968 AS COL_5F1356C2_0D55_448F_8C8C_38FBC06EAABE#130618, CR_DAT_EFF_W_437358#129969 AS COL_F33F8519_3D16_4272_8AB5_E85E076D1E8A#130619, CR_CODUTI_437359#129951 AS COL_F76CEC0E_82B6_460A_A552_15AD3913A517#130620, CR_DATMAJ_437360#129960 AS COL_E16747CA_6685_4C69_BE4B_2487CE285208#130621, CR_CODSIT_437361#129949 AS COL_1599F118_0F9E_4E3C_B132_49A6D77E9BE8#130622, CR_SECTRA_437362#130023 AS COL_ABCC54B9_043A_4963_A30C_3F942ED05079#130623, CR_TYPCR_437363#130042 AS COL_33F58137_2FE0_40D8_9EC0_75598F2D9550#130624, CR_CODSUP_437364#129950 AS COL_2C600758_1D4B_4D53_B079_0BA980794577#130625, CR_NIVVCR_437365#129999 AS COL_1E485014_7A9D_4C72_91F2_1DB4246BAF9E#130626, CR_NUMVCR_437366#130012 AS COL_C51EEC02_53F1_427D_998A_B3926ABBF77F#130627, CR_NB_COR_437367#129997 AS COL_1E7F1BE2_FE43_4741_9466_DE8C2BB3FF59#130628, CR_DATSUP_437368#129964 AS COL_03D23BCB_4865_4D47_9085_8A61F3177175#130629, CR_HEUSUP_437369#129988 AS COL_F99C813D_38E3_49C6_8B24_802BAD67BB49#130630, CR_FLARCH_437370#129972 AS COL_3F78654C_F0AB_4DB1_953C_45D0287E45DC#130631, CR_STAEXT_437371#130026 AS COL_A8E8F826_92BA_403D_9338_8A782BBB541D#130632, CR_FLIMPR_437372#129974 AS COL_E4A54235_49AF_4432_8CE0_E079E1E2D130#130633, CR_LOCKCR_437373#129994 AS COL_EBDDB818_9BCB_4E26_90E1_6073CF5E2A8F#130634, CR_CODMCR_437374#129947 AS COL_B91030F8_9B21_415C_8A38_C1846FCE1BD1#130635, CR_DATMCR_437375#129961 AS COL_0C0B8905_4FD2_4717_86C0_D5E0D274AB52#130636, CR_HEUMCR_437376#129986 AS COL_4DB686B3_935C_4E46_821F_46C99E58108A#130637, CR_CODACC_437377#129940 AS COL_BEA33394_38D5_4D77_B7BB_33CDFDC70671#130638, CR_MOTPAS_437378#129995 AS COL_1DB05876_7BAB_457F_B802_1C7F664E6DDE#130639, CR_LIBCO_437379#129993 AS COL_79A4CADF_272A_44F7_BBD3_99A35242B73E#130640, CR_SUBDIC_437380#130037 AS COL_1EBF3348_0265_4507_8FD4_B7AD36BC517C#130641, CR_SUBDIR_437381#130038 AS COL_169594E0_BE84_4A74_90EC_9EABB112D82C#130642, CR_NUMPRT_437382#130011 AS COL_DD9CBF59_6716_42A4_8466_9D95B954E119#130643, CR_STA_ENV_PRT_437383#130033 AS COL_1A463532_E346_4DC9_877E_70D117A819E7#130644, CR_STA_RET_PRO_437384#130036 AS COL_31780E95_B4DD_4FF3_A187_E39C8E154C10#130645, CR_STA_ENV_FRA_437385#130032 AS COL_0E70A245_F0BC_4924_BAF3_8E13B9AD65D7#130646, CR_STA_RET_FRA_437386#130035 AS COL_95794A76_A8FE_4573_A4D5_AD017E334160#130647, CR_CODCLI_437387#129941 AS COL_07196D1A_0D50_4267_9451_864F1EEAC4F5#130648, CR_PRI_DIC_437388#130019 AS COL_03897C9F_7781_4AAD_9DE0_21251A64D991#130649, CR_DAT_DIC_TRA_437389#129967 AS COL_6B270073_8360_4428_99D4_6BAA35ECC88F#130650, CR_HEU_DIC_TRA_437390#129991 AS COL_29D44850_A40D_4781_8CBA_491C489022E5#130651, CR_CODFRA_437391#129945 AS COL_33F4D1D2_5075_4D15_BF7C_25C0349ADF81#130652, CR_SECEXT_437392#130022 AS COL_139B864F_8E84_4CC2_BB8B_CD2D2194C59C#130653, CR_STATUT_EXT_437393#130030 AS COL_268DADCB_5896_47CF_9C8A_3B357A9866CC#130654, CR_SIMP_JOB_ID_437394#130024 AS COL_0469C0BB_A269_4053_8A29_E46624056F13#130655, CR_DAT_CR_INT_437395#129966 AS COL_D3A03AFC_E6DF_4D79_B1B1_29735666A5FF#130656, CR_HEU_CR_INT_437396#129990 AS COL_A1F788A2_F27D_404A_A5FB_A21AEEE14C22#130657, CR_DELAI_TOTAL_437397#129970 AS COL_A8CD8314_37F0_40F0_AEB9_14AE0F2953CE#130658, CR_NB_LIGNE_EXT_437398#129998 AS COL_56DB471E_E2EA_4B09_9110_1904EEC38498#130659, CR_NB_CAR_EXT_437399#129996 AS COL_27376993_1E16_4804_9A7E_9DCBD88969E5#130660, CR_NOMEXT_437400#130003 AS COL_1597D57D_BB05_4888_9F7E_69656D0F0FC2#130661, CR_SUBEXT_437401#130039 AS COL_095E9C8B_ABF9_41CC_A6A9_9E2428CDF1A1#130662, CR_FLTBDI_437402#129976 AS COL_63B98FE1_842D_4097_AF70_621A5ECCF782#130663, CR_TYPDIC_437403#130043 AS COL_C691E7D0_BDD2_45F2_BB41_894A9895CE67#130664, CR_STA_ENV_ACK_437404#130031 AS COL_25B42821_A52F_4341_8B75_ACB3C1292F9A#130665, CR_STA_RET_ACK_437405#130034 AS COL_DA1A110A_D008_497D_B47F_3DDB502FFEFC#130666, CR_TAILLE_DIC_437406#130041 AS COL_15DD9B70_1C90_4831_87BF_0C305AACD0C8#130667, CR_CHKSUM_DIC_437407#129939 AS COL_F223DC08_EBBA_4246_A445_6069F397E65C#130668, CR_DATMAIL_437408#129959 AS COL_D0943EFD_7FF2_42A6_8A39_CB7FE85DB5EA#130669, CR_HEUMAIL_437409#129985 AS COL_9D316656_33D8_485F_B34F_1F867230C0B1#130670, CR_CODMAIL_437410#129946 AS COL_123326BE_6C75_464A_94E2_F73A1D73A2E5#130671, CR_STADMP_437411#130025 AS COL_C705ECA2_5821_4D89_B5E1_6A6CB177D49B#130672, CR_CODDMP_437412#129944 AS COL_7A388285_7D5F_49E3_82EC_97BB23F3C599#130673, CR_DATDMP_437413#129958 AS COL_F18F454B_5BB4_4778_BC00_A77DF7DD5D16#130674, CR_HEUDMP_437414#129982 AS COL_13E71BF7_5C64_43A7_A77F_D9C85107A505#130675, CR_OIDDMP_437415#130013 AS COL_5314F095_D308_4B28_BA4F_AC827851EBAC#130676, CR_VISDMP_437416#130045 AS COL_91B571C8_3C27_4644_9CCB_974FEDC96559#130677, CR_SCNPAT_437417#130021 AS COL_8027EA33_EFA6_41EC_8E57_E45C5EB8BEF2#130678, CR_DATSCN_437418#129962 AS COL_075CC793_DD04_4D05_9483_007E1272F07F#130679, CR_NUMMCR_437419#130010 AS COL_50717D31_AF59_4A48_BE5B_0D9F16625DCB#130680, CR_NUMCR_CLOUD_437420#130005 AS COL_7758A926_CF0E_47F4_8F61_0E20F0E5B0CE#130681, CR_NUMDRV_437421#130008 AS COL_0B584815_1C45_4A2D_A9AE_1EE80581DD88#130682, CR_FLARCH_D_437422#129973 AS COL_17E22F3F_4EFA_41BD_BD5E_F1CAC4D0DDB7#130683, CR_REFEXT_437423#130020 AS COL_098DBD08_1EFB_4DE6_A58D_9707BB412F8F#130684, CR_ANNONCE_437424#129938 AS COL_2E04E0FD_10CE_4558_B4FF_F4CCDD20AA94#130685, CR_PERIPH_437425#130016 AS COL_E2F04093_FAFD_4607_9281_F8070703526F#130686, CR_DATCRE_437426#129955 AS COL_50B7F367_FB8A_4AFB_819A_3819CB6E0041#130687, CR_HEUCRE_437427#129979 AS COL_1FAFE43C_A95C_4DDC_93B8_CAD40E202D50#130688, CR_ORIGINE_437428#130015 AS COL_D9750980_DDFA_46BB_804B_854B19F8AA43#130689, CR_OID_437429#130014 AS COL_42B78BC9_EA71_4052_A271_03C4EC7A0A2E#130690, CR_FLORDO_437430#129975 AS COL_FE5AC7EA_4867_42CB_8B5C_59A5455CF512#130691, CR_IDCDA_437431#129992 AS COL_D8A089C6_B986_47BB_8359_33875D230263#130692, CR_FLTR_437432#129977 AS COL_7EB22787_E13F_4B17_B685_6ACCADDF9B06#130693]
Input [108]: [CR_ANNONCE_437424#129938, CR_CHKSUM_DIC_437407#129939, CR_CODACC_437377#129940, CR_CODCLI_437387#129941, CR_CODDCR_437354#129942, CR_CODDIC_437342#129943, CR_CODDMP_437412#129944, CR_CODFRA_437391#129945, CR_CODMAIL_437410#129946, CR_CODMCR_437374#129947, CR_CODSEC_437348#129948, CR_CODSIT_437361#129949, CR_CODSUP_437364#129950, CR_CODUTI_437359#129951, CR_CODVCR_437351#129952, CR_CONTEXT_437343#129953, CR_CR_437338#129954, CR_DATCRE_437426#129955, CR_DATDCR_437355#129956, CR_DATDIC_437344#129957, CR_DATDMP_437413#129958, CR_DATMAIL_437408#129959, CR_DATMAJ_437360#129960, CR_DATMCR_437375#129961, CR_DATSCN_437418#129962, CR_DATSEC_437349#129963, CR_DATSUP_437368#129964, CR_DATVCR_437352#129965, CR_DAT_CR_INT_437395#129966, CR_DAT_DIC_TRA_437389#129967, CR_DAT_EFF_D_437357#129968, CR_DAT_EFF_W_437358#129969, CR_DELAI_TOTAL_437397#129970, CR_DURDCR_437334#129971, CR_FLARCH_437370#129972, CR_FLARCH_D_437422#129973, CR_FLIMPR_437372#129974, CR_FLORDO_437430#129975, CR_FLTBDI_437402#129976, CR_FLTR_437432#129977, CR_FOR_CR_437337#129978, CR_HEUCRE_437427#129979, CR_HEUDCR_437356#129980, CR_HEUDIC_437345#129981, CR_HEUDMP_437414#129982, CR_HEUI_D_437346#129983, CR_HEUI_F_437347#129984, CR_HEUMAIL_437409#129985, CR_HEUMCR_437376#129986, CR_HEUSEC_437350#129987, CR_HEUSUP_437369#129988, CR_HEUVCR_437353#129989, CR_HEU_CR_INT_437396#129990, CR_HEU_DIC_TRA_437390#129991, CR_IDCDA_437431#129992, CR_LIBCO_437379#129993, CR_LOCKCR_437373#129994, CR_MOTPAS_437378#129995, CR_NB_CAR_EXT_437399#129996, CR_NB_COR_437367#129997, CR_NB_LIGNE_EXT_437398#129998, CR_NIVVCR_437365#129999, CR_NOMDCR_437332#130000, CR_NOMDIC_437327#130001, CR_NOMDOS_437336#130002, CR_NOMEXT_437400#130003, CR_NUMCR_437325#130004, CR_NUMCR_CLOUD_437420#130005, CR_NUMDEM_437328#130006, CR_NUMDOS_437326#130007, CR_NUMDRV_437421#130008, CR_NUMEXA_437329#130009, CR_NUMMCR_437419#130010, CR_NUMPRT_437382#130011, CR_NUMVCR_437366#130012, CR_OIDDMP_437415#130013, CR_OID_437429#130014, CR_ORIGINE_437428#130015, CR_PERIPH_437425#130016, CR_POSDCR_437335#130017, CR_PRIOR_437331#130018, CR_PRI_DIC_437388#130019, CR_REFEXT_437423#130020, CR_SCNPAT_437417#130021, CR_SECEXT_437392#130022, CR_SECTRA_437362#130023, CR_SIMP_JOB_ID_437394#130024, CR_STADMP_437411#130025, CR_STAEXT_437371#130026, CR_STATCR_437341#130027, CR_STATDIC_437339#130028, CR_STATSM_437340#130029, CR_STATUT_EXT_437393#130030, CR_STA_ENV_ACK_437404#130031, CR_STA_ENV_FRA_437385#130032, CR_STA_ENV_PRT_437383#130033, CR_STA_RET_ACK_437405#130034, CR_STA_RET_FRA_437386#130035, CR_STA_RET_PRO_437384#130036, CR_SUBDIC_437380#130037, CR_SUBDIR_437381#130038, CR_SUBEXT_437401#130039, CR_TAIDCR_437333#130040, CR_TAILLE_DIC_437406#130041, CR_TYPCR_437363#130042, CR_TYPDIC_437403#130043, CR_TYPDOC_437330#130044, CR_VISDMP_437416#130045]

(4) CollectLimit
Input [108]: [COL_2F91B5DB_079F_4007_8BBD_243DBA39EB8E#130586, COL_84DD70B2_7B79_492E_B0F4_F66E498F43D3#130587, COL_E3EE4BB2_7210_45F2_8B35_A032FB991B5D#130588, COL_E6184484_AF0B_4CD0_AB1C_A6384D23894D#130589, COL_7FD1AF9F_CA3E_4BB6_A332_30E20CFE349B#130590, COL_9858EDE6_855D_4522_B367_CE86D407FA1D#130591, COL_F617F1AB_8500_4B96_8248_17029707DD6F#130592, COL_87EE67A0_4424_47D5_8584_0A55967CACF4#130593, COL_F87F69C4_4CF4_46EF_826D_4553225669FA#130594, COL_8E101077_1161_4F3F_B5E5_76C5FC2B405D#130595, COL_F55B34B1_B4A1_46C5_9877_B1786A37E194#130596, COL_5294B4F8_17C6_4E4A_858F_0B62BDBB8D88#130597, COL_BD8EA799_C46A_4567_AEE6_2FBEE19A043C#130598, COL_A424645F_FC5F_48DA_A88D_2F986BF0A6D4#130599, COL_C270B0E8_6D76_466E_A97C_DB7F6E593944#130600, COL_D26522E4_E641_442D_B0BE_189CB276280D#130601, COL_BDF321A4_7AB2_4724_A531_D7291599C407#130602, COL_54C55853_7E31_4B13_A724_A42C1A4EDEBC#130603, COL_1BDF04DB_C91D_4BD8_85C8_B48A03406BB5#130604, COL_B4DD9C4C_11DF_4CA1_87E0_C76ED85E5C1D#130605, COL_250169E8_981D_4998_A0C2_1F9CBA240794#130606, COL_4A08FC67_7743_4048_9446_DB3F3BB9B98E#130607, COL_18D3C547_569A_4684_A4A1_3EBFE8482A5B#130608, COL_A5FFE858_64A8_40F5_8F72_E64A836D3A56#130609, COL_317C9FDE_EB1E_46FC_A9F5_206D5D2D3D96#130610, COL_E7E8F442_5BF6_479E_9496_40C107A48BF9#130611, COL_6AD618B7_DC97_4649_9C79_E95FD069C5DA#130612, COL_E1C48615_09D9_46F5_B82F_0694349F274B#130613, COL_63356D2A_19E4_4674_BDBF_AA6E2AFB7F60#130614, COL_FC1F9F6A_A98B_4737_8B71_BFBAA8DBAB0A#130615, COL_89EEEB1F_23AC_4324_A42D_C6AC7F671485#130616, COL_6A90FF7E_92FF_4879_BEBA_81A2EC5F6EA3#130617, COL_5F1356C2_0D55_448F_8C8C_38FBC06EAABE#130618, COL_F33F8519_3D16_4272_8AB5_E85E076D1E8A#130619, COL_F76CEC0E_82B6_460A_A552_15AD3913A517#130620, COL_E16747CA_6685_4C69_BE4B_2487CE285208#130621, COL_1599F118_0F9E_4E3C_B132_49A6D77E9BE8#130622, COL_ABCC54B9_043A_4963_A30C_3F942ED05079#130623, COL_33F58137_2FE0_40D8_9EC0_75598F2D9550#130624, COL_2C600758_1D4B_4D53_B079_0BA980794577#130625, COL_1E485014_7A9D_4C72_91F2_1DB4246BAF9E#130626, COL_C51EEC02_53F1_427D_998A_B3926ABBF77F#130627, COL_1E7F1BE2_FE43_4741_9466_DE8C2BB3FF59#130628, COL_03D23BCB_4865_4D47_9085_8A61F3177175#130629, COL_F99C813D_38E3_49C6_8B24_802BAD67BB49#130630, COL_3F78654C_F0AB_4DB1_953C_45D0287E45DC#130631, COL_A8E8F826_92BA_403D_9338_8A782BBB541D#130632, COL_E4A54235_49AF_4432_8CE0_E079E1E2D130#130633, COL_EBDDB818_9BCB_4E26_90E1_6073CF5E2A8F#130634, COL_B91030F8_9B21_415C_8A38_C1846FCE1BD1#130635, COL_0C0B8905_4FD2_4717_86C0_D5E0D274AB52#130636, COL_4DB686B3_935C_4E46_821F_46C99E58108A#130637, COL_BEA33394_38D5_4D77_B7BB_33CDFDC70671#130638, COL_1DB05876_7BAB_457F_B802_1C7F664E6DDE#130639, COL_79A4CADF_272A_44F7_BBD3_99A35242B73E#130640, COL_1EBF3348_0265_4507_8FD4_B7AD36BC517C#130641, COL_169594E0_BE84_4A74_90EC_9EABB112D82C#130642, COL_DD9CBF59_6716_42A4_8466_9D95B954E119#130643, COL_1A463532_E346_4DC9_877E_70D117A819E7#130644, COL_31780E95_B4DD_4FF3_A187_E39C8E154C10#130645, COL_0E70A245_F0BC_4924_BAF3_8E13B9AD65D7#130646, COL_95794A76_A8FE_4573_A4D5_AD017E334160#130647, COL_07196D1A_0D50_4267_9451_864F1EEAC4F5#130648, COL_03897C9F_7781_4AAD_9DE0_21251A64D991#130649, COL_6B270073_8360_4428_99D4_6BAA35ECC88F#130650, COL_29D44850_A40D_4781_8CBA_491C489022E5#130651, COL_33F4D1D2_5075_4D15_BF7C_25C0349ADF81#130652, COL_139B864F_8E84_4CC2_BB8B_CD2D2194C59C#130653, COL_268DADCB_5896_47CF_9C8A_3B357A9866CC#130654, COL_0469C0BB_A269_4053_8A29_E46624056F13#130655, COL_D3A03AFC_E6DF_4D79_B1B1_29735666A5FF#130656, COL_A1F788A2_F27D_404A_A5FB_A21AEEE14C22#130657, COL_A8CD8314_37F0_40F0_AEB9_14AE0F2953CE#130658, COL_56DB471E_E2EA_4B09_9110_1904EEC38498#130659, COL_27376993_1E16_4804_9A7E_9DCBD88969E5#130660, COL_1597D57D_BB05_4888_9F7E_69656D0F0FC2#130661, COL_095E9C8B_ABF9_41CC_A6A9_9E2428CDF1A1#130662, COL_63B98FE1_842D_4097_AF70_621A5ECCF782#130663, COL_C691E7D0_BDD2_45F2_BB41_894A9895CE67#130664, COL_25B42821_A52F_4341_8B75_ACB3C1292F9A#130665, COL_DA1A110A_D008_497D_B47F_3DDB502FFEFC#130666, COL_15DD9B70_1C90_4831_87BF_0C305AACD0C8#130667, COL_F223DC08_EBBA_4246_A445_6069F397E65C#130668, COL_D0943EFD_7FF2_42A6_8A39_CB7FE85DB5EA#130669, COL_9D316656_33D8_485F_B34F_1F867230C0B1#130670, COL_123326BE_6C75_464A_94E2_F73A1D73A2E5#130671, COL_C705ECA2_5821_4D89_B5E1_6A6CB177D49B#130672, COL_7A388285_7D5F_49E3_82EC_97BB23F3C599#130673, COL_F18F454B_5BB4_4778_BC00_A77DF7DD5D16#130674, COL_13E71BF7_5C64_43A7_A77F_D9C85107A505#130675, COL_5314F095_D308_4B28_BA4F_AC827851EBAC#130676, COL_91B571C8_3C27_4644_9CCB_974FEDC96559#130677, COL_8027EA33_EFA6_41EC_8E57_E45C5EB8BEF2#130678, COL_075CC793_DD04_4D05_9483_007E1272F07F#130679, COL_50717D31_AF59_4A48_BE5B_0D9F16625DCB#130680, COL_7758A926_CF0E_47F4_8F61_0E20F0E5B0CE#130681, COL_0B584815_1C45_4A2D_A9AE_1EE80581DD88#130682, COL_17E22F3F_4EFA_41BD_BD5E_F1CAC4D0DDB7#130683, COL_098DBD08_1EFB_4DE6_A58D_9707BB412F8F#130684, COL_2E04E0FD_10CE_4558_B4FF_F4CCDD20AA94#130685, COL_E2F04093_FAFD_4607_9281_F8070703526F#130686, COL_50B7F367_FB8A_4AFB_819A_3819CB6E0041#130687, COL_1FAFE43C_A95C_4DDC_93B8_CAD40E202D50#130688, COL_D9750980_DDFA_46BB_804B_854B19F8AA43#130689, COL_42B78BC9_EA71_4052_A271_03C4EC7A0A2E#130690, COL_FE5AC7EA_4867_42CB_8B5C_59A5455CF512#130691, COL_D8A089C6_B986_47BB_8359_33875D230263#130692, COL_7EB22787_E13F_4B17_B685_6ACCADDF9B06#130693]
Arguments: 1500

SQL / DataFrame Properties

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