== 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_4846938043714560`, false, true, LocalTempView, true
(3) LogicalRelation
Arguments: JDBCRelation("SDATA_YEWU"."t_materials_list") [numPartitions=1], [data_id#482, material_code#483, material_name#484, model#485, unit#486, whether_audited#487, specification#488, brand#489, bom_number#490, material_number_erp#491, material_description#492, material_note#493, quantity#494, warning_content#495, warehouse_date#496, storage_age#497, whether_age_warning#498, del_flag#499, create_member#500, office_id#501, create_time#502, create_member_ip_address#503, last_modifier#504, last_modify_time#505, last_modify_ip_address#506], false
(4) Project
Arguments: [data_id#482, material_code#483, material_name#484, model#485, unit#486, whether_audited#487, specification#488, brand#489, bom_number#490, material_number_erp#491, material_description#492, material_note#493, quantity#494, warning_content#495, warehouse_date#496, storage_age#497, whether_age_warning#498, del_flag#499, create_member#500, office_id#501, create_time#502, create_member_ip_address#503, last_modifier#504, last_modify_time#505, last_modify_ip_address#506]
(5) View
Arguments: `view_4846937960614912`, true
(6) SubqueryAlias
Arguments: view_4846937960614912
(7) LogicalRelation
Arguments: JDBCRelation("SDATA_YEWU"."t_bpbjgl_warning_configure") [numPartitions=1], [data_id#647, material_number#648, name#649, lower#650, low#651, HIGH#652, higher#653, warning_days#654, create_member#655, office_id#656, create_time#657, create_member_ip_address#658, last_modifier#659, last_modify_time#660, last_modifier_ip_address#661], false
(8) Project
Arguments: [data_id#647, material_number#648, name#649, lower#650, low#651, HIGH#652, higher#653, warning_days#654, create_member#655, office_id#656, create_time#657, create_member_ip_address#658, last_modifier#659, last_modify_time#660, last_modifier_ip_address#661]
(9) View
Arguments: `view_4846937954454528`, true
(10) SubqueryAlias
Arguments: view_4846937954454528
(11) Join
Arguments: LeftOuter, (data_id#482 = material_number#648)
(12) Project
Arguments: [data_id#482, material_code#483, material_name#484, model#485, unit#486, whether_audited#487, specification#488, brand#489, bom_number#490, material_number_erp#491, material_description#492, material_note#493, quantity#494, warning_content#495, warehouse_date#496, storage_age#497, whether_age_warning#498, del_flag#499, create_member#500, office_id#501, create_time#502, create_member_ip_address#503, last_modifier#504, last_modify_time#505, ... 4 more fields]