== 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_3342162`, 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)#108658, RAWTOHEX(PATIENT_ID)#108659, IN_DATE#108660, OUT_DATE#108661, IN_MODE#108662, OUT_MODE#108663, IN_UNIT#108664, OUT_UNIT#108665, VISIT_TYPE#108666, CHAMP_PMSI#108667, UNIT_PATH#108668, EMERGENCY#108669, CANCELED#108670], false
(4) Project
Arguments: [RAWTOHEX(VISIT_ID)#108658, RAWTOHEX(PATIENT_ID)#108659, IN_DATE#108660, OUT_DATE#108661, IN_MODE#108662, OUT_MODE#108663, IN_UNIT#108664, OUT_UNIT#108665, VISIT_TYPE#108666, CHAMP_PMSI#108667, UNIT_PATH#108668, staticinvoke(class org.apache.spark.sql.catalyst.util.CharVarcharCodegenUtils, StringType, readSidePadding, EMERGENCY#108669, 1, true, false, true) AS EMERGENCY#108671, CANCELED#108670]
(5) Project
Arguments: [RAWTOHEX(VISIT_ID)#108658 AS COLL0#108685, RAWTOHEX(PATIENT_ID)#108659 AS COLL1#108686, IN_DATE#108660 AS COLL2#108687, OUT_DATE#108661 AS COLL3#108688, IN_MODE#108662 AS COLL4#108689, OUT_MODE#108663 AS COLL5#108690, IN_UNIT#108664 AS COLL6#108691, OUT_UNIT#108665 AS COLL7#108692, VISIT_TYPE#108666 AS COLL8#108693, CHAMP_PMSI#108667 AS COLL9#108694, UNIT_PATH#108668 AS COLL10#108695, EMERGENCY#108671 AS COLL11#108696, CANCELED#108670 AS COLL12#108697]
(6) Project
Arguments: [COLL0#108685 AS COLL0#108711, COLL1#108686 AS COLL1#108712, COLL2#108687 AS COLL2#108713, COLL3#108688 AS COLL3#108714, COLL4#108689 AS COLL4#108715, COLL5#108690 AS COLL5#108716, COLL6#108691 AS COLL6#108717, COLL7#108692 AS COLL7#108718, COLL8#108693 AS COLL8#108719, COLL9#108694 AS COLL9#108720, COLL10#108695 AS COLL10#108721, COLL11#108696 AS COLL11#108722, COLL12#108697 AS COLL12#108723]
(7) Project
Arguments: [COLL0#108711, COLL1#108712, COLL2#108713, COLL3#108714, COLL4#108715, COLL5#108716, COLL6#108717, COLL7#108718, COLL8#108719, COLL9#108720, COLL10#108721, COLL11#108722, COLL12#108723]
(8) Project
Arguments: [cast(COLL12#108723 as int) AS CANCELED_3355#108750, COLL9#108720 AS CHAMP_PMSI_3352#108751, COLL11#108722 AS EMERGENCY_3354#108752, COLL2#108713 AS IN_DATE_3345#108753, COLL4#108715 AS IN_MODE_3347#108754, COLL6#108717 AS IN_UNIT_3349#108755, COLL3#108714 AS OUT_DATE_3346#108756, COLL5#108716 AS OUT_MODE_3348#108757, COLL7#108718 AS OUT_UNIT_3350#108758, COLL1#108712 AS PATIENT_ID_3344#108759, COLL10#108721 AS UNIT_PATH_3353#108760, COLL0#108711 AS VISIT_ID_3343#108761, COLL8#108719 AS VISIT_TYPE_3351#108762]
(9) Project
Arguments: [CANCELED_3355#108750, CHAMP_PMSI_3352#108751, EMERGENCY_3354#108752, IN_DATE_3345#108753, IN_MODE_3347#108754, IN_UNIT_3349#108755, OUT_DATE_3346#108756, OUT_MODE_3348#108757, OUT_UNIT_3350#108758, PATIENT_ID_3344#108759, UNIT_PATH_3353#108760, VISIT_ID_3343#108761, VISIT_TYPE_3351#108762, str_encrypt(VISIT_ID_3343#108761) AS ENCRYPT_3536#108776]