== Physical Plan ==
AdaptiveSparkPlan (20)
+- == Final Plan ==
* HashAggregate (13)
+- * HashAggregate (12)
+- * Project (11)
+- * Filter (10)
+- FlatMapGroupsInPandas (9)
+- * Sort (8)
+- TableCacheQueryStage (7), Statistics(sizeInBytes=3.1 KiB, rowCount=5)
+- InMemoryTableScan (1)
+- InMemoryRelation (2)
+- AdaptiveSparkPlan (6)
+- Exchange (5)
+- Project (4)
+- Scan JDBCRelation((
SELECT
c.brand_context_id,
c.NetworkID,
c.Child_Node,
c.Parent_id,
ISNULL(c.supplier_id, '') AS supplier_id,
ISNULL(c.preferrd_supplier_id, '') AS preferrd_supplier_id,
ISNULL(c.Supplier_declaration_RefID, '') AS supplier_ref_id,
ISNULL(c.SupplierUID, '') AS supplier_uid,
ISNULL(c.SupplierName, '') AS supplier_name,
ISNULL(c.SupplierCountry, '') AS supplier_country,
ISNULL(c.DirectIndirectSupplier, '') AS direct_indirect,
ISNULL(c.source_type, '') AS source_type,
ISNULL(c.product_name, '') AS product_name,
c.tier,
CAST(ISNULL(c.is_latest, 0) AS BIT) AS is_latest,
CAST(ISNULL(c.is_latest_submitted, 0) AS BIT) AS is_latest_submitted,
CAST(ISNULL(c.is_unknown_supplier, 0) AS BIT) AS is_unknown_supplier,
ISNULL(c.company_id, '') AS company_id,
ISNULL(c.config_name, '') AS config_name,
ISNULL(c.Direct_Supplier_Name, '') AS direct_supplier_name,
ISNULL(rs.launch_request_name, '') AS launch_request_name,
ISNULL(rs.launch_config_ref, '') AS launch_config_ref,
rs.revision_version,
ISNULL(rs.submission_status, '') AS submission_status,
CONVERT(VARCHAR(30), rs.launch_date, 126) AS launch_date,
CONVERT(VARCHAR(30), rs.expiry_date, 126) AS expiry_date,
CONVERT(VARCHAR(30), rs.submitted_date, 126) AS submitted_date,
ISNULL(f.facility_id, '') AS facility_direct_id,
ISNULL(f.preferrd_facility_id, '') AS preferrd_facility_id,
ISNULL(f.facility_declaration_RefID, '') AS facility_ref_id,
ISNULL(f.FacilityName, '') AS facility_name,
ISNULL(f.FacilityCountry, '') AS facility_country,
ISNULL(f.FacilityCity, '') AS facility_city,
ISNULL(f.FacilityState, '') AS facility_state,
CAST(ISNULL(f.is_unknown_facility, 0) AS BIT) AS is_unknown_facility,
CAST(ISNULL(f.facility_Subcontractor, 0) AS BIT) AS facility_subcontractor,
ISNULL(f.Sub_supplier_declaration_ref, '') AS subcontractor_ref_id,
ISNULL(f.subcontractor_name, '') AS subcontractor_name,
ISNULL(f.subcontractor_country, '') AS subcontractor_country,
ISNULL(f.subcontractor_state, '') AS subcontractor_state,
ISNULL(f.subcontractor_city, '') AS subcontractor_city,
CAST(ISNULL(f.is_unknown_subcontractor, 0) AS BIT) AS is_unknown_subcontractor,
ISNULL(fm.Material, '') AS material,
ISNULL(fm.Value_process, '') AS value_process
FROM Datahub_dim_SCM_Chain c
JOIN Datahub_dim_SCM_Request_Status rs
ON rs.NetworkID = c.NetworkID
AND rs.brand_context_id = c.brand_context_id
AND rs.revision_version = c.revision_version
LEFT JOIN Datahub_dim_SCM_Facility f
ON f.NetworkID = c.NetworkID
AND f.brand_context_id = c.brand_context_id
AND f.Child_Node = c.Child_Node
AND f.fac_enabled = 1
AND f.is_latest_submitted = 1
LEFT JOIN Datahub_dim_SCM_Facility_Materials fm
ON fm.NetworkID = f.NetworkID
AND fm.facility_declaration_RefID = f.facility_declaration_RefID
AND fm.brand_context_id = f.brand_context_id
AND fm.Child_Node = f.Child_Node
AND fm.is_latest_submitted = 1
WHERE c.brand_context_id = '6aacf5861a41b434b2a90520'
AND c.is_latest_submitted = 1
AND c.NetworkID IN ('DCB3E899D1BC53F0D57A29EE55C4BE2123E5F606E53AE08EC44221543A506147')
) AS t) [numPartitions=1] (3)
+- == Initial Plan ==
HashAggregate (19)
+- HashAggregate (18)
+- Project (17)
+- Filter (16)
+- FlatMapGroupsInPandas (15)
+- Sort (14)
+- InMemoryTableScan (1)
+- InMemoryRelation (2)
+- AdaptiveSparkPlan (6)
+- Exchange (5)
+- Project (4)
+- Scan JDBCRelation((
SELECT
c.brand_context_id,
c.NetworkID,
c.Child_Node,
c.Parent_id,
ISNULL(c.supplier_id, '') AS supplier_id,
ISNULL(c.preferrd_supplier_id, '') AS preferrd_supplier_id,
ISNULL(c.Supplier_declaration_RefID, '') AS supplier_ref_id,
ISNULL(c.SupplierUID, '') AS supplier_uid,
ISNULL(c.SupplierName, '') AS supplier_name,
ISNULL(c.SupplierCountry, '') AS supplier_country,
ISNULL(c.DirectIndirectSupplier, '') AS direct_indirect,
ISNULL(c.source_type, '') AS source_type,
ISNULL(c.product_name, '') AS product_name,
c.tier,
CAST(ISNULL(c.is_latest, 0) AS BIT) AS is_latest,
CAST(ISNULL(c.is_latest_submitted, 0) AS BIT) AS is_latest_submitted,
CAST(ISNULL(c.is_unknown_supplier, 0) AS BIT) AS is_unknown_supplier,
ISNULL(c.company_id, '') AS company_id,
ISNULL(c.config_name, '') AS config_name,
ISNULL(c.Direct_Supplier_Name, '') AS direct_supplier_name,
ISNULL(rs.launch_request_name, '') AS launch_request_name,
ISNULL(rs.launch_config_ref, '') AS launch_config_ref,
rs.revision_version,
ISNULL(rs.submission_status, '') AS submission_status,
CONVERT(VARCHAR(30), rs.launch_date, 126) AS launch_date,
CONVERT(VARCHAR(30), rs.expiry_date, 126) AS expiry_date,
CONVERT(VARCHAR(30), rs.submitted_date, 126) AS submitted_date,
ISNULL(f.facility_id, '') AS facility_direct_id,
ISNULL(f.preferrd_facility_id, '') AS preferrd_facility_id,
ISNULL(f.facility_declaration_RefID, '') AS facility_ref_id,
ISNULL(f.FacilityName, '') AS facility_name,
ISNULL(f.FacilityCountry, '') AS facility_country,
ISNULL(f.FacilityCity, '') AS facility_city,
ISNULL(f.FacilityState, '') AS facility_state,
CAST(ISNULL(f.is_unknown_facility, 0) AS BIT) AS is_unknown_facility,
CAST(ISNULL(f.facility_Subcontractor, 0) AS BIT) AS facility_subcontractor,
ISNULL(f.Sub_supplier_declaration_ref, '') AS subcontractor_ref_id,
ISNULL(f.subcontractor_name, '') AS subcontractor_name,
ISNULL(f.subcontractor_country, '') AS subcontractor_country,
ISNULL(f.subcontractor_state, '') AS subcontractor_state,
ISNULL(f.subcontractor_city, '') AS subcontractor_city,
CAST(ISNULL(f.is_unknown_subcontractor, 0) AS BIT) AS is_unknown_subcontractor,
ISNULL(fm.Material, '') AS material,
ISNULL(fm.Value_process, '') AS value_process
FROM Datahub_dim_SCM_Chain c
JOIN Datahub_dim_SCM_Request_Status rs
ON rs.NetworkID = c.NetworkID
AND rs.brand_context_id = c.brand_context_id
AND rs.revision_version = c.revision_version
LEFT JOIN Datahub_dim_SCM_Facility f
ON f.NetworkID = c.NetworkID
AND f.brand_context_id = c.brand_context_id
AND f.Child_Node = c.Child_Node
AND f.fac_enabled = 1
AND f.is_latest_submitted = 1
LEFT JOIN Datahub_dim_SCM_Facility_Materials fm
ON fm.NetworkID = f.NetworkID
AND fm.facility_declaration_RefID = f.facility_declaration_RefID
AND fm.brand_context_id = f.brand_context_id
AND fm.Child_Node = f.Child_Node
AND fm.is_latest_submitted = 1
WHERE c.brand_context_id = '6aacf5861a41b434b2a90520'
AND c.is_latest_submitted = 1
AND c.NetworkID IN ('DCB3E899D1BC53F0D57A29EE55C4BE2123E5F606E53AE08EC44221543A506147')
) AS t) [numPartitions=1] (3)
(1) InMemoryTableScan
Output [48]: [NetworkID#12010773, brand_context_id#12010729, NetworkID#12010773, Child_Node#12010731, Parent_id#12010732, supplier_id#12010733, preferrd_supplier_id#12010734, supplier_ref_id#12010735, supplier_uid#12010736, supplier_name#12010737, supplier_country#12010738, direct_indirect#12010739, source_type#12010740, product_name#12010741, tier#12010742, is_latest#12010743, is_latest_submitted#12010744, is_unknown_supplier#12010745, company_id#12010746, config_name#12010747, direct_supplier_name#12010748, launch_request_name#12010749, launch_config_ref#12010750, revision_version#12010751, submission_status#12010752, launch_date#12010753, expiry_date#12010754, submitted_date#12010755, facility_direct_id#12010756, preferrd_facility_id#12010757, facility_ref_id#12010758, facility_name#12010759, facility_country#12010760, facility_city#12010761, facility_state#12010762, is_unknown_facility#12010763, facility_subcontractor#12010764, subcontractor_ref_id#12010765, subcontractor_name#12010766, subcontractor_country#12010767, subcontractor_state#12010768, subcontractor_city#12010769, is_unknown_subcontractor#12010770, material#12010771, value_process#12010772, node_id#12010818, _eff_sub#12010864, _eff_fac#12010911]
Arguments: [NetworkID#12010773, brand_context_id#12010729, NetworkID#12010773, Child_Node#12010731, Parent_id#12010732, supplier_id#12010733, preferrd_supplier_id#12010734, supplier_ref_id#12010735, supplier_uid#12010736, supplier_name#12010737, supplier_country#12010738, direct_indirect#12010739, source_type#12010740, product_name#12010741, tier#12010742, is_latest#12010743, is_latest_submitted#12010744, is_unknown_supplier#12010745, company_id#12010746, config_name#12010747, direct_supplier_name#12010748, launch_request_name#12010749, launch_config_ref#12010750, revision_version#12010751, ... 24 more fields]
(2) InMemoryRelation
Arguments: [brand_context_id#12010729, NetworkID#12010773, Child_Node#12010731, Parent_id#12010732, supplier_id#12010733, preferrd_supplier_id#12010734, supplier_ref_id#12010735, supplier_uid#12010736, supplier_name#12010737, supplier_country#12010738, direct_indirect#12010739, source_type#12010740, product_name#12010741, tier#12010742, is_latest#12010743, is_latest_submitted#12010744, is_unknown_supplier#12010745, company_id#12010746, config_name#12010747, direct_supplier_name#12010748, launch_request_name#12010749, launch_config_ref#12010750, revision_version#12010751, submission_status#12010752, ... 23 more fields], CachedRDDBuilder(org.apache.spark.sql.execution.columnar.DefaultCachedBatchSerializer@730ae8bf,StorageLevel(disk, memory, deserialized, 1 replicas),AdaptiveSparkPlan isFinalPlan=true
+- == Final Plan ==
ShuffleQueryStage 0
+- Exchange SinglePartition, REPARTITION_BY_NUM, [plan_id=3993734]
+- *(1) Project [brand_context_id#12010729, staticinvoke(class org.apache.spark.sql.catalyst.util.CharVarcharCodegenUtils, StringType, readSidePadding, NetworkID#12010730, 64, true, false, true) AS NetworkID#12010773, Child_Node#12010731, Parent_id#12010732, supplier_id#12010733, preferrd_supplier_id#12010734, supplier_ref_id#12010735, supplier_uid#12010736, supplier_name#12010737, supplier_country#12010738, direct_indirect#12010739, source_type#12010740, product_name#12010741, tier#12010742, is_latest#12010743, is_latest_submitted#12010744, is_unknown_supplier#12010745, company_id#12010746, config_name#12010747, direct_supplier_name#12010748, launch_request_name#12010749, launch_config_ref#12010750, revision_version#12010751, submission_status#12010752, ... 23 more fields]
+- *(1) Scan JDBCRelation((
SELECT
c.brand_context_id,
c.NetworkID,
c.Child_Node,
c.Parent_id,
ISNULL(c.supplier_id, '') AS supplier_id,
ISNULL(c.preferrd_supplier_id, '') AS preferrd_supplier_id,
ISNULL(c.Supplier_declaration_RefID, '') AS supplier_ref_id,
ISNULL(c.SupplierUID, '') AS supplier_uid,
ISNULL(c.SupplierName, '') AS supplier_name,
ISNULL(c.SupplierCountry, '') AS supplier_country,
ISNULL(c.DirectIndirectSupplier, '') AS direct_indirect,
ISNULL(c.source_type, '') AS source_type,
ISNULL(c.product_name, '') AS product_name,
c.tier,
CAST(ISNULL(c.is_latest, 0) AS BIT) AS is_latest,
CAST(ISNULL(c.is_latest_submitted, 0) AS BIT) AS is_latest_submitted,
CAST(ISNULL(c.is_unknown_supplier, 0) AS BIT) AS is_unknown_supplier,
ISNULL(c.company_id, '') AS company_id,
ISNULL(c.config_name, '') AS config_name,
ISNULL(c.Direct_Supplier_Name, '') AS direct_supplier_name,
ISNULL(rs.launch_request_name, '') AS launch_request_name,
ISNULL(rs.launch_config_ref, '') AS launch_config_ref,
rs.revision_version,
ISNULL(rs.submission_status, '') AS submission_status,
CONVERT(VARCHAR(30), rs.launch_date, 126) AS launch_date,
CONVERT(VARCHAR(30), rs.expiry_date, 126) AS expiry_date,
CONVERT(VARCHAR(30), rs.submitted_date, 126) AS submitted_date,
ISNULL(f.facility_id, '') AS facility_direct_id,
ISNULL(f.preferrd_facility_id, '') AS preferrd_facility_id,
ISNULL(f.facility_declaration_RefID, '') AS facility_ref_id,
ISNULL(f.FacilityName, '') AS facility_name,
ISNULL(f.FacilityCountry, '') AS facility_country,
ISNULL(f.FacilityCity, '') AS facility_city,
ISNULL(f.FacilityState, '') AS facility_state,
CAST(ISNULL(f.is_unknown_facility, 0) AS BIT) AS is_unknown_facility,
CAST(ISNULL(f.facility_Subcontractor, 0) AS BIT) AS facility_subcontractor,
ISNULL(f.Sub_supplier_declaration_ref, '') AS subcontractor_ref_id,
ISNULL(f.subcontractor_name, '') AS subcontractor_name,
ISNULL(f.subcontractor_country, '') AS subcontractor_country,
ISNULL(f.subcontractor_state, '') AS subcontractor_state,
ISNULL(f.subcontractor_city, '') AS subcontractor_city,
CAST(ISNULL(f.is_unknown_subcontractor, 0) AS BIT) AS is_unknown_subcontractor,
ISNULL(fm.Material, '') AS material,
ISNULL(fm.Value_process, '') AS value_process
FROM Datahub_dim_SCM_Chain c
JOIN Datahub_dim_SCM_Request_Status rs
ON rs.NetworkID = c.NetworkID
AND rs.brand_context_id = c.brand_context_id
AND rs.revision_version = c.revision_version
LEFT JOIN Datahub_dim_SCM_Facility f
ON f.NetworkID = c.NetworkID
AND f.brand_context_id = c.brand_context_id
AND f.Child_Node = c.Child_Node
AND f.fac_enabled = 1
AND f.is_latest_submitted = 1
LEFT JOIN Datahub_dim_SCM_Facility_Materials fm
ON fm.NetworkID = f.NetworkID
AND fm.facility_declaration_RefID = f.facility_declaration_RefID
AND fm.brand_context_id = f.brand_context_id
AND fm.Child_Node = f.Child_Node
AND fm.is_latest_submitted = 1
WHERE c.brand_context_id = '6aacf5861a41b434b2a90520'
AND c.is_latest_submitted = 1
AND c.NetworkID IN ('DCB3E899D1BC53F0D57A29EE55C4BE2123E5F606E53AE08EC44221543A506147')
) AS t) [numPartitions=1] [brand_context_id#12010729,NetworkID#12010730,Child_Node#12010731,Parent_id#12010732,supplier_id#12010733,preferrd_supplier_id#12010734,supplier_ref_id#12010735,supplier_uid#12010736,supplier_name#12010737,supplier_country#12010738,direct_indirect#12010739,source_type#12010740,product_name#12010741,tier#12010742,is_latest#12010743,is_latest_submitted#12010744,is_unknown_supplier#12010745,company_id#12010746,config_name#12010747,direct_supplier_name#12010748,launch_request_name#12010749,launch_config_ref#12010750,revision_version#12010751,submission_status#12010752,... 20 more fields] PushedFilters: [], ReadSchema: struct<brand_context_id:string,NetworkID:string,Child_Node:string,Parent_id:string,supplier_id:st...
+- == Initial Plan ==
Exchange SinglePartition, REPARTITION_BY_NUM, [plan_id=3993705]
+- Project [brand_context_id#12010729, staticinvoke(class org.apache.spark.sql.catalyst.util.CharVarcharCodegenUtils, StringType, readSidePadding, NetworkID#12010730, 64, true, false, true) AS NetworkID#12010773, Child_Node#12010731, Parent_id#12010732, supplier_id#12010733, preferrd_supplier_id#12010734, supplier_ref_id#12010735, supplier_uid#12010736, supplier_name#12010737, supplier_country#12010738, direct_indirect#12010739, source_type#12010740, product_name#12010741, tier#12010742, is_latest#12010743, is_latest_submitted#12010744, is_unknown_supplier#12010745, company_id#12010746, config_name#12010747, direct_supplier_name#12010748, launch_request_name#12010749, launch_config_ref#12010750, revision_version#12010751, submission_status#12010752, ... 23 more fields]
+- Scan JDBCRelation((
SELECT
c.brand_context_id,
c.NetworkID,
c.Child_Node,
c.Parent_id,
ISNULL(c.supplier_id, '') AS supplier_id,
ISNULL(c.preferrd_supplier_id, '') AS preferrd_supplier_id,
ISNULL(c.Supplier_declaration_RefID, '') AS supplier_ref_id,
ISNULL(c.SupplierUID, '') AS supplier_uid,
ISNULL(c.SupplierName, '') AS supplier_name,
ISNULL(c.SupplierCountry, '') AS supplier_country,
ISNULL(c.DirectIndirectSupplier, '') AS direct_indirect,
ISNULL(c.source_type, '') AS source_type,
ISNULL(c.product_name, '') AS product_name,
c.tier,
CAST(ISNULL(c.is_latest, 0) AS BIT) AS is_latest,
CAST(ISNULL(c.is_latest_submitted, 0) AS BIT) AS is_latest_submitted,
CAST(ISNULL(c.is_unknown_supplier, 0) AS BIT) AS is_unknown_supplier,
ISNULL(c.company_id, '') AS company_id,
ISNULL(c.config_name, '') AS config_name,
ISNULL(c.Direct_Supplier_Name, '') AS direct_supplier_name,
ISNULL(rs.launch_request_name, '') AS launch_request_name,
ISNULL(rs.launch_config_ref, '') AS launch_config_ref,
rs.revision_version,
ISNULL(rs.submission_status, '') AS submission_status,
CONVERT(VARCHAR(30), rs.launch_date, 126) AS launch_date,
CONVERT(VARCHAR(30), rs.expiry_date, 126) AS expiry_date,
CONVERT(VARCHAR(30), rs.submitted_date, 126) AS submitted_date,
ISNULL(f.facility_id, '') AS facility_direct_id,
ISNULL(f.preferrd_facility_id, '') AS preferrd_facility_id,
ISNULL(f.facility_declaration_RefID, '') AS facility_ref_id,
ISNULL(f.FacilityName, '') AS facility_name,
ISNULL(f.FacilityCountry, '') AS facility_country,
ISNULL(f.FacilityCity, '') AS facility_city,
ISNULL(f.FacilityState, '') AS facility_state,
CAST(ISNULL(f.is_unknown_facility, 0) AS BIT) AS is_unknown_facility,
CAST(ISNULL(f.facility_Subcontractor, 0) AS BIT) AS facility_subcontractor,
ISNULL(f.Sub_supplier_declaration_ref, '') AS subcontractor_ref_id,
ISNULL(f.subcontractor_name, '') AS subcontractor_name,
ISNULL(f.subcontractor_country, '') AS subcontractor_country,
ISNULL(f.subcontractor_state, '') AS subcontractor_state,
ISNULL(f.subcontractor_city, '') AS subcontractor_city,
CAST(ISNULL(f.is_unknown_subcontractor, 0) AS BIT) AS is_unknown_subcontractor,
ISNULL(fm.Material, '') AS material,
ISNULL(fm.Value_process, '') AS value_process
FROM Datahub_dim_SCM_Chain c
JOIN Datahub_dim_SCM_Request_Status rs
ON rs.NetworkID = c.NetworkID
AND rs.brand_context_id = c.brand_context_id
AND rs.revision_version = c.revision_version
LEFT JOIN Datahub_dim_SCM_Facility f
ON f.NetworkID = c.NetworkID
AND f.brand_context_id = c.brand_context_id
AND f.Child_Node = c.Child_Node
AND f.fac_enabled = 1
AND f.is_latest_submitted = 1
LEFT JOIN Datahub_dim_SCM_Facility_Materials fm
ON fm.NetworkID = f.NetworkID
AND fm.facility_declaration_RefID = f.facility_declaration_RefID
AND fm.brand_context_id = f.brand_context_id
AND fm.Child_Node = f.Child_Node
AND fm.is_latest_submitted = 1
WHERE c.brand_context_id = '6aacf5861a41b434b2a90520'
AND c.is_latest_submitted = 1
AND c.NetworkID IN ('DCB3E899D1BC53F0D57A29EE55C4BE2123E5F606E53AE08EC44221543A506147')
) AS t) [numPartitions=1] [brand_context_id#12010729,NetworkID#12010730,Child_Node#12010731,Parent_id#12010732,supplier_id#12010733,preferrd_supplier_id#12010734,supplier_ref_id#12010735,supplier_uid#12010736,supplier_name#12010737,supplier_country#12010738,direct_indirect#12010739,source_type#12010740,product_name#12010741,tier#12010742,is_latest#12010743,is_latest_submitted#12010744,is_unknown_supplier#12010745,company_id#12010746,config_name#12010747,direct_supplier_name#12010748,launch_request_name#12010749,launch_config_ref#12010750,revision_version#12010751,submission_status#12010752,... 20 more fields] PushedFilters: [], ReadSchema: struct<brand_context_id:string,NetworkID:string,Child_Node:string,Parent_id:string,supplier_id:st...
,None)
(3) Scan JDBCRelation((
SELECT
c.brand_context_id,
c.NetworkID,
c.Child_Node,
c.Parent_id,
ISNULL(c.supplier_id, '') AS supplier_id,
ISNULL(c.preferrd_supplier_id, '') AS preferrd_supplier_id,
ISNULL(c.Supplier_declaration_RefID, '') AS supplier_ref_id,
ISNULL(c.SupplierUID, '') AS supplier_uid,
ISNULL(c.SupplierName, '') AS supplier_name,
ISNULL(c.SupplierCountry, '') AS supplier_country,
ISNULL(c.DirectIndirectSupplier, '') AS direct_indirect,
ISNULL(c.source_type, '') AS source_type,
ISNULL(c.product_name, '') AS product_name,
c.tier,
CAST(ISNULL(c.is_latest, 0) AS BIT) AS is_latest,
CAST(ISNULL(c.is_latest_submitted, 0) AS BIT) AS is_latest_submitted,
CAST(ISNULL(c.is_unknown_supplier, 0) AS BIT) AS is_unknown_supplier,
ISNULL(c.company_id, '') AS company_id,
ISNULL(c.config_name, '') AS config_name,
ISNULL(c.Direct_Supplier_Name, '') AS direct_supplier_name,
ISNULL(rs.launch_request_name, '') AS launch_request_name,
ISNULL(rs.launch_config_ref, '') AS launch_config_ref,
rs.revision_version,
ISNULL(rs.submission_status, '') AS submission_status,
CONVERT(VARCHAR(30), rs.launch_date, 126) AS launch_date,
CONVERT(VARCHAR(30), rs.expiry_date, 126) AS expiry_date,
CONVERT(VARCHAR(30), rs.submitted_date, 126) AS submitted_date,
ISNULL(f.facility_id, '') AS facility_direct_id,
ISNULL(f.preferrd_facility_id, '') AS preferrd_facility_id,
ISNULL(f.facility_declaration_RefID, '') AS facility_ref_id,
ISNULL(f.FacilityName, '') AS facility_name,
ISNULL(f.FacilityCountry, '') AS facility_country,
ISNULL(f.FacilityCity, '') AS facility_city,
ISNULL(f.FacilityState, '') AS facility_state,
CAST(ISNULL(f.is_unknown_facility, 0) AS BIT) AS is_unknown_facility,
CAST(ISNULL(f.facility_Subcontractor, 0) AS BIT) AS facility_subcontractor,
ISNULL(f.Sub_supplier_declaration_ref, '') AS subcontractor_ref_id,
ISNULL(f.subcontractor_name, '') AS subcontractor_name,
ISNULL(f.subcontractor_country, '') AS subcontractor_country,
ISNULL(f.subcontractor_state, '') AS subcontractor_state,
ISNULL(f.subcontractor_city, '') AS subcontractor_city,
CAST(ISNULL(f.is_unknown_subcontractor, 0) AS BIT) AS is_unknown_subcontractor,
ISNULL(fm.Material, '') AS material,
ISNULL(fm.Value_process, '') AS value_process
FROM Datahub_dim_SCM_Chain c
JOIN Datahub_dim_SCM_Request_Status rs
ON rs.NetworkID = c.NetworkID
AND rs.brand_context_id = c.brand_context_id
AND rs.revision_version = c.revision_version
LEFT JOIN Datahub_dim_SCM_Facility f
ON f.NetworkID = c.NetworkID
AND f.brand_context_id = c.brand_context_id
AND f.Child_Node = c.Child_Node
AND f.fac_enabled = 1
AND f.is_latest_submitted = 1
LEFT JOIN Datahub_dim_SCM_Facility_Materials fm
ON fm.NetworkID = f.NetworkID
AND fm.facility_declaration_RefID = f.facility_declaration_RefID
AND fm.brand_context_id = f.brand_context_id
AND fm.Child_Node = f.Child_Node
AND fm.is_latest_submitted = 1
WHERE c.brand_context_id = '6aacf5861a41b434b2a90520'
AND c.is_latest_submitted = 1
AND c.NetworkID IN ('DCB3E899D1BC53F0D57A29EE55C4BE2123E5F606E53AE08EC44221543A506147')
) AS t) [numPartitions=1]
Output [44]: [brand_context_id#12010729, NetworkID#12010730, Child_Node#12010731, Parent_id#12010732, supplier_id#12010733, preferrd_supplier_id#12010734, supplier_ref_id#12010735, supplier_uid#12010736, supplier_name#12010737, supplier_country#12010738, direct_indirect#12010739, source_type#12010740, product_name#12010741, tier#12010742, is_latest#12010743, is_latest_submitted#12010744, is_unknown_supplier#12010745, company_id#12010746, config_name#12010747, direct_supplier_name#12010748, launch_request_name#12010749, launch_config_ref#12010750, revision_version#12010751, submission_status#12010752, launch_date#12010753, expiry_date#12010754, submitted_date#12010755, facility_direct_id#12010756, preferrd_facility_id#12010757, facility_ref_id#12010758, facility_name#12010759, facility_country#12010760, facility_city#12010761, facility_state#12010762, is_unknown_facility#12010763, facility_subcontractor#12010764, subcontractor_ref_id#12010765, subcontractor_name#12010766, subcontractor_country#12010767, subcontractor_state#12010768, subcontractor_city#12010769, is_unknown_subcontractor#12010770, material#12010771, value_process#12010772]
ReadSchema: struct<brand_context_id:string,NetworkID:string,Child_Node:string,Parent_id:string,supplier_id:string,preferrd_supplier_id:string,supplier_ref_id:string,supplier_uid:string,supplier_name:string,supplier_country:string,direct_indirect:string,source_type:string,product_name:string,tier:smallint,is_latest:boolean,is_latest_submitted:boolean,is_unknown_supplier:boolean,company_id:string,config_name:string,direct_supplier_name:string,launch_request_name:string,launch_config_ref:string,revision_version:smallint,submission_status:string,launch_date:string,expiry_date:string,submitted_date:string,facility_direct_id:string,preferrd_facility_id:string,facility_ref_id:string,facility_name:string,facility_country:string,facility_city:string,facility_state:string,is_unknown_facility:boolean,facility_subcontractor:boolean,subcontractor_ref_id:string,subcontractor_name:string,subcontractor_country:string,subcontractor_state:string,subcontractor_city:string,is_unknown_subcontractor:boolean,material:string,value_process:string>
(4) Project
Output [47]: [brand_context_id#12010729, staticinvoke(class org.apache.spark.sql.catalyst.util.CharVarcharCodegenUtils, StringType, readSidePadding, NetworkID#12010730, 64, true, false, true) AS NetworkID#12010773, Child_Node#12010731, Parent_id#12010732, supplier_id#12010733, preferrd_supplier_id#12010734, supplier_ref_id#12010735, supplier_uid#12010736, supplier_name#12010737, supplier_country#12010738, direct_indirect#12010739, source_type#12010740, product_name#12010741, tier#12010742, is_latest#12010743, is_latest_submitted#12010744, is_unknown_supplier#12010745, company_id#12010746, config_name#12010747, direct_supplier_name#12010748, launch_request_name#12010749, launch_config_ref#12010750, revision_version#12010751, submission_status#12010752, launch_date#12010753, expiry_date#12010754, submitted_date#12010755, facility_direct_id#12010756, preferrd_facility_id#12010757, facility_ref_id#12010758, facility_name#12010759, facility_country#12010760, facility_city#12010761, facility_state#12010762, is_unknown_facility#12010763, facility_subcontractor#12010764, subcontractor_ref_id#12010765, subcontractor_name#12010766, subcontractor_country#12010767, subcontractor_state#12010768, subcontractor_city#12010769, is_unknown_subcontractor#12010770, material#12010771, value_process#12010772, sha2(cast(concat(brand_context_id#12010729, |, coalesce(CASE WHEN NOT (supplier_id#12010733 = ) THEN supplier_id#12010733 END, supplier_ref_id#12010735), |, coalesce(CASE WHEN NOT (facility_direct_id#12010756 = ) THEN facility_direct_id#12010756 END, facility_ref_id#12010758), |, lower(trim(value_process#12010772, None)), |, lower(trim(product_name#12010741, None)), |, lower(trim(material#12010771, None)), |, CASE WHEN (facility_subcontractor#12010764 AND NOT (subcontractor_ref_id#12010765 = )) THEN subcontractor_ref_id#12010765 ELSE END) as binary), 256) AS node_id#12010818, CASE WHEN (facility_subcontractor#12010764 AND NOT (subcontractor_ref_id#12010765 = )) THEN subcontractor_ref_id#12010765 ELSE END AS _eff_sub#12010864, coalesce(CASE WHEN NOT (facility_direct_id#12010756 = ) THEN facility_direct_id#12010756 END, facility_ref_id#12010758) AS _eff_fac#12010911]
Input [44]: [brand_context_id#12010729, NetworkID#12010730, Child_Node#12010731, Parent_id#12010732, supplier_id#12010733, preferrd_supplier_id#12010734, supplier_ref_id#12010735, supplier_uid#12010736, supplier_name#12010737, supplier_country#12010738, direct_indirect#12010739, source_type#12010740, product_name#12010741, tier#12010742, is_latest#12010743, is_latest_submitted#12010744, is_unknown_supplier#12010745, company_id#12010746, config_name#12010747, direct_supplier_name#12010748, launch_request_name#12010749, launch_config_ref#12010750, revision_version#12010751, submission_status#12010752, launch_date#12010753, expiry_date#12010754, submitted_date#12010755, facility_direct_id#12010756, preferrd_facility_id#12010757, facility_ref_id#12010758, facility_name#12010759, facility_country#12010760, facility_city#12010761, facility_state#12010762, is_unknown_facility#12010763, facility_subcontractor#12010764, subcontractor_ref_id#12010765, subcontractor_name#12010766, subcontractor_country#12010767, subcontractor_state#12010768, subcontractor_city#12010769, is_unknown_subcontractor#12010770, material#12010771, value_process#12010772]
(5) Exchange
Input [47]: [brand_context_id#12010729, NetworkID#12010773, Child_Node#12010731, Parent_id#12010732, supplier_id#12010733, preferrd_supplier_id#12010734, supplier_ref_id#12010735, supplier_uid#12010736, supplier_name#12010737, supplier_country#12010738, direct_indirect#12010739, source_type#12010740, product_name#12010741, tier#12010742, is_latest#12010743, is_latest_submitted#12010744, is_unknown_supplier#12010745, company_id#12010746, config_name#12010747, direct_supplier_name#12010748, launch_request_name#12010749, launch_config_ref#12010750, revision_version#12010751, submission_status#12010752, launch_date#12010753, expiry_date#12010754, submitted_date#12010755, facility_direct_id#12010756, preferrd_facility_id#12010757, facility_ref_id#12010758, facility_name#12010759, facility_country#12010760, facility_city#12010761, facility_state#12010762, is_unknown_facility#12010763, facility_subcontractor#12010764, subcontractor_ref_id#12010765, subcontractor_name#12010766, subcontractor_country#12010767, subcontractor_state#12010768, subcontractor_city#12010769, is_unknown_subcontractor#12010770, material#12010771, value_process#12010772, node_id#12010818, _eff_sub#12010864, _eff_fac#12010911]
Arguments: SinglePartition, REPARTITION_BY_NUM, [plan_id=3993705]
(6) AdaptiveSparkPlan
Output [47]: [brand_context_id#12010729, NetworkID#12010773, Child_Node#12010731, Parent_id#12010732, supplier_id#12010733, preferrd_supplier_id#12010734, supplier_ref_id#12010735, supplier_uid#12010736, supplier_name#12010737, supplier_country#12010738, direct_indirect#12010739, source_type#12010740, product_name#12010741, tier#12010742, is_latest#12010743, is_latest_submitted#12010744, is_unknown_supplier#12010745, company_id#12010746, config_name#12010747, direct_supplier_name#12010748, launch_request_name#12010749, launch_config_ref#12010750, revision_version#12010751, submission_status#12010752, launch_date#12010753, expiry_date#12010754, submitted_date#12010755, facility_direct_id#12010756, preferrd_facility_id#12010757, facility_ref_id#12010758, facility_name#12010759, facility_country#12010760, facility_city#12010761, facility_state#12010762, is_unknown_facility#12010763, facility_subcontractor#12010764, subcontractor_ref_id#12010765, subcontractor_name#12010766, subcontractor_country#12010767, subcontractor_state#12010768, subcontractor_city#12010769, is_unknown_subcontractor#12010770, material#12010771, value_process#12010772, node_id#12010818, _eff_sub#12010864, _eff_fac#12010911]
Arguments: isFinalPlan=false
(7) TableCacheQueryStage
Output [48]: [NetworkID#12010773, brand_context_id#12010729, NetworkID#12010773, Child_Node#12010731, Parent_id#12010732, supplier_id#12010733, preferrd_supplier_id#12010734, supplier_ref_id#12010735, supplier_uid#12010736, supplier_name#12010737, supplier_country#12010738, direct_indirect#12010739, source_type#12010740, product_name#12010741, tier#12010742, is_latest#12010743, is_latest_submitted#12010744, is_unknown_supplier#12010745, company_id#12010746, config_name#12010747, direct_supplier_name#12010748, launch_request_name#12010749, launch_config_ref#12010750, revision_version#12010751, submission_status#12010752, launch_date#12010753, expiry_date#12010754, submitted_date#12010755, facility_direct_id#12010756, preferrd_facility_id#12010757, facility_ref_id#12010758, facility_name#12010759, facility_country#12010760, facility_city#12010761, facility_state#12010762, is_unknown_facility#12010763, facility_subcontractor#12010764, subcontractor_ref_id#12010765, subcontractor_name#12010766, subcontractor_country#12010767, subcontractor_state#12010768, subcontractor_city#12010769, is_unknown_subcontractor#12010770, material#12010771, value_process#12010772, node_id#12010818, _eff_sub#12010864, _eff_fac#12010911]
Arguments: 0
(8) Sort [codegen id : 1]
Input [48]: [NetworkID#12010773, brand_context_id#12010729, NetworkID#12010773, Child_Node#12010731, Parent_id#12010732, supplier_id#12010733, preferrd_supplier_id#12010734, supplier_ref_id#12010735, supplier_uid#12010736, supplier_name#12010737, supplier_country#12010738, direct_indirect#12010739, source_type#12010740, product_name#12010741, tier#12010742, is_latest#12010743, is_latest_submitted#12010744, is_unknown_supplier#12010745, company_id#12010746, config_name#12010747, direct_supplier_name#12010748, launch_request_name#12010749, launch_config_ref#12010750, revision_version#12010751, submission_status#12010752, launch_date#12010753, expiry_date#12010754, submitted_date#12010755, facility_direct_id#12010756, preferrd_facility_id#12010757, facility_ref_id#12010758, facility_name#12010759, facility_country#12010760, facility_city#12010761, facility_state#12010762, is_unknown_facility#12010763, facility_subcontractor#12010764, subcontractor_ref_id#12010765, subcontractor_name#12010766, subcontractor_country#12010767, subcontractor_state#12010768, subcontractor_city#12010769, is_unknown_subcontractor#12010770, material#12010771, value_process#12010772, node_id#12010818, _eff_sub#12010864, _eff_fac#12010911]
Arguments: [NetworkID#12010773 ASC NULLS FIRST], false, 0
(9) FlatMapGroupsInPandas
Input [48]: [NetworkID#12010773, brand_context_id#12010729, NetworkID#12010773, Child_Node#12010731, Parent_id#12010732, supplier_id#12010733, preferrd_supplier_id#12010734, supplier_ref_id#12010735, supplier_uid#12010736, supplier_name#12010737, supplier_country#12010738, direct_indirect#12010739, source_type#12010740, product_name#12010741, tier#12010742, is_latest#12010743, is_latest_submitted#12010744, is_unknown_supplier#12010745, company_id#12010746, config_name#12010747, direct_supplier_name#12010748, launch_request_name#12010749, launch_config_ref#12010750, revision_version#12010751, submission_status#12010752, launch_date#12010753, expiry_date#12010754, submitted_date#12010755, facility_direct_id#12010756, preferrd_facility_id#12010757, facility_ref_id#12010758, facility_name#12010759, facility_country#12010760, facility_city#12010761, facility_state#12010762, is_unknown_facility#12010763, facility_subcontractor#12010764, subcontractor_ref_id#12010765, subcontractor_name#12010766, subcontractor_country#12010767, subcontractor_state#12010768, subcontractor_city#12010769, is_unknown_subcontractor#12010770, material#12010771, value_process#12010772, node_id#12010818, _eff_sub#12010864, _eff_fac#12010911]
Arguments: [NetworkID#12010773], _feeds_into_partition(brand_context_id#12010729, NetworkID#12010773, Child_Node#12010731, Parent_id#12010732, supplier_id#12010733, preferrd_supplier_id#12010734, supplier_ref_id#12010735, supplier_uid#12010736, supplier_name#12010737, supplier_country#12010738, direct_indirect#12010739, source_type#12010740, product_name#12010741, tier#12010742, is_latest#12010743, is_latest_submitted#12010744, is_unknown_supplier#12010745, company_id#12010746, config_name#12010747, direct_supplier_name#12010748, launch_request_name#12010749, launch_config_ref#12010750, revision_version#12010751, submission_status#12010752, launch_date#12010753, expiry_date#12010754, submitted_date#12010755, facility_direct_id#12010756, preferrd_facility_id#12010757, facility_ref_id#12010758, facility_name#12010759, facility_country#12010760, facility_city#12010761, facility_state#12010762, is_unknown_facility#12010763, facility_subcontractor#12010764, subcontractor_ref_id#12010765, subcontractor_name#12010766, subcontractor_country#12010767, subcontractor_state#12010768, subcontractor_city#12010769, is_unknown_subcontractor#12010770, material#12010771, value_process#12010772, node_id#12010818, _eff_sub#12010864, _eff_fac#12010911)#12012580, [from_node_id#12012581, to_node_id#12012582, brand_context_id#12012583, declaration_id#12012584, allocation_pct#12012585, allocation_source#12012586, declarer_supplier_id#12012587, declarer_supplier_uid#12012588, declarer_supplier_name#12012589, config_name#12012590, launch_request_name#12012591, launch_config_ref#12012592, revision_version#12012593, status#12012594, launch_date#12012595, expiry_date#12012596, submitted_date#12012597, source_type#12012598, src_tier#12012599, dst_tier#12012600, is_latest#12012601, is_latest_submitted#12012602]
(10) Filter [codegen id : 2]
Input [22]: [from_node_id#12012581, to_node_id#12012582, brand_context_id#12012583, declaration_id#12012584, allocation_pct#12012585, allocation_source#12012586, declarer_supplier_id#12012587, declarer_supplier_uid#12012588, declarer_supplier_name#12012589, config_name#12012590, launch_request_name#12012591, launch_config_ref#12012592, revision_version#12012593, status#12012594, launch_date#12012595, expiry_date#12012596, submitted_date#12012597, source_type#12012598, src_tier#12012599, dst_tier#12012600, is_latest#12012601, is_latest_submitted#12012602]
Condition : ((isnotnull(declarer_supplier_id#12012587) AND isnotnull(config_name#12012590)) AND (NOT (declarer_supplier_id#12012587 = ) AND NOT (config_name#12012590 = )))
(11) Project [codegen id : 2]
Output [2]: [declarer_supplier_id#12012587, config_name#12012590]
Input [22]: [from_node_id#12012581, to_node_id#12012582, brand_context_id#12012583, declaration_id#12012584, allocation_pct#12012585, allocation_source#12012586, declarer_supplier_id#12012587, declarer_supplier_uid#12012588, declarer_supplier_name#12012589, config_name#12012590, launch_request_name#12012591, launch_config_ref#12012592, revision_version#12012593, status#12012594, launch_date#12012595, expiry_date#12012596, submitted_date#12012597, source_type#12012598, src_tier#12012599, dst_tier#12012600, is_latest#12012601, is_latest_submitted#12012602]
(12) HashAggregate [codegen id : 2]
Input [2]: [declarer_supplier_id#12012587, config_name#12012590]
Keys [2]: [declarer_supplier_id#12012587, config_name#12012590]
Functions: []
Aggregate Attributes: []
Results [2]: [declarer_supplier_id#12012587, config_name#12012590]
(13) HashAggregate [codegen id : 2]
Input [2]: [declarer_supplier_id#12012587, config_name#12012590]
Keys [2]: [declarer_supplier_id#12012587, config_name#12012590]
Functions: []
Aggregate Attributes: []
Results [2]: [declarer_supplier_id#12012587, config_name#12012590]
(14) Sort
Input [48]: [NetworkID#12010773, brand_context_id#12010729, NetworkID#12010773, Child_Node#12010731, Parent_id#12010732, supplier_id#12010733, preferrd_supplier_id#12010734, supplier_ref_id#12010735, supplier_uid#12010736, supplier_name#12010737, supplier_country#12010738, direct_indirect#12010739, source_type#12010740, product_name#12010741, tier#12010742, is_latest#12010743, is_latest_submitted#12010744, is_unknown_supplier#12010745, company_id#12010746, config_name#12010747, direct_supplier_name#12010748, launch_request_name#12010749, launch_config_ref#12010750, revision_version#12010751, submission_status#12010752, launch_date#12010753, expiry_date#12010754, submitted_date#12010755, facility_direct_id#12010756, preferrd_facility_id#12010757, facility_ref_id#12010758, facility_name#12010759, facility_country#12010760, facility_city#12010761, facility_state#12010762, is_unknown_facility#12010763, facility_subcontractor#12010764, subcontractor_ref_id#12010765, subcontractor_name#12010766, subcontractor_country#12010767, subcontractor_state#12010768, subcontractor_city#12010769, is_unknown_subcontractor#12010770, material#12010771, value_process#12010772, node_id#12010818, _eff_sub#12010864, _eff_fac#12010911]
Arguments: [NetworkID#12010773 ASC NULLS FIRST], false, 0
(15) FlatMapGroupsInPandas
Input [48]: [NetworkID#12010773, brand_context_id#12010729, NetworkID#12010773, Child_Node#12010731, Parent_id#12010732, supplier_id#12010733, preferrd_supplier_id#12010734, supplier_ref_id#12010735, supplier_uid#12010736, supplier_name#12010737, supplier_country#12010738, direct_indirect#12010739, source_type#12010740, product_name#12010741, tier#12010742, is_latest#12010743, is_latest_submitted#12010744, is_unknown_supplier#12010745, company_id#12010746, config_name#12010747, direct_supplier_name#12010748, launch_request_name#12010749, launch_config_ref#12010750, revision_version#12010751, submission_status#12010752, launch_date#12010753, expiry_date#12010754, submitted_date#12010755, facility_direct_id#12010756, preferrd_facility_id#12010757, facility_ref_id#12010758, facility_name#12010759, facility_country#12010760, facility_city#12010761, facility_state#12010762, is_unknown_facility#12010763, facility_subcontractor#12010764, subcontractor_ref_id#12010765, subcontractor_name#12010766, subcontractor_country#12010767, subcontractor_state#12010768, subcontractor_city#12010769, is_unknown_subcontractor#12010770, material#12010771, value_process#12010772, node_id#12010818, _eff_sub#12010864, _eff_fac#12010911]
Arguments: [NetworkID#12010773], _feeds_into_partition(brand_context_id#12010729, NetworkID#12010773, Child_Node#12010731, Parent_id#12010732, supplier_id#12010733, preferrd_supplier_id#12010734, supplier_ref_id#12010735, supplier_uid#12010736, supplier_name#12010737, supplier_country#12010738, direct_indirect#12010739, source_type#12010740, product_name#12010741, tier#12010742, is_latest#12010743, is_latest_submitted#12010744, is_unknown_supplier#12010745, company_id#12010746, config_name#12010747, direct_supplier_name#12010748, launch_request_name#12010749, launch_config_ref#12010750, revision_version#12010751, submission_status#12010752, launch_date#12010753, expiry_date#12010754, submitted_date#12010755, facility_direct_id#12010756, preferrd_facility_id#12010757, facility_ref_id#12010758, facility_name#12010759, facility_country#12010760, facility_city#12010761, facility_state#12010762, is_unknown_facility#12010763, facility_subcontractor#12010764, subcontractor_ref_id#12010765, subcontractor_name#12010766, subcontractor_country#12010767, subcontractor_state#12010768, subcontractor_city#12010769, is_unknown_subcontractor#12010770, material#12010771, value_process#12010772, node_id#12010818, _eff_sub#12010864, _eff_fac#12010911)#12012580, [from_node_id#12012581, to_node_id#12012582, brand_context_id#12012583, declaration_id#12012584, allocation_pct#12012585, allocation_source#12012586, declarer_supplier_id#12012587, declarer_supplier_uid#12012588, declarer_supplier_name#12012589, config_name#12012590, launch_request_name#12012591, launch_config_ref#12012592, revision_version#12012593, status#12012594, launch_date#12012595, expiry_date#12012596, submitted_date#12012597, source_type#12012598, src_tier#12012599, dst_tier#12012600, is_latest#12012601, is_latest_submitted#12012602]
(16) Filter
Input [22]: [from_node_id#12012581, to_node_id#12012582, brand_context_id#12012583, declaration_id#12012584, allocation_pct#12012585, allocation_source#12012586, declarer_supplier_id#12012587, declarer_supplier_uid#12012588, declarer_supplier_name#12012589, config_name#12012590, launch_request_name#12012591, launch_config_ref#12012592, revision_version#12012593, status#12012594, launch_date#12012595, expiry_date#12012596, submitted_date#12012597, source_type#12012598, src_tier#12012599, dst_tier#12012600, is_latest#12012601, is_latest_submitted#12012602]
Condition : ((isnotnull(declarer_supplier_id#12012587) AND isnotnull(config_name#12012590)) AND (NOT (declarer_supplier_id#12012587 = ) AND NOT (config_name#12012590 = )))
(17) Project
Output [2]: [declarer_supplier_id#12012587, config_name#12012590]
Input [22]: [from_node_id#12012581, to_node_id#12012582, brand_context_id#12012583, declaration_id#12012584, allocation_pct#12012585, allocation_source#12012586, declarer_supplier_id#12012587, declarer_supplier_uid#12012588, declarer_supplier_name#12012589, config_name#12012590, launch_request_name#12012591, launch_config_ref#12012592, revision_version#12012593, status#12012594, launch_date#12012595, expiry_date#12012596, submitted_date#12012597, source_type#12012598, src_tier#12012599, dst_tier#12012600, is_latest#12012601, is_latest_submitted#12012602]
(18) HashAggregate
Input [2]: [declarer_supplier_id#12012587, config_name#12012590]
Keys [2]: [declarer_supplier_id#12012587, config_name#12012590]
Functions: []
Aggregate Attributes: []
Results [2]: [declarer_supplier_id#12012587, config_name#12012590]
(19) HashAggregate
Input [2]: [declarer_supplier_id#12012587, config_name#12012590]
Keys [2]: [declarer_supplier_id#12012587, config_name#12012590]
Functions: []
Aggregate Attributes: []
Results [2]: [declarer_supplier_id#12012587, config_name#12012590]
(20) AdaptiveSparkPlan
Output [2]: [declarer_supplier_id#12012587, config_name#12012590]
Arguments: isFinalPlan=true