digraph G {
0 [labelType="html" label="<br><b>CollectLimit</b><br><br>"];
subgraph cluster1 {
isCluster="true";
label="WholeStageCodegen (1)\n \nduration: 97 ms";
2 [labelType="html" label="<br><b>Project</b><br><br>"];
3 [labelType="html" label="<b>Scan JDBCRelation((SELECT RAWTOHEX(PATIENT_ID), \"BIRTH_DATE\", \"GENDER\", \"PSEUDO\", \"INHOSPITAL_DEATH_DATE\", \"INHOSPITAL_DEATH_CODE\", \"DEATH_DATE\", \"EXTERNAL_DEATH_PROCESS_ID\" FROM \"DTM_622\".\"PATIENT\") x) [numPartitions=1] </b><br><br>number of output rows: 189"];
}
2->0;
3->2;
}
4
CollectLimit 1500
Project [RAWTOHEX(PATIENT_ID)#62228 AS COL_PATIENT_ID_3333#62364, BIRTH_DATE#62229 AS COL_BIRTH_DATE_3334#62365, GENDER#62230 AS COL_GENDER_3335#62366, PSEUDO#62231 AS COL_PSEUDO_3336#62367, INHOSPITAL_DEATH_DATE#62232 AS COL_INHOSPITAL_DEAT_3337#62368, INHOSPITAL_DEATH_CODE#62233 AS COL_INHOSPITAL_DEAT_3338#62369, DEATH_DATE#62234 AS COL_DEATH_DATE_3339#62370, cast(EXTERNAL_DEATH_PROCESS_ID#62235 as int) AS COL_EXTERNAL_DEATH__3340#62371]
Scan JDBCRelation((SELECT RAWTOHEX(PATIENT_ID), "BIRTH_DATE", "GENDER", "PSEUDO", "INHOSPITAL_DEATH_DATE", "INHOSPITAL_DEATH_CODE", "DEATH_DATE", "EXTERNAL_DEATH_PROCESS_ID" FROM "DTM_622"."PATIENT") x) [numPartitions=1] [RAWTOHEX(PATIENT_ID)#62228,BIRTH_DATE#62229,GENDER#62230,PSEUDO#62231,INHOSPITAL_DEATH_DATE#62232,INHOSPITAL_DEATH_CODE#62233,DEATH_DATE#62234,EXTERNAL_DEATH_PROCESS_ID#62235] PushedFilters: [], ReadSchema: struct<RAWTOHEX(PATIENT_ID):string,BIRTH_DATE:timestamp,GENDER:string,PSEUDO:string,INHOSPITAL_DE...
WholeStageCodegen (1)
== Physical Plan ==
CollectLimit (3)
+- * Project (2)
+- * Scan JDBCRelation((SELECT RAWTOHEX(PATIENT_ID), "BIRTH_DATE", "GENDER", "PSEUDO", "INHOSPITAL_DEATH_DATE", "INHOSPITAL_DEATH_CODE", "DEATH_DATE", "EXTERNAL_DEATH_PROCESS_ID" FROM "DTM_622"."PATIENT") x) [numPartitions=1] (1)
(1) Scan JDBCRelation((SELECT RAWTOHEX(PATIENT_ID), "BIRTH_DATE", "GENDER", "PSEUDO", "INHOSPITAL_DEATH_DATE", "INHOSPITAL_DEATH_CODE", "DEATH_DATE", "EXTERNAL_DEATH_PROCESS_ID" FROM "DTM_622"."PATIENT") x) [numPartitions=1] [codegen id : 1]
Output [8]: [RAWTOHEX(PATIENT_ID)#62228, BIRTH_DATE#62229, GENDER#62230, PSEUDO#62231, INHOSPITAL_DEATH_DATE#62232, INHOSPITAL_DEATH_CODE#62233, DEATH_DATE#62234, EXTERNAL_DEATH_PROCESS_ID#62235]
ReadSchema: struct<RAWTOHEX(PATIENT_ID):string,BIRTH_DATE:timestamp,GENDER:string,PSEUDO:string,INHOSPITAL_DEATH_DATE:timestamp,INHOSPITAL_DEATH_CODE:string,DEATH_DATE:timestamp,EXTERNAL_DEATH_PROCESS_ID:decimal(38,0)>
(2) Project [codegen id : 1]
Output [8]: [RAWTOHEX(PATIENT_ID)#62228 AS COL_PATIENT_ID_3333#62364, BIRTH_DATE#62229 AS COL_BIRTH_DATE_3334#62365, GENDER#62230 AS COL_GENDER_3335#62366, PSEUDO#62231 AS COL_PSEUDO_3336#62367, INHOSPITAL_DEATH_DATE#62232 AS COL_INHOSPITAL_DEAT_3337#62368, INHOSPITAL_DEATH_CODE#62233 AS COL_INHOSPITAL_DEAT_3338#62369, DEATH_DATE#62234 AS COL_DEATH_DATE_3339#62370, cast(EXTERNAL_DEATH_PROCESS_ID#62235 as int) AS COL_EXTERNAL_DEATH__3340#62371]
Input [8]: [RAWTOHEX(PATIENT_ID)#62228, BIRTH_DATE#62229, GENDER#62230, PSEUDO#62231, INHOSPITAL_DEATH_DATE#62232, INHOSPITAL_DEATH_CODE#62233, DEATH_DATE#62234, EXTERNAL_DEATH_PROCESS_ID#62235]
(3) CollectLimit
Input [8]: [COL_PATIENT_ID_3333#62364, COL_BIRTH_DATE_3334#62365, COL_GENDER_3335#62366, COL_PSEUDO_3336#62367, COL_INHOSPITAL_DEAT_3337#62368, COL_INHOSPITAL_DEAT_3338#62369, COL_DEATH_DATE_3339#62370, COL_EXTERNAL_DEATH__3340#62371]
Arguments: 1500