perfkitbenchmarker/data/edw/tpc_profile_details.py (3,107 lines of code) (raw):
"""The order of query templates in each query stream.
The order is determined by dsqgen. Details can be found at
http://www.tpc.org/tpc_documents_current_versions/current_specifications.asp
The order is the same for all scale factors.
"""
profile_dictionary = {
'tpc_ds_power': [
96,
7,
75,
44,
39,
80,
32,
19,
25,
78,
86,
1,
91,
21,
43,
27,
94,
45,
58,
64,
36,
33,
46,
62,
16,
10,
63,
69,
60,
59,
37,
98,
85,
70,
67,
28,
81,
97,
66,
90,
17,
47,
95,
92,
3,
51,
35,
49,
9,
31,
11,
93,
29,
38,
22,
89,
15,
6,
52,
50,
42,
41,
8,
12,
20,
88,
82,
23,
14,
57,
65,
71,
34,
48,
30,
74,
87,
77,
73,
84,
54,
55,
56,
2,
26,
40,
72,
53,
79,
18,
13,
24,
4,
99,
68,
83,
61,
5,
76,
],
'tpc_ds_throughput_1': [
83,
32,
30,
92,
66,
84,
98,
58,
16,
77,
40,
96,
13,
36,
95,
63,
99,
3,
6,
12,
28,
85,
51,
41,
27,
78,
8,
14,
50,
52,
81,
5,
26,
57,
82,
69,
54,
61,
88,
18,
94,
35,
68,
24,
75,
11,
67,
9,
25,
37,
86,
4,
60,
97,
33,
79,
43,
80,
93,
31,
47,
17,
19,
1,
64,
53,
55,
46,
21,
15,
20,
65,
70,
49,
59,
48,
72,
87,
34,
2,
38,
22,
89,
7,
10,
90,
71,
29,
73,
45,
91,
62,
44,
76,
23,
56,
42,
39,
74,
],
'tpc_ds_throughput_2': [
56,
98,
59,
24,
88,
2,
5,
6,
27,
87,
90,
83,
91,
28,
68,
8,
76,
75,
80,
1,
69,
26,
11,
17,
63,
77,
19,
21,
31,
93,
54,
39,
10,
15,
55,
14,
38,
42,
53,
45,
99,
67,
23,
62,
30,
86,
82,
25,
16,
81,
40,
44,
50,
61,
85,
73,
95,
84,
4,
37,
35,
94,
58,
96,
12,
29,
22,
51,
36,
43,
64,
20,
57,
9,
52,
49,
71,
72,
70,
7,
97,
33,
79,
32,
78,
18,
65,
60,
34,
3,
13,
41,
92,
74,
46,
89,
47,
66,
48,
],
'tpc_ds_throughput_3': [
89,
5,
52,
62,
53,
7,
39,
80,
63,
72,
18,
56,
13,
69,
23,
19,
74,
30,
84,
96,
14,
10,
86,
94,
8,
87,
58,
36,
37,
4,
38,
66,
78,
43,
22,
21,
97,
47,
29,
3,
76,
82,
46,
41,
59,
40,
55,
16,
27,
54,
90,
92,
31,
42,
26,
34,
68,
2,
44,
81,
67,
99,
6,
83,
1,
60,
33,
11,
28,
95,
12,
64,
15,
25,
93,
9,
65,
71,
57,
32,
61,
85,
73,
98,
77,
45,
20,
50,
70,
75,
91,
17,
24,
48,
51,
79,
35,
88,
49,
],
'tpc_ds_throughput_4': [
79,
39,
93,
41,
29,
32,
66,
84,
8,
71,
45,
89,
91,
14,
46,
58,
48,
59,
2,
83,
21,
78,
40,
99,
19,
72,
6,
28,
81,
44,
97,
88,
77,
95,
33,
36,
61,
35,
60,
75,
74,
55,
51,
17,
52,
90,
22,
27,
63,
38,
18,
24,
37,
47,
10,
70,
23,
7,
92,
54,
82,
76,
80,
56,
96,
50,
85,
86,
69,
68,
1,
12,
43,
16,
4,
25,
20,
65,
15,
98,
42,
26,
34,
5,
87,
3,
64,
31,
57,
30,
13,
94,
62,
49,
11,
73,
67,
53,
9,
],
'tpc_ds_throughput_5': [
73,
66,
4,
17,
60,
98,
88,
2,
19,
65,
3,
79,
13,
21,
51,
6,
49,
52,
7,
56,
36,
77,
90,
76,
58,
71,
80,
69,
54,
92,
61,
53,
87,
68,
85,
28,
42,
67,
50,
30,
48,
22,
11,
94,
93,
18,
33,
63,
8,
97,
45,
62,
81,
35,
78,
57,
46,
32,
24,
38,
55,
74,
84,
89,
83,
31,
26,
40,
14,
23,
96,
1,
95,
27,
44,
16,
64,
20,
43,
5,
47,
10,
70,
39,
72,
75,
12,
37,
15,
59,
91,
99,
41,
9,
86,
34,
82,
29,
25,
],
'tpc_ds_throughput_6': [
34,
88,
44,
94,
50,
5,
53,
7,
58,
20,
75,
73,
91,
36,
11,
80,
9,
93,
32,
89,
28,
87,
18,
74,
6,
65,
84,
14,
38,
24,
42,
29,
72,
23,
26,
69,
47,
82,
31,
59,
49,
33,
86,
99,
4,
45,
85,
8,
19,
61,
3,
41,
54,
67,
77,
15,
51,
98,
62,
97,
22,
48,
2,
79,
56,
37,
10,
90,
21,
46,
83,
96,
68,
63,
92,
27,
12,
64,
95,
39,
35,
78,
57,
66,
71,
30,
1,
81,
43,
52,
13,
76,
17,
25,
40,
70,
55,
60,
16,
],
'tpc_ds_throughput_7': [
70,
53,
92,
99,
31,
39,
29,
32,
6,
64,
30,
34,
13,
28,
86,
84,
25,
4,
98,
79,
69,
72,
45,
48,
80,
20,
2,
21,
97,
62,
47,
60,
71,
46,
10,
14,
35,
55,
37,
52,
9,
85,
40,
76,
44,
3,
26,
19,
58,
42,
75,
17,
38,
82,
87,
43,
11,
5,
41,
61,
33,
49,
7,
73,
89,
81,
78,
18,
36,
51,
56,
83,
23,
8,
24,
63,
1,
12,
68,
66,
67,
77,
15,
88,
65,
59,
96,
54,
95,
93,
91,
74,
94,
16,
90,
57,
22,
50,
27,
],
'tpc_ds_throughput_8': [
57,
29,
24,
76,
37,
66,
60,
98,
80,
12,
59,
70,
91,
69,
40,
2,
16,
44,
5,
73,
14,
71,
3,
49,
84,
64,
7,
36,
61,
41,
35,
50,
65,
51,
78,
21,
67,
22,
81,
93,
25,
26,
90,
74,
92,
75,
10,
58,
6,
47,
30,
94,
97,
55,
72,
95,
86,
39,
17,
42,
85,
9,
32,
34,
79,
54,
77,
45,
28,
11,
89,
56,
46,
19,
62,
8,
96,
1,
23,
88,
82,
87,
43,
53,
20,
52,
83,
38,
68,
4,
13,
48,
99,
27,
18,
15,
33,
31,
63,
],
'tpc_ds_throughput_9': [
15,
60,
62,
74,
81,
88,
50,
5,
84,
1,
52,
57,
13,
14,
90,
7,
27,
92,
39,
34,
21,
65,
75,
9,
2,
12,
32,
28,
42,
17,
67,
31,
20,
11,
77,
36,
82,
33,
54,
4,
16,
10,
18,
48,
24,
30,
78,
6,
80,
35,
59,
99,
61,
22,
71,
68,
40,
66,
94,
47,
26,
25,
98,
70,
73,
38,
87,
3,
69,
86,
79,
89,
51,
58,
41,
19,
83,
96,
46,
53,
55,
72,
95,
29,
64,
93,
56,
97,
23,
44,
91,
49,
76,
63,
45,
43,
85,
37,
8,
],
'tpc_ds_throughput_10': [
43,
50,
41,
48,
54,
53,
31,
39,
2,
96,
93,
15,
91,
21,
18,
32,
63,
24,
66,
70,
36,
20,
30,
25,
7,
1,
98,
69,
47,
94,
82,
37,
64,
86,
87,
28,
55,
85,
38,
44,
27,
78,
45,
49,
62,
59,
77,
80,
84,
67,
52,
76,
42,
33,
65,
23,
90,
88,
99,
35,
10,
16,
5,
57,
34,
97,
72,
75,
14,
40,
73,
79,
11,
6,
17,
58,
56,
83,
51,
29,
22,
71,
68,
60,
12,
4,
89,
61,
46,
92,
13,
9,
74,
8,
3,
95,
26,
81,
19,
],
'tpc_ds_throughput_11': [
95,
31,
17,
49,
38,
29,
37,
66,
7,
83,
4,
43,
13,
36,
45,
98,
8,
62,
88,
57,
28,
64,
59,
16,
32,
96,
5,
14,
35,
99,
55,
81,
12,
40,
72,
69,
22,
26,
97,
92,
63,
77,
3,
9,
41,
52,
87,
84,
2,
82,
93,
74,
47,
85,
20,
46,
18,
53,
76,
67,
78,
27,
39,
15,
70,
61,
71,
30,
21,
90,
34,
73,
86,
80,
94,
6,
89,
56,
11,
60,
33,
65,
23,
50,
1,
44,
79,
42,
51,
24,
91,
25,
48,
19,
75,
68,
10,
54,
58,
],
'tpc_ds_throughput_12': [
68,
37,
94,
9,
97,
60,
81,
88,
32,
56,
44,
95,
91,
28,
3,
5,
19,
41,
53,
15,
69,
12,
52,
27,
98,
83,
39,
21,
67,
76,
22,
54,
1,
90,
71,
14,
33,
10,
61,
24,
8,
87,
75,
25,
17,
93,
72,
2,
7,
55,
4,
48,
35,
26,
64,
51,
45,
29,
74,
82,
77,
63,
66,
43,
57,
42,
65,
59,
36,
18,
70,
34,
40,
84,
99,
80,
79,
89,
86,
50,
85,
20,
46,
31,
96,
92,
73,
47,
11,
62,
13,
16,
49,
58,
30,
23,
78,
38,
6,
],
'tpc_ds_throughput_13': [
23,
81,
99,
25,
61,
50,
54,
53,
98,
89,
92,
68,
13,
69,
75,
39,
58,
17,
29,
43,
14,
1,
93,
63,
5,
56,
66,
36,
82,
74,
33,
38,
96,
18,
65,
21,
85,
78,
42,
62,
19,
72,
30,
16,
94,
4,
71,
7,
32,
22,
44,
49,
67,
10,
12,
11,
3,
60,
48,
55,
87,
8,
88,
95,
15,
47,
20,
52,
28,
45,
57,
70,
90,
2,
76,
84,
73,
79,
40,
31,
26,
64,
51,
37,
83,
24,
34,
35,
86,
41,
91,
27,
9,
6,
59,
46,
77,
97,
80,
],
'tpc_ds_throughput_14': [
46,
54,
76,
16,
42,
31,
38,
29,
5,
79,
24,
23,
91,
14,
30,
66,
6,
94,
60,
95,
21,
96,
4,
8,
39,
89,
88,
28,
55,
48,
85,
97,
83,
45,
20,
36,
26,
77,
47,
41,
58,
71,
59,
27,
99,
44,
65,
32,
98,
33,
92,
9,
82,
78,
1,
86,
75,
50,
49,
22,
72,
19,
53,
68,
43,
35,
64,
93,
69,
3,
15,
57,
18,
7,
74,
2,
34,
73,
90,
37,
10,
12,
11,
81,
56,
62,
70,
67,
40,
17,
13,
63,
25,
80,
52,
51,
87,
61,
84,
],
'tpc_ds_throughput_15': [
51,
38,
74,
27,
47,
37,
97,
60,
39,
73,
62,
46,
13,
21,
59,
88,
80,
99,
50,
68,
36,
83,
44,
19,
66,
79,
53,
69,
22,
49,
26,
61,
56,
3,
64,
28,
10,
87,
35,
17,
6,
65,
52,
63,
76,
92,
20,
98,
5,
85,
24,
25,
55,
77,
96,
40,
30,
31,
9,
33,
71,
58,
29,
23,
95,
67,
12,
4,
14,
75,
43,
15,
45,
32,
48,
7,
70,
34,
18,
81,
78,
1,
86,
54,
89,
41,
57,
82,
90,
94,
91,
8,
16,
84,
93,
11,
72,
42,
2,
],
'tpc_ds_throughput_16': [
11,
97,
48,
63,
35,
81,
61,
50,
66,
34,
41,
51,
91,
36,
52,
53,
84,
76,
31,
23,
28,
56,
92,
58,
88,
73,
29,
14,
33,
9,
10,
42,
89,
75,
12,
69,
78,
72,
67,
94,
80,
20,
93,
8,
74,
24,
64,
5,
39,
26,
62,
16,
22,
87,
83,
90,
59,
37,
25,
85,
65,
6,
60,
46,
68,
82,
1,
44,
21,
30,
95,
43,
3,
98,
49,
32,
57,
70,
45,
54,
77,
96,
40,
38,
79,
17,
15,
55,
18,
99,
13,
19,
27,
2,
4,
86,
71,
47,
7,
],
'tpc_ds_throughput_17': [
86,
61,
49,
8,
67,
54,
42,
31,
88,
70,
17,
11,
13,
28,
93,
29,
2,
74,
37,
46,
69,
89,
24,
6,
53,
34,
60,
21,
85,
25,
78,
47,
79,
30,
1,
14,
77,
71,
82,
99,
84,
64,
4,
19,
48,
62,
12,
39,
66,
10,
41,
27,
33,
72,
56,
18,
52,
81,
16,
26,
20,
80,
50,
51,
23,
55,
96,
92,
36,
59,
68,
95,
75,
5,
9,
98,
15,
57,
3,
38,
87,
83,
90,
97,
73,
94,
43,
22,
45,
76,
91,
58,
63,
7,
44,
40,
65,
35,
32,
],
'tpc_ds_throughput_18': [
40,
42,
9,
19,
82,
38,
47,
37,
53,
57,
94,
86,
91,
69,
4,
60,
7,
48,
81,
51,
14,
79,
62,
80,
29,
70,
50,
36,
26,
16,
77,
35,
73,
59,
96,
21,
87,
65,
55,
76,
2,
12,
44,
58,
49,
41,
1,
66,
88,
78,
17,
63,
85,
71,
89,
45,
93,
54,
27,
10,
64,
84,
31,
11,
46,
22,
83,
24,
28,
52,
23,
68,
30,
39,
25,
5,
43,
15,
75,
97,
72,
56,
18,
61,
34,
99,
95,
33,
3,
74,
13,
6,
8,
32,
92,
90,
20,
67,
98,
],
'tpc_ds_throughput_19': [
90,
47,
25,
58,
55,
97,
35,
81,
29,
15,
99,
40,
13,
14,
44,
50,
32,
49,
54,
11,
21,
73,
41,
84,
60,
57,
31,
28,
10,
27,
87,
67,
34,
52,
83,
36,
72,
20,
22,
74,
7,
1,
92,
6,
9,
17,
96,
88,
53,
77,
94,
8,
26,
65,
79,
3,
4,
38,
63,
78,
12,
2,
37,
86,
51,
33,
56,
62,
69,
93,
46,
23,
59,
66,
16,
39,
95,
43,
30,
61,
71,
89,
45,
42,
70,
76,
68,
85,
75,
48,
91,
80,
19,
98,
24,
18,
64,
82,
5,
],
'tpc_ds_throughput_20': [
18,
35,
16,
6,
22,
61,
67,
54,
60,
43,
76,
90,
91,
21,
92,
31,
98,
9,
38,
86,
36,
34,
17,
2,
50,
15,
37,
69,
78,
63,
72,
82,
70,
93,
56,
28,
71,
64,
33,
48,
32,
96,
24,
80,
25,
94,
83,
53,
29,
87,
99,
19,
10,
20,
73,
75,
44,
97,
8,
77,
1,
7,
81,
40,
11,
85,
89,
41,
14,
4,
51,
46,
52,
88,
27,
66,
68,
95,
59,
42,
65,
79,
3,
47,
57,
74,
23,
26,
30,
49,
13,
84,
58,
5,
62,
45,
12,
55,
39,
],
'tpc_h_power': [
14,
2,
9,
20,
6,
17,
18,
8,
21,
13,
3,
22,
16,
4,
11,
15,
1,
10,
19,
5,
7,
12,
],
'tpc_h_throughput_1': [
21,
3,
18,
5,
11,
7,
6,
20,
17,
12,
16,
15,
13,
10,
2,
8,
14,
19,
9,
22,
1,
4,
],
'tpc_h_throughput_2': [
6,
17,
14,
16,
19,
10,
9,
2,
15,
8,
5,
22,
12,
7,
13,
18,
1,
4,
20,
3,
11,
21,
],
'tpc_h_throughput_3': [
8,
5,
4,
6,
17,
7,
1,
18,
22,
14,
9,
10,
15,
11,
20,
2,
21,
19,
13,
16,
12,
3,
],
'tpc_h_throughput_4': [
5,
21,
14,
19,
15,
17,
12,
6,
4,
9,
8,
16,
11,
2,
10,
18,
1,
13,
7,
22,
3,
20,
],
'tpc_h_throughput_5': [
21,
15,
4,
6,
7,
16,
19,
18,
14,
22,
11,
13,
3,
1,
2,
5,
8,
20,
12,
17,
10,
9,
],
'tpc_h_throughput_6': [
10,
3,
15,
13,
6,
8,
9,
7,
4,
11,
22,
18,
12,
1,
5,
16,
2,
14,
19,
20,
17,
21,
],
'tpc_h_throughput_7': [
18,
8,
20,
21,
2,
4,
22,
17,
1,
11,
9,
19,
3,
13,
5,
7,
10,
16,
6,
14,
15,
12,
],
'tpc_h_throughput_8': [
19,
1,
15,
17,
5,
8,
9,
12,
14,
7,
4,
3,
20,
16,
6,
22,
10,
13,
2,
21,
18,
11,
],
'tpc_h_throughput_9': [
8,
13,
2,
20,
17,
3,
6,
21,
18,
11,
19,
10,
15,
4,
22,
1,
7,
12,
9,
14,
5,
16,
],
'tpc_h_throughput_10': [
6,
15,
18,
17,
12,
1,
7,
2,
22,
13,
21,
10,
14,
9,
3,
16,
20,
19,
11,
4,
8,
5,
],
'tpc_h_throughput_11': [
15,
14,
18,
17,
10,
20,
16,
11,
1,
8,
4,
22,
5,
12,
3,
9,
21,
2,
13,
6,
19,
7,
],
'tpc_h_throughput_12': [
1,
7,
16,
17,
18,
22,
12,
6,
8,
9,
11,
4,
2,
5,
20,
21,
13,
10,
19,
3,
14,
15,
],
'tpc_h_throughput_13': [
21,
17,
7,
3,
1,
10,
12,
22,
9,
16,
6,
11,
2,
4,
5,
14,
8,
20,
13,
18,
15,
19,
],
'tpc_h_throughput_14': [
2,
9,
5,
4,
18,
1,
20,
15,
16,
17,
7,
21,
13,
14,
19,
8,
22,
11,
10,
3,
12,
6,
],
'tpc_h_throughput_15': [
16,
9,
17,
8,
14,
11,
10,
12,
6,
21,
7,
3,
15,
5,
22,
20,
1,
13,
19,
2,
4,
18,
],
'tpc_h_throughput_16': [
1,
3,
6,
5,
2,
16,
14,
22,
17,
20,
4,
9,
10,
11,
15,
8,
12,
19,
18,
13,
7,
21,
],
'tpc_h_throughput_17': [
3,
16,
5,
11,
21,
9,
2,
15,
10,
18,
17,
7,
8,
19,
14,
13,
1,
4,
22,
20,
6,
12,
],
'tpc_h_throughput_18': [
14,
4,
13,
5,
21,
11,
8,
6,
3,
17,
2,
20,
1,
19,
10,
9,
12,
18,
15,
7,
22,
16,
],
'tpc_h_throughput_19': [
4,
12,
22,
14,
5,
15,
16,
2,
8,
10,
17,
9,
21,
7,
3,
6,
13,
18,
11,
20,
19,
1,
],
'tpc_h_throughput_20': [
16,
15,
14,
13,
4,
22,
18,
19,
7,
1,
12,
17,
5,
10,
20,
3,
9,
21,
11,
2,
6,
8,
],
'tpc_h_throughput_21': [
20,
14,
21,
12,
15,
17,
4,
19,
13,
10,
11,
1,
16,
5,
18,
7,
8,
22,
9,
6,
3,
2,
],
'tpc_h_throughput_22': [
16,
14,
13,
2,
21,
10,
11,
4,
1,
22,
18,
12,
19,
5,
7,
8,
6,
3,
15,
20,
9,
17,
],
'tpc_h_throughput_23': [
18,
15,
9,
14,
12,
2,
8,
11,
22,
21,
16,
1,
6,
17,
5,
10,
19,
4,
20,
13,
3,
7,
],
'tpc_h_throughput_24': [
7,
3,
10,
14,
13,
21,
18,
6,
20,
4,
9,
8,
22,
15,
2,
1,
5,
12,
19,
17,
11,
16,
],
'tpc_h_throughput_25': [
18,
1,
13,
7,
16,
10,
14,
2,
19,
5,
21,
11,
22,
15,
8,
17,
20,
3,
4,
12,
6,
9,
],
'tpc_h_throughput_26': [
13,
2,
22,
5,
11,
21,
20,
14,
7,
10,
4,
9,
19,
18,
6,
3,
1,
8,
15,
12,
17,
16,
],
'tpc_h_throughput_27': [
14,
17,
21,
8,
2,
9,
6,
4,
5,
13,
22,
7,
15,
3,
1,
18,
16,
11,
10,
12,
20,
19,
],
'tpc_h_throughput_28': [
10,
22,
1,
12,
13,
18,
21,
20,
2,
14,
16,
7,
15,
3,
4,
17,
5,
19,
6,
8,
9,
11,
],
'tpc_h_throughput_29': [
10,
8,
9,
18,
12,
6,
1,
5,
20,
11,
17,
22,
16,
3,
13,
2,
15,
21,
14,
19,
7,
4,
],
'tpc_h_throughput_30': [
7,
17,
22,
5,
3,
10,
13,
18,
9,
1,
14,
15,
21,
19,
16,
12,
8,
6,
11,
20,
4,
2,
],
'tpc_h_throughput_31': [
2,
9,
21,
3,
4,
7,
1,
11,
16,
5,
20,
19,
18,
8,
17,
13,
10,
12,
15,
6,
14,
22,
],
'tpc_h_throughput_32': [
15,
12,
8,
4,
22,
13,
16,
17,
18,
3,
7,
5,
6,
1,
9,
11,
21,
10,
14,
20,
19,
2,
],
'tpc_h_throughput_33': [
15,
16,
2,
11,
17,
7,
5,
14,
20,
4,
21,
3,
10,
9,
12,
8,
13,
6,
18,
19,
22,
1,
],
'tpc_h_throughput_34': [
1,
13,
11,
3,
4,
21,
6,
14,
15,
22,
18,
9,
7,
5,
10,
20,
12,
16,
17,
8,
19,
2,
],
'tpc_h_throughput_35': [
14,
17,
22,
20,
8,
16,
5,
10,
1,
13,
2,
21,
12,
9,
4,
18,
3,
7,
6,
19,
15,
11,
],
'tpc_h_throughput_36': [
9,
17,
7,
4,
5,
13,
21,
18,
11,
3,
22,
1,
6,
16,
20,
14,
15,
10,
8,
2,
12,
19,
],
'tpc_h_throughput_37': [
13,
14,
5,
22,
19,
11,
9,
6,
18,
15,
8,
10,
7,
4,
17,
16,
3,
1,
12,
2,
21,
20,
],
'tpc_h_throughput_38': [
20,
5,
4,
14,
11,
1,
6,
16,
8,
22,
7,
3,
2,
12,
21,
19,
17,
13,
10,
15,
18,
9,
],
'tpc_h_throughput_39': [
3,
7,
14,
15,
6,
5,
21,
20,
18,
10,
4,
16,
19,
1,
13,
9,
8,
17,
11,
12,
22,
2,
],
'tpc_h_throughput_40': [
13,
15,
17,
1,
22,
11,
3,
4,
7,
20,
14,
21,
9,
8,
2,
18,
16,
6,
10,
12,
5,
19,
],
}