forked from zssky/prom2click
-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathschema.sql
102 lines (89 loc) · 3.62 KB
/
schema.sql
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
# note:REPLACE {shard} AND {REPLICA} AND run ON EACH SERVER
// LOCAL test TABLE ON ubuntu ..
CREATE TABLE metrics.samples (
ip STRING DEFAULT 'default',
app STRING DEFAULT 'x',
name STRING DEFAULT 'x',
job STRING DEFAULT 'x',
namespace STRING DEFAULT 'x',
shard STRING DEFAULT 'x',
keyspace STRING DEFAULT 'x',
component STRING DEFAULT 'x',
containername STRING DEFAULT 'x',
val FLOAT64,
ts DATETIME,
date DATE DEFAULT toDate(0),
tags ARRAY (String),
updated DATETIME DEFAULT now()
)
ENGINE = MergeTree PARTITION BY toMonday (date
) ORDER BY (date, NAME, ts
) SETTINGS index_granularity = 8192
// LOCAL TABLE ON Centos ..
CREATE TABLE metrics.samples (
ip STRING DEFAULT 'default',
app STRING DEFAULT 'x',
name STRING DEFAULT 'x',
job STRING DEFAULT 'x',
namespace STRING DEFAULT 'x',
shard STRING DEFAULT 'x',
keyspace STRING DEFAULT 'x',
component STRING DEFAULT 'x',
containername STRING DEFAULT 'x',
val FLOAT64,
ts DATETIME,
date DATE DEFAULT toDate(0),
tags ARRAY (String),
updated DATETIME DEFAULT now()
)ENGINE = MergeTree PARTITION BY toMonday (date) ORDER BY (date, NAME, ts) SETTINGS index_granularity = 8192;
CREATE TABLE metrics.samples (
ip STRING DEFAULT 'default',
app STRING DEFAULT 'x',
name STRING DEFAULT 'x',
job STRING DEFAULT 'x',
namespace STRING DEFAULT 'x',
shard STRING DEFAULT 'x',
keyspace STRING DEFAULT 'x',
component STRING DEFAULT 'x',
containername STRING DEFAULT 'x',
val FLOAT64,
ts DATETIME,
date DATE DEFAULT toDate(0),
tags ARRAY (String),
updated DATETIME DEFAULT now()
)ENGINE = ReplicatedGraphiteMergeTree ('/clickhouse/tables/{shard}/metrics.samples','{replica}', partition by toMonday(date) order by (date, name, ts) settings index_granularity=8192);
===线上操作步骤===
DROP DATABASE IF EXISTS metrics ON CLUSTER ads_app_clickhouse_cluster;
create database metrics on cluster ads_app_clickhouse_cluster;
CREATE TABLE IF NOT EXISTS metrics.samples (
ip String DEFAULT 'x',
app String DEFAULT 'x',
name String DEFAULT 'x',
job String DEFAULT 'x',
namespace String DEFAULT 'x',
shard String DEFAULT 'x',
keyspace String DEFAULT 'x',
component String DEFAULT 'x',
containername String DEFAULT 'x',
val Float64,
ts DateTime,
date Date DEFAULT toDate(0),
tags Array(String),
updated DateTime DEFAULT now()
)ENGINE = ReplicatedMergeTree('/clickhouse/tables/{shard}/metrics.samples','{replica}') PARTITION BY toMonday(date) ORDER BY (date, name, ts) SETTINGS index_granularity = 8192;
CREATE TABLE IF NOT EXISTS metrics.distribute ON CLUSTER ads_app_clickhouse_cluster(
ip String DEFAULT 'x',
app String DEFAULT 'x',
name String DEFAULT 'x',
job String DEFAULT 'x',
namespace String DEFAULT 'x',
shard String DEFAULT 'x',
keyspace String DEFAULT 'x',
component String DEFAULT 'x',
containername String DEFAULT 'x',
val Float64,
ts DateTime,
date Date DEFAULT toDate(0),
tags Array(String),
updated DateTime DEFAULT now()
)ENGINE = Distributed(ads_app_clickhouse_cluster, metrics, samples,rand())