== 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_3388163`, false, true, LocalTempView, true
(3) LogicalRelation
Arguments: parquet, [ACTIVITY_3362#70395, IN_DATE_3363#70396, OUT_DATE_3364#70397, PATIENT_ID_3360#70398, UNIT_3361#70399, VISIT_ID_3359#70400, VISIT_UNIT_ID_3358#70401], false
(4) View
Arguments: `VISIT_UNIT_3357163`, true
(5) SubqueryAlias
Arguments: VISIT_UNIT_3357163
(6) Project
Arguments: [ACTIVITY_3362#70395 AS VISIT_UNIT_3357_ACTIVITY_3362#70447, IN_DATE_3363#70396 AS VISIT_UNIT_3357_IN_DATE_3363#70448, OUT_DATE_3364#70397 AS VISIT_UNIT_3357_OUT_DATE_3364#70449, PATIENT_ID_3360#70398 AS VISIT_UNIT_3357_PATIENT_ID_3360#70450, UNIT_3361#70399 AS VISIT_UNIT_3357_UNIT_3361#70451, VISIT_ID_3359#70400 AS VISIT_UNIT_3357_VISIT_ID_3359#70452, VISIT_UNIT_ID_3358#70401 AS VISIT_UNIT_3357_VISIT_UNIT_ID_3358#70453]
(7) Project
Arguments: [cast(VISIT_UNIT_3357_VISIT_UNIT_ID_3358#70453 as string) AS COL_19FBC2D6_FC49_4062_822A_242A41929E7D#70478, cast(VISIT_UNIT_3357_VISIT_ID_3359#70452 as string) AS COL_085E93C6_B825_4DA8_8708_8D98C406324F#70479, cast(VISIT_UNIT_3357_PATIENT_ID_3360#70450 as string) AS COL_FC9902B4_8859_4AF9_ADF1_99A2E15E5351#70480, cast(VISIT_UNIT_3357_UNIT_3361#70451 as string) AS COL_9A5ACA40_F512_495A_9718_534E3BBBA5EE#70481, cast(VISIT_UNIT_3357_ACTIVITY_3362#70447 as string) AS COL_822D1F41_6EAB_4525_8075_1BCA23137730#70482, cast(VISIT_UNIT_3357_IN_DATE_3363#70448 as timestamp) AS COL_8E1D7833_6478_47C9_AF51_C374496B0CFF#70483, cast(VISIT_UNIT_3357_OUT_DATE_3364#70449 as timestamp) AS COL_84B2BFCE_5604_4B75_A7EA_82682A7D0210#70484]
(8) Project
Arguments: [COL_19FBC2D6_FC49_4062_822A_242A41929E7D#70478 AS COL_19FBC2D6_FC49_4062_822A_242A41929E7D#70502, COL_085E93C6_B825_4DA8_8708_8D98C406324F#70479 AS COL_085E93C6_B825_4DA8_8708_8D98C406324F#70503, COL_FC9902B4_8859_4AF9_ADF1_99A2E15E5351#70480 AS COL_FC9902B4_8859_4AF9_ADF1_99A2E15E5351#70504, COL_9A5ACA40_F512_495A_9718_534E3BBBA5EE#70481 AS COL_9A5ACA40_F512_495A_9718_534E3BBBA5EE#70505, COL_822D1F41_6EAB_4525_8075_1BCA23137730#70482 AS COL_822D1F41_6EAB_4525_8075_1BCA23137730#70506, COL_8E1D7833_6478_47C9_AF51_C374496B0CFF#70483 AS COL_8E1D7833_6478_47C9_AF51_C374496B0CFF#70507, COL_84B2BFCE_5604_4B75_A7EA_82682A7D0210#70484 AS COL_84B2BFCE_5604_4B75_A7EA_82682A7D0210#70508]
(9) Project
Arguments: [COL_19FBC2D6_FC49_4062_822A_242A41929E7D#70502, COL_085E93C6_B825_4DA8_8708_8D98C406324F#70503, COL_FC9902B4_8859_4AF9_ADF1_99A2E15E5351#70504, COL_9A5ACA40_F512_495A_9718_534E3BBBA5EE#70505, COL_822D1F41_6EAB_4525_8075_1BCA23137730#70506, COL_8E1D7833_6478_47C9_AF51_C374496B0CFF#70507, COL_84B2BFCE_5604_4B75_A7EA_82682A7D0210#70508, date_diff(cast(HOUR as string), COL_84B2BFCE_5604_4B75_A7EA_82682A7D0210#70508, COL_8E1D7833_6478_47C9_AF51_C374496B0CFF#70507) AS COL_42BBAE75_38D5_44F7_AA65_77D5EA8C5D8C#70529L]
(10) Project
Arguments: [COL_19FBC2D6_FC49_4062_822A_242A41929E7D#70502, COL_085E93C6_B825_4DA8_8708_8D98C406324F#70503, COL_FC9902B4_8859_4AF9_ADF1_99A2E15E5351#70504, COL_9A5ACA40_F512_495A_9718_534E3BBBA5EE#70505, COL_822D1F41_6EAB_4525_8075_1BCA23137730#70506, COL_8E1D7833_6478_47C9_AF51_C374496B0CFF#70507, COL_84B2BFCE_5604_4B75_A7EA_82682A7D0210#70508, COL_42BBAE75_38D5_44F7_AA65_77D5EA8C5D8C#70529L, date_diff(cast(DAY as string), COL_84B2BFCE_5604_4B75_A7EA_82682A7D0210#70508, COL_8E1D7833_6478_47C9_AF51_C374496B0CFF#70507) AS COL_F533C3E3_214A_45F3_B98F_9683DD01C84C#70540L]
(11) Project
Arguments: [COL_19FBC2D6_FC49_4062_822A_242A41929E7D#70502, COL_085E93C6_B825_4DA8_8708_8D98C406324F#70503, COL_FC9902B4_8859_4AF9_ADF1_99A2E15E5351#70504, COL_9A5ACA40_F512_495A_9718_534E3BBBA5EE#70505, COL_822D1F41_6EAB_4525_8075_1BCA23137730#70506, COL_8E1D7833_6478_47C9_AF51_C374496B0CFF#70507, COL_84B2BFCE_5604_4B75_A7EA_82682A7D0210#70508, COL_42BBAE75_38D5_44F7_AA65_77D5EA8C5D8C#70529L, COL_F533C3E3_214A_45F3_B98F_9683DD01C84C#70540L, date_diff(cast(MINUTE as string), COL_84B2BFCE_5604_4B75_A7EA_82682A7D0210#70508, COL_8E1D7833_6478_47C9_AF51_C374496B0CFF#70507) AS COL_B80CC574_7E7E_464D_90B8_5AFE7B1EA083#70562L]
(12) Project
Arguments: [COL_19FBC2D6_FC49_4062_822A_242A41929E7D#70502, COL_085E93C6_B825_4DA8_8708_8D98C406324F#70503, COL_FC9902B4_8859_4AF9_ADF1_99A2E15E5351#70504, COL_9A5ACA40_F512_495A_9718_534E3BBBA5EE#70505, COL_822D1F41_6EAB_4525_8075_1BCA23137730#70506, COL_8E1D7833_6478_47C9_AF51_C374496B0CFF#70507, COL_84B2BFCE_5604_4B75_A7EA_82682A7D0210#70508, COL_42BBAE75_38D5_44F7_AA65_77D5EA8C5D8C#70529L, COL_F533C3E3_214A_45F3_B98F_9683DD01C84C#70540L, COL_B80CC574_7E7E_464D_90B8_5AFE7B1EA083#70562L, 1 AS CONST#70587]
(13) Project
Arguments: [COL_19FBC2D6_FC49_4062_822A_242A41929E7D#70502, COL_085E93C6_B825_4DA8_8708_8D98C406324F#70503, COL_FC9902B4_8859_4AF9_ADF1_99A2E15E5351#70504, COL_9A5ACA40_F512_495A_9718_534E3BBBA5EE#70505, COL_822D1F41_6EAB_4525_8075_1BCA23137730#70506, COL_8E1D7833_6478_47C9_AF51_C374496B0CFF#70507, COL_84B2BFCE_5604_4B75_A7EA_82682A7D0210#70508, COL_42BBAE75_38D5_44F7_AA65_77D5EA8C5D8C#70529L, COL_F533C3E3_214A_45F3_B98F_9683DD01C84C#70540L, COL_B80CC574_7E7E_464D_90B8_5AFE7B1EA083#70562L, CONST#70587]
(14) Window
Arguments: [row_number() windowspecdefinition(COL_FC9902B4_8859_4AF9_ADF1_99A2E15E5351#70504, CONST#70587 DESC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_81E443F6_8690_4169_A3FF_904877152479#70613], [COL_FC9902B4_8859_4AF9_ADF1_99A2E15E5351#70504], [CONST#70587 DESC NULLS LAST]
(15) Project
Arguments: [COL_19FBC2D6_FC49_4062_822A_242A41929E7D#70502, COL_085E93C6_B825_4DA8_8708_8D98C406324F#70503, COL_FC9902B4_8859_4AF9_ADF1_99A2E15E5351#70504, COL_9A5ACA40_F512_495A_9718_534E3BBBA5EE#70505, COL_822D1F41_6EAB_4525_8075_1BCA23137730#70506, COL_8E1D7833_6478_47C9_AF51_C374496B0CFF#70507, COL_84B2BFCE_5604_4B75_A7EA_82682A7D0210#70508, COL_42BBAE75_38D5_44F7_AA65_77D5EA8C5D8C#70529L, COL_F533C3E3_214A_45F3_B98F_9683DD01C84C#70540L, COL_B80CC574_7E7E_464D_90B8_5AFE7B1EA083#70562L, CONST#70587, COL_81E443F6_8690_4169_A3FF_904877152479#70613, COL_81E443F6_8690_4169_A3FF_904877152479#70613]
(16) Project
Arguments: [COL_19FBC2D6_FC49_4062_822A_242A41929E7D#70502, COL_085E93C6_B825_4DA8_8708_8D98C406324F#70503, COL_FC9902B4_8859_4AF9_ADF1_99A2E15E5351#70504, COL_9A5ACA40_F512_495A_9718_534E3BBBA5EE#70505, COL_822D1F41_6EAB_4525_8075_1BCA23137730#70506, COL_8E1D7833_6478_47C9_AF51_C374496B0CFF#70507, COL_84B2BFCE_5604_4B75_A7EA_82682A7D0210#70508, COL_42BBAE75_38D5_44F7_AA65_77D5EA8C5D8C#70529L, COL_F533C3E3_214A_45F3_B98F_9683DD01C84C#70540L, COL_B80CC574_7E7E_464D_90B8_5AFE7B1EA083#70562L, CONST#70587, COL_81E443F6_8690_4169_A3FF_904877152479#70613]
(17) Project
Arguments: [COL_19FBC2D6_FC49_4062_822A_242A41929E7D#70502, COL_085E93C6_B825_4DA8_8708_8D98C406324F#70503, COL_FC9902B4_8859_4AF9_ADF1_99A2E15E5351#70504, COL_9A5ACA40_F512_495A_9718_534E3BBBA5EE#70505, COL_822D1F41_6EAB_4525_8075_1BCA23137730#70506, COL_8E1D7833_6478_47C9_AF51_C374496B0CFF#70507, COL_84B2BFCE_5604_4B75_A7EA_82682A7D0210#70508, COL_42BBAE75_38D5_44F7_AA65_77D5EA8C5D8C#70529L, COL_F533C3E3_214A_45F3_B98F_9683DD01C84C#70540L, COL_B80CC574_7E7E_464D_90B8_5AFE7B1EA083#70562L, COL_81E443F6_8690_4169_A3FF_904877152479#70613]
(18) Project
Arguments: [COL_19FBC2D6_FC49_4062_822A_242A41929E7D#70502, COL_085E93C6_B825_4DA8_8708_8D98C406324F#70503, COL_FC9902B4_8859_4AF9_ADF1_99A2E15E5351#70504, COL_9A5ACA40_F512_495A_9718_534E3BBBA5EE#70505, COL_822D1F41_6EAB_4525_8075_1BCA23137730#70506, COL_8E1D7833_6478_47C9_AF51_C374496B0CFF#70507, COL_84B2BFCE_5604_4B75_A7EA_82682A7D0210#70508, COL_42BBAE75_38D5_44F7_AA65_77D5EA8C5D8C#70529L, COL_F533C3E3_214A_45F3_B98F_9683DD01C84C#70540L, COL_B80CC574_7E7E_464D_90B8_5AFE7B1EA083#70562L, COL_81E443F6_8690_4169_A3FF_904877152479#70613, 1 AS CONST#70653]
(19) Project
Arguments: [COL_19FBC2D6_FC49_4062_822A_242A41929E7D#70502, COL_085E93C6_B825_4DA8_8708_8D98C406324F#70503, COL_FC9902B4_8859_4AF9_ADF1_99A2E15E5351#70504, COL_9A5ACA40_F512_495A_9718_534E3BBBA5EE#70505, COL_822D1F41_6EAB_4525_8075_1BCA23137730#70506, COL_8E1D7833_6478_47C9_AF51_C374496B0CFF#70507, COL_84B2BFCE_5604_4B75_A7EA_82682A7D0210#70508, COL_42BBAE75_38D5_44F7_AA65_77D5EA8C5D8C#70529L, COL_F533C3E3_214A_45F3_B98F_9683DD01C84C#70540L, COL_B80CC574_7E7E_464D_90B8_5AFE7B1EA083#70562L, COL_81E443F6_8690_4169_A3FF_904877152479#70613, CONST#70653]
(20) Window
Arguments: [count(1) windowspecdefinition(COL_FC9902B4_8859_4AF9_ADF1_99A2E15E5351#70504, CONST#70653 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_E1B5859E_D2C6_4F99_B80B_F17B551056F9#70692L], [COL_FC9902B4_8859_4AF9_ADF1_99A2E15E5351#70504], [CONST#70653 DESC NULLS LAST]
(21) Project
Arguments: [COL_19FBC2D6_FC49_4062_822A_242A41929E7D#70502, COL_085E93C6_B825_4DA8_8708_8D98C406324F#70503, COL_FC9902B4_8859_4AF9_ADF1_99A2E15E5351#70504, COL_9A5ACA40_F512_495A_9718_534E3BBBA5EE#70505, COL_822D1F41_6EAB_4525_8075_1BCA23137730#70506, COL_8E1D7833_6478_47C9_AF51_C374496B0CFF#70507, COL_84B2BFCE_5604_4B75_A7EA_82682A7D0210#70508, COL_42BBAE75_38D5_44F7_AA65_77D5EA8C5D8C#70529L, COL_F533C3E3_214A_45F3_B98F_9683DD01C84C#70540L, COL_B80CC574_7E7E_464D_90B8_5AFE7B1EA083#70562L, COL_81E443F6_8690_4169_A3FF_904877152479#70613, CONST#70653, COL_E1B5859E_D2C6_4F99_B80B_F17B551056F9#70692L, COL_E1B5859E_D2C6_4F99_B80B_F17B551056F9#70692L]
(22) Project
Arguments: [COL_19FBC2D6_FC49_4062_822A_242A41929E7D#70502, COL_085E93C6_B825_4DA8_8708_8D98C406324F#70503, COL_FC9902B4_8859_4AF9_ADF1_99A2E15E5351#70504, COL_9A5ACA40_F512_495A_9718_534E3BBBA5EE#70505, COL_822D1F41_6EAB_4525_8075_1BCA23137730#70506, COL_8E1D7833_6478_47C9_AF51_C374496B0CFF#70507, COL_84B2BFCE_5604_4B75_A7EA_82682A7D0210#70508, COL_42BBAE75_38D5_44F7_AA65_77D5EA8C5D8C#70529L, COL_F533C3E3_214A_45F3_B98F_9683DD01C84C#70540L, COL_B80CC574_7E7E_464D_90B8_5AFE7B1EA083#70562L, COL_81E443F6_8690_4169_A3FF_904877152479#70613, CONST#70653, COL_E1B5859E_D2C6_4F99_B80B_F17B551056F9#70692L]
(23) Project
Arguments: [COL_19FBC2D6_FC49_4062_822A_242A41929E7D#70502, COL_085E93C6_B825_4DA8_8708_8D98C406324F#70503, COL_FC9902B4_8859_4AF9_ADF1_99A2E15E5351#70504, COL_9A5ACA40_F512_495A_9718_534E3BBBA5EE#70505, COL_822D1F41_6EAB_4525_8075_1BCA23137730#70506, COL_8E1D7833_6478_47C9_AF51_C374496B0CFF#70507, COL_84B2BFCE_5604_4B75_A7EA_82682A7D0210#70508, COL_42BBAE75_38D5_44F7_AA65_77D5EA8C5D8C#70529L, COL_F533C3E3_214A_45F3_B98F_9683DD01C84C#70540L, COL_B80CC574_7E7E_464D_90B8_5AFE7B1EA083#70562L, COL_81E443F6_8690_4169_A3FF_904877152479#70613, COL_E1B5859E_D2C6_4F99_B80B_F17B551056F9#70692L]
(24) Project
Arguments: [COL_19FBC2D6_FC49_4062_822A_242A41929E7D#70502 AS COL_19FBC2D6_FC49_4062_822A_242A41929E7D#70754, COL_085E93C6_B825_4DA8_8708_8D98C406324F#70503 AS COL_085E93C6_B825_4DA8_8708_8D98C406324F#70755, COL_FC9902B4_8859_4AF9_ADF1_99A2E15E5351#70504 AS COL_FC9902B4_8859_4AF9_ADF1_99A2E15E5351#70756, COL_9A5ACA40_F512_495A_9718_534E3BBBA5EE#70505 AS COL_9A5ACA40_F512_495A_9718_534E3BBBA5EE#70757, COL_822D1F41_6EAB_4525_8075_1BCA23137730#70506 AS COL_822D1F41_6EAB_4525_8075_1BCA23137730#70758, COL_8E1D7833_6478_47C9_AF51_C374496B0CFF#70507 AS COL_8E1D7833_6478_47C9_AF51_C374496B0CFF#70759, COL_84B2BFCE_5604_4B75_A7EA_82682A7D0210#70508 AS COL_84B2BFCE_5604_4B75_A7EA_82682A7D0210#70760, COL_42BBAE75_38D5_44F7_AA65_77D5EA8C5D8C#70529L AS COL_42BBAE75_38D5_44F7_AA65_77D5EA8C5D8C#70761L, COL_F533C3E3_214A_45F3_B98F_9683DD01C84C#70540L AS COL_F533C3E3_214A_45F3_B98F_9683DD01C84C#70762L, COL_B80CC574_7E7E_464D_90B8_5AFE7B1EA083#70562L AS COL_B80CC574_7E7E_464D_90B8_5AFE7B1EA083#70763L, COL_81E443F6_8690_4169_A3FF_904877152479#70613 AS COL_81E443F6_8690_4169_A3FF_904877152479#70764, COL_E1B5859E_D2C6_4F99_B80B_F17B551056F9#70692L AS COL_E1B5859E_D2C6_4F99_B80B_F17B551056F9#70765L]
(25) Project
Arguments: [COL_19FBC2D6_FC49_4062_822A_242A41929E7D#70754 AS COL_19FBC2D6_FC49_4062_822A_242A41929E7D#70802, COL_085E93C6_B825_4DA8_8708_8D98C406324F#70755 AS COL_085E93C6_B825_4DA8_8708_8D98C406324F#70803, COL_FC9902B4_8859_4AF9_ADF1_99A2E15E5351#70756 AS COL_FC9902B4_8859_4AF9_ADF1_99A2E15E5351#70804, COL_9A5ACA40_F512_495A_9718_534E3BBBA5EE#70757 AS COL_9A5ACA40_F512_495A_9718_534E3BBBA5EE#70805, COL_822D1F41_6EAB_4525_8075_1BCA23137730#70758 AS COL_822D1F41_6EAB_4525_8075_1BCA23137730#70806, COL_8E1D7833_6478_47C9_AF51_C374496B0CFF#70759 AS COL_8E1D7833_6478_47C9_AF51_C374496B0CFF#70807, COL_84B2BFCE_5604_4B75_A7EA_82682A7D0210#70760 AS COL_84B2BFCE_5604_4B75_A7EA_82682A7D0210#70808, COL_42BBAE75_38D5_44F7_AA65_77D5EA8C5D8C#70761L AS COL_42BBAE75_38D5_44F7_AA65_77D5EA8C5D8C#70809L, COL_F533C3E3_214A_45F3_B98F_9683DD01C84C#70762L AS COL_F533C3E3_214A_45F3_B98F_9683DD01C84C#70810L, COL_B80CC574_7E7E_464D_90B8_5AFE7B1EA083#70763L AS COL_B80CC574_7E7E_464D_90B8_5AFE7B1EA083#70811L, COL_81E443F6_8690_4169_A3FF_904877152479#70764 AS COL_81E443F6_8690_4169_A3FF_904877152479#70812, COL_E1B5859E_D2C6_4F99_B80B_F17B551056F9#70765L AS COL_E1B5859E_D2C6_4F99_B80B_F17B551056F9#70813L]
(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)#70194, BIRTH_DATE#70195, GENDER#70196, PSEUDO#70197, INHOSPITAL_DEATH_DATE#70198, INHOSPITAL_DEATH_CODE#70199, DEATH_DATE#70200, EXTERNAL_DEATH_PROCESS_ID#70201], false
(27) Project
Arguments: [RAWTOHEX(PATIENT_ID)#70194 AS COLL0#70218, BIRTH_DATE#70195 AS COLL1#70221, GENDER#70196 AS COLL2#70223, PSEUDO#70197 AS COLL3#70225, INHOSPITAL_DEATH_DATE#70198 AS COLL4#70227, INHOSPITAL_DEATH_CODE#70199 AS COLL5#70229, DEATH_DATE#70200 AS COLL6#70231, EXTERNAL_DEATH_PROCESS_ID#70201 AS COLL7#70233]
(28) Project
Arguments: [COLL0#70218 AS COLL0#70251, COLL1#70221 AS COLL1#70252, COLL2#70223 AS COLL2#70254, COLL3#70225 AS COLL3#70256, COLL4#70227 AS COLL4#70258, COLL5#70229 AS COLL5#70260, COLL6#70231 AS COLL6#70262, COLL7#70233 AS COLL7#70264]
(29) Project
Arguments: [COLL0#70251, COLL1#70252, COLL2#70254, COLL3#70256, COLL4#70258, COLL5#70260, COLL6#70262, COLL7#70264]
(30) Project
Arguments: [COLL1#70252 AS BIRTH_DATE_3334#70300, COLL6#70262 AS DEATH_DATE_3339#70301, cast(COLL7#70264 as int) AS EXTERNAL_DEATH__3340#70304, COLL2#70254 AS GENDER_3335#70305, COLL4#70258 AS INHOSPITAL_DEAT_3337#70306, COLL5#70260 AS INHOSPITAL_DEAT_3338#70309, COLL0#70251 AS PATIENT_ID_3333#70311, COLL3#70256 AS PSEUDO_3336#70313]
(31) Project
Arguments: [BIRTH_DATE_3334#70300, DEATH_DATE_3339#70301, EXTERNAL_DEATH__3340#70304, GENDER_3335#70305, INHOSPITAL_DEAT_3337#70306, INHOSPITAL_DEAT_3338#70309, PATIENT_ID_3333#70311, PSEUDO_3336#70313]
(32) View
Arguments: `PATIENT_3332163`, true
(33) SubqueryAlias
Arguments: PATIENT_3332163
(34) Project
Arguments: [BIRTH_DATE_3334#70300 AS PATIENT_3332_BIRTH_DATE_3334#70874, DEATH_DATE_3339#70301 AS PATIENT_3332_DEATH_DATE_3339#70875, EXTERNAL_DEATH__3340#70304 AS PATIENT_3332_EXTERNAL_DEATH__3340#70876, GENDER_3335#70305 AS PATIENT_3332_GENDER_3335#70877, INHOSPITAL_DEAT_3337#70306 AS PATIENT_3332_INHOSPITAL_DEAT_3337#70878, INHOSPITAL_DEAT_3338#70309 AS PATIENT_3332_INHOSPITAL_DEAT_3338#70879, PATIENT_ID_3333#70311 AS PATIENT_3332_PATIENT_ID_3333#70880, PSEUDO_3336#70313 AS PATIENT_3332_PSEUDO_3336#70881]
(35) Join
Arguments: LeftOuter, (COL_FC9902B4_8859_4AF9_ADF1_99A2E15E5351#70804 = PATIENT_3332_PATIENT_ID_3333#70880)
(36) Project
Arguments: [COL_19FBC2D6_FC49_4062_822A_242A41929E7D#70802, COL_085E93C6_B825_4DA8_8708_8D98C406324F#70803, COL_FC9902B4_8859_4AF9_ADF1_99A2E15E5351#70804, COL_9A5ACA40_F512_495A_9718_534E3BBBA5EE#70805, COL_822D1F41_6EAB_4525_8075_1BCA23137730#70806, COL_8E1D7833_6478_47C9_AF51_C374496B0CFF#70807, COL_84B2BFCE_5604_4B75_A7EA_82682A7D0210#70808, COL_42BBAE75_38D5_44F7_AA65_77D5EA8C5D8C#70809L, COL_F533C3E3_214A_45F3_B98F_9683DD01C84C#70810L, COL_B80CC574_7E7E_464D_90B8_5AFE7B1EA083#70811L, COL_81E443F6_8690_4169_A3FF_904877152479#70812, COL_E1B5859E_D2C6_4F99_B80B_F17B551056F9#70813L, PATIENT_3332_BIRTH_DATE_3334#70874 AS COL_EE70CFCF_48AE_421B_B986_474C75240784#70972, PATIENT_3332_GENDER_3335#70877 AS COL_C19E44C6_621F_4783_82A1_307B3A5BA095#70973, PATIENT_3332_PSEUDO_3336#70881 AS COL_82F42988_9AB5_475F_98F4_C50AA08B4DD1#70974, PATIENT_3332_INHOSPITAL_DEAT_3337#70878 AS COL_1C8EA12E_41CE_4721_8B26_C38A9176A03B#70975, PATIENT_3332_DEATH_DATE_3339#70875 AS COL_0CC3E633_F8A0_4FB6_8585_A621BF2C008D#70976, PATIENT_3332_EXTERNAL_DEATH__3340#70876 AS COL_0B804298_EC9D_45F5_895B_D7E11A23A804#70977]
(37) Project
Arguments: [COL_19FBC2D6_FC49_4062_822A_242A41929E7D#70802 AS COL_19FBC2D6_FC49_4062_822A_242A41929E7D#71014, COL_085E93C6_B825_4DA8_8708_8D98C406324F#70803 AS COL_085E93C6_B825_4DA8_8708_8D98C406324F#71015, COL_FC9902B4_8859_4AF9_ADF1_99A2E15E5351#70804 AS COL_FC9902B4_8859_4AF9_ADF1_99A2E15E5351#71016, COL_9A5ACA40_F512_495A_9718_534E3BBBA5EE#70805 AS COL_9A5ACA40_F512_495A_9718_534E3BBBA5EE#71017, COL_822D1F41_6EAB_4525_8075_1BCA23137730#70806 AS COL_822D1F41_6EAB_4525_8075_1BCA23137730#71018, COL_8E1D7833_6478_47C9_AF51_C374496B0CFF#70807 AS COL_8E1D7833_6478_47C9_AF51_C374496B0CFF#71019, COL_84B2BFCE_5604_4B75_A7EA_82682A7D0210#70808 AS COL_84B2BFCE_5604_4B75_A7EA_82682A7D0210#71020, COL_42BBAE75_38D5_44F7_AA65_77D5EA8C5D8C#70809L AS COL_42BBAE75_38D5_44F7_AA65_77D5EA8C5D8C#71021L, COL_F533C3E3_214A_45F3_B98F_9683DD01C84C#70810L AS COL_F533C3E3_214A_45F3_B98F_9683DD01C84C#71022L, COL_B80CC574_7E7E_464D_90B8_5AFE7B1EA083#70811L AS COL_B80CC574_7E7E_464D_90B8_5AFE7B1EA083#71023L, COL_81E443F6_8690_4169_A3FF_904877152479#70812 AS COL_81E443F6_8690_4169_A3FF_904877152479#71024, COL_E1B5859E_D2C6_4F99_B80B_F17B551056F9#70813L AS COL_E1B5859E_D2C6_4F99_B80B_F17B551056F9#71025L, COL_EE70CFCF_48AE_421B_B986_474C75240784#70972 AS COL_EE70CFCF_48AE_421B_B986_474C75240784#71026, COL_C19E44C6_621F_4783_82A1_307B3A5BA095#70973 AS COL_C19E44C6_621F_4783_82A1_307B3A5BA095#71027, COL_1C8EA12E_41CE_4721_8B26_C38A9176A03B#70975 AS COL_1C8EA12E_41CE_4721_8B26_C38A9176A03B#71028, COL_0CC3E633_F8A0_4FB6_8585_A621BF2C008D#70976 AS COL_0CC3E633_F8A0_4FB6_8585_A621BF2C008D#71029, COL_82F42988_9AB5_475F_98F4_C50AA08B4DD1#70974 AS COL_82F42988_9AB5_475F_98F4_C50AA08B4DD1#71030, COL_0B804298_EC9D_45F5_895B_D7E11A23A804#70977 AS COL_0B804298_EC9D_45F5_895B_D7E11A23A804#71031]