hdh-spark-job - Details for Query 1382

Submitted Time: 2026/10/23 13:28:27
Duration: 8 s
Succeeded Jobs: 1380 1384

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

digraph G { 0 [labelType="html" label=" CollectLimit "]; 1 [labelType="html" label=" Union "]; subgraph cluster2 { isCluster="true"; label="WholeStageCodegen (1)\n \nduration: 419 ms"; 3 [labelType="html" label=" LocalLimit "]; 4 [labelType="html" label=" Project "]; 5 [labelType="html" label="Filter number of output rows: 23"]; 6 [labelType="html" label="Scan JDBCRelation((SELECT \"jn_numjou\", \"jn_action\", \"jn_typjou\", \"jn_table\", \"jn_datjou\", \"jn_heujou\", \"jn_codper\", \"jn_numdos\", \"jn_numdem\", \"jn_numexa\", \"jn_numdrv\", \"jn_numcr\", \"jn_numfus\", \"jn_comment\", \"jn_codsit\", \"jn_xmldata\", \"jn_prg_code\", \"jn_terminal\", \"jn_osuser\", \"jn_ip_address\", \"jn_flenv\", \"jn_datenv\", \"jn_nument\", \"jn_numstu\", \"jn_numser\", \"jn_numima\", \"jn_numrb\", \"jn_dursec\" FROM \"xplore\".\"h_journal\") as x) [numPartitions=1] number of output rows: 8,765"]; } subgraph cluster7 { isCluster="true"; label="WholeStageCodegen (2)\n \nduration: 415 ms"; 8 [labelType="html" label=" LocalLimit "]; 9 [labelType="html" label=" Project "]; 10 [labelType="html" label="Filter number of output rows: 23"]; 11 [labelType="html" label="Scan JDBCRelation((SELECT \"jn_numjou\", \"jn_action\", \"jn_typjou\", \"jn_table\", \"jn_datjou\", \"jn_heujou\", \"jn_codper\", \"jn_numdos\", \"jn_numdem\", \"jn_numexa\", \"jn_numdrv\", \"jn_numcr\", \"jn_numfus\", \"jn_comment\", \"jn_codsit\", \"jn_xmldata\", \"jn_prg_code\", \"jn_terminal\", \"jn_osuser\", \"jn_ip_address\", \"jn_flenv\", \"jn_datenv\", \"jn_nument\", \"jn_numstu\", \"jn_numser\", \"jn_numima\", \"jn_numrb\", \"jn_dursec\" FROM \"xplore2\".\"h_journal\") as x) [numPartitions=1] number of output rows: 8,765"]; } 1->0; 3->1; 4->3; 5->4; 6->5; 8->1; 9->8; 10->9; 11->10; }

CollectLimit 1500

Union

LocalLimit 1500

Project [jn_numjou#697611 AS COL_5F1B26BF_0116_4441_8AA0_8E54C69995EC#698295, jn_action#697612 AS COL_50751B07_2C1F_4B42_A389_ACBEC61E76FD#698296, jn_typjou#697613 AS COL_CB1BBC32_6C50_43FA_8EDD_03248998C6B3#698297, jn_table#697614 AS COL_48D5E11C_1B3B_45C3_9C69_D69856EEC1C2#698298, jn_datjou#697615 AS COL_CDDE886E_1248_4E9B_8916_DEB3C9E30D6A#698299, jn_heujou#697616 AS COL_21AB7359_69A6_4463_94AF_E19F04314932#698300, jn_codper#697617 AS COL_25882646_BBE3_4A1C_BC06_2304760A20B9#698301, jn_numdos#697618 AS COL_89DC4B05_2395_4039_9B13_C68E2FEC749B#698302, jn_numdem#697619 AS COL_77E7013C_D4FF_4ADC_A900_33D220B23B5F#698303, jn_numexa#697620 AS COL_8484D7FC_2F45_4222_9765_FD25A8527A00#698304, jn_numdrv#697621 AS COL_C9F1BAA4_9456_42AD_87EE_2A9D7D44D696#698305, jn_numcr#697622 AS COL_F15B56EC_65F8_4D77_8B0E_B6E96185327B#698306, jn_numfus#697623 AS COL_C3BA9D9A_A4BA_4D0C_904F_0B035CA82E8F#698307, jn_comment#697624 AS COL_5813CD9A_CC3C_4F4F_986C_04238061281B#698308, jn_codsit#697625 AS COL_11511345_520B_4A31_9F42_089615E35E25#698309, jn_xmldata#697626 AS COL_50544B72_748F_4955_A9EE_444FC5853FC4#698310, jn_prg_code#697627 AS COL_2FB27DDB_28A4_4076_8B12_67B3963281F9#698311, jn_terminal#697628 AS COL_941A9562_422A_407F_B5C0_FD1F0CE918B8#698312, jn_osuser#697629 AS COL_193F0589_F384_409E_B999_D28796E9E406#698313, jn_ip_address#697630 AS COL_B04E86E8_35DE_4185_AB1F_B0576DD6F763#698314, jn_flenv#697631 AS COL_DAB5CC94_E5F5_4CAD_AB6C_24D524F0AB10#698315, jn_datenv#697632 AS COL_C128B0B9_616F_4346_833E_3E45E77AC49E#698316, jn_nument#697633 AS COL_E8C57DD2_274E_4354_A11F_9F7898673794#698317, jn_numstu#697634 AS COL_2860AE8E_7B3D_438D_BC29_91FC3A3B7CBE#698318, ... 5 more fields]

Filter ((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(jn_numjou#697611)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(jn_numjou#697611)), MAIN) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_action#697612)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(jn_action#697612)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_typjou#697613)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(jn_typjou#697613)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_table#697614)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(jn_table#697614)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_datjou#697615)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(jn_datjou#697615)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_heujou#697616)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(jn_heujou#697616)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_codper#697617)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(jn_codper#697617)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_numdos#697618)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(jn_numdos#697618)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_numdem#697619)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(jn_numdem#697619)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_numexa#697620)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(jn_numexa#697620)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_numdrv#697621)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(jn_numdrv#697621)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_numcr#697622)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(jn_numcr#697622)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_numfus#697623)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(jn_numfus#697623)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_comment#697624)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(jn_comment#697624)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_codsit#697625)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(jn_codsit#697625)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_xmldata#697626)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(jn_xmldata#697626)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_prg_code#697627)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(jn_prg_code#697627)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_terminal#697628)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(jn_terminal#697628)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_osuser#697629)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(jn_osuser#697629)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_ip_address#697630)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(jn_ip_address#697630)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_flenv#697631)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(jn_flenv#697631)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_datenv#697632)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(jn_datenv#697632)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_nument#697633)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(jn_nument#697633)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_numstu#697634)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(jn_numstu#697634)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_numser#697635)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(jn_numser#697635)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_numima#697636)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(jn_numima#697636)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_numrb#697637)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(jn_numrb#697637)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_dursec#697638)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(jn_dursec#697638)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_create(Cab_A))), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(str_create(Cab_A))), MAIN) END)

Scan JDBCRelation((SELECT "jn_numjou", "jn_action", "jn_typjou", "jn_table", "jn_datjou", "jn_heujou", "jn_codper", "jn_numdos", "jn_numdem", "jn_numexa", "jn_numdrv", "jn_numcr", "jn_numfus", "jn_comment", "jn_codsit", "jn_xmldata", "jn_prg_code", "jn_terminal", "jn_osuser", "jn_ip_address", "jn_flenv", "jn_datenv", "jn_nument", "jn_numstu", "jn_numser", "jn_numima", "jn_numrb", "jn_dursec" FROM "xplore"."h_journal") as x) [numPartitions=1] [jn_numjou#697611,jn_action#697612,jn_typjou#697613,jn_table#697614,jn_datjou#697615,jn_heujou#697616,jn_codper#697617,jn_numdos#697618,jn_numdem#697619,jn_numexa#697620,jn_numdrv#697621,jn_numcr#697622,jn_numfus#697623,jn_comment#697624,jn_codsit#697625,jn_xmldata#697626,jn_prg_code#697627,jn_terminal#697628,jn_osuser#697629,jn_ip_address#697630,jn_flenv#697631,jn_datenv#697632,jn_nument#697633,jn_numstu#697634,... 4 more fields] PushedFilters: [], ReadSchema: struct<jn_numjou:string,jn_action:string,jn_typjou:string,jn_table:string,jn_datjou:string,jn_heu...

WholeStageCodegen (1)

LocalLimit 1500

Project [jn_numjou#697866 AS COL_5F1B26BF_0116_4441_8AA0_8E54C69995EC#698382, jn_action#697867 AS COL_50751B07_2C1F_4B42_A389_ACBEC61E76FD#698383, jn_typjou#697868 AS COL_CB1BBC32_6C50_43FA_8EDD_03248998C6B3#698384, jn_table#697869 AS COL_48D5E11C_1B3B_45C3_9C69_D69856EEC1C2#698385, jn_datjou#697870 AS COL_CDDE886E_1248_4E9B_8916_DEB3C9E30D6A#698386, jn_heujou#697871 AS COL_21AB7359_69A6_4463_94AF_E19F04314932#698387, jn_codper#697872 AS COL_25882646_BBE3_4A1C_BC06_2304760A20B9#698388, jn_numdos#697873 AS COL_89DC4B05_2395_4039_9B13_C68E2FEC749B#698389, jn_numdem#697874 AS COL_77E7013C_D4FF_4ADC_A900_33D220B23B5F#698390, jn_numexa#697875 AS COL_8484D7FC_2F45_4222_9765_FD25A8527A00#698391, jn_numdrv#697876 AS COL_C9F1BAA4_9456_42AD_87EE_2A9D7D44D696#698392, jn_numcr#697877 AS COL_F15B56EC_65F8_4D77_8B0E_B6E96185327B#698393, jn_numfus#697878 AS COL_C3BA9D9A_A4BA_4D0C_904F_0B035CA82E8F#698394, jn_comment#697879 AS COL_5813CD9A_CC3C_4F4F_986C_04238061281B#698395, jn_codsit#697880 AS COL_11511345_520B_4A31_9F42_089615E35E25#698396, jn_xmldata#697881 AS COL_50544B72_748F_4955_A9EE_444FC5853FC4#698397, jn_prg_code#697882 AS COL_2FB27DDB_28A4_4076_8B12_67B3963281F9#698398, jn_terminal#697883 AS COL_941A9562_422A_407F_B5C0_FD1F0CE918B8#698399, jn_osuser#697884 AS COL_193F0589_F384_409E_B999_D28796E9E406#698400, jn_ip_address#697885 AS COL_B04E86E8_35DE_4185_AB1F_B0576DD6F763#698401, jn_flenv#697886 AS COL_DAB5CC94_E5F5_4CAD_AB6C_24D524F0AB10#698402, jn_datenv#697887 AS COL_C128B0B9_616F_4346_833E_3E45E77AC49E#698403, jn_nument#697888 AS COL_E8C57DD2_274E_4354_A11F_9F7898673794#698404, jn_numstu#697889 AS COL_2860AE8E_7B3D_438D_BC29_91FC3A3B7CBE#698405, ... 5 more fields]

Filter ((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(jn_numjou#697866)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(jn_numjou#697866)), MAIN) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_action#697867)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(jn_action#697867)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_typjou#697868)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(jn_typjou#697868)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_table#697869)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(jn_table#697869)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_datjou#697870)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(jn_datjou#697870)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_heujou#697871)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(jn_heujou#697871)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_codper#697872)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(jn_codper#697872)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_numdos#697873)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(jn_numdos#697873)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_numdem#697874)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(jn_numdem#697874)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_numexa#697875)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(jn_numexa#697875)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_numdrv#697876)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(jn_numdrv#697876)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_numcr#697877)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(jn_numcr#697877)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_numfus#697878)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(jn_numfus#697878)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_comment#697879)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(jn_comment#697879)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_codsit#697880)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(jn_codsit#697880)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_xmldata#697881)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(jn_xmldata#697881)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_prg_code#697882)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(jn_prg_code#697882)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_terminal#697883)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(jn_terminal#697883)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_osuser#697884)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(jn_osuser#697884)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_ip_address#697885)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(jn_ip_address#697885)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_flenv#697886)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(jn_flenv#697886)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_datenv#697887)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(jn_datenv#697887)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_nument#697888)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(jn_nument#697888)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_numstu#697889)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(jn_numstu#697889)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_numser#697890)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(jn_numser#697890)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_numima#697891)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(jn_numima#697891)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_numrb#697892)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(jn_numrb#697892)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_dursec#697893)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(jn_dursec#697893)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_create(Cab_B))), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(str_create(Cab_B))), MAIN) END)

Scan JDBCRelation((SELECT "jn_numjou", "jn_action", "jn_typjou", "jn_table", "jn_datjou", "jn_heujou", "jn_codper", "jn_numdos", "jn_numdem", "jn_numexa", "jn_numdrv", "jn_numcr", "jn_numfus", "jn_comment", "jn_codsit", "jn_xmldata", "jn_prg_code", "jn_terminal", "jn_osuser", "jn_ip_address", "jn_flenv", "jn_datenv", "jn_nument", "jn_numstu", "jn_numser", "jn_numima", "jn_numrb", "jn_dursec" FROM "xplore2"."h_journal") as x) [numPartitions=1] [jn_numjou#697866,jn_action#697867,jn_typjou#697868,jn_table#697869,jn_datjou#697870,jn_heujou#697871,jn_codper#697872,jn_numdos#697873,jn_numdem#697874,jn_numexa#697875,jn_numdrv#697876,jn_numcr#697877,jn_numfus#697878,jn_comment#697879,jn_codsit#697880,jn_xmldata#697881,jn_prg_code#697882,jn_terminal#697883,jn_osuser#697884,jn_ip_address#697885,jn_flenv#697886,jn_datenv#697887,jn_nument#697888,jn_numstu#697889,... 4 more fields] PushedFilters: [], ReadSchema: struct<jn_numjou:string,jn_action:string,jn_typjou:string,jn_table:string,jn_datjou:string,jn_heu...

WholeStageCodegen (2)

Details

== Physical Plan ==
CollectLimit (10)
+- Union (9)
   :- * LocalLimit (4)
   :  +- * Project (3)
   :     +- * Filter (2)
   :        +- * Scan JDBCRelation((SELECT "jn_numjou", "jn_action", "jn_typjou", "jn_table", "jn_datjou", "jn_heujou", "jn_codper", "jn_numdos", "jn_numdem", "jn_numexa", "jn_numdrv", "jn_numcr", "jn_numfus", "jn_comment", "jn_codsit", "jn_xmldata", "jn_prg_code", "jn_terminal", "jn_osuser", "jn_ip_address", "jn_flenv", "jn_datenv", "jn_nument", "jn_numstu", "jn_numser", "jn_numima", "jn_numrb", "jn_dursec" FROM "xplore"."h_journal") as x) [numPartitions=1]  (1)
   +- * LocalLimit (8)
      +- * Project (7)
         +- * Filter (6)
            +- * Scan JDBCRelation((SELECT "jn_numjou", "jn_action", "jn_typjou", "jn_table", "jn_datjou", "jn_heujou", "jn_codper", "jn_numdos", "jn_numdem", "jn_numexa", "jn_numdrv", "jn_numcr", "jn_numfus", "jn_comment", "jn_codsit", "jn_xmldata", "jn_prg_code", "jn_terminal", "jn_osuser", "jn_ip_address", "jn_flenv", "jn_datenv", "jn_nument", "jn_numstu", "jn_numser", "jn_numima", "jn_numrb", "jn_dursec" FROM "xplore2"."h_journal") as x) [numPartitions=1]  (5)


(1) Scan JDBCRelation((SELECT "jn_numjou", "jn_action", "jn_typjou", "jn_table", "jn_datjou", "jn_heujou", "jn_codper", "jn_numdos", "jn_numdem", "jn_numexa", "jn_numdrv", "jn_numcr", "jn_numfus", "jn_comment", "jn_codsit", "jn_xmldata", "jn_prg_code", "jn_terminal", "jn_osuser", "jn_ip_address", "jn_flenv", "jn_datenv", "jn_nument", "jn_numstu", "jn_numser", "jn_numima", "jn_numrb", "jn_dursec" FROM "xplore"."h_journal") as x) [numPartitions=1]  [codegen id : 1]
Output [28]: [jn_numjou#697611, jn_action#697612, jn_typjou#697613, jn_table#697614, jn_datjou#697615, jn_heujou#697616, jn_codper#697617, jn_numdos#697618, jn_numdem#697619, jn_numexa#697620, jn_numdrv#697621, jn_numcr#697622, jn_numfus#697623, jn_comment#697624, jn_codsit#697625, jn_xmldata#697626, jn_prg_code#697627, jn_terminal#697628, jn_osuser#697629, jn_ip_address#697630, jn_flenv#697631, jn_datenv#697632, jn_nument#697633, jn_numstu#697634, jn_numser#697635, jn_numima#697636, jn_numrb#697637, jn_dursec#697638]
ReadSchema: struct<jn_numjou:string,jn_action:string,jn_typjou:string,jn_table:string,jn_datjou:string,jn_heujou:string,jn_codper:string,jn_numdos:string,jn_numdem:string,jn_numexa:string,jn_numdrv:string,jn_numcr:string,jn_numfus:string,jn_comment:string,jn_codsit:string,jn_xmldata:string,jn_prg_code:string,jn_terminal:string,jn_osuser:string,jn_ip_address:string,jn_flenv:string,jn_datenv:string,jn_nument:string,jn_numstu:string,jn_numser:string,jn_numima:string,jn_numrb:string,jn_dursec:string>

(2) Filter [codegen id : 1]
Input [28]: [jn_numjou#697611, jn_action#697612, jn_typjou#697613, jn_table#697614, jn_datjou#697615, jn_heujou#697616, jn_codper#697617, jn_numdos#697618, jn_numdem#697619, jn_numexa#697620, jn_numdrv#697621, jn_numcr#697622, jn_numfus#697623, jn_comment#697624, jn_codsit#697625, jn_xmldata#697626, jn_prg_code#697627, jn_terminal#697628, jn_osuser#697629, jn_ip_address#697630, jn_flenv#697631, jn_datenv#697632, jn_nument#697633, jn_numstu#697634, jn_numser#697635, jn_numima#697636, jn_numrb#697637, jn_dursec#697638]
Condition : ((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(jn_numjou#697611)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(jn_numjou#697611)), MAIN) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_action#697612)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(jn_action#697612)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_typjou#697613)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(jn_typjou#697613)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_table#697614)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(jn_table#697614)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_datjou#697615)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(jn_datjou#697615)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_heujou#697616)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(jn_heujou#697616)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_codper#697617)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(jn_codper#697617)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_numdos#697618)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(jn_numdos#697618)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_numdem#697619)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(jn_numdem#697619)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_numexa#697620)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(jn_numexa#697620)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_numdrv#697621)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(jn_numdrv#697621)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_numcr#697622)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(jn_numcr#697622)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_numfus#697623)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(jn_numfus#697623)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_comment#697624)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(jn_comment#697624)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_codsit#697625)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(jn_codsit#697625)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_xmldata#697626)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(jn_xmldata#697626)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_prg_code#697627)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(jn_prg_code#697627)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_terminal#697628)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(jn_terminal#697628)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_osuser#697629)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(jn_osuser#697629)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_ip_address#697630)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(jn_ip_address#697630)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_flenv#697631)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(jn_flenv#697631)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_datenv#697632)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(jn_datenv#697632)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_nument#697633)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(jn_nument#697633)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_numstu#697634)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(jn_numstu#697634)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_numser#697635)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(jn_numser#697635)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_numima#697636)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(jn_numima#697636)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_numrb#697637)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(jn_numrb#697637)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_dursec#697638)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(jn_dursec#697638)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_create(Cab_A))), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(str_create(Cab_A))), MAIN) END)

(3) Project [codegen id : 1]
Output [29]: [jn_numjou#697611 AS COL_5F1B26BF_0116_4441_8AA0_8E54C69995EC#698295, jn_action#697612 AS COL_50751B07_2C1F_4B42_A389_ACBEC61E76FD#698296, jn_typjou#697613 AS COL_CB1BBC32_6C50_43FA_8EDD_03248998C6B3#698297, jn_table#697614 AS COL_48D5E11C_1B3B_45C3_9C69_D69856EEC1C2#698298, jn_datjou#697615 AS COL_CDDE886E_1248_4E9B_8916_DEB3C9E30D6A#698299, jn_heujou#697616 AS COL_21AB7359_69A6_4463_94AF_E19F04314932#698300, jn_codper#697617 AS COL_25882646_BBE3_4A1C_BC06_2304760A20B9#698301, jn_numdos#697618 AS COL_89DC4B05_2395_4039_9B13_C68E2FEC749B#698302, jn_numdem#697619 AS COL_77E7013C_D4FF_4ADC_A900_33D220B23B5F#698303, jn_numexa#697620 AS COL_8484D7FC_2F45_4222_9765_FD25A8527A00#698304, jn_numdrv#697621 AS COL_C9F1BAA4_9456_42AD_87EE_2A9D7D44D696#698305, jn_numcr#697622 AS COL_F15B56EC_65F8_4D77_8B0E_B6E96185327B#698306, jn_numfus#697623 AS COL_C3BA9D9A_A4BA_4D0C_904F_0B035CA82E8F#698307, jn_comment#697624 AS COL_5813CD9A_CC3C_4F4F_986C_04238061281B#698308, jn_codsit#697625 AS COL_11511345_520B_4A31_9F42_089615E35E25#698309, jn_xmldata#697626 AS COL_50544B72_748F_4955_A9EE_444FC5853FC4#698310, jn_prg_code#697627 AS COL_2FB27DDB_28A4_4076_8B12_67B3963281F9#698311, jn_terminal#697628 AS COL_941A9562_422A_407F_B5C0_FD1F0CE918B8#698312, jn_osuser#697629 AS COL_193F0589_F384_409E_B999_D28796E9E406#698313, jn_ip_address#697630 AS COL_B04E86E8_35DE_4185_AB1F_B0576DD6F763#698314, jn_flenv#697631 AS COL_DAB5CC94_E5F5_4CAD_AB6C_24D524F0AB10#698315, jn_datenv#697632 AS COL_C128B0B9_616F_4346_833E_3E45E77AC49E#698316, jn_nument#697633 AS COL_E8C57DD2_274E_4354_A11F_9F7898673794#698317, jn_numstu#697634 AS COL_2860AE8E_7B3D_438D_BC29_91FC3A3B7CBE#698318, jn_numser#697635 AS COL_4DEF7C43_450C_44D6_9718_80CB5325D943#698319, jn_numima#697636 AS COL_52AE74A8_EF89_4907_A435_05F1D56F2443#698320, jn_numrb#697637 AS COL_1BFECB04_A04D_4D00_987A_1FE0E1BA420C#698321, jn_dursec#697638 AS COL_A7218EA2_AF42_4ECD_8DC7_89B19D17AA23#698322, str_create(Cab_A) AS COL_5FD472A9_C6F6_4EBD_913A_4A4EC70AB249#698323]
Input [28]: [jn_numjou#697611, jn_action#697612, jn_typjou#697613, jn_table#697614, jn_datjou#697615, jn_heujou#697616, jn_codper#697617, jn_numdos#697618, jn_numdem#697619, jn_numexa#697620, jn_numdrv#697621, jn_numcr#697622, jn_numfus#697623, jn_comment#697624, jn_codsit#697625, jn_xmldata#697626, jn_prg_code#697627, jn_terminal#697628, jn_osuser#697629, jn_ip_address#697630, jn_flenv#697631, jn_datenv#697632, jn_nument#697633, jn_numstu#697634, jn_numser#697635, jn_numima#697636, jn_numrb#697637, jn_dursec#697638]

(4) LocalLimit [codegen id : 1]
Input [29]: [COL_5F1B26BF_0116_4441_8AA0_8E54C69995EC#698295, COL_50751B07_2C1F_4B42_A389_ACBEC61E76FD#698296, COL_CB1BBC32_6C50_43FA_8EDD_03248998C6B3#698297, COL_48D5E11C_1B3B_45C3_9C69_D69856EEC1C2#698298, COL_CDDE886E_1248_4E9B_8916_DEB3C9E30D6A#698299, COL_21AB7359_69A6_4463_94AF_E19F04314932#698300, COL_25882646_BBE3_4A1C_BC06_2304760A20B9#698301, COL_89DC4B05_2395_4039_9B13_C68E2FEC749B#698302, COL_77E7013C_D4FF_4ADC_A900_33D220B23B5F#698303, COL_8484D7FC_2F45_4222_9765_FD25A8527A00#698304, COL_C9F1BAA4_9456_42AD_87EE_2A9D7D44D696#698305, COL_F15B56EC_65F8_4D77_8B0E_B6E96185327B#698306, COL_C3BA9D9A_A4BA_4D0C_904F_0B035CA82E8F#698307, COL_5813CD9A_CC3C_4F4F_986C_04238061281B#698308, COL_11511345_520B_4A31_9F42_089615E35E25#698309, COL_50544B72_748F_4955_A9EE_444FC5853FC4#698310, COL_2FB27DDB_28A4_4076_8B12_67B3963281F9#698311, COL_941A9562_422A_407F_B5C0_FD1F0CE918B8#698312, COL_193F0589_F384_409E_B999_D28796E9E406#698313, COL_B04E86E8_35DE_4185_AB1F_B0576DD6F763#698314, COL_DAB5CC94_E5F5_4CAD_AB6C_24D524F0AB10#698315, COL_C128B0B9_616F_4346_833E_3E45E77AC49E#698316, COL_E8C57DD2_274E_4354_A11F_9F7898673794#698317, COL_2860AE8E_7B3D_438D_BC29_91FC3A3B7CBE#698318, COL_4DEF7C43_450C_44D6_9718_80CB5325D943#698319, COL_52AE74A8_EF89_4907_A435_05F1D56F2443#698320, COL_1BFECB04_A04D_4D00_987A_1FE0E1BA420C#698321, COL_A7218EA2_AF42_4ECD_8DC7_89B19D17AA23#698322, COL_5FD472A9_C6F6_4EBD_913A_4A4EC70AB249#698323]
Arguments: 1500

(5) Scan JDBCRelation((SELECT "jn_numjou", "jn_action", "jn_typjou", "jn_table", "jn_datjou", "jn_heujou", "jn_codper", "jn_numdos", "jn_numdem", "jn_numexa", "jn_numdrv", "jn_numcr", "jn_numfus", "jn_comment", "jn_codsit", "jn_xmldata", "jn_prg_code", "jn_terminal", "jn_osuser", "jn_ip_address", "jn_flenv", "jn_datenv", "jn_nument", "jn_numstu", "jn_numser", "jn_numima", "jn_numrb", "jn_dursec" FROM "xplore2"."h_journal") as x) [numPartitions=1]  [codegen id : 2]
Output [28]: [jn_numjou#697866, jn_action#697867, jn_typjou#697868, jn_table#697869, jn_datjou#697870, jn_heujou#697871, jn_codper#697872, jn_numdos#697873, jn_numdem#697874, jn_numexa#697875, jn_numdrv#697876, jn_numcr#697877, jn_numfus#697878, jn_comment#697879, jn_codsit#697880, jn_xmldata#697881, jn_prg_code#697882, jn_terminal#697883, jn_osuser#697884, jn_ip_address#697885, jn_flenv#697886, jn_datenv#697887, jn_nument#697888, jn_numstu#697889, jn_numser#697890, jn_numima#697891, jn_numrb#697892, jn_dursec#697893]
ReadSchema: struct<jn_numjou:string,jn_action:string,jn_typjou:string,jn_table:string,jn_datjou:string,jn_heujou:string,jn_codper:string,jn_numdos:string,jn_numdem:string,jn_numexa:string,jn_numdrv:string,jn_numcr:string,jn_numfus:string,jn_comment:string,jn_codsit:string,jn_xmldata:string,jn_prg_code:string,jn_terminal:string,jn_osuser:string,jn_ip_address:string,jn_flenv:string,jn_datenv:string,jn_nument:string,jn_numstu:string,jn_numser:string,jn_numima:string,jn_numrb:string,jn_dursec:string>

(6) Filter [codegen id : 2]
Input [28]: [jn_numjou#697866, jn_action#697867, jn_typjou#697868, jn_table#697869, jn_datjou#697870, jn_heujou#697871, jn_codper#697872, jn_numdos#697873, jn_numdem#697874, jn_numexa#697875, jn_numdrv#697876, jn_numcr#697877, jn_numfus#697878, jn_comment#697879, jn_codsit#697880, jn_xmldata#697881, jn_prg_code#697882, jn_terminal#697883, jn_osuser#697884, jn_ip_address#697885, jn_flenv#697886, jn_datenv#697887, jn_nument#697888, jn_numstu#697889, jn_numser#697890, jn_numima#697891, jn_numrb#697892, jn_dursec#697893]
Condition : ((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(jn_numjou#697866)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(jn_numjou#697866)), MAIN) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_action#697867)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(jn_action#697867)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_typjou#697868)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(jn_typjou#697868)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_table#697869)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(jn_table#697869)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_datjou#697870)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(jn_datjou#697870)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_heujou#697871)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(jn_heujou#697871)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_codper#697872)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(jn_codper#697872)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_numdos#697873)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(jn_numdos#697873)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_numdem#697874)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(jn_numdem#697874)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_numexa#697875)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(jn_numexa#697875)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_numdrv#697876)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(jn_numdrv#697876)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_numcr#697877)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(jn_numcr#697877)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_numfus#697878)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(jn_numfus#697878)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_comment#697879)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(jn_comment#697879)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_codsit#697880)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(jn_codsit#697880)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_xmldata#697881)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(jn_xmldata#697881)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_prg_code#697882)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(jn_prg_code#697882)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_terminal#697883)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(jn_terminal#697883)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_osuser#697884)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(jn_osuser#697884)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_ip_address#697885)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(jn_ip_address#697885)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_flenv#697886)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(jn_flenv#697886)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_datenv#697887)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(jn_datenv#697887)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_nument#697888)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(jn_nument#697888)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_numstu#697889)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(jn_numstu#697889)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_numser#697890)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(jn_numser#697890)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_numima#697891)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(jn_numima#697891)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_numrb#697892)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(jn_numrb#697892)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_dursec#697893)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(jn_dursec#697893)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_create(Cab_B))), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(str_create(Cab_B))), MAIN) END)

(7) Project [codegen id : 2]
Output [29]: [jn_numjou#697866 AS COL_5F1B26BF_0116_4441_8AA0_8E54C69995EC#698382, jn_action#697867 AS COL_50751B07_2C1F_4B42_A389_ACBEC61E76FD#698383, jn_typjou#697868 AS COL_CB1BBC32_6C50_43FA_8EDD_03248998C6B3#698384, jn_table#697869 AS COL_48D5E11C_1B3B_45C3_9C69_D69856EEC1C2#698385, jn_datjou#697870 AS COL_CDDE886E_1248_4E9B_8916_DEB3C9E30D6A#698386, jn_heujou#697871 AS COL_21AB7359_69A6_4463_94AF_E19F04314932#698387, jn_codper#697872 AS COL_25882646_BBE3_4A1C_BC06_2304760A20B9#698388, jn_numdos#697873 AS COL_89DC4B05_2395_4039_9B13_C68E2FEC749B#698389, jn_numdem#697874 AS COL_77E7013C_D4FF_4ADC_A900_33D220B23B5F#698390, jn_numexa#697875 AS COL_8484D7FC_2F45_4222_9765_FD25A8527A00#698391, jn_numdrv#697876 AS COL_C9F1BAA4_9456_42AD_87EE_2A9D7D44D696#698392, jn_numcr#697877 AS COL_F15B56EC_65F8_4D77_8B0E_B6E96185327B#698393, jn_numfus#697878 AS COL_C3BA9D9A_A4BA_4D0C_904F_0B035CA82E8F#698394, jn_comment#697879 AS COL_5813CD9A_CC3C_4F4F_986C_04238061281B#698395, jn_codsit#697880 AS COL_11511345_520B_4A31_9F42_089615E35E25#698396, jn_xmldata#697881 AS COL_50544B72_748F_4955_A9EE_444FC5853FC4#698397, jn_prg_code#697882 AS COL_2FB27DDB_28A4_4076_8B12_67B3963281F9#698398, jn_terminal#697883 AS COL_941A9562_422A_407F_B5C0_FD1F0CE918B8#698399, jn_osuser#697884 AS COL_193F0589_F384_409E_B999_D28796E9E406#698400, jn_ip_address#697885 AS COL_B04E86E8_35DE_4185_AB1F_B0576DD6F763#698401, jn_flenv#697886 AS COL_DAB5CC94_E5F5_4CAD_AB6C_24D524F0AB10#698402, jn_datenv#697887 AS COL_C128B0B9_616F_4346_833E_3E45E77AC49E#698403, jn_nument#697888 AS COL_E8C57DD2_274E_4354_A11F_9F7898673794#698404, jn_numstu#697889 AS COL_2860AE8E_7B3D_438D_BC29_91FC3A3B7CBE#698405, jn_numser#697890 AS COL_4DEF7C43_450C_44D6_9718_80CB5325D943#698406, jn_numima#697891 AS COL_52AE74A8_EF89_4907_A435_05F1D56F2443#698407, jn_numrb#697892 AS COL_1BFECB04_A04D_4D00_987A_1FE0E1BA420C#698408, jn_dursec#697893 AS COL_A7218EA2_AF42_4ECD_8DC7_89B19D17AA23#698409, str_create(Cab_B) AS COL_5FD472A9_C6F6_4EBD_913A_4A4EC70AB249#698410]
Input [28]: [jn_numjou#697866, jn_action#697867, jn_typjou#697868, jn_table#697869, jn_datjou#697870, jn_heujou#697871, jn_codper#697872, jn_numdos#697873, jn_numdem#697874, jn_numexa#697875, jn_numdrv#697876, jn_numcr#697877, jn_numfus#697878, jn_comment#697879, jn_codsit#697880, jn_xmldata#697881, jn_prg_code#697882, jn_terminal#697883, jn_osuser#697884, jn_ip_address#697885, jn_flenv#697886, jn_datenv#697887, jn_nument#697888, jn_numstu#697889, jn_numser#697890, jn_numima#697891, jn_numrb#697892, jn_dursec#697893]

(8) LocalLimit [codegen id : 2]
Input [29]: [COL_5F1B26BF_0116_4441_8AA0_8E54C69995EC#698382, COL_50751B07_2C1F_4B42_A389_ACBEC61E76FD#698383, COL_CB1BBC32_6C50_43FA_8EDD_03248998C6B3#698384, COL_48D5E11C_1B3B_45C3_9C69_D69856EEC1C2#698385, COL_CDDE886E_1248_4E9B_8916_DEB3C9E30D6A#698386, COL_21AB7359_69A6_4463_94AF_E19F04314932#698387, COL_25882646_BBE3_4A1C_BC06_2304760A20B9#698388, COL_89DC4B05_2395_4039_9B13_C68E2FEC749B#698389, COL_77E7013C_D4FF_4ADC_A900_33D220B23B5F#698390, COL_8484D7FC_2F45_4222_9765_FD25A8527A00#698391, COL_C9F1BAA4_9456_42AD_87EE_2A9D7D44D696#698392, COL_F15B56EC_65F8_4D77_8B0E_B6E96185327B#698393, COL_C3BA9D9A_A4BA_4D0C_904F_0B035CA82E8F#698394, COL_5813CD9A_CC3C_4F4F_986C_04238061281B#698395, COL_11511345_520B_4A31_9F42_089615E35E25#698396, COL_50544B72_748F_4955_A9EE_444FC5853FC4#698397, COL_2FB27DDB_28A4_4076_8B12_67B3963281F9#698398, COL_941A9562_422A_407F_B5C0_FD1F0CE918B8#698399, COL_193F0589_F384_409E_B999_D28796E9E406#698400, COL_B04E86E8_35DE_4185_AB1F_B0576DD6F763#698401, COL_DAB5CC94_E5F5_4CAD_AB6C_24D524F0AB10#698402, COL_C128B0B9_616F_4346_833E_3E45E77AC49E#698403, COL_E8C57DD2_274E_4354_A11F_9F7898673794#698404, COL_2860AE8E_7B3D_438D_BC29_91FC3A3B7CBE#698405, COL_4DEF7C43_450C_44D6_9718_80CB5325D943#698406, COL_52AE74A8_EF89_4907_A435_05F1D56F2443#698407, COL_1BFECB04_A04D_4D00_987A_1FE0E1BA420C#698408, COL_A7218EA2_AF42_4ECD_8DC7_89B19D17AA23#698409, COL_5FD472A9_C6F6_4EBD_913A_4A4EC70AB249#698410]
Arguments: 1500

(9) Union

(10) CollectLimit
Input [29]: [COL_5F1B26BF_0116_4441_8AA0_8E54C69995EC#698295, COL_50751B07_2C1F_4B42_A389_ACBEC61E76FD#698296, COL_CB1BBC32_6C50_43FA_8EDD_03248998C6B3#698297, COL_48D5E11C_1B3B_45C3_9C69_D69856EEC1C2#698298, COL_CDDE886E_1248_4E9B_8916_DEB3C9E30D6A#698299, COL_21AB7359_69A6_4463_94AF_E19F04314932#698300, COL_25882646_BBE3_4A1C_BC06_2304760A20B9#698301, COL_89DC4B05_2395_4039_9B13_C68E2FEC749B#698302, COL_77E7013C_D4FF_4ADC_A900_33D220B23B5F#698303, COL_8484D7FC_2F45_4222_9765_FD25A8527A00#698304, COL_C9F1BAA4_9456_42AD_87EE_2A9D7D44D696#698305, COL_F15B56EC_65F8_4D77_8B0E_B6E96185327B#698306, COL_C3BA9D9A_A4BA_4D0C_904F_0B035CA82E8F#698307, COL_5813CD9A_CC3C_4F4F_986C_04238061281B#698308, COL_11511345_520B_4A31_9F42_089615E35E25#698309, COL_50544B72_748F_4955_A9EE_444FC5853FC4#698310, COL_2FB27DDB_28A4_4076_8B12_67B3963281F9#698311, COL_941A9562_422A_407F_B5C0_FD1F0CE918B8#698312, COL_193F0589_F384_409E_B999_D28796E9E406#698313, COL_B04E86E8_35DE_4185_AB1F_B0576DD6F763#698314, COL_DAB5CC94_E5F5_4CAD_AB6C_24D524F0AB10#698315, COL_C128B0B9_616F_4346_833E_3E45E77AC49E#698316, COL_E8C57DD2_274E_4354_A11F_9F7898673794#698317, COL_2860AE8E_7B3D_438D_BC29_91FC3A3B7CBE#698318, COL_4DEF7C43_450C_44D6_9718_80CB5325D943#698319, COL_52AE74A8_EF89_4907_A435_05F1D56F2443#698320, COL_1BFECB04_A04D_4D00_987A_1FE0E1BA420C#698321, COL_A7218EA2_AF42_4ECD_8DC7_89B19D17AA23#698322, COL_5FD472A9_C6F6_4EBD_913A_4A4EC70AB249#698323]
Arguments: 1500

SQL / DataFrame Properties

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