== 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_4926210202668032`, false, true, LocalTempView, true
(3) LogicalRelation
Arguments: JDBCRelation("SDATA_YEWU"."t_materials_list") [numPartitions=1], [data_id#27950, material_code#27951, material_name#27952, model#27953, unit#27954, whether_audited#27955, specification#27956, brand#27957, bom_number#27958, material_number_erp#27959, material_description#27960, material_note#27961, quantity#27962, warning_content#27963, warehouse_date#27964, storage_age#27965, whether_age_warning#27966, del_flag#27967, create_member#27968, office_id#27969, create_time#27970, create_member_ip_address#27971, last_modifier#27972, last_modify_time#27973, last_modify_ip_address#27974], false
(4) Project
Arguments: [data_id#27950, material_code#27951, material_name#27952, model#27953, unit#27954, whether_audited#27955, specification#27956, brand#27957, bom_number#27958, material_number_erp#27959, material_description#27960, material_note#27961, quantity#27962, warning_content#27963, warehouse_date#27964, storage_age#27965, whether_age_warning#27966, del_flag#27967, create_member#27968, office_id#27969, create_time#27970, create_member_ip_address#27971, last_modifier#27972, last_modify_time#27973, last_modify_ip_address#27974]
(5) View
Arguments: `view_4926210194017280`, true
(6) SubqueryAlias
Arguments: view_4926210194017280
(7) LogicalRelation
Arguments: JDBCRelation("SDATA_YEWU"."t_bpbjgl_warning_configure") [numPartitions=1], [data_id#28115, material_number#28116, name#28117, lower#28118, low#28119, HIGH#28120, higher#28121, warning_days#28122, create_member#28123, office_id#28124, create_time#28125, create_member_ip_address#28126, last_modifier#28127, last_modify_time#28128, last_modifier_ip_address#28129], false
(8) Project
Arguments: [data_id#28115, material_number#28116, name#28117, lower#28118, low#28119, HIGH#28120, higher#28121, warning_days#28122, create_member#28123, office_id#28124, create_time#28125, create_member_ip_address#28126, last_modifier#28127, last_modify_time#28128, last_modifier_ip_address#28129]
(9) View
Arguments: `view_4926210193361920`, true
(10) SubqueryAlias
Arguments: view_4926210193361920
(11) Join
Arguments: LeftOuter, (data_id#27950 = material_number#28116)
(12) Project
Arguments: [data_id#27950, material_code#27951, material_name#27952, model#27953, unit#27954, whether_audited#27955, specification#27956, brand#27957, bom_number#27958, material_number_erp#27959, material_description#27960, material_note#27961, quantity#27962, warning_content#27963, warehouse_date#27964, storage_age#27965, whether_age_warning#27966, del_flag#27967, create_member#27968, office_id#27969, create_time#27970, create_member_ip_address#27971, last_modifier#27972, last_modify_time#27973, ... 4 more fields]