digraph G {
0 [labelType="html" label="<b>Execute InsertIntoHadoopFsRelationCommand</b><br><br>task commit time: 1 ms<br>number of written files: 1<br>job commit time: 8 ms<br>number of output rows: 1,382<br>number of dynamic part: 0<br>written output: 32.7 KiB"];
1 [labelType="html" label="<br><b>WriteFiles</b><br><br>"];
subgraph cluster2 {
isCluster="true";
label="WholeStageCodegen (1)\n \nduration: 125 ms";
3 [labelType="html" label="<br><b>Project</b><br><br>"];
4 [labelType="html" label="<b>Scan JDBCRelation((SELECT \"VISIT_UNIT_ID\", \"VISIT_ID\", \"PATIENT_ID\", \"UNIT\", \"ACTIVITY\", \"IN_DATE\", \"OUT_DATE\" FROM \"DTM_622\".\"VISIT_UNIT\") x) [numPartitions=1] </b><br><br>number of output rows: 1,382"];
}
1->0;
3->1;
4->3;
}
5
Execute InsertIntoHadoopFsRelationCommand file:/data/output/cache/parquet/uet/VISIT_UNIT_3357, false, Parquet, [path=file:///data/output/cache/parquet/uet/VISIT_UNIT_3357], Overwrite, [ACTIVITY_3362, IN_DATE_3363, OUT_DATE_3364, PATIENT_ID_3360, UNIT_3361, VISIT_ID_3359, VISIT_UNIT_ID_3358]
WriteFiles
Project [ACTIVITY#4373 AS ACTIVITY_3362#4418, IN_DATE#4374 AS IN_DATE_3363#4419, OUT_DATE#4375 AS OUT_DATE_3364#4420, null AS PATIENT_ID_3360#4421, UNIT#4372 AS UNIT_3361#4422, null AS VISIT_ID_3359#4423, null AS VISIT_UNIT_ID_3358#4424]
Scan JDBCRelation((SELECT "VISIT_UNIT_ID", "VISIT_ID", "PATIENT_ID", "UNIT", "ACTIVITY", "IN_DATE", "OUT_DATE" FROM "DTM_622"."VISIT_UNIT") x) [numPartitions=1] [ACTIVITY#4373,IN_DATE#4374,OUT_DATE#4375,UNIT#4372] PushedFilters: [], ReadSchema: struct<ACTIVITY:string,IN_DATE:timestamp,OUT_DATE:timestamp,UNIT:string>
WholeStageCodegen (1)
== Physical Plan ==
Execute InsertIntoHadoopFsRelationCommand (4)
+- WriteFiles (3)
+- * Project (2)
+- * Scan JDBCRelation((SELECT "VISIT_UNIT_ID", "VISIT_ID", "PATIENT_ID", "UNIT", "ACTIVITY", "IN_DATE", "OUT_DATE" FROM "DTM_622"."VISIT_UNIT") x) [numPartitions=1] (1)
(1) Scan JDBCRelation((SELECT "VISIT_UNIT_ID", "VISIT_ID", "PATIENT_ID", "UNIT", "ACTIVITY", "IN_DATE", "OUT_DATE" FROM "DTM_622"."VISIT_UNIT") x) [numPartitions=1] [codegen id : 1]
Output [4]: [ACTIVITY#4373, IN_DATE#4374, OUT_DATE#4375, UNIT#4372]
ReadSchema: struct<ACTIVITY:string,IN_DATE:timestamp,OUT_DATE:timestamp,UNIT:string>
(2) Project [codegen id : 1]
Output [7]: [ACTIVITY#4373 AS ACTIVITY_3362#4418, IN_DATE#4374 AS IN_DATE_3363#4419, OUT_DATE#4375 AS OUT_DATE_3364#4420, null AS PATIENT_ID_3360#4421, UNIT#4372 AS UNIT_3361#4422, null AS VISIT_ID_3359#4423, null AS VISIT_UNIT_ID_3358#4424]
Input [4]: [ACTIVITY#4373, IN_DATE#4374, OUT_DATE#4375, UNIT#4372]
(3) WriteFiles
Input [7]: [ACTIVITY_3362#4418, IN_DATE_3363#4419, OUT_DATE_3364#4420, PATIENT_ID_3360#4421, UNIT_3361#4422, VISIT_ID_3359#4423, VISIT_UNIT_ID_3358#4424]
(4) Execute InsertIntoHadoopFsRelationCommand
Input: []
Arguments: file:/data/output/cache/parquet/uet/VISIT_UNIT_3357, false, Parquet, [path=file:///data/output/cache/parquet/uet/VISIT_UNIT_3357], Overwrite, [ACTIVITY_3362, IN_DATE_3363, OUT_DATE_3364, PATIENT_ID_3360, UNIT_3361, VISIT_ID_3359, VISIT_UNIT_ID_3358]