== 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=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 ==
HashAggregate (11)
+- Exchange (10)
+- HashAggregate (9)
+- 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) 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: []
Arguments: 0
(5) HashAggregate [codegen id : 1]
Input: []
Keys: []
Functions [1]: [partial_count(1)]
Aggregate Attributes [1]: [count#10600450L]
Results [1]: [count#10600451L]
(6) Exchange
Input [1]: [count#10600451L]
Arguments: SinglePartition, ENSURE_REQUIREMENTS, [plan_id=376349]
(7) ShuffleQueryStage
Output [1]: [count#10600451L]
Arguments: 1
(8) HashAggregate [codegen id : 2]
Input [1]: [count#10600451L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#10600367L]
Results [1]: [count(1)#10600367L AS count#10600368L]
(9) HashAggregate
Input: []
Keys: []
Functions [1]: [partial_count(1)]
Aggregate Attributes [1]: [count#10600450L]
Results [1]: [count#10600451L]
(10) Exchange
Input [1]: [count#10600451L]
Arguments: SinglePartition, ENSURE_REQUIREMENTS, [plan_id=376000]
(11) HashAggregate
Input [1]: [count#10600451L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#10600367L]
Results [1]: [count(1)#10600367L AS count#10600368L]
(12) AdaptiveSparkPlan
Output [1]: [count#10600368L]
Arguments: isFinalPlan=true