== 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_2852162`, 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#1680, DOCUMENT_ID#1681, PATIENT_ID#1682, VISIT_ID#1683, VISIT_UNIT_ID#1684, ID_ENTREPOT_STRUCTURE#1685, ID_ENTREPOT#1686, ID_PAT#1687, ID_SEJ#1688, ID_MVT#1689, TERMINOLOGY_CODE#1690, CONCEPT_CODE#1691, NB#1692, START_AT#1693, TEXT#1694, LOWER_BOUND#1695, HIGHER_BOUND#1696, CERTAINTY#1697, CONTEXT#1698, QUALIFIER#1699, END_AT#1700, UNIT_VAL#1701, TYPE_VAL#1702, INSTANCE_ID#1703], false
(4) Project
Arguments: [DOCUMENT_DATA_ID#1680 AS COLL0#1728, DOCUMENT_ID#1681 AS COLL1#1729, PATIENT_ID#1682 AS COLL2#1730, VISIT_ID#1683 AS COLL3#1731, VISIT_UNIT_ID#1684 AS COLL4#1732, ID_ENTREPOT_STRUCTURE#1685 AS COLL5#1733, ID_ENTREPOT#1686 AS COLL6#1734, ID_PAT#1687 AS COLL7#1735, ID_SEJ#1688 AS COLL8#1736, ID_MVT#1689 AS COLL9#1737, TERMINOLOGY_CODE#1690 AS COLL10#1738, CONCEPT_CODE#1691 AS COLL11#1739, NB#1692 AS COLL12#1740, START_AT#1693 AS COLL13#1741, TEXT#1694 AS COLL14#1742, LOWER_BOUND#1695 AS COLL15#1743, HIGHER_BOUND#1696 AS COLL16#1744, CERTAINTY#1697 AS COLL17#1745, CONTEXT#1698 AS COLL18#1746, QUALIFIER#1699 AS COLL19#1747, END_AT#1700 AS COLL20#1748, UNIT_VAL#1701 AS COLL21#1749, TYPE_VAL#1702 AS COLL22#1750, INSTANCE_ID#1703 AS COLL23#1751]
(5) Project
Arguments: [COLL0#1728 AS COLL0#1776, COLL1#1729 AS COLL1#1777, COLL2#1730 AS COLL2#1778, COLL3#1731 AS COLL3#1779, COLL4#1732 AS COLL4#1780, COLL5#1733 AS COLL5#1781, COLL6#1734 AS COLL6#1782, COLL7#1735 AS COLL7#1783, COLL8#1736 AS COLL8#1784, COLL9#1737 AS COLL9#1785, COLL10#1738 AS COLL10#1786, COLL11#1739 AS COLL11#1787, COLL12#1740 AS COLL12#1788, COLL13#1741 AS COLL13#1789, COLL14#1742 AS COLL14#1790, COLL15#1743 AS COLL15#1791, COLL16#1744 AS COLL16#1792, COLL17#1745 AS COLL17#1793, COLL18#1746 AS COLL18#1794, COLL19#1747 AS COLL19#1795, COLL20#1748 AS COLL20#1796, COLL21#1749 AS COLL21#1797, COLL22#1750 AS COLL22#1798, COLL23#1751 AS COLL23#1799]
(6) Project
Arguments: [COLL0#1776, COLL1#1777, COLL2#1778, COLL3#1779, COLL4#1780, COLL5#1781, COLL6#1782, COLL7#1783, COLL8#1784, COLL9#1785, COLL10#1786, COLL11#1787, COLL12#1788, COLL13#1789, COLL14#1790, COLL15#1791, COLL16#1792, COLL17#1793, COLL18#1794, COLL19#1795, COLL20#1796, COLL21#1797, COLL22#1798, COLL23#1799]
(7) Project
Arguments: [cast(REFORMAT_FOR_DOUBLE(COLL17#1793) as double) AS CERTAINTY_2870#1848, COLL11#1787 AS CONCEPT_CODE_2864#1849, COLL18#1794 AS CONTEXT_2871#1850, cast(null as string) AS DOCUMENT_DATA_I_2853#1851, cast(null as string) AS DOCUMENT_ID_2854#1852, COLL20#1796 AS END_AT_2873#1853, cast(REFORMAT_FOR_DOUBLE(COLL16#1792) as double) AS HIGHER_BOUND_2869#1854, cast(COLL6#1782 as int) AS ID_ENTREPOT_2859#1855, cast(COLL5#1781 as int) AS ID_ENTREPOT_STR_2858#1856, cast(COLL9#1785 as int) AS ID_MVT_2862#1857, cast(COLL7#1783 as int) AS ID_PAT_2860#1858, cast(COLL8#1784 as int) AS ID_SEJ_2861#1859, COLL23#1799 AS INSTANCE_ID_2876#1860, cast(REFORMAT_FOR_DOUBLE(COLL15#1791) as double) AS LOWER_BOUND_2868#1861, cast(REFORMAT_FOR_DOUBLE(COLL12#1788) as double) AS NB_2865#1862, cast(null as string) AS PATIENT_ID_2855#1863, COLL19#1795 AS QUALIFIER_2872#1864, COLL13#1789 AS START_AT_2866#1865, COLL10#1786 AS TERMINOLOGY_COD_2863#1866, COLL14#1790 AS TEXT_2867#1867, COLL22#1798 AS TYPE_VAL_2875#1868, COLL21#1797 AS UNIT_VAL_2874#1869, cast(null as string) AS VISIT_ID_2856#1870, cast(null as string) AS VISIT_UNIT_ID_2857#1871]
(8) Project
Arguments: [CERTAINTY_2870#1848, CONCEPT_CODE_2864#1849, CONTEXT_2871#1850, DOCUMENT_DATA_I_2853#1851, DOCUMENT_ID_2854#1852, END_AT_2873#1853, HIGHER_BOUND_2869#1854, ID_ENTREPOT_2859#1855, ID_ENTREPOT_STR_2858#1856, ID_MVT_2862#1857, ID_PAT_2860#1858, ID_SEJ_2861#1859, INSTANCE_ID_2876#1860, LOWER_BOUND_2868#1861, NB_2865#1862, PATIENT_ID_2855#1863, QUALIFIER_2872#1864, START_AT_2866#1865, TERMINOLOGY_COD_2863#1866, TEXT_2867#1867, TYPE_VAL_2875#1868, UNIT_VAL_2874#1869, VISIT_ID_2856#1870, VISIT_UNIT_ID_2857#1871]