digraph G {
0 [labelType="html" label="<b>Execute InsertIntoHadoopFsRelationCommand</b><br><br>task commit time: 14 ms<br>number of written files: 1<br>job commit time: 19 ms<br>number of output rows: 155<br>number of dynamic part: 0<br>written output: 6.6 KiB"];
1 [labelType="html" label="<br><b>WriteFiles</b><br><br>"];
subgraph cluster2 {
isCluster="true";
label="WholeStageCodegen (1)\n \nduration: 657 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\", \"ID_MVT\", \"ID_SEJ\", \"ID_PAT\", \"UNIT\", \"ACTIVITY\", \"IN_DATE\", \"OUT_DATE\" FROM \"DTM_261\".\"VISIT_UNIT\") x) [numPartitions=1] </b><br><br>number of output rows: 155"];
}
1->0;
3->1;
4->3;
}
5
Execute InsertIntoHadoopFsRelationCommand file:/data/output/cache/parquet/uet/VISIT_UNIT_2958, false, Parquet, [path=file:///data/output/cache/parquet/uet/VISIT_UNIT_2958], Overwrite, [ACTIVITY_2966, ID_MVT_2962, ID_PAT_2964, ID_SEJ_2963, IN_DATE_2967, OUT_DATE_2968, PATIENT_ID_2961, UNIT_2965, VISIT_ID_2960, VISIT_UNIT_ID_2959]
WriteFiles
Project [ACTIVITY#3367 AS ACTIVITY_2966#3431, staticinvoke(class org.apache.spark.sql.catalyst.util.CharVarcharCodegenUtils, StringType, readSidePadding, ID_MVT#3363, 20, true, false, true) AS ID_MVT_2962#3432, cast(ID_PAT#3365 as int) AS ID_PAT_2964#3433, cast(ID_SEJ#3364 as int) AS ID_SEJ_2963#3434, IN_DATE#3368 AS IN_DATE_2967#3435, OUT_DATE#3369 AS OUT_DATE_2968#3436, null AS PATIENT_ID_2961#3437, UNIT#3366 AS UNIT_2965#3438, null AS VISIT_ID_2960#3439, null AS VISIT_UNIT_ID_2959#3440]
Scan JDBCRelation((SELECT "VISIT_UNIT_ID", "VISIT_ID", "PATIENT_ID", "ID_MVT", "ID_SEJ", "ID_PAT", "UNIT", "ACTIVITY", "IN_DATE", "OUT_DATE" FROM "DTM_261"."VISIT_UNIT") x) [numPartitions=1] [ACTIVITY#3367,ID_MVT#3363,ID_PAT#3365,ID_SEJ#3364,IN_DATE#3368,OUT_DATE#3369,UNIT#3366] PushedFilters: [], ReadSchema: struct<ACTIVITY:string,ID_MVT:string,ID_PAT:decimal(38,0),ID_SEJ:decimal(38,0),IN_DATE:timestamp,...
WholeStageCodegen (1)
== Physical Plan ==
Execute InsertIntoHadoopFsRelationCommand (4)
+- WriteFiles (3)
+- * Project (2)
+- * Scan JDBCRelation((SELECT "VISIT_UNIT_ID", "VISIT_ID", "PATIENT_ID", "ID_MVT", "ID_SEJ", "ID_PAT", "UNIT", "ACTIVITY", "IN_DATE", "OUT_DATE" FROM "DTM_261"."VISIT_UNIT") x) [numPartitions=1] (1)
(1) Scan JDBCRelation((SELECT "VISIT_UNIT_ID", "VISIT_ID", "PATIENT_ID", "ID_MVT", "ID_SEJ", "ID_PAT", "UNIT", "ACTIVITY", "IN_DATE", "OUT_DATE" FROM "DTM_261"."VISIT_UNIT") x) [numPartitions=1] [codegen id : 1]
Output [7]: [ACTIVITY#3367, ID_MVT#3363, ID_PAT#3365, ID_SEJ#3364, IN_DATE#3368, OUT_DATE#3369, UNIT#3366]
ReadSchema: struct<ACTIVITY:string,ID_MVT:string,ID_PAT:decimal(38,0),ID_SEJ:decimal(38,0),IN_DATE:timestamp,OUT_DATE:timestamp,UNIT:string>
(2) Project [codegen id : 1]
Output [10]: [ACTIVITY#3367 AS ACTIVITY_2966#3431, staticinvoke(class org.apache.spark.sql.catalyst.util.CharVarcharCodegenUtils, StringType, readSidePadding, ID_MVT#3363, 20, true, false, true) AS ID_MVT_2962#3432, cast(ID_PAT#3365 as int) AS ID_PAT_2964#3433, cast(ID_SEJ#3364 as int) AS ID_SEJ_2963#3434, IN_DATE#3368 AS IN_DATE_2967#3435, OUT_DATE#3369 AS OUT_DATE_2968#3436, null AS PATIENT_ID_2961#3437, UNIT#3366 AS UNIT_2965#3438, null AS VISIT_ID_2960#3439, null AS VISIT_UNIT_ID_2959#3440]
Input [7]: [ACTIVITY#3367, ID_MVT#3363, ID_PAT#3365, ID_SEJ#3364, IN_DATE#3368, OUT_DATE#3369, UNIT#3366]
(3) WriteFiles
Input [10]: [ACTIVITY_2966#3431, ID_MVT_2962#3432, ID_PAT_2964#3433, ID_SEJ_2963#3434, IN_DATE_2967#3435, OUT_DATE_2968#3436, PATIENT_ID_2961#3437, UNIT_2965#3438, VISIT_ID_2960#3439, VISIT_UNIT_ID_2959#3440]
(4) Execute InsertIntoHadoopFsRelationCommand
Input: []
Arguments: file:/data/output/cache/parquet/uet/VISIT_UNIT_2958, false, Parquet, [path=file:///data/output/cache/parquet/uet/VISIT_UNIT_2958], Overwrite, [ACTIVITY_2966, ID_MVT_2962, ID_PAT_2964, ID_SEJ_2963, IN_DATE_2967, OUT_DATE_2968, PATIENT_ID_2961, UNIT_2965, VISIT_ID_2960, VISIT_UNIT_ID_2959]