== Physical Plan ==
AdaptiveSparkPlan (12)
+- == Final Plan ==
ObjectHashAggregate (7)
+- ShuffleQueryStage (6), Statistics(sizeInBytes=1169.9 KiB, rowCount=1)
+- Exchange (5)
+- ObjectHashAggregate (4)
+- * Project (3)
+- * ColumnarToRow (2)
+- Scan parquet (1)
+- == Initial Plan ==
ObjectHashAggregate (11)
+- Exchange (10)
+- ObjectHashAggregate (9)
+- Project (8)
+- Scan parquet (1)
(1) Scan parquet
Output [1]: [COL_3FCABC8B_94D6_4907_A464_3800851C2E14#115380]
Batched: true
Location: InMemoryFileIndex [file:/data/output/cache/parquet/datablock/TEST_156492]
ReadSchema: struct<COL_3FCABC8B_94D6_4907_A464_3800851C2E14:double>
(2) ColumnarToRow [codegen id : 1]
Input [1]: [COL_3FCABC8B_94D6_4907_A464_3800851C2E14#115380]
(3) Project [codegen id : 1]
Output [1]: [COL_3FCABC8B_94D6_4907_A464_3800851C2E14#115380 AS COL_COL_3FCABC8B_94D6_4907_A464_3800851C2E14#115566]
Input [1]: [COL_3FCABC8B_94D6_4907_A464_3800851C2E14#115380]
(4) ObjectHashAggregate
Input [1]: [COL_COL_3FCABC8B_94D6_4907_A464_3800851C2E14#115566]
Keys: []
Functions [11]: [partial_count(1), partial_count(CASE WHEN (NOT isnan(COL_COL_3FCABC8B_94D6_4907_A464_3800851C2E14#115566) AND isnotnull(COL_COL_3FCABC8B_94D6_4907_A464_3800851C2E14#115566)) THEN COL_COL_3FCABC8B_94D6_4907_A464_3800851C2E14 END), partial_min(COL_COL_3FCABC8B_94D6_4907_A464_3800851C2E14#115566), partial_max(COL_COL_3FCABC8B_94D6_4907_A464_3800851C2E14#115566), partial_avg(COL_COL_3FCABC8B_94D6_4907_A464_3800851C2E14#115566), partial_percentile_approx(COL_COL_3FCABC8B_94D6_4907_A464_3800851C2E14#115566, 0.5, 10000, 0, 0), partial_sum(COL_COL_3FCABC8B_94D6_4907_A464_3800851C2E14#115566), partial_var_samp(COL_COL_3FCABC8B_94D6_4907_A464_3800851C2E14#115566), partial_stddev_pop(COL_COL_3FCABC8B_94D6_4907_A464_3800851C2E14#115566), partial_percentile_approx(COL_COL_3FCABC8B_94D6_4907_A464_3800851C2E14#115566, 0.25, 10000, 0, 0), partial_percentile_approx(COL_COL_3FCABC8B_94D6_4907_A464_3800851C2E14#115566, 0.75, 10000, 0, 0)]
Aggregate Attributes [16]: [count#115753L, count#115754L, min#115755, max#115756, sum#115757, count#115758L, buf#115759, sum#115760, n#115692, avg#115693, m2#115694, n#115700, avg#115701, m2#115702, buf#115761, buf#115762]
Results [16]: [count#115763L, count#115764L, min#115765, max#115766, sum#115767, count#115768L, buf#115769, sum#115770, n#115697, avg#115698, m2#115699, n#115705, avg#115706, m2#115707, buf#115771, buf#115772]
(5) Exchange
Input [16]: [count#115763L, count#115764L, min#115765, max#115766, sum#115767, count#115768L, buf#115769, sum#115770, n#115697, avg#115698, m2#115699, n#115705, avg#115706, m2#115707, buf#115771, buf#115772]
Arguments: SinglePartition, ENSURE_REQUIREMENTS, [plan_id=8273]
(6) ShuffleQueryStage
Output [16]: [count#115763L, count#115764L, min#115765, max#115766, sum#115767, count#115768L, buf#115769, sum#115770, n#115697, avg#115698, m2#115699, n#115705, avg#115706, m2#115707, buf#115771, buf#115772]
Arguments: 0
(7) ObjectHashAggregate
Input [16]: [count#115763L, count#115764L, min#115765, max#115766, sum#115767, count#115768L, buf#115769, sum#115770, n#115697, avg#115698, m2#115699, n#115705, avg#115706, m2#115707, buf#115771, buf#115772]
Keys: []
Functions [11]: [count(1), count(CASE WHEN (NOT isnan(COL_COL_3FCABC8B_94D6_4907_A464_3800851C2E14#115566) AND isnotnull(COL_COL_3FCABC8B_94D6_4907_A464_3800851C2E14#115566)) THEN COL_COL_3FCABC8B_94D6_4907_A464_3800851C2E14 END), min(COL_COL_3FCABC8B_94D6_4907_A464_3800851C2E14#115566), max(COL_COL_3FCABC8B_94D6_4907_A464_3800851C2E14#115566), avg(COL_COL_3FCABC8B_94D6_4907_A464_3800851C2E14#115566), percentile_approx(COL_COL_3FCABC8B_94D6_4907_A464_3800851C2E14#115566, 0.5, 10000, 0, 0), sum(COL_COL_3FCABC8B_94D6_4907_A464_3800851C2E14#115566), var_samp(COL_COL_3FCABC8B_94D6_4907_A464_3800851C2E14#115566), stddev_pop(COL_COL_3FCABC8B_94D6_4907_A464_3800851C2E14#115566), percentile_approx(COL_COL_3FCABC8B_94D6_4907_A464_3800851C2E14#115566, 0.25, 10000, 0, 0), percentile_approx(COL_COL_3FCABC8B_94D6_4907_A464_3800851C2E14#115566, 0.75, 10000, 0, 0)]
Aggregate Attributes [11]: [count(1)#115623L, count(CASE WHEN (NOT isnan(COL_COL_3FCABC8B_94D6_4907_A464_3800851C2E14#115566) AND isnotnull(COL_COL_3FCABC8B_94D6_4907_A464_3800851C2E14#115566)) THEN COL_COL_3FCABC8B_94D6_4907_A464_3800851C2E14 END)#115626L, min(COL_COL_3FCABC8B_94D6_4907_A464_3800851C2E14#115566)#115628, max(COL_COL_3FCABC8B_94D6_4907_A464_3800851C2E14#115566)#115630, avg(COL_COL_3FCABC8B_94D6_4907_A464_3800851C2E14#115566)#115632, percentile_approx(COL_COL_3FCABC8B_94D6_4907_A464_3800851C2E14#115566, 0.5, 10000, 0, 0)#115708, sum(COL_COL_3FCABC8B_94D6_4907_A464_3800851C2E14#115566)#115635, var_samp(COL_COL_3FCABC8B_94D6_4907_A464_3800851C2E14#115566)#115645, stddev_pop(COL_COL_3FCABC8B_94D6_4907_A464_3800851C2E14#115566)#115655, percentile_approx(COL_COL_3FCABC8B_94D6_4907_A464_3800851C2E14#115566, 0.25, 10000, 0, 0)#115709, percentile_approx(COL_COL_3FCABC8B_94D6_4907_A464_3800851C2E14#115566, 0.75, 10000, 0, 0)#115711]
Results [12]: [count(1)#115623L AS COL_COL_3FCABC8B_94D6_4907_A464_3800851C2E141#115625L, count(CASE WHEN (NOT isnan(COL_COL_3FCABC8B_94D6_4907_A464_3800851C2E14#115566) AND isnotnull(COL_COL_3FCABC8B_94D6_4907_A464_3800851C2E14#115566)) THEN COL_COL_3FCABC8B_94D6_4907_A464_3800851C2E14 END)#115626L AS COL_COL_3FCABC8B_94D6_4907_A464_3800851C2E142#115627L, min(COL_COL_3FCABC8B_94D6_4907_A464_3800851C2E14#115566)#115628 AS COL_COL_3FCABC8B_94D6_4907_A464_3800851C2E144#115629, max(COL_COL_3FCABC8B_94D6_4907_A464_3800851C2E14#115566)#115630 AS COL_COL_3FCABC8B_94D6_4907_A464_3800851C2E145#115631, avg(COL_COL_3FCABC8B_94D6_4907_A464_3800851C2E14#115566)#115632 AS COL_COL_3FCABC8B_94D6_4907_A464_3800851C2E146#115633, percentile_approx(COL_COL_3FCABC8B_94D6_4907_A464_3800851C2E14#115566, 0.5, 10000, 0, 0)#115708 AS COL_COL_3FCABC8B_94D6_4907_A464_3800851C2E147#115634, sum(COL_COL_3FCABC8B_94D6_4907_A464_3800851C2E14#115566)#115635 AS COL_COL_3FCABC8B_94D6_4907_A464_3800851C2E148#115636, var_samp(COL_COL_3FCABC8B_94D6_4907_A464_3800851C2E14#115566)#115645 AS COL_COL_3FCABC8B_94D6_4907_A464_3800851C2E149#115646, stddev_pop(COL_COL_3FCABC8B_94D6_4907_A464_3800851C2E14#115566)#115655 AS COL_COL_3FCABC8B_94D6_4907_A464_3800851C2E1410#115656, percentile_approx(COL_COL_3FCABC8B_94D6_4907_A464_3800851C2E14#115566, 0.25, 10000, 0, 0)#115709 AS COL_COL_3FCABC8B_94D6_4907_A464_3800851C2E1411#115657, percentile_approx(COL_COL_3FCABC8B_94D6_4907_A464_3800851C2E14#115566, 0.5, 10000, 0, 0)#115708 AS COL_COL_3FCABC8B_94D6_4907_A464_3800851C2E1412#115658, percentile_approx(COL_COL_3FCABC8B_94D6_4907_A464_3800851C2E14#115566, 0.75, 10000, 0, 0)#115711 AS COL_COL_3FCABC8B_94D6_4907_A464_3800851C2E1413#115659]
(8) Project
Output [1]: [COL_3FCABC8B_94D6_4907_A464_3800851C2E14#115380 AS COL_COL_3FCABC8B_94D6_4907_A464_3800851C2E14#115566]
Input [1]: [COL_3FCABC8B_94D6_4907_A464_3800851C2E14#115380]
(9) ObjectHashAggregate
Input [1]: [COL_COL_3FCABC8B_94D6_4907_A464_3800851C2E14#115566]
Keys: []
Functions [11]: [partial_count(1), partial_count(CASE WHEN (NOT isnan(COL_COL_3FCABC8B_94D6_4907_A464_3800851C2E14#115566) AND isnotnull(COL_COL_3FCABC8B_94D6_4907_A464_3800851C2E14#115566)) THEN COL_COL_3FCABC8B_94D6_4907_A464_3800851C2E14 END), partial_min(COL_COL_3FCABC8B_94D6_4907_A464_3800851C2E14#115566), partial_max(COL_COL_3FCABC8B_94D6_4907_A464_3800851C2E14#115566), partial_avg(COL_COL_3FCABC8B_94D6_4907_A464_3800851C2E14#115566), partial_percentile_approx(COL_COL_3FCABC8B_94D6_4907_A464_3800851C2E14#115566, 0.5, 10000, 0, 0), partial_sum(COL_COL_3FCABC8B_94D6_4907_A464_3800851C2E14#115566), partial_var_samp(COL_COL_3FCABC8B_94D6_4907_A464_3800851C2E14#115566), partial_stddev_pop(COL_COL_3FCABC8B_94D6_4907_A464_3800851C2E14#115566), partial_percentile_approx(COL_COL_3FCABC8B_94D6_4907_A464_3800851C2E14#115566, 0.25, 10000, 0, 0), partial_percentile_approx(COL_COL_3FCABC8B_94D6_4907_A464_3800851C2E14#115566, 0.75, 10000, 0, 0)]
Aggregate Attributes [16]: [count#115753L, count#115754L, min#115755, max#115756, sum#115757, count#115758L, buf#115759, sum#115760, n#115692, avg#115693, m2#115694, n#115700, avg#115701, m2#115702, buf#115761, buf#115762]
Results [16]: [count#115763L, count#115764L, min#115765, max#115766, sum#115767, count#115768L, buf#115769, sum#115770, n#115697, avg#115698, m2#115699, n#115705, avg#115706, m2#115707, buf#115771, buf#115772]
(10) Exchange
Input [16]: [count#115763L, count#115764L, min#115765, max#115766, sum#115767, count#115768L, buf#115769, sum#115770, n#115697, avg#115698, m2#115699, n#115705, avg#115706, m2#115707, buf#115771, buf#115772]
Arguments: SinglePartition, ENSURE_REQUIREMENTS, [plan_id=8256]
(11) ObjectHashAggregate
Input [16]: [count#115763L, count#115764L, min#115765, max#115766, sum#115767, count#115768L, buf#115769, sum#115770, n#115697, avg#115698, m2#115699, n#115705, avg#115706, m2#115707, buf#115771, buf#115772]
Keys: []
Functions [11]: [count(1), count(CASE WHEN (NOT isnan(COL_COL_3FCABC8B_94D6_4907_A464_3800851C2E14#115566) AND isnotnull(COL_COL_3FCABC8B_94D6_4907_A464_3800851C2E14#115566)) THEN COL_COL_3FCABC8B_94D6_4907_A464_3800851C2E14 END), min(COL_COL_3FCABC8B_94D6_4907_A464_3800851C2E14#115566), max(COL_COL_3FCABC8B_94D6_4907_A464_3800851C2E14#115566), avg(COL_COL_3FCABC8B_94D6_4907_A464_3800851C2E14#115566), percentile_approx(COL_COL_3FCABC8B_94D6_4907_A464_3800851C2E14#115566, 0.5, 10000, 0, 0), sum(COL_COL_3FCABC8B_94D6_4907_A464_3800851C2E14#115566), var_samp(COL_COL_3FCABC8B_94D6_4907_A464_3800851C2E14#115566), stddev_pop(COL_COL_3FCABC8B_94D6_4907_A464_3800851C2E14#115566), percentile_approx(COL_COL_3FCABC8B_94D6_4907_A464_3800851C2E14#115566, 0.25, 10000, 0, 0), percentile_approx(COL_COL_3FCABC8B_94D6_4907_A464_3800851C2E14#115566, 0.75, 10000, 0, 0)]
Aggregate Attributes [11]: [count(1)#115623L, count(CASE WHEN (NOT isnan(COL_COL_3FCABC8B_94D6_4907_A464_3800851C2E14#115566) AND isnotnull(COL_COL_3FCABC8B_94D6_4907_A464_3800851C2E14#115566)) THEN COL_COL_3FCABC8B_94D6_4907_A464_3800851C2E14 END)#115626L, min(COL_COL_3FCABC8B_94D6_4907_A464_3800851C2E14#115566)#115628, max(COL_COL_3FCABC8B_94D6_4907_A464_3800851C2E14#115566)#115630, avg(COL_COL_3FCABC8B_94D6_4907_A464_3800851C2E14#115566)#115632, percentile_approx(COL_COL_3FCABC8B_94D6_4907_A464_3800851C2E14#115566, 0.5, 10000, 0, 0)#115708, sum(COL_COL_3FCABC8B_94D6_4907_A464_3800851C2E14#115566)#115635, var_samp(COL_COL_3FCABC8B_94D6_4907_A464_3800851C2E14#115566)#115645, stddev_pop(COL_COL_3FCABC8B_94D6_4907_A464_3800851C2E14#115566)#115655, percentile_approx(COL_COL_3FCABC8B_94D6_4907_A464_3800851C2E14#115566, 0.25, 10000, 0, 0)#115709, percentile_approx(COL_COL_3FCABC8B_94D6_4907_A464_3800851C2E14#115566, 0.75, 10000, 0, 0)#115711]
Results [12]: [count(1)#115623L AS COL_COL_3FCABC8B_94D6_4907_A464_3800851C2E141#115625L, count(CASE WHEN (NOT isnan(COL_COL_3FCABC8B_94D6_4907_A464_3800851C2E14#115566) AND isnotnull(COL_COL_3FCABC8B_94D6_4907_A464_3800851C2E14#115566)) THEN COL_COL_3FCABC8B_94D6_4907_A464_3800851C2E14 END)#115626L AS COL_COL_3FCABC8B_94D6_4907_A464_3800851C2E142#115627L, min(COL_COL_3FCABC8B_94D6_4907_A464_3800851C2E14#115566)#115628 AS COL_COL_3FCABC8B_94D6_4907_A464_3800851C2E144#115629, max(COL_COL_3FCABC8B_94D6_4907_A464_3800851C2E14#115566)#115630 AS COL_COL_3FCABC8B_94D6_4907_A464_3800851C2E145#115631, avg(COL_COL_3FCABC8B_94D6_4907_A464_3800851C2E14#115566)#115632 AS COL_COL_3FCABC8B_94D6_4907_A464_3800851C2E146#115633, percentile_approx(COL_COL_3FCABC8B_94D6_4907_A464_3800851C2E14#115566, 0.5, 10000, 0, 0)#115708 AS COL_COL_3FCABC8B_94D6_4907_A464_3800851C2E147#115634, sum(COL_COL_3FCABC8B_94D6_4907_A464_3800851C2E14#115566)#115635 AS COL_COL_3FCABC8B_94D6_4907_A464_3800851C2E148#115636, var_samp(COL_COL_3FCABC8B_94D6_4907_A464_3800851C2E14#115566)#115645 AS COL_COL_3FCABC8B_94D6_4907_A464_3800851C2E149#115646, stddev_pop(COL_COL_3FCABC8B_94D6_4907_A464_3800851C2E14#115566)#115655 AS COL_COL_3FCABC8B_94D6_4907_A464_3800851C2E1410#115656, percentile_approx(COL_COL_3FCABC8B_94D6_4907_A464_3800851C2E14#115566, 0.25, 10000, 0, 0)#115709 AS COL_COL_3FCABC8B_94D6_4907_A464_3800851C2E1411#115657, percentile_approx(COL_COL_3FCABC8B_94D6_4907_A464_3800851C2E14#115566, 0.5, 10000, 0, 0)#115708 AS COL_COL_3FCABC8B_94D6_4907_A464_3800851C2E1412#115658, percentile_approx(COL_COL_3FCABC8B_94D6_4907_A464_3800851C2E14#115566, 0.75, 10000, 0, 0)#115711 AS COL_COL_3FCABC8B_94D6_4907_A464_3800851C2E1413#115659]
(12) AdaptiveSparkPlan
Output [12]: [COL_COL_3FCABC8B_94D6_4907_A464_3800851C2E141#115625L, COL_COL_3FCABC8B_94D6_4907_A464_3800851C2E142#115627L, COL_COL_3FCABC8B_94D6_4907_A464_3800851C2E144#115629, COL_COL_3FCABC8B_94D6_4907_A464_3800851C2E145#115631, COL_COL_3FCABC8B_94D6_4907_A464_3800851C2E146#115633, COL_COL_3FCABC8B_94D6_4907_A464_3800851C2E147#115634, COL_COL_3FCABC8B_94D6_4907_A464_3800851C2E148#115636, COL_COL_3FCABC8B_94D6_4907_A464_3800851C2E149#115646, COL_COL_3FCABC8B_94D6_4907_A464_3800851C2E1410#115656, COL_COL_3FCABC8B_94D6_4907_A464_3800851C2E1411#115657, COL_COL_3FCABC8B_94D6_4907_A464_3800851C2E1412#115658, COL_COL_3FCABC8B_94D6_4907_A464_3800851C2E1413#115659]
Arguments: isFinalPlan=true