hdh-spark-job - Details for Query 709

Submitted Time: 2026/10/21 21:35:51
Duration: 0.6 s
Succeeded Jobs: 688 689

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

digraph G { 0 [labelType="html" label=" AdaptiveSparkPlan "]; 1 [labelType="html" label="SortAggregate number of output rows: 1"]; 2 [labelType="html" label="Exchange shuffle records written: 1 local merged chunks fetched: 0 shuffle write time: 0 ms remote merged bytes read: 0.0 B local merged blocks fetched: 0 corrupt merged block chunks: 0 remote merged reqs duration: 0 ms remote merged blocks fetched: 0 records read: 1 local bytes read: 101.0 B fetch wait time: 0 ms remote bytes read: 0.0 B merged fetch fallback count: 0 local blocks read: 1 remote merged chunks fetched: 0 remote blocks read: 0 data size: 72.0 B local merged bytes read: 0.0 B number of partitions: 1 remote reqs duration: 0 ms remote bytes read to disk: 0.0 B shuffle bytes written: 101.0 B"]; 3 [labelType="html" label="SortAggregate number of output rows: 1"]; subgraph cluster4 { isCluster="true"; label="WholeStageCodegen (1)\n \nduration: 339 ms"; 5 [labelType="html" label=" Project "]; 6 [labelType="html" label="Filter number of output rows: 180"]; 7 [labelType="html" label="ColumnarToRow number of output rows: 8,765 number of input batches: 3"]; } 8 [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"]; 1->0; 2->1; 3->2; 5->3; 6->5; 7->6; 8->7; }

AdaptiveSparkPlan isFinalPlan=true

SortAggregate(key=[], functions=[count(1), count(COL_8D5A1E74_3717_468E_BFC4_C915C657FBC3#155361), min(COL_8D5A1E74_3717_468E_BFC4_C915C657FBC3#155361), max(COL_8D5A1E74_3717_468E_BFC4_C915C657FBC3#155361)])

Exchange SinglePartition, ENSURE_REQUIREMENTS, [plan_id=14516]

SortAggregate(key=[], functions=[partial_count(1), partial_count(COL_8D5A1E74_3717_468E_BFC4_C915C657FBC3#155361), partial_min(COL_8D5A1E74_3717_468E_BFC4_C915C657FBC3#155361), partial_max(COL_8D5A1E74_3717_468E_BFC4_C915C657FBC3#155361)])

Project [JN_TYPJOU_437912#155217 AS COL_8D5A1E74_3717_468E_BFC4_C915C657FBC3#155361]

Filter (((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(JN_NUMJOU_437910#155209)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(JN_NUMJOU_437910#155209)), MARX) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(JN_ACTION_437911#155191)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(JN_ACTION_437911#155191)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(JN_TYPJOU_437912#155217)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(JN_TYPJOU_437912#155217)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(JN_TABLE_437913#155215)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(JN_TABLE_437913#155215)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(JN_DATJOU_437914#155196)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(JN_DATJOU_437914#155196)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(JN_HEUJOU_437915#155199)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(JN_HEUJOU_437915#155199)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(JN_CODPER_437916#155192)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(JN_CODPER_437916#155192)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(JN_NUMDOS_437917#155203)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(JN_NUMDOS_437917#155203)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(JN_NUMDEM_437918#155202)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(JN_NUMDEM_437918#155202)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(JN_NUMEXA_437919#155206)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(JN_NUMEXA_437919#155206)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(JN_NUMDRV_437920#155204)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(JN_NUMDRV_437920#155204)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(JN_NUMCR_437921#155201)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(JN_NUMCR_437921#155201)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(JN_NUMFUS_437922#155207)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(JN_NUMFUS_437922#155207)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(JN_COMMENT_437923#155194)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(JN_COMMENT_437923#155194)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(JN_CODSIT_437924#155193)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(JN_CODSIT_437924#155193)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(JN_XMLDATA_437925#155218)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(JN_XMLDATA_437925#155218)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(JN_PRG_CODE_437926#155214)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(JN_PRG_CODE_437926#155214)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(JN_TERMINAL_437927#155216)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(JN_TERMINAL_437927#155216)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(JN_OSUSER_437928#155213)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(JN_OSUSER_437928#155213)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(JN_IP_ADDRESS_437929#155200)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(JN_IP_ADDRESS_437929#155200)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(JN_FLENV_437930#155198)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(JN_FLENV_437930#155198)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(JN_DATENV_437931#155195)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(JN_DATENV_437931#155195)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(JN_NUMENT_437932#155205)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(JN_NUMENT_437932#155205)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(JN_NUMSTU_437933#155212)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(JN_NUMSTU_437933#155212)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(JN_NUMSER_437934#155211)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(JN_NUMSER_437934#155211)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(JN_NUMIMA_437935#155208)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(JN_NUMIMA_437935#155208)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(JN_NUMRB_437936#155210)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(JN_NUMRB_437936#155210)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(JN_DURSEC_437937#155197)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(JN_DURSEC_437937#155197)), MARX) END)

ColumnarToRow

WholeStageCodegen (1)

FileScan parquet [JN_ACTION_437911#155191,JN_CODPER_437916#155192,JN_CODSIT_437924#155193,JN_COMMENT_437923#155194,JN_DATENV_437931#155195,JN_DATJOU_437914#155196,JN_DURSEC_437937#155197,JN_FLENV_437930#155198,JN_HEUJOU_437915#155199,JN_IP_ADDRESS_437929#155200,JN_NUMCR_437921#155201,JN_NUMDEM_437918#155202,JN_NUMDOS_437917#155203,JN_NUMDRV_437920#155204,JN_NUMENT_437932#155205,JN_NUMEXA_437919#155206,JN_NUMFUS_437922#155207,JN_NUMIMA_437935#155208,JN_NUMJOU_437910#155209,JN_NUMRB_437936#155210,JN_NUMSER_437934#155211,JN_NUMSTU_437933#155212,JN_OSUSER_437928#155213,JN_PRG_CODE_437926#155214,... 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 ==
AdaptiveSparkPlan (14)
+- == Final Plan ==
   SortAggregate (8)
   +- ShuffleQueryStage (7), Statistics(sizeInBytes=72.0 B, rowCount=1)
      +- Exchange (6)
         +- SortAggregate (5)
            +- * Project (4)
               +- * Filter (3)
                  +- * ColumnarToRow (2)
                     +- Scan parquet  (1)
+- == Initial Plan ==
   SortAggregate (13)
   +- Exchange (12)
      +- SortAggregate (11)
         +- Project (10)
            +- Filter (9)
               +- Scan parquet  (1)


(1) Scan parquet 
Output [28]: [JN_ACTION_437911#155191, JN_CODPER_437916#155192, JN_CODSIT_437924#155193, JN_COMMENT_437923#155194, JN_DATENV_437931#155195, JN_DATJOU_437914#155196, JN_DURSEC_437937#155197, JN_FLENV_437930#155198, JN_HEUJOU_437915#155199, JN_IP_ADDRESS_437929#155200, JN_NUMCR_437921#155201, JN_NUMDEM_437918#155202, JN_NUMDOS_437917#155203, JN_NUMDRV_437920#155204, JN_NUMENT_437932#155205, JN_NUMEXA_437919#155206, JN_NUMFUS_437922#155207, JN_NUMIMA_437935#155208, JN_NUMJOU_437910#155209, JN_NUMRB_437936#155210, JN_NUMSER_437934#155211, JN_NUMSTU_437933#155212, JN_OSUSER_437928#155213, JN_PRG_CODE_437926#155214, JN_TABLE_437913#155215, JN_TERMINAL_437927#155216, JN_TYPJOU_437912#155217, JN_XMLDATA_437925#155218]
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#155191, JN_CODPER_437916#155192, JN_CODSIT_437924#155193, JN_COMMENT_437923#155194, JN_DATENV_437931#155195, JN_DATJOU_437914#155196, JN_DURSEC_437937#155197, JN_FLENV_437930#155198, JN_HEUJOU_437915#155199, JN_IP_ADDRESS_437929#155200, JN_NUMCR_437921#155201, JN_NUMDEM_437918#155202, JN_NUMDOS_437917#155203, JN_NUMDRV_437920#155204, JN_NUMENT_437932#155205, JN_NUMEXA_437919#155206, JN_NUMFUS_437922#155207, JN_NUMIMA_437935#155208, JN_NUMJOU_437910#155209, JN_NUMRB_437936#155210, JN_NUMSER_437934#155211, JN_NUMSTU_437933#155212, JN_OSUSER_437928#155213, JN_PRG_CODE_437926#155214, JN_TABLE_437913#155215, JN_TERMINAL_437927#155216, JN_TYPJOU_437912#155217, JN_XMLDATA_437925#155218]

(3) Filter [codegen id : 1]
Input [28]: [JN_ACTION_437911#155191, JN_CODPER_437916#155192, JN_CODSIT_437924#155193, JN_COMMENT_437923#155194, JN_DATENV_437931#155195, JN_DATJOU_437914#155196, JN_DURSEC_437937#155197, JN_FLENV_437930#155198, JN_HEUJOU_437915#155199, JN_IP_ADDRESS_437929#155200, JN_NUMCR_437921#155201, JN_NUMDEM_437918#155202, JN_NUMDOS_437917#155203, JN_NUMDRV_437920#155204, JN_NUMENT_437932#155205, JN_NUMEXA_437919#155206, JN_NUMFUS_437922#155207, JN_NUMIMA_437935#155208, JN_NUMJOU_437910#155209, JN_NUMRB_437936#155210, JN_NUMSER_437934#155211, JN_NUMSTU_437933#155212, JN_OSUSER_437928#155213, JN_PRG_CODE_437926#155214, JN_TABLE_437913#155215, JN_TERMINAL_437927#155216, JN_TYPJOU_437912#155217, JN_XMLDATA_437925#155218]
Condition : (((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(JN_NUMJOU_437910#155209)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(JN_NUMJOU_437910#155209)), MARX) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(JN_ACTION_437911#155191)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(JN_ACTION_437911#155191)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(JN_TYPJOU_437912#155217)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(JN_TYPJOU_437912#155217)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(JN_TABLE_437913#155215)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(JN_TABLE_437913#155215)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(JN_DATJOU_437914#155196)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(JN_DATJOU_437914#155196)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(JN_HEUJOU_437915#155199)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(JN_HEUJOU_437915#155199)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(JN_CODPER_437916#155192)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(JN_CODPER_437916#155192)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(JN_NUMDOS_437917#155203)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(JN_NUMDOS_437917#155203)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(JN_NUMDEM_437918#155202)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(JN_NUMDEM_437918#155202)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(JN_NUMEXA_437919#155206)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(JN_NUMEXA_437919#155206)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(JN_NUMDRV_437920#155204)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(JN_NUMDRV_437920#155204)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(JN_NUMCR_437921#155201)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(JN_NUMCR_437921#155201)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(JN_NUMFUS_437922#155207)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(JN_NUMFUS_437922#155207)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(JN_COMMENT_437923#155194)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(JN_COMMENT_437923#155194)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(JN_CODSIT_437924#155193)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(JN_CODSIT_437924#155193)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(JN_XMLDATA_437925#155218)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(JN_XMLDATA_437925#155218)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(JN_PRG_CODE_437926#155214)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(JN_PRG_CODE_437926#155214)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(JN_TERMINAL_437927#155216)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(JN_TERMINAL_437927#155216)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(JN_OSUSER_437928#155213)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(JN_OSUSER_437928#155213)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(JN_IP_ADDRESS_437929#155200)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(JN_IP_ADDRESS_437929#155200)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(JN_FLENV_437930#155198)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(JN_FLENV_437930#155198)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(JN_DATENV_437931#155195)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(JN_DATENV_437931#155195)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(JN_NUMENT_437932#155205)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(JN_NUMENT_437932#155205)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(JN_NUMSTU_437933#155212)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(JN_NUMSTU_437933#155212)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(JN_NUMSER_437934#155211)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(JN_NUMSER_437934#155211)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(JN_NUMIMA_437935#155208)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(JN_NUMIMA_437935#155208)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(JN_NUMRB_437936#155210)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(JN_NUMRB_437936#155210)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(JN_DURSEC_437937#155197)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(JN_DURSEC_437937#155197)), MARX) END)

(4) Project [codegen id : 1]
Output [1]: [JN_TYPJOU_437912#155217 AS COL_8D5A1E74_3717_468E_BFC4_C915C657FBC3#155361]
Input [28]: [JN_ACTION_437911#155191, JN_CODPER_437916#155192, JN_CODSIT_437924#155193, JN_COMMENT_437923#155194, JN_DATENV_437931#155195, JN_DATJOU_437914#155196, JN_DURSEC_437937#155197, JN_FLENV_437930#155198, JN_HEUJOU_437915#155199, JN_IP_ADDRESS_437929#155200, JN_NUMCR_437921#155201, JN_NUMDEM_437918#155202, JN_NUMDOS_437917#155203, JN_NUMDRV_437920#155204, JN_NUMENT_437932#155205, JN_NUMEXA_437919#155206, JN_NUMFUS_437922#155207, JN_NUMIMA_437935#155208, JN_NUMJOU_437910#155209, JN_NUMRB_437936#155210, JN_NUMSER_437934#155211, JN_NUMSTU_437933#155212, JN_OSUSER_437928#155213, JN_PRG_CODE_437926#155214, JN_TABLE_437913#155215, JN_TERMINAL_437927#155216, JN_TYPJOU_437912#155217, JN_XMLDATA_437925#155218]

(5) SortAggregate
Input [1]: [COL_8D5A1E74_3717_468E_BFC4_C915C657FBC3#155361]
Keys: []
Functions [4]: [partial_count(1), partial_count(COL_8D5A1E74_3717_468E_BFC4_C915C657FBC3#155361), partial_min(COL_8D5A1E74_3717_468E_BFC4_C915C657FBC3#155361), partial_max(COL_8D5A1E74_3717_468E_BFC4_C915C657FBC3#155361)]
Aggregate Attributes [4]: [count#155463L, count#155464L, min#155465, max#155466]
Results [4]: [count#155467L, count#155468L, min#155469, max#155470]

(6) Exchange
Input [4]: [count#155467L, count#155468L, min#155469, max#155470]
Arguments: SinglePartition, ENSURE_REQUIREMENTS, [plan_id=14516]

(7) ShuffleQueryStage
Output [4]: [count#155467L, count#155468L, min#155469, max#155470]
Arguments: 0

(8) SortAggregate
Input [4]: [count#155467L, count#155468L, min#155469, max#155470]
Keys: []
Functions [4]: [count(1), count(COL_8D5A1E74_3717_468E_BFC4_C915C657FBC3#155361), min(COL_8D5A1E74_3717_468E_BFC4_C915C657FBC3#155361), max(COL_8D5A1E74_3717_468E_BFC4_C915C657FBC3#155361)]
Aggregate Attributes [4]: [count(1)#155415L, count(COL_8D5A1E74_3717_468E_BFC4_C915C657FBC3#155361)#155418L, min(COL_8D5A1E74_3717_468E_BFC4_C915C657FBC3#155361)#155421, max(COL_8D5A1E74_3717_468E_BFC4_C915C657FBC3#155361)#155423]
Results [4]: [count(1)#155415L AS COL_8D5A1E74_3717_468E_BFC4_C915C657FBC31#155417L, count(COL_8D5A1E74_3717_468E_BFC4_C915C657FBC3#155361)#155418L AS COL_8D5A1E74_3717_468E_BFC4_C915C657FBC32#155420L, min(COL_8D5A1E74_3717_468E_BFC4_C915C657FBC3#155361)#155421 AS COL_8D5A1E74_3717_468E_BFC4_C915C657FBC34#155422, max(COL_8D5A1E74_3717_468E_BFC4_C915C657FBC3#155361)#155423 AS COL_8D5A1E74_3717_468E_BFC4_C915C657FBC35#155424]

(9) Filter
Input [28]: [JN_ACTION_437911#155191, JN_CODPER_437916#155192, JN_CODSIT_437924#155193, JN_COMMENT_437923#155194, JN_DATENV_437931#155195, JN_DATJOU_437914#155196, JN_DURSEC_437937#155197, JN_FLENV_437930#155198, JN_HEUJOU_437915#155199, JN_IP_ADDRESS_437929#155200, JN_NUMCR_437921#155201, JN_NUMDEM_437918#155202, JN_NUMDOS_437917#155203, JN_NUMDRV_437920#155204, JN_NUMENT_437932#155205, JN_NUMEXA_437919#155206, JN_NUMFUS_437922#155207, JN_NUMIMA_437935#155208, JN_NUMJOU_437910#155209, JN_NUMRB_437936#155210, JN_NUMSER_437934#155211, JN_NUMSTU_437933#155212, JN_OSUSER_437928#155213, JN_PRG_CODE_437926#155214, JN_TABLE_437913#155215, JN_TERMINAL_437927#155216, JN_TYPJOU_437912#155217, JN_XMLDATA_437925#155218]
Condition : (((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(JN_NUMJOU_437910#155209)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(JN_NUMJOU_437910#155209)), MARX) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(JN_ACTION_437911#155191)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(JN_ACTION_437911#155191)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(JN_TYPJOU_437912#155217)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(JN_TYPJOU_437912#155217)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(JN_TABLE_437913#155215)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(JN_TABLE_437913#155215)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(JN_DATJOU_437914#155196)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(JN_DATJOU_437914#155196)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(JN_HEUJOU_437915#155199)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(JN_HEUJOU_437915#155199)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(JN_CODPER_437916#155192)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(JN_CODPER_437916#155192)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(JN_NUMDOS_437917#155203)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(JN_NUMDOS_437917#155203)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(JN_NUMDEM_437918#155202)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(JN_NUMDEM_437918#155202)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(JN_NUMEXA_437919#155206)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(JN_NUMEXA_437919#155206)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(JN_NUMDRV_437920#155204)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(JN_NUMDRV_437920#155204)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(JN_NUMCR_437921#155201)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(JN_NUMCR_437921#155201)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(JN_NUMFUS_437922#155207)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(JN_NUMFUS_437922#155207)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(JN_COMMENT_437923#155194)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(JN_COMMENT_437923#155194)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(JN_CODSIT_437924#155193)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(JN_CODSIT_437924#155193)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(JN_XMLDATA_437925#155218)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(JN_XMLDATA_437925#155218)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(JN_PRG_CODE_437926#155214)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(JN_PRG_CODE_437926#155214)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(JN_TERMINAL_437927#155216)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(JN_TERMINAL_437927#155216)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(JN_OSUSER_437928#155213)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(JN_OSUSER_437928#155213)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(JN_IP_ADDRESS_437929#155200)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(JN_IP_ADDRESS_437929#155200)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(JN_FLENV_437930#155198)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(JN_FLENV_437930#155198)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(JN_DATENV_437931#155195)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(JN_DATENV_437931#155195)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(JN_NUMENT_437932#155205)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(JN_NUMENT_437932#155205)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(JN_NUMSTU_437933#155212)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(JN_NUMSTU_437933#155212)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(JN_NUMSER_437934#155211)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(JN_NUMSER_437934#155211)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(JN_NUMIMA_437935#155208)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(JN_NUMIMA_437935#155208)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(JN_NUMRB_437936#155210)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(JN_NUMRB_437936#155210)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(JN_DURSEC_437937#155197)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(JN_DURSEC_437937#155197)), MARX) END)

(10) Project
Output [1]: [JN_TYPJOU_437912#155217 AS COL_8D5A1E74_3717_468E_BFC4_C915C657FBC3#155361]
Input [28]: [JN_ACTION_437911#155191, JN_CODPER_437916#155192, JN_CODSIT_437924#155193, JN_COMMENT_437923#155194, JN_DATENV_437931#155195, JN_DATJOU_437914#155196, JN_DURSEC_437937#155197, JN_FLENV_437930#155198, JN_HEUJOU_437915#155199, JN_IP_ADDRESS_437929#155200, JN_NUMCR_437921#155201, JN_NUMDEM_437918#155202, JN_NUMDOS_437917#155203, JN_NUMDRV_437920#155204, JN_NUMENT_437932#155205, JN_NUMEXA_437919#155206, JN_NUMFUS_437922#155207, JN_NUMIMA_437935#155208, JN_NUMJOU_437910#155209, JN_NUMRB_437936#155210, JN_NUMSER_437934#155211, JN_NUMSTU_437933#155212, JN_OSUSER_437928#155213, JN_PRG_CODE_437926#155214, JN_TABLE_437913#155215, JN_TERMINAL_437927#155216, JN_TYPJOU_437912#155217, JN_XMLDATA_437925#155218]

(11) SortAggregate
Input [1]: [COL_8D5A1E74_3717_468E_BFC4_C915C657FBC3#155361]
Keys: []
Functions [4]: [partial_count(1), partial_count(COL_8D5A1E74_3717_468E_BFC4_C915C657FBC3#155361), partial_min(COL_8D5A1E74_3717_468E_BFC4_C915C657FBC3#155361), partial_max(COL_8D5A1E74_3717_468E_BFC4_C915C657FBC3#155361)]
Aggregate Attributes [4]: [count#155463L, count#155464L, min#155465, max#155466]
Results [4]: [count#155467L, count#155468L, min#155469, max#155470]

(12) Exchange
Input [4]: [count#155467L, count#155468L, min#155469, max#155470]
Arguments: SinglePartition, ENSURE_REQUIREMENTS, [plan_id=14495]

(13) SortAggregate
Input [4]: [count#155467L, count#155468L, min#155469, max#155470]
Keys: []
Functions [4]: [count(1), count(COL_8D5A1E74_3717_468E_BFC4_C915C657FBC3#155361), min(COL_8D5A1E74_3717_468E_BFC4_C915C657FBC3#155361), max(COL_8D5A1E74_3717_468E_BFC4_C915C657FBC3#155361)]
Aggregate Attributes [4]: [count(1)#155415L, count(COL_8D5A1E74_3717_468E_BFC4_C915C657FBC3#155361)#155418L, min(COL_8D5A1E74_3717_468E_BFC4_C915C657FBC3#155361)#155421, max(COL_8D5A1E74_3717_468E_BFC4_C915C657FBC3#155361)#155423]
Results [4]: [count(1)#155415L AS COL_8D5A1E74_3717_468E_BFC4_C915C657FBC31#155417L, count(COL_8D5A1E74_3717_468E_BFC4_C915C657FBC3#155361)#155418L AS COL_8D5A1E74_3717_468E_BFC4_C915C657FBC32#155420L, min(COL_8D5A1E74_3717_468E_BFC4_C915C657FBC3#155361)#155421 AS COL_8D5A1E74_3717_468E_BFC4_C915C657FBC34#155422, max(COL_8D5A1E74_3717_468E_BFC4_C915C657FBC3#155361)#155423 AS COL_8D5A1E74_3717_468E_BFC4_C915C657FBC35#155424]

(14) AdaptiveSparkPlan
Output [4]: [COL_8D5A1E74_3717_468E_BFC4_C915C657FBC31#155417L, COL_8D5A1E74_3717_468E_BFC4_C915C657FBC32#155420L, COL_8D5A1E74_3717_468E_BFC4_C915C657FBC34#155422, COL_8D5A1E74_3717_468E_BFC4_C915C657FBC35#155424]
Arguments: isFinalPlan=true

SQL / DataFrame Properties

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