== Physical Plan ==
Execute CreateViewCommand (1)
+- CreateViewCommand (2)
+- Project (16)
+- Project (15)
+- Project (14)
+- Project (13)
+- Project (12)
+- SubqueryAlias (11)
+- View (10)
+- Project (9)
+- Project (8)
+- Project (7)
+- Project (6)
+- Project (5)
+- Project (4)
+- LogicalRelation (3)
(1) Execute CreateViewCommand
Output: []
(2) CreateViewCommand
Arguments: `VISIT_3399161`, false, true, LocalTempView, true
(3) LogicalRelation
Arguments: JDBCRelation((SELECT RAWTOHEX(VISIT_ID), RAWTOHEX(PATIENT_ID), "IN_DATE", "OUT_DATE", "IN_MODE", "OUT_MODE", "IN_UNIT", "OUT_UNIT", "VISIT_TYPE", "CHAMP_PMSI", "UNIT_PATH", "EMERGENCY", "CANCELED" FROM "DTM_622"."VISIT") x) [numPartitions=1], [RAWTOHEX(VISIT_ID)#110536, RAWTOHEX(PATIENT_ID)#110537, IN_DATE#110538, OUT_DATE#110539, IN_MODE#110540, OUT_MODE#110541, IN_UNIT#110542, OUT_UNIT#110543, VISIT_TYPE#110544, CHAMP_PMSI#110545, UNIT_PATH#110546, EMERGENCY#110547, CANCELED#110548], false
(4) Project
Arguments: [RAWTOHEX(VISIT_ID)#110536, RAWTOHEX(PATIENT_ID)#110537, IN_DATE#110538, OUT_DATE#110539, IN_MODE#110540, OUT_MODE#110541, IN_UNIT#110542, OUT_UNIT#110543, VISIT_TYPE#110544, CHAMP_PMSI#110545, UNIT_PATH#110546, staticinvoke(class org.apache.spark.sql.catalyst.util.CharVarcharCodegenUtils, StringType, readSidePadding, EMERGENCY#110547, 1, true, false, true) AS EMERGENCY#110549, CANCELED#110548]
(5) Project
Arguments: [RAWTOHEX(VISIT_ID)#110536 AS COLL0#110563, RAWTOHEX(PATIENT_ID)#110537 AS COLL1#110564, IN_DATE#110538 AS COLL2#110565, OUT_DATE#110539 AS COLL3#110566, IN_MODE#110540 AS COLL4#110567, OUT_MODE#110541 AS COLL5#110568, IN_UNIT#110542 AS COLL6#110569, OUT_UNIT#110543 AS COLL7#110570, VISIT_TYPE#110544 AS COLL8#110571, CHAMP_PMSI#110545 AS COLL9#110572, UNIT_PATH#110546 AS COLL10#110573, EMERGENCY#110549 AS COLL11#110574, CANCELED#110548 AS COLL12#110575]
(6) Project
Arguments: [COLL0#110563 AS COLL0#110589, COLL1#110564 AS COLL1#110590, COLL2#110565 AS COLL2#110591, COLL3#110566 AS COLL3#110592, COLL4#110567 AS COLL4#110593, COLL5#110568 AS COLL5#110594, COLL6#110569 AS COLL6#110595, COLL7#110570 AS COLL7#110596, COLL8#110571 AS COLL8#110597, COLL9#110572 AS COLL9#110598, COLL10#110573 AS COLL10#110599, COLL11#110574 AS COLL11#110600, COLL12#110575 AS COLL12#110601]
(7) Project
Arguments: [COLL0#110589, COLL1#110590, COLL2#110591, COLL3#110592, COLL4#110593, COLL5#110594, COLL6#110595, COLL7#110596, COLL8#110597, COLL9#110598, COLL10#110599, COLL11#110600, COLL12#110601]
(8) Project
Arguments: [cast(COLL12#110601 as int) AS CANCELED_3355#110628, COLL9#110598 AS CHAMP_PMSI_3352#110629, COLL11#110600 AS EMERGENCY_3354#110630, COLL2#110591 AS IN_DATE_3345#110631, COLL4#110593 AS IN_MODE_3347#110632, COLL6#110595 AS IN_UNIT_3349#110633, COLL3#110592 AS OUT_DATE_3346#110634, COLL5#110594 AS OUT_MODE_3348#110635, COLL7#110596 AS OUT_UNIT_3350#110636, COLL1#110590 AS PATIENT_ID_3344#110637, COLL10#110599 AS UNIT_PATH_3353#110638, COLL0#110589 AS VISIT_ID_3343#110639, COLL8#110597 AS VISIT_TYPE_3351#110640]
(9) Project
Arguments: [CANCELED_3355#110628, CHAMP_PMSI_3352#110629, EMERGENCY_3354#110630, IN_DATE_3345#110631, IN_MODE_3347#110632, IN_UNIT_3349#110633, OUT_DATE_3346#110634, OUT_MODE_3348#110635, OUT_UNIT_3350#110636, PATIENT_ID_3344#110637, UNIT_PATH_3353#110638, VISIT_ID_3343#110639, VISIT_TYPE_3351#110640, str_encrypt(VISIT_ID_3343#110639) AS ENCRYPT_3536#110654]
(10) View
Arguments: `VISIT_3342161`, true
(11) SubqueryAlias
Arguments: VISIT_3342161
(12) Project
Arguments: [CANCELED_3355#110628 AS VISIT_3342_CANCELED_3355#110683, CHAMP_PMSI_3352#110629 AS VISIT_3342_CHAMP_PMSI_3352#110684, EMERGENCY_3354#110630 AS VISIT_3342_EMERGENCY_3354#110685, IN_DATE_3345#110631 AS VISIT_3342_IN_DATE_3345#110686, IN_MODE_3347#110632 AS VISIT_3342_IN_MODE_3347#110687, IN_UNIT_3349#110633 AS VISIT_3342_IN_UNIT_3349#110688, OUT_DATE_3346#110634 AS VISIT_3342_OUT_DATE_3346#110689, OUT_MODE_3348#110635 AS VISIT_3342_OUT_MODE_3348#110690, OUT_UNIT_3350#110636 AS VISIT_3342_OUT_UNIT_3350#110691, PATIENT_ID_3344#110637 AS VISIT_3342_PATIENT_ID_3344#110692, UNIT_PATH_3353#110638 AS VISIT_3342_UNIT_PATH_3353#110693, VISIT_ID_3343#110639 AS VISIT_3342_VISIT_ID_3343#110694, VISIT_TYPE_3351#110640 AS VISIT_3342_VISIT_TYPE_3351#110695, ENCRYPT_3536#110654 AS VISIT_3342_ENCRYPT_3536#110696]
(13) Project
Arguments: [cast(VISIT_3342_VISIT_ID_3343#110694 as string) AS COL_EEA9697B_DB68_4A22_8733_70F35E85FA8C#110724, cast(VISIT_3342_PATIENT_ID_3344#110692 as string) AS COL_8859F9BF_E9D0_49C6_AD56_9C140D4C38A1#110725, cast(VISIT_3342_IN_DATE_3345#110686 as timestamp) AS COL_AA4B3BC4_44A1_47D3_AC4B_C41D5CB3B3E9#110726, cast(VISIT_3342_OUT_DATE_3346#110689 as timestamp) AS COL_F89F7AFE_9225_468C_A09B_7E0D4F0CD71B#110727, cast(VISIT_3342_IN_MODE_3347#110687 as string) AS COL_058F9F93_2D83_40ED_B3F6_4CAE6CD3C909#110728, cast(VISIT_3342_OUT_MODE_3348#110690 as string) AS COL_6514FE18_2F15_46F7_BE9B_8C8A1CDED5B0#110729, cast(VISIT_3342_IN_UNIT_3349#110688 as string) AS COL_0C85CE96_902F_49B0_8699_B1D8041E9741#110730, cast(VISIT_3342_OUT_UNIT_3350#110691 as string) AS COL_93D07A84_DAB1_4601_8776_58638D68C63B#110731, cast(VISIT_3342_VISIT_TYPE_3351#110695 as string) AS COL_69F7D2CB_3582_450F_B81C_F35E14BD2F3A#110732, cast(VISIT_3342_CHAMP_PMSI_3352#110684 as string) AS COL_8DD6299D_F88E_4923_BA4A_AA5963BBA243#110733, cast(VISIT_3342_UNIT_PATH_3353#110693 as string) AS COL_8F292832_9A81_4CB6_A3E8_AAF5E0E2B9D1#110734, cast(VISIT_3342_EMERGENCY_3354#110685 as string) AS COL_119B8687_79BA_47AC_A253_99B3F514F94F#110735, cast(VISIT_3342_CANCELED_3355#110683 as int) AS COL_7A51C905_886C_4162_94AE_BCBA7820952A#110736]
(14) Project
Arguments: [COL_EEA9697B_DB68_4A22_8733_70F35E85FA8C#110724 AS COL_EEA9697B_DB68_4A22_8733_70F35E85FA8C#110750, COL_8859F9BF_E9D0_49C6_AD56_9C140D4C38A1#110725 AS COL_8859F9BF_E9D0_49C6_AD56_9C140D4C38A1#110751, COL_AA4B3BC4_44A1_47D3_AC4B_C41D5CB3B3E9#110726 AS COL_AA4B3BC4_44A1_47D3_AC4B_C41D5CB3B3E9#110752, COL_F89F7AFE_9225_468C_A09B_7E0D4F0CD71B#110727 AS COL_F89F7AFE_9225_468C_A09B_7E0D4F0CD71B#110753, COL_058F9F93_2D83_40ED_B3F6_4CAE6CD3C909#110728 AS COL_058F9F93_2D83_40ED_B3F6_4CAE6CD3C909#110754, COL_6514FE18_2F15_46F7_BE9B_8C8A1CDED5B0#110729 AS COL_6514FE18_2F15_46F7_BE9B_8C8A1CDED5B0#110755, COL_0C85CE96_902F_49B0_8699_B1D8041E9741#110730 AS COL_0C85CE96_902F_49B0_8699_B1D8041E9741#110756, COL_93D07A84_DAB1_4601_8776_58638D68C63B#110731 AS COL_93D07A84_DAB1_4601_8776_58638D68C63B#110757, COL_69F7D2CB_3582_450F_B81C_F35E14BD2F3A#110732 AS COL_69F7D2CB_3582_450F_B81C_F35E14BD2F3A#110758, COL_8DD6299D_F88E_4923_BA4A_AA5963BBA243#110733 AS COL_8DD6299D_F88E_4923_BA4A_AA5963BBA243#110759, COL_8F292832_9A81_4CB6_A3E8_AAF5E0E2B9D1#110734 AS COL_8F292832_9A81_4CB6_A3E8_AAF5E0E2B9D1#110760, COL_119B8687_79BA_47AC_A253_99B3F514F94F#110735 AS COL_119B8687_79BA_47AC_A253_99B3F514F94F#110761, COL_7A51C905_886C_4162_94AE_BCBA7820952A#110736 AS COL_7A51C905_886C_4162_94AE_BCBA7820952A#110762]
(15) Project
Arguments: [COL_EEA9697B_DB68_4A22_8733_70F35E85FA8C#110750, COL_8859F9BF_E9D0_49C6_AD56_9C140D4C38A1#110751, COL_AA4B3BC4_44A1_47D3_AC4B_C41D5CB3B3E9#110752, COL_F89F7AFE_9225_468C_A09B_7E0D4F0CD71B#110753, COL_058F9F93_2D83_40ED_B3F6_4CAE6CD3C909#110754, COL_6514FE18_2F15_46F7_BE9B_8C8A1CDED5B0#110755, COL_0C85CE96_902F_49B0_8699_B1D8041E9741#110756, COL_93D07A84_DAB1_4601_8776_58638D68C63B#110757, COL_69F7D2CB_3582_450F_B81C_F35E14BD2F3A#110758, COL_8DD6299D_F88E_4923_BA4A_AA5963BBA243#110759, COL_8F292832_9A81_4CB6_A3E8_AAF5E0E2B9D1#110760, COL_119B8687_79BA_47AC_A253_99B3F514F94F#110761, COL_7A51C905_886C_4162_94AE_BCBA7820952A#110762, str_join(array(COL_0C85CE96_902F_49B0_8699_B1D8041E9741#110756, COL_93D07A84_DAB1_4601_8776_58638D68C63B#110757), cast(> as string)) AS COL_163AB4E6_D7B0_4397_BF6B_992AF7938586#110776]
(16) Project
Arguments: [COL_EEA9697B_DB68_4A22_8733_70F35E85FA8C#110750 AS COL_EEA9697B_DB68_4A22_8733_70F35E85FA8C#110791, COL_8859F9BF_E9D0_49C6_AD56_9C140D4C38A1#110751 AS COL_8859F9BF_E9D0_49C6_AD56_9C140D4C38A1#110792, COL_AA4B3BC4_44A1_47D3_AC4B_C41D5CB3B3E9#110752 AS COL_AA4B3BC4_44A1_47D3_AC4B_C41D5CB3B3E9#110793, COL_F89F7AFE_9225_468C_A09B_7E0D4F0CD71B#110753 AS COL_F89F7AFE_9225_468C_A09B_7E0D4F0CD71B#110794, COL_058F9F93_2D83_40ED_B3F6_4CAE6CD3C909#110754 AS COL_058F9F93_2D83_40ED_B3F6_4CAE6CD3C909#110795, COL_6514FE18_2F15_46F7_BE9B_8C8A1CDED5B0#110755 AS COL_6514FE18_2F15_46F7_BE9B_8C8A1CDED5B0#110796, COL_0C85CE96_902F_49B0_8699_B1D8041E9741#110756 AS COL_0C85CE96_902F_49B0_8699_B1D8041E9741#110797, COL_93D07A84_DAB1_4601_8776_58638D68C63B#110757 AS COL_93D07A84_DAB1_4601_8776_58638D68C63B#110798, COL_69F7D2CB_3582_450F_B81C_F35E14BD2F3A#110758 AS COL_69F7D2CB_3582_450F_B81C_F35E14BD2F3A#110799, COL_8DD6299D_F88E_4923_BA4A_AA5963BBA243#110759 AS COL_8DD6299D_F88E_4923_BA4A_AA5963BBA243#110800, COL_8F292832_9A81_4CB6_A3E8_AAF5E0E2B9D1#110760 AS COL_8F292832_9A81_4CB6_A3E8_AAF5E0E2B9D1#110801, COL_119B8687_79BA_47AC_A253_99B3F514F94F#110761 AS COL_119B8687_79BA_47AC_A253_99B3F514F94F#110802, COL_7A51C905_886C_4162_94AE_BCBA7820952A#110762 AS COL_7A51C905_886C_4162_94AE_BCBA7820952A#110803, COL_163AB4E6_D7B0_4397_BF6B_992AF7938586#110776 AS COL_163AB4E6_D7B0_4397_BF6B_992AF7938586#110804]