/
q35.sql.out
105 lines (104 loc) · 4.9 KB
/
q35.sql.out
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
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
-- Automatically generated by TPCDSQueryTestSuite
-- !query schema
struct<ca_state:string,cd_gender:string,cd_marital_status:string,cd_dep_count:int,cnt1:bigint,avg(cd_dep_count):double,max(cd_dep_count):int,sum(cd_dep_count):bigint,cd_dep_employed_count:int,cnt2:bigint,avg(cd_dep_employed_count):double,max(cd_dep_employed_count):int,sum(cd_dep_employed_count):bigint,cd_dep_college_count:int,cnt3:bigint,avg(cd_dep_college_count):double,max(cd_dep_college_count):int,sum(cd_dep_college_count):bigint>
-- !query output
NULL F D 0 1 0.0 0 0 1 1 1.0 1 1 2 1 2.0 2 2
NULL F D 0 1 0.0 0 0 3 1 3.0 3 3 0 1 0.0 0 0
NULL F D 0 1 0.0 0 0 5 1 5.0 5 5 0 1 0.0 0 0
NULL F D 0 1 0.0 0 0 6 1 6.0 6 6 0 1 0.0 0 0
NULL F D 1 1 1.0 1 1 1 1 1.0 1 1 1 1 1.0 1 1
NULL F D 1 1 1.0 1 1 5 1 5.0 5 5 3 1 3.0 3 3
NULL F D 3 1 3.0 3 3 0 1 0.0 0 0 5 1 5.0 5 5
NULL F D 3 1 3.0 3 3 1 1 1.0 1 1 3 1 3.0 3 3
NULL F D 3 1 3.0 3 3 5 1 5.0 5 5 4 1 4.0 4 4
NULL F D 4 1 4.0 4 4 2 1 2.0 2 2 5 1 5.0 5 5
NULL F D 4 1 4.0 4 4 4 1 4.0 4 4 4 1 4.0 4 4
NULL F D 6 1 6.0 6 6 0 1 0.0 0 0 6 1 6.0 6 6
NULL F D 6 1 6.0 6 6 5 1 5.0 5 5 4 1 4.0 4 4
NULL F M 0 1 0.0 0 0 0 1 0.0 0 0 3 1 3.0 3 3
NULL F M 0 1 0.0 0 0 3 1 3.0 3 3 6 1 6.0 6 6
NULL F M 1 2 1.0 1 2 1 2 1.0 1 2 0 2 0.0 0 0
NULL F M 1 1 1.0 1 1 2 1 2.0 2 2 4 1 4.0 4 4
NULL F M 1 1 1.0 1 1 3 1 3.0 3 3 3 1 3.0 3 3
NULL F M 1 1 1.0 1 1 4 1 4.0 4 4 2 1 2.0 2 2
NULL F M 1 1 1.0 1 1 6 1 6.0 6 6 2 1 2.0 2 2
NULL F M 2 1 2.0 2 2 1 1 1.0 1 1 0 1 0.0 0 0
NULL F M 2 1 2.0 2 2 5 1 5.0 5 5 4 1 4.0 4 4
NULL F M 3 1 3.0 3 3 0 1 0.0 0 0 4 1 4.0 4 4
NULL F M 4 1 4.0 4 4 2 1 2.0 2 2 1 1 1.0 1 1
NULL F M 4 1 4.0 4 4 4 1 4.0 4 4 1 1 1.0 1 1
NULL F M 5 1 5.0 5 5 1 1 1.0 1 1 2 1 2.0 2 2
NULL F M 5 1 5.0 5 5 3 1 3.0 3 3 3 1 3.0 3 3
NULL F M 6 1 6.0 6 6 2 1 2.0 2 2 2 1 2.0 2 2
NULL F M 6 1 6.0 6 6 2 1 2.0 2 2 3 1 3.0 3 3
NULL F M 6 1 6.0 6 6 3 1 3.0 3 3 4 1 4.0 4 4
NULL F M 6 1 6.0 6 6 5 1 5.0 5 5 1 1 1.0 1 1
NULL F S 0 1 0.0 0 0 0 1 0.0 0 0 3 1 3.0 3 3
NULL F S 0 1 0.0 0 0 2 1 2.0 2 2 3 1 3.0 3 3
NULL F S 0 1 0.0 0 0 3 1 3.0 3 3 6 1 6.0 6 6
NULL F S 0 1 0.0 0 0 4 1 4.0 4 4 5 1 5.0 5 5
NULL F S 1 1 1.0 1 1 0 1 0.0 0 0 3 1 3.0 3 3
NULL F S 1 1 1.0 1 1 3 1 3.0 3 3 4 1 4.0 4 4
NULL F S 1 1 1.0 1 1 4 1 4.0 4 4 0 1 0.0 0 0
NULL F S 1 1 1.0 1 1 4 1 4.0 4 4 4 1 4.0 4 4
NULL F S 1 1 1.0 1 1 5 1 5.0 5 5 0 1 0.0 0 0
NULL F S 2 1 2.0 2 2 0 1 0.0 0 0 3 1 3.0 3 3
NULL F S 2 1 2.0 2 2 1 1 1.0 1 1 6 1 6.0 6 6
NULL F S 2 1 2.0 2 2 2 1 2.0 2 2 2 1 2.0 2 2
NULL F S 2 1 2.0 2 2 4 1 4.0 4 4 6 1 6.0 6 6
NULL F S 2 1 2.0 2 2 6 1 6.0 6 6 1 1 1.0 1 1
NULL F S 2 1 2.0 2 2 6 1 6.0 6 6 5 1 5.0 5 5
NULL F S 3 1 3.0 3 3 1 1 1.0 1 1 0 1 0.0 0 0
NULL F S 3 1 3.0 3 3 1 1 1.0 1 1 2 1 2.0 2 2
NULL F S 3 1 3.0 3 3 3 1 3.0 3 3 0 1 0.0 0 0
NULL F S 3 1 3.0 3 3 4 1 4.0 4 4 6 1 6.0 6 6
NULL F S 3 1 3.0 3 3 6 1 6.0 6 6 6 1 6.0 6 6
NULL F S 4 1 4.0 4 4 0 1 0.0 0 0 2 1 2.0 2 2
NULL F S 5 1 5.0 5 5 4 1 4.0 4 4 2 1 2.0 2 2
NULL F S 5 1 5.0 5 5 6 1 6.0 6 6 6 1 6.0 6 6
NULL F S 6 1 6.0 6 6 0 1 0.0 0 0 0 1 0.0 0 0
NULL F S 6 1 6.0 6 6 0 1 0.0 0 0 2 1 2.0 2 2
NULL F S 6 1 6.0 6 6 4 1 4.0 4 4 5 1 5.0 5 5
NULL F U 0 1 0.0 0 0 4 1 4.0 4 4 1 1 1.0 1 1
NULL F U 0 1 0.0 0 0 5 1 5.0 5 5 1 1 1.0 1 1
NULL F U 0 1 0.0 0 0 6 1 6.0 6 6 6 1 6.0 6 6
NULL F U 1 1 1.0 1 1 5 1 5.0 5 5 2 1 2.0 2 2
NULL F U 2 1 2.0 2 2 4 1 4.0 4 4 4 1 4.0 4 4
NULL F U 3 1 3.0 3 3 1 1 1.0 1 1 6 1 6.0 6 6
NULL F U 3 1 3.0 3 3 3 1 3.0 3 3 6 1 6.0 6 6
NULL F U 3 1 3.0 3 3 4 1 4.0 4 4 3 1 3.0 3 3
NULL F U 3 1 3.0 3 3 5 1 5.0 5 5 1 1 1.0 1 1
NULL F U 3 1 3.0 3 3 6 1 6.0 6 6 0 1 0.0 0 0
NULL F U 3 1 3.0 3 3 6 1 6.0 6 6 3 1 3.0 3 3
NULL F U 6 1 6.0 6 6 1 1 1.0 1 1 3 1 3.0 3 3
NULL F U 6 1 6.0 6 6 2 1 2.0 2 2 1 1 1.0 1 1
NULL F U 6 1 6.0 6 6 5 1 5.0 5 5 6 1 6.0 6 6
NULL F W 0 1 0.0 0 0 2 1 2.0 2 2 4 1 4.0 4 4
NULL F W 0 1 0.0 0 0 6 1 6.0 6 6 2 1 2.0 2 2
NULL F W 2 1 2.0 2 2 5 1 5.0 5 5 1 1 1.0 1 1
NULL F W 4 1 4.0 4 4 0 1 0.0 0 0 4 1 4.0 4 4
NULL F W 4 1 4.0 4 4 1 1 1.0 1 1 1 1 1.0 1 1
NULL F W 4 1 4.0 4 4 2 1 2.0 2 2 6 1 6.0 6 6
NULL F W 4 1 4.0 4 4 4 1 4.0 4 4 3 1 3.0 3 3
NULL F W 5 1 5.0 5 5 6 1 6.0 6 6 1 1 1.0 1 1
NULL F W 6 1 6.0 6 6 2 1 2.0 2 2 6 1 6.0 6 6
NULL F W 6 1 6.0 6 6 3 1 3.0 3 3 4 1 4.0 4 4
NULL F W 6 1 6.0 6 6 4 1 4.0 4 4 0 1 0.0 0 0
NULL F W 6 1 6.0 6 6 5 1 5.0 5 5 6 1 6.0 6 6
NULL M D 1 1 1.0 1 1 5 1 5.0 5 5 6 1 6.0 6 6
NULL M D 2 1 2.0 2 2 3 1 3.0 3 3 3 1 3.0 3 3
NULL M D 2 1 2.0 2 2 6 1 6.0 6 6 1 1 1.0 1 1
NULL M D 2 1 2.0 2 2 6 1 6.0 6 6 6 1 6.0 6 6
NULL M D 3 1 3.0 3 3 5 1 5.0 5 5 4 1 4.0 4 4
NULL M D 3 1 3.0 3 3 6 1 6.0 6 6 6 1 6.0 6 6
NULL M D 4 1 4.0 4 4 5 1 5.0 5 5 5 1 5.0 5 5
NULL M D 6 1 6.0 6 6 1 1 1.0 1 1 1 1 1.0 1 1
NULL M D 6 1 6.0 6 6 2 1 2.0 2 2 5 1 5.0 5 5
NULL M D 6 1 6.0 6 6 4 1 4.0 4 4 3 1 3.0 3 3
NULL M D 6 1 6.0 6 6 4 1 4.0 4 4 4 1 4.0 4 4
NULL M M 0 1 0.0 0 0 0 1 0.0 0 0 2 1 2.0 2 2
NULL M M 0 1 0.0 0 0 1 1 1.0 1 1 6 1 6.0 6 6
NULL M M 0 1 0.0 0 0 2 1 2.0 2 2 0 1 0.0 0 0
NULL M M 0 1 0.0 0 0 6 1 6.0 6 6 1 1 1.0 1 1
NULL M M 0 1 0.0 0 0 6 1 6.0 6 6 2 1 2.0 2 2
NULL M M 1 1 1.0 1 1 1 1 1.0 1 1 6 1 6.0 6 6