hdh-spark-job - Details for Query 707

Submitted Time: 2026/10/21 21:34:47
Duration: 0.5 s
Succeeded Jobs: 685

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: 322 ms"; 2 [labelType="html" label=" Project "]; 3 [labelType="html" label="Filter number of output rows: 180"]; 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: 6 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#154956 AS COL_96B64494_D7E1_4141_8D15_2EB7E896C273#155106, JN_ACTION_437911#154938 AS COL_7AE81966_B618_443A_AC3C_C499533DCA34#155107, JN_TYPJOU_437912#154964 AS COL_8D5A1E74_3717_468E_BFC4_C915C657FBC3#155108, JN_TABLE_437913#154962 AS COL_4BBC16EE_4E36_4D3B_BF53_3A1A0342F183#155109, JN_DATJOU_437914#154943 AS COL_2D5B8FAC_6D9A_4E6B_B343_A18CF937C5BA#155110, JN_HEUJOU_437915#154946 AS COL_D2250836_0155_4ACA_92AC_3319917A9D53#155111, JN_CODPER_437916#154939 AS COL_FA6E3B50_7A3F_443C_A872_FECA651C2A8D#155112, JN_NUMDOS_437917#154950 AS COL_E567498C_AE5C_4687_A564_3CB7C3FD709D#155113, JN_NUMDEM_437918#154949 AS COL_F2FA46B2_05D6_4F5E_BDF0_1BF905F6ECD4#155114, JN_NUMEXA_437919#154953 AS COL_402ACBCD_9682_44EC_AFFB_A36BA23CDE4D#155115, JN_NUMDRV_437920#154951 AS COL_D6ADC533_D823_4837_84A1_41E0D7240A2D#155116, JN_NUMCR_437921#154948 AS COL_8CB03ECD_9BA7_44CC_952B_6A137A2B2051#155117, JN_NUMFUS_437922#154954 AS COL_C969F1AC_44CF_448A_AA98_5AADB7C451AB#155118, JN_COMMENT_437923#154941 AS COL_B13EB9E1_D304_421E_B0E7_1B814F46A922#155119, JN_CODSIT_437924#154940 AS COL_3E8F3115_0E4F_472D_B89D_41C063EDCC07#155120, JN_XMLDATA_437925#154965 AS COL_F9BDB9F3_B05E_4066_B202_71A17A806000#155121, JN_PRG_CODE_437926#154961 AS COL_DB237870_D6A1_46AB_9955_5F556B8935EA#155122, JN_TERMINAL_437927#154963 AS COL_BB9724D0_1A27_42B6_884A_288C8F5CEB38#155123, JN_OSUSER_437928#154960 AS COL_CF1F1FEE_BDB1_4DED_B58E_5CC85AC57204#155124, JN_IP_ADDRESS_437929#154947 AS COL_3FF279DF_AD03_4011_8A99_1F30A383437E#155125, JN_FLENV_437930#154945 AS COL_607C7BE8_47AB_4294_B515_83817D87BC21#155126, JN_DATENV_437931#154942 AS COL_4706D2FA_262D_4A0F_881F_61A8FDD7A3DC#155127, JN_NUMENT_437932#154952 AS COL_93CD03AA_CE58_45B0_B34C_70AB24E1119D#155128, JN_NUMSTU_437933#154959 AS COL_62D86201_9494_46CB_B745_60B817F564C5#155129, ... 4 more fields]

