digraph G {
0 [labelType="html" label="<br><b>CollectLimit</b><br><br>"];
subgraph cluster1 {
isCluster="true";
label="WholeStageCodegen (1)\n \nduration: 0 ms";
2 [labelType="html" label="<br><b>Project</b><br><br>"];
3 [labelType="html" label="<br><b>Project</b><br><br>"];
4 [labelType="html" label="<br><b>Project</b><br><br>"];
5 [labelType="html" label="<b>Filter</b><br><br>number of output rows: 1,500"];
}
6 [labelType="html" label="<b>Scan csv </b><br><br>number of output rows: 1,500<br>number of files read: 1<br>metadata time: 0 ms<br>size of files read: 1603.1 KiB"];
2->0;
3->2;
4->3;
5->4;
6->5;
}
7
CollectLimit 1500
Project [COL_C1C98BAA_7EA9_4CB2_A686_925823C16099#4804, str_encrypt(str_capitalize(COL_7371B675_E6D8_4025_A620_3FAE015EE3EB#4812)) AS COL_2E5E2192_4F08_4241_B74C_79A40C8626E3#4825, COL_547435B8_8DB2_4569_9A58_AE47AD2B7277#4806, COL_7371B675_E6D8_4025_A620_3FAE015EE3EB#4812]
Project [COL_C1C98BAA_7EA9_4CB2_A686_925823C16099#4804, COL_547435B8_8DB2_4569_9A58_AE47AD2B7277#4806, str_concat(array(COL_D7E91983_8399_4147_80AF_C5C78124A716#4807, str_concat(array(COL_23101222_7759_4184_A265_5C564F57646D#4805, COL_547435B8_8DB2_4569_9A58_AE47AD2B7277#4806)))) AS COL_7371B675_E6D8_4025_A620_3FAE015EE3EB#4812]
Project [n_dossier#4653 AS COL_C1C98BAA_7EA9_4CB2_A686_925823C16099#4804, prenom_patient#4657 AS COL_23101222_7759_4184_A265_5C564F57646D#4805, cast(date_naissance#4658 as string) AS COL_547435B8_8DB2_4569_9A58_AE47AD2B7277#4806, str_if_with_rule(isnull(nom_naissance#4656), nom_patient#4655, nom_naissance#4656) AS COL_D7E91983_8399_4147_80AF_C5C78124A716#4807]
Filter isnotnull(n_dossier#4653)
WholeStageCodegen (1)
FileScan csv [n_dossier#4653,nom_patient#4655,nom_naissance#4656,prenom_patient#4657,date_naissance#4658] Batched: false, DataFilters: [isnotnull(n_dossier#4653)], Format: CSV, Location: InMemoryFileIndex(1 paths)[file:/data/input/depot/csv/execution/491DA9B8_20E8_4F00_AC1C_AA2422665..., PartitionFilters: [], PushedFilters: [IsNotNull(n_dossier)], ReadSchema: struct<n_dossier:string,nom_patient:string,nom_naissance:string,prenom_patient:string,date_naissa...
== Physical Plan ==
CollectLimit (6)
+- * Project (5)
+- * Project (4)
+- * Project (3)
+- * Filter (2)
+- Scan csv (1)
(1) Scan csv
Output [5]: [n_dossier#4653, nom_patient#4655, nom_naissance#4656, prenom_patient#4657, date_naissance#4658]
Batched: false
Location: InMemoryFileIndex [file:/data/input/depot/csv/execution/491DA9B8_20E8_4F00_AC1C_AA24226656D0/current/sample3.csv]
PushedFilters: [IsNotNull(n_dossier)]
ReadSchema: struct<n_dossier:string,nom_patient:string,nom_naissance:string,prenom_patient:string,date_naissance:int>
(2) Filter [codegen id : 1]
Input [5]: [n_dossier#4653, nom_patient#4655, nom_naissance#4656, prenom_patient#4657, date_naissance#4658]
Condition : isnotnull(n_dossier#4653)
(3) Project [codegen id : 1]
Output [4]: [n_dossier#4653 AS COL_C1C98BAA_7EA9_4CB2_A686_925823C16099#4804, prenom_patient#4657 AS COL_23101222_7759_4184_A265_5C564F57646D#4805, cast(date_naissance#4658 as string) AS COL_547435B8_8DB2_4569_9A58_AE47AD2B7277#4806, str_if_with_rule(isnull(nom_naissance#4656), nom_patient#4655, nom_naissance#4656) AS COL_D7E91983_8399_4147_80AF_C5C78124A716#4807]
Input [5]: [n_dossier#4653, nom_patient#4655, nom_naissance#4656, prenom_patient#4657, date_naissance#4658]
(4) Project [codegen id : 1]
Output [3]: [COL_C1C98BAA_7EA9_4CB2_A686_925823C16099#4804, COL_547435B8_8DB2_4569_9A58_AE47AD2B7277#4806, str_concat(array(COL_D7E91983_8399_4147_80AF_C5C78124A716#4807, str_concat(array(COL_23101222_7759_4184_A265_5C564F57646D#4805, COL_547435B8_8DB2_4569_9A58_AE47AD2B7277#4806)))) AS COL_7371B675_E6D8_4025_A620_3FAE015EE3EB#4812]
Input [4]: [COL_C1C98BAA_7EA9_4CB2_A686_925823C16099#4804, COL_23101222_7759_4184_A265_5C564F57646D#4805, COL_547435B8_8DB2_4569_9A58_AE47AD2B7277#4806, COL_D7E91983_8399_4147_80AF_C5C78124A716#4807]
(5) Project [codegen id : 1]
Output [4]: [COL_C1C98BAA_7EA9_4CB2_A686_925823C16099#4804, str_encrypt(str_capitalize(COL_7371B675_E6D8_4025_A620_3FAE015EE3EB#4812)) AS COL_2E5E2192_4F08_4241_B74C_79A40C8626E3#4825, COL_547435B8_8DB2_4569_9A58_AE47AD2B7277#4806, COL_7371B675_E6D8_4025_A620_3FAE015EE3EB#4812]
Input [3]: [COL_C1C98BAA_7EA9_4CB2_A686_925823C16099#4804, COL_547435B8_8DB2_4569_9A58_AE47AD2B7277#4806, COL_7371B675_E6D8_4025_A620_3FAE015EE3EB#4812]
(6) CollectLimit
Input [4]: [COL_C1C98BAA_7EA9_4CB2_A686_925823C16099#4804, COL_2E5E2192_4F08_4241_B74C_79A40C8626E3#4825, COL_547435B8_8DB2_4569_9A58_AE47AD2B7277#4806, COL_7371B675_E6D8_4025_A620_3FAE015EE3EB#4812]
Arguments: 1500