digraph G {
0 [labelType="html" label="<br><b>CollectLimit</b><br><br>"];
subgraph cluster1 {
isCluster="true";
label="WholeStageCodegen (1)\n \nduration: 93 ms";
2 [labelType="html" label="<br><b>Project</b><br><br>"];
3 [labelType="html" label="<b>Scan JDBCRelation((SELECT RAWTOHEX(PATIENT_ID), \"ID_PAT\", \"BIRTH_DATE\", \"GENDER\", \"PSEUDO\", \"INHOSPITAL_DEATH_DATE\", \"INHOSPITAL_DEATH_CODE\", \"DEATH_DATE\", \"EXTERNAL_DEATH_PROCESS_ID\" FROM \"DTM_261\".\"PATIENT\") x) [numPartitions=1] </b><br><br>number of output rows: 50"];
}
2->0;
3->2;
}
4
CollectLimit 1500
Project [RAWTOHEX(PATIENT_ID)#54984 AS COL_PATIENT_ID_2931#55137, cast(ID_PAT#54985 as int) AS COL_ID_PAT_2932#55138, BIRTH_DATE#54986 AS COL_BIRTH_DATE_2933#55139, GENDER#54987 AS COL_GENDER_2934#55140, PSEUDO#54988 AS COL_PSEUDO_2935#55141, INHOSPITAL_DEATH_DATE#54989 AS COL_INHOSPITAL_DEAT_2936#55142, INHOSPITAL_DEATH_CODE#54990 AS COL_INHOSPITAL_DEAT_2937#55143, DEATH_DATE#54991 AS COL_DEATH_DATE_2938#55144, cast(EXTERNAL_DEATH_PROCESS_ID#54992 as int) AS COL_EXTERNAL_DEATH__2939#55145]
Scan JDBCRelation((SELECT RAWTOHEX(PATIENT_ID), "ID_PAT", "BIRTH_DATE", "GENDER", "PSEUDO", "INHOSPITAL_DEATH_DATE", "INHOSPITAL_DEATH_CODE", "DEATH_DATE", "EXTERNAL_DEATH_PROCESS_ID" FROM "DTM_261"."PATIENT") x) [numPartitions=1] [RAWTOHEX(PATIENT_ID)#54984,ID_PAT#54985,BIRTH_DATE#54986,GENDER#54987,PSEUDO#54988,INHOSPITAL_DEATH_DATE#54989,INHOSPITAL_DEATH_CODE#54990,DEATH_DATE#54991,EXTERNAL_DEATH_PROCESS_ID#54992] PushedFilters: [], ReadSchema: struct<RAWTOHEX(PATIENT_ID):string,ID_PAT:decimal(38,0),BIRTH_DATE:timestamp,GENDER:string,PSEUDO...
WholeStageCodegen (1)
== Physical Plan ==
CollectLimit (3)
+- * Project (2)
+- * Scan JDBCRelation((SELECT RAWTOHEX(PATIENT_ID), "ID_PAT", "BIRTH_DATE", "GENDER", "PSEUDO", "INHOSPITAL_DEATH_DATE", "INHOSPITAL_DEATH_CODE", "DEATH_DATE", "EXTERNAL_DEATH_PROCESS_ID" FROM "DTM_261"."PATIENT") x) [numPartitions=1] (1)
(1) Scan JDBCRelation((SELECT RAWTOHEX(PATIENT_ID), "ID_PAT", "BIRTH_DATE", "GENDER", "PSEUDO", "INHOSPITAL_DEATH_DATE", "INHOSPITAL_DEATH_CODE", "DEATH_DATE", "EXTERNAL_DEATH_PROCESS_ID" FROM "DTM_261"."PATIENT") x) [numPartitions=1] [codegen id : 1]
Output [9]: [RAWTOHEX(PATIENT_ID)#54984, ID_PAT#54985, BIRTH_DATE#54986, GENDER#54987, PSEUDO#54988, INHOSPITAL_DEATH_DATE#54989, INHOSPITAL_DEATH_CODE#54990, DEATH_DATE#54991, EXTERNAL_DEATH_PROCESS_ID#54992]
ReadSchema: struct<RAWTOHEX(PATIENT_ID):string,ID_PAT:decimal(38,0),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 [9]: [RAWTOHEX(PATIENT_ID)#54984 AS COL_PATIENT_ID_2931#55137, cast(ID_PAT#54985 as int) AS COL_ID_PAT_2932#55138, BIRTH_DATE#54986 AS COL_BIRTH_DATE_2933#55139, GENDER#54987 AS COL_GENDER_2934#55140, PSEUDO#54988 AS COL_PSEUDO_2935#55141, INHOSPITAL_DEATH_DATE#54989 AS COL_INHOSPITAL_DEAT_2936#55142, INHOSPITAL_DEATH_CODE#54990 AS COL_INHOSPITAL_DEAT_2937#55143, DEATH_DATE#54991 AS COL_DEATH_DATE_2938#55144, cast(EXTERNAL_DEATH_PROCESS_ID#54992 as int) AS COL_EXTERNAL_DEATH__2939#55145]
Input [9]: [RAWTOHEX(PATIENT_ID)#54984, ID_PAT#54985, BIRTH_DATE#54986, GENDER#54987, PSEUDO#54988, INHOSPITAL_DEATH_DATE#54989, INHOSPITAL_DEATH_CODE#54990, DEATH_DATE#54991, EXTERNAL_DEATH_PROCESS_ID#54992]
(3) CollectLimit
Input [9]: [COL_PATIENT_ID_2931#55137, COL_ID_PAT_2932#55138, COL_BIRTH_DATE_2933#55139, COL_GENDER_2934#55140, COL_PSEUDO_2935#55141, COL_INHOSPITAL_DEAT_2936#55142, COL_INHOSPITAL_DEAT_2937#55143, COL_DEATH_DATE_2938#55144, COL_EXTERNAL_DEATH__2939#55145]
Arguments: 1500