== 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_4914885553949696`, false, true, LocalTempView, true
(3) LogicalRelation
Arguments: JDBCRelation("SDATA_YEWU"."t_materials_list") [numPartitions=1], [data_id#24026, material_code#24027, material_name#24028, model#24029, unit#24030, whether_audited#24031, specification#24032, brand#24033, bom_number#24034, material_number_erp#24035, material_description#24036, material_note#24037, quantity#24038, warning_content#24039, warehouse_date#24040, storage_age#24041, whether_age_warning#24042, del_flag#24043, create_member#24044, office_id#24045, create_time#24046, create_member_ip_address#24047, last_modifier#24048, last_modify_time#24049, last_modify_ip_address#24050], false
(4) Project
Arguments: [data_id#24026, material_code#24027, material_name#24028, model#24029, unit#24030, whether_audited#24031, specification#24032, brand#24033, bom_number#24034, material_number_erp#24035, material_description#24036, material_note#24037, quantity#24038, warning_content#24039, warehouse_date#24040, storage_age#24041, whether_age_warning#24042, del_flag#24043, create_member#24044, office_id#24045, create_time#24046, create_member_ip_address#24047, last_modifier#24048, last_modify_time#24049, last_modify_ip_address#24050]
(5) View
Arguments: `view_4914885548837888`, true
(6) SubqueryAlias
Arguments: view_4914885548837888
(7) LogicalRelation
Arguments: JDBCRelation("SDATA_YEWU"."t_bpbjgl_warning_configure") [numPartitions=1], [data_id#24191, material_number#24192, name#24193, lower#24194, low#24195, HIGH#24196, higher#24197, warning_days#24198, create_member#24199, office_id#24200, create_time#24201, create_member_ip_address#24202, last_modifier#24203, last_modify_time#24204, last_modifier_ip_address#24205], false
(8) Project
Arguments: [data_id#24191, material_number#24192, name#24193, lower#24194, low#24195, HIGH#24196, higher#24197, warning_days#24198, create_member#24199, office_id#24200, create_time#24201, create_member_ip_address#24202, last_modifier#24203, last_modify_time#24204, last_modifier_ip_address#24205]
(9) View
Arguments: `view_4914885548182528`, true
(10) SubqueryAlias
Arguments: view_4914885548182528
(11) Join
Arguments: LeftOuter, (data_id#24026 = material_number#24192)
(12) Project
Arguments: [data_id#24026, material_code#24027, material_name#24028, model#24029, unit#24030, whether_audited#24031, specification#24032, brand#24033, bom_number#24034, material_number_erp#24035, material_description#24036, material_note#24037, quantity#24038, warning_content#24039, warehouse_date#24040, storage_age#24041, whether_age_warning#24042, del_flag#24043, create_member#24044, office_id#24045, create_time#24046, create_member_ip_address#24047, last_modifier#24048, last_modify_time#24049, ... 4 more fields]