Filter (((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(JN_NUMJOU_437910#154956)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(JN_NUMJOU_437910#154956)), MARX) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(JN_ACTION_437911#154938)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(JN_ACTION_437911#154938)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(JN_TYPJOU_437912#154964)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(JN_TYPJOU_437912#154964)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(JN_TABLE_437913#154962)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(JN_TABLE_437913#154962)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(JN_DATJOU_437914#154943)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(JN_DATJOU_437914#154943)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(JN_HEUJOU_437915#154946)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(JN_HEUJOU_437915#154946)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(JN_CODPER_437916#154939)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(JN_CODPER_437916#154939)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(JN_NUMDOS_437917#154950)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(JN_NUMDOS_437917#154950)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(JN_NUMDEM_437918#154949)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(JN_NUMDEM_437918#154949)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(JN_NUMEXA_437919#154953)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(JN_NUMEXA_437919#154953)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(JN_NUMDRV_437920#154951)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(JN_NUMDRV_437920#154951)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(JN_NUMCR_437921#154948)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(JN_NUMCR_437921#154948)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(JN_NUMFUS_437922#154954)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(JN_NUMFUS_437922#154954)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(JN_COMMENT_437923#154941)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(JN_COMMENT_437923#154941)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(JN_CODSIT_437924#154940)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(JN_CODSIT_437924#154940)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(JN_XMLDATA_437925#154965)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(JN_XMLDATA_437925#154965)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(JN_PRG_CODE_437926#154961)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(JN_PRG_CODE_437926#154961)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(JN_TERMINAL_437927#154963)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(JN_TERMINAL_437927#154963)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(JN_OSUSER_437928#154960)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(JN_OSUSER_437928#154960)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(JN_IP_ADDRESS_437929#154947)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(JN_IP_ADDRESS_437929#154947)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(JN_FLENV_437930#154945)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(JN_FLENV_437930#154945)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(JN_DATENV_437931#154942)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(JN_DATENV_437931#154942)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(JN_NUMENT_437932#154952)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(JN_NUMENT_437932#154952)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(JN_NUMSTU_437933#154959)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(JN_NUMSTU_437933#154959)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(JN_NUMSER_437934#154958)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(JN_NUMSER_437934#154958)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(JN_NUMIMA_437935#154955)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(JN_NUMIMA_437935#154955)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(JN_NUMRB_437936#154957)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(JN_NUMRB_437936#154957)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(JN_DURSEC_437937#154944)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(JN_DURSEC_437937#154944)), MARX) END)

ColumnarToRow

WholeStageCodegen (1)

FileScan parquet [JN_ACTION_437911#154938,JN_CODPER_437916#154939,JN_CODSIT_437924#154940,JN_COMMENT_437923#154941,JN_DATENV_437931#154942,JN_DATJOU_437914#154943,JN_DURSEC_437937#154944,JN_FLENV_437930#154945,JN_HEUJOU_437915#154946,JN_IP_ADDRESS_437929#154947,JN_NUMCR_437921#154948,JN_NUMDEM_437918#154949,JN_NUMDOS_437917#154950,JN_NUMDRV_437920#154951,JN_NUMENT_437932#154952,JN_NUMEXA_437919#154953,JN_NUMFUS_437922#154954,JN_NUMIMA_437935#154955,JN_NUMJOU_437910#154956,JN_NUMRB_437936#154957,JN_NUMSER_437934#154958,JN_NUMSTU_437933#154959,JN_OSUSER_437928#154960,JN_PRG_CODE_437926#154961,... 4 more fields] Batched: true, DataFilters: [(((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(JN_NUMJOU_437910#15..., 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#154938, JN_CODPER_437916#154939, JN_CODSIT_437924#154940, JN_COMMENT_437923#154941, JN_DATENV_437931#154942, JN_DATJOU_437914#154943, JN_DURSEC_437937#154944, JN_FLENV_437930#154945, JN_HEUJOU_437915#154946, JN_IP_ADDRESS_437929#154947, JN_NUMCR_437921#154948, JN_NUMDEM_437918#154949, JN_NUMDOS_437917#154950, JN_NUMDRV_437920#154951, JN_NUMENT_437932#154952, JN_NUMEXA_437919#154953, JN_NUMFUS_437922#154954, JN_NUMIMA_437935#154955, JN_NUMJOU_437910#154956, JN_NUMRB_437936#154957, JN_NUMSER_437934#154958, JN_NUMSTU_437933#154959, JN_OSUSER_437928#154960, JN_PRG_CODE_437926#154961, JN_TABLE_437913#154962, JN_TERMINAL_437927#154963, JN_TYPJOU_437912#154964, JN_XMLDATA_437925#154965]
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#154938, JN_CODPER_437916#154939, JN_CODSIT_437924#154940, JN_COMMENT_437923#154941, JN_DATENV_437931#154942, JN_DATJOU_437914#154943, JN_DURSEC_437937#154944, JN_FLENV_437930#154945, JN_HEUJOU_437915#154946, JN_IP_ADDRESS_437929#154947, JN_NUMCR_437921#154948, JN_NUMDEM_437918#154949, JN_NUMDOS_437917#154950, JN_NUMDRV_437920#154951, JN_NUMENT_437932#154952, JN_NUMEXA_437919#154953, JN_NUMFUS_437922#154954, JN_NUMIMA_437935#154955, JN_NUMJOU_437910#154956, JN_NUMRB_437936#154957, JN_NUMSER_437934#154958, JN_NUMSTU_437933#154959, JN_OSUSER_437928#154960, JN_PRG_CODE_437926#154961, JN_TABLE_437913#154962, JN_TERMINAL_437927#154963, JN_TYPJOU_437912#154964, JN_XMLDATA_437925#154965]

(3) Filter [codegen id : 1]
Input [28]: [JN_ACTION_437911#154938, JN_CODPER_437916#154939, JN_CODSIT_437924#154940, JN_COMMENT_437923#154941, JN_DATENV_437931#154942, JN_DATJOU_437914#154943, JN_DURSEC_437937#154944, JN_FLENV_437930#154945, JN_HEUJOU_437915#154946, JN_IP_ADDRESS_437929#154947, JN_NUMCR_437921#154948, JN_NUMDEM_437918#154949, JN_NUMDOS_437917#154950, JN_NUMDRV_437920#154951, JN_NUMENT_437932#154952, JN_NUMEXA_437919#154953, JN_NUMFUS_437922#154954, JN_NUMIMA_437935#154955, JN_NUMJOU_437910#154956, JN_NUMRB_437936#154957, JN_NUMSER_437934#154958, JN_NUMSTU_437933#154959, JN_OSUSER_437928#154960, JN_PRG_CODE_437926#154961, JN_TABLE_437913#154962, JN_TERMINAL_437927#154963, JN_TYPJOU_437912#154964, JN_XMLDATA_437925#154965]
Condition : (((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(JN_NUMJOU_437910#154956)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(JN_NUMJOU_437910#154956)), MARX) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(JN_ACTION_437911#154938)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(JN_ACTION_437911#154938)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(JN_TYPJOU_437912#154964)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(JN_TYPJOU_437912#154964)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(JN_TABLE_437913#154962)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(JN_TABLE_437913#154962)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(JN_DATJOU_437914#154943)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(JN_DATJOU_437914#154943)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(JN_HEUJOU_437915#154946)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(JN_HEUJOU_437915#154946)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(JN_CODPER_437916#154939)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(JN_CODPER_437916#154939)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(JN_NUMDOS_437917#154950)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(JN_NUMDOS_437917#154950)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(JN_NUMDEM_437918#154949)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(JN_NUMDEM_437918#154949)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(JN_NUMEXA_437919#154953)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(JN_NUMEXA_437919#154953)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(JN_NUMDRV_437920#154951)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(JN_NUMDRV_437920#154951)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(JN_NUMCR_437921#154948)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(JN_NUMCR_437921#154948)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(JN_NUMFUS_437922#154954)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(JN_NUMFUS_437922#154954)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(JN_COMMENT_437923#154941)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(JN_COMMENT_437923#154941)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(JN_CODSIT_437924#154940)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(JN_CODSIT_437924#154940)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(JN_XMLDATA_437925#154965)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(JN_XMLDATA_437925#154965)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(JN_PRG_CODE_437926#154961)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(JN_PRG_CODE_437926#154961)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(JN_TERMINAL_437927#154963)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(JN_TERMINAL_437927#154963)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(JN_OSUSER_437928#154960)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(JN_OSUSER_437928#154960)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(JN_IP_ADDRESS_437929#154947)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(JN_IP_ADDRESS_437929#154947)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(JN_FLENV_437930#154945)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(JN_FLENV_437930#154945)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(JN_DATENV_437931#154942)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(JN_DATENV_437931#154942)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(JN_NUMENT_437932#154952)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(JN_NUMENT_437932#154952)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(JN_NUMSTU_437933#154959)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(JN_NUMSTU_437933#154959)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(JN_NUMSER_437934#154958)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(JN_NUMSER_437934#154958)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(JN_NUMIMA_437935#154955)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(JN_NUMIMA_437935#154955)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(JN_NUMRB_437936#154957)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(JN_NUMRB_437936#154957)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(JN_DURSEC_437937#154944)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(JN_DURSEC_437937#154944)), MARX) END)

(4) Project [codegen id : 1]
Output [28]: [JN_NUMJOU_437910#154956 AS COL_96B64494_D7E1_4141_8D15_2EB7E896C273#155106, JN_ACTION_437911#154938 AS COL_7AE81966_B618_443A_AC3C_C499533DCA34#155107, JN_TYPJOU_437912#154964 AS COL_8D5A1E74_3717_468E_BFC4_C915C657FBC3#155108, JN_TABLE_437913#154962 AS COL_4BBC16EE_4E36_4D3B_BF53_3A1A0342F183#155109, JN_DATJOU_437914#154943 AS COL_2D5B8FAC_6D9A_4E6B_B343_A18CF937C5BA#155110, JN_HEUJOU_437915#154946 AS COL_D2250836_0155_4ACA_92AC_3319917A9D53#155111, JN_CODPER_437916#154939 AS COL_FA6E3B50_7A3F_443C_A872_FECA651C2A8D#155112, JN_NUMDOS_437917#154950 AS COL_E567498C_AE5C_4687_A564_3CB7C3FD709D#155113, JN_NUMDEM_437918#154949 AS COL_F2FA46B2_05D6_4F5E_BDF0_1BF905F6ECD4#155114, JN_NUMEXA_437919#154953 AS COL_402ACBCD_9682_44EC_AFFB_A36BA23CDE4D#155115, JN_NUMDRV_437920#154951 AS COL_D6ADC533_D823_4837_84A1_41E0D7240A2D#155116, JN_NUMCR_437921#154948 AS COL_8CB03ECD_9BA7_44CC_952B_6A137A2B2051#155117, JN_NUMFUS_437922#154954 AS COL_C969F1AC_44CF_448A_AA98_5AADB7C451AB#155118, JN_COMMENT_437923#154941 AS COL_B13EB9E1_D304_421E_B0E7_1B814F46A922#155119, JN_CODSIT_437924#154940 AS COL_3E8F3115_0E4F_472D_B89D_41C063EDCC07#155120, JN_XMLDATA_437925#154965 AS COL_F9BDB9F3_B05E_4066_B202_71A17A806000#155121, JN_PRG_CODE_437926#154961 AS COL_DB237870_D6A1_46AB_9955_5F556B8935EA#155122, JN_TERMINAL_437927#154963 AS COL_BB9724D0_1A27_42B6_884A_288C8F5CEB38#155123, JN_OSUSER_437928#154960 AS COL_CF1F1FEE_BDB1_4DED_B58E_5CC85AC57204#155124, JN_IP_ADDRESS_437929#154947 AS COL_3FF279DF_AD03_4011_8A99_1F30A383437E#155125, JN_FLENV_437930#154945 AS COL_607C7BE8_47AB_4294_B515_83817D87BC21#155126, JN_DATENV_437931#154942 AS COL_4706D2FA_262D_4A0F_881F_61A8FDD7A3DC#155127, JN_NUMENT_437932#154952 AS COL_93CD03AA_CE58_45B0_B34C_70AB24E1119D#155128, JN_NUMSTU_437933#154959 AS COL_62D86201_9494_46CB_B745_60B817F564C5#155129, JN_NUMSER_437934#154958 AS COL_27A8EC3D_735F_4099_9FB0_9992FB550CF3#155130, JN_NUMIMA_437935#154955 AS COL_F6BB3801_AFAC_4DE2_A9CA_0A775D65F072#155131, JN_NUMRB_437936#154957 AS COL_13799BA1_D691_4A16_A0C0_F0BA40EA6C8A#155132, JN_DURSEC_437937#154944 AS COL_B3A3733F_32DB_40B8_B7D0_2D2A4112C090#155133]
Input [28]: [JN_ACTION_437911#154938, JN_CODPER_437916#154939, JN_CODSIT_437924#154940, JN_COMMENT_437923#154941, JN_DATENV_437931#154942, JN_DATJOU_437914#154943, JN_DURSEC_437937#154944, JN_FLENV_437930#154945, JN_HEUJOU_437915#154946, JN_IP_ADDRESS_437929#154947, JN_NUMCR_437921#154948, JN_NUMDEM_437918#154949, JN_NUMDOS_437917#154950, JN_NUMDRV_437920#154951, JN_NUMENT_437932#154952, JN_NUMEXA_437919#154953, JN_NUMFUS_437922#154954, JN_NUMIMA_437935#154955, JN_NUMJOU_437910#154956, JN_NUMRB_437936#154957, JN_NUMSER_437934#154958, JN_NUMSTU_437933#154959, JN_OSUSER_437928#154960, JN_PRG_CODE_437926#154961, JN_TABLE_437913#154962, JN_TERMINAL_437927#154963, JN_TYPJOU_437912#154964, JN_XMLDATA_437925#154965]

(5) CollectLimit
Input [28]: [COL_96B64494_D7E1_4141_8D15_2EB7E896C273#155106, COL_7AE81966_B618_443A_AC3C_C499533DCA34#155107, COL_8D5A1E74_3717_468E_BFC4_C915C657FBC3#155108, COL_4BBC16EE_4E36_4D3B_BF53_3A1A0342F183#155109, COL_2D5B8FAC_6D9A_4E6B_B343_A18CF937C5BA#155110, COL_D2250836_0155_4ACA_92AC_3319917A9D53#155111, COL_FA6E3B50_7A3F_443C_A872_FECA651C2A8D#155112, COL_E567498C_AE5C_4687_A564_3CB7C3FD709D#155113, COL_F2FA46B2_05D6_4F5E_BDF0_1BF905F6ECD4#155114, COL_402ACBCD_9682_44EC_AFFB_A36BA23CDE4D#155115, COL_D6ADC533_D823_4837_84A1_41E0D7240A2D#155116, COL_8CB03ECD_9BA7_44CC_952B_6A137A2B2051#155117, COL_C969F1AC_44CF_448A_AA98_5AADB7C451AB#155118, COL_B13EB9E1_D304_421E_B0E7_1B814F46A922#155119, COL_3E8F3115_0E4F_472D_B89D_41C063EDCC07#155120, COL_F9BDB9F3_B05E_4066_B202_71A17A806000#155121, COL_DB237870_D6A1_46AB_9955_5F556B8935EA#155122, COL_BB9724D0_1A27_42B6_884A_288C8F5CEB38#155123, COL_CF1F1FEE_BDB1_4DED_B58E_5CC85AC57204#155124, COL_3FF279DF_AD03_4011_8A99_1F30A383437E#155125, COL_607C7BE8_47AB_4294_B515_83817D87BC21#155126, COL_4706D2FA_262D_4A0F_881F_61A8FDD7A3DC#155127, COL_93CD03AA_CE58_45B0_B34C_70AB24E1119D#155128, COL_62D86201_9494_46CB_B745_60B817F564C5#155129, COL_27A8EC3D_735F_4099_9FB0_9992FB550CF3#155130, COL_F6BB3801_AFAC_4DE2_A9CA_0A775D65F072#155131, COL_13799BA1_D691_4A16_A0C0_F0BA40EA6C8A#155132, COL_B3A3733F_32DB_40B8_B7D0_2D2A4112C090#155133]
Arguments: 1500

SQL / DataFrame Properties

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