hdh-spark-job - Details for Query 611

Submitted Time: 2026/10/21 21:32:15
Duration: 0.3 s
Succeeded Jobs: 547

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: 8 ms"; 2 [labelType="html" label=" Project "]; 3 [labelType="html" label="Filter number of output rows: 78"]; 4 [labelType="html" label="ColumnarToRow number of output rows: 80 number of input batches: 1"]; } 5 [labelType="html" label="Scan parquet number of files read: 1 scan time: 5 ms metadata time: 0 ms size of files read: 16.2 KiB number of output rows: 80"]; 2->0; 3->2; 4->3; 5->4; }

CollectLimit 1500

Project [UN_CODSER_438335#126620 AS COL_FC36F0E3_819E_4F1F_B3DA_747F8D0B3498#126854, UN_LIB30_438336#126635 AS COL_C6249CB4_EB19_4A9F_9F08_7F82C075294D#126855, UN_LIBCO_438337#126636 AS COL_6E14DB13_7968_4E60_B2E0_7D2DBD952425#126856, UN_SERV_438338#126646 AS COL_D4C74997_D244_44C7_BD03_E46A9A0A4746#126857, UN_NATURE_438339#126640 AS COL_28844A14_3212_46B2_B056_E6BCEB956520#126858, UN_VALID_438340#126651 AS COL_A263D3EB_4ECF_4AB7_BD02_AB929D3593DD#126859, UN_UF_DEM_438341#126648 AS COL_8397A5D6_5BEC_46CC_A2BD_000FE8A34A3B#126860, UN_UF_EXE_438342#126649 AS COL_14475057_7FAB_4D27_95BB_A16297B5A727#126861, UN_UF_LOC_438343#126650 AS COL_BA393EAA_60E6_49F4_93E8_FAEF1C583084#126862, UN_TELBUR_438344#126647 AS COL_BC33D938_B8B1_4527_9A60_D024A122F90B#126863, UN_FAX_438345#126633 AS COL_96BA3445_3A85_4367_BCDD_B355134AEECC#126864, UN_E_MAIL_438346#126632 AS COL_1BA3DEDB_C750_475F_92A3_FF7805A40418#126865, UN_ENVADM_438347#126631 AS COL_9EA8D3BF_2C11_40E7_B842_49488D5F1EDC#126866, UN_LIEU_S_438348#126637 AS COL_9946151B_D1A3_47DB_9668_F71C402E51E6#126867, UN_CODUTI_438349#126623 AS COL_D8912422_1CEB_4A32_9170_75D29B492BB7#126868, UN_DATMAJ_438350#126629 AS COL_7893AA98_1C78_44EA_8443_153F57E306DA#126869, UN_CODSIT_438351#126621 AS COL_18582FF1_F7A4_419F_8048_ADAC5A69F1F4#126870, UN_MODTRT_438352#126638 AS COL_B7C95DF9_744C_4867_8207_C76D4578947A#126871, UN_DISPRE_438353#126630 AS COL_E40EECCB_F6FC_4509_8285_B53E1A456DE8#126872, UN_CODSOC_438354#126622 AS COL_ED2B7A08_28B1_47E5_A8AB_7436B43C0D8C#126873, UN_NUMCPT_A_438355#126641 AS COL_1B216C55_17C2_4395_874D_5929728B9368#126874, UN_NUMCPT_F_438356#126643 AS COL_58E842AA_5A4D_43AD_9F8E_1A831DA296EB#126875, UN_NUMCPT_C_438357#126642 AS COL_18902568_A23E_4F1F_8709_86E32242E97F#126876, UN_CHEFSER_438358#126617 AS COL_7D611DEA_35F8_4357_8F2D_7DC9276C3516#126877, ... 16 more fields]

Filter (((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(UN_CODSER_438335#126620)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(UN_CODSER_438335#126620)), MARX) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(UN_LIB30_438336#126635)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(UN_LIB30_438336#126635)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(UN_LIBCO_438337#126636)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(UN_LIBCO_438337#126636)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(UN_SERV_438338#126646)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(UN_SERV_438338#126646)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(UN_NATURE_438339#126640)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(UN_NATURE_438339#126640)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(UN_VALID_438340#126651)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(UN_VALID_438340#126651)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(UN_UF_DEM_438341#126648)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(UN_UF_DEM_438341#126648)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(UN_UF_EXE_438342#126649)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(UN_UF_EXE_438342#126649)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(UN_UF_LOC_438343#126650)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(UN_UF_LOC_438343#126650)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(UN_TELBUR_438344#126647)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(UN_TELBUR_438344#126647)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(UN_FAX_438345#126633)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(UN_FAX_438345#126633)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(UN_E_MAIL_438346#126632)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(UN_E_MAIL_438346#126632)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(UN_ENVADM_438347#126631)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(UN_ENVADM_438347#126631)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(UN_LIEU_S_438348#126637)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(UN_LIEU_S_438348#126637)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(UN_CODUTI_438349#126623)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(UN_CODUTI_438349#126623)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(UN_DATMAJ_438350#126629)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(UN_DATMAJ_438350#126629)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(UN_CODSIT_438351#126621)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(UN_CODSIT_438351#126621)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(UN_MODTRT_438352#126638)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(UN_MODTRT_438352#126638)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(UN_DISPRE_438353#126630)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(UN_DISPRE_438353#126630)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(UN_CODSOC_438354#126622)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(UN_CODSOC_438354#126622)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(UN_NUMCPT_A_438355#126641)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(UN_NUMCPT_A_438355#126641)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(UN_NUMCPT_F_438356#126643)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(UN_NUMCPT_F_438356#126643)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(UN_NUMCPT_C_438357#126642)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(UN_NUMCPT_C_438357#126642)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(UN_CHEFSER_438358#126617)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(UN_CHEFSER_438358#126617)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(UN_DATEDE_438359#126627)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(UN_DATEDE_438359#126627)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(UN_DATEFI_438360#126628)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(UN_DATEFI_438360#126628)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(UN_COMMENT_438361#126624)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(UN_COMMENT_438361#126624)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(UN_FLICPT_438362#126634)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(UN_FLICPT_438362#126634)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(UN_XML_P_CPTA_438363#126653)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(UN_XML_P_CPTA_438363#126653)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(UN_NUMPRF_438364#126644)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(UN_NUMPRF_438364#126644)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(UN_CSCPT_438365#126626)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(UN_CSCPT_438365#126626)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(UN_CSANA_438366#126625)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(UN_CSANA_438366#126625)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(UN_CODADM_438367#126618)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(UN_CODADM_438367#126618)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(UN_MOD_ENVOI_438368#126639)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(UN_MOD_ENVOI_438368#126639)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(UN_ADR_1_438369#126614)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(UN_ADR_1_438369#126614)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(UN_ADR_2_438370#126615)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(UN_ADR_2_438370#126615)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(UN_ADR_3_438371#126616)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(UN_ADR_3_438371#126616)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(UN_CODPOS_438372#126619)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(UN_CODPOS_438372#126619)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(UN_VILLE_438373#126652)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(UN_VILLE_438373#126652)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(UN_PAYS_438374#126645)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(UN_PAYS_438374#126645)), MARX) END)

ColumnarToRow

WholeStageCodegen (1)

FileScan parquet [UN_ADR_1_438369#126614,UN_ADR_2_438370#126615,UN_ADR_3_438371#126616,UN_CHEFSER_438358#126617,UN_CODADM_438367#126618,UN_CODPOS_438372#126619,UN_CODSER_438335#126620,UN_CODSIT_438351#126621,UN_CODSOC_438354#126622,UN_CODUTI_438349#126623,UN_COMMENT_438361#126624,UN_CSANA_438366#126625,UN_CSCPT_438365#126626,UN_DATEDE_438359#126627,UN_DATEFI_438360#126628,UN_DATMAJ_438350#126629,UN_DISPRE_438353#126630,UN_ENVADM_438347#126631,UN_E_MAIL_438346#126632,UN_FAX_438345#126633,UN_FLICPT_438362#126634,UN_LIB30_438336#126635,UN_LIBCO_438337#126636,UN_LIEU_S_438348#126637,... 16 more fields] Batched: true, DataFilters: [(((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(UN_CODS..., Format: Parquet, Location: InMemoryFileIndex(1 paths)[file:/data/output/cache/parquet/uet/H_UNIT_438334], PartitionFilters: [], PushedFilters: [], ReadSchema: struct<UN_ADR_1_438369:string,UN_ADR_2_438370:string,UN_ADR_3_438371:string,UN_CHEFSER_438358:str...

Details

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


(1) Scan parquet 
Output [40]: [UN_ADR_1_438369#126614, UN_ADR_2_438370#126615, UN_ADR_3_438371#126616, UN_CHEFSER_438358#126617, UN_CODADM_438367#126618, UN_CODPOS_438372#126619, UN_CODSER_438335#126620, UN_CODSIT_438351#126621, UN_CODSOC_438354#126622, UN_CODUTI_438349#126623, UN_COMMENT_438361#126624, UN_CSANA_438366#126625, UN_CSCPT_438365#126626, UN_DATEDE_438359#126627, UN_DATEFI_438360#126628, UN_DATMAJ_438350#126629, UN_DISPRE_438353#126630, UN_ENVADM_438347#126631, UN_E_MAIL_438346#126632, UN_FAX_438345#126633, UN_FLICPT_438362#126634, UN_LIB30_438336#126635, UN_LIBCO_438337#126636, UN_LIEU_S_438348#126637, UN_MODTRT_438352#126638, UN_MOD_ENVOI_438368#126639, UN_NATURE_438339#126640, UN_NUMCPT_A_438355#126641, UN_NUMCPT_C_438357#126642, UN_NUMCPT_F_438356#126643, UN_NUMPRF_438364#126644, UN_PAYS_438374#126645, UN_SERV_438338#126646, UN_TELBUR_438344#126647, UN_UF_DEM_438341#126648, UN_UF_EXE_438342#126649, UN_UF_LOC_438343#126650, UN_VALID_438340#126651, UN_VILLE_438373#126652, UN_XML_P_CPTA_438363#126653]
Batched: true
Location: InMemoryFileIndex [file:/data/output/cache/parquet/uet/H_UNIT_438334]
ReadSchema: struct<UN_ADR_1_438369:string,UN_ADR_2_438370:string,UN_ADR_3_438371:string,UN_CHEFSER_438358:string,UN_CODADM_438367:string,UN_CODPOS_438372:string,UN_CODSER_438335:string,UN_CODSIT_438351:string,UN_CODSOC_438354:string,UN_CODUTI_438349:string,UN_COMMENT_438361:string,UN_CSANA_438366:string,UN_CSCPT_438365:string,UN_DATEDE_438359:string,UN_DATEFI_438360:string,UN_DATMAJ_438350:string,UN_DISPRE_438353:string,UN_ENVADM_438347:string,UN_E_MAIL_438346:string,UN_FAX_438345:string,UN_FLICPT_438362:string,UN_LIB30_438336:string,UN_LIBCO_438337:string,UN_LIEU_S_438348:string,UN_MODTRT_438352:string,UN_MOD_ENVOI_438368:string,UN_NATURE_438339:string,UN_NUMCPT_A_438355:string,UN_NUMCPT_C_438357:string,UN_NUMCPT_F_438356:string,UN_NUMPRF_438364:string,UN_PAYS_438374:string,UN_SERV_438338:string,UN_TELBUR_438344:string,UN_UF_DEM_438341:string,UN_UF_EXE_438342:string,UN_UF_LOC_438343:string,UN_VALID_438340:string,UN_VILLE_438373:string,UN_XML_P_CPTA_438363:string>

(2) ColumnarToRow [codegen id : 1]
Input [40]: [UN_ADR_1_438369#126614, UN_ADR_2_438370#126615, UN_ADR_3_438371#126616, UN_CHEFSER_438358#126617, UN_CODADM_438367#126618, UN_CODPOS_438372#126619, UN_CODSER_438335#126620, UN_CODSIT_438351#126621, UN_CODSOC_438354#126622, UN_CODUTI_438349#126623, UN_COMMENT_438361#126624, UN_CSANA_438366#126625, UN_CSCPT_438365#126626, UN_DATEDE_438359#126627, UN_DATEFI_438360#126628, UN_DATMAJ_438350#126629, UN_DISPRE_438353#126630, UN_ENVADM_438347#126631, UN_E_MAIL_438346#126632, UN_FAX_438345#126633, UN_FLICPT_438362#126634, UN_LIB30_438336#126635, UN_LIBCO_438337#126636, UN_LIEU_S_438348#126637, UN_MODTRT_438352#126638, UN_MOD_ENVOI_438368#126639, UN_NATURE_438339#126640, UN_NUMCPT_A_438355#126641, UN_NUMCPT_C_438357#126642, UN_NUMCPT_F_438356#126643, UN_NUMPRF_438364#126644, UN_PAYS_438374#126645, UN_SERV_438338#126646, UN_TELBUR_438344#126647, UN_UF_DEM_438341#126648, UN_UF_EXE_438342#126649, UN_UF_LOC_438343#126650, UN_VALID_438340#126651, UN_VILLE_438373#126652, UN_XML_P_CPTA_438363#126653]

(3) Filter [codegen id : 1]
Input [40]: [UN_ADR_1_438369#126614, UN_ADR_2_438370#126615, UN_ADR_3_438371#126616, UN_CHEFSER_438358#126617, UN_CODADM_438367#126618, UN_CODPOS_438372#126619, UN_CODSER_438335#126620, UN_CODSIT_438351#126621, UN_CODSOC_438354#126622, UN_CODUTI_438349#126623, UN_COMMENT_438361#126624, UN_CSANA_438366#126625, UN_CSCPT_438365#126626, UN_DATEDE_438359#126627, UN_DATEFI_438360#126628, UN_DATMAJ_438350#126629, UN_DISPRE_438353#126630, UN_ENVADM_438347#126631, UN_E_MAIL_438346#126632, UN_FAX_438345#126633, UN_FLICPT_438362#126634, UN_LIB30_438336#126635, UN_LIBCO_438337#126636, UN_LIEU_S_438348#126637, UN_MODTRT_438352#126638, UN_MOD_ENVOI_438368#126639, UN_NATURE_438339#126640, UN_NUMCPT_A_438355#126641, UN_NUMCPT_C_438357#126642, UN_NUMCPT_F_438356#126643, UN_NUMPRF_438364#126644, UN_PAYS_438374#126645, UN_SERV_438338#126646, UN_TELBUR_438344#126647, UN_UF_DEM_438341#126648, UN_UF_EXE_438342#126649, UN_UF_LOC_438343#126650, UN_VALID_438340#126651, UN_VILLE_438373#126652, UN_XML_P_CPTA_438363#126653]
Condition : (((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(UN_CODSER_438335#126620)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(UN_CODSER_438335#126620)), MARX) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(UN_LIB30_438336#126635)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(UN_LIB30_438336#126635)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(UN_LIBCO_438337#126636)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(UN_LIBCO_438337#126636)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(UN_SERV_438338#126646)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(UN_SERV_438338#126646)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(UN_NATURE_438339#126640)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(UN_NATURE_438339#126640)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(UN_VALID_438340#126651)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(UN_VALID_438340#126651)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(UN_UF_DEM_438341#126648)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(UN_UF_DEM_438341#126648)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(UN_UF_EXE_438342#126649)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(UN_UF_EXE_438342#126649)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(UN_UF_LOC_438343#126650)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(UN_UF_LOC_438343#126650)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(UN_TELBUR_438344#126647)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(UN_TELBUR_438344#126647)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(UN_FAX_438345#126633)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(UN_FAX_438345#126633)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(UN_E_MAIL_438346#126632)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(UN_E_MAIL_438346#126632)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(UN_ENVADM_438347#126631)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(UN_ENVADM_438347#126631)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(UN_LIEU_S_438348#126637)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(UN_LIEU_S_438348#126637)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(UN_CODUTI_438349#126623)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(UN_CODUTI_438349#126623)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(UN_DATMAJ_438350#126629)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(UN_DATMAJ_438350#126629)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(UN_CODSIT_438351#126621)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(UN_CODSIT_438351#126621)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(UN_MODTRT_438352#126638)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(UN_MODTRT_438352#126638)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(UN_DISPRE_438353#126630)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(UN_DISPRE_438353#126630)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(UN_CODSOC_438354#126622)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(UN_CODSOC_438354#126622)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(UN_NUMCPT_A_438355#126641)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(UN_NUMCPT_A_438355#126641)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(UN_NUMCPT_F_438356#126643)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(UN_NUMCPT_F_438356#126643)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(UN_NUMCPT_C_438357#126642)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(UN_NUMCPT_C_438357#126642)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(UN_CHEFSER_438358#126617)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(UN_CHEFSER_438358#126617)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(UN_DATEDE_438359#126627)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(UN_DATEDE_438359#126627)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(UN_DATEFI_438360#126628)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(UN_DATEFI_438360#126628)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(UN_COMMENT_438361#126624)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(UN_COMMENT_438361#126624)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(UN_FLICPT_438362#126634)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(UN_FLICPT_438362#126634)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(UN_XML_P_CPTA_438363#126653)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(UN_XML_P_CPTA_438363#126653)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(UN_NUMPRF_438364#126644)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(UN_NUMPRF_438364#126644)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(UN_CSCPT_438365#126626)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(UN_CSCPT_438365#126626)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(UN_CSANA_438366#126625)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(UN_CSANA_438366#126625)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(UN_CODADM_438367#126618)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(UN_CODADM_438367#126618)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(UN_MOD_ENVOI_438368#126639)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(UN_MOD_ENVOI_438368#126639)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(UN_ADR_1_438369#126614)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(UN_ADR_1_438369#126614)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(UN_ADR_2_438370#126615)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(UN_ADR_2_438370#126615)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(UN_ADR_3_438371#126616)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(UN_ADR_3_438371#126616)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(UN_CODPOS_438372#126619)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(UN_CODPOS_438372#126619)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(UN_VILLE_438373#126652)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(UN_VILLE_438373#126652)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(UN_PAYS_438374#126645)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(UN_PAYS_438374#126645)), MARX) END)

(4) Project [codegen id : 1]
Output [40]: [UN_CODSER_438335#126620 AS COL_FC36F0E3_819E_4F1F_B3DA_747F8D0B3498#126854, UN_LIB30_438336#126635 AS COL_C6249CB4_EB19_4A9F_9F08_7F82C075294D#126855, UN_LIBCO_438337#126636 AS COL_6E14DB13_7968_4E60_B2E0_7D2DBD952425#126856, UN_SERV_438338#126646 AS COL_D4C74997_D244_44C7_BD03_E46A9A0A4746#126857, UN_NATURE_438339#126640 AS COL_28844A14_3212_46B2_B056_E6BCEB956520#126858, UN_VALID_438340#126651 AS COL_A263D3EB_4ECF_4AB7_BD02_AB929D3593DD#126859, UN_UF_DEM_438341#126648 AS COL_8397A5D6_5BEC_46CC_A2BD_000FE8A34A3B#126860, UN_UF_EXE_438342#126649 AS COL_14475057_7FAB_4D27_95BB_A16297B5A727#126861, UN_UF_LOC_438343#126650 AS COL_BA393EAA_60E6_49F4_93E8_FAEF1C583084#126862, UN_TELBUR_438344#126647 AS COL_BC33D938_B8B1_4527_9A60_D024A122F90B#126863, UN_FAX_438345#126633 AS COL_96BA3445_3A85_4367_BCDD_B355134AEECC#126864, UN_E_MAIL_438346#126632 AS COL_1BA3DEDB_C750_475F_92A3_FF7805A40418#126865, UN_ENVADM_438347#126631 AS COL_9EA8D3BF_2C11_40E7_B842_49488D5F1EDC#126866, UN_LIEU_S_438348#126637 AS COL_9946151B_D1A3_47DB_9668_F71C402E51E6#126867, UN_CODUTI_438349#126623 AS COL_D8912422_1CEB_4A32_9170_75D29B492BB7#126868, UN_DATMAJ_438350#126629 AS COL_7893AA98_1C78_44EA_8443_153F57E306DA#126869, UN_CODSIT_438351#126621 AS COL_18582FF1_F7A4_419F_8048_ADAC5A69F1F4#126870, UN_MODTRT_438352#126638 AS COL_B7C95DF9_744C_4867_8207_C76D4578947A#126871, UN_DISPRE_438353#126630 AS COL_E40EECCB_F6FC_4509_8285_B53E1A456DE8#126872, UN_CODSOC_438354#126622 AS COL_ED2B7A08_28B1_47E5_A8AB_7436B43C0D8C#126873, UN_NUMCPT_A_438355#126641 AS COL_1B216C55_17C2_4395_874D_5929728B9368#126874, UN_NUMCPT_F_438356#126643 AS COL_58E842AA_5A4D_43AD_9F8E_1A831DA296EB#126875, UN_NUMCPT_C_438357#126642 AS COL_18902568_A23E_4F1F_8709_86E32242E97F#126876, UN_CHEFSER_438358#126617 AS COL_7D611DEA_35F8_4357_8F2D_7DC9276C3516#126877, UN_DATEDE_438359#126627 AS COL_F3CA48A8_1151_4FA7_965D_6B276403E016#126878, UN_DATEFI_438360#126628 AS COL_55CE341B_20D4_458B_8F1B_9A2D0D2B092F#126879, UN_COMMENT_438361#126624 AS COL_D559400C_A64A_4D06_AAD7_78D1D7C0DBC8#126880, UN_FLICPT_438362#126634 AS COL_0DFC3937_DC80_4673_8036_48A24E99A6F6#126881, UN_XML_P_CPTA_438363#126653 AS COL_E88AF87C_3260_4922_9770_C0E70382BD77#126882, UN_NUMPRF_438364#126644 AS COL_7B1B60B2_4DE6_4623_A692_81BD796BC09A#126883, UN_CSCPT_438365#126626 AS COL_DFF25690_9485_4715_89C5_3322C8EF1339#126884, UN_CSANA_438366#126625 AS COL_93C7A01A_3EB4_41E0_AC7B_B4D46EAEE4EF#126885, UN_CODADM_438367#126618 AS COL_A7DFFAF6_BE6A_4C02_BC23_B6D38505E0F3#126886, UN_MOD_ENVOI_438368#126639 AS COL_B53F4DBB_FA15_4164_8A20_EFC568B567AA#126887, UN_ADR_1_438369#126614 AS COL_3C7B6CAB_0C63_4438_8E13_685F92F2F5D8#126888, UN_ADR_2_438370#126615 AS COL_453F0B07_D8DB_419F_8D45_8E8E3EFCA6BF#126889, UN_ADR_3_438371#126616 AS COL_46DCAFE2_47A9_4687_9FAC_9D6E1ECB84A3#126890, UN_CODPOS_438372#126619 AS COL_6A243090_33D8_4365_BDEF_7D7955EA9488#126891, UN_VILLE_438373#126652 AS COL_944F5827_8971_43C6_A3FA_56EC96B9490C#126892, UN_PAYS_438374#126645 AS COL_25097582_8DA4_4B9C_A5CE_EAEC136C496A#126893]
Input [40]: [UN_ADR_1_438369#126614, UN_ADR_2_438370#126615, UN_ADR_3_438371#126616, UN_CHEFSER_438358#126617, UN_CODADM_438367#126618, UN_CODPOS_438372#126619, UN_CODSER_438335#126620, UN_CODSIT_438351#126621, UN_CODSOC_438354#126622, UN_CODUTI_438349#126623, UN_COMMENT_438361#126624, UN_CSANA_438366#126625, UN_CSCPT_438365#126626, UN_DATEDE_438359#126627, UN_DATEFI_438360#126628, UN_DATMAJ_438350#126629, UN_DISPRE_438353#126630, UN_ENVADM_438347#126631, UN_E_MAIL_438346#126632, UN_FAX_438345#126633, UN_FLICPT_438362#126634, UN_LIB30_438336#126635, UN_LIBCO_438337#126636, UN_LIEU_S_438348#126637, UN_MODTRT_438352#126638, UN_MOD_ENVOI_438368#126639, UN_NATURE_438339#126640, UN_NUMCPT_A_438355#126641, UN_NUMCPT_C_438357#126642, UN_NUMCPT_F_438356#126643, UN_NUMPRF_438364#126644, UN_PAYS_438374#126645, UN_SERV_438338#126646, UN_TELBUR_438344#126647, UN_UF_DEM_438341#126648, UN_UF_EXE_438342#126649, UN_UF_LOC_438343#126650, UN_VALID_438340#126651, UN_VILLE_438373#126652, UN_XML_P_CPTA_438363#126653]

(5) CollectLimit
Input [40]: [COL_FC36F0E3_819E_4F1F_B3DA_747F8D0B3498#126854, COL_C6249CB4_EB19_4A9F_9F08_7F82C075294D#126855, COL_6E14DB13_7968_4E60_B2E0_7D2DBD952425#126856, COL_D4C74997_D244_44C7_BD03_E46A9A0A4746#126857, COL_28844A14_3212_46B2_B056_E6BCEB956520#126858, COL_A263D3EB_4ECF_4AB7_BD02_AB929D3593DD#126859, COL_8397A5D6_5BEC_46CC_A2BD_000FE8A34A3B#126860, COL_14475057_7FAB_4D27_95BB_A16297B5A727#126861, COL_BA393EAA_60E6_49F4_93E8_FAEF1C583084#126862, COL_BC33D938_B8B1_4527_9A60_D024A122F90B#126863, COL_96BA3445_3A85_4367_BCDD_B355134AEECC#126864, COL_1BA3DEDB_C750_475F_92A3_FF7805A40418#126865, COL_9EA8D3BF_2C11_40E7_B842_49488D5F1EDC#126866, COL_9946151B_D1A3_47DB_9668_F71C402E51E6#126867, COL_D8912422_1CEB_4A32_9170_75D29B492BB7#126868, COL_7893AA98_1C78_44EA_8443_153F57E306DA#126869, COL_18582FF1_F7A4_419F_8048_ADAC5A69F1F4#126870, COL_B7C95DF9_744C_4867_8207_C76D4578947A#126871, COL_E40EECCB_F6FC_4509_8285_B53E1A456DE8#126872, COL_ED2B7A08_28B1_47E5_A8AB_7436B43C0D8C#126873, COL_1B216C55_17C2_4395_874D_5929728B9368#126874, COL_58E842AA_5A4D_43AD_9F8E_1A831DA296EB#126875, COL_18902568_A23E_4F1F_8709_86E32242E97F#126876, COL_7D611DEA_35F8_4357_8F2D_7DC9276C3516#126877, COL_F3CA48A8_1151_4FA7_965D_6B276403E016#126878, COL_55CE341B_20D4_458B_8F1B_9A2D0D2B092F#126879, COL_D559400C_A64A_4D06_AAD7_78D1D7C0DBC8#126880, COL_0DFC3937_DC80_4673_8036_48A24E99A6F6#126881, COL_E88AF87C_3260_4922_9770_C0E70382BD77#126882, COL_7B1B60B2_4DE6_4623_A692_81BD796BC09A#126883, COL_DFF25690_9485_4715_89C5_3322C8EF1339#126884, COL_93C7A01A_3EB4_41E0_AC7B_B4D46EAEE4EF#126885, COL_A7DFFAF6_BE6A_4C02_BC23_B6D38505E0F3#126886, COL_B53F4DBB_FA15_4164_8A20_EFC568B567AA#126887, COL_3C7B6CAB_0C63_4438_8E13_685F92F2F5D8#126888, COL_453F0B07_D8DB_419F_8D45_8E8E3EFCA6BF#126889, COL_46DCAFE2_47A9_4687_9FAC_9D6E1ECB84A3#126890, COL_6A243090_33D8_4365_BDEF_7D7955EA9488#126891, COL_944F5827_8971_43C6_A3FA_56EC96B9490C#126892, COL_25097582_8DA4_4B9C_A5CE_EAEC136C496A#126893]
Arguments: 1500

SQL / DataFrame Properties

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