-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathtest.txt
More file actions
30 lines (30 loc) · 834 Bytes
/
test.txt
File metadata and controls
30 lines (30 loc) · 834 Bytes
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
R := inputfromfile(sales1)
R1 := select(R, (time > 50) or (qty < 30))
R2 := project(R1, saleid, qty, pricerange)
R3 := avg(R1, qty)
R4 := sumgroup(R1, time, qty)
R5 := sumgroup(R1, qty, time, pricerange)
R6 := avggroup(R1, qty, pricerange)
S := inputfromfile(sales2)
Hash(R,customerid)
T := join(R, S, R.customerid = S.C)
Hash(R1,saleid)
T1 := join(R1, S, R1.saleid = S.saleid)
T2 := sort(T1, S_C)
T2prime := sort(T1, R1_time, S_C)
T3 := movavg(T2prime, R1_qty, 3)
T4 := movsum(T2prime, R1_qty, 5)
Q1 := select(R, qty = 5)
Btree(R, qty)
Q2 := select(R, qty = 5)
Q3 := select(R, itemid = 7)
Hash(R,itemid)
Q4 := select(R, itemid = 7)
Q5 := concat(Q4, Q2)
C1 := count(R1, qty)
C2 := countgroup(R1, time, qty)
C3 := countgroup(R1, qty, time, pricerange)
outputtofile(Q1, Q1)
outputtofile(C1, C1)
outputtofile(R1, R1)
outputtofile(R6, R6)