hdh-spark-job - Details for Query 768

Submitted Time: 2026/10/21 21:37:08
Duration: 0.3 s
Succeeded Jobs: 772

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

CollectLimit 1500

Project [VN_NUMEVE_437785#173371 AS COL_672478D8_8F86_48EB_9E57_A416977F0E18#173551, VN_TYPEVE_437786#173384 AS COL_FCB6E4C5_CA9B_4867_8E68_95B8E81658D2#173552, VN_ACTION_437787#173353 AS COL_C562BA8B_63A8_4E90_B967_FC013EB65DBD#173553, VN_TRAITE_437788#173383 AS COL_0FFB4FB7_1632_4BDF_8A7E_DB895B446E87#173554, VN_DATEVE_437789#173357 AS COL_57B779DE_E164_4449_AE87_8404FD1FB6FB#173555, VN_HEUEVE_437790#173361 AS COL_AE130E2C_049E_4A59_9C76_D2BEF12B9C0F#173556, VN_NUMDOS_437791#173368 AS COL_A652772A_338F_4E5E_9332_C57EE19B0A3E#173557, VN_NUMDEM_437792#173366 AS COL_DD44CB79_B00F_4AE2_885D_E49360692C0C#173558, VN_NUMPCO_437793#173378 AS COL_DCCC8191_33FE_4295_80AB_1F79830444AD#173559, VN_NUMCOT_437794#173364 AS COL_80B24156_9B0F_4704_8234_72D9690C6188#173560, VN_NUMCR_437795#173365 AS COL_C981F73F_7534_4B6C_AF47_F61A067C6EC1#173561, VN_NUMFUS_437796#173373 AS COL_4A5E62E8_9C76_43B8_8DDF_4E799328B8E2#173562, VN_NUMEXA_437797#173372 AS COL_72D48A19_576D_44A3_A88C_2A9328791D8F#173563, VN_DATMAJ_437798#173359 AS COL_D154BA97_C149_41B5_A80C_7E0AF525977C#173564, VN_CODUTI_437799#173355 AS COL_1DBC5304_0DEA_4546_9E0C_D08F514B6DF9#173565, VN_CODSIT_437800#173354 AS COL_71BC54A3_593C_4BE6_B99A_48A9C8B022F8#173566, VN_COMMENT_437801#173356 AS COL_9CEF3AC2_B380_4842_9B94_5BD90E5054D0#173567, VN_NUMDRV_437802#173370 AS COL_4D88E233_9F19_4543_B6C5_082FCA81724C#173568, VN_FLMANU_437803#173360 AS COL_5CAEAE90_4D21_4F15_88B0_B39DCDD0C110#173569, VN_DATMAJMANU_437804#173358 AS COL_ADA5BEED_36CB_414D_A335_2E4E551BD756#173570, VN_HEUMAJMANU_437805#173362 AS COL_68A93206_4115_416F_996C_92D60DC27BD9#173571, VN_STA_ENV_437806#173382 AS COL_DC540DF5_1109_436A_B336_86ECDC69A4FF#173572, VN_NUMDOS_DEST_437807#173369 AS COL_FBE9B6F8_F9A5_4268_9670_A0AC4E99851A#173573, VN_NUMDEM_DEST_437808#173367 AS COL_C6D12190_1F86_4865_9E67_E5C3F643F5A6#173574, ... 9 more fields]

Filter ((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(VN_NUMEVE_437785#173371)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(VN_NUMEVE_437785#173371)), A63000893163) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(VN_TYPEVE_437786#173384)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(VN_TYPEVE_437786#173384)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(VN_ACTION_437787#173353)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(VN_ACTION_437787#173353)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(VN_TRAITE_437788#173383)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(VN_TRAITE_437788#173383)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(VN_DATEVE_437789#173357)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(VN_DATEVE_437789#173357)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(VN_HEUEVE_437790#173361)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(VN_HEUEVE_437790#173361)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(VN_NUMDOS_437791#173368)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(VN_NUMDOS_437791#173368)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(VN_NUMDEM_437792#173366)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(VN_NUMDEM_437792#173366)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(VN_NUMPCO_437793#173378)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(VN_NUMPCO_437793#173378)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(VN_NUMCOT_437794#173364)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(VN_NUMCOT_437794#173364)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(VN_NUMCR_437795#173365)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(VN_NUMCR_437795#173365)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(VN_NUMFUS_437796#173373)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(VN_NUMFUS_437796#173373)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(VN_NUMEXA_437797#173372)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(VN_NUMEXA_437797#173372)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(VN_DATMAJ_437798#173359)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(VN_DATMAJ_437798#173359)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(VN_CODUTI_437799#173355)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(VN_CODUTI_437799#173355)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(VN_CODSIT_437800#173354)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(VN_CODSIT_437800#173354)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(VN_COMMENT_437801#173356)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(VN_COMMENT_437801#173356)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(VN_NUMDRV_437802#173370)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(VN_NUMDRV_437802#173370)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(VN_FLMANU_437803#173360)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(VN_FLMANU_437803#173360)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(VN_DATMAJMANU_437804#173358)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(VN_DATMAJMANU_437804#173358)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(VN_HEUMAJMANU_437805#173362)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(VN_HEUMAJMANU_437805#173362)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(VN_STA_ENV_437806#173382)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(VN_STA_ENV_437806#173382)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(VN_NUMDOS_DEST_437807#173369)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(VN_NUMDOS_DEST_437807#173369)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(VN_NUMDEM_DEST_437808#173367)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(VN_NUMDEM_DEST_437808#173367)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(VN_SIGMA_437809#173381)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(VN_SIGMA_437809#173381)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(VN_NUMRESA_437810#173379)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(VN_NUMRESA_437810#173379)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(VN_NUMPAN_437811#173377)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(VN_NUMPAN_437811#173377)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(VN_XMLDATA_437812#173385)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(VN_XMLDATA_437812#173385)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(VN_NUMMCR_437813#173375)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(VN_NUMMCR_437813#173375)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(VN_NUMSTU_437814#173380)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(VN_NUMSTU_437814#173380)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(VN_NUMCDE_437815#173363)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(VN_NUMCDE_437815#173363)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(VN_NUMLCD_437816#173374)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(VN_NUMLCD_437816#173374)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(VN_NUMMVT_437817#173376)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(VN_NUMMVT_437817#173376)), A63000893163) END)

ColumnarToRow

WholeStageCodegen (1)

FileScan parquet [VN_ACTION_437787#173353,VN_CODSIT_437800#173354,VN_CODUTI_437799#173355,VN_COMMENT_437801#173356,VN_DATEVE_437789#173357,VN_DATMAJMANU_437804#173358,VN_DATMAJ_437798#173359,VN_FLMANU_437803#173360,VN_HEUEVE_437790#173361,VN_HEUMAJMANU_437805#173362,VN_NUMCDE_437815#173363,VN_NUMCOT_437794#173364,VN_NUMCR_437795#173365,VN_NUMDEM_437792#173366,VN_NUMDEM_DEST_437808#173367,VN_NUMDOS_437791#173368,VN_NUMDOS_DEST_437807#173369,VN_NUMDRV_437802#173370,VN_NUMEVE_437785#173371,VN_NUMEXA_437797#173372,VN_NUMFUS_437796#173373,VN_NUMLCD_437816#173374,VN_NUMMCR_437813#173375,VN_NUMMVT_437817#173376,... 9 more fields] Batched: true, DataFilters: [((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(VN_NUMEVE_4377..., Format: Parquet, Location: InMemoryFileIndex(1 paths)[file:/data/output/cache/parquet/uet/H_EVEN_437784], PartitionFilters: [], PushedFilters: [], ReadSchema: struct<VN_ACTION_437787:string,VN_CODSIT_437800:string,VN_CODUTI_437799:string,VN_COMMENT_437801:...

Details

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


(1) Scan parquet 
Output [33]: [VN_ACTION_437787#173353, VN_CODSIT_437800#173354, VN_CODUTI_437799#173355, VN_COMMENT_437801#173356, VN_DATEVE_437789#173357, VN_DATMAJMANU_437804#173358, VN_DATMAJ_437798#173359, VN_FLMANU_437803#173360, VN_HEUEVE_437790#173361, VN_HEUMAJMANU_437805#173362, VN_NUMCDE_437815#173363, VN_NUMCOT_437794#173364, VN_NUMCR_437795#173365, VN_NUMDEM_437792#173366, VN_NUMDEM_DEST_437808#173367, VN_NUMDOS_437791#173368, VN_NUMDOS_DEST_437807#173369, VN_NUMDRV_437802#173370, VN_NUMEVE_437785#173371, VN_NUMEXA_437797#173372, VN_NUMFUS_437796#173373, VN_NUMLCD_437816#173374, VN_NUMMCR_437813#173375, VN_NUMMVT_437817#173376, VN_NUMPAN_437811#173377, VN_NUMPCO_437793#173378, VN_NUMRESA_437810#173379, VN_NUMSTU_437814#173380, VN_SIGMA_437809#173381, VN_STA_ENV_437806#173382, VN_TRAITE_437788#173383, VN_TYPEVE_437786#173384, VN_XMLDATA_437812#173385]
Batched: true
Location: InMemoryFileIndex [file:/data/output/cache/parquet/uet/H_EVEN_437784]
ReadSchema: struct<VN_ACTION_437787:string,VN_CODSIT_437800:string,VN_CODUTI_437799:string,VN_COMMENT_437801:string,VN_DATEVE_437789:string,VN_DATMAJMANU_437804:string,VN_DATMAJ_437798:string,VN_FLMANU_437803:string,VN_HEUEVE_437790:string,VN_HEUMAJMANU_437805:string,VN_NUMCDE_437815:string,VN_NUMCOT_437794:string,VN_NUMCR_437795:string,VN_NUMDEM_437792:string,VN_NUMDEM_DEST_437808:string,VN_NUMDOS_437791:string,VN_NUMDOS_DEST_437807:string,VN_NUMDRV_437802:string,VN_NUMEVE_437785:string,VN_NUMEXA_437797:string,VN_NUMFUS_437796:string,VN_NUMLCD_437816:string,VN_NUMMCR_437813:string,VN_NUMMVT_437817:string,VN_NUMPAN_437811:string,VN_NUMPCO_437793:string,VN_NUMRESA_437810:string,VN_NUMSTU_437814:string,VN_SIGMA_437809:string,VN_STA_ENV_437806:string,VN_TRAITE_437788:string,VN_TYPEVE_437786:string,VN_XMLDATA_437812:string>

(2) ColumnarToRow [codegen id : 1]
Input [33]: [VN_ACTION_437787#173353, VN_CODSIT_437800#173354, VN_CODUTI_437799#173355, VN_COMMENT_437801#173356, VN_DATEVE_437789#173357, VN_DATMAJMANU_437804#173358, VN_DATMAJ_437798#173359, VN_FLMANU_437803#173360, VN_HEUEVE_437790#173361, VN_HEUMAJMANU_437805#173362, VN_NUMCDE_437815#173363, VN_NUMCOT_437794#173364, VN_NUMCR_437795#173365, VN_NUMDEM_437792#173366, VN_NUMDEM_DEST_437808#173367, VN_NUMDOS_437791#173368, VN_NUMDOS_DEST_437807#173369, VN_NUMDRV_437802#173370, VN_NUMEVE_437785#173371, VN_NUMEXA_437797#173372, VN_NUMFUS_437796#173373, VN_NUMLCD_437816#173374, VN_NUMMCR_437813#173375, VN_NUMMVT_437817#173376, VN_NUMPAN_437811#173377, VN_NUMPCO_437793#173378, VN_NUMRESA_437810#173379, VN_NUMSTU_437814#173380, VN_SIGMA_437809#173381, VN_STA_ENV_437806#173382, VN_TRAITE_437788#173383, VN_TYPEVE_437786#173384, VN_XMLDATA_437812#173385]

(3) Filter [codegen id : 1]
Input [33]: [VN_ACTION_437787#173353, VN_CODSIT_437800#173354, VN_CODUTI_437799#173355, VN_COMMENT_437801#173356, VN_DATEVE_437789#173357, VN_DATMAJMANU_437804#173358, VN_DATMAJ_437798#173359, VN_FLMANU_437803#173360, VN_HEUEVE_437790#173361, VN_HEUMAJMANU_437805#173362, VN_NUMCDE_437815#173363, VN_NUMCOT_437794#173364, VN_NUMCR_437795#173365, VN_NUMDEM_437792#173366, VN_NUMDEM_DEST_437808#173367, VN_NUMDOS_437791#173368, VN_NUMDOS_DEST_437807#173369, VN_NUMDRV_437802#173370, VN_NUMEVE_437785#173371, VN_NUMEXA_437797#173372, VN_NUMFUS_437796#173373, VN_NUMLCD_437816#173374, VN_NUMMCR_437813#173375, VN_NUMMVT_437817#173376, VN_NUMPAN_437811#173377, VN_NUMPCO_437793#173378, VN_NUMRESA_437810#173379, VN_NUMSTU_437814#173380, VN_SIGMA_437809#173381, VN_STA_ENV_437806#173382, VN_TRAITE_437788#173383, VN_TYPEVE_437786#173384, VN_XMLDATA_437812#173385]
Condition : ((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(VN_NUMEVE_437785#173371)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(VN_NUMEVE_437785#173371)), A63000893163) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(VN_TYPEVE_437786#173384)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(VN_TYPEVE_437786#173384)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(VN_ACTION_437787#173353)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(VN_ACTION_437787#173353)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(VN_TRAITE_437788#173383)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(VN_TRAITE_437788#173383)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(VN_DATEVE_437789#173357)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(VN_DATEVE_437789#173357)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(VN_HEUEVE_437790#173361)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(VN_HEUEVE_437790#173361)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(VN_NUMDOS_437791#173368)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(VN_NUMDOS_437791#173368)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(VN_NUMDEM_437792#173366)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(VN_NUMDEM_437792#173366)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(VN_NUMPCO_437793#173378)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(VN_NUMPCO_437793#173378)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(VN_NUMCOT_437794#173364)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(VN_NUMCOT_437794#173364)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(VN_NUMCR_437795#173365)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(VN_NUMCR_437795#173365)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(VN_NUMFUS_437796#173373)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(VN_NUMFUS_437796#173373)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(VN_NUMEXA_437797#173372)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(VN_NUMEXA_437797#173372)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(VN_DATMAJ_437798#173359)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(VN_DATMAJ_437798#173359)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(VN_CODUTI_437799#173355)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(VN_CODUTI_437799#173355)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(VN_CODSIT_437800#173354)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(VN_CODSIT_437800#173354)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(VN_COMMENT_437801#173356)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(VN_COMMENT_437801#173356)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(VN_NUMDRV_437802#173370)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(VN_NUMDRV_437802#173370)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(VN_FLMANU_437803#173360)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(VN_FLMANU_437803#173360)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(VN_DATMAJMANU_437804#173358)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(VN_DATMAJMANU_437804#173358)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(VN_HEUMAJMANU_437805#173362)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(VN_HEUMAJMANU_437805#173362)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(VN_STA_ENV_437806#173382)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(VN_STA_ENV_437806#173382)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(VN_NUMDOS_DEST_437807#173369)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(VN_NUMDOS_DEST_437807#173369)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(VN_NUMDEM_DEST_437808#173367)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(VN_NUMDEM_DEST_437808#173367)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(VN_SIGMA_437809#173381)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(VN_SIGMA_437809#173381)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(VN_NUMRESA_437810#173379)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(VN_NUMRESA_437810#173379)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(VN_NUMPAN_437811#173377)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(VN_NUMPAN_437811#173377)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(VN_XMLDATA_437812#173385)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(VN_XMLDATA_437812#173385)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(VN_NUMMCR_437813#173375)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(VN_NUMMCR_437813#173375)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(VN_NUMSTU_437814#173380)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(VN_NUMSTU_437814#173380)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(VN_NUMCDE_437815#173363)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(VN_NUMCDE_437815#173363)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(VN_NUMLCD_437816#173374)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(VN_NUMLCD_437816#173374)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(VN_NUMMVT_437817#173376)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(VN_NUMMVT_437817#173376)), A63000893163) END)

(4) Project [codegen id : 1]
Output [33]: [VN_NUMEVE_437785#173371 AS COL_672478D8_8F86_48EB_9E57_A416977F0E18#173551, VN_TYPEVE_437786#173384 AS COL_FCB6E4C5_CA9B_4867_8E68_95B8E81658D2#173552, VN_ACTION_437787#173353 AS COL_C562BA8B_63A8_4E90_B967_FC013EB65DBD#173553, VN_TRAITE_437788#173383 AS COL_0FFB4FB7_1632_4BDF_8A7E_DB895B446E87#173554, VN_DATEVE_437789#173357 AS COL_57B779DE_E164_4449_AE87_8404FD1FB6FB#173555, VN_HEUEVE_437790#173361 AS COL_AE130E2C_049E_4A59_9C76_D2BEF12B9C0F#173556, VN_NUMDOS_437791#173368 AS COL_A652772A_338F_4E5E_9332_C57EE19B0A3E#173557, VN_NUMDEM_437792#173366 AS COL_DD44CB79_B00F_4AE2_885D_E49360692C0C#173558, VN_NUMPCO_437793#173378 AS COL_DCCC8191_33FE_4295_80AB_1F79830444AD#173559, VN_NUMCOT_437794#173364 AS COL_80B24156_9B0F_4704_8234_72D9690C6188#173560, VN_NUMCR_437795#173365 AS COL_C981F73F_7534_4B6C_AF47_F61A067C6EC1#173561, VN_NUMFUS_437796#173373 AS COL_4A5E62E8_9C76_43B8_8DDF_4E799328B8E2#173562, VN_NUMEXA_437797#173372 AS COL_72D48A19_576D_44A3_A88C_2A9328791D8F#173563, VN_DATMAJ_437798#173359 AS COL_D154BA97_C149_41B5_A80C_7E0AF525977C#173564, VN_CODUTI_437799#173355 AS COL_1DBC5304_0DEA_4546_9E0C_D08F514B6DF9#173565, VN_CODSIT_437800#173354 AS COL_71BC54A3_593C_4BE6_B99A_48A9C8B022F8#173566, VN_COMMENT_437801#173356 AS COL_9CEF3AC2_B380_4842_9B94_5BD90E5054D0#173567, VN_NUMDRV_437802#173370 AS COL_4D88E233_9F19_4543_B6C5_082FCA81724C#173568, VN_FLMANU_437803#173360 AS COL_5CAEAE90_4D21_4F15_88B0_B39DCDD0C110#173569, VN_DATMAJMANU_437804#173358 AS COL_ADA5BEED_36CB_414D_A335_2E4E551BD756#173570, VN_HEUMAJMANU_437805#173362 AS COL_68A93206_4115_416F_996C_92D60DC27BD9#173571, VN_STA_ENV_437806#173382 AS COL_DC540DF5_1109_436A_B336_86ECDC69A4FF#173572, VN_NUMDOS_DEST_437807#173369 AS COL_FBE9B6F8_F9A5_4268_9670_A0AC4E99851A#173573, VN_NUMDEM_DEST_437808#173367 AS COL_C6D12190_1F86_4865_9E67_E5C3F643F5A6#173574, VN_SIGMA_437809#173381 AS COL_40255B31_6FEE_42FB_AEE1_B2F9051C85BE#173575, VN_NUMRESA_437810#173379 AS COL_C952776B_50C4_435B_ACED_D4B1FBA5EC31#173576, VN_NUMPAN_437811#173377 AS COL_E3EBFE4A_4EB6_4BD7_A228_72380EB0FECD#173577, VN_XMLDATA_437812#173385 AS COL_A0DFDF86_1F87_4C1E_8CCE_1592138AA31D#173578, VN_NUMMCR_437813#173375 AS COL_D6080E8F_FB43_4B6C_B08E_927F0A5D3A84#173579, VN_NUMSTU_437814#173380 AS COL_F0526557_12ED_434E_A868_8ED6357890B4#173580, VN_NUMCDE_437815#173363 AS COL_B8DE1661_3D33_473A_9585_C0D61480D3A1#173581, VN_NUMLCD_437816#173374 AS COL_4438E7F8_9F13_4199_A7D2_DD2176CF6667#173582, VN_NUMMVT_437817#173376 AS COL_8E9B2D81_FAD3_4CB1_851A_FDCA84EACF77#173583]
Input [33]: [VN_ACTION_437787#173353, VN_CODSIT_437800#173354, VN_CODUTI_437799#173355, VN_COMMENT_437801#173356, VN_DATEVE_437789#173357, VN_DATMAJMANU_437804#173358, VN_DATMAJ_437798#173359, VN_FLMANU_437803#173360, VN_HEUEVE_437790#173361, VN_HEUMAJMANU_437805#173362, VN_NUMCDE_437815#173363, VN_NUMCOT_437794#173364, VN_NUMCR_437795#173365, VN_NUMDEM_437792#173366, VN_NUMDEM_DEST_437808#173367, VN_NUMDOS_437791#173368, VN_NUMDOS_DEST_437807#173369, VN_NUMDRV_437802#173370, VN_NUMEVE_437785#173371, VN_NUMEXA_437797#173372, VN_NUMFUS_437796#173373, VN_NUMLCD_437816#173374, VN_NUMMCR_437813#173375, VN_NUMMVT_437817#173376, VN_NUMPAN_437811#173377, VN_NUMPCO_437793#173378, VN_NUMRESA_437810#173379, VN_NUMSTU_437814#173380, VN_SIGMA_437809#173381, VN_STA_ENV_437806#173382, VN_TRAITE_437788#173383, VN_TYPEVE_437786#173384, VN_XMLDATA_437812#173385]

(5) CollectLimit
Input [33]: [COL_672478D8_8F86_48EB_9E57_A416977F0E18#173551, COL_FCB6E4C5_CA9B_4867_8E68_95B8E81658D2#173552, COL_C562BA8B_63A8_4E90_B967_FC013EB65DBD#173553, COL_0FFB4FB7_1632_4BDF_8A7E_DB895B446E87#173554, COL_57B779DE_E164_4449_AE87_8404FD1FB6FB#173555, COL_AE130E2C_049E_4A59_9C76_D2BEF12B9C0F#173556, COL_A652772A_338F_4E5E_9332_C57EE19B0A3E#173557, COL_DD44CB79_B00F_4AE2_885D_E49360692C0C#173558, COL_DCCC8191_33FE_4295_80AB_1F79830444AD#173559, COL_80B24156_9B0F_4704_8234_72D9690C6188#173560, COL_C981F73F_7534_4B6C_AF47_F61A067C6EC1#173561, COL_4A5E62E8_9C76_43B8_8DDF_4E799328B8E2#173562, COL_72D48A19_576D_44A3_A88C_2A9328791D8F#173563, COL_D154BA97_C149_41B5_A80C_7E0AF525977C#173564, COL_1DBC5304_0DEA_4546_9E0C_D08F514B6DF9#173565, COL_71BC54A3_593C_4BE6_B99A_48A9C8B022F8#173566, COL_9CEF3AC2_B380_4842_9B94_5BD90E5054D0#173567, COL_4D88E233_9F19_4543_B6C5_082FCA81724C#173568, COL_5CAEAE90_4D21_4F15_88B0_B39DCDD0C110#173569, COL_ADA5BEED_36CB_414D_A335_2E4E551BD756#173570, COL_68A93206_4115_416F_996C_92D60DC27BD9#173571, COL_DC540DF5_1109_436A_B336_86ECDC69A4FF#173572, COL_FBE9B6F8_F9A5_4268_9670_A0AC4E99851A#173573, COL_C6D12190_1F86_4865_9E67_E5C3F643F5A6#173574, COL_40255B31_6FEE_42FB_AEE1_B2F9051C85BE#173575, COL_C952776B_50C4_435B_ACED_D4B1FBA5EC31#173576, COL_E3EBFE4A_4EB6_4BD7_A228_72380EB0FECD#173577, COL_A0DFDF86_1F87_4C1E_8CCE_1592138AA31D#173578, COL_D6080E8F_FB43_4B6C_B08E_927F0A5D3A84#173579, COL_F0526557_12ED_434E_A868_8ED6357890B4#173580, COL_B8DE1661_3D33_473A_9585_C0D61480D3A1#173581, COL_4438E7F8_9F13_4199_A7D2_DD2176CF6667#173582, COL_8E9B2D81_FAD3_4CB1_851A_FDCA84EACF77#173583]
Arguments: 1500

SQL / DataFrame Properties

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