== Physical Plan ==
Execute CreateViewCommand (1)
+- CreateViewCommand (2)
+- Project (12)
+- Join (11)
:- SubqueryAlias (6)
: +- View (5)
: +- Project (4)
: +- LogicalRelation (3)
+- SubqueryAlias (10)
+- View (9)
+- Project (8)
+- LogicalRelation (7)
(1) Execute CreateViewCommand
Output: []
(2) CreateViewCommand
Arguments: `view_4892236344462336`, false, true, LocalTempView, true
(3) LogicalRelation
Arguments: JDBCRelation("SDATA_YEWU"."t_materials_list") [numPartitions=1], [data_id#16178, material_code#16179, material_name#16180, model#16181, unit#16182, whether_audited#16183, specification#16184, brand#16185, bom_number#16186, material_number_erp#16187, material_description#16188, material_note#16189, quantity#16190, warning_content#16191, warehouse_date#16192, storage_age#16193, whether_age_warning#16194, del_flag#16195, create_member#16196, office_id#16197, create_time#16198, create_member_ip_address#16199, last_modifier#16200, last_modify_time#16201, last_modify_ip_address#16202], false
(4) Project
Arguments: [data_id#16178, material_code#16179, material_name#16180, model#16181, unit#16182, whether_audited#16183, specification#16184, brand#16185, bom_number#16186, material_number_erp#16187, material_description#16188, material_note#16189, quantity#16190, warning_content#16191, warehouse_date#16192, storage_age#16193, whether_age_warning#16194, del_flag#16195, create_member#16196, office_id#16197, create_time#16198, create_member_ip_address#16199, last_modifier#16200, last_modify_time#16201, last_modify_ip_address#16202]
(5) View
Arguments: `view_4892236333583360`, true
(6) SubqueryAlias
Arguments: view_4892236333583360
(7) LogicalRelation
Arguments: JDBCRelation("SDATA_YEWU"."t_bpbjgl_warning_configure") [numPartitions=1], [data_id#16343, material_number#16344, name#16345, lower#16346, low#16347, HIGH#16348, higher#16349, warning_days#16350, create_member#16351, office_id#16352, create_time#16353, create_member_ip_address#16354, last_modifier#16355, last_modify_time#16356, last_modifier_ip_address#16357], false
(8) Project
Arguments: [data_id#16343, material_number#16344, name#16345, lower#16346, low#16347, HIGH#16348, higher#16349, warning_days#16350, create_member#16351, office_id#16352, create_time#16353, create_member_ip_address#16354, last_modifier#16355, last_modify_time#16356, last_modifier_ip_address#16357]
(9) View
Arguments: `view_4892236332665856`, true
(10) SubqueryAlias
Arguments: view_4892236332665856
(11) Join
Arguments: LeftOuter, (data_id#16178 = material_number#16344)
(12) Project
Arguments: [data_id#16178, material_code#16179, material_name#16180, model#16181, unit#16182, whether_audited#16183, specification#16184, brand#16185, bom_number#16186, material_number_erp#16187, material_description#16188, material_note#16189, quantity#16190, warning_content#16191, warehouse_date#16192, storage_age#16193, whether_age_warning#16194, del_flag#16195, create_member#16196, office_id#16197, create_time#16198, create_member_ip_address#16199, last_modifier#16200, last_modify_time#16201, ... 4 more fields]