== 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_4971508701334528`, false, true, LocalTempView, true
(3) LogicalRelation
Arguments: JDBCRelation("SDATA_YEWU"."t_materials_list") [numPartitions=1], [data_id#43646, material_code#43647, material_name#43648, model#43649, unit#43650, whether_audited#43651, specification#43652, brand#43653, bom_number#43654, material_number_erp#43655, material_description#43656, material_note#43657, quantity#43658, warning_content#43659, warehouse_date#43660, storage_age#43661, whether_age_warning#43662, del_flag#43663, create_member#43664, office_id#43665, create_time#43666, create_member_ip_address#43667, last_modifier#43668, last_modify_time#43669, last_modify_ip_address#43670], false
(4) Project
Arguments: [data_id#43646, material_code#43647, material_name#43648, model#43649, unit#43650, whether_audited#43651, specification#43652, brand#43653, bom_number#43654, material_number_erp#43655, material_description#43656, material_note#43657, quantity#43658, warning_content#43659, warehouse_date#43660, storage_age#43661, whether_age_warning#43662, del_flag#43663, create_member#43664, office_id#43665, create_time#43666, create_member_ip_address#43667, last_modifier#43668, last_modify_time#43669, last_modify_ip_address#43670]
(5) View
Arguments: `view_4971508692683776`, true
(6) SubqueryAlias
Arguments: view_4971508692683776
(7) LogicalRelation
Arguments: JDBCRelation("SDATA_YEWU"."t_bpbjgl_warning_configure") [numPartitions=1], [data_id#43811, material_number#43812, name#43813, lower#43814, low#43815, HIGH#43816, higher#43817, warning_days#43818, create_member#43819, office_id#43820, create_time#43821, create_member_ip_address#43822, last_modifier#43823, last_modify_time#43824, last_modifier_ip_address#43825], false
(8) Project
Arguments: [data_id#43811, material_number#43812, name#43813, lower#43814, low#43815, HIGH#43816, higher#43817, warning_days#43818, create_member#43819, office_id#43820, create_time#43821, create_member_ip_address#43822, last_modifier#43823, last_modify_time#43824, last_modifier_ip_address#43825]
(9) View
Arguments: `view_4971508691766272`, true
(10) SubqueryAlias
Arguments: view_4971508691766272
(11) Join
Arguments: LeftOuter, (data_id#43646 = material_number#43812)
(12) Project
Arguments: [data_id#43646, material_code#43647, material_name#43648, model#43649, unit#43650, whether_audited#43651, specification#43652, brand#43653, bom_number#43654, material_number_erp#43655, material_description#43656, material_note#43657, quantity#43658, warning_content#43659, warehouse_date#43660, storage_age#43661, whether_age_warning#43662, del_flag#43663, create_member#43664, office_id#43665, create_time#43666, create_member_ip_address#43667, last_modifier#43668, last_modify_time#43669, ... 4 more fields]