hdh-spark-job - Details for Query 1329

Submitted Time: 2026/10/23 13:26:55
Duration: 3 s
Succeeded Jobs: 1328 1331

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: 347 ms"; 3 [labelType="html" label=" LocalLimit "]; 4 [labelType="html" label=" Project "]; 5 [labelType="html" label="Filter number of output rows: 180"]; 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: 346 ms"; 8 [labelType="html" label=" LocalLimit "]; 9 [labelType="html" label=" Project "]; 10 [labelType="html" label="Filter number of output rows: 180"]; 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#660667 AS COL_04E1F459_57B0_4F3C_B5CE_056E9AAF8C3C#661351, jn_action#660668 AS COL_2E1347F3_D27F_45F4_9DDE_8ED53F3BE9C6#661352, jn_typjou#660669 AS COL_447CA75E_185B_4A39_A5C4_240AB572C710#661353, jn_table#660670 AS COL_732D3918_E03D_4C2F_8DF1_8CEF3C61FE4E#661354, jn_datjou#660671 AS COL_3447593C_C0AA_4309_B6D6_CED64D9FAC8A#661355, jn_heujou#660672 AS COL_CB54725D_71D0_4406_9459_E22F310F13BD#661356, jn_codper#660673 AS COL_FD07E62C_8E53_493F_BCEF_58833D864117#661357, jn_numdos#660674 AS COL_10DA8765_2B5B_4725_925C_2708562C4456#661358, jn_numdem#660675 AS COL_7943F88C_97BC_441F_BBF8_C339B3183C90#661359, jn_numexa#660676 AS COL_04B8622D_F80C_4DAC_8CA2_3DF975F5D185#661360, jn_numdrv#660677 AS COL_70EF8CBF_E529_467E_BC8A_5DCBE5733B02#661361, jn_numcr#660678 AS COL_7B821600_FE7B_4DE5_A80A_6C101EF98FBC#661362, jn_numfus#660679 AS COL_6F5FF8CA_FC8B_425B_AA60_94D6F3EE2A6B#661363, jn_comment#660680 AS COL_EF12384C_CA9A_490A_8984_F7CE7F0CEA2F#661364, jn_codsit#660681 AS COL_00FC5A90_6218_4D9E_B017_7FFAD9DB74EF#661365, jn_xmldata#660682 AS COL_0BBEDD45_BEB3_49D6_94CB_7809346461F5#661366, jn_prg_code#660683 AS COL_7C3BF30E_5F0D_407C_A903_8E4558739F2E#661367, jn_terminal#660684 AS COL_F4A37E2F_3C84_415D_BF0E_BD988F0E37DD#661368, jn_osuser#660685 AS COL_ED706854_E4EB_4ABE_B98A_7A73851A05DD#661369, jn_ip_address#660686 AS COL_E1CD2F42_3B84_4BCD_8AC9_5D502479CBA9#661370, jn_flenv#660687 AS COL_749BEB71_CB51_4CE8_B905_AC0C5E85EDB7#661371, jn_datenv#660688 AS COL_D44BD50B_48F9_4810_9620_FC32272B92AB#661372, jn_nument#660689 AS COL_CE3A9CA0_D722_4837_BA35_216614794F40#661373, jn_numstu#660690 AS COL_CF06C768_6EA3_48C1_BF60_264718EDC136#661374, ... 5 more fields]

