== 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_4869587104828416`, false, true, LocalTempView, true
(3) LogicalRelation
Arguments: JDBCRelation("SDATA_YEWU"."t_materials_list") [numPartitions=1], [data_id#8330, material_code#8331, material_name#8332, model#8333, unit#8334, whether_audited#8335, specification#8336, brand#8337, bom_number#8338, material_number_erp#8339, material_description#8340, material_note#8341, quantity#8342, warning_content#8343, warehouse_date#8344, storage_age#8345, whether_age_warning#8346, del_flag#8347, create_member#8348, office_id#8349, create_time#8350, create_member_ip_address#8351, last_modifier#8352, last_modify_time#8353, last_modify_ip_address#8354], false
(4) Project
Arguments: [data_id#8330, material_code#8331, material_name#8332, model#8333, unit#8334, whether_audited#8335, specification#8336, brand#8337, bom_number#8338, material_number_erp#8339, material_description#8340, material_note#8341, quantity#8342, warning_content#8343, warehouse_date#8344, storage_age#8345, whether_age_warning#8346, del_flag#8347, create_member#8348, office_id#8349, create_time#8350, create_member_ip_address#8351, last_modifier#8352, last_modify_time#8353, last_modify_ip_address#8354]
(5) View
Arguments: `view_4869587093949440`, true
(6) SubqueryAlias
Arguments: view_4869587093949440
(7) LogicalRelation
Arguments: JDBCRelation("SDATA_YEWU"."t_bpbjgl_warning_configure") [numPartitions=1], [data_id#8495, material_number#8496, name#8497, lower#8498, low#8499, HIGH#8500, higher#8501, warning_days#8502, create_member#8503, office_id#8504, create_time#8505, create_member_ip_address#8506, last_modifier#8507, last_modify_time#8508, last_modifier_ip_address#8509], false
(8) Project
Arguments: [data_id#8495, material_number#8496, name#8497, lower#8498, low#8499, HIGH#8500, higher#8501, warning_days#8502, create_member#8503, office_id#8504, create_time#8505, create_member_ip_address#8506, last_modifier#8507, last_modify_time#8508, last_modifier_ip_address#8509]
(9) View
Arguments: `view_4869587092769792`, true
(10) SubqueryAlias
Arguments: view_4869587092769792
(11) Join
Arguments: LeftOuter, (data_id#8330 = material_number#8496)
(12) Project
Arguments: [data_id#8330, material_code#8331, material_name#8332, model#8333, unit#8334, whether_audited#8335, specification#8336, brand#8337, bom_number#8338, material_number_erp#8339, material_description#8340, material_note#8341, quantity#8342, warning_content#8343, warehouse_date#8344, storage_age#8345, whether_age_warning#8346, del_flag#8347, create_member#8348, office_id#8349, create_time#8350, create_member_ip_address#8351, last_modifier#8352, last_modify_time#8353, ... 4 more fields]