digraph G {
0 [labelType="html" label="<br><b>CollectLimit</b><br><br>"];
subgraph cluster1 {
isCluster="true";
label="WholeStageCodegen (1)\n \nduration: 0 ms";
2 [labelType="html" label="<b>Scan JDBCRelation((SELECT RAWTOHEX(DOCUMENT_DATA_ID), RAWTOHEX(DOCUMENT_ID), RAWTOHEX(PATIENT_ID), RAWTOHEX(VISIT_ID), RAWTOHEX(VISIT_UNIT_ID), \"ID_ENTREPOT_STRUCTURE\", \"ID_ENTREPOT\", \"ID_PAT\", \"ID_SEJ\", \"ID_MVT\", \"TERMINOLOGY_CODE\", \"CONCEPT_CODE\", \"NB\", \"START_AT\", \"TEXT\", \"LOWER_BOUND\", \"HIGHER_BOUND\", \"CERTAINTY\", \"CONTEXT\", \"QUALIFIER\", \"END_AT\", \"UNIT_VAL\", \"TYPE_VAL\", \"INSTANCE_ID\" FROM \"DTM_261\".\"DOCUMENT_DATA\") x) [numPartitions=1] </b><br><br>number of output rows: 500"];
}
2->0;
}
3
CollectLimit 500
Scan JDBCRelation((SELECT RAWTOHEX(DOCUMENT_DATA_ID), RAWTOHEX(DOCUMENT_ID), RAWTOHEX(PATIENT_ID), RAWTOHEX(VISIT_ID), RAWTOHEX(VISIT_UNIT_ID), "ID_ENTREPOT_STRUCTURE", "ID_ENTREPOT", "ID_PAT", "ID_SEJ", "ID_MVT", "TERMINOLOGY_CODE", "CONCEPT_CODE", "NB", "START_AT", "TEXT", "LOWER_BOUND", "HIGHER_BOUND", "CERTAINTY", "CONTEXT", "QUALIFIER", "END_AT", "UNIT_VAL", "TYPE_VAL", "INSTANCE_ID" FROM "DTM_261"."DOCUMENT_DATA") x) [numPartitions=1] [RAWTOHEX(DOCUMENT_DATA_ID)#57780,RAWTOHEX(DOCUMENT_ID)#57781,RAWTOHEX(PATIENT_ID)#57782,RAWTOHEX(VISIT_ID)#57783,RAWTOHEX(VISIT_UNIT_ID)#57784,ID_ENTREPOT_STRUCTURE#57785,ID_ENTREPOT#57786,ID_PAT#57787,ID_SEJ#57788,ID_MVT#57789,TERMINOLOGY_CODE#57790,CONCEPT_CODE#57791,NB#57792,START_AT#57793,TEXT#57794,LOWER_BOUND#57795,HIGHER_BOUND#57796,CERTAINTY#57797,CONTEXT#57798,QUALIFIER#57799,END_AT#57800,UNIT_VAL#57801,TYPE_VAL#57802,INSTANCE_ID#57803] PushedFilters: [], ReadSchema: struct<RAWTOHEX(DOCUMENT_DATA_ID):string,RAWTOHEX(DOCUMENT_ID):string,RAWTOHEX(PATIENT_ID):string...
WholeStageCodegen (1)
== Physical Plan ==
CollectLimit (2)
+- * Scan JDBCRelation((SELECT RAWTOHEX(DOCUMENT_DATA_ID), RAWTOHEX(DOCUMENT_ID), RAWTOHEX(PATIENT_ID), RAWTOHEX(VISIT_ID), RAWTOHEX(VISIT_UNIT_ID), "ID_ENTREPOT_STRUCTURE", "ID_ENTREPOT", "ID_PAT", "ID_SEJ", "ID_MVT", "TERMINOLOGY_CODE", "CONCEPT_CODE", "NB", "START_AT", "TEXT", "LOWER_BOUND", "HIGHER_BOUND", "CERTAINTY", "CONTEXT", "QUALIFIER", "END_AT", "UNIT_VAL", "TYPE_VAL", "INSTANCE_ID" FROM "DTM_261"."DOCUMENT_DATA") x) [numPartitions=1] (1)
(1) Scan JDBCRelation((SELECT RAWTOHEX(DOCUMENT_DATA_ID), RAWTOHEX(DOCUMENT_ID), RAWTOHEX(PATIENT_ID), RAWTOHEX(VISIT_ID), RAWTOHEX(VISIT_UNIT_ID), "ID_ENTREPOT_STRUCTURE", "ID_ENTREPOT", "ID_PAT", "ID_SEJ", "ID_MVT", "TERMINOLOGY_CODE", "CONCEPT_CODE", "NB", "START_AT", "TEXT", "LOWER_BOUND", "HIGHER_BOUND", "CERTAINTY", "CONTEXT", "QUALIFIER", "END_AT", "UNIT_VAL", "TYPE_VAL", "INSTANCE_ID" FROM "DTM_261"."DOCUMENT_DATA") x) [numPartitions=1] [codegen id : 1]
Output [24]: [RAWTOHEX(DOCUMENT_DATA_ID)#57780, RAWTOHEX(DOCUMENT_ID)#57781, RAWTOHEX(PATIENT_ID)#57782, RAWTOHEX(VISIT_ID)#57783, RAWTOHEX(VISIT_UNIT_ID)#57784, ID_ENTREPOT_STRUCTURE#57785, ID_ENTREPOT#57786, ID_PAT#57787, ID_SEJ#57788, ID_MVT#57789, TERMINOLOGY_CODE#57790, CONCEPT_CODE#57791, NB#57792, START_AT#57793, TEXT#57794, LOWER_BOUND#57795, HIGHER_BOUND#57796, CERTAINTY#57797, CONTEXT#57798, QUALIFIER#57799, END_AT#57800, UNIT_VAL#57801, TYPE_VAL#57802, INSTANCE_ID#57803]
ReadSchema: struct<RAWTOHEX(DOCUMENT_DATA_ID):string,RAWTOHEX(DOCUMENT_ID):string,RAWTOHEX(PATIENT_ID):string,RAWTOHEX(VISIT_ID):string,RAWTOHEX(VISIT_UNIT_ID):string,ID_ENTREPOT_STRUCTURE:decimal(38,0),ID_ENTREPOT:decimal(38,0),ID_PAT:decimal(38,0),ID_SEJ:decimal(38,0),ID_MVT:decimal(38,0),TERMINOLOGY_CODE:string,CONCEPT_CODE:string,NB:decimal(38,10),START_AT:timestamp,TEXT:string,LOWER_BOUND:decimal(38,10),HIGHER_BOUND:decimal(38,10),CERTAINTY:decimal(38,10),CONTEXT:string,QUALIFIER:string,END_AT:timestamp,UNIT_VAL:string,TYPE_VAL:string,INSTANCE_ID:string>
(2) CollectLimit
Input [24]: [RAWTOHEX(DOCUMENT_DATA_ID)#57780, RAWTOHEX(DOCUMENT_ID)#57781, RAWTOHEX(PATIENT_ID)#57782, RAWTOHEX(VISIT_ID)#57783, RAWTOHEX(VISIT_UNIT_ID)#57784, ID_ENTREPOT_STRUCTURE#57785, ID_ENTREPOT#57786, ID_PAT#57787, ID_SEJ#57788, ID_MVT#57789, TERMINOLOGY_CODE#57790, CONCEPT_CODE#57791, NB#57792, START_AT#57793, TEXT#57794, LOWER_BOUND#57795, HIGHER_BOUND#57796, CERTAINTY#57797, CONTEXT#57798, QUALIFIER#57799, END_AT#57800, UNIT_VAL#57801, TYPE_VAL#57802, INSTANCE_ID#57803]
Arguments: 500