== 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_4948859434306560`, false, true, LocalTempView, true
(3) LogicalRelation
Arguments: JDBCRelation("SDATA_YEWU"."t_materials_list") [numPartitions=1], [data_id#35798, material_code#35799, material_name#35800, model#35801, unit#35802, whether_audited#35803, specification#35804, brand#35805, bom_number#35806, material_number_erp#35807, material_description#35808, material_note#35809, quantity#35810, warning_content#35811, warehouse_date#35812, storage_age#35813, whether_age_warning#35814, del_flag#35815, create_member#35816, office_id#35817, create_time#35818, create_member_ip_address#35819, last_modifier#35820, last_modify_time#35821, last_modify_ip_address#35822], false
(4) Project
Arguments: [data_id#35798, material_code#35799, material_name#35800, model#35801, unit#35802, whether_audited#35803, specification#35804, brand#35805, bom_number#35806, material_number_erp#35807, material_description#35808, material_note#35809, quantity#35810, warning_content#35811, warehouse_date#35812, storage_age#35813, whether_age_warning#35814, del_flag#35815, create_member#35816, office_id#35817, create_time#35818, create_member_ip_address#35819, last_modifier#35820, last_modify_time#35821, last_modify_ip_address#35822]
(5) View
Arguments: `view_4948859428277248`, true
(6) SubqueryAlias
Arguments: view_4948859428277248
(7) LogicalRelation
Arguments: JDBCRelation("SDATA_YEWU"."t_bpbjgl_warning_configure") [numPartitions=1], [data_id#35963, material_number#35964, name#35965, lower#35966, low#35967, HIGH#35968, higher#35969, warning_days#35970, create_member#35971, office_id#35972, create_time#35973, create_member_ip_address#35974, last_modifier#35975, last_modify_time#35976, last_modifier_ip_address#35977], false
(8) Project
Arguments: [data_id#35963, material_number#35964, name#35965, lower#35966, low#35967, HIGH#35968, higher#35969, warning_days#35970, create_member#35971, office_id#35972, create_time#35973, create_member_ip_address#35974, last_modifier#35975, last_modify_time#35976, last_modifier_ip_address#35977]
(9) View
Arguments: `view_4948859427621888`, true
(10) SubqueryAlias
Arguments: view_4948859427621888
(11) Join
Arguments: LeftOuter, (data_id#35798 = material_number#35964)
(12) Project
Arguments: [data_id#35798, material_code#35799, material_name#35800, model#35801, unit#35802, whether_audited#35803, specification#35804, brand#35805, bom_number#35806, material_number_erp#35807, material_description#35808, material_note#35809, quantity#35810, warning_content#35811, warehouse_date#35812, storage_age#35813, whether_age_warning#35814, del_flag#35815, create_member#35816, office_id#35817, create_time#35818, create_member_ip_address#35819, last_modifier#35820, last_modify_time#35821, ... 4 more fields]