== 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_4960184047766528`, false, true, LocalTempView, true
(3) LogicalRelation
Arguments: JDBCRelation("SDATA_YEWU"."t_materials_list") [numPartitions=1], [data_id#39722, material_code#39723, material_name#39724, model#39725, unit#39726, whether_audited#39727, specification#39728, brand#39729, bom_number#39730, material_number_erp#39731, material_description#39732, material_note#39733, quantity#39734, warning_content#39735, warehouse_date#39736, storage_age#39737, whether_age_warning#39738, del_flag#39739, create_member#39740, office_id#39741, create_time#39742, create_member_ip_address#39743, last_modifier#39744, last_modify_time#39745, last_modify_ip_address#39746], false
(4) Project
Arguments: [data_id#39722, material_code#39723, material_name#39724, model#39725, unit#39726, whether_audited#39727, specification#39728, brand#39729, bom_number#39730, material_number_erp#39731, material_description#39732, material_note#39733, quantity#39734, warning_content#39735, warehouse_date#39736, storage_age#39737, whether_age_warning#39738, del_flag#39739, create_member#39740, office_id#39741, create_time#39742, create_member_ip_address#39743, last_modifier#39744, last_modify_time#39745, last_modify_ip_address#39746]
(5) View
Arguments: `view_4960184043179008`, true
(6) SubqueryAlias
Arguments: view_4960184043179008
(7) LogicalRelation
Arguments: JDBCRelation("SDATA_YEWU"."t_bpbjgl_warning_configure") [numPartitions=1], [data_id#39887, material_number#39888, name#39889, lower#39890, low#39891, HIGH#39892, higher#39893, warning_days#39894, create_member#39895, office_id#39896, create_time#39897, create_member_ip_address#39898, last_modifier#39899, last_modify_time#39900, last_modifier_ip_address#39901], false
(8) Project
Arguments: [data_id#39887, material_number#39888, name#39889, lower#39890, low#39891, HIGH#39892, higher#39893, warning_days#39894, create_member#39895, office_id#39896, create_time#39897, create_member_ip_address#39898, last_modifier#39899, last_modify_time#39900, last_modifier_ip_address#39901]
(9) View
Arguments: `view_4960184042523648`, true
(10) SubqueryAlias
Arguments: view_4960184042523648
(11) Join
Arguments: LeftOuter, (data_id#39722 = material_number#39888)
(12) Project
Arguments: [data_id#39722, material_code#39723, material_name#39724, model#39725, unit#39726, whether_audited#39727, specification#39728, brand#39729, bom_number#39730, material_number_erp#39731, material_description#39732, material_note#39733, quantity#39734, warning_content#39735, warehouse_date#39736, storage_age#39737, whether_age_warning#39738, del_flag#39739, create_member#39740, office_id#39741, create_time#39742, create_member_ip_address#39743, last_modifier#39744, last_modify_time#39745, ... 4 more fields]