== Physical Plan ==
CollectLimit (2)
+- * Scan JDBCRelation((SELECT RAWTOHEX(VISIT_UNIT_ID), RAWTOHEX(VISIT_ID), RAWTOHEX(PATIENT_ID), "UNIT", "ACTIVITY", "IN_DATE", "OUT_DATE" FROM "DTM_622"."VISIT_UNIT") x) [numPartitions=1] (1)
(1) Scan JDBCRelation((SELECT RAWTOHEX(VISIT_UNIT_ID), RAWTOHEX(VISIT_ID), RAWTOHEX(PATIENT_ID), "UNIT", "ACTIVITY", "IN_DATE", "OUT_DATE" FROM "DTM_622"."VISIT_UNIT") x) [numPartitions=1] [codegen id : 1]
Output [7]: [RAWTOHEX(VISIT_UNIT_ID)#52691, RAWTOHEX(VISIT_ID)#52692, RAWTOHEX(PATIENT_ID)#52693, UNIT#52694, ACTIVITY#52695, IN_DATE#52696, OUT_DATE#52697]
ReadSchema: struct<RAWTOHEX(VISIT_UNIT_ID):string,RAWTOHEX(VISIT_ID):string,RAWTOHEX(PATIENT_ID):string,UNIT:string,ACTIVITY:string,IN_DATE:timestamp,OUT_DATE:timestamp>
(2) CollectLimit
Input [7]: [RAWTOHEX(VISIT_UNIT_ID)#52691, RAWTOHEX(VISIT_ID)#52692, RAWTOHEX(PATIENT_ID)#52693, UNIT#52694, ACTIVITY#52695, IN_DATE#52696, OUT_DATE#52697]
Arguments: 500