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="<b>Scan JDBCRelation((SELECT \"idt_patient\", \"nom_usage_patient\", \"prenom_patient\", \"nom_naissance\", \"datenais\", \"sexe\" FROM \"etab_source\".\"tb_patient\") as x) [numPartitions=1] </b><br><br>number of output rows: 1,500"];
}
2->0;
3->2;
}
4
CollectLimit 1500
Project [idt_patient#51567 AS COL_CC28EC76_C163_4384_B287_2C28C791971E#51663, nom_usage_patient#51568 AS COL_041AEF9A_5F84_47C8_B97E_E2E95A81D465#51664, prenom_patient#51569 AS COL_5C63F1BA_B1F3_45CD_A5D8_C25FD46508DE#51665, nom_naissance#51570 AS COL_FD92A8D0_A1AC_475D_A2E2_1BB69EC1BD3C#51666, datenais#51571 AS COL_439F75F7_0F86_43B4_8B2E_A3D8B968E3FD#51667, sexe#51572 AS COL_C805393A_A3DE_40D3_8C2A_332D6D56B173#51668, RANKING_RESULTS_CONNECTOR(STOP_IF_TRUE, null, array(RANKING_STRING(sexe#51572, Masculin, equal, [F], [], false, 2, , null), RANKING_STRING(sexe#51572, Féminin, equal, [M], [], false, 1, , null))) AS COL_8798EFAE_9539_42F9_95DD_F3483A40467D#51689]
Scan JDBCRelation((SELECT "idt_patient", "nom_usage_patient", "prenom_patient", "nom_naissance", "datenais", "sexe" FROM "etab_source"."tb_patient") as x) [numPartitions=1] [idt_patient#51567,nom_usage_patient#51568,prenom_patient#51569,nom_naissance#51570,datenais#51571,sexe#51572] PushedFilters: [], ReadSchema: struct<idt_patient:string,nom_usage_patient:string,prenom_patient:string,nom_naissance:string,dat...
WholeStageCodegen (1)
== Physical Plan ==
CollectLimit (3)
+- * Project (2)
+- * Scan JDBCRelation((SELECT "idt_patient", "nom_usage_patient", "prenom_patient", "nom_naissance", "datenais", "sexe" FROM "etab_source"."tb_patient") as x) [numPartitions=1] (1)
(1) Scan JDBCRelation((SELECT "idt_patient", "nom_usage_patient", "prenom_patient", "nom_naissance", "datenais", "sexe" FROM "etab_source"."tb_patient") as x) [numPartitions=1] [codegen id : 1]
Output [6]: [idt_patient#51567, nom_usage_patient#51568, prenom_patient#51569, nom_naissance#51570, datenais#51571, sexe#51572]
ReadSchema: struct<idt_patient:string,nom_usage_patient:string,prenom_patient:string,nom_naissance:string,datenais:string,sexe:string>
(2) Project [codegen id : 1]
Output [7]: [idt_patient#51567 AS COL_CC28EC76_C163_4384_B287_2C28C791971E#51663, nom_usage_patient#51568 AS COL_041AEF9A_5F84_47C8_B97E_E2E95A81D465#51664, prenom_patient#51569 AS COL_5C63F1BA_B1F3_45CD_A5D8_C25FD46508DE#51665, nom_naissance#51570 AS COL_FD92A8D0_A1AC_475D_A2E2_1BB69EC1BD3C#51666, datenais#51571 AS COL_439F75F7_0F86_43B4_8B2E_A3D8B968E3FD#51667, sexe#51572 AS COL_C805393A_A3DE_40D3_8C2A_332D6D56B173#51668, RANKING_RESULTS_CONNECTOR(STOP_IF_TRUE, null, array(RANKING_STRING(sexe#51572, Masculin, equal, [F], [], false, 2, , null), RANKING_STRING(sexe#51572, Féminin, equal, [M], [], false, 1, , null))) AS COL_8798EFAE_9539_42F9_95DD_F3483A40467D#51689]
Input [6]: [idt_patient#51567, nom_usage_patient#51568, prenom_patient#51569, nom_naissance#51570, datenais#51571, sexe#51572]
(3) CollectLimit
Input [7]: [COL_CC28EC76_C163_4384_B287_2C28C791971E#51663, COL_041AEF9A_5F84_47C8_B97E_E2E95A81D465#51664, COL_5C63F1BA_B1F3_45CD_A5D8_C25FD46508DE#51665, COL_FD92A8D0_A1AC_475D_A2E2_1BB69EC1BD3C#51666, COL_439F75F7_0F86_43B4_8B2E_A3D8B968E3FD#51667, COL_C805393A_A3DE_40D3_8C2A_332D6D56B173#51668, COL_8798EFAE_9539_42F9_95DD_F3483A40467D#51689]
Arguments: 1500