Filter ((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(jn_numjou#660667)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(jn_numjou#660667)), MARX) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_action#660668)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(jn_action#660668)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_typjou#660669)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(jn_typjou#660669)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_table#660670)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(jn_table#660670)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_datjou#660671)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(jn_datjou#660671)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_heujou#660672)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(jn_heujou#660672)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_codper#660673)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(jn_codper#660673)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_numdos#660674)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(jn_numdos#660674)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_numdem#660675)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(jn_numdem#660675)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_numexa#660676)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(jn_numexa#660676)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_numdrv#660677)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(jn_numdrv#660677)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_numcr#660678)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(jn_numcr#660678)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_numfus#660679)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(jn_numfus#660679)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_comment#660680)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(jn_comment#660680)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_codsit#660681)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(jn_codsit#660681)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_xmldata#660682)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(jn_xmldata#660682)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_prg_code#660683)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(jn_prg_code#660683)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_terminal#660684)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(jn_terminal#660684)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_osuser#660685)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(jn_osuser#660685)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_ip_address#660686)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(jn_ip_address#660686)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_flenv#660687)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(jn_flenv#660687)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_datenv#660688)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(jn_datenv#660688)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_nument#660689)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(jn_nument#660689)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_numstu#660690)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(jn_numstu#660690)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_numser#660691)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(jn_numser#660691)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_numima#660692)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(jn_numima#660692)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_numrb#660693)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(jn_numrb#660693)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_dursec#660694)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(jn_dursec#660694)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_create(Cab_A))), MARX)) THEN false ELSE Contains(str_remove_accent(upper(str_create(Cab_A))), MARX) 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#660667,jn_action#660668,jn_typjou#660669,jn_table#660670,jn_datjou#660671,jn_heujou#660672,jn_codper#660673,jn_numdos#660674,jn_numdem#660675,jn_numexa#660676,jn_numdrv#660677,jn_numcr#660678,jn_numfus#660679,jn_comment#660680,jn_codsit#660681,jn_xmldata#660682,jn_prg_code#660683,jn_terminal#660684,jn_osuser#660685,jn_ip_address#660686,jn_flenv#660687,jn_datenv#660688,jn_nument#660689,jn_numstu#660690,... 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#660922 AS COL_04E1F459_57B0_4F3C_B5CE_056E9AAF8C3C#661438, jn_action#660923 AS COL_2E1347F3_D27F_45F4_9DDE_8ED53F3BE9C6#661439, jn_typjou#660924 AS COL_447CA75E_185B_4A39_A5C4_240AB572C710#661440, jn_table#660925 AS COL_732D3918_E03D_4C2F_8DF1_8CEF3C61FE4E#661441, jn_datjou#660926 AS COL_3447593C_C0AA_4309_B6D6_CED64D9FAC8A#661442, jn_heujou#660927 AS COL_CB54725D_71D0_4406_9459_E22F310F13BD#661443, jn_codper#660928 AS COL_FD07E62C_8E53_493F_BCEF_58833D864117#661444, jn_numdos#660929 AS COL_10DA8765_2B5B_4725_925C_2708562C4456#661445, jn_numdem#660930 AS COL_7943F88C_97BC_441F_BBF8_C339B3183C90#661446, jn_numexa#660931 AS COL_04B8622D_F80C_4DAC_8CA2_3DF975F5D185#661447, jn_numdrv#660932 AS COL_70EF8CBF_E529_467E_BC8A_5DCBE5733B02#661448, jn_numcr#660933 AS COL_7B821600_FE7B_4DE5_A80A_6C101EF98FBC#661449, jn_numfus#660934 AS COL_6F5FF8CA_FC8B_425B_AA60_94D6F3EE2A6B#661450, jn_comment#660935 AS COL_EF12384C_CA9A_490A_8984_F7CE7F0CEA2F#661451, jn_codsit#660936 AS COL_00FC5A90_6218_4D9E_B017_7FFAD9DB74EF#661452, jn_xmldata#660937 AS COL_0BBEDD45_BEB3_49D6_94CB_7809346461F5#661453, jn_prg_code#660938 AS COL_7C3BF30E_5F0D_407C_A903_8E4558739F2E#661454, jn_terminal#660939 AS COL_F4A37E2F_3C84_415D_BF0E_BD988F0E37DD#661455, jn_osuser#660940 AS COL_ED706854_E4EB_4ABE_B98A_7A73851A05DD#661456, jn_ip_address#660941 AS COL_E1CD2F42_3B84_4BCD_8AC9_5D502479CBA9#661457, jn_flenv#660942 AS COL_749BEB71_CB51_4CE8_B905_AC0C5E85EDB7#661458, jn_datenv#660943 AS COL_D44BD50B_48F9_4810_9620_FC32272B92AB#661459, jn_nument#660944 AS COL_CE3A9CA0_D722_4837_BA35_216614794F40#661460, jn_numstu#660945 AS COL_CF06C768_6EA3_48C1_BF60_264718EDC136#661461, ... 5 more fields]

Filter ((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(jn_numjou#660922)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(jn_numjou#660922)), MARX) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_action#660923)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(jn_action#660923)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_typjou#660924)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(jn_typjou#660924)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_table#660925)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(jn_table#660925)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_datjou#660926)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(jn_datjou#660926)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_heujou#660927)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(jn_heujou#660927)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_codper#660928)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(jn_codper#660928)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_numdos#660929)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(jn_numdos#660929)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_numdem#660930)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(jn_numdem#660930)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_numexa#660931)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(jn_numexa#660931)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_numdrv#660932)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(jn_numdrv#660932)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_numcr#660933)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(jn_numcr#660933)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_numfus#660934)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(jn_numfus#660934)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_comment#660935)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(jn_comment#660935)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_codsit#660936)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(jn_codsit#660936)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_xmldata#660937)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(jn_xmldata#660937)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_prg_code#660938)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(jn_prg_code#660938)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_terminal#660939)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(jn_terminal#660939)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_osuser#660940)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(jn_osuser#660940)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_ip_address#660941)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(jn_ip_address#660941)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_flenv#660942)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(jn_flenv#660942)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_datenv#660943)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(jn_datenv#660943)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_nument#660944)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(jn_nument#660944)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_numstu#660945)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(jn_numstu#660945)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_numser#660946)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(jn_numser#660946)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_numima#660947)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(jn_numima#660947)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_numrb#660948)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(jn_numrb#660948)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_dursec#660949)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(jn_dursec#660949)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_create(Cab_B))), MARX)) THEN false ELSE Contains(str_remove_accent(upper(str_create(Cab_B))), MARX) 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#660922,jn_action#660923,jn_typjou#660924,jn_table#660925,jn_datjou#660926,jn_heujou#660927,jn_codper#660928,jn_numdos#660929,jn_numdem#660930,jn_numexa#660931,jn_numdrv#660932,jn_numcr#660933,jn_numfus#660934,jn_comment#660935,jn_codsit#660936,jn_xmldata#660937,jn_prg_code#660938,jn_terminal#660939,jn_osuser#660940,jn_ip_address#660941,jn_flenv#660942,jn_datenv#660943,jn_nument#660944,jn_numstu#660945,... 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#660667, jn_action#660668, jn_typjou#660669, jn_table#660670, jn_datjou#660671, jn_heujou#660672, jn_codper#660673, jn_numdos#660674, jn_numdem#660675, jn_numexa#660676, jn_numdrv#660677, jn_numcr#660678, jn_numfus#660679, jn_comment#660680, jn_codsit#660681, jn_xmldata#660682, jn_prg_code#660683, jn_terminal#660684, jn_osuser#660685, jn_ip_address#660686, jn_flenv#660687, jn_datenv#660688, jn_nument#660689, jn_numstu#660690, jn_numser#660691, jn_numima#660692, jn_numrb#660693, jn_dursec#660694]
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#660667, jn_action#660668, jn_typjou#660669, jn_table#660670, jn_datjou#660671, jn_heujou#660672, jn_codper#660673, jn_numdos#660674, jn_numdem#660675, jn_numexa#660676, jn_numdrv#660677, jn_numcr#660678, jn_numfus#660679, jn_comment#660680, jn_codsit#660681, jn_xmldata#660682, jn_prg_code#660683, jn_terminal#660684, jn_osuser#660685, jn_ip_address#660686, jn_flenv#660687, jn_datenv#660688, jn_nument#660689, jn_numstu#660690, jn_numser#660691, jn_numima#660692, jn_numrb#660693, jn_dursec#660694]
Condition : ((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(jn_numjou#660667)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(jn_numjou#660667)), MARX) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_action#660668)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(jn_action#660668)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_typjou#660669)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(jn_typjou#660669)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_table#660670)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(jn_table#660670)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_datjou#660671)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(jn_datjou#660671)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_heujou#660672)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(jn_heujou#660672)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_codper#660673)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(jn_codper#660673)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_numdos#660674)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(jn_numdos#660674)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_numdem#660675)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(jn_numdem#660675)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_numexa#660676)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(jn_numexa#660676)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_numdrv#660677)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(jn_numdrv#660677)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_numcr#660678)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(jn_numcr#660678)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_numfus#660679)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(jn_numfus#660679)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_comment#660680)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(jn_comment#660680)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_codsit#660681)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(jn_codsit#660681)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_xmldata#660682)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(jn_xmldata#660682)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_prg_code#660683)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(jn_prg_code#660683)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_terminal#660684)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(jn_terminal#660684)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_osuser#660685)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(jn_osuser#660685)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_ip_address#660686)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(jn_ip_address#660686)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_flenv#660687)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(jn_flenv#660687)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_datenv#660688)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(jn_datenv#660688)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_nument#660689)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(jn_nument#660689)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_numstu#660690)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(jn_numstu#660690)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_numser#660691)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(jn_numser#660691)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_numima#660692)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(jn_numima#660692)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_numrb#660693)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(jn_numrb#660693)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_dursec#660694)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(jn_dursec#660694)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_create(Cab_A))), MARX)) THEN false ELSE Contains(str_remove_accent(upper(str_create(Cab_A))), MARX) END)

(3) Project [codegen id : 1]
Output [29]: [jn_numjou#660667 AS COL_04E1F459_57B0_4F3C_B5CE_056E9AAF8C3C#661351, jn_action#660668 AS COL_2E1347F3_D27F_45F4_9DDE_8ED53F3BE9C6#661352, jn_typjou#660669 AS COL_447CA75E_185B_4A39_A5C4_240AB572C710#661353, jn_table#660670 AS COL_732D3918_E03D_4C2F_8DF1_8CEF3C61FE4E#661354, jn_datjou#660671 AS COL_3447593C_C0AA_4309_B6D6_CED64D9FAC8A#661355, jn_heujou#660672 AS COL_CB54725D_71D0_4406_9459_E22F310F13BD#661356, jn_codper#660673 AS COL_FD07E62C_8E53_493F_BCEF_58833D864117#661357, jn_numdos#660674 AS COL_10DA8765_2B5B_4725_925C_2708562C4456#661358, jn_numdem#660675 AS COL_7943F88C_97BC_441F_BBF8_C339B3183C90#661359, jn_numexa#660676 AS COL_04B8622D_F80C_4DAC_8CA2_3DF975F5D185#661360, jn_numdrv#660677 AS COL_70EF8CBF_E529_467E_BC8A_5DCBE5733B02#661361, jn_numcr#660678 AS COL_7B821600_FE7B_4DE5_A80A_6C101EF98FBC#661362, jn_numfus#660679 AS COL_6F5FF8CA_FC8B_425B_AA60_94D6F3EE2A6B#661363, jn_comment#660680 AS COL_EF12384C_CA9A_490A_8984_F7CE7F0CEA2F#661364, jn_codsit#660681 AS COL_00FC5A90_6218_4D9E_B017_7FFAD9DB74EF#661365, jn_xmldata#660682 AS COL_0BBEDD45_BEB3_49D6_94CB_7809346461F5#661366, jn_prg_code#660683 AS COL_7C3BF30E_5F0D_407C_A903_8E4558739F2E#661367, jn_terminal#660684 AS COL_F4A37E2F_3C84_415D_BF0E_BD988F0E37DD#661368, jn_osuser#660685 AS COL_ED706854_E4EB_4ABE_B98A_7A73851A05DD#661369, jn_ip_address#660686 AS COL_E1CD2F42_3B84_4BCD_8AC9_5D502479CBA9#661370, jn_flenv#660687 AS COL_749BEB71_CB51_4CE8_B905_AC0C5E85EDB7#661371, jn_datenv#660688 AS COL_D44BD50B_48F9_4810_9620_FC32272B92AB#661372, jn_nument#660689 AS COL_CE3A9CA0_D722_4837_BA35_216614794F40#661373, jn_numstu#660690 AS COL_CF06C768_6EA3_48C1_BF60_264718EDC136#661374, jn_numser#660691 AS COL_9D12DFC8_0C92_4126_BEDF_9B0EC223FAA2#661375, jn_numima#660692 AS COL_B0C4E25A_8D09_4498_B7FC_02B5F8999E7C#661376, jn_numrb#660693 AS COL_E5EF3FBB_9062_4BAD_9533_F9F3AB97D171#661377, jn_dursec#660694 AS COL_E9C0AA8A_13CF_44B4_96F9_D4D2912AB108#661378, str_create(Cab_A) AS COL_1BB5C9C6_83A5_4F15_8C23_8B48EE27AD74#661379]
Input [28]: [jn_numjou#660667, jn_action#660668, jn_typjou#660669, jn_table#660670, jn_datjou#660671, jn_heujou#660672, jn_codper#660673, jn_numdos#660674, jn_numdem#660675, jn_numexa#660676, jn_numdrv#660677, jn_numcr#660678, jn_numfus#660679, jn_comment#660680, jn_codsit#660681, jn_xmldata#660682, jn_prg_code#660683, jn_terminal#660684, jn_osuser#660685, jn_ip_address#660686, jn_flenv#660687, jn_datenv#660688, jn_nument#660689, jn_numstu#660690, jn_numser#660691, jn_numima#660692, jn_numrb#660693, jn_dursec#660694]

(4) LocalLimit [codegen id : 1]
Input [29]: [COL_04E1F459_57B0_4F3C_B5CE_056E9AAF8C3C#661351, COL_2E1347F3_D27F_45F4_9DDE_8ED53F3BE9C6#661352, COL_447CA75E_185B_4A39_A5C4_240AB572C710#661353, COL_732D3918_E03D_4C2F_8DF1_8CEF3C61FE4E#661354, COL_3447593C_C0AA_4309_B6D6_CED64D9FAC8A#661355, COL_CB54725D_71D0_4406_9459_E22F310F13BD#661356, COL_FD07E62C_8E53_493F_BCEF_58833D864117#661357, COL_10DA8765_2B5B_4725_925C_2708562C4456#661358, COL_7943F88C_97BC_441F_BBF8_C339B3183C90#661359, COL_04B8622D_F80C_4DAC_8CA2_3DF975F5D185#661360, COL_70EF8CBF_E529_467E_BC8A_5DCBE5733B02#661361, COL_7B821600_FE7B_4DE5_A80A_6C101EF98FBC#661362, COL_6F5FF8CA_FC8B_425B_AA60_94D6F3EE2A6B#661363, COL_EF12384C_CA9A_490A_8984_F7CE7F0CEA2F#661364, COL_00FC5A90_6218_4D9E_B017_7FFAD9DB74EF#661365, COL_0BBEDD45_BEB3_49D6_94CB_7809346461F5#661366, COL_7C3BF30E_5F0D_407C_A903_8E4558739F2E#661367, COL_F4A37E2F_3C84_415D_BF0E_BD988F0E37DD#661368, COL_ED706854_E4EB_4ABE_B98A_7A73851A05DD#661369, COL_E1CD2F42_3B84_4BCD_8AC9_5D502479CBA9#661370, COL_749BEB71_CB51_4CE8_B905_AC0C5E85EDB7#661371, COL_D44BD50B_48F9_4810_9620_FC32272B92AB#661372, COL_CE3A9CA0_D722_4837_BA35_216614794F40#661373, COL_CF06C768_6EA3_48C1_BF60_264718EDC136#661374, COL_9D12DFC8_0C92_4126_BEDF_9B0EC223FAA2#661375, COL_B0C4E25A_8D09_4498_B7FC_02B5F8999E7C#661376, COL_E5EF3FBB_9062_4BAD_9533_F9F3AB97D171#661377, COL_E9C0AA8A_13CF_44B4_96F9_D4D2912AB108#661378, COL_1BB5C9C6_83A5_4F15_8C23_8B48EE27AD74#661379]
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#660922, jn_action#660923, jn_typjou#660924, jn_table#660925, jn_datjou#660926, jn_heujou#660927, jn_codper#660928, jn_numdos#660929, jn_numdem#660930, jn_numexa#660931, jn_numdrv#660932, jn_numcr#660933, jn_numfus#660934, jn_comment#660935, jn_codsit#660936, jn_xmldata#660937, jn_prg_code#660938, jn_terminal#660939, jn_osuser#660940, jn_ip_address#660941, jn_flenv#660942, jn_datenv#660943, jn_nument#660944, jn_numstu#660945, jn_numser#660946, jn_numima#660947, jn_numrb#660948, jn_dursec#660949]
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#660922, jn_action#660923, jn_typjou#660924, jn_table#660925, jn_datjou#660926, jn_heujou#660927, jn_codper#660928, jn_numdos#660929, jn_numdem#660930, jn_numexa#660931, jn_numdrv#660932, jn_numcr#660933, jn_numfus#660934, jn_comment#660935, jn_codsit#660936, jn_xmldata#660937, jn_prg_code#660938, jn_terminal#660939, jn_osuser#660940, jn_ip_address#660941, jn_flenv#660942, jn_datenv#660943, jn_nument#660944, jn_numstu#660945, jn_numser#660946, jn_numima#660947, jn_numrb#660948, jn_dursec#660949]
Condition : ((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(jn_numjou#660922)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(jn_numjou#660922)), MARX) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_action#660923)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(jn_action#660923)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_typjou#660924)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(jn_typjou#660924)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_table#660925)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(jn_table#660925)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_datjou#660926)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(jn_datjou#660926)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_heujou#660927)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(jn_heujou#660927)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_codper#660928)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(jn_codper#660928)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_numdos#660929)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(jn_numdos#660929)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_numdem#660930)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(jn_numdem#660930)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_numexa#660931)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(jn_numexa#660931)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_numdrv#660932)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(jn_numdrv#660932)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_numcr#660933)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(jn_numcr#660933)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_numfus#660934)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(jn_numfus#660934)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_comment#660935)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(jn_comment#660935)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_codsit#660936)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(jn_codsit#660936)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_xmldata#660937)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(jn_xmldata#660937)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_prg_code#660938)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(jn_prg_code#660938)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_terminal#660939)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(jn_terminal#660939)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_osuser#660940)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(jn_osuser#660940)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_ip_address#660941)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(jn_ip_address#660941)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_flenv#660942)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(jn_flenv#660942)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_datenv#660943)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(jn_datenv#660943)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_nument#660944)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(jn_nument#660944)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_numstu#660945)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(jn_numstu#660945)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_numser#660946)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(jn_numser#660946)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_numima#660947)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(jn_numima#660947)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_numrb#660948)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(jn_numrb#660948)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(jn_dursec#660949)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(jn_dursec#660949)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_create(Cab_B))), MARX)) THEN false ELSE Contains(str_remove_accent(upper(str_create(Cab_B))), MARX) END)

(7) Project [codegen id : 2]
Output [29]: [jn_numjou#660922 AS COL_04E1F459_57B0_4F3C_B5CE_056E9AAF8C3C#661438, jn_action#660923 AS COL_2E1347F3_D27F_45F4_9DDE_8ED53F3BE9C6#661439, jn_typjou#660924 AS COL_447CA75E_185B_4A39_A5C4_240AB572C710#661440, jn_table#660925 AS COL_732D3918_E03D_4C2F_8DF1_8CEF3C61FE4E#661441, jn_datjou#660926 AS COL_3447593C_C0AA_4309_B6D6_CED64D9FAC8A#661442, jn_heujou#660927 AS COL_CB54725D_71D0_4406_9459_E22F310F13BD#661443, jn_codper#660928 AS COL_FD07E62C_8E53_493F_BCEF_58833D864117#661444, jn_numdos#660929 AS COL_10DA8765_2B5B_4725_925C_2708562C4456#661445, jn_numdem#660930 AS COL_7943F88C_97BC_441F_BBF8_C339B3183C90#661446, jn_numexa#660931 AS COL_04B8622D_F80C_4DAC_8CA2_3DF975F5D185#661447, jn_numdrv#660932 AS COL_70EF8CBF_E529_467E_BC8A_5DCBE5733B02#661448, jn_numcr#660933 AS COL_7B821600_FE7B_4DE5_A80A_6C101EF98FBC#661449, jn_numfus#660934 AS COL_6F5FF8CA_FC8B_425B_AA60_94D6F3EE2A6B#661450, jn_comment#660935 AS COL_EF12384C_CA9A_490A_8984_F7CE7F0CEA2F#661451, jn_codsit#660936 AS COL_00FC5A90_6218_4D9E_B017_7FFAD9DB74EF#661452, jn_xmldata#660937 AS COL_0BBEDD45_BEB3_49D6_94CB_7809346461F5#661453, jn_prg_code#660938 AS COL_7C3BF30E_5F0D_407C_A903_8E4558739F2E#661454, jn_terminal#660939 AS COL_F4A37E2F_3C84_415D_BF0E_BD988F0E37DD#661455, jn_osuser#660940 AS COL_ED706854_E4EB_4ABE_B98A_7A73851A05DD#661456, jn_ip_address#660941 AS COL_E1CD2F42_3B84_4BCD_8AC9_5D502479CBA9#661457, jn_flenv#660942 AS COL_749BEB71_CB51_4CE8_B905_AC0C5E85EDB7#661458, jn_datenv#660943 AS COL_D44BD50B_48F9_4810_9620_FC32272B92AB#661459, jn_nument#660944 AS COL_CE3A9CA0_D722_4837_BA35_216614794F40#661460, jn_numstu#660945 AS COL_CF06C768_6EA3_48C1_BF60_264718EDC136#661461, jn_numser#660946 AS COL_9D12DFC8_0C92_4126_BEDF_9B0EC223FAA2#661462, jn_numima#660947 AS COL_B0C4E25A_8D09_4498_B7FC_02B5F8999E7C#661463, jn_numrb#660948 AS COL_E5EF3FBB_9062_4BAD_9533_F9F3AB97D171#661464, jn_dursec#660949 AS COL_E9C0AA8A_13CF_44B4_96F9_D4D2912AB108#661465, str_create(Cab_B) AS COL_1BB5C9C6_83A5_4F15_8C23_8B48EE27AD74#661466]
Input [28]: [jn_numjou#660922, jn_action#660923, jn_typjou#660924, jn_table#660925, jn_datjou#660926, jn_heujou#660927, jn_codper#660928, jn_numdos#660929, jn_numdem#660930, jn_numexa#660931, jn_numdrv#660932, jn_numcr#660933, jn_numfus#660934, jn_comment#660935, jn_codsit#660936, jn_xmldata#660937, jn_prg_code#660938, jn_terminal#660939, jn_osuser#660940, jn_ip_address#660941, jn_flenv#660942, jn_datenv#660943, jn_nument#660944, jn_numstu#660945, jn_numser#660946, jn_numima#660947, jn_numrb#660948, jn_dursec#660949]

(8) LocalLimit [codegen id : 2]
Input [29]: [COL_04E1F459_57B0_4F3C_B5CE_056E9AAF8C3C#661438, COL_2E1347F3_D27F_45F4_9DDE_8ED53F3BE9C6#661439, COL_447CA75E_185B_4A39_A5C4_240AB572C710#661440, COL_732D3918_E03D_4C2F_8DF1_8CEF3C61FE4E#661441, COL_3447593C_C0AA_4309_B6D6_CED64D9FAC8A#661442, COL_CB54725D_71D0_4406_9459_E22F310F13BD#661443, COL_FD07E62C_8E53_493F_BCEF_58833D864117#661444, COL_10DA8765_2B5B_4725_925C_2708562C4456#661445, COL_7943F88C_97BC_441F_BBF8_C339B3183C90#661446, COL_04B8622D_F80C_4DAC_8CA2_3DF975F5D185#661447, COL_70EF8CBF_E529_467E_BC8A_5DCBE5733B02#661448, COL_7B821600_FE7B_4DE5_A80A_6C101EF98FBC#661449, COL_6F5FF8CA_FC8B_425B_AA60_94D6F3EE2A6B#661450, COL_EF12384C_CA9A_490A_8984_F7CE7F0CEA2F#661451, COL_00FC5A90_6218_4D9E_B017_7FFAD9DB74EF#661452, COL_0BBEDD45_BEB3_49D6_94CB_7809346461F5#661453, COL_7C3BF30E_5F0D_407C_A903_8E4558739F2E#661454, COL_F4A37E2F_3C84_415D_BF0E_BD988F0E37DD#661455, COL_ED706854_E4EB_4ABE_B98A_7A73851A05DD#661456, COL_E1CD2F42_3B84_4BCD_8AC9_5D502479CBA9#661457, COL_749BEB71_CB51_4CE8_B905_AC0C5E85EDB7#661458, COL_D44BD50B_48F9_4810_9620_FC32272B92AB#661459, COL_CE3A9CA0_D722_4837_BA35_216614794F40#661460, COL_CF06C768_6EA3_48C1_BF60_264718EDC136#661461, COL_9D12DFC8_0C92_4126_BEDF_9B0EC223FAA2#661462, COL_B0C4E25A_8D09_4498_B7FC_02B5F8999E7C#661463, COL_E5EF3FBB_9062_4BAD_9533_F9F3AB97D171#661464, COL_E9C0AA8A_13CF_44B4_96F9_D4D2912AB108#661465, COL_1BB5C9C6_83A5_4F15_8C23_8B48EE27AD74#661466]
Arguments: 1500

(9) Union

(10) CollectLimit
Input [29]: [COL_04E1F459_57B0_4F3C_B5CE_056E9AAF8C3C#661351, COL_2E1347F3_D27F_45F4_9DDE_8ED53F3BE9C6#661352, COL_447CA75E_185B_4A39_A5C4_240AB572C710#661353, COL_732D3918_E03D_4C2F_8DF1_8CEF3C61FE4E#661354, COL_3447593C_C0AA_4309_B6D6_CED64D9FAC8A#661355, COL_CB54725D_71D0_4406_9459_E22F310F13BD#661356, COL_FD07E62C_8E53_493F_BCEF_58833D864117#661357, COL_10DA8765_2B5B_4725_925C_2708562C4456#661358, COL_7943F88C_97BC_441F_BBF8_C339B3183C90#661359, COL_04B8622D_F80C_4DAC_8CA2_3DF975F5D185#661360, COL_70EF8CBF_E529_467E_BC8A_5DCBE5733B02#661361, COL_7B821600_FE7B_4DE5_A80A_6C101EF98FBC#661362, COL_6F5FF8CA_FC8B_425B_AA60_94D6F3EE2A6B#661363, COL_EF12384C_CA9A_490A_8984_F7CE7F0CEA2F#661364, COL_00FC5A90_6218_4D9E_B017_7FFAD9DB74EF#661365, COL_0BBEDD45_BEB3_49D6_94CB_7809346461F5#661366, COL_7C3BF30E_5F0D_407C_A903_8E4558739F2E#661367, COL_F4A37E2F_3C84_415D_BF0E_BD988F0E37DD#661368, COL_ED706854_E4EB_4ABE_B98A_7A73851A05DD#661369, COL_E1CD2F42_3B84_4BCD_8AC9_5D502479CBA9#661370, COL_749BEB71_CB51_4CE8_B905_AC0C5E85EDB7#661371, COL_D44BD50B_48F9_4810_9620_FC32272B92AB#661372, COL_CE3A9CA0_D722_4837_BA35_216614794F40#661373, COL_CF06C768_6EA3_48C1_BF60_264718EDC136#661374, COL_9D12DFC8_0C92_4126_BEDF_9B0EC223FAA2#661375, COL_B0C4E25A_8D09_4498_B7FC_02B5F8999E7C#661376, COL_E5EF3FBB_9062_4BAD_9533_F9F3AB97D171#661377, COL_E9C0AA8A_13CF_44B4_96F9_D4D2912AB108#661378, COL_1BB5C9C6_83A5_4F15_8C23_8B48EE27AD74#661379]
Arguments: 1500

SQL / DataFrame Properties

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