== Physical Plan ==
AdaptiveSparkPlan (7)
+- == Final Plan ==
DeserializeToObject (5)
+- TableCacheQueryStage (4), Statistics(sizeInBytes=3.3 KiB, rowCount=13)
+- InMemoryTableScan (1)
+- InMemoryRelation (2)
+- * Scan JDBCRelation(dbo.fact_PDC_AGEC_Report) [numPartitions=1] (3)
+- == Initial Plan ==
DeserializeToObject (6)
+- InMemoryTableScan (1)
+- InMemoryRelation (2)
+- * Scan JDBCRelation(dbo.fact_PDC_AGEC_Report) [numPartitions=1] (3)
(1) InMemoryTableScan
Output [33]: [brand_id#20599252, Style ID#20599253, Supplier_id#20599254, season#20599255, Model#20599256, Part#20599257, Color#20599258, Tipo origine#20599259, Product ID#20599260, Country-Style Printing#20599261, Country-Finishing#20599262, Country-Stitching#20599263, material_supplier_id#20599264, Mseason#20599265, Country Manufacturing / Assembling#20599266, Country-Style Dyeing#20599267, ProductType#20599268, productClassification#20599269, productGroup#20599270, % Material Recycled#20599271, % Microplastic#20599272, Last Date for confirmed OC#20599273, Cancelled Flag#20599274, Supplier Name#20599275, Country-Fabric Dyeing#20599276, Country-Yarn Dyeing#20599277, Country-Fabric Printing#20599278, Country-Weaving#20599279, Country- Knitting#20599280, launch_details_config_name#20599281, ReportType#20599282, division#20599283, unique_division_key#20599284]
Arguments: [brand_id#20599252, Style ID#20599253, Supplier_id#20599254, season#20599255, Model#20599256, Part#20599257, Color#20599258, Tipo origine#20599259, Product ID#20599260, Country-Style Printing#20599261, Country-Finishing#20599262, Country-Stitching#20599263, material_supplier_id#20599264, Mseason#20599265, Country Manufacturing / Assembling#20599266, Country-Style Dyeing#20599267, ProductType#20599268, productClassification#20599269, productGroup#20599270, % Material Recycled#20599271, % Microplastic#20599272, Last Date for confirmed OC#20599273, Cancelled Flag#20599274, Supplier Name#20599275, ... 9 more fields]
(2) InMemoryRelation
Arguments: [brand_id#20599252, Style ID#20599253, Supplier_id#20599254, season#20599255, Model#20599256, Part#20599257, Color#20599258, Tipo origine#20599259, Product ID#20599260, Country-Style Printing#20599261, Country-Finishing#20599262, Country-Stitching#20599263, material_supplier_id#20599264, Mseason#20599265, Country Manufacturing / Assembling#20599266, Country-Style Dyeing#20599267, ProductType#20599268, productClassification#20599269, productGroup#20599270, % Material Recycled#20599271, % Microplastic#20599272, Last Date for confirmed OC#20599273, Cancelled Flag#20599274, Supplier Name#20599275, ... 9 more fields], CachedRDDBuilder(org.apache.spark.sql.execution.columnar.DefaultCachedBatchSerializer@14de14ab,StorageLevel(disk, memory, deserialized, 1 replicas),*(1) Scan JDBCRelation(dbo.fact_PDC_AGEC_Report) [numPartitions=1] [brand_id#20599252,Style ID#20599253,Supplier_id#20599254,season#20599255,Model#20599256,Part#20599257,Color#20599258,Tipo origine#20599259,Product ID#20599260,Country-Style Printing#20599261,Country-Finishing#20599262,Country-Stitching#20599263,material_supplier_id#20599264,Mseason#20599265,Country Manufacturing / Assembling#20599266,Country-Style Dyeing#20599267,ProductType#20599268,productClassification#20599269,productGroup#20599270,% Material Recycled#20599271,% Microplastic#20599272,Last Date for confirmed OC#20599273,Cancelled Flag#20599274,Supplier Name#20599275,... 9 more fields] PushedFilters: [], ReadSchema: struct<brand_id:string,Style ID:string,Supplier_id:string,season:string,Model:string,Part:string,...
,None)
(3) Scan JDBCRelation(dbo.fact_PDC_AGEC_Report) [numPartitions=1] [codegen id : 1]
Output [33]: [brand_id#20599252, Style ID#20599253, Supplier_id#20599254, season#20599255, Model#20599256, Part#20599257, Color#20599258, Tipo origine#20599259, Product ID#20599260, Country-Style Printing#20599261, Country-Finishing#20599262, Country-Stitching#20599263, material_supplier_id#20599264, Mseason#20599265, Country Manufacturing / Assembling#20599266, Country-Style Dyeing#20599267, ProductType#20599268, productClassification#20599269, productGroup#20599270, % Material Recycled#20599271, % Microplastic#20599272, Last Date for confirmed OC#20599273, Cancelled Flag#20599274, Supplier Name#20599275, Country-Fabric Dyeing#20599276, Country-Yarn Dyeing#20599277, Country-Fabric Printing#20599278, Country-Weaving#20599279, Country- Knitting#20599280, launch_details_config_name#20599281, ReportType#20599282, division#20599283, unique_division_key#20599284]
ReadSchema: struct<brand_id:string,Style ID:string,Supplier_id:string,season:string,Model:string,Part:string,Color:int,Tipo origine:int,Product ID:string,Country-Style Printing:string,Country-Finishing:string,Country-Stitching:string,material_supplier_id:string,Mseason:string,Country Manufacturing / Assembling:string,Country-Style Dyeing:string,ProductType:int,productClassification:int,productGroup:int,% Material Recycled:int,% Microplastic:int,Last Date for confirmed OC:int,Cancelled Flag:int,Supplier Name:string,Country-Fabric Dyeing:string,Country-Yarn Dyeing:string,Country-Fabric Printing:string,Country-Weaving:string,Country- Knitting:string,launch_details_config_name:string,ReportType:string,division:string,unique_division_key:string>
(4) TableCacheQueryStage
Output [33]: [brand_id#20599252, Style ID#20599253, Supplier_id#20599254, season#20599255, Model#20599256, Part#20599257, Color#20599258, Tipo origine#20599259, Product ID#20599260, Country-Style Printing#20599261, Country-Finishing#20599262, Country-Stitching#20599263, material_supplier_id#20599264, Mseason#20599265, Country Manufacturing / Assembling#20599266, Country-Style Dyeing#20599267, ProductType#20599268, productClassification#20599269, productGroup#20599270, % Material Recycled#20599271, % Microplastic#20599272, Last Date for confirmed OC#20599273, Cancelled Flag#20599274, Supplier Name#20599275, Country-Fabric Dyeing#20599276, Country-Yarn Dyeing#20599277, Country-Fabric Printing#20599278, Country-Weaving#20599279, Country- Knitting#20599280, launch_details_config_name#20599281, ReportType#20599282, division#20599283, unique_division_key#20599284]
Arguments: 0
(5) DeserializeToObject
Input [33]: [brand_id#20599252, Style ID#20599253, Supplier_id#20599254, season#20599255, Model#20599256, Part#20599257, Color#20599258, Tipo origine#20599259, Product ID#20599260, Country-Style Printing#20599261, Country-Finishing#20599262, Country-Stitching#20599263, material_supplier_id#20599264, Mseason#20599265, Country Manufacturing / Assembling#20599266, Country-Style Dyeing#20599267, ProductType#20599268, productClassification#20599269, productGroup#20599270, % Material Recycled#20599271, % Microplastic#20599272, Last Date for confirmed OC#20599273, Cancelled Flag#20599274, Supplier Name#20599275, Country-Fabric Dyeing#20599276, Country-Yarn Dyeing#20599277, Country-Fabric Printing#20599278, Country-Weaving#20599279, Country- Knitting#20599280, launch_details_config_name#20599281, ReportType#20599282, division#20599283, unique_division_key#20599284]
Arguments: createexternalrow(brand_id#20599252.toString, Style ID#20599253.toString, Supplier_id#20599254.toString, season#20599255.toString, Model#20599256.toString, Part#20599257.toString, staticinvoke(class java.lang.Integer, ObjectType(class java.lang.Integer), valueOf, Color#20599258, true, false, true), staticinvoke(class java.lang.Integer, ObjectType(class java.lang.Integer), valueOf, Tipo origine#20599259, true, false, true), Product ID#20599260.toString, Country-Style Printing#20599261.toString, Country-Finishing#20599262.toString, Country-Stitching#20599263.toString, material_supplier_id#20599264.toString, Mseason#20599265.toString, Country Manufacturing / Assembling#20599266.toString, Country-Style Dyeing#20599267.toString, staticinvoke(class java.lang.Integer, ObjectType(class java.lang.Integer), valueOf, ProductType#20599268, true, false, true), staticinvoke(class java.lang.Integer, ObjectType(class java.lang.Integer), valueOf, productClassification#20599269, true, false, true), staticinvoke(class java.lang.Integer, ObjectType(class java.lang.Integer), valueOf, productGroup#20599270, true, false, true), staticinvoke(class java.lang.Integer, ObjectType(class java.lang.Integer), valueOf, % Material Recycled#20599271, true, false, true), staticinvoke(class java.lang.Integer, ObjectType(class java.lang.Integer), valueOf, % Microplastic#20599272, true, false, true), staticinvoke(class java.lang.Integer, ObjectType(class java.lang.Integer), valueOf, Last Date for confirmed OC#20599273, true, false, true), staticinvoke(class java.lang.Integer, ObjectType(class java.lang.Integer), valueOf, Cancelled Flag#20599274, true, false, true), Supplier Name#20599275.toString, ... 42 more fields), obj#20600425: org.apache.spark.sql.Row
(6) DeserializeToObject
Input [33]: [brand_id#20599252, Style ID#20599253, Supplier_id#20599254, season#20599255, Model#20599256, Part#20599257, Color#20599258, Tipo origine#20599259, Product ID#20599260, Country-Style Printing#20599261, Country-Finishing#20599262, Country-Stitching#20599263, material_supplier_id#20599264, Mseason#20599265, Country Manufacturing / Assembling#20599266, Country-Style Dyeing#20599267, ProductType#20599268, productClassification#20599269, productGroup#20599270, % Material Recycled#20599271, % Microplastic#20599272, Last Date for confirmed OC#20599273, Cancelled Flag#20599274, Supplier Name#20599275, Country-Fabric Dyeing#20599276, Country-Yarn Dyeing#20599277, Country-Fabric Printing#20599278, Country-Weaving#20599279, Country- Knitting#20599280, launch_details_config_name#20599281, ReportType#20599282, division#20599283, unique_division_key#20599284]
Arguments: createexternalrow(brand_id#20599252.toString, Style ID#20599253.toString, Supplier_id#20599254.toString, season#20599255.toString, Model#20599256.toString, Part#20599257.toString, staticinvoke(class java.lang.Integer, ObjectType(class java.lang.Integer), valueOf, Color#20599258, true, false, true), staticinvoke(class java.lang.Integer, ObjectType(class java.lang.Integer), valueOf, Tipo origine#20599259, true, false, true), Product ID#20599260.toString, Country-Style Printing#20599261.toString, Country-Finishing#20599262.toString, Country-Stitching#20599263.toString, material_supplier_id#20599264.toString, Mseason#20599265.toString, Country Manufacturing / Assembling#20599266.toString, Country-Style Dyeing#20599267.toString, staticinvoke(class java.lang.Integer, ObjectType(class java.lang.Integer), valueOf, ProductType#20599268, true, false, true), staticinvoke(class java.lang.Integer, ObjectType(class java.lang.Integer), valueOf, productClassification#20599269, true, false, true), staticinvoke(class java.lang.Integer, ObjectType(class java.lang.Integer), valueOf, productGroup#20599270, true, false, true), staticinvoke(class java.lang.Integer, ObjectType(class java.lang.Integer), valueOf, % Material Recycled#20599271, true, false, true), staticinvoke(class java.lang.Integer, ObjectType(class java.lang.Integer), valueOf, % Microplastic#20599272, true, false, true), staticinvoke(class java.lang.Integer, ObjectType(class java.lang.Integer), valueOf, Last Date for confirmed OC#20599273, true, false, true), staticinvoke(class java.lang.Integer, ObjectType(class java.lang.Integer), valueOf, Cancelled Flag#20599274, true, false, true), Supplier Name#20599275.toString, ... 42 more fields), obj#20600425: org.apache.spark.sql.Row
(7) AdaptiveSparkPlan
Output [1]: [obj#20600425]
Arguments: isFinalPlan=true