== Physical Plan ==
AdaptiveSparkPlan (12)
+- == Final Plan ==
* HashAggregate (8)
+- ShuffleQueryStage (7), Statistics(sizeInBytes=16.0 B, rowCount=1)
+- Exchange (6)
+- * HashAggregate (5)
+- TableCacheQueryStage (4), Statistics(sizeInBytes=6.4 MiB, rowCount=1.00E+4)
+- InMemoryTableScan (1)
+- InMemoryRelation (2)
+- Scan JDBCRelation((SELECT * FROM dbo.fact_trans_chain_po_detail WHERE bigid BETWEEN 1 AND 10000) AS page) [numPartitions=1] (3)
+- == Initial Plan ==
HashAggregate (11)
+- Exchange (10)
+- HashAggregate (9)
+- InMemoryTableScan (1)
+- InMemoryRelation (2)
+- Scan JDBCRelation((SELECT * FROM dbo.fact_trans_chain_po_detail WHERE bigid BETWEEN 1 AND 10000) AS page) [numPartitions=1] (3)
(1) InMemoryTableScan
Output: []
(2) InMemoryRelation
Arguments: [po_item_product_code#15129212, po_item_product_name#15129213, transaction_id#15129214, buyer_gln#15129215, seller_gln#15129216, pod_division#15129217, pod_delivery_date#15129218, pod_product_item_id#15129219, pod_product_entity#15129220, po_number#15129221, product_item_id#15129222, product_entity#15129223, brand_context_id#15129224, po_division#15129225, po_delivery_date#15129226, row_id#15129227L, parent_row_id#15129228, chain_seq#15129229, tier#15129230, production_input_type#15129231, trans_create_ts#15129232, trans_update_ts#15129233, outbound_create_ts#15129234, outbound_supplier_code#15129235, ... 111 more fields], CachedRDDBuilder(org.apache.spark.sql.execution.columnar.DefaultCachedBatchSerializer@730ae8bf,StorageLevel(disk, memory, deserialized, 1 replicas),Scan JDBCRelation((SELECT * FROM dbo.fact_trans_chain_po_detail WHERE bigid BETWEEN 1 AND 10000) AS page) [numPartitions=1] [po_item_product_code#15129212,po_item_product_name#15129213,transaction_id#15129214,buyer_gln#15129215,seller_gln#15129216,pod_division#15129217,pod_delivery_date#15129218,pod_product_item_id#15129219,pod_product_entity#15129220,po_number#15129221,product_item_id#15129222,product_entity#15129223,brand_context_id#15129224,po_division#15129225,po_delivery_date#15129226,row_id#15129227L,parent_row_id#15129228,chain_seq#15129229,tier#15129230,production_input_type#15129231,trans_create_ts#15129232,trans_update_ts#15129233,outbound_create_ts#15129234,outbound_supplier_code#15129235,... 111 more fields] PushedFilters: [], ReadSchema: struct<po_item_product_code:string,po_item_product_name:string,transaction_id:string,buyer_gln:st...
,None)
(3) Scan JDBCRelation((SELECT * FROM dbo.fact_trans_chain_po_detail WHERE bigid BETWEEN 1 AND 10000) AS page) [numPartitions=1]
Output [135]: [po_item_product_code#15129212, po_item_product_name#15129213, transaction_id#15129214, buyer_gln#15129215, seller_gln#15129216, pod_division#15129217, pod_delivery_date#15129218, pod_product_item_id#15129219, pod_product_entity#15129220, po_number#15129221, product_item_id#15129222, product_entity#15129223, brand_context_id#15129224, po_division#15129225, po_delivery_date#15129226, row_id#15129227L, parent_row_id#15129228, chain_seq#15129229, tier#15129230, production_input_type#15129231, trans_create_ts#15129232, trans_update_ts#15129233, outbound_create_ts#15129234, outbound_supplier_code#15129235, outbound_supplier_name#15129236, outbound_trans_date#15129237, outbound_quantity#15129238, outbound_quantity_unit#15129239, outbound_seller_uom_quantity#15129240, outbound_seller_uom_unit#15129241, production_facility_uid#15129242, production_facility_name#15129243, production_facility_country#15129244, production_lot_id#15129245, production_trans_date#15129246, production_quantity#15129247, production_quantity_unit#15129248, production_seller_uom_quantity#15129249, production_seller_uom_unit#15129250, production_product_type#15129251, production_product_code#15129252, production_product_name#15129253, production_inputlot_quantity#15129254, production_inputlot_unit#15129255, production_inputlot_uom_quantity#15129256, production_inputlot_uom_quantity_unit#15129257, IP_P_facility_uid#15129258, IP_P_facility_name#15129259, IP_P_facility_country#15129260, IP_P_product_type#15129261, IP_P_lot_id#15129262, IP_P_trans_date#15129263, IP_P_output_quantity#15129264, IP_P_seller_uom_quantity#15129265, IP_P_seller_uom_quantity_unit#15129266, IP_P_inputlot_quantity#15129267, IP_P_inputlot_product_uid#15129268, PPI_product_name#15129269, IP_P_inputlot_supplier_facility_uid#15129270, IP_P_Supplier_facility_name#15129271, IP_P_Supplier_facility_country#15129272, IP_P_inputlot_id#15129273, IP_P_I_facility_uid#15129274, IP_P_I_facility_name#15129275, IP_P_I_facility_country#15129276, IP_P_I_transdate#15129277, IP_P_I_quantity#15129278, IP_P__IQuanaity_Unit_Desc#15129279, IP_P_Business_Document_Number#15129280, IP_P_output_product_uid#15129281, IP_P_product_ProductName#15129282, IP_P_product_ProductType#15129283, Inbound_Seller_UID#15129284, Inbound_Seller_Name#15129285, IP_P_I_profile_uid#15129286, IP_P_I_profile_name#15129287, IP_P_MaterialComp#15129288, IP_P_inputlot_supplier_uom_quantity#15129289, IP_P_inputlot_supplier_uom_unit#15129290, inbound_id#15129291, inbound_create_ts#15129292, inbound_trans_type#15129293, inbound_status#15129294, inbound_product_code#15129295, inbound_product_name#15129296, inbound_supplier_uid#15129297, inbound_Supplier_Name#15129298, inbound_supplier_facility_uid#15129299, inbound_supplier_facility_name#15129300, inbound_supplier_facility_country#15129301, inbound_seller_lot_id#15129302, inbound_facility_uid#15129303, inbound_facility_country#15129304, inbound_facility_name#15129305, inbound_trans_date#15129306, inbound_quantity#15129307, inbound_quantity_unit#15129308, inbound_seller_uom_quantity#15129309, inbound_seller_uom_unit#15129310, input_material_composition#15129311, inbound_business_document_number#15129312, inbound_document_yes_no#15129313, inter_production_facility_uid#15129314, inter_production_facility_name#15129315, inter_production_facility_country#15129316, inter_production_article_type_id#15129317, inter_production_material_unique_code#15129318, inter_production_internal_article_name#15129319, inter_production_lot_id#15129320, inter_production_trans_date#15129321, inter_production_output_quantity#15129322, inter_production_output_unit#15129323, inter_production_material#15129324, inter_production_input_quantity#15129325, inter_production_input_unit#15129326, inter_pod_input_product_code#15129327, inter_pod_input_product_name#15129328, inter_pod_inbound_reference_id#15129329, inter_pod_inbound_Supplier_Name#15129330, inter_pod_inbound_supplier_facility_uid#15129331, inter_pod_supplier_facility_name#15129332, inter_pod_address_country#15129333, inter_pod_inbound_seller_lot_id#15129334, inter_pod_inbound_facility_uid#15129335, inter_pod_inbound_facility_country#15129336, inter_pod_inbound_facility_name#15129337, inter_pod_inbound_trans_date#15129338, inter_pod_inbound_quantity#15129339, inter_pod_inbound_unit#15129340, inter_pod_inbound_seller_uom_quantity#15129341, inter_pod_inbound_seller_uom_unit#15129342, inter_pod_input_material_composition#15129343, inter_pod_business_document_number#15129344, inter_pod_inbound_document_yes_no#15129345, bigid#15129346L]
ReadSchema: struct<po_item_product_code:string,po_item_product_name:string,transaction_id:string,buyer_gln:string,seller_gln:string,pod_division:string,pod_delivery_date:date,pod_product_item_id:string,pod_product_entity:string,po_number:string,product_item_id:string,product_entity:string,brand_context_id:string,po_division:string,po_delivery_date:date,row_id:bigint,parent_row_id:int,chain_seq:string,tier:string,production_input_type:string,trans_create_ts:string,trans_update_ts:string,outbound_create_ts:date,outbound_supplier_code:string,outbound_supplier_name:string,outbound_trans_date:date,outbound_quantity:string,outbound_quantity_unit:string,outbound_seller_uom_quantity:string,outbound_seller_uom_unit:string,production_facility_uid:string,production_facility_name:string,production_facility_country:string,production_lot_id:string,production_trans_date:date,production_quantity:double,production_quantity_unit:string,production_seller_uom_quantity:string,production_seller_uom_unit:string,production_product_type:string,production_product_code:string,production_product_name:string,production_inputlot_quantity:double,production_inputlot_unit:string,production_inputlot_uom_quantity:string,production_inputlot_uom_quantity_unit:string,IP_P_facility_uid:string,IP_P_facility_name:string,IP_P_facility_country:string,IP_P_product_type:string,IP_P_lot_id:string,IP_P_trans_date:date,IP_P_output_quantity:double,IP_P_seller_uom_quantity:string,IP_P_seller_uom_quantity_unit:string,IP_P_inputlot_quantity:string,IP_P_inputlot_product_uid:string,PPI_product_name:string,IP_P_inputlot_supplier_facility_uid:string,IP_P_Supplier_facility_name:string,IP_P_Supplier_facility_country:string,IP_P_inputlot_id:string,IP_P_I_facility_uid:string,IP_P_I_facility_name:string,IP_P_I_facility_country:string,IP_P_I_transdate:date,IP_P_I_quantity:double,IP_P__IQuanaity_Unit_Desc:string,IP_P_Business_Document_Number:string,IP_P_output_product_uid:string,IP_P_product_ProductName:string,IP_P_product_ProductType:string,Inbound_Seller_UID:string,Inbound_Seller_Name:string,IP_P_I_profile_uid:string,IP_P_I_profile_name:string,IP_P_MaterialComp:string,IP_P_inputlot_supplier_uom_quantity:string,IP_P_inputlot_supplier_uom_unit:string,inbound_id:string,inbound_create_ts:string,inbound_trans_type:string,inbound_status:string,inbound_product_code:string,inbound_product_name:string,inbound_supplier_uid:string,inbound_Supplier_Name:string,inbound_supplier_facility_uid:string,inbound_supplier_facility_name:string,inbound_supplier_facility_country:string,inbound_seller_lot_id:string,inbound_facility_uid:string,inbound_facility_country:string,inbound_facility_name:string,inbound_trans_date:date,inbound_quantity:double,inbound_quantity_unit:string,inbound_seller_uom_quantity:string,inbound_seller_uom_unit:string,input_material_composition:string,inbound_business_document_number:string,inbound_document_yes_no:string,inter_production_facility_uid:string,inter_production_facility_name:string,inter_production_facility_country:string,inter_production_article_type_id:string,inter_production_material_unique_code:string,inter_production_internal_article_name:string,inter_production_lot_id:string,inter_production_trans_date:date,inter_production_output_quantity:double,inter_production_output_unit:string,inter_production_material:string,inter_production_input_quantity:double,inter_production_input_unit:string,inter_pod_input_product_code:string,inter_pod_input_product_name:string,inter_pod_inbound_reference_id:string,inter_pod_inbound_Supplier_Name:string,inter_pod_inbound_supplier_facility_uid:string,inter_pod_supplier_facility_name:string,inter_pod_address_country:string,inter_pod_inbound_seller_lot_id:string,inter_pod_inbound_facility_uid:string,inter_pod_inbound_facility_country:string,inter_pod_inbound_facility_name:string,inter_pod_inbound_trans_date:date,inter_pod_inbound_quantity:double,inter_pod_inbound_unit:string,inter_pod_inbound_seller_uom_quantity:string,inter_pod_inbound_seller_uom_unit:string,inter_pod_input_material_composition:string,inter_pod_business_document_number:string,inter_pod_inbound_document_yes_no:string,bigid:bigint>
(4) TableCacheQueryStage
Output: []
Arguments: 0
(5) HashAggregate [codegen id : 1]
Input: []
Keys: []
Functions [1]: [partial_count(1)]
Aggregate Attributes [1]: [count#15132320L]
Results [1]: [count#15132321L]
(6) Exchange
Input [1]: [count#15132321L]
Arguments: SinglePartition, ENSURE_REQUIREMENTS, [plan_id=4305967]
(7) ShuffleQueryStage
Output [1]: [count#15132321L]
Arguments: 1
(8) HashAggregate [codegen id : 2]
Input [1]: [count#15132321L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#15130292L]
Results [1]: [count(1)#15130292L AS count#15130293L]
(9) HashAggregate
Input: []
Keys: []
Functions [1]: [partial_count(1)]
Aggregate Attributes [1]: [count#15132320L]
Results [1]: [count#15132321L]
(10) Exchange
Input [1]: [count#15132321L]
Arguments: SinglePartition, ENSURE_REQUIREMENTS, [plan_id=4305872]
(11) HashAggregate
Input [1]: [count#15132321L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#15130292L]
Results [1]: [count(1)#15130292L AS count#15130293L]
(12) AdaptiveSparkPlan
Output [1]: [count#15130293L]
Arguments: isFinalPlan=true