digraph G {
0 [labelType="html" label="<br><b>CollectLimit</b><br><br>"];
1 [labelType="html" label="<br><b>Union</b><br><br>"];
subgraph cluster2 {
isCluster="true";
label="WholeStageCodegen (1)\n \nduration: 0 ms";
3 [labelType="html" label="<br><b>LocalLimit</b><br><br>"];
4 [labelType="html" label="<br><b>Project</b><br><br>"];
}
5 [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: 104.1 MiB"];
subgraph cluster6 {
isCluster="true";
label="WholeStageCodegen (2)\n \nduration: 0 ms";
7 [labelType="html" label="<br><b>LocalLimit</b><br><br>"];
8 [labelType="html" label="<br><b>Project</b><br><br>"];
9 [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: 0"];
}
1->0;
3->1;
4->3;
5->4;
7->1;
8->7;
9->8;
}
10
CollectLimit 1500
Union
LocalLimit 1500
Project [IPP#273324 AS COL_IPP_19873#273781, Code établissement#273325 AS COL_CODE_ETABLISSEM_19874#273782, Lib établissement#273326 AS COL_LIB_ETABLISSEME_19875#273783, Date prélévement#273327 AS COL_DATE_PRELEVEMEN_19876#273784, Code examen Biologie#273328 AS COL_CODE_EXAMEN_BIO_19877#273785, Libellé examen Biologie#273329 AS COL_LIBELLE_EXAMEN__19878#273786, cast(REFORMAT_FOR_DOUBLE(Résultat (numérique)#273330) as double) AS COL_RESULTAT_NUMERI_19879#273787, Unite#273331 AS COL_UNITE_19880#273788, Code médecin#273332 AS COL_CODE_MEDECIN_19881#273789, Nom médecin#273333 AS COL_NOM_MEDECIN_19882#273790, Prénom médecin#273334 AS COL_PRENOM_MEDECIN_19883#273791, Nom document biologie#273335 AS COL_NOM_DOCUMENT_BI_19884#273792, Nom complet document biologie#273336 AS COL_NOM_COMPLET_DOC_19885#273793, Venue#273337 AS COL_VENUE_19886#273794, cast(REFORMAT_FOR_DOUBLE(Borne basse#273338) as double) AS COL_BORNE_BASSE_19887#273795, cast(REFORMAT_FOR_DOUBLE(Borne haute#273339) as double) AS COL_BORNE_HAUTE_19888#273796, str_create(CH St Agnès) AS COL_ORIGINE_19890#273797, str_extract_by_str(Code examen Biologie#273328, _, RIGHT) AS COL_T1_20254#273798]
WholeStageCodegen (1)
FileScan csv [IPP#273324,Code établissement#273325,Lib établissement#273326,Date prélévement#273327,Code examen Biologie#273328,Libellé examen Biologie#273329,Résultat (numérique)#273330,Unite#273331,Code médecin#273332,Nom médecin#273333,Prénom médecin#273334,Nom document biologie#273335,Nom complet document biologie#273336,Venue#273337,Borne basse#273338,Borne haute#273339] Batched: false, DataFilters: [], Format: CSV, Location: InMemoryFileIndex(1 paths)[file:/data/input/depot/csv/tmp/BIOLOGIE_SAINT__19889/BIOLOGIE_Etab_STA..., PartitionFilters: [], PushedFilters: [], ReadSchema: struct<IPP:string,Code établissement:string,Lib établissement:string,Date prélévement:timestamp,C...
LocalLimit 1500
Project [IPP#273472 AS COL_IPP_19873#273818, Code établissement#273473 AS COL_CODE_ETABLISSEM_19874#273819, Lib établissement#273474 AS COL_LIB_ETABLISSEME_19875#273820, Date prélévement#273475 AS COL_DATE_PRELEVEMEN_19876#273821, Code examen Biologie#273476 AS COL_CODE_EXAMEN_BIO_19877#273822, Libellé examen Biologie#273477 AS COL_LIBELLE_EXAMEN__19878#273823, Résultat (numérique)#273478 AS COL_RESULTAT_NUMERI_19879#273824, Unite#273479 AS COL_UNITE_19880#273825, Code médecin#273480 AS COL_CODE_MEDECIN_19881#273826, Nom médecin#273481 AS COL_NOM_MEDECIN_19882#273827, Prénom médecin#273482 AS COL_PRENOM_MEDECIN_19883#273828, Nom document biologie#273483 AS COL_NOM_DOCUMENT_BI_19884#273829, Nom complet document biologie#273484 AS COL_NOM_COMPLET_DOC_19885#273830, Venue#273485 AS COL_VENUE_19886#273831, Borne basse#273486 AS COL_BORNE_BASSE_19887#273832, Borne haute#273487 AS COL_BORNE_HAUTE_19888#273833, str_create(Etb Linet) AS COL_ORIGINE_19890#273834, str_extract_by_str(Code examen Biologie#273476, _, RIGHT) AS COL_T1_20254#273835]
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#273472,Code établissement#273473,Lib établissement#273474,Date prélévement#273475,Code examen Biologie#273476,Libellé examen Biologie#273477,Résultat (numérique)#273478,Unite#273479,Code médecin#273480,Nom médecin#273481,Prénom médecin#273482,Nom document biologie#273483,Nom complet document biologie#273484,Venue#273485,Borne basse#273486,Borne haute#273487] PushedFilters: [], ReadSchema: struct<IPP:string,Code établissement:string,Lib établissement:string,Date prélévement:timestamp,C...
WholeStageCodegen (2)
== Physical Plan ==
CollectLimit (8)
+- Union (7)
:- * LocalLimit (3)
: +- * Project (2)
: +- Scan csv (1)
+- * LocalLimit (6)
+- * Project (5)
+- * 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] (4)
(1) Scan csv
Output [16]: [IPP#273324, Code établissement#273325, Lib établissement#273326, Date prélévement#273327, Code examen Biologie#273328, Libellé examen Biologie#273329, Résultat (numérique)#273330, Unite#273331, Code médecin#273332, Nom médecin#273333, Prénom médecin#273334, Nom document biologie#273335, Nom complet document biologie#273336, Venue#273337, Borne basse#273338, Borne haute#273339]
Batched: false
Location: InMemoryFileIndex [file:/data/input/depot/csv/tmp/BIOLOGIE_SAINT__19889/BIOLOGIE_Etab_STA.csv]
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):string,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:string,Borne haute:string>
(2) Project [codegen id : 1]
Output [18]: [IPP#273324 AS COL_IPP_19873#273781, Code établissement#273325 AS COL_CODE_ETABLISSEM_19874#273782, Lib établissement#273326 AS COL_LIB_ETABLISSEME_19875#273783, Date prélévement#273327 AS COL_DATE_PRELEVEMEN_19876#273784, Code examen Biologie#273328 AS COL_CODE_EXAMEN_BIO_19877#273785, Libellé examen Biologie#273329 AS COL_LIBELLE_EXAMEN__19878#273786, cast(REFORMAT_FOR_DOUBLE(Résultat (numérique)#273330) as double) AS COL_RESULTAT_NUMERI_19879#273787, Unite#273331 AS COL_UNITE_19880#273788, Code médecin#273332 AS COL_CODE_MEDECIN_19881#273789, Nom médecin#273333 AS COL_NOM_MEDECIN_19882#273790, Prénom médecin#273334 AS COL_PRENOM_MEDECIN_19883#273791, Nom document biologie#273335 AS COL_NOM_DOCUMENT_BI_19884#273792, Nom complet document biologie#273336 AS COL_NOM_COMPLET_DOC_19885#273793, Venue#273337 AS COL_VENUE_19886#273794, cast(REFORMAT_FOR_DOUBLE(Borne basse#273338) as double) AS COL_BORNE_BASSE_19887#273795, cast(REFORMAT_FOR_DOUBLE(Borne haute#273339) as double) AS COL_BORNE_HAUTE_19888#273796, str_create(CH St Agnès) AS COL_ORIGINE_19890#273797, str_extract_by_str(Code examen Biologie#273328, _, RIGHT) AS COL_T1_20254#273798]
Input [16]: [IPP#273324, Code établissement#273325, Lib établissement#273326, Date prélévement#273327, Code examen Biologie#273328, Libellé examen Biologie#273329, Résultat (numérique)#273330, Unite#273331, Code médecin#273332, Nom médecin#273333, Prénom médecin#273334, Nom document biologie#273335, Nom complet document biologie#273336, Venue#273337, Borne basse#273338, Borne haute#273339]
(3) LocalLimit [codegen id : 1]
Input [18]: [COL_IPP_19873#273781, COL_CODE_ETABLISSEM_19874#273782, COL_LIB_ETABLISSEME_19875#273783, COL_DATE_PRELEVEMEN_19876#273784, COL_CODE_EXAMEN_BIO_19877#273785, COL_LIBELLE_EXAMEN__19878#273786, COL_RESULTAT_NUMERI_19879#273787, COL_UNITE_19880#273788, COL_CODE_MEDECIN_19881#273789, COL_NOM_MEDECIN_19882#273790, COL_PRENOM_MEDECIN_19883#273791, COL_NOM_DOCUMENT_BI_19884#273792, COL_NOM_COMPLET_DOC_19885#273793, COL_VENUE_19886#273794, COL_BORNE_BASSE_19887#273795, COL_BORNE_HAUTE_19888#273796, COL_ORIGINE_19890#273797, COL_T1_20254#273798]
Arguments: 1500
(4) 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 : 2]
Output [16]: [IPP#273472, Code établissement#273473, Lib établissement#273474, Date prélévement#273475, Code examen Biologie#273476, Libellé examen Biologie#273477, Résultat (numérique)#273478, Unite#273479, Code médecin#273480, Nom médecin#273481, Prénom médecin#273482, Nom document biologie#273483, Nom complet document biologie#273484, Venue#273485, Borne basse#273486, Borne haute#273487]
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>
(5) Project [codegen id : 2]
Output [18]: [IPP#273472 AS COL_IPP_19873#273818, Code établissement#273473 AS COL_CODE_ETABLISSEM_19874#273819, Lib établissement#273474 AS COL_LIB_ETABLISSEME_19875#273820, Date prélévement#273475 AS COL_DATE_PRELEVEMEN_19876#273821, Code examen Biologie#273476 AS COL_CODE_EXAMEN_BIO_19877#273822, Libellé examen Biologie#273477 AS COL_LIBELLE_EXAMEN__19878#273823, Résultat (numérique)#273478 AS COL_RESULTAT_NUMERI_19879#273824, Unite#273479 AS COL_UNITE_19880#273825, Code médecin#273480 AS COL_CODE_MEDECIN_19881#273826, Nom médecin#273481 AS COL_NOM_MEDECIN_19882#273827, Prénom médecin#273482 AS COL_PRENOM_MEDECIN_19883#273828, Nom document biologie#273483 AS COL_NOM_DOCUMENT_BI_19884#273829, Nom complet document biologie#273484 AS COL_NOM_COMPLET_DOC_19885#273830, Venue#273485 AS COL_VENUE_19886#273831, Borne basse#273486 AS COL_BORNE_BASSE_19887#273832, Borne haute#273487 AS COL_BORNE_HAUTE_19888#273833, str_create(Etb Linet) AS COL_ORIGINE_19890#273834, str_extract_by_str(Code examen Biologie#273476, _, RIGHT) AS COL_T1_20254#273835]
Input [16]: [IPP#273472, Code établissement#273473, Lib établissement#273474, Date prélévement#273475, Code examen Biologie#273476, Libellé examen Biologie#273477, Résultat (numérique)#273478, Unite#273479, Code médecin#273480, Nom médecin#273481, Prénom médecin#273482, Nom document biologie#273483, Nom complet document biologie#273484, Venue#273485, Borne basse#273486, Borne haute#273487]
(6) LocalLimit [codegen id : 2]
Input [18]: [COL_IPP_19873#273818, COL_CODE_ETABLISSEM_19874#273819, COL_LIB_ETABLISSEME_19875#273820, COL_DATE_PRELEVEMEN_19876#273821, COL_CODE_EXAMEN_BIO_19877#273822, COL_LIBELLE_EXAMEN__19878#273823, COL_RESULTAT_NUMERI_19879#273824, COL_UNITE_19880#273825, COL_CODE_MEDECIN_19881#273826, COL_NOM_MEDECIN_19882#273827, COL_PRENOM_MEDECIN_19883#273828, COL_NOM_DOCUMENT_BI_19884#273829, COL_NOM_COMPLET_DOC_19885#273830, COL_VENUE_19886#273831, COL_BORNE_BASSE_19887#273832, COL_BORNE_HAUTE_19888#273833, COL_ORIGINE_19890#273834, COL_T1_20254#273835]
Arguments: 1500
(7) Union
(8) CollectLimit
Input [18]: [COL_IPP_19873#273781, COL_CODE_ETABLISSEM_19874#273782, COL_LIB_ETABLISSEME_19875#273783, COL_DATE_PRELEVEMEN_19876#273784, COL_CODE_EXAMEN_BIO_19877#273785, COL_LIBELLE_EXAMEN__19878#273786, COL_RESULTAT_NUMERI_19879#273787, COL_UNITE_19880#273788, COL_CODE_MEDECIN_19881#273789, COL_NOM_MEDECIN_19882#273790, COL_PRENOM_MEDECIN_19883#273791, COL_NOM_DOCUMENT_BI_19884#273792, COL_NOM_COMPLET_DOC_19885#273793, COL_VENUE_19886#273794, COL_BORNE_BASSE_19887#273795, COL_BORNE_HAUTE_19888#273796, COL_ORIGINE_19890#273797, COL_T1_20254#273798]
Arguments: 1500