digraph G {
0 [labelType="html" label="<br><b>CollectLimit</b><br><br>"];
subgraph cluster1 {
isCluster="true";
label="WholeStageCodegen (1)\n \nduration: total (min, med, max (stageId: taskId))\n148 ms (8 ms, 16 ms, 27 ms (stage 12701.0: task 13460))";
2 [labelType="html" label="<br><b>Project</b><br><br>"];
3 [labelType="html" label="<b>Filter</b><br><br>number of output rows: 1"];
4 [labelType="html" label="<b>ColumnarToRow</b><br><br>number of output rows: 23,308<br>number of input batches: 6"];
}
5 [labelType="html" label="<b>Scan parquet </b><br><br>number of files read: 10<br>scan time total (min, med, max (stageId: taskId))<br>145 ms (8 ms, 16 ms, 27 ms (stage 12701.0: task 13460))<br>metadata time: 0 ms<br>size of files read: 102.6 MiB<br>number of output rows: 23,308"];
2->0;
3->2;
4->3;
5->4;
}
6
CollectLimit 500000
Project [str_concat(array(str_join(array(Statut : , COL_FC10C112_88B1_45B9_AA4E_B279540F2D09#1105340, , FIDES : , COL_7283FB96_45C4_411A_901D_417BCF15E684#1105341, , Facturable AM :, COL_D0D2A969_5962_4BD8_9DAA_FA2A1236DF25#1105342, , Présence Acte Urgence dans RSF : , COL_F05A55CE_AA70_477D_B5B1_B1F39C0FF908#1105345), ), , , , , , , , )) AS COL_B1FDD3BC_4D33_4C93_B639_1C1F2E7B04C3#1105496, COL_F05A55CE_AA70_477D_B5B1_B1F39C0FF908#1105345 AS COL_396B6C1A_0DF9_4E49_99E4_F697B9D4D40F#1105480]
Filter ((COL_AF155DAB_420D_45B6_A9A9_56AA8D2E3D5C#1105337 <=> 011208796) AND (COL_57A29A37_9A17_4B66_8075_897F4B240E81#1105334 <=> A))
ColumnarToRow
WholeStageCodegen (1)
FileScan parquet [COL_57A29A37_9A17_4B66_8075_897F4B240E81#1105334,COL_AF155DAB_420D_45B6_A9A9_56AA8D2E3D5C#1105337,COL_FC10C112_88B1_45B9_AA4E_B279540F2D09#1105340,COL_7283FB96_45C4_411A_901D_417BCF15E684#1105341,COL_D0D2A969_5962_4BD8_9DAA_FA2A1236DF25#1105342,COL_F05A55CE_AA70_477D_B5B1_B1F39C0FF908#1105345] Batched: true, DataFilters: [(COL_AF155DAB_420D_45B6_A9A9_56AA8D2E3D5C#1105337 <=> 011208796), (COL_57A29A37_9A17_4B66_8075_8..., Format: Parquet, Location: InMemoryFileIndex(1 paths)[file:/data/output/cache/parquet/datablock/00_D_DETERMINAT_210515], PartitionFilters: [], PushedFilters: [EqualNullSafe(COL_AF155DAB_420D_45B6_A9A9_56AA8D2E3D5C,011208796), EqualNullSafe(COL_57A29A37_9A..., ReadSchema: struct<COL_57A29A37_9A17_4B66_8075_897F4B240E81:string,COL_AF155DAB_420D_45B6_A9A9_56AA8D2E3D5C:s...
== Physical Plan ==
CollectLimit (5)
+- * Project (4)
+- * Filter (3)
+- * ColumnarToRow (2)
+- Scan parquet (1)
(1) Scan parquet
Output [6]: [COL_57A29A37_9A17_4B66_8075_897F4B240E81#1105334, COL_AF155DAB_420D_45B6_A9A9_56AA8D2E3D5C#1105337, COL_FC10C112_88B1_45B9_AA4E_B279540F2D09#1105340, COL_7283FB96_45C4_411A_901D_417BCF15E684#1105341, COL_D0D2A969_5962_4BD8_9DAA_FA2A1236DF25#1105342, COL_F05A55CE_AA70_477D_B5B1_B1F39C0FF908#1105345]
Batched: true
Location: InMemoryFileIndex [file:/data/output/cache/parquet/datablock/00_D_DETERMINAT_210515]
PushedFilters: [EqualNullSafe(COL_AF155DAB_420D_45B6_A9A9_56AA8D2E3D5C,011208796), EqualNullSafe(COL_57A29A37_9A17_4B66_8075_897F4B240E81,A)]
ReadSchema: struct<COL_57A29A37_9A17_4B66_8075_897F4B240E81:string,COL_AF155DAB_420D_45B6_A9A9_56AA8D2E3D5C:string,COL_FC10C112_88B1_45B9_AA4E_B279540F2D09:string,COL_7283FB96_45C4_411A_901D_417BCF15E684:string,COL_D0D2A969_5962_4BD8_9DAA_FA2A1236DF25:string,COL_F05A55CE_AA70_477D_B5B1_B1F39C0FF908:string>
(2) ColumnarToRow [codegen id : 1]
Input [6]: [COL_57A29A37_9A17_4B66_8075_897F4B240E81#1105334, COL_AF155DAB_420D_45B6_A9A9_56AA8D2E3D5C#1105337, COL_FC10C112_88B1_45B9_AA4E_B279540F2D09#1105340, COL_7283FB96_45C4_411A_901D_417BCF15E684#1105341, COL_D0D2A969_5962_4BD8_9DAA_FA2A1236DF25#1105342, COL_F05A55CE_AA70_477D_B5B1_B1F39C0FF908#1105345]
(3) Filter [codegen id : 1]
Input [6]: [COL_57A29A37_9A17_4B66_8075_897F4B240E81#1105334, COL_AF155DAB_420D_45B6_A9A9_56AA8D2E3D5C#1105337, COL_FC10C112_88B1_45B9_AA4E_B279540F2D09#1105340, COL_7283FB96_45C4_411A_901D_417BCF15E684#1105341, COL_D0D2A969_5962_4BD8_9DAA_FA2A1236DF25#1105342, COL_F05A55CE_AA70_477D_B5B1_B1F39C0FF908#1105345]
Condition : ((COL_AF155DAB_420D_45B6_A9A9_56AA8D2E3D5C#1105337 <=> 011208796) AND (COL_57A29A37_9A17_4B66_8075_897F4B240E81#1105334 <=> A))
(4) Project [codegen id : 1]
Output [2]: [str_concat(array(str_join(array(Statut : , COL_FC10C112_88B1_45B9_AA4E_B279540F2D09#1105340, , FIDES : , COL_7283FB96_45C4_411A_901D_417BCF15E684#1105341, , Facturable AM :, COL_D0D2A969_5962_4BD8_9DAA_FA2A1236DF25#1105342, , Présence Acte Urgence dans RSF : , COL_F05A55CE_AA70_477D_B5B1_B1F39C0FF908#1105345), ), , , , , , , , )) AS COL_B1FDD3BC_4D33_4C93_B639_1C1F2E7B04C3#1105496, COL_F05A55CE_AA70_477D_B5B1_B1F39C0FF908#1105345 AS COL_396B6C1A_0DF9_4E49_99E4_F697B9D4D40F#1105480]
Input [6]: [COL_57A29A37_9A17_4B66_8075_897F4B240E81#1105334, COL_AF155DAB_420D_45B6_A9A9_56AA8D2E3D5C#1105337, COL_FC10C112_88B1_45B9_AA4E_B279540F2D09#1105340, COL_7283FB96_45C4_411A_901D_417BCF15E684#1105341, COL_D0D2A969_5962_4BD8_9DAA_FA2A1236DF25#1105342, COL_F05A55CE_AA70_477D_B5B1_B1F39C0FF908#1105345]
(5) CollectLimit
Input [2]: [COL_B1FDD3BC_4D33_4C93_B639_1C1F2E7B04C3#1105496, COL_396B6C1A_0DF9_4E49_99E4_F697B9D4D40F#1105480]
Arguments: 500000