digraph G {
0 [labelType="html" label="<br><b>CollectLimit</b><br><br>"];
subgraph cluster1 {
isCluster="true";
label="WholeStageCodegen (1)\n \nduration: 58.4 s";
2 [labelType="html" label="<br><b>Project</b><br><br>"];
3 [labelType="html" label="<b>Scan JDBCRelation((SELECT \"DOCUMENT_TEXT_ID\", \"DOCUMENT_ID\", \"PATIENT_ID\", \"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: 681"];
}
2->0;
3->2;
}
4
CollectLimit 1500
Project [null AS COL_DOCUMENT_TEXT_I_2879#2658, null AS COL_DOCUMENT_ID_2880#2659, null AS COL_PATIENT_ID_2881#2660, null AS COL_VISIT_ID_2882#2661, cast(TXTID#2458 as int) AS COL_TXTID_2883#2662, cast(ID_ENTREPOT#2459 as int) AS COL_ID_ENTREPOT_2884#2663, cast(ID_PAT#2460 as int) AS COL_ID_PAT_2885#2664, cast(ID_SEJ#2461 as int) AS COL_ID_SEJ_2886#2665, CONTEXT#2462 AS COL_CONTEXT_2887#2666, cast(REFORMAT_FOR_DOUBLE(CERTAINTY#2463) as double) AS COL_CERTAINTY_2888#2667, cast(CONTEXT_RANK#2464 as int) AS COL_CONTEXT_RANK_2889#2668, TEXT#2465 AS COL_TEXT_2890#2669]
Scan JDBCRelation((SELECT "DOCUMENT_TEXT_ID", "DOCUMENT_ID", "PATIENT_ID", "VISIT_ID", "TXTID", "ID_ENTREPOT", "ID_PAT", "ID_SEJ", "CONTEXT", "CERTAINTY", "CONTEXT_RANK", "TEXT" FROM "DTM_261"."DOCUMENT_TEXT") x) [numPartitions=1] [TXTID#2458,ID_ENTREPOT#2459,ID_PAT#2460,ID_SEJ#2461,CONTEXT#2462,CERTAINTY#2463,CONTEXT_RANK#2464,TEXT#2465] PushedFilters: [], ReadSchema: struct<TXTID:decimal(38,0),ID_ENTREPOT:decimal(38,0),ID_PAT:decimal(38,0),ID_SEJ:decimal(38,0),CO...
WholeStageCodegen (1)
== Physical Plan ==
CollectLimit (3)
+- * Project (2)
+- * Scan JDBCRelation((SELECT "DOCUMENT_TEXT_ID", "DOCUMENT_ID", "PATIENT_ID", "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 "DOCUMENT_TEXT_ID", "DOCUMENT_ID", "PATIENT_ID", "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 [8]: [TXTID#2458, ID_ENTREPOT#2459, ID_PAT#2460, ID_SEJ#2461, CONTEXT#2462, CERTAINTY#2463, CONTEXT_RANK#2464, TEXT#2465]
ReadSchema: struct<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]: [null AS COL_DOCUMENT_TEXT_I_2879#2658, null AS COL_DOCUMENT_ID_2880#2659, null AS COL_PATIENT_ID_2881#2660, null AS COL_VISIT_ID_2882#2661, cast(TXTID#2458 as int) AS COL_TXTID_2883#2662, cast(ID_ENTREPOT#2459 as int) AS COL_ID_ENTREPOT_2884#2663, cast(ID_PAT#2460 as int) AS COL_ID_PAT_2885#2664, cast(ID_SEJ#2461 as int) AS COL_ID_SEJ_2886#2665, CONTEXT#2462 AS COL_CONTEXT_2887#2666, cast(REFORMAT_FOR_DOUBLE(CERTAINTY#2463) as double) AS COL_CERTAINTY_2888#2667, cast(CONTEXT_RANK#2464 as int) AS COL_CONTEXT_RANK_2889#2668, TEXT#2465 AS COL_TEXT_2890#2669]
Input [8]: [TXTID#2458, ID_ENTREPOT#2459, ID_PAT#2460, ID_SEJ#2461, CONTEXT#2462, CERTAINTY#2463, CONTEXT_RANK#2464, TEXT#2465]
(3) CollectLimit
Input [12]: [COL_DOCUMENT_TEXT_I_2879#2658, COL_DOCUMENT_ID_2880#2659, COL_PATIENT_ID_2881#2660, COL_VISIT_ID_2882#2661, COL_TXTID_2883#2662, COL_ID_ENTREPOT_2884#2663, COL_ID_PAT_2885#2664, COL_ID_SEJ_2886#2665, COL_CONTEXT_2887#2666, COL_CERTAINTY_2888#2667, COL_CONTEXT_RANK_2889#2668, COL_TEXT_2890#2669]
Arguments: 1500