== Physical Plan ==
AdaptiveSparkPlan (7)
+- == Final Plan ==
DeserializeToObject (5)
+- TableCacheQueryStage (4), Statistics(sizeInBytes=2.1 KiB, rowCount=97)
+- InMemoryTableScan (1)
+- InMemoryRelation (2)
+- * Scan JDBCRelation((SELECT * FROM dbo.fact_spa_social_compliance_audit_results_dates WHERE bigid BETWEEN 1 AND 97) AS page) [numPartitions=1] (3)
+- == Initial Plan ==
DeserializeToObject (6)
+- InMemoryTableScan (1)
+- InMemoryRelation (2)
+- * Scan JDBCRelation((SELECT * FROM dbo.fact_spa_social_compliance_audit_results_dates WHERE bigid BETWEEN 1 AND 97) AS page) [numPartitions=1] (3)
(1) InMemoryTableScan
Output [2]: [audit_date#10600343, fiscal_quarter#10600344]
Arguments: [audit_date#10600343, fiscal_quarter#10600344]
(2) InMemoryRelation
Arguments: [audit_date#10600343, fiscal_quarter#10600344, bigid#10600345L], CachedRDDBuilder(org.apache.spark.sql.execution.columnar.DefaultCachedBatchSerializer@7795a5ad,StorageLevel(disk, memory, deserialized, 1 replicas),*(1) Scan JDBCRelation((SELECT * FROM dbo.fact_spa_social_compliance_audit_results_dates WHERE bigid BETWEEN 1 AND 97) AS page) [numPartitions=1] [audit_date#10600343,fiscal_quarter#10600344,bigid#10600345L] PushedFilters: [], ReadSchema: struct<audit_date:date,fiscal_quarter:string,bigid:bigint>
,None)
(3) Scan JDBCRelation((SELECT * FROM dbo.fact_spa_social_compliance_audit_results_dates WHERE bigid BETWEEN 1 AND 97) AS page) [numPartitions=1] [codegen id : 1]
Output [3]: [audit_date#10600343, fiscal_quarter#10600344, bigid#10600345L]
ReadSchema: struct<audit_date:date,fiscal_quarter:string,bigid:bigint>
(4) TableCacheQueryStage
Output [2]: [audit_date#10600343, fiscal_quarter#10600344]
Arguments: 0
(5) DeserializeToObject
Input [2]: [audit_date#10600343, fiscal_quarter#10600344]
Arguments: createexternalrow(staticinvoke(class org.apache.spark.sql.catalyst.util.DateTimeUtils$, ObjectType(class java.sql.Date), toJavaDate, audit_date#10600343, true, false, true), fiscal_quarter#10600344.toString, StructField(audit_date,DateType,true), StructField(fiscal_quarter,StringType,true)), obj#10605417: org.apache.spark.sql.Row
(6) DeserializeToObject
Input [2]: [audit_date#10600343, fiscal_quarter#10600344]
Arguments: createexternalrow(staticinvoke(class org.apache.spark.sql.catalyst.util.DateTimeUtils$, ObjectType(class java.sql.Date), toJavaDate, audit_date#10600343, true, false, true), fiscal_quarter#10600344.toString, StructField(audit_date,DateType,true), StructField(fiscal_quarter,StringType,true)), obj#10605417: org.apache.spark.sql.Row
(7) AdaptiveSparkPlan
Output [1]: [obj#10605417]
Arguments: isFinalPlan=true