== Physical Plan ==
Execute CreateViewCommand (1)
+- CreateViewCommand (2)
+- Project (19)
+- Union (18)
:- Project (7)
: +- Project (6)
: +- Project (5)
: +- Project (4)
: +- LogicalRelation (3)
:- Project (12)
: +- Project (11)
: +- Project (10)
: +- Project (9)
: +- LogicalRelation (8)
+- Project (17)
+- Project (16)
+- Project (15)
+- Project (14)
+- LogicalRelation (13)
(1) Execute CreateViewCommand
Output: []
(2) CreateViewCommand
Arguments: `BIOLOGIE_SUIVI__19872170`, false, true, LocalTempView, true
(3) LogicalRelation
Arguments: csv, [IPP#119558, Code établissement#119559, Lib établissement#119560, Date prélévement#119561, Code examen Biologie#119562, Libellé examen Biologie#119563, Résultat (numérique)#119564, Unite#119565, Code médecin#119566, Nom médecin#119567, Prénom médecin#119568, Nom document biologie#119569, Nom complet document biologie#119570, Venue#119571, Borne basse#119572, Borne haute#119573], false
(4) Project
Arguments: [IPP#119558 AS COLL0#119590, Code établissement#119559 AS COLL1#119591, Lib établissement#119560 AS COLL2#119592, Date prélévement#119561 AS COLL3#119593, Code examen Biologie#119562 AS COLL4#119594, Libellé examen Biologie#119563 AS COLL5#119595, Résultat (numérique)#119564 AS COLL6#119596, Unite#119565 AS COLL7#119597, Code médecin#119566 AS COLL8#119598, Nom médecin#119567 AS COLL9#119599, Prénom médecin#119568 AS COLL10#119600, Nom document biologie#119569 AS COLL11#119601, Nom complet document biologie#119570 AS COLL12#119602, Venue#119571 AS COLL13#119603, Borne basse#119572 AS COLL14#119604, Borne haute#119573 AS COLL15#119605]
(5) Project
Arguments: [COLL0#119590 AS COLL0#119623, COLL1#119591 AS COLL1#119624, COLL2#119592 AS COLL2#119625, COLL3#119593 AS COLL3#119626, COLL4#119594 AS COLL4#119627, COLL5#119595 AS COLL5#119628, COLL6#119596 AS COLL6#119629, COLL7#119597 AS COLL7#119630, COLL8#119598 AS COLL8#119631, COLL9#119599 AS COLL9#119632, COLL10#119600 AS COLL10#119633, COLL11#119601 AS COLL11#119634, COLL12#119602 AS COLL12#119635, COLL13#119603 AS COLL13#119636, COLL14#119604 AS COLL14#119637, COLL15#119605 AS COLL15#119638]
(6) Project
Arguments: [COLL0#119623, COLL1#119624, COLL2#119625, COLL3#119626, COLL4#119627, COLL5#119628, COLL6#119629, COLL7#119630, COLL8#119631, COLL9#119632, COLL10#119633, COLL11#119634, COLL12#119635, COLL13#119636, COLL14#119637, COLL15#119638]
(7) Project
Arguments: [cast(REFORMAT_FOR_DOUBLE(COLL14#119637) as double) AS BORNE_BASSE_19887#119671, cast(REFORMAT_FOR_DOUBLE(COLL15#119638) as double) AS BORNE_HAUTE_19888#119672, COLL1#119624 AS CODE_ETABLISSEM_19874#119673, COLL4#119627 AS CODE_EXAMEN_BIO_19877#119674, COLL8#119631 AS CODE_MEDECIN_19881#119675, COLL3#119626 AS DATE_PRELEVEMEN_19876#119676, COLL0#119623 AS IPP_19873#119677, COLL5#119628 AS LIBELLE_EXAMEN__19878#119678, COLL2#119625 AS LIB_ETABLISSEME_19875#119679, COLL12#119635 AS NOM_COMPLET_DOC_19885#119680, COLL11#119634 AS NOM_DOCUMENT_BI_19884#119681, COLL9#119632 AS NOM_MEDECIN_19882#119682, cast(str_create(cast(CH St Agnès as string)) as string) AS ORIGINE_19890#119688, COLL10#119633 AS PRENOM_MEDECIN_19883#119684, cast(REFORMAT_FOR_DOUBLE(COLL6#119629) as double) AS RESULTAT_NUMERI_19879#119685, COLL7#119630 AS UNITE_19880#119686, COLL13#119636 AS VENUE_19886#119687]
(8) LogicalRelation
Arguments: csv, [IPP#119723, Code établissement#119724, Lib établissement#119725, Date prélévement#119726, Code examen Biologie#119727, Libellé examen Biologie#119728, Résultat (numérique)#119729, Unite#119730, Code médecin#119731, Nom médecin#119732, Prénom médecin#119733, Nom document biologie#119734, Nom complet document biologie#119735, Venue#119736, Borne basse#119737, Borne haute#119738], false
(9) Project
Arguments: [IPP#119723 AS COLL0#119755, Code établissement#119724 AS COLL1#119756, Lib établissement#119725 AS COLL2#119757, Date prélévement#119726 AS COLL3#119758, Code examen Biologie#119727 AS COLL4#119759, Libellé examen Biologie#119728 AS COLL5#119760, Résultat (numérique)#119729 AS COLL6#119761, Unite#119730 AS COLL7#119762, Code médecin#119731 AS COLL8#119763, Nom médecin#119732 AS COLL9#119764, Prénom médecin#119733 AS COLL10#119765, Nom document biologie#119734 AS COLL11#119766, Nom complet document biologie#119735 AS COLL12#119767, Venue#119736 AS COLL13#119768, Borne basse#119737 AS COLL14#119769, Borne haute#119738 AS COLL15#119770]
(10) Project
Arguments: [COLL0#119755 AS COLL0#119788, COLL1#119756 AS COLL1#119789, COLL2#119757 AS COLL2#119790, COLL3#119758 AS COLL3#119791, COLL4#119759 AS COLL4#119792, COLL5#119760 AS COLL5#119793, COLL6#119761 AS COLL6#119794, COLL7#119762 AS COLL7#119795, COLL8#119763 AS COLL8#119796, COLL9#119764 AS COLL9#119797, COLL10#119765 AS COLL10#119798, COLL11#119766 AS COLL11#119799, COLL12#119767 AS COLL12#119800, COLL13#119768 AS COLL13#119801, COLL14#119769 AS COLL14#119802, COLL15#119770 AS COLL15#119803]
(11) Project
Arguments: [COLL0#119788, COLL1#119789, COLL2#119790, COLL3#119791, COLL4#119792, COLL5#119793, COLL6#119794, COLL7#119795, COLL8#119796, COLL9#119797, COLL10#119798, COLL11#119799, COLL12#119800, COLL13#119801, COLL14#119802, COLL15#119803]
(12) Project
Arguments: [COLL14#119802 AS BORNE_BASSE_19887#119836, COLL15#119803 AS BORNE_HAUTE_19888#119837, COLL1#119789 AS CODE_ETABLISSEM_19874#119838, COLL4#119792 AS CODE_EXAMEN_BIO_19877#119839, COLL8#119796 AS CODE_MEDECIN_19881#119840, COLL3#119791 AS DATE_PRELEVEMEN_19876#119841, COLL0#119788 AS IPP_19873#119842, COLL5#119793 AS LIBELLE_EXAMEN__19878#119843, COLL2#119790 AS LIB_ETABLISSEME_19875#119844, COLL12#119800 AS NOM_COMPLET_DOC_19885#119845, COLL11#119799 AS NOM_DOCUMENT_BI_19884#119846, COLL9#119797 AS NOM_MEDECIN_19882#119847, cast(str_create(cast(CH Butel as string)) as string) AS ORIGINE_19890#119853, COLL10#119798 AS PRENOM_MEDECIN_19883#119849, COLL6#119794 AS RESULTAT_NUMERI_19879#119850, COLL7#119795 AS UNITE_19880#119851, COLL13#119801 AS VENUE_19886#119852]
(13) LogicalRelation
Arguments: 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#119888, Code établissement#119889, Lib établissement#119890, Date prélévement#119891, Code examen Biologie#119892, Libellé examen Biologie#119893, Résultat (numérique)#119894, Unite#119895, Code médecin#119896, Nom médecin#119897, Prénom médecin#119898, Nom document biologie#119899, Nom complet document biologie#119900, Venue#119901, Borne basse#119902, Borne haute#119903], false
(14) Project
Arguments: [IPP#119888 AS COLL0#119920, Code établissement#119889 AS COLL1#119921, Lib établissement#119890 AS COLL2#119922, Date prélévement#119891 AS COLL3#119923, Code examen Biologie#119892 AS COLL4#119924, Libellé examen Biologie#119893 AS COLL5#119925, Résultat (numérique)#119894 AS COLL6#119926, Unite#119895 AS COLL7#119927, Code médecin#119896 AS COLL8#119928, Nom médecin#119897 AS COLL9#119929, Prénom médecin#119898 AS COLL10#119930, Nom document biologie#119899 AS COLL11#119931, Nom complet document biologie#119900 AS COLL12#119932, Venue#119901 AS COLL13#119933, Borne basse#119902 AS COLL14#119934, Borne haute#119903 AS COLL15#119935]
(15) Project
Arguments: [COLL0#119920 AS COLL0#119952, COLL1#119921 AS COLL1#119953, COLL2#119922 AS COLL2#119954, COLL3#119923 AS COLL3#119955, COLL4#119924 AS COLL4#119956, COLL5#119925 AS COLL5#119957, COLL6#119926 AS COLL6#119958, COLL7#119927 AS COLL7#119959, COLL8#119928 AS COLL8#119960, COLL9#119929 AS COLL9#119961, COLL10#119930 AS COLL10#119962, COLL11#119931 AS COLL11#119963, COLL12#119932 AS COLL12#119964, COLL13#119933 AS COLL13#119965, COLL14#119934 AS COLL14#119966, COLL15#119935 AS COLL15#119967]
(16) Project
Arguments: [COLL0#119952, COLL1#119953, COLL2#119954, COLL3#119955, COLL4#119956, COLL5#119957, COLL6#119958, COLL7#119959, COLL8#119960, COLL9#119961, COLL10#119962, COLL11#119963, COLL12#119964, COLL13#119965, COLL14#119966, COLL15#119967]
(17) Project
Arguments: [COLL14#119966 AS BORNE_BASSE_19887#120000, COLL15#119967 AS BORNE_HAUTE_19888#120001, COLL1#119953 AS CODE_ETABLISSEM_19874#120002, COLL4#119956 AS CODE_EXAMEN_BIO_19877#120003, COLL8#119960 AS CODE_MEDECIN_19881#120004, COLL3#119955 AS DATE_PRELEVEMEN_19876#120005, COLL0#119952 AS IPP_19873#120006, COLL5#119957 AS LIBELLE_EXAMEN__19878#120007, COLL2#119954 AS LIB_ETABLISSEME_19875#120008, COLL12#119964 AS NOM_COMPLET_DOC_19885#120009, COLL11#119963 AS NOM_DOCUMENT_BI_19884#120010, COLL9#119961 AS NOM_MEDECIN_19882#120011, cast(str_create(cast(Etb Linet as string)) as string) AS ORIGINE_19890#120017, COLL10#119962 AS PRENOM_MEDECIN_19883#120013, COLL6#119958 AS RESULTAT_NUMERI_19879#120014, COLL7#119959 AS UNITE_19880#120015, COLL13#119965 AS VENUE_19886#120016]
(18) Union
Arguments: false, false
(19) Project
Arguments: [BORNE_BASSE_19887#119671, BORNE_HAUTE_19888#119672, CODE_ETABLISSEM_19874#119673, CODE_EXAMEN_BIO_19877#119674, CODE_MEDECIN_19881#119675, DATE_PRELEVEMEN_19876#119676, IPP_19873#119677, LIBELLE_EXAMEN__19878#119678, LIB_ETABLISSEME_19875#119679, NOM_COMPLET_DOC_19885#119680, NOM_DOCUMENT_BI_19884#119681, NOM_MEDECIN_19882#119682, ORIGINE_19890#119688, PRENOM_MEDECIN_19883#119684, RESULTAT_NUMERI_19879#119685, UNITE_19880#119686, VENUE_19886#119687, str_extract_by_str(CODE_EXAMEN_BIO_19877#119674, cast(_ as string), cast(RIGHT as string)) AS T1_20254#120052]