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 \"IPP\", \"Code \u00E9tablissement\", \"Lib \u00E9tablissement\", \"Date pr\u00E9l\u00E9vement\", \"Code examen Biologie\", \"Libell\u00E9 examen Biologie\", \"R\u00E9sultat (num\u00E9rique)\", \"Unite\", \"Code m\u00E9decin\", \"Nom m\u00E9decin\", \"Pr\u00E9nom m\u00E9decin\", \"Nom document biologie\", \"Nom complet document biologie\", \"Venue\", \"Borne basse\", \"Borne haute\" FROM \"public\".\"biologie_etb_lin\") as x) [numPartitions=1] </b><br><br>number of output rows: 1,500"];
}
2->0;
3->2;
}
4
CollectLimit 1500
Project [IPP#271328 AS COL_IPP_19873#271620, Code établissement#271329 AS COL_CODE_ETABLISSEM_19874#271621, Lib établissement#271330 AS COL_LIB_ETABLISSEME_19875#271622, Date prélévement#271331 AS COL_DATE_PRELEVEMEN_19876#271623, Code examen Biologie#271332 AS COL_CODE_EXAMEN_BIO_19877#271624, Libellé examen Biologie#271333 AS COL_LIBELLE_EXAMEN__19878#271625, Résultat (numérique)#271334 AS COL_RESULTAT_NUMERI_19879#271626, Unite#271335 AS COL_UNITE_19880#271627, Code médecin#271336 AS COL_CODE_MEDECIN_19881#271628, Nom médecin#271337 AS COL_NOM_MEDECIN_19882#271629, Prénom médecin#271338 AS COL_PRENOM_MEDECIN_19883#271630, Nom document biologie#271339 AS COL_NOM_DOCUMENT_BI_19884#271631, Nom complet document biologie#271340 AS COL_NOM_COMPLET_DOC_19885#271632, Venue#271341 AS COL_VENUE_19886#271633, Borne basse#271342 AS COL_BORNE_BASSE_19887#271634, Borne haute#271343 AS COL_BORNE_HAUTE_19888#271635, str_create(Etb Linet) AS COL_ORIGINE_19890#271636, str_extract_by_str(Code examen Biologie#271332, _, RIGHT) AS COL_T1_20254#271637]
Scan JDBCRelation((SELECT "IPP", "Code établissement", "Lib établissement", "Date prélévement", "Code examen Biologie", "Libellé examen Biologie", "Résultat (numérique)", "Unite", "Code médecin", "Nom médecin", "Prénom médecin", "Nom document biologie", "Nom complet document biologie", "Venue", "Borne basse", "Borne haute" FROM "public"."biologie_etb_lin") as x) [numPartitions=1] [IPP#271328,Code établissement#271329,Lib établissement#271330,Date prélévement#271331,Code examen Biologie#271332,Libellé examen Biologie#271333,Résultat (numérique)#271334,Unite#271335,Code médecin#271336,Nom médecin#271337,Prénom médecin#271338,Nom document biologie#271339,Nom complet document biologie#271340,Venue#271341,Borne basse#271342,Borne haute#271343] PushedFilters: [], ReadSchema: struct<IPP:string,Code établissement:string,Lib établissement:string,Date prélévement:timestamp,C...
WholeStageCodegen (1)
== Physical Plan ==
CollectLimit (3)
+- * Project (2)
+- * Scan JDBCRelation((SELECT "IPP", "Code établissement", "Lib établissement", "Date prélévement", "Code examen Biologie", "Libellé examen Biologie", "Résultat (numérique)", "Unite", "Code médecin", "Nom médecin", "Prénom médecin", "Nom document biologie", "Nom complet document biologie", "Venue", "Borne basse", "Borne haute" FROM "public"."biologie_etb_lin") as x) [numPartitions=1] (1)
(1) Scan JDBCRelation((SELECT "IPP", "Code établissement", "Lib établissement", "Date prélévement", "Code examen Biologie", "Libellé examen Biologie", "Résultat (numérique)", "Unite", "Code médecin", "Nom médecin", "Prénom médecin", "Nom document biologie", "Nom complet document biologie", "Venue", "Borne basse", "Borne haute" FROM "public"."biologie_etb_lin") as x) [numPartitions=1] [codegen id : 1]
Output [16]: [IPP#271328, Code établissement#271329, Lib établissement#271330, Date prélévement#271331, Code examen Biologie#271332, Libellé examen Biologie#271333, Résultat (numérique)#271334, Unite#271335, Code médecin#271336, Nom médecin#271337, Prénom médecin#271338, Nom document biologie#271339, Nom complet document biologie#271340, Venue#271341, Borne basse#271342, Borne haute#271343]
ReadSchema: struct<IPP:string,Code établissement:string,Lib établissement:string,Date prélévement:timestamp,Code examen Biologie:string,Libellé examen Biologie:string,Résultat (numérique):double,Unite:string,Code médecin:string,Nom médecin:string,Prénom médecin:string,Nom document biologie:string,Nom complet document biologie:string,Venue:string,Borne basse:double,Borne haute:double>
(2) Project [codegen id : 1]
Output [18]: [IPP#271328 AS COL_IPP_19873#271620, Code établissement#271329 AS COL_CODE_ETABLISSEM_19874#271621, Lib établissement#271330 AS COL_LIB_ETABLISSEME_19875#271622, Date prélévement#271331 AS COL_DATE_PRELEVEMEN_19876#271623, Code examen Biologie#271332 AS COL_CODE_EXAMEN_BIO_19877#271624, Libellé examen Biologie#271333 AS COL_LIBELLE_EXAMEN__19878#271625, Résultat (numérique)#271334 AS COL_RESULTAT_NUMERI_19879#271626, Unite#271335 AS COL_UNITE_19880#271627, Code médecin#271336 AS COL_CODE_MEDECIN_19881#271628, Nom médecin#271337 AS COL_NOM_MEDECIN_19882#271629, Prénom médecin#271338 AS COL_PRENOM_MEDECIN_19883#271630, Nom document biologie#271339 AS COL_NOM_DOCUMENT_BI_19884#271631, Nom complet document biologie#271340 AS COL_NOM_COMPLET_DOC_19885#271632, Venue#271341 AS COL_VENUE_19886#271633, Borne basse#271342 AS COL_BORNE_BASSE_19887#271634, Borne haute#271343 AS COL_BORNE_HAUTE_19888#271635, str_create(Etb Linet) AS COL_ORIGINE_19890#271636, str_extract_by_str(Code examen Biologie#271332, _, RIGHT) AS COL_T1_20254#271637]
Input [16]: [IPP#271328, Code établissement#271329, Lib établissement#271330, Date prélévement#271331, Code examen Biologie#271332, Libellé examen Biologie#271333, Résultat (numérique)#271334, Unite#271335, Code médecin#271336, Nom médecin#271337, Prénom médecin#271338, Nom document biologie#271339, Nom complet document biologie#271340, Venue#271341, Borne basse#271342, Borne haute#271343]
(3) CollectLimit
Input [18]: [COL_IPP_19873#271620, COL_CODE_ETABLISSEM_19874#271621, COL_LIB_ETABLISSEME_19875#271622, COL_DATE_PRELEVEMEN_19876#271623, COL_CODE_EXAMEN_BIO_19877#271624, COL_LIBELLE_EXAMEN__19878#271625, COL_RESULTAT_NUMERI_19879#271626, COL_UNITE_19880#271627, COL_CODE_MEDECIN_19881#271628, COL_NOM_MEDECIN_19882#271629, COL_PRENOM_MEDECIN_19883#271630, COL_NOM_DOCUMENT_BI_19884#271631, COL_NOM_COMPLET_DOC_19885#271632, COL_VENUE_19886#271633, COL_BORNE_BASSE_19887#271634, COL_BORNE_HAUTE_19888#271635, COL_ORIGINE_19890#271636, COL_T1_20254#271637]
Arguments: 1500