== Physical Plan ==
Execute CreateViewCommand (1)
+- CreateViewCommand (2)
+- Project (9)
+- Project (8)
+- Project (7)
+- Project (6)
+- Project (5)
+- Project (4)
+- LogicalRelation (3)
(1) Execute CreateViewCommand
Output: []
(2) CreateViewCommand
Arguments: `VISIT_3342166`, 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)#114684, RAWTOHEX(PATIENT_ID)#114685, IN_DATE#114686, OUT_DATE#114687, IN_MODE#114688, OUT_MODE#114689, IN_UNIT#114690, OUT_UNIT#114691, VISIT_TYPE#114692, CHAMP_PMSI#114693, UNIT_PATH#114694, EMERGENCY#114695, CANCELED#114696], false
(4) Project
Arguments: [RAWTOHEX(VISIT_ID)#114684, RAWTOHEX(PATIENT_ID)#114685, IN_DATE#114686, OUT_DATE#114687, IN_MODE#114688, OUT_MODE#114689, IN_UNIT#114690, OUT_UNIT#114691, VISIT_TYPE#114692, CHAMP_PMSI#114693, UNIT_PATH#114694, staticinvoke(class org.apache.spark.sql.catalyst.util.CharVarcharCodegenUtils, StringType, readSidePadding, EMERGENCY#114695, 1, true, false, true) AS EMERGENCY#114697, CANCELED#114696]
(5) Project
Arguments: [RAWTOHEX(VISIT_ID)#114684 AS COLL0#114711, RAWTOHEX(PATIENT_ID)#114685 AS COLL1#114712, IN_DATE#114686 AS COLL2#114713, OUT_DATE#114687 AS COLL3#114714, IN_MODE#114688 AS COLL4#114715, OUT_MODE#114689 AS COLL5#114716, IN_UNIT#114690 AS COLL6#114717, OUT_UNIT#114691 AS COLL7#114718, VISIT_TYPE#114692 AS COLL8#114719, CHAMP_PMSI#114693 AS COLL9#114720, UNIT_PATH#114694 AS COLL10#114721, EMERGENCY#114697 AS COLL11#114722, CANCELED#114696 AS COLL12#114723]
(6) Project
Arguments: [COLL0#114711 AS COLL0#114737, COLL1#114712 AS COLL1#114738, COLL2#114713 AS COLL2#114739, COLL3#114714 AS COLL3#114740, COLL4#114715 AS COLL4#114741, COLL5#114716 AS COLL5#114742, COLL6#114717 AS COLL6#114743, COLL7#114718 AS COLL7#114744, COLL8#114719 AS COLL8#114745, COLL9#114720 AS COLL9#114746, COLL10#114721 AS COLL10#114747, COLL11#114722 AS COLL11#114748, COLL12#114723 AS COLL12#114749]
(7) Project
Arguments: [COLL0#114737, COLL1#114738, COLL2#114739, COLL3#114740, COLL4#114741, COLL5#114742, COLL6#114743, COLL7#114744, COLL8#114745, COLL9#114746, COLL10#114747, COLL11#114748, COLL12#114749]
(8) Project
Arguments: [cast(COLL12#114749 as int) AS CANCELED_3355#114776, COLL9#114746 AS CHAMP_PMSI_3352#114777, COLL11#114748 AS EMERGENCY_3354#114778, COLL2#114739 AS IN_DATE_3345#114779, COLL4#114741 AS IN_MODE_3347#114780, COLL6#114743 AS IN_UNIT_3349#114781, COLL3#114740 AS OUT_DATE_3346#114782, COLL5#114742 AS OUT_MODE_3348#114783, COLL7#114744 AS OUT_UNIT_3350#114784, COLL1#114738 AS PATIENT_ID_3344#114785, COLL10#114747 AS UNIT_PATH_3353#114786, COLL0#114737 AS VISIT_ID_3343#114787, COLL8#114745 AS VISIT_TYPE_3351#114788]
(9) Project
Arguments: [CANCELED_3355#114776, CHAMP_PMSI_3352#114777, EMERGENCY_3354#114778, IN_DATE_3345#114779, IN_MODE_3347#114780, IN_UNIT_3349#114781, OUT_DATE_3346#114782, OUT_MODE_3348#114783, OUT_UNIT_3350#114784, PATIENT_ID_3344#114785, UNIT_PATH_3353#114786, VISIT_ID_3343#114787, VISIT_TYPE_3351#114788, str_encrypt(VISIT_ID_3343#114787) AS ENCRYPT_3536#114802]