1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
|
/*
* Licensed to the Apache Software Foundation (ASF) under one or more
* contributor license agreements. See the NOTICE file distributed with
* this work for additional information regarding copyright ownership.
* The ASF licenses this file to You under the Apache License, Version 2.0
* (the "License"); you may not use this file except in compliance with
* the License. You may obtain a copy of the License at
*
* http://www.apache.org/licenses/LICENSE-2.0
*
* Unless required by applicable law or agreed to in writing, software
* distributed under the License is distributed on an "AS IS" BASIS,
* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
* See the License for the specific language governing permissions and
* limitations under the License.
*/
package org.apache.spark.sql.catalyst.optimizer
import org.apache.spark.sql.catalyst.dsl.expressions._
import org.apache.spark.sql.catalyst.dsl.plans._
import org.apache.spark.sql.catalyst.plans.PlanTest
import org.apache.spark.sql.catalyst.plans.logical.{LocalRelation, LogicalPlan}
import org.apache.spark.sql.catalyst.rules.RuleExecutor
class CollapseWindowSuite extends PlanTest {
object Optimize extends RuleExecutor[LogicalPlan] {
val batches =
Batch("CollapseWindow", FixedPoint(10),
CollapseWindow) :: Nil
}
val testRelation = LocalRelation('a.double, 'b.double, 'c.string)
val a = testRelation.output(0)
val b = testRelation.output(1)
val c = testRelation.output(2)
val partitionSpec1 = Seq(c)
val partitionSpec2 = Seq(c + 1)
val orderSpec1 = Seq(c.asc)
val orderSpec2 = Seq(c.desc)
test("collapse two adjacent windows with the same partition/order") {
val query = testRelation
.window(Seq(min(a).as('min_a)), partitionSpec1, orderSpec1)
.window(Seq(max(a).as('max_a)), partitionSpec1, orderSpec1)
.window(Seq(sum(b).as('sum_b)), partitionSpec1, orderSpec1)
.window(Seq(avg(b).as('avg_b)), partitionSpec1, orderSpec1)
val optimized = Optimize.execute(query.analyze)
val correctAnswer = testRelation.window(Seq(
avg(b).as('avg_b),
sum(b).as('sum_b),
max(a).as('max_a),
min(a).as('min_a)), partitionSpec1, orderSpec1)
comparePlans(optimized, correctAnswer)
}
test("Don't collapse adjacent windows with different partitions or orders") {
val query1 = testRelation
.window(Seq(min(a).as('min_a)), partitionSpec1, orderSpec1)
.window(Seq(max(a).as('max_a)), partitionSpec1, orderSpec2)
val optimized1 = Optimize.execute(query1.analyze)
val correctAnswer1 = query1.analyze
comparePlans(optimized1, correctAnswer1)
val query2 = testRelation
.window(Seq(min(a).as('min_a)), partitionSpec1, orderSpec1)
.window(Seq(max(a).as('max_a)), partitionSpec2, orderSpec1)
val optimized2 = Optimize.execute(query2.analyze)
val correctAnswer2 = query2.analyze
comparePlans(optimized2, correctAnswer2)
}
}
|