== Physical Plan ==
Execute CreateViewCommand (1)
+- CreateViewCommand (2)
+- Project (37)
+- Project (36)
+- Join (35)
:- Project (25)
: +- Project (24)
: +- Project (23)
: +- Project (22)
: +- Project (21)
: +- Window (20)
: +- Project (19)
: +- Project (18)
: +- Project (17)
: +- Project (16)
: +- Project (15)
: +- Window (14)
: +- Project (13)
: +- Project (12)
: +- Project (11)
: +- Project (10)
: +- Project (9)
: +- Project (8)
: +- Project (7)
: +- Project (6)
: +- SubqueryAlias (5)
: +- View (4)
: +- LogicalRelation (3)
+- Project (34)
+- SubqueryAlias (33)
+- View (32)
+- Project (31)
+- Project (30)
+- Project (29)
+- Project (28)
+- Project (27)
+- LogicalRelation (26)
(1) Execute CreateViewCommand
Output: []
(2) CreateViewCommand
Arguments: `VISIT_UNIT_AVER_3388165`, false, true, LocalTempView, true
(3) LogicalRelation
Arguments: parquet, [ACTIVITY_3362#68761, IN_DATE_3363#68762, OUT_DATE_3364#68763, PATIENT_ID_3360#68764, UNIT_3361#68765, VISIT_ID_3359#68766, VISIT_UNIT_ID_3358#68767], false
(4) View
Arguments: `VISIT_UNIT_3357165`, true
(5) SubqueryAlias
Arguments: VISIT_UNIT_3357165
(6) Project
Arguments: [ACTIVITY_3362#68761 AS VISIT_UNIT_3357_ACTIVITY_3362#68782, IN_DATE_3363#68762 AS VISIT_UNIT_3357_IN_DATE_3363#68783, OUT_DATE_3364#68763 AS VISIT_UNIT_3357_OUT_DATE_3364#68784, PATIENT_ID_3360#68764 AS VISIT_UNIT_3357_PATIENT_ID_3360#68785, UNIT_3361#68765 AS VISIT_UNIT_3357_UNIT_3361#68786, VISIT_ID_3359#68766 AS VISIT_UNIT_3357_VISIT_ID_3359#68787, VISIT_UNIT_ID_3358#68767 AS VISIT_UNIT_3357_VISIT_UNIT_ID_3358#68788]
(7) Project
Arguments: [cast(VISIT_UNIT_3357_VISIT_UNIT_ID_3358#68788 as string) AS COL_19FBC2D6_FC49_4062_822A_242A41929E7D#68803, cast(VISIT_UNIT_3357_VISIT_ID_3359#68787 as string) AS COL_085E93C6_B825_4DA8_8708_8D98C406324F#68804, cast(VISIT_UNIT_3357_PATIENT_ID_3360#68785 as string) AS COL_FC9902B4_8859_4AF9_ADF1_99A2E15E5351#68805, cast(VISIT_UNIT_3357_UNIT_3361#68786 as string) AS COL_9A5ACA40_F512_495A_9718_534E3BBBA5EE#68806, cast(VISIT_UNIT_3357_ACTIVITY_3362#68782 as string) AS COL_822D1F41_6EAB_4525_8075_1BCA23137730#68807, cast(VISIT_UNIT_3357_IN_DATE_3363#68783 as timestamp) AS COL_8E1D7833_6478_47C9_AF51_C374496B0CFF#68808, cast(VISIT_UNIT_3357_OUT_DATE_3364#68784 as timestamp) AS COL_84B2BFCE_5604_4B75_A7EA_82682A7D0210#68809]
(8) Project
Arguments: [COL_19FBC2D6_FC49_4062_822A_242A41929E7D#68803 AS COL_19FBC2D6_FC49_4062_822A_242A41929E7D#68817, COL_085E93C6_B825_4DA8_8708_8D98C406324F#68804 AS COL_085E93C6_B825_4DA8_8708_8D98C406324F#68818, COL_FC9902B4_8859_4AF9_ADF1_99A2E15E5351#68805 AS COL_FC9902B4_8859_4AF9_ADF1_99A2E15E5351#68819, COL_9A5ACA40_F512_495A_9718_534E3BBBA5EE#68806 AS COL_9A5ACA40_F512_495A_9718_534E3BBBA5EE#68820, COL_822D1F41_6EAB_4525_8075_1BCA23137730#68807 AS COL_822D1F41_6EAB_4525_8075_1BCA23137730#68821, COL_8E1D7833_6478_47C9_AF51_C374496B0CFF#68808 AS COL_8E1D7833_6478_47C9_AF51_C374496B0CFF#68822, COL_84B2BFCE_5604_4B75_A7EA_82682A7D0210#68809 AS COL_84B2BFCE_5604_4B75_A7EA_82682A7D0210#68823]
(9) Project
Arguments: [COL_19FBC2D6_FC49_4062_822A_242A41929E7D#68817, COL_085E93C6_B825_4DA8_8708_8D98C406324F#68818, COL_FC9902B4_8859_4AF9_ADF1_99A2E15E5351#68819, COL_9A5ACA40_F512_495A_9718_534E3BBBA5EE#68820, COL_822D1F41_6EAB_4525_8075_1BCA23137730#68821, COL_8E1D7833_6478_47C9_AF51_C374496B0CFF#68822, COL_84B2BFCE_5604_4B75_A7EA_82682A7D0210#68823, date_diff(cast(HOUR as string), COL_84B2BFCE_5604_4B75_A7EA_82682A7D0210#68823, COL_8E1D7833_6478_47C9_AF51_C374496B0CFF#68822) AS COL_42BBAE75_38D5_44F7_AA65_77D5EA8C5D8C#68831L]
(10) Project
Arguments: [COL_19FBC2D6_FC49_4062_822A_242A41929E7D#68817, COL_085E93C6_B825_4DA8_8708_8D98C406324F#68818, COL_FC9902B4_8859_4AF9_ADF1_99A2E15E5351#68819, COL_9A5ACA40_F512_495A_9718_534E3BBBA5EE#68820, COL_822D1F41_6EAB_4525_8075_1BCA23137730#68821, COL_8E1D7833_6478_47C9_AF51_C374496B0CFF#68822, COL_84B2BFCE_5604_4B75_A7EA_82682A7D0210#68823, COL_42BBAE75_38D5_44F7_AA65_77D5EA8C5D8C#68831L, date_diff(cast(DAY as string), COL_84B2BFCE_5604_4B75_A7EA_82682A7D0210#68823, COL_8E1D7833_6478_47C9_AF51_C374496B0CFF#68822) AS COL_F533C3E3_214A_45F3_B98F_9683DD01C84C#68840L]
(11) Project
Arguments: [COL_19FBC2D6_FC49_4062_822A_242A41929E7D#68817, COL_085E93C6_B825_4DA8_8708_8D98C406324F#68818, COL_FC9902B4_8859_4AF9_ADF1_99A2E15E5351#68819, COL_9A5ACA40_F512_495A_9718_534E3BBBA5EE#68820, COL_822D1F41_6EAB_4525_8075_1BCA23137730#68821, COL_8E1D7833_6478_47C9_AF51_C374496B0CFF#68822, COL_84B2BFCE_5604_4B75_A7EA_82682A7D0210#68823, COL_42BBAE75_38D5_44F7_AA65_77D5EA8C5D8C#68831L, COL_F533C3E3_214A_45F3_B98F_9683DD01C84C#68840L, date_diff(cast(MINUTE as string), COL_84B2BFCE_5604_4B75_A7EA_82682A7D0210#68823, COL_8E1D7833_6478_47C9_AF51_C374496B0CFF#68822) AS COL_B80CC574_7E7E_464D_90B8_5AFE7B1EA083#68850L]
(12) Project
Arguments: [COL_19FBC2D6_FC49_4062_822A_242A41929E7D#68817, COL_085E93C6_B825_4DA8_8708_8D98C406324F#68818, COL_FC9902B4_8859_4AF9_ADF1_99A2E15E5351#68819, COL_9A5ACA40_F512_495A_9718_534E3BBBA5EE#68820, COL_822D1F41_6EAB_4525_8075_1BCA23137730#68821, COL_8E1D7833_6478_47C9_AF51_C374496B0CFF#68822, COL_84B2BFCE_5604_4B75_A7EA_82682A7D0210#68823, COL_42BBAE75_38D5_44F7_AA65_77D5EA8C5D8C#68831L, COL_F533C3E3_214A_45F3_B98F_9683DD01C84C#68840L, COL_B80CC574_7E7E_464D_90B8_5AFE7B1EA083#68850L, 1 AS CONST#68862]
(13) Project
Arguments: [COL_19FBC2D6_FC49_4062_822A_242A41929E7D#68817, COL_085E93C6_B825_4DA8_8708_8D98C406324F#68818, COL_FC9902B4_8859_4AF9_ADF1_99A2E15E5351#68819, COL_9A5ACA40_F512_495A_9718_534E3BBBA5EE#68820, COL_822D1F41_6EAB_4525_8075_1BCA23137730#68821, COL_8E1D7833_6478_47C9_AF51_C374496B0CFF#68822, COL_84B2BFCE_5604_4B75_A7EA_82682A7D0210#68823, COL_42BBAE75_38D5_44F7_AA65_77D5EA8C5D8C#68831L, COL_F533C3E3_214A_45F3_B98F_9683DD01C84C#68840L, COL_B80CC574_7E7E_464D_90B8_5AFE7B1EA083#68850L, CONST#68862]
(14) Window
Arguments: [row_number() windowspecdefinition(COL_FC9902B4_8859_4AF9_ADF1_99A2E15E5351#68819, CONST#68862 DESC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_81E443F6_8690_4169_A3FF_904877152479#68875], [COL_FC9902B4_8859_4AF9_ADF1_99A2E15E5351#68819], [CONST#68862 DESC NULLS LAST]
(15) Project
Arguments: [COL_19FBC2D6_FC49_4062_822A_242A41929E7D#68817, COL_085E93C6_B825_4DA8_8708_8D98C406324F#68818, COL_FC9902B4_8859_4AF9_ADF1_99A2E15E5351#68819, COL_9A5ACA40_F512_495A_9718_534E3BBBA5EE#68820, COL_822D1F41_6EAB_4525_8075_1BCA23137730#68821, COL_8E1D7833_6478_47C9_AF51_C374496B0CFF#68822, COL_84B2BFCE_5604_4B75_A7EA_82682A7D0210#68823, COL_42BBAE75_38D5_44F7_AA65_77D5EA8C5D8C#68831L, COL_F533C3E3_214A_45F3_B98F_9683DD01C84C#68840L, COL_B80CC574_7E7E_464D_90B8_5AFE7B1EA083#68850L, CONST#68862, COL_81E443F6_8690_4169_A3FF_904877152479#68875, COL_81E443F6_8690_4169_A3FF_904877152479#68875]
(16) Project
Arguments: [COL_19FBC2D6_FC49_4062_822A_242A41929E7D#68817, COL_085E93C6_B825_4DA8_8708_8D98C406324F#68818, COL_FC9902B4_8859_4AF9_ADF1_99A2E15E5351#68819, COL_9A5ACA40_F512_495A_9718_534E3BBBA5EE#68820, COL_822D1F41_6EAB_4525_8075_1BCA23137730#68821, COL_8E1D7833_6478_47C9_AF51_C374496B0CFF#68822, COL_84B2BFCE_5604_4B75_A7EA_82682A7D0210#68823, COL_42BBAE75_38D5_44F7_AA65_77D5EA8C5D8C#68831L, COL_F533C3E3_214A_45F3_B98F_9683DD01C84C#68840L, COL_B80CC574_7E7E_464D_90B8_5AFE7B1EA083#68850L, CONST#68862, COL_81E443F6_8690_4169_A3FF_904877152479#68875]
(17) Project
Arguments: [COL_19FBC2D6_FC49_4062_822A_242A41929E7D#68817, COL_085E93C6_B825_4DA8_8708_8D98C406324F#68818, COL_FC9902B4_8859_4AF9_ADF1_99A2E15E5351#68819, COL_9A5ACA40_F512_495A_9718_534E3BBBA5EE#68820, COL_822D1F41_6EAB_4525_8075_1BCA23137730#68821, COL_8E1D7833_6478_47C9_AF51_C374496B0CFF#68822, COL_84B2BFCE_5604_4B75_A7EA_82682A7D0210#68823, COL_42BBAE75_38D5_44F7_AA65_77D5EA8C5D8C#68831L, COL_F533C3E3_214A_45F3_B98F_9683DD01C84C#68840L, COL_B80CC574_7E7E_464D_90B8_5AFE7B1EA083#68850L, COL_81E443F6_8690_4169_A3FF_904877152479#68875]
(18) Project
Arguments: [COL_19FBC2D6_FC49_4062_822A_242A41929E7D#68817, COL_085E93C6_B825_4DA8_8708_8D98C406324F#68818, COL_FC9902B4_8859_4AF9_ADF1_99A2E15E5351#68819, COL_9A5ACA40_F512_495A_9718_534E3BBBA5EE#68820, COL_822D1F41_6EAB_4525_8075_1BCA23137730#68821, COL_8E1D7833_6478_47C9_AF51_C374496B0CFF#68822, COL_84B2BFCE_5604_4B75_A7EA_82682A7D0210#68823, COL_42BBAE75_38D5_44F7_AA65_77D5EA8C5D8C#68831L, COL_F533C3E3_214A_45F3_B98F_9683DD01C84C#68840L, COL_B80CC574_7E7E_464D_90B8_5AFE7B1EA083#68850L, COL_81E443F6_8690_4169_A3FF_904877152479#68875, 1 AS CONST#68914]
(19) Project
Arguments: [COL_19FBC2D6_FC49_4062_822A_242A41929E7D#68817, COL_085E93C6_B825_4DA8_8708_8D98C406324F#68818, COL_FC9902B4_8859_4AF9_ADF1_99A2E15E5351#68819, COL_9A5ACA40_F512_495A_9718_534E3BBBA5EE#68820, COL_822D1F41_6EAB_4525_8075_1BCA23137730#68821, COL_8E1D7833_6478_47C9_AF51_C374496B0CFF#68822, COL_84B2BFCE_5604_4B75_A7EA_82682A7D0210#68823, COL_42BBAE75_38D5_44F7_AA65_77D5EA8C5D8C#68831L, COL_F533C3E3_214A_45F3_B98F_9683DD01C84C#68840L, COL_B80CC574_7E7E_464D_90B8_5AFE7B1EA083#68850L, COL_81E443F6_8690_4169_A3FF_904877152479#68875, CONST#68914]
(20) Window
Arguments: [count(1) windowspecdefinition(COL_FC9902B4_8859_4AF9_ADF1_99A2E15E5351#68819, CONST#68914 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_E1B5859E_D2C6_4F99_B80B_F17B551056F9#68929L], [COL_FC9902B4_8859_4AF9_ADF1_99A2E15E5351#68819], [CONST#68914 DESC NULLS LAST]
(21) Project
Arguments: [COL_19FBC2D6_FC49_4062_822A_242A41929E7D#68817, COL_085E93C6_B825_4DA8_8708_8D98C406324F#68818, COL_FC9902B4_8859_4AF9_ADF1_99A2E15E5351#68819, COL_9A5ACA40_F512_495A_9718_534E3BBBA5EE#68820, COL_822D1F41_6EAB_4525_8075_1BCA23137730#68821, COL_8E1D7833_6478_47C9_AF51_C374496B0CFF#68822, COL_84B2BFCE_5604_4B75_A7EA_82682A7D0210#68823, COL_42BBAE75_38D5_44F7_AA65_77D5EA8C5D8C#68831L, COL_F533C3E3_214A_45F3_B98F_9683DD01C84C#68840L, COL_B80CC574_7E7E_464D_90B8_5AFE7B1EA083#68850L, COL_81E443F6_8690_4169_A3FF_904877152479#68875, CONST#68914, COL_E1B5859E_D2C6_4F99_B80B_F17B551056F9#68929L, COL_E1B5859E_D2C6_4F99_B80B_F17B551056F9#68929L]
(22) Project
Arguments: [COL_19FBC2D6_FC49_4062_822A_242A41929E7D#68817, COL_085E93C6_B825_4DA8_8708_8D98C406324F#68818, COL_FC9902B4_8859_4AF9_ADF1_99A2E15E5351#68819, COL_9A5ACA40_F512_495A_9718_534E3BBBA5EE#68820, COL_822D1F41_6EAB_4525_8075_1BCA23137730#68821, COL_8E1D7833_6478_47C9_AF51_C374496B0CFF#68822, COL_84B2BFCE_5604_4B75_A7EA_82682A7D0210#68823, COL_42BBAE75_38D5_44F7_AA65_77D5EA8C5D8C#68831L, COL_F533C3E3_214A_45F3_B98F_9683DD01C84C#68840L, COL_B80CC574_7E7E_464D_90B8_5AFE7B1EA083#68850L, COL_81E443F6_8690_4169_A3FF_904877152479#68875, CONST#68914, COL_E1B5859E_D2C6_4F99_B80B_F17B551056F9#68929L]
(23) Project
Arguments: [COL_19FBC2D6_FC49_4062_822A_242A41929E7D#68817, COL_085E93C6_B825_4DA8_8708_8D98C406324F#68818, COL_FC9902B4_8859_4AF9_ADF1_99A2E15E5351#68819, COL_9A5ACA40_F512_495A_9718_534E3BBBA5EE#68820, COL_822D1F41_6EAB_4525_8075_1BCA23137730#68821, COL_8E1D7833_6478_47C9_AF51_C374496B0CFF#68822, COL_84B2BFCE_5604_4B75_A7EA_82682A7D0210#68823, COL_42BBAE75_38D5_44F7_AA65_77D5EA8C5D8C#68831L, COL_F533C3E3_214A_45F3_B98F_9683DD01C84C#68840L, COL_B80CC574_7E7E_464D_90B8_5AFE7B1EA083#68850L, COL_81E443F6_8690_4169_A3FF_904877152479#68875, COL_E1B5859E_D2C6_4F99_B80B_F17B551056F9#68929L]
(24) Project
Arguments: [COL_19FBC2D6_FC49_4062_822A_242A41929E7D#68817 AS COL_19FBC2D6_FC49_4062_822A_242A41929E7D#68983, COL_085E93C6_B825_4DA8_8708_8D98C406324F#68818 AS COL_085E93C6_B825_4DA8_8708_8D98C406324F#68984, COL_FC9902B4_8859_4AF9_ADF1_99A2E15E5351#68819 AS COL_FC9902B4_8859_4AF9_ADF1_99A2E15E5351#68985, COL_9A5ACA40_F512_495A_9718_534E3BBBA5EE#68820 AS COL_9A5ACA40_F512_495A_9718_534E3BBBA5EE#68986, COL_822D1F41_6EAB_4525_8075_1BCA23137730#68821 AS COL_822D1F41_6EAB_4525_8075_1BCA23137730#68987, COL_8E1D7833_6478_47C9_AF51_C374496B0CFF#68822 AS COL_8E1D7833_6478_47C9_AF51_C374496B0CFF#68988, COL_84B2BFCE_5604_4B75_A7EA_82682A7D0210#68823 AS COL_84B2BFCE_5604_4B75_A7EA_82682A7D0210#68989, COL_42BBAE75_38D5_44F7_AA65_77D5EA8C5D8C#68831L AS COL_42BBAE75_38D5_44F7_AA65_77D5EA8C5D8C#68990L, COL_F533C3E3_214A_45F3_B98F_9683DD01C84C#68840L AS COL_F533C3E3_214A_45F3_B98F_9683DD01C84C#68991L, COL_B80CC574_7E7E_464D_90B8_5AFE7B1EA083#68850L AS COL_B80CC574_7E7E_464D_90B8_5AFE7B1EA083#68992L, COL_81E443F6_8690_4169_A3FF_904877152479#68875 AS COL_81E443F6_8690_4169_A3FF_904877152479#68993, COL_E1B5859E_D2C6_4F99_B80B_F17B551056F9#68929L AS COL_E1B5859E_D2C6_4F99_B80B_F17B551056F9#68994L]
(25) Project
Arguments: [COL_19FBC2D6_FC49_4062_822A_242A41929E7D#68983 AS COL_19FBC2D6_FC49_4062_822A_242A41929E7D#69035, COL_085E93C6_B825_4DA8_8708_8D98C406324F#68984 AS COL_085E93C6_B825_4DA8_8708_8D98C406324F#69036, COL_FC9902B4_8859_4AF9_ADF1_99A2E15E5351#68985 AS COL_FC9902B4_8859_4AF9_ADF1_99A2E15E5351#69037, COL_9A5ACA40_F512_495A_9718_534E3BBBA5EE#68986 AS COL_9A5ACA40_F512_495A_9718_534E3BBBA5EE#69038, COL_822D1F41_6EAB_4525_8075_1BCA23137730#68987 AS COL_822D1F41_6EAB_4525_8075_1BCA23137730#69039, COL_8E1D7833_6478_47C9_AF51_C374496B0CFF#68988 AS COL_8E1D7833_6478_47C9_AF51_C374496B0CFF#69040, COL_84B2BFCE_5604_4B75_A7EA_82682A7D0210#68989 AS COL_84B2BFCE_5604_4B75_A7EA_82682A7D0210#69041, COL_42BBAE75_38D5_44F7_AA65_77D5EA8C5D8C#68990L AS COL_42BBAE75_38D5_44F7_AA65_77D5EA8C5D8C#69042L, COL_F533C3E3_214A_45F3_B98F_9683DD01C84C#68991L AS COL_F533C3E3_214A_45F3_B98F_9683DD01C84C#69043L, COL_B80CC574_7E7E_464D_90B8_5AFE7B1EA083#68992L AS COL_B80CC574_7E7E_464D_90B8_5AFE7B1EA083#69044L, COL_81E443F6_8690_4169_A3FF_904877152479#68993 AS COL_81E443F6_8690_4169_A3FF_904877152479#69045, COL_E1B5859E_D2C6_4F99_B80B_F17B551056F9#68994L AS COL_E1B5859E_D2C6_4F99_B80B_F17B551056F9#69046L]
(26) LogicalRelation
Arguments: JDBCRelation((SELECT RAWTOHEX(PATIENT_ID), "BIRTH_DATE", "GENDER", "PSEUDO", "INHOSPITAL_DEATH_DATE", "INHOSPITAL_DEATH_CODE", "DEATH_DATE", "EXTERNAL_DEATH_PROCESS_ID" FROM "DTM_622"."PATIENT") x) [numPartitions=1], [RAWTOHEX(PATIENT_ID)#68601, BIRTH_DATE#68602, GENDER#68603, PSEUDO#68604, INHOSPITAL_DEATH_DATE#68605, INHOSPITAL_DEATH_CODE#68606, DEATH_DATE#68607, EXTERNAL_DEATH_PROCESS_ID#68608], false
(27) Project
Arguments: [RAWTOHEX(PATIENT_ID)#68601 AS COLL0#68617, BIRTH_DATE#68602 AS COLL1#68618, GENDER#68603 AS COLL2#68619, PSEUDO#68604 AS COLL3#68620, INHOSPITAL_DEATH_DATE#68605 AS COLL4#68621, INHOSPITAL_DEATH_CODE#68606 AS COLL5#68622, DEATH_DATE#68607 AS COLL6#68623, EXTERNAL_DEATH_PROCESS_ID#68608 AS COLL7#68624]
(28) Project
Arguments: [COLL0#68617 AS COLL0#68633, COLL1#68618 AS COLL1#68634, COLL2#68619 AS COLL2#68635, COLL3#68620 AS COLL3#68636, COLL4#68621 AS COLL4#68637, COLL5#68622 AS COLL5#68638, COLL6#68623 AS COLL6#68639, COLL7#68624 AS COLL7#68640]
(29) Project
Arguments: [COLL0#68633, COLL1#68634, COLL2#68635, COLL3#68636, COLL4#68637, COLL5#68638, COLL6#68639, COLL7#68640]
(30) Project
Arguments: [COLL1#68634 AS BIRTH_DATE_3334#68657, COLL6#68639 AS DEATH_DATE_3339#68658, cast(COLL7#68640 as int) AS EXTERNAL_DEATH__3340#68659, COLL2#68635 AS GENDER_3335#68660, COLL4#68637 AS INHOSPITAL_DEAT_3337#68661, COLL5#68638 AS INHOSPITAL_DEAT_3338#68662, COLL0#68633 AS PATIENT_ID_3333#68663, COLL3#68636 AS PSEUDO_3336#68664]
(31) Project
Arguments: [BIRTH_DATE_3334#68657, DEATH_DATE_3339#68658, EXTERNAL_DEATH__3340#68659, GENDER_3335#68660, INHOSPITAL_DEAT_3337#68661, INHOSPITAL_DEAT_3338#68662, PATIENT_ID_3333#68663, PSEUDO_3336#68664]
(32) View
Arguments: `PATIENT_3332165`, true
(33) SubqueryAlias
Arguments: PATIENT_3332165
(34) Project
Arguments: [BIRTH_DATE_3334#68657 AS PATIENT_3332_BIRTH_DATE_3334#69087, DEATH_DATE_3339#68658 AS PATIENT_3332_DEATH_DATE_3339#69088, EXTERNAL_DEATH__3340#68659 AS PATIENT_3332_EXTERNAL_DEATH__3340#69089, GENDER_3335#68660 AS PATIENT_3332_GENDER_3335#69090, INHOSPITAL_DEAT_3337#68661 AS PATIENT_3332_INHOSPITAL_DEAT_3337#69091, INHOSPITAL_DEAT_3338#68662 AS PATIENT_3332_INHOSPITAL_DEAT_3338#69092, PATIENT_ID_3333#68663 AS PATIENT_3332_PATIENT_ID_3333#69093, PSEUDO_3336#68664 AS PATIENT_3332_PSEUDO_3336#69094]
(35) Join
Arguments: LeftOuter, (COL_FC9902B4_8859_4AF9_ADF1_99A2E15E5351#69037 = PATIENT_3332_PATIENT_ID_3333#69093)
(36) Project
Arguments: [COL_19FBC2D6_FC49_4062_822A_242A41929E7D#69035, COL_085E93C6_B825_4DA8_8708_8D98C406324F#69036, COL_FC9902B4_8859_4AF9_ADF1_99A2E15E5351#69037, COL_9A5ACA40_F512_495A_9718_534E3BBBA5EE#69038, COL_822D1F41_6EAB_4525_8075_1BCA23137730#69039, COL_8E1D7833_6478_47C9_AF51_C374496B0CFF#69040, COL_84B2BFCE_5604_4B75_A7EA_82682A7D0210#69041, COL_42BBAE75_38D5_44F7_AA65_77D5EA8C5D8C#69042L, COL_F533C3E3_214A_45F3_B98F_9683DD01C84C#69043L, COL_B80CC574_7E7E_464D_90B8_5AFE7B1EA083#69044L, COL_81E443F6_8690_4169_A3FF_904877152479#69045, COL_E1B5859E_D2C6_4F99_B80B_F17B551056F9#69046L, PATIENT_3332_BIRTH_DATE_3334#69087 AS COL_EE70CFCF_48AE_421B_B986_474C75240784#69180, PATIENT_3332_GENDER_3335#69090 AS COL_C19E44C6_621F_4783_82A1_307B3A5BA095#69181, PATIENT_3332_PSEUDO_3336#69094 AS COL_82F42988_9AB5_475F_98F4_C50AA08B4DD1#69182, PATIENT_3332_INHOSPITAL_DEAT_3337#69091 AS COL_1C8EA12E_41CE_4721_8B26_C38A9176A03B#69183, PATIENT_3332_DEATH_DATE_3339#69088 AS COL_0CC3E633_F8A0_4FB6_8585_A621BF2C008D#69184, PATIENT_3332_EXTERNAL_DEATH__3340#69089 AS COL_0B804298_EC9D_45F5_895B_D7E11A23A804#69185]
(37) Project
Arguments: [COL_19FBC2D6_FC49_4062_822A_242A41929E7D#69035 AS COL_19FBC2D6_FC49_4062_822A_242A41929E7D#69232, COL_085E93C6_B825_4DA8_8708_8D98C406324F#69036 AS COL_085E93C6_B825_4DA8_8708_8D98C406324F#69233, COL_FC9902B4_8859_4AF9_ADF1_99A2E15E5351#69037 AS COL_FC9902B4_8859_4AF9_ADF1_99A2E15E5351#69234, COL_9A5ACA40_F512_495A_9718_534E3BBBA5EE#69038 AS COL_9A5ACA40_F512_495A_9718_534E3BBBA5EE#69235, COL_822D1F41_6EAB_4525_8075_1BCA23137730#69039 AS COL_822D1F41_6EAB_4525_8075_1BCA23137730#69236, COL_8E1D7833_6478_47C9_AF51_C374496B0CFF#69040 AS COL_8E1D7833_6478_47C9_AF51_C374496B0CFF#69237, COL_84B2BFCE_5604_4B75_A7EA_82682A7D0210#69041 AS COL_84B2BFCE_5604_4B75_A7EA_82682A7D0210#69238, COL_42BBAE75_38D5_44F7_AA65_77D5EA8C5D8C#69042L AS COL_42BBAE75_38D5_44F7_AA65_77D5EA8C5D8C#69239L, COL_F533C3E3_214A_45F3_B98F_9683DD01C84C#69043L AS COL_F533C3E3_214A_45F3_B98F_9683DD01C84C#69240L, COL_B80CC574_7E7E_464D_90B8_5AFE7B1EA083#69044L AS COL_B80CC574_7E7E_464D_90B8_5AFE7B1EA083#69241L, COL_81E443F6_8690_4169_A3FF_904877152479#69045 AS COL_81E443F6_8690_4169_A3FF_904877152479#69242, COL_E1B5859E_D2C6_4F99_B80B_F17B551056F9#69046L AS COL_E1B5859E_D2C6_4F99_B80B_F17B551056F9#69243L, COL_EE70CFCF_48AE_421B_B986_474C75240784#69180 AS COL_EE70CFCF_48AE_421B_B986_474C75240784#69244, COL_C19E44C6_621F_4783_82A1_307B3A5BA095#69181 AS COL_C19E44C6_621F_4783_82A1_307B3A5BA095#69245, COL_1C8EA12E_41CE_4721_8B26_C38A9176A03B#69183 AS COL_1C8EA12E_41CE_4721_8B26_C38A9176A03B#69246, COL_0CC3E633_F8A0_4FB6_8585_A621BF2C008D#69184 AS COL_0CC3E633_F8A0_4FB6_8585_A621BF2C008D#69247, COL_82F42988_9AB5_475F_98F4_C50AA08B4DD1#69182 AS COL_82F42988_9AB5_475F_98F4_C50AA08B4DD1#69248, COL_0B804298_EC9D_45F5_895B_D7E11A23A804#69185 AS COL_0B804298_EC9D_45F5_895B_D7E11A23A804#69249]