Show the Stage ID and Task ID that corresponds to the max metric
digraph G {
0 [labelType="html" label="<br><b>CollectLimit</b><br><br>"];
subgraph cluster1 {
isCluster="true";
label="WholeStageCodegen (1)\n \nduration: 61 ms";
2 [labelType="html" label="<br><b>Project</b><br><br>"];
3 [labelType="html" label="<b>Filter</b><br><br>number of output rows: 2"];
4 [labelType="html" label="<b>ColumnarToRow</b><br><br>number of output rows: 2,577<br>number of input batches: 1"];
}
5 [labelType="html" label="<b>Scan parquet </b><br><br>number of files read: 1<br>scan time: 2 ms<br>metadata time: 0 ms<br>size of files read: 57.3 KiB<br>number of output rows: 2,577"];
2->0;
3->2;
4->3;
5->4;
}
6
CollectLimit 1500
Project [str_remove_space(str_remove_extend(Code+CIM+10#1107192, [.]), RIGHT) AS COL_CODE_CIM_10_232850#1107333, Libell%C3%A9+long#1107193 AS COL_LIBELLE_LONG_232851#1107334, Date_effet#1107196 AS COL_DATE_EFFET_232852#1107335, Date_r%C3%A9vocation#1107197 AS COL_DATE_REVOCATION_232853#1107336, Responsable+MAJ#1107194 AS COL_RESPONSABLE_MAJ_232854#1107337, Source#1107195 AS COL_SOURCE_232855#1107338, str_remove_space(str_remove_extend(str_remove_space(str_remove_extend(Code+CIM+10#1107192, [.]), RIGHT), [.]), RIGHT) AS COL_CODE_CIM10_NORM_232856#1107339]
Filter ((((CASE WHEN isnull(Contains(str_remove_accent(upper(str_remove_space(str_remove_extend(Code+CIM+10#1107192, [.]), RIGHT))), R53)) THEN false ELSE Contains(str_remove_accent(upper(str_remove_space(str_remove_extend(Code+CIM+10#1107192, [.]), RIGHT))), R53) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(Libell%C3%A9+long#1107193)), R53)) THEN false ELSE Contains(str_remove_accent(upper(Libell%C3%A9+long#1107193)), R53) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(Responsable+MAJ#1107194)), R53)) THEN false ELSE Contains(str_remove_accent(upper(Responsable+MAJ#1107194)), R53) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(Source#1107195)), R53)) THEN false ELSE Contains(str_remove_accent(upper(Source#1107195)), R53) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_remove_space(str_remove_extend(str_remove_space(str_remove_extend(Code+CIM+10#1107192, [.]), RIGHT), [.]), RIGHT))), R53)) THEN false ELSE Contains(str_remove_accent(upper(str_remove_space(str_remove_extend(str_remove_space(str_remove_extend(Code+CIM+10#1107192, [.]), RIGHT), [.]), RIGHT))), R53) END)