== 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#14524964, po_item_product_name#14524965, transaction_id#14524966, buyer_gln#14524967, seller_gln#14524968, pod_division#14524969, pod_delivery_date#14524970, pod_product_item_id#14524971, pod_product_entity#14524972, po_number#14524973, product_item_id#14524974, product_entity#14524975, brand_context_id#14524976, po_division#14524977, po_delivery_date#14524978, row_id#14524979L, parent_row_id#14524980, chain_seq#14524981, tier#14524982, production_input_type#14524983, trans_create_ts#14524984, trans_update_ts#14524985, outbound_create_ts#14524986, outbound_supplier_code#14524987, ... 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#14524964,po_item_product_name#14524965,transaction_id#14524966,buyer_gln#14524967,seller_gln#14524968,pod_division#14524969,pod_delivery_date#14524970,pod_product_item_id#14524971,pod_product_entity#14524972,po_number#14524973,product_item_id#14524974,product_entity#14524975,brand_context_id#14524976,po_division#14524977,po_delivery_date#14524978,row_id#14524979L,parent_row_id#14524980,chain_seq#14524981,tier#14524982,production_input_type#14524983,trans_create_ts#14524984,trans_update_ts#14524985,outbound_create_ts#14524986,outbound_supplier_code#14524987,... 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#14524964, po_item_product_name#14524965, transaction_id#14524966, buyer_gln#14524967, seller_gln#14524968, pod_division#14524969, pod_delivery_date#14524970, pod_product_item_id#14524971, pod_product_entity#14524972, po_number#14524973, product_item_id#14524974, product_entity#14524975, brand_context_id#14524976, po_division#14524977, po_delivery_date#14524978, row_id#14524979L, parent_row_id#14524980, chain_seq#14524981, tier#14524982, production_input_type#14524983, trans_create_ts#14524984, trans_update_ts#14524985, outbound_create_ts#14524986, outbound_supplier_code#14524987, outbound_supplier_name#14524988, outbound_trans_date#14524989, outbound_quantity#14524990, outbound_quantity_unit#14524991, outbound_seller_uom_quantity#14524992, outbound_seller_uom_unit#14524993, production_facility_uid#14524994, production_facility_name#14524995, production_facility_country#14524996, production_lot_id#14524997, production_trans_date#14524998, production_quantity#14524999, production_quantity_unit#14525000, production_seller_uom_quantity#14525001, production_seller_uom_unit#14525002, production_product_type#14525003, production_product_code#14525004, production_product_name#14525005, production_inputlot_quantity#14525006, production_inputlot_unit#14525007, production_inputlot_uom_quantity#14525008, production_inputlot_uom_quantity_unit#14525009, IP_P_facility_uid#14525010, IP_P_facility_name#14525011, IP_P_facility_country#14525012, IP_P_product_type#14525013, IP_P_lot_id#14525014, IP_P_trans_date#14525015, IP_P_output_quantity#14525016, IP_P_seller_uom_quantity#14525017, IP_P_seller_uom_quantity_unit#14525018, IP_P_inputlot_quantity#14525019, IP_P_inputlot_product_uid#14525020, PPI_product_name#14525021, IP_P_inputlot_supplier_facility_uid#14525022, IP_P_Supplier_facility_name#14525023, IP_P_Supplier_facility_country#14525024, IP_P_inputlot_id#14525025, IP_P_I_facility_uid#14525026, IP_P_I_facility_name#14525027, IP_P_I_facility_country#14525028, IP_P_I_transdate#14525029, IP_P_I_quantity#14525030, IP_P__IQuanaity_Unit_Desc#14525031, IP_P_Business_Document_Number#14525032, IP_P_output_product_uid#14525033, IP_P_product_ProductName#14525034, IP_P_product_ProductType#14525035, Inbound_Seller_UID#14525036, Inbound_Seller_Name#14525037, IP_P_I_profile_uid#14525038, IP_P_I_profile_name#14525039, IP_P_MaterialComp#14525040, IP_P_inputlot_supplier_uom_quantity#14525041, IP_P_inputlot_supplier_uom_unit#14525042, inbound_id#14525043, inbound_create_ts#14525044, inbound_trans_type#14525045, inbound_status#14525046, inbound_product_code#14525047, inbound_product_name#14525048, inbound_supplier_uid#14525049, inbound_Supplier_Name#14525050, inbound_supplier_facility_uid#14525051, inbound_supplier_facility_name#14525052, inbound_supplier_facility_country#14525053, inbound_seller_lot_id#14525054, inbound_facility_uid#14525055, inbound_facility_country#14525056, inbound_facility_name#14525057, inbound_trans_date#14525058, inbound_quantity#14525059, inbound_quantity_unit#14525060, inbound_seller_uom_quantity#14525061, inbound_seller_uom_unit#14525062, input_material_composition#14525063, inbound_business_document_number#14525064, inbound_document_yes_no#14525065, inter_production_facility_uid#14525066, inter_production_facility_name#14525067, inter_production_facility_country#14525068, inter_production_article_type_id#14525069, inter_production_material_unique_code#14525070, inter_production_internal_article_name#14525071, inter_production_lot_id#14525072, inter_production_trans_date#14525073, inter_production_output_quantity#14525074, inter_production_output_unit#14525075, inter_production_material#14525076, inter_production_input_quantity#14525077, inter_production_input_unit#14525078, inter_pod_input_product_code#14525079, inter_pod_input_product_name#14525080, inter_pod_inbound_reference_id#14525081, inter_pod_inbound_Supplier_Name#14525082, inter_pod_inbound_supplier_facility_uid#14525083, inter_pod_supplier_facility_name#14525084, inter_pod_address_country#14525085, inter_pod_inbound_seller_lot_id#14525086, inter_pod_inbound_facility_uid#14525087, inter_pod_inbound_facility_country#14525088, inter_pod_inbound_facility_name#14525089, inter_pod_inbound_trans_date#14525090, inter_pod_inbound_quantity#14525091, inter_pod_inbound_unit#14525092, inter_pod_inbound_seller_uom_quantity#14525093, inter_pod_inbound_seller_uom_unit#14525094, inter_pod_input_material_composition#14525095, inter_pod_business_document_number#14525096, inter_pod_inbound_document_yes_no#14525097, bigid#14525098L]
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#14528072L]
Results [1]: [count#14528073L]
(6) Exchange
Input [1]: [count#14528073L]
Arguments: SinglePartition, ENSURE_REQUIREMENTS, [plan_id=4263309]
(7) ShuffleQueryStage
Output [1]: [count#14528073L]
Arguments: 1
(8) HashAggregate [codegen id : 2]
Input [1]: [count#14528073L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#14526044L]
Results [1]: [count(1)#14526044L AS count#14526045L]
(9) HashAggregate
Input: []
Keys: []
Functions [1]: [partial_count(1)]
Aggregate Attributes [1]: [count#14528072L]
Results [1]: [count#14528073L]
(10) Exchange
Input [1]: [count#14528073L]
Arguments: SinglePartition, ENSURE_REQUIREMENTS, [plan_id=4263233]
(11) HashAggregate
Input [1]: [count#14528073L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#14526044L]
Results [1]: [count(1)#14526044L AS count#14526045L]
(12) AdaptiveSparkPlan
Output [1]: [count#14526045L]
Arguments: isFinalPlan=true