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#52837 AS COL_CC28EC76_C163_4384_B287_2C28C791971E#52933, nom_usage_patient#52838 AS COL_041AEF9A_5F84_47C8_B97E_E2E95A81D465#52934, prenom_patient#52839 AS COL_5C63F1BA_B1F3_45CD_A5D8_C25FD46508DE#52935, nom_naissance#52840 AS COL_FD92A8D0_A1AC_475D_A2E2_1BB69EC1BD3C#52936, str_concat(array(str_join(array(str_list_get(str_split(datenais#52841, /), 2), str_list_get(str_split(datenais#52841, /), 1), str_list_get(str_split(datenais#52841, /), 0)), -), , 00.00.00.000)) AS COL_C00ADF76_9FC2_4611_853D_6F23E47D38A3#52998, RANKING_RESULTS_CONNECTOR(STOP_IF_TRUE, null, array(RANKING_STRING(sexe#52842, Masculin, equal, [F], [], false, 2, , null), RANKING_STRING(sexe#52842, Féminin, equal, [M], [], false, 1, , null))) AS COL_8798EFAE_9539_42F9_95DD_F3483A40467D#52999]
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#52837,nom_usage_patient#52838,prenom_patient#52839,nom_naissance#52840,datenais#52841,sexe#52842] 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#52837, nom_usage_patient#52838, prenom_patient#52839, nom_naissance#52840, datenais#52841, sexe#52842]
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 [6]: [idt_patient#52837 AS COL_CC28EC76_C163_4384_B287_2C28C791971E#52933, nom_usage_patient#52838 AS COL_041AEF9A_5F84_47C8_B97E_E2E95A81D465#52934, prenom_patient#52839 AS COL_5C63F1BA_B1F3_45CD_A5D8_C25FD46508DE#52935, nom_naissance#52840 AS COL_FD92A8D0_A1AC_475D_A2E2_1BB69EC1BD3C#52936, str_concat(array(str_join(array(str_list_get(str_split(datenais#52841, /), 2), str_list_get(str_split(datenais#52841, /), 1), str_list_get(str_split(datenais#52841, /), 0)), -), , 00.00.00.000)) AS COL_C00ADF76_9FC2_4611_853D_6F23E47D38A3#52998, RANKING_RESULTS_CONNECTOR(STOP_IF_TRUE, null, array(RANKING_STRING(sexe#52842, Masculin, equal, [F], [], false, 2, , null), RANKING_STRING(sexe#52842, Féminin, equal, [M], [], false, 1, , null))) AS COL_8798EFAE_9539_42F9_95DD_F3483A40467D#52999]
Input [6]: [idt_patient#52837, nom_usage_patient#52838, prenom_patient#52839, nom_naissance#52840, datenais#52841, sexe#52842]
(3) CollectLimit
Input [6]: [COL_CC28EC76_C163_4384_B287_2C28C791971E#52933, COL_041AEF9A_5F84_47C8_B97E_E2E95A81D465#52934, COL_5C63F1BA_B1F3_45CD_A5D8_C25FD46508DE#52935, COL_FD92A8D0_A1AC_475D_A2E2_1BB69EC1BD3C#52936, COL_C00ADF76_9FC2_4611_853D_6F23E47D38A3#52998, COL_8798EFAE_9539_42F9_95DD_F3483A40467D#52999]
Arguments: 1500