digraph G {
0 [labelType="html" label="<br><b>CollectLimit</b><br><br>"];
subgraph cluster1 {
isCluster="true";
label="WholeStageCodegen (1)";
2 [labelType="html" label="<b>Scan JDBCRelation((SELECT RAWTOHEX(DOCUMENT_ID), RAWTOHEX(METADOCUMENT_ID), RAWTOHEX(PATIENT_ID), RAWTOHEX(VISIT_ID), RAWTOHEX(VISIT_UNIT_ID), \"ID_ENTREPOT\", \"ID_PAT\", \"ID_SEJ\", \"ID_MVT\", \"ID_LOT\", \"UPDATED_AT\", \"UNIT\", \"DELEGATE_UNIT\", \"HIERARCHY_UNIT\", \"TITLE\", \"DOCUMENT_TYPE\", \"CREATED_AT\", \"BODY\", \"AUTHOR\", \"INSTANCE_ID\", \"PATIENT_AGE\", \"FORMAT\" FROM \"DTM_261\".\"DOCUMENT\") x) [numPartitions=1] </b><br><br>number of output rows: 212"];
}
2->0;
}
3
CollectLimit 500
Scan JDBCRelation((SELECT RAWTOHEX(DOCUMENT_ID), RAWTOHEX(METADOCUMENT_ID), RAWTOHEX(PATIENT_ID), RAWTOHEX(VISIT_ID), RAWTOHEX(VISIT_UNIT_ID), "ID_ENTREPOT", "ID_PAT", "ID_SEJ", "ID_MVT", "ID_LOT", "UPDATED_AT", "UNIT", "DELEGATE_UNIT", "HIERARCHY_UNIT", "TITLE", "DOCUMENT_TYPE", "CREATED_AT", "BODY", "AUTHOR", "INSTANCE_ID", "PATIENT_AGE", "FORMAT" FROM "DTM_261"."DOCUMENT") x) [numPartitions=1] [RAWTOHEX(DOCUMENT_ID)#56627,RAWTOHEX(METADOCUMENT_ID)#56628,RAWTOHEX(PATIENT_ID)#56629,RAWTOHEX(VISIT_ID)#56630,RAWTOHEX(VISIT_UNIT_ID)#56631,ID_ENTREPOT#56632,ID_PAT#56633,ID_SEJ#56634,ID_MVT#56635,ID_LOT#56636,UPDATED_AT#56637,UNIT#56638,DELEGATE_UNIT#56639,HIERARCHY_UNIT#56640,TITLE#56641,DOCUMENT_TYPE#56642,CREATED_AT#56643,BODY#56644,AUTHOR#56645,INSTANCE_ID#56646,PATIENT_AGE#56647,FORMAT#56648] PushedFilters: [], ReadSchema: struct<RAWTOHEX(DOCUMENT_ID):string,RAWTOHEX(METADOCUMENT_ID):string,RAWTOHEX(PATIENT_ID):string,...
WholeStageCodegen (1)
== Physical Plan ==
CollectLimit (2)
+- * Scan JDBCRelation((SELECT RAWTOHEX(DOCUMENT_ID), RAWTOHEX(METADOCUMENT_ID), RAWTOHEX(PATIENT_ID), RAWTOHEX(VISIT_ID), RAWTOHEX(VISIT_UNIT_ID), "ID_ENTREPOT", "ID_PAT", "ID_SEJ", "ID_MVT", "ID_LOT", "UPDATED_AT", "UNIT", "DELEGATE_UNIT", "HIERARCHY_UNIT", "TITLE", "DOCUMENT_TYPE", "CREATED_AT", "BODY", "AUTHOR", "INSTANCE_ID", "PATIENT_AGE", "FORMAT" FROM "DTM_261"."DOCUMENT") x) [numPartitions=1] (1)
(1) Scan JDBCRelation((SELECT RAWTOHEX(DOCUMENT_ID), RAWTOHEX(METADOCUMENT_ID), RAWTOHEX(PATIENT_ID), RAWTOHEX(VISIT_ID), RAWTOHEX(VISIT_UNIT_ID), "ID_ENTREPOT", "ID_PAT", "ID_SEJ", "ID_MVT", "ID_LOT", "UPDATED_AT", "UNIT", "DELEGATE_UNIT", "HIERARCHY_UNIT", "TITLE", "DOCUMENT_TYPE", "CREATED_AT", "BODY", "AUTHOR", "INSTANCE_ID", "PATIENT_AGE", "FORMAT" FROM "DTM_261"."DOCUMENT") x) [numPartitions=1] [codegen id : 1]
Output [22]: [RAWTOHEX(DOCUMENT_ID)#56627, RAWTOHEX(METADOCUMENT_ID)#56628, RAWTOHEX(PATIENT_ID)#56629, RAWTOHEX(VISIT_ID)#56630, RAWTOHEX(VISIT_UNIT_ID)#56631, ID_ENTREPOT#56632, ID_PAT#56633, ID_SEJ#56634, ID_MVT#56635, ID_LOT#56636, UPDATED_AT#56637, UNIT#56638, DELEGATE_UNIT#56639, HIERARCHY_UNIT#56640, TITLE#56641, DOCUMENT_TYPE#56642, CREATED_AT#56643, BODY#56644, AUTHOR#56645, INSTANCE_ID#56646, PATIENT_AGE#56647, FORMAT#56648]
ReadSchema: struct<RAWTOHEX(DOCUMENT_ID):string,RAWTOHEX(METADOCUMENT_ID):string,RAWTOHEX(PATIENT_ID):string,RAWTOHEX(VISIT_ID):string,RAWTOHEX(VISIT_UNIT_ID):string,ID_ENTREPOT:decimal(38,0),ID_PAT:decimal(38,0),ID_SEJ:decimal(38,0),ID_MVT:decimal(38,0),ID_LOT:decimal(38,0),UPDATED_AT:timestamp,UNIT:string,DELEGATE_UNIT:string,HIERARCHY_UNIT:string,TITLE:string,DOCUMENT_TYPE:string,CREATED_AT:timestamp,BODY:string,AUTHOR:string,INSTANCE_ID:string,PATIENT_AGE:decimal(38,0),FORMAT:string>
(2) CollectLimit
Input [22]: [RAWTOHEX(DOCUMENT_ID)#56627, RAWTOHEX(METADOCUMENT_ID)#56628, RAWTOHEX(PATIENT_ID)#56629, RAWTOHEX(VISIT_ID)#56630, RAWTOHEX(VISIT_UNIT_ID)#56631, ID_ENTREPOT#56632, ID_PAT#56633, ID_SEJ#56634, ID_MVT#56635, ID_LOT#56636, UPDATED_AT#56637, UNIT#56638, DELEGATE_UNIT#56639, HIERARCHY_UNIT#56640, TITLE#56641, DOCUMENT_TYPE#56642, CREATED_AT#56643, BODY#56644, AUTHOR#56645, INSTANCE_ID#56646, PATIENT_AGE#56647, FORMAT#56648]
Arguments: 500