digraph G {
0 [labelType="html" label="<br><b>CollectLimit</b><br><br>"];
subgraph cluster1 {
isCluster="true";
label="WholeStageCodegen (1)\n \nduration: 102 ms";
2 [labelType="html" label="<br><b>Project</b><br><br>"];
3 [labelType="html" label="<b>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] </b><br><br>number of output rows: 1,382"];
}
2->0;
3->2;
}
4
CollectLimit 1500
Project [RAWTOHEX(VISIT_UNIT_ID)#52904 AS COL_19FBC2D6_FC49_4062_822A_242A41929E7D#53016, RAWTOHEX(VISIT_ID)#52905 AS COL_085E93C6_B825_4DA8_8708_8D98C406324F#53017, RAWTOHEX(PATIENT_ID)#52906 AS COL_FC9902B4_8859_4AF9_ADF1_99A2E15E5351#53018, UNIT#52907 AS COL_9A5ACA40_F512_495A_9718_534E3BBBA5EE#53019, ACTIVITY#52908 AS COL_822D1F41_6EAB_4525_8075_1BCA23137730#53020, IN_DATE#52909 AS COL_8E1D7833_6478_47C9_AF51_C374496B0CFF#53021, OUT_DATE#52910 AS COL_84B2BFCE_5604_4B75_A7EA_82682A7D0210#53022, date_diff(HOUR, OUT_DATE#52910, IN_DATE#52909) AS COL_42BBAE75_38D5_44F7_AA65_77D5EA8C5D8C#53067L, date_diff(DAY, OUT_DATE#52910, IN_DATE#52909) AS COL_F533C3E3_214A_45F3_B98F_9683DD01C84C#53068L, date_diff(MINUTE, OUT_DATE#52910, IN_DATE#52909) AS COL_B80CC574_7E7E_464D_90B8_5AFE7B1EA083#53069L]
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] [RAWTOHEX(VISIT_UNIT_ID)#52904,RAWTOHEX(VISIT_ID)#52905,RAWTOHEX(PATIENT_ID)#52906,UNIT#52907,ACTIVITY#52908,IN_DATE#52909,OUT_DATE#52910] PushedFilters: [], ReadSchema: struct<RAWTOHEX(VISIT_UNIT_ID):string,RAWTOHEX(VISIT_ID):string,RAWTOHEX(PATIENT_ID):string,UNIT:...
WholeStageCodegen (1)
== Physical Plan ==
CollectLimit (3)
+- * Project (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)#52904, RAWTOHEX(VISIT_ID)#52905, RAWTOHEX(PATIENT_ID)#52906, UNIT#52907, ACTIVITY#52908, IN_DATE#52909, OUT_DATE#52910]
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) Project [codegen id : 1]
Output [10]: [RAWTOHEX(VISIT_UNIT_ID)#52904 AS COL_19FBC2D6_FC49_4062_822A_242A41929E7D#53016, RAWTOHEX(VISIT_ID)#52905 AS COL_085E93C6_B825_4DA8_8708_8D98C406324F#53017, RAWTOHEX(PATIENT_ID)#52906 AS COL_FC9902B4_8859_4AF9_ADF1_99A2E15E5351#53018, UNIT#52907 AS COL_9A5ACA40_F512_495A_9718_534E3BBBA5EE#53019, ACTIVITY#52908 AS COL_822D1F41_6EAB_4525_8075_1BCA23137730#53020, IN_DATE#52909 AS COL_8E1D7833_6478_47C9_AF51_C374496B0CFF#53021, OUT_DATE#52910 AS COL_84B2BFCE_5604_4B75_A7EA_82682A7D0210#53022, date_diff(HOUR, OUT_DATE#52910, IN_DATE#52909) AS COL_42BBAE75_38D5_44F7_AA65_77D5EA8C5D8C#53067L, date_diff(DAY, OUT_DATE#52910, IN_DATE#52909) AS COL_F533C3E3_214A_45F3_B98F_9683DD01C84C#53068L, date_diff(MINUTE, OUT_DATE#52910, IN_DATE#52909) AS COL_B80CC574_7E7E_464D_90B8_5AFE7B1EA083#53069L]
Input [7]: [RAWTOHEX(VISIT_UNIT_ID)#52904, RAWTOHEX(VISIT_ID)#52905, RAWTOHEX(PATIENT_ID)#52906, UNIT#52907, ACTIVITY#52908, IN_DATE#52909, OUT_DATE#52910]
(3) CollectLimit
Input [10]: [COL_19FBC2D6_FC49_4062_822A_242A41929E7D#53016, COL_085E93C6_B825_4DA8_8708_8D98C406324F#53017, COL_FC9902B4_8859_4AF9_ADF1_99A2E15E5351#53018, COL_9A5ACA40_F512_495A_9718_534E3BBBA5EE#53019, COL_822D1F41_6EAB_4525_8075_1BCA23137730#53020, COL_8E1D7833_6478_47C9_AF51_C374496B0CFF#53021, COL_84B2BFCE_5604_4B75_A7EA_82682A7D0210#53022, COL_42BBAE75_38D5_44F7_AA65_77D5EA8C5D8C#53067L, COL_F533C3E3_214A_45F3_B98F_9683DD01C84C#53068L, COL_B80CC574_7E7E_464D_90B8_5AFE7B1EA083#53069L]
Arguments: 1500