== 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_4880911722482688`, false, true, LocalTempView, true
(3) LogicalRelation
Arguments: JDBCRelation("SDATA_YEWU"."t_materials_list") [numPartitions=1], [data_id#12254, material_code#12255, material_name#12256, model#12257, unit#12258, whether_audited#12259, specification#12260, brand#12261, bom_number#12262, material_number_erp#12263, material_description#12264, material_note#12265, quantity#12266, warning_content#12267, warehouse_date#12268, storage_age#12269, whether_age_warning#12270, del_flag#12271, create_member#12272, office_id#12273, create_time#12274, create_member_ip_address#12275, last_modifier#12276, last_modify_time#12277, last_modify_ip_address#12278], false
(4) Project
Arguments: [data_id#12254, material_code#12255, material_name#12256, model#12257, unit#12258, whether_audited#12259, specification#12260, brand#12261, bom_number#12262, material_number_erp#12263, material_description#12264, material_note#12265, quantity#12266, warning_content#12267, warehouse_date#12268, storage_age#12269, whether_age_warning#12270, del_flag#12271, create_member#12272, office_id#12273, create_time#12274, create_member_ip_address#12275, last_modifier#12276, last_modify_time#12277, last_modify_ip_address#12278]
(5) View
Arguments: `view_4880911715666944`, true
(6) SubqueryAlias
Arguments: view_4880911715666944
(7) LogicalRelation
Arguments: JDBCRelation("SDATA_YEWU"."t_bpbjgl_warning_configure") [numPartitions=1], [data_id#12419, material_number#12420, name#12421, lower#12422, low#12423, HIGH#12424, higher#12425, warning_days#12426, create_member#12427, office_id#12428, create_time#12429, create_member_ip_address#12430, last_modifier#12431, last_modify_time#12432, last_modifier_ip_address#12433], false
(8) Project
Arguments: [data_id#12419, material_number#12420, name#12421, lower#12422, low#12423, HIGH#12424, higher#12425, warning_days#12426, create_member#12427, office_id#12428, create_time#12429, create_member_ip_address#12430, last_modifier#12431, last_modify_time#12432, last_modifier_ip_address#12433]
(9) View
Arguments: `view_4880911715011584`, true
(10) SubqueryAlias
Arguments: view_4880911715011584
(11) Join
Arguments: LeftOuter, (data_id#12254 = material_number#12420)
(12) Project
Arguments: [data_id#12254, material_code#12255, material_name#12256, model#12257, unit#12258, whether_audited#12259, specification#12260, brand#12261, bom_number#12262, material_number_erp#12263, material_description#12264, material_note#12265, quantity#12266, warning_content#12267, warehouse_date#12268, storage_age#12269, whether_age_warning#12270, del_flag#12271, create_member#12272, office_id#12273, create_time#12274, create_member_ip_address#12275, last_modifier#12276, last_modify_time#12277, ... 4 more fields]