digraph G {
0 [labelType="html" label="<br><b>CollectLimit</b><br><br>"];
subgraph cluster1 {
isCluster="true";
label="WholeStageCodegen (1)";
2 [labelType="html" label="<br><b>Project</b><br><br>"];
3 [labelType="html" label="<b>Scan JDBCRelation((SELECT RAWTOHEX(DOCUMENT_TEXT_ID), RAWTOHEX(DOCUMENT_ID), RAWTOHEX(PATIENT_ID), RAWTOHEX(VISIT_ID), \"TXTID\", \"ID_ENTREPOT\", \"ID_PAT\", \"ID_SEJ\", \"CONTEXT\", \"CERTAINTY\", \"CONTEXT_RANK\", \"TEXT\" FROM \"DTM_261\".\"DOCUMENT_TEXT\") x) [numPartitions=1] </b><br><br>number of output rows: 345"];
}
2->0;
3->2;
}
4
CollectLimit 1500
Project [RAWTOHEX(DOCUMENT_TEXT_ID)#60656 AS COL_DOCUMENT_TEXT_I_2879#60860, RAWTOHEX(DOCUMENT_ID)#60657 AS COL_DOCUMENT_ID_2880#60861, RAWTOHEX(PATIENT_ID)#60658 AS COL_PATIENT_ID_2881#60862, RAWTOHEX(VISIT_ID)#60659 AS COL_VISIT_ID_2882#60863, cast(TXTID#60660 as int) AS COL_TXTID_2883#60864, cast(ID_ENTREPOT#60661 as int) AS COL_ID_ENTREPOT_2884#60865, cast(ID_PAT#60662 as int) AS COL_ID_PAT_2885#60866, cast(ID_SEJ#60663 as int) AS COL_ID_SEJ_2886#60867, CONTEXT#60664 AS COL_CONTEXT_2887#60868, cast(REFORMAT_FOR_DOUBLE(CERTAINTY#60665) as double) AS COL_CERTAINTY_2888#60869, cast(CONTEXT_RANK#60666 as int) AS COL_CONTEXT_RANK_2889#60870, TEXT#60667 AS COL_TEXT_2890#60871]
Scan JDBCRelation((SELECT RAWTOHEX(DOCUMENT_TEXT_ID), RAWTOHEX(DOCUMENT_ID), RAWTOHEX(PATIENT_ID), RAWTOHEX(VISIT_ID), "TXTID", "ID_ENTREPOT", "ID_PAT", "ID_SEJ", "CONTEXT", "CERTAINTY", "CONTEXT_RANK", "TEXT" FROM "DTM_261"."DOCUMENT_TEXT") x) [numPartitions=1] [RAWTOHEX(DOCUMENT_TEXT_ID)#60656,RAWTOHEX(DOCUMENT_ID)#60657,RAWTOHEX(PATIENT_ID)#60658,RAWTOHEX(VISIT_ID)#60659,TXTID#60660,ID_ENTREPOT#60661,ID_PAT#60662,ID_SEJ#60663,CONTEXT#60664,CERTAINTY#60665,CONTEXT_RANK#60666,TEXT#60667] PushedFilters: [], ReadSchema: struct<RAWTOHEX(DOCUMENT_TEXT_ID):string,RAWTOHEX(DOCUMENT_ID):string,RAWTOHEX(PATIENT_ID):string...
WholeStageCodegen (1)
== Physical Plan ==
CollectLimit (3)
+- * Project (2)
+- * Scan JDBCRelation((SELECT RAWTOHEX(DOCUMENT_TEXT_ID), RAWTOHEX(DOCUMENT_ID), RAWTOHEX(PATIENT_ID), RAWTOHEX(VISIT_ID), "TXTID", "ID_ENTREPOT", "ID_PAT", "ID_SEJ", "CONTEXT", "CERTAINTY", "CONTEXT_RANK", "TEXT" FROM "DTM_261"."DOCUMENT_TEXT") x) [numPartitions=1] (1)
(1) Scan JDBCRelation((SELECT RAWTOHEX(DOCUMENT_TEXT_ID), RAWTOHEX(DOCUMENT_ID), RAWTOHEX(PATIENT_ID), RAWTOHEX(VISIT_ID), "TXTID", "ID_ENTREPOT", "ID_PAT", "ID_SEJ", "CONTEXT", "CERTAINTY", "CONTEXT_RANK", "TEXT" FROM "DTM_261"."DOCUMENT_TEXT") x) [numPartitions=1] [codegen id : 1]
Output [12]: [RAWTOHEX(DOCUMENT_TEXT_ID)#60656, RAWTOHEX(DOCUMENT_ID)#60657, RAWTOHEX(PATIENT_ID)#60658, RAWTOHEX(VISIT_ID)#60659, TXTID#60660, ID_ENTREPOT#60661, ID_PAT#60662, ID_SEJ#60663, CONTEXT#60664, CERTAINTY#60665, CONTEXT_RANK#60666, TEXT#60667]
ReadSchema: struct<RAWTOHEX(DOCUMENT_TEXT_ID):string,RAWTOHEX(DOCUMENT_ID):string,RAWTOHEX(PATIENT_ID):string,RAWTOHEX(VISIT_ID):string,TXTID:decimal(38,0),ID_ENTREPOT:decimal(38,0),ID_PAT:decimal(38,0),ID_SEJ:decimal(38,0),CONTEXT:string,CERTAINTY:decimal(38,10),CONTEXT_RANK:decimal(38,0),TEXT:string>
(2) Project [codegen id : 1]
Output [12]: [RAWTOHEX(DOCUMENT_TEXT_ID)#60656 AS COL_DOCUMENT_TEXT_I_2879#60860, RAWTOHEX(DOCUMENT_ID)#60657 AS COL_DOCUMENT_ID_2880#60861, RAWTOHEX(PATIENT_ID)#60658 AS COL_PATIENT_ID_2881#60862, RAWTOHEX(VISIT_ID)#60659 AS COL_VISIT_ID_2882#60863, cast(TXTID#60660 as int) AS COL_TXTID_2883#60864, cast(ID_ENTREPOT#60661 as int) AS COL_ID_ENTREPOT_2884#60865, cast(ID_PAT#60662 as int) AS COL_ID_PAT_2885#60866, cast(ID_SEJ#60663 as int) AS COL_ID_SEJ_2886#60867, CONTEXT#60664 AS COL_CONTEXT_2887#60868, cast(REFORMAT_FOR_DOUBLE(CERTAINTY#60665) as double) AS COL_CERTAINTY_2888#60869, cast(CONTEXT_RANK#60666 as int) AS COL_CONTEXT_RANK_2889#60870, TEXT#60667 AS COL_TEXT_2890#60871]
Input [12]: [RAWTOHEX(DOCUMENT_TEXT_ID)#60656, RAWTOHEX(DOCUMENT_ID)#60657, RAWTOHEX(PATIENT_ID)#60658, RAWTOHEX(VISIT_ID)#60659, TXTID#60660, ID_ENTREPOT#60661, ID_PAT#60662, ID_SEJ#60663, CONTEXT#60664, CERTAINTY#60665, CONTEXT_RANK#60666, TEXT#60667]
(3) CollectLimit
Input [12]: [COL_DOCUMENT_TEXT_I_2879#60860, COL_DOCUMENT_ID_2880#60861, COL_PATIENT_ID_2881#60862, COL_VISIT_ID_2882#60863, COL_TXTID_2883#60864, COL_ID_ENTREPOT_2884#60865, COL_ID_PAT_2885#60866, COL_ID_SEJ_2886#60867, COL_CONTEXT_2887#60868, COL_CERTAINTY_2888#60869, COL_CONTEXT_RANK_2889#60870, COL_TEXT_2890#60871]
Arguments: 1500