== 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_4937534839852032`, false, true, LocalTempView, true
(3) LogicalRelation
Arguments: JDBCRelation("SDATA_YEWU"."t_materials_list") [numPartitions=1], [data_id#31874, material_code#31875, material_name#31876, model#31877, unit#31878, whether_audited#31879, specification#31880, brand#31881, bom_number#31882, material_number_erp#31883, material_description#31884, material_note#31885, quantity#31886, warning_content#31887, warehouse_date#31888, storage_age#31889, whether_age_warning#31890, del_flag#31891, create_member#31892, office_id#31893, create_time#31894, create_member_ip_address#31895, last_modifier#31896, last_modify_time#31897, last_modify_ip_address#31898], false
(4) Project
Arguments: [data_id#31874, material_code#31875, material_name#31876, model#31877, unit#31878, whether_audited#31879, specification#31880, brand#31881, bom_number#31882, material_number_erp#31883, material_description#31884, material_note#31885, quantity#31886, warning_content#31887, warehouse_date#31888, storage_age#31889, whether_age_warning#31890, del_flag#31891, create_member#31892, office_id#31893, create_time#31894, create_member_ip_address#31895, last_modifier#31896, last_modify_time#31897, last_modify_ip_address#31898]
(5) View
Arguments: `view_4937534834609152`, true
(6) SubqueryAlias
Arguments: view_4937534834609152
(7) LogicalRelation
Arguments: JDBCRelation("SDATA_YEWU"."t_bpbjgl_warning_configure") [numPartitions=1], [data_id#32039, material_number#32040, name#32041, lower#32042, low#32043, HIGH#32044, higher#32045, warning_days#32046, create_member#32047, office_id#32048, create_time#32049, create_member_ip_address#32050, last_modifier#32051, last_modify_time#32052, last_modifier_ip_address#32053], false
(8) Project
Arguments: [data_id#32039, material_number#32040, name#32041, lower#32042, low#32043, HIGH#32044, higher#32045, warning_days#32046, create_member#32047, office_id#32048, create_time#32049, create_member_ip_address#32050, last_modifier#32051, last_modify_time#32052, last_modifier_ip_address#32053]
(9) View
Arguments: `view_4937534833953792`, true
(10) SubqueryAlias
Arguments: view_4937534833953792
(11) Join
Arguments: LeftOuter, (data_id#31874 = material_number#32040)
(12) Project
Arguments: [data_id#31874, material_code#31875, material_name#31876, model#31877, unit#31878, whether_audited#31879, specification#31880, brand#31881, bom_number#31882, material_number_erp#31883, material_description#31884, material_note#31885, quantity#31886, warning_content#31887, warehouse_date#31888, storage_age#31889, whether_age_warning#31890, del_flag#31891, create_member#31892, office_id#31893, create_time#31894, create_member_ip_address#31895, last_modifier#31896, last_modify_time#31897, ... 4 more fields]