== Physical Plan ==
Execute CreateViewCommand (1)
+- CreateViewCommand (2)
+- Project (8)
+- Project (7)
+- Project (6)
+- Project (5)
+- Project (4)
+- LogicalRelation (3)
(1) Execute CreateViewCommand
Output: []
(2) CreateViewCommand
Arguments: `DOCUMENT_DATA_2852163`, false, true, LocalTempView, true
(3) LogicalRelation
Arguments: JDBCRelation((SELECT "DOCUMENT_DATA_ID", "DOCUMENT_ID", "PATIENT_ID", "VISIT_ID", "VISIT_UNIT_ID", "ID_ENTREPOT_STRUCTURE", "ID_ENTREPOT", "ID_PAT", "ID_SEJ", "ID_MVT", "TERMINOLOGY_CODE", "CONCEPT_CODE", "NB", "START_AT", "TEXT", "LOWER_BOUND", "HIGHER_BOUND", "CERTAINTY", "CONTEXT", "QUALIFIER", "END_AT", "UNIT_VAL", "TYPE_VAL", "INSTANCE_ID" FROM "DTM_261"."DOCUMENT_DATA") x) [numPartitions=1], [DOCUMENT_DATA_ID#1195, DOCUMENT_ID#1196, PATIENT_ID#1197, VISIT_ID#1198, VISIT_UNIT_ID#1199, ID_ENTREPOT_STRUCTURE#1200, ID_ENTREPOT#1201, ID_PAT#1202, ID_SEJ#1203, ID_MVT#1204, TERMINOLOGY_CODE#1205, CONCEPT_CODE#1206, NB#1207, START_AT#1208, TEXT#1209, LOWER_BOUND#1210, HIGHER_BOUND#1211, CERTAINTY#1212, CONTEXT#1213, QUALIFIER#1214, END_AT#1215, UNIT_VAL#1216, TYPE_VAL#1217, INSTANCE_ID#1218], false
(4) Project
Arguments: [DOCUMENT_DATA_ID#1195 AS COLL0#1243, DOCUMENT_ID#1196 AS COLL1#1244, PATIENT_ID#1197 AS COLL2#1245, VISIT_ID#1198 AS COLL3#1246, VISIT_UNIT_ID#1199 AS COLL4#1247, ID_ENTREPOT_STRUCTURE#1200 AS COLL5#1248, ID_ENTREPOT#1201 AS COLL6#1249, ID_PAT#1202 AS COLL7#1250, ID_SEJ#1203 AS COLL8#1251, ID_MVT#1204 AS COLL9#1252, TERMINOLOGY_CODE#1205 AS COLL10#1253, CONCEPT_CODE#1206 AS COLL11#1254, NB#1207 AS COLL12#1255, START_AT#1208 AS COLL13#1256, TEXT#1209 AS COLL14#1257, LOWER_BOUND#1210 AS COLL15#1258, HIGHER_BOUND#1211 AS COLL16#1259, CERTAINTY#1212 AS COLL17#1260, CONTEXT#1213 AS COLL18#1261, QUALIFIER#1214 AS COLL19#1262, END_AT#1215 AS COLL20#1263, UNIT_VAL#1216 AS COLL21#1264, TYPE_VAL#1217 AS COLL22#1265, INSTANCE_ID#1218 AS COLL23#1266]
(5) Project
Arguments: [COLL0#1243 AS COLL0#1291, COLL1#1244 AS COLL1#1292, COLL2#1245 AS COLL2#1293, COLL3#1246 AS COLL3#1294, COLL4#1247 AS COLL4#1295, COLL5#1248 AS COLL5#1296, COLL6#1249 AS COLL6#1297, COLL7#1250 AS COLL7#1298, COLL8#1251 AS COLL8#1299, COLL9#1252 AS COLL9#1300, COLL10#1253 AS COLL10#1301, COLL11#1254 AS COLL11#1302, COLL12#1255 AS COLL12#1303, COLL13#1256 AS COLL13#1304, COLL14#1257 AS COLL14#1305, COLL15#1258 AS COLL15#1306, COLL16#1259 AS COLL16#1307, COLL17#1260 AS COLL17#1308, COLL18#1261 AS COLL18#1309, COLL19#1262 AS COLL19#1310, COLL20#1263 AS COLL20#1311, COLL21#1264 AS COLL21#1312, COLL22#1265 AS COLL22#1313, COLL23#1266 AS COLL23#1314]
(6) Project
Arguments: [COLL0#1291, COLL1#1292, COLL2#1293, COLL3#1294, COLL4#1295, COLL5#1296, COLL6#1297, COLL7#1298, COLL8#1299, COLL9#1300, COLL10#1301, COLL11#1302, COLL12#1303, COLL13#1304, COLL14#1305, COLL15#1306, COLL16#1307, COLL17#1308, COLL18#1309, COLL19#1310, COLL20#1311, COLL21#1312, COLL22#1313, COLL23#1314]
(7) Project
Arguments: [cast(REFORMAT_FOR_DOUBLE(COLL17#1308) as double) AS CERTAINTY_2870#1363, COLL11#1302 AS CONCEPT_CODE_2864#1364, COLL18#1309 AS CONTEXT_2871#1365, cast(null as string) AS DOCUMENT_DATA_I_2853#1366, cast(null as string) AS DOCUMENT_ID_2854#1367, COLL20#1311 AS END_AT_2873#1368, cast(REFORMAT_FOR_DOUBLE(COLL16#1307) as double) AS HIGHER_BOUND_2869#1369, cast(COLL6#1297 as int) AS ID_ENTREPOT_2859#1370, cast(COLL5#1296 as int) AS ID_ENTREPOT_STR_2858#1371, cast(COLL9#1300 as int) AS ID_MVT_2862#1372, cast(COLL7#1298 as int) AS ID_PAT_2860#1373, cast(COLL8#1299 as int) AS ID_SEJ_2861#1374, COLL23#1314 AS INSTANCE_ID_2876#1375, cast(REFORMAT_FOR_DOUBLE(COLL15#1306) as double) AS LOWER_BOUND_2868#1376, cast(REFORMAT_FOR_DOUBLE(COLL12#1303) as double) AS NB_2865#1377, cast(null as string) AS PATIENT_ID_2855#1378, COLL19#1310 AS QUALIFIER_2872#1379, COLL13#1304 AS START_AT_2866#1380, COLL10#1301 AS TERMINOLOGY_COD_2863#1381, COLL14#1305 AS TEXT_2867#1382, COLL22#1313 AS TYPE_VAL_2875#1383, COLL21#1312 AS UNIT_VAL_2874#1384, cast(null as string) AS VISIT_ID_2856#1385, cast(null as string) AS VISIT_UNIT_ID_2857#1386]
(8) Project
Arguments: [CERTAINTY_2870#1363, CONCEPT_CODE_2864#1364, CONTEXT_2871#1365, DOCUMENT_DATA_I_2853#1366, DOCUMENT_ID_2854#1367, END_AT_2873#1368, HIGHER_BOUND_2869#1369, ID_ENTREPOT_2859#1370, ID_ENTREPOT_STR_2858#1371, ID_MVT_2862#1372, ID_PAT_2860#1373, ID_SEJ_2861#1374, INSTANCE_ID_2876#1375, LOWER_BOUND_2868#1376, NB_2865#1377, PATIENT_ID_2855#1378, QUALIFIER_2872#1379, START_AT_2866#1380, TERMINOLOGY_COD_2863#1381, TEXT_2867#1382, TYPE_VAL_2875#1383, UNIT_VAL_2874#1384, VISIT_ID_2856#1385, VISIT_UNIT_ID_2857#1386]