== Physical Plan ==
AdaptiveSparkPlan (7)
+- == Final Plan ==
DeserializeToObject (5)
+- TableCacheQueryStage (4), Statistics(sizeInBytes=14.5 KiB, rowCount=29)
+- InMemoryTableScan (1)
+- InMemoryRelation (2)
+- * Scan JDBCRelation((SELECT * FROM dbo.fact_supplier_facility_list WHERE bigid BETWEEN 1 AND 29) AS page) [numPartitions=1] (3)
+- == Initial Plan ==
DeserializeToObject (6)
+- InMemoryTableScan (1)
+- InMemoryRelation (2)
+- * Scan JDBCRelation((SELECT * FROM dbo.fact_supplier_facility_list WHERE bigid BETWEEN 1 AND 29) AS page) [numPartitions=1] (3)
(1) InMemoryTableScan
Output [48]: [brandid#993212, supplier_id#993213, Supplier Active Indicator#993214, Tier#993215, Tier Concat#993216, Supplier UID#993217, Supplier Name#993218, Supplier Industry Key#993219, Supplier Industry Key Description#993220, Supplier Address Line 1#993221, Supplier Address Line 2#993222, Supplier City#993223, Supplier State#993224, Supplier Country#993225, Supplier Zip Code#993226, Facility Active Indicator#993227, Facility UID#993228, Facility Name#993229, Facility Address Line 1#993230, Facility Address Line 2#993231, Facility City#993232, Facility State#993233, Facility Country#993234, Facility Zip Code#993235, Facility Industry Key#993236, Facility Industry Key Description#993237, Product Type#993238, Brands#993239, Brands Concat#993240, Contact Name#993241, Contact Email#993242, Contact Number#993243, Male Employee Count#993244, Female Employee Count#993245, Certificates#993246, Certificates Concat#993247, Production Capacity#993248, Value Process#993249, Value Process Concat#993250, Supplier Status#993251, Brand Created#993252, sp_supplier_id#993253, fs_facility_id#993254, Type Of Production#993255, FG Production#993256, RMS Production#993257, Facility_tier#993258, Facility_Archived_Status#993259]
Arguments: [brandid#993212, supplier_id#993213, Supplier Active Indicator#993214, Tier#993215, Tier Concat#993216, Supplier UID#993217, Supplier Name#993218, Supplier Industry Key#993219, Supplier Industry Key Description#993220, Supplier Address Line 1#993221, Supplier Address Line 2#993222, Supplier City#993223, Supplier State#993224, Supplier Country#993225, Supplier Zip Code#993226, Facility Active Indicator#993227, Facility UID#993228, Facility Name#993229, Facility Address Line 1#993230, Facility Address Line 2#993231, Facility City#993232, Facility State#993233, Facility Country#993234, Facility Zip Code#993235, ... 24 more fields]
(2) InMemoryRelation
Arguments: [brandid#993212, supplier_id#993213, Supplier Active Indicator#993214, Tier#993215, Tier Concat#993216, Supplier UID#993217, Supplier Name#993218, Supplier Industry Key#993219, Supplier Industry Key Description#993220, Supplier Address Line 1#993221, Supplier Address Line 2#993222, Supplier City#993223, Supplier State#993224, Supplier Country#993225, Supplier Zip Code#993226, Facility Active Indicator#993227, Facility UID#993228, Facility Name#993229, Facility Address Line 1#993230, Facility Address Line 2#993231, Facility City#993232, Facility State#993233, Facility Country#993234, Facility Zip Code#993235, ... 25 more fields], CachedRDDBuilder(org.apache.spark.sql.execution.columnar.DefaultCachedBatchSerializer@730ae8bf,StorageLevel(disk, memory, deserialized, 1 replicas),*(1) Scan JDBCRelation((SELECT * FROM dbo.fact_supplier_facility_list WHERE bigid BETWEEN 1 AND 29) AS page) [numPartitions=1] [brandid#993212,supplier_id#993213,Supplier Active Indicator#993214,Tier#993215,Tier Concat#993216,Supplier UID#993217,Supplier Name#993218,Supplier Industry Key#993219,Supplier Industry Key Description#993220,Supplier Address Line 1#993221,Supplier Address Line 2#993222,Supplier City#993223,Supplier State#993224,Supplier Country#993225,Supplier Zip Code#993226,Facility Active Indicator#993227,Facility UID#993228,Facility Name#993229,Facility Address Line 1#993230,Facility Address Line 2#993231,Facility City#993232,Facility State#993233,Facility Country#993234,Facility Zip Code#993235,... 25 more fields] PushedFilters: [], ReadSchema: struct<brandid:string,supplier_id:string,Supplier Active Indicator:string,Tier:string,Tier Concat...
,None)
(3) Scan JDBCRelation((SELECT * FROM dbo.fact_supplier_facility_list WHERE bigid BETWEEN 1 AND 29) AS page) [numPartitions=1] [codegen id : 1]
Output [49]: [brandid#993212, supplier_id#993213, Supplier Active Indicator#993214, Tier#993215, Tier Concat#993216, Supplier UID#993217, Supplier Name#993218, Supplier Industry Key#993219, Supplier Industry Key Description#993220, Supplier Address Line 1#993221, Supplier Address Line 2#993222, Supplier City#993223, Supplier State#993224, Supplier Country#993225, Supplier Zip Code#993226, Facility Active Indicator#993227, Facility UID#993228, Facility Name#993229, Facility Address Line 1#993230, Facility Address Line 2#993231, Facility City#993232, Facility State#993233, Facility Country#993234, Facility Zip Code#993235, Facility Industry Key#993236, Facility Industry Key Description#993237, Product Type#993238, Brands#993239, Brands Concat#993240, Contact Name#993241, Contact Email#993242, Contact Number#993243, Male Employee Count#993244, Female Employee Count#993245, Certificates#993246, Certificates Concat#993247, Production Capacity#993248, Value Process#993249, Value Process Concat#993250, Supplier Status#993251, Brand Created#993252, sp_supplier_id#993253, fs_facility_id#993254, Type Of Production#993255, FG Production#993256, RMS Production#993257, Facility_tier#993258, Facility_Archived_Status#993259, bigid#993260L]
ReadSchema: struct<brandid:string,supplier_id:string,Supplier Active Indicator:string,Tier:string,Tier Concat:string,Supplier UID:string,Supplier Name:string,Supplier Industry Key:string,Supplier Industry Key Description:string,Supplier Address Line 1:string,Supplier Address Line 2:string,Supplier City:string,Supplier State:string,Supplier Country:string,Supplier Zip Code:string,Facility Active Indicator:string,Facility UID:string,Facility Name:string,Facility Address Line 1:string,Facility Address Line 2:string,Facility City:string,Facility State:string,Facility Country:string,Facility Zip Code:string,Facility Industry Key:string,Facility Industry Key Description:string,Product Type:string,Brands:string,Brands Concat:string,Contact Name:string,Contact Email:string,Contact Number:string,Male Employee Count:double,Female Employee Count:double,Certificates:string,Certificates Concat:string,Production Capacity:string,Value Process:string,Value Process Concat:string,Supplier Status:string,Brand Created:string,sp_supplier_id:string,fs_facility_id:string,Type Of Production:string,FG Production:string,RMS Production:string,Facility_tier:string,Facility_Archived_Status:string,bigid:bigint>
(4) TableCacheQueryStage
Output [48]: [brandid#993212, supplier_id#993213, Supplier Active Indicator#993214, Tier#993215, Tier Concat#993216, Supplier UID#993217, Supplier Name#993218, Supplier Industry Key#993219, Supplier Industry Key Description#993220, Supplier Address Line 1#993221, Supplier Address Line 2#993222, Supplier City#993223, Supplier State#993224, Supplier Country#993225, Supplier Zip Code#993226, Facility Active Indicator#993227, Facility UID#993228, Facility Name#993229, Facility Address Line 1#993230, Facility Address Line 2#993231, Facility City#993232, Facility State#993233, Facility Country#993234, Facility Zip Code#993235, Facility Industry Key#993236, Facility Industry Key Description#993237, Product Type#993238, Brands#993239, Brands Concat#993240, Contact Name#993241, Contact Email#993242, Contact Number#993243, Male Employee Count#993244, Female Employee Count#993245, Certificates#993246, Certificates Concat#993247, Production Capacity#993248, Value Process#993249, Value Process Concat#993250, Supplier Status#993251, Brand Created#993252, sp_supplier_id#993253, fs_facility_id#993254, Type Of Production#993255, FG Production#993256, RMS Production#993257, Facility_tier#993258, Facility_Archived_Status#993259]
Arguments: 0
(5) DeserializeToObject
Input [48]: [brandid#993212, supplier_id#993213, Supplier Active Indicator#993214, Tier#993215, Tier Concat#993216, Supplier UID#993217, Supplier Name#993218, Supplier Industry Key#993219, Supplier Industry Key Description#993220, Supplier Address Line 1#993221, Supplier Address Line 2#993222, Supplier City#993223, Supplier State#993224, Supplier Country#993225, Supplier Zip Code#993226, Facility Active Indicator#993227, Facility UID#993228, Facility Name#993229, Facility Address Line 1#993230, Facility Address Line 2#993231, Facility City#993232, Facility State#993233, Facility Country#993234, Facility Zip Code#993235, Facility Industry Key#993236, Facility Industry Key Description#993237, Product Type#993238, Brands#993239, Brands Concat#993240, Contact Name#993241, Contact Email#993242, Contact Number#993243, Male Employee Count#993244, Female Employee Count#993245, Certificates#993246, Certificates Concat#993247, Production Capacity#993248, Value Process#993249, Value Process Concat#993250, Supplier Status#993251, Brand Created#993252, sp_supplier_id#993253, fs_facility_id#993254, Type Of Production#993255, FG Production#993256, RMS Production#993257, Facility_tier#993258, Facility_Archived_Status#993259]
Arguments: createexternalrow(brandid#993212.toString, supplier_id#993213.toString, Supplier Active Indicator#993214.toString, Tier#993215.toString, Tier Concat#993216.toString, Supplier UID#993217.toString, Supplier Name#993218.toString, Supplier Industry Key#993219.toString, Supplier Industry Key Description#993220.toString, Supplier Address Line 1#993221.toString, Supplier Address Line 2#993222.toString, Supplier City#993223.toString, Supplier State#993224.toString, Supplier Country#993225.toString, Supplier Zip Code#993226.toString, Facility Active Indicator#993227.toString, Facility UID#993228.toString, Facility Name#993229.toString, Facility Address Line 1#993230.toString, Facility Address Line 2#993231.toString, Facility City#993232.toString, Facility State#993233.toString, Facility Country#993234.toString, Facility Zip Code#993235.toString, ... 72 more fields), obj#997357: org.apache.spark.sql.Row
(6) DeserializeToObject
Input [48]: [brandid#993212, supplier_id#993213, Supplier Active Indicator#993214, Tier#993215, Tier Concat#993216, Supplier UID#993217, Supplier Name#993218, Supplier Industry Key#993219, Supplier Industry Key Description#993220, Supplier Address Line 1#993221, Supplier Address Line 2#993222, Supplier City#993223, Supplier State#993224, Supplier Country#993225, Supplier Zip Code#993226, Facility Active Indicator#993227, Facility UID#993228, Facility Name#993229, Facility Address Line 1#993230, Facility Address Line 2#993231, Facility City#993232, Facility State#993233, Facility Country#993234, Facility Zip Code#993235, Facility Industry Key#993236, Facility Industry Key Description#993237, Product Type#993238, Brands#993239, Brands Concat#993240, Contact Name#993241, Contact Email#993242, Contact Number#993243, Male Employee Count#993244, Female Employee Count#993245, Certificates#993246, Certificates Concat#993247, Production Capacity#993248, Value Process#993249, Value Process Concat#993250, Supplier Status#993251, Brand Created#993252, sp_supplier_id#993253, fs_facility_id#993254, Type Of Production#993255, FG Production#993256, RMS Production#993257, Facility_tier#993258, Facility_Archived_Status#993259]
Arguments: createexternalrow(brandid#993212.toString, supplier_id#993213.toString, Supplier Active Indicator#993214.toString, Tier#993215.toString, Tier Concat#993216.toString, Supplier UID#993217.toString, Supplier Name#993218.toString, Supplier Industry Key#993219.toString, Supplier Industry Key Description#993220.toString, Supplier Address Line 1#993221.toString, Supplier Address Line 2#993222.toString, Supplier City#993223.toString, Supplier State#993224.toString, Supplier Country#993225.toString, Supplier Zip Code#993226.toString, Facility Active Indicator#993227.toString, Facility UID#993228.toString, Facility Name#993229.toString, Facility Address Line 1#993230.toString, Facility Address Line 2#993231.toString, Facility City#993232.toString, Facility State#993233.toString, Facility Country#993234.toString, Facility Zip Code#993235.toString, ... 72 more fields), obj#997357: org.apache.spark.sql.Row
(7) AdaptiveSparkPlan
Output [1]: [obj#997357]
Arguments: isFinalPlan=true