hdh-spark-job - Details for Query 761

Submitted Time: 2026/10/21 21:36:59
Duration: 0.5 s
Succeeded Jobs: 762

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

CollectLimit 1500

Project [JN_NUMJOU_437910#170362 AS COL_83767C93_A141_4C9C_8EF7_B5B481B30EE7#170648, JN_ACTION_437911#170344 AS COL_22CEA9F0_3F69_4039_8A13_75B28EB137F6#170649, JN_TYPJOU_437912#170370 AS COL_2AC59C5B_776E_4288_A554_59A801AD7321#170650, JN_TABLE_437913#170368 AS COL_0D0B9F1D_022F_4347_B678_3191F3B9C8C9#170651, JN_DATJOU_437914#170349 AS COL_E362A659_3F6F_4C21_8FCE_8E321609DB9B#170652, JN_HEUJOU_437915#170352 AS COL_E8C411DC_53A0_45F2_9E02_790459390C6A#170653, JN_CODPER_437916#170345 AS COL_E28DCDE8_078A_409B_A530_74FC278F03C1#170654, JN_NUMDOS_437917#170356 AS COL_D5607502_E8CA_4045_8D8A_B786B7AE3F7B#170655, JN_NUMDEM_437918#170355 AS COL_398AF484_33AF_4DB8_AF1D_65D04EC18E4C#170656, JN_NUMEXA_437919#170359 AS COL_67622320_1823_46D9_81E3_BC9357168E85#170657, JN_NUMDRV_437920#170357 AS COL_2B62B381_F2BC_492B_9B5D_9923B084956E#170658, JN_NUMCR_437921#170354 AS COL_5DE21EEA_FF38_4685_B8C3_B07CDD6492E0#170659, JN_NUMFUS_437922#170360 AS COL_24999C15_F7CD_4E12_8225_578C3F6E8A79#170660, JN_COMMENT_437923#170347 AS COL_300A88FE_FA44_4EAF_870E_252C6EA3C56D#170661, JN_CODSIT_437924#170346 AS COL_54727353_DB4E_4E11_AC56_BA96D026D5F8#170662, JN_XMLDATA_437925#170371 AS COL_2ABEE95A_70A0_42AE_A903_BB621197B0ED#170663, JN_PRG_CODE_437926#170367 AS COL_DD7F4E40_CBBC_4034_AB0E_5C05A8F726D8#170664, JN_TERMINAL_437927#170369 AS COL_0E1872A0_8B6E_4733_9EA1_E6B1254FF973#170665, JN_OSUSER_437928#170366 AS COL_78BB7AEA_2CF8_47A9_9E81_A3D415D920DE#170666, JN_IP_ADDRESS_437929#170353 AS COL_1CA36529_9D2B_4D15_A5C3_FFF06EB3E327#170667, JN_FLENV_437930#170351 AS COL_E3244541_9487_4DE4_87FC_E411037CF183#170668, JN_DATENV_437931#170348 AS COL_4385B164_2EAE_488F_9EBD_14ABFA26AD1A#170669, JN_NUMENT_437932#170358 AS COL_1AD8A979_EC6B_435B_B3B4_D93CDB5A721B#170670, JN_NUMSTU_437933#170365 AS COL_9C166E1A_DC39_4F9C_822E_968A70553F34#170671, ... 4 more fields]

Filter (((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(JN_NUMJOU_437910#170362)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(JN_NUMJOU_437910#170362)), A63000893163) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(JN_ACTION_437911#170344)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(JN_ACTION_437911#170344)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(JN_TYPJOU_437912#170370)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(JN_TYPJOU_437912#170370)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(JN_TABLE_437913#170368)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(JN_TABLE_437913#170368)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(JN_DATJOU_437914#170349)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(JN_DATJOU_437914#170349)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(JN_HEUJOU_437915#170352)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(JN_HEUJOU_437915#170352)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(JN_CODPER_437916#170345)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(JN_CODPER_437916#170345)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(JN_NUMDOS_437917#170356)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(JN_NUMDOS_437917#170356)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(JN_NUMDEM_437918#170355)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(JN_NUMDEM_437918#170355)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(JN_NUMEXA_437919#170359)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(JN_NUMEXA_437919#170359)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(JN_NUMDRV_437920#170357)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(JN_NUMDRV_437920#170357)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(JN_NUMCR_437921#170354)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(JN_NUMCR_437921#170354)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(JN_NUMFUS_437922#170360)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(JN_NUMFUS_437922#170360)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(JN_COMMENT_437923#170347)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(JN_COMMENT_437923#170347)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(JN_CODSIT_437924#170346)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(JN_CODSIT_437924#170346)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(JN_XMLDATA_437925#170371)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(JN_XMLDATA_437925#170371)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(JN_PRG_CODE_437926#170367)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(JN_PRG_CODE_437926#170367)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(JN_TERMINAL_437927#170369)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(JN_TERMINAL_437927#170369)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(JN_OSUSER_437928#170366)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(JN_OSUSER_437928#170366)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(JN_IP_ADDRESS_437929#170353)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(JN_IP_ADDRESS_437929#170353)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(JN_FLENV_437930#170351)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(JN_FLENV_437930#170351)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(JN_DATENV_437931#170348)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(JN_DATENV_437931#170348)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(JN_NUMENT_437932#170358)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(JN_NUMENT_437932#170358)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(JN_NUMSTU_437933#170365)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(JN_NUMSTU_437933#170365)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(JN_NUMSER_437934#170364)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(JN_NUMSER_437934#170364)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(JN_NUMIMA_437935#170361)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(JN_NUMIMA_437935#170361)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(JN_NUMRB_437936#170363)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(JN_NUMRB_437936#170363)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(JN_DURSEC_437937#170350)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(JN_DURSEC_437937#170350)), A63000893163) END)

ColumnarToRow

WholeStageCodegen (1)

FileScan parquet [JN_ACTION_437911#170344,JN_CODPER_437916#170345,JN_CODSIT_437924#170346,JN_COMMENT_437923#170347,JN_DATENV_437931#170348,JN_DATJOU_437914#170349,JN_DURSEC_437937#170350,JN_FLENV_437930#170351,JN_HEUJOU_437915#170352,JN_IP_ADDRESS_437929#170353,JN_NUMCR_437921#170354,JN_NUMDEM_437918#170355,JN_NUMDOS_437917#170356,JN_NUMDRV_437920#170357,JN_NUMENT_437932#170358,JN_NUMEXA_437919#170359,JN_NUMFUS_437922#170360,JN_NUMIMA_437935#170361,JN_NUMJOU_437910#170362,JN_NUMRB_437936#170363,JN_NUMSER_437934#170364,JN_NUMSTU_437933#170365,JN_OSUSER_437928#170366,JN_PRG_CODE_437926#170367,... 4 more fields] Batched: true, DataFilters: [(((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(JN_NUMJOU_437910#17..., Format: Parquet, Location: InMemoryFileIndex(1 paths)[file:/data/output/cache/parquet/uet/H_JOURNAL_437909], PartitionFilters: [], PushedFilters: [], ReadSchema: struct<JN_ACTION_437911:string,JN_CODPER_437916:string,JN_CODSIT_437924:string,JN_COMMENT_437923:...

Details

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


(1) Scan parquet 
Output [28]: [JN_ACTION_437911#170344, JN_CODPER_437916#170345, JN_CODSIT_437924#170346, JN_COMMENT_437923#170347, JN_DATENV_437931#170348, JN_DATJOU_437914#170349, JN_DURSEC_437937#170350, JN_FLENV_437930#170351, JN_HEUJOU_437915#170352, JN_IP_ADDRESS_437929#170353, JN_NUMCR_437921#170354, JN_NUMDEM_437918#170355, JN_NUMDOS_437917#170356, JN_NUMDRV_437920#170357, JN_NUMENT_437932#170358, JN_NUMEXA_437919#170359, JN_NUMFUS_437922#170360, JN_NUMIMA_437935#170361, JN_NUMJOU_437910#170362, JN_NUMRB_437936#170363, JN_NUMSER_437934#170364, JN_NUMSTU_437933#170365, JN_OSUSER_437928#170366, JN_PRG_CODE_437926#170367, JN_TABLE_437913#170368, JN_TERMINAL_437927#170369, JN_TYPJOU_437912#170370, JN_XMLDATA_437925#170371]
Batched: true
Location: InMemoryFileIndex [file:/data/output/cache/parquet/uet/H_JOURNAL_437909]
ReadSchema: struct<JN_ACTION_437911:string,JN_CODPER_437916:string,JN_CODSIT_437924:string,JN_COMMENT_437923:string,JN_DATENV_437931:string,JN_DATJOU_437914:string,JN_DURSEC_437937:string,JN_FLENV_437930:string,JN_HEUJOU_437915:string,JN_IP_ADDRESS_437929:string,JN_NUMCR_437921:string,JN_NUMDEM_437918:string,JN_NUMDOS_437917:string,JN_NUMDRV_437920:string,JN_NUMENT_437932:string,JN_NUMEXA_437919:string,JN_NUMFUS_437922:string,JN_NUMIMA_437935:string,JN_NUMJOU_437910:string,JN_NUMRB_437936:string,JN_NUMSER_437934:string,JN_NUMSTU_437933:string,JN_OSUSER_437928:string,JN_PRG_CODE_437926:string,JN_TABLE_437913:string,JN_TERMINAL_437927:string,JN_TYPJOU_437912:string,JN_XMLDATA_437925:string>

(2) ColumnarToRow [codegen id : 1]
Input [28]: [JN_ACTION_437911#170344, JN_CODPER_437916#170345, JN_CODSIT_437924#170346, JN_COMMENT_437923#170347, JN_DATENV_437931#170348, JN_DATJOU_437914#170349, JN_DURSEC_437937#170350, JN_FLENV_437930#170351, JN_HEUJOU_437915#170352, JN_IP_ADDRESS_437929#170353, JN_NUMCR_437921#170354, JN_NUMDEM_437918#170355, JN_NUMDOS_437917#170356, JN_NUMDRV_437920#170357, JN_NUMENT_437932#170358, JN_NUMEXA_437919#170359, JN_NUMFUS_437922#170360, JN_NUMIMA_437935#170361, JN_NUMJOU_437910#170362, JN_NUMRB_437936#170363, JN_NUMSER_437934#170364, JN_NUMSTU_437933#170365, JN_OSUSER_437928#170366, JN_PRG_CODE_437926#170367, JN_TABLE_437913#170368, JN_TERMINAL_437927#170369, JN_TYPJOU_437912#170370, JN_XMLDATA_437925#170371]

(3) Filter [codegen id : 1]
Input [28]: [JN_ACTION_437911#170344, JN_CODPER_437916#170345, JN_CODSIT_437924#170346, JN_COMMENT_437923#170347, JN_DATENV_437931#170348, JN_DATJOU_437914#170349, JN_DURSEC_437937#170350, JN_FLENV_437930#170351, JN_HEUJOU_437915#170352, JN_IP_ADDRESS_437929#170353, JN_NUMCR_437921#170354, JN_NUMDEM_437918#170355, JN_NUMDOS_437917#170356, JN_NUMDRV_437920#170357, JN_NUMENT_437932#170358, JN_NUMEXA_437919#170359, JN_NUMFUS_437922#170360, JN_NUMIMA_437935#170361, JN_NUMJOU_437910#170362, JN_NUMRB_437936#170363, JN_NUMSER_437934#170364, JN_NUMSTU_437933#170365, JN_OSUSER_437928#170366, JN_PRG_CODE_437926#170367, JN_TABLE_437913#170368, JN_TERMINAL_437927#170369, JN_TYPJOU_437912#170370, JN_XMLDATA_437925#170371]
Condition : (((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(JN_NUMJOU_437910#170362)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(JN_NUMJOU_437910#170362)), A63000893163) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(JN_ACTION_437911#170344)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(JN_ACTION_437911#170344)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(JN_TYPJOU_437912#170370)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(JN_TYPJOU_437912#170370)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(JN_TABLE_437913#170368)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(JN_TABLE_437913#170368)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(JN_DATJOU_437914#170349)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(JN_DATJOU_437914#170349)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(JN_HEUJOU_437915#170352)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(JN_HEUJOU_437915#170352)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(JN_CODPER_437916#170345)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(JN_CODPER_437916#170345)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(JN_NUMDOS_437917#170356)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(JN_NUMDOS_437917#170356)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(JN_NUMDEM_437918#170355)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(JN_NUMDEM_437918#170355)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(JN_NUMEXA_437919#170359)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(JN_NUMEXA_437919#170359)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(JN_NUMDRV_437920#170357)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(JN_NUMDRV_437920#170357)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(JN_NUMCR_437921#170354)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(JN_NUMCR_437921#170354)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(JN_NUMFUS_437922#170360)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(JN_NUMFUS_437922#170360)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(JN_COMMENT_437923#170347)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(JN_COMMENT_437923#170347)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(JN_CODSIT_437924#170346)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(JN_CODSIT_437924#170346)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(JN_XMLDATA_437925#170371)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(JN_XMLDATA_437925#170371)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(JN_PRG_CODE_437926#170367)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(JN_PRG_CODE_437926#170367)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(JN_TERMINAL_437927#170369)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(JN_TERMINAL_437927#170369)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(JN_OSUSER_437928#170366)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(JN_OSUSER_437928#170366)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(JN_IP_ADDRESS_437929#170353)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(JN_IP_ADDRESS_437929#170353)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(JN_FLENV_437930#170351)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(JN_FLENV_437930#170351)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(JN_DATENV_437931#170348)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(JN_DATENV_437931#170348)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(JN_NUMENT_437932#170358)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(JN_NUMENT_437932#170358)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(JN_NUMSTU_437933#170365)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(JN_NUMSTU_437933#170365)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(JN_NUMSER_437934#170364)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(JN_NUMSER_437934#170364)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(JN_NUMIMA_437935#170361)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(JN_NUMIMA_437935#170361)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(JN_NUMRB_437936#170363)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(JN_NUMRB_437936#170363)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(JN_DURSEC_437937#170350)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(JN_DURSEC_437937#170350)), A63000893163) END)

(4) Project [codegen id : 1]
Output [28]: [JN_NUMJOU_437910#170362 AS COL_83767C93_A141_4C9C_8EF7_B5B481B30EE7#170648, JN_ACTION_437911#170344 AS COL_22CEA9F0_3F69_4039_8A13_75B28EB137F6#170649, JN_TYPJOU_437912#170370 AS COL_2AC59C5B_776E_4288_A554_59A801AD7321#170650, JN_TABLE_437913#170368 AS COL_0D0B9F1D_022F_4347_B678_3191F3B9C8C9#170651, JN_DATJOU_437914#170349 AS COL_E362A659_3F6F_4C21_8FCE_8E321609DB9B#170652, JN_HEUJOU_437915#170352 AS COL_E8C411DC_53A0_45F2_9E02_790459390C6A#170653, JN_CODPER_437916#170345 AS COL_E28DCDE8_078A_409B_A530_74FC278F03C1#170654, JN_NUMDOS_437917#170356 AS COL_D5607502_E8CA_4045_8D8A_B786B7AE3F7B#170655, JN_NUMDEM_437918#170355 AS COL_398AF484_33AF_4DB8_AF1D_65D04EC18E4C#170656, JN_NUMEXA_437919#170359 AS COL_67622320_1823_46D9_81E3_BC9357168E85#170657, JN_NUMDRV_437920#170357 AS COL_2B62B381_F2BC_492B_9B5D_9923B084956E#170658, JN_NUMCR_437921#170354 AS COL_5DE21EEA_FF38_4685_B8C3_B07CDD6492E0#170659, JN_NUMFUS_437922#170360 AS COL_24999C15_F7CD_4E12_8225_578C3F6E8A79#170660, JN_COMMENT_437923#170347 AS COL_300A88FE_FA44_4EAF_870E_252C6EA3C56D#170661, JN_CODSIT_437924#170346 AS COL_54727353_DB4E_4E11_AC56_BA96D026D5F8#170662, JN_XMLDATA_437925#170371 AS COL_2ABEE95A_70A0_42AE_A903_BB621197B0ED#170663, JN_PRG_CODE_437926#170367 AS COL_DD7F4E40_CBBC_4034_AB0E_5C05A8F726D8#170664, JN_TERMINAL_437927#170369 AS COL_0E1872A0_8B6E_4733_9EA1_E6B1254FF973#170665, JN_OSUSER_437928#170366 AS COL_78BB7AEA_2CF8_47A9_9E81_A3D415D920DE#170666, JN_IP_ADDRESS_437929#170353 AS COL_1CA36529_9D2B_4D15_A5C3_FFF06EB3E327#170667, JN_FLENV_437930#170351 AS COL_E3244541_9487_4DE4_87FC_E411037CF183#170668, JN_DATENV_437931#170348 AS COL_4385B164_2EAE_488F_9EBD_14ABFA26AD1A#170669, JN_NUMENT_437932#170358 AS COL_1AD8A979_EC6B_435B_B3B4_D93CDB5A721B#170670, JN_NUMSTU_437933#170365 AS COL_9C166E1A_DC39_4F9C_822E_968A70553F34#170671, JN_NUMSER_437934#170364 AS COL_C2724738_1935_4DAD_83DD_D943604F9C79#170672, JN_NUMIMA_437935#170361 AS COL_732C767D_E910_4E11_8130_32586A34220B#170673, JN_NUMRB_437936#170363 AS COL_3023EB8D_EF48_466D_87A3_DEB3A8933B8E#170674, JN_DURSEC_437937#170350 AS COL_CC2ADB8B_3799_443F_8AB2_1730D0F33DC4#170675]
Input [28]: [JN_ACTION_437911#170344, JN_CODPER_437916#170345, JN_CODSIT_437924#170346, JN_COMMENT_437923#170347, JN_DATENV_437931#170348, JN_DATJOU_437914#170349, JN_DURSEC_437937#170350, JN_FLENV_437930#170351, JN_HEUJOU_437915#170352, JN_IP_ADDRESS_437929#170353, JN_NUMCR_437921#170354, JN_NUMDEM_437918#170355, JN_NUMDOS_437917#170356, JN_NUMDRV_437920#170357, JN_NUMENT_437932#170358, JN_NUMEXA_437919#170359, JN_NUMFUS_437922#170360, JN_NUMIMA_437935#170361, JN_NUMJOU_437910#170362, JN_NUMRB_437936#170363, JN_NUMSER_437934#170364, JN_NUMSTU_437933#170365, JN_OSUSER_437928#170366, JN_PRG_CODE_437926#170367, JN_TABLE_437913#170368, JN_TERMINAL_437927#170369, JN_TYPJOU_437912#170370, JN_XMLDATA_437925#170371]

(5) CollectLimit
Input [28]: [COL_83767C93_A141_4C9C_8EF7_B5B481B30EE7#170648, COL_22CEA9F0_3F69_4039_8A13_75B28EB137F6#170649, COL_2AC59C5B_776E_4288_A554_59A801AD7321#170650, COL_0D0B9F1D_022F_4347_B678_3191F3B9C8C9#170651, COL_E362A659_3F6F_4C21_8FCE_8E321609DB9B#170652, COL_E8C411DC_53A0_45F2_9E02_790459390C6A#170653, COL_E28DCDE8_078A_409B_A530_74FC278F03C1#170654, COL_D5607502_E8CA_4045_8D8A_B786B7AE3F7B#170655, COL_398AF484_33AF_4DB8_AF1D_65D04EC18E4C#170656, COL_67622320_1823_46D9_81E3_BC9357168E85#170657, COL_2B62B381_F2BC_492B_9B5D_9923B084956E#170658, COL_5DE21EEA_FF38_4685_B8C3_B07CDD6492E0#170659, COL_24999C15_F7CD_4E12_8225_578C3F6E8A79#170660, COL_300A88FE_FA44_4EAF_870E_252C6EA3C56D#170661, COL_54727353_DB4E_4E11_AC56_BA96D026D5F8#170662, COL_2ABEE95A_70A0_42AE_A903_BB621197B0ED#170663, COL_DD7F4E40_CBBC_4034_AB0E_5C05A8F726D8#170664, COL_0E1872A0_8B6E_4733_9EA1_E6B1254FF973#170665, COL_78BB7AEA_2CF8_47A9_9E81_A3D415D920DE#170666, COL_1CA36529_9D2B_4D15_A5C3_FFF06EB3E327#170667, COL_E3244541_9487_4DE4_87FC_E411037CF183#170668, COL_4385B164_2EAE_488F_9EBD_14ABFA26AD1A#170669, COL_1AD8A979_EC6B_435B_B3B4_D93CDB5A721B#170670, COL_9C166E1A_DC39_4F9C_822E_968A70553F34#170671, COL_C2724738_1935_4DAD_83DD_D943604F9C79#170672, COL_732C767D_E910_4E11_8130_32586A34220B#170673, COL_3023EB8D_EF48_466D_87A3_DEB3A8933B8E#170674, COL_CC2ADB8B_3799_443F_8AB2_1730D0F33DC4#170675]
Arguments: 1500

SQL / DataFrame Properties

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