== Physical Plan ==
Execute CreateViewCommand (1)
+- CreateViewCommand (2)
+- Project (16)
+- Sort (15)
+- Project (14)
+- Aggregate (13)
+- Project (12)
+- Project (11)
+- Project (10)
+- SubqueryAlias (9)
+- View (8)
+- Project (7)
+- Project (6)
+- Project (5)
+- Project (4)
+- LogicalRelation (3)
(1) Execute CreateViewCommand
Output: []
(2) CreateViewCommand
Arguments: `ENTITY_DEPOT_TE_23372164`, false, true, LocalTempView, true
(3) LogicalRelation
Arguments: csv, [IPP - Identifiant_Patient#1142, Nom de famille patient#1143, Prénom patient#1144, Nom de naissance patient#1145, Sexe Patient#1146, Date de naissance patient#1147, Code établissement#1148, Libellé établissement#1149, rue#1150, commune#1151, code postal#1152, Latitude Adresse#1153, Longitude Adresse#1154, DPT#1155], false
(4) Project
Arguments: [IPP - Identifiant_Patient#1142 AS IPP - Identifiant_Patient#1184, Nom de famille patient#1143 AS Nom de famille patient#1185, Prénom patient#1144 AS Prénom patient#1186, Nom de naissance patient#1145 AS Nom de naissance patient#1187, Sexe Patient#1146 AS Sexe Patient#1188, Date de naissance patient#1147 AS Date de naissance patient#1189, Code établissement#1148 AS Code établissement#1190, Libellé établissement#1149 AS Libellé établissement#1191, rue#1150 AS rue#1192, commune#1151 AS commune#1193, code postal#1152 AS code postal#1194, Latitude Adresse#1153 AS Latitude Adresse#1195, Longitude Adresse#1154 AS Longitude Adresse#1196, DPT#1155 AS DPT#1197]
(5) Project
Arguments: [IPP - Identifiant_Patient#1184, Nom de famille patient#1185, Prénom patient#1186, Nom de naissance patient#1187, Sexe Patient#1188, Date de naissance patient#1189, Code établissement#1190, Libellé établissement#1191, rue#1192, commune#1193, code postal#1194, Latitude Adresse#1195, Longitude Adresse#1196, DPT#1197]
(6) Project
Arguments: [code postal#1194 AS _CODE_POSTAL#1227, Code établissement#1190 AS _CODE_TABLISSEMENT#1228, commune#1193 AS _COMMUNE#1229, Date de naissance patient#1189 AS _DATE_DE_NAISSANCE_PATIENT#1230, DPT#1197 AS _DPT#1231, IPP - Identifiant_Patient#1184 AS _IPP_IDENTIFIANT_PATIENT#1232, Latitude Adresse#1195 AS _LATITUDE_ADRESSE#1233, Libellé établissement#1191 AS _LIBELL_TABLISSEMENT#1234, Longitude Adresse#1196 AS _LONGITUDE_ADRESSE#1235, Nom de famille patient#1185 AS _NOM_DE_FAMILLE_PATIENT#1236, Nom de naissance patient#1187 AS _NOM_DE_NAISSANCE_PATIENT#1237, Prénom patient#1186 AS _PR_NOM_PATIENT#1238, rue#1192 AS _RUE#1239, Sexe Patient#1188 AS _SEXE_PATIENT#1240]
(7) Project
Arguments: [_CODE_POSTAL#1227, _CODE_TABLISSEMENT#1228, _COMMUNE#1229, _DATE_DE_NAISSANCE_PATIENT#1230, _DPT#1231, _IPP_IDENTIFIANT_PATIENT#1232, _LATITUDE_ADRESSE#1233, _LIBELL_TABLISSEMENT#1234, _LONGITUDE_ADRESSE#1235, _NOM_DE_FAMILLE_PATIENT#1236, _NOM_DE_NAISSANCE_PATIENT#1237, _PR_NOM_PATIENT#1238, _RUE#1239, _SEXE_PATIENT#1240, str_complete(int_to_str(_CODE_POSTAL#1227), cast(0 as string), cast(5 as bigint), cast(LEFT as string)) AS CODE_POSTAL_NOR_23371#1255]
(8) View
Arguments: `ENTITY_DEPOT_TE_23356164`, true
(9) SubqueryAlias
Arguments: ENTITY_DEPOT_TE_23356164
(10) Project
Arguments: [_CODE_POSTAL#1227 AS ENTITY_DEPOT_TE_23356__CODE_POSTAL#1286, _CODE_TABLISSEMENT#1228 AS ENTITY_DEPOT_TE_23356__CODE_TABLISSEMENT#1287, _COMMUNE#1229 AS ENTITY_DEPOT_TE_23356__COMMUNE#1288, _DATE_DE_NAISSANCE_PATIENT#1230 AS ENTITY_DEPOT_TE_23356__DATE_DE_NAISSANCE_PATIENT#1289, _DPT#1231 AS ENTITY_DEPOT_TE_23356__DPT#1290, _IPP_IDENTIFIANT_PATIENT#1232 AS ENTITY_DEPOT_TE_23356__IPP_IDENTIFIANT_PATIENT#1291, _LATITUDE_ADRESSE#1233 AS ENTITY_DEPOT_TE_23356__LATITUDE_ADRESSE#1292, _LIBELL_TABLISSEMENT#1234 AS ENTITY_DEPOT_TE_23356__LIBELL_TABLISSEMENT#1293, _LONGITUDE_ADRESSE#1235 AS ENTITY_DEPOT_TE_23356__LONGITUDE_ADRESSE#1294, _NOM_DE_FAMILLE_PATIENT#1236 AS ENTITY_DEPOT_TE_23356__NOM_DE_FAMILLE_PATIENT#1295, _NOM_DE_NAISSANCE_PATIENT#1237 AS ENTITY_DEPOT_TE_23356__NOM_DE_NAISSANCE_PATIENT#1296, _PR_NOM_PATIENT#1238 AS ENTITY_DEPOT_TE_23356__PR_NOM_PATIENT#1297, _RUE#1239 AS ENTITY_DEPOT_TE_23356__RUE#1298, _SEXE_PATIENT#1240 AS ENTITY_DEPOT_TE_23356__SEXE_PATIENT#1299, CODE_POSTAL_NOR_23371#1255 AS ENTITY_DEPOT_TE_23356_CODE_POSTAL_NOR_23371#1300]
(11) Project
Arguments: [cast(ENTITY_DEPOT_TE_23356__IPP_IDENTIFIANT_PATIENT#1291 as string) AS COL_96EBE23D_A510_4A33_A17A_2FCEF5CCAFD5#1331, cast(ENTITY_DEPOT_TE_23356__NOM_DE_FAMILLE_PATIENT#1295 as string) AS COL_335EE8E5_FEA0_4F22_8CB3_D71B189C2774#1332, cast(ENTITY_DEPOT_TE_23356__PR_NOM_PATIENT#1297 as string) AS COL_AFDD307D_6D56_4174_89B0_A182BAF9BE2C#1333, cast(ENTITY_DEPOT_TE_23356__NOM_DE_NAISSANCE_PATIENT#1296 as string) AS COL_138FF842_F4E4_4B83_B193_5BAA5D192261#1334, cast(ENTITY_DEPOT_TE_23356__SEXE_PATIENT#1299 as int) AS COL_82173DAB_91F7_4ACF_B897_0C0B1DD31E6C#1335, cast(ENTITY_DEPOT_TE_23356__DATE_DE_NAISSANCE_PATIENT#1289 as string) AS COL_CF5E3A93_8305_429E_A948_DF1627D3DE35#1336, cast(ENTITY_DEPOT_TE_23356__CODE_TABLISSEMENT#1287 as string) AS COL_E5095073_6CF1_405F_83F4_CEE5B9F07B9E#1337, cast(ENTITY_DEPOT_TE_23356__LIBELL_TABLISSEMENT#1293 as string) AS COL_D84ED7BA_6EC3_4DE8_A5D3_D295526930DF#1338, cast(ENTITY_DEPOT_TE_23356__RUE#1298 as string) AS COL_B8A4D484_E807_4E17_A086_069B99F3FE35#1339, cast(ENTITY_DEPOT_TE_23356__COMMUNE#1288 as string) AS COL_008DDC94_19BA_4F8E_A120_A278AD76C687#1340, cast(ENTITY_DEPOT_TE_23356__CODE_POSTAL#1286 as int) AS COL_228A9BD8_126D_4349_931B_139A63C5DFAF#1341, cast(ENTITY_DEPOT_TE_23356__LATITUDE_ADRESSE#1292 as double) AS COL_04811AE2_A67B_4EF5_8D52_A9C03420EDF3#1342, cast(ENTITY_DEPOT_TE_23356__LONGITUDE_ADRESSE#1294 as double) AS COL_DD07EEA2_975F_4B38_84A8_7A6AB586FDD4#1343, cast(ENTITY_DEPOT_TE_23356__DPT#1290 as int) AS COL_AF185383_3F7C_4A45_9DD2_F718785C191C#1344, cast(ENTITY_DEPOT_TE_23356_CODE_POSTAL_NOR_23371#1300 as string) AS COL_F9A328F9_95C1_44CA_BB91_5FCCCF7875AF#1345]
(12) Project
Arguments: [COL_96EBE23D_A510_4A33_A17A_2FCEF5CCAFD5#1331 AS COL_96EBE23D_A510_4A33_A17A_2FCEF5CCAFD5#1361, COL_335EE8E5_FEA0_4F22_8CB3_D71B189C2774#1332 AS COL_335EE8E5_FEA0_4F22_8CB3_D71B189C2774#1362, COL_AFDD307D_6D56_4174_89B0_A182BAF9BE2C#1333 AS COL_AFDD307D_6D56_4174_89B0_A182BAF9BE2C#1363, COL_138FF842_F4E4_4B83_B193_5BAA5D192261#1334 AS COL_138FF842_F4E4_4B83_B193_5BAA5D192261#1364, COL_82173DAB_91F7_4ACF_B897_0C0B1DD31E6C#1335 AS COL_82173DAB_91F7_4ACF_B897_0C0B1DD31E6C#1365, COL_CF5E3A93_8305_429E_A948_DF1627D3DE35#1336 AS COL_CF5E3A93_8305_429E_A948_DF1627D3DE35#1366, COL_E5095073_6CF1_405F_83F4_CEE5B9F07B9E#1337 AS COL_E5095073_6CF1_405F_83F4_CEE5B9F07B9E#1367, COL_D84ED7BA_6EC3_4DE8_A5D3_D295526930DF#1338 AS COL_D84ED7BA_6EC3_4DE8_A5D3_D295526930DF#1368, COL_B8A4D484_E807_4E17_A086_069B99F3FE35#1339 AS COL_B8A4D484_E807_4E17_A086_069B99F3FE35#1369, COL_008DDC94_19BA_4F8E_A120_A278AD76C687#1340 AS COL_008DDC94_19BA_4F8E_A120_A278AD76C687#1370, COL_228A9BD8_126D_4349_931B_139A63C5DFAF#1341 AS COL_228A9BD8_126D_4349_931B_139A63C5DFAF#1371, COL_04811AE2_A67B_4EF5_8D52_A9C03420EDF3#1342 AS COL_04811AE2_A67B_4EF5_8D52_A9C03420EDF3#1372, COL_DD07EEA2_975F_4B38_84A8_7A6AB586FDD4#1343 AS COL_DD07EEA2_975F_4B38_84A8_7A6AB586FDD4#1373, COL_AF185383_3F7C_4A45_9DD2_F718785C191C#1344 AS COL_AF185383_3F7C_4A45_9DD2_F718785C191C#1374, COL_F9A328F9_95C1_44CA_BB91_5FCCCF7875AF#1345 AS COL_F9A328F9_95C1_44CA_BB91_5FCCCF7875AF#1375]
(13) Aggregate
Arguments: [COL_AF185383_3F7C_4A45_9DD2_F718785C191C#1374, COL_AFDD307D_6D56_4174_89B0_A182BAF9BE2C#1363], [COL_AF185383_3F7C_4A45_9DD2_F718785C191C#1374 AS COL_89B753B4_1BC1_4BC3_958C_EF51134F443C#1391, COL_AFDD307D_6D56_4174_89B0_A182BAF9BE2C#1363 AS COL_7FB10548_34DA_4B88_9326_F27291D6199C#1392, 1 AS NULL_1#1411, count(1) AS COL_83756F20_D775_4450_8556_5ADA123CECE0#1410L]
(14) Project
Arguments: [COL_89B753B4_1BC1_4BC3_958C_EF51134F443C#1391, COL_7FB10548_34DA_4B88_9326_F27291D6199C#1392, COL_83756F20_D775_4450_8556_5ADA123CECE0#1410L]
(15) Sort
Arguments: [COL_89B753B4_1BC1_4BC3_958C_EF51134F443C#1391 ASC NULLS FIRST, COL_7FB10548_34DA_4B88_9326_F27291D6199C#1392 ASC NULLS FIRST], true
(16) Project
Arguments: [COL_89B753B4_1BC1_4BC3_958C_EF51134F443C#1391 AS COL_89B753B4_1BC1_4BC3_958C_EF51134F443C#1419, COL_7FB10548_34DA_4B88_9326_F27291D6199C#1392 AS COL_7FB10548_34DA_4B88_9326_F27291D6199C#1420, bigint_to_int(COL_83756F20_D775_4450_8556_5ADA123CECE0#1410L) AS COL_83756F20_D775_4450_8556_5ADA123CECE0#1421]