== 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.5 MiB, rowCount=1.00E+4)
+- InMemoryTableScan (1)
+- InMemoryRelation (2)
+- Scan JDBCRelation((SELECT * FROM dbo.fact_trans_chain_po_detail WHERE bigid BETWEEN 10001 AND 20000) 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 10001 AND 20000) AS page) [numPartitions=1] (3)
(1) InMemoryTableScan
Output: []
(2) InMemoryRelation
Arguments: [po_item_product_code#1008133, po_item_product_name#1008134, transaction_id#1008135, buyer_gln#1008136, seller_gln#1008137, pod_division#1008138, pod_delivery_date#1008139, pod_product_item_id#1008140, pod_product_entity#1008141, po_number#1008142, product_item_id#1008143, product_entity#1008144, brand_context_id#1008145, po_division#1008146, po_delivery_date#1008147, row_id#1008148L, parent_row_id#1008149, chain_seq#1008150, tier#1008151, production_input_type#1008152, trans_create_ts#1008153, trans_update_ts#1008154, outbound_create_ts#1008155, outbound_supplier_code#1008156, ... 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 10001 AND 20000) AS page) [numPartitions=1] [po_item_product_code#1008133,po_item_product_name#1008134,transaction_id#1008135,buyer_gln#1008136,seller_gln#1008137,pod_division#1008138,pod_delivery_date#1008139,pod_product_item_id#1008140,pod_product_entity#1008141,po_number#1008142,product_item_id#1008143,product_entity#1008144,brand_context_id#1008145,po_division#1008146,po_delivery_date#1008147,row_id#1008148L,parent_row_id#1008149,chain_seq#1008150,tier#1008151,production_input_type#1008152,trans_create_ts#1008153,trans_update_ts#1008154,outbound_create_ts#1008155,outbound_supplier_code#1008156,... 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 10001 AND 20000) AS page) [numPartitions=1]
Output [135]: [po_item_product_code#1008133, po_item_product_name#1008134, transaction_id#1008135, buyer_gln#1008136, seller_gln#1008137, pod_division#1008138, pod_delivery_date#1008139, pod_product_item_id#1008140, pod_product_entity#1008141, po_number#1008142, product_item_id#1008143, product_entity#1008144, brand_context_id#1008145, po_division#1008146, po_delivery_date#1008147, row_id#1008148L, parent_row_id#1008149, chain_seq#1008150, tier#1008151, production_input_type#1008152, trans_create_ts#1008153, trans_update_ts#1008154, outbound_create_ts#1008155, outbound_supplier_code#1008156, outbound_supplier_name#1008157, outbound_trans_date#1008158, outbound_quantity#1008159, outbound_quantity_unit#1008160, outbound_seller_uom_quantity#1008161, outbound_seller_uom_unit#1008162, production_facility_uid#1008163, production_facility_name#1008164, production_facility_country#1008165, production_lot_id#1008166, production_trans_date#1008167, production_quantity#1008168, production_quantity_unit#1008169, production_seller_uom_quantity#1008170, production_seller_uom_unit#1008171, production_product_type#1008172, production_product_code#1008173, production_product_name#1008174, production_inputlot_quantity#1008175, production_inputlot_unit#1008176, production_inputlot_uom_quantity#1008177, production_inputlot_uom_quantity_unit#1008178, IP_P_facility_uid#1008179, IP_P_facility_name#1008180, IP_P_facility_country#1008181, IP_P_product_type#1008182, IP_P_lot_id#1008183, IP_P_trans_date#1008184, IP_P_output_quantity#1008185, IP_P_seller_uom_quantity#1008186, IP_P_seller_uom_quantity_unit#1008187, IP_P_inputlot_quantity#1008188, IP_P_inputlot_product_uid#1008189, PPI_product_name#1008190, IP_P_inputlot_supplier_facility_uid#1008191, IP_P_Supplier_facility_name#1008192, IP_P_Supplier_facility_country#1008193, IP_P_inputlot_id#1008194, IP_P_I_facility_uid#1008195, IP_P_I_facility_name#1008196, IP_P_I_facility_country#1008197, IP_P_I_transdate#1008198, IP_P_I_quantity#1008199, IP_P__IQuanaity_Unit_Desc#1008200, IP_P_Business_Document_Number#1008201, IP_P_output_product_uid#1008202, IP_P_product_ProductName#1008203, IP_P_product_ProductType#1008204, Inbound_Seller_UID#1008205, Inbound_Seller_Name#1008206, IP_P_I_profile_uid#1008207, IP_P_I_profile_name#1008208, IP_P_MaterialComp#1008209, IP_P_inputlot_supplier_uom_quantity#1008210, IP_P_inputlot_supplier_uom_unit#1008211, inbound_id#1008212, inbound_create_ts#1008213, inbound_trans_type#1008214, inbound_status#1008215, inbound_product_code#1008216, inbound_product_name#1008217, inbound_supplier_uid#1008218, inbound_Supplier_Name#1008219, inbound_supplier_facility_uid#1008220, inbound_supplier_facility_name#1008221, inbound_supplier_facility_country#1008222, inbound_seller_lot_id#1008223, inbound_facility_uid#1008224, inbound_facility_country#1008225, inbound_facility_name#1008226, inbound_trans_date#1008227, inbound_quantity#1008228, inbound_quantity_unit#1008229, inbound_seller_uom_quantity#1008230, inbound_seller_uom_unit#1008231, input_material_composition#1008232, inbound_business_document_number#1008233, inbound_document_yes_no#1008234, inter_production_facility_uid#1008235, inter_production_facility_name#1008236, inter_production_facility_country#1008237, inter_production_article_type_id#1008238, inter_production_material_unique_code#1008239, inter_production_internal_article_name#1008240, inter_production_lot_id#1008241, inter_production_trans_date#1008242, inter_production_output_quantity#1008243, inter_production_output_unit#1008244, inter_production_material#1008245, inter_production_input_quantity#1008246, inter_production_input_unit#1008247, inter_pod_input_product_code#1008248, inter_pod_input_product_name#1008249, inter_pod_inbound_reference_id#1008250, inter_pod_inbound_Supplier_Name#1008251, inter_pod_inbound_supplier_facility_uid#1008252, inter_pod_supplier_facility_name#1008253, inter_pod_address_country#1008254, inter_pod_inbound_seller_lot_id#1008255, inter_pod_inbound_facility_uid#1008256, inter_pod_inbound_facility_country#1008257, inter_pod_inbound_facility_name#1008258, inter_pod_inbound_trans_date#1008259, inter_pod_inbound_quantity#1008260, inter_pod_inbound_unit#1008261, inter_pod_inbound_seller_uom_quantity#1008262, inter_pod_inbound_seller_uom_unit#1008263, inter_pod_input_material_composition#1008264, inter_pod_business_document_number#1008265, inter_pod_inbound_document_yes_no#1008266, bigid#1008267L]
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#1011241L]
Results [1]: [count#1011242L]
(6) Exchange
Input [1]: [count#1011242L]
Arguments: SinglePartition, ENSURE_REQUIREMENTS, [plan_id=48230]
(7) ShuffleQueryStage
Output [1]: [count#1011242L]
Arguments: 1
(8) HashAggregate [codegen id : 2]
Input [1]: [count#1011242L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#1009213L]
Results [1]: [count(1)#1009213L AS count#1009214L]
(9) HashAggregate
Input: []
Keys: []
Functions [1]: [partial_count(1)]
Aggregate Attributes [1]: [count#1011241L]
Results [1]: [count#1011242L]
(10) Exchange
Input [1]: [count#1011242L]
Arguments: SinglePartition, ENSURE_REQUIREMENTS, [plan_id=48154]
(11) HashAggregate
Input [1]: [count#1011242L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#1009213L]
Results [1]: [count(1)#1009213L AS count#1009214L]
(12) AdaptiveSparkPlan
Output [1]: [count#1009214L]
Arguments: isFinalPlan=true