Gfgpc45E

1/*CREATE TABLE IF NOT EXISTS support_metrics (
2    domain VARCHAR(100) NOT NULL,
3    truncated_time VARCHAR(100) NOT NULL,
4    app_id VARCHAR(100) NOT NULL,
5    platform_type VARCHAR(100) NOT NULL,
6    lang VARCHAR(100) NOT NULL,
7    handling_time_sum BIGINT,
8    issue_created_count BIGINT,
9    issue_assign_count BIGINT,
10    CONSTRAINT pk PRIMARY KEY(domain,truncated_time,app_id,platform_type,lang));
11);*/
12INSERT INTO support_metrics VALUES('test','201801010000','test_app_20170907103216787-ee581870cb0bd01','platform1','en', 10000,100,10);
13INSERT INTO support_metrics VALUES('test','201801010000','test_app_20170907103216787-ee581870cb0bd01','platform2','en', 10000,100,10);
14INSERT INTO support_metrics VALUES('test','201801010000','test_app_20170907103216787-ee581870cb0bd01','platform3','en', 10000,100,10);
15INSERT INTO support_metrics VALUES('test','201801010000','test_app_20170907103216787-ee581870cb0bd02','platform1','en', 10000,100,10);
16INSERT INTO support_metrics VALUES('test','201801010000','test_app_20170907103216787-ee581870cb0bd02','platform2','en', 10000,100,10);
17INSERT INTO support_metrics VALUES('test','201801010000','test_app_20170907103216787-ee581870cb0bd02','platform3','en', 10000,100,10);
18INSERT INTO support_metrics VALUES('test','201801010000','test_app_20170907103216787-ee581870cb0bd02','platform3','sp', 10000,100,10);
19
20INSERT INTO support_metrics VALUES('test','201801010030','test_app_20170907103216787-ee581870cb0bd01','platform1','en', 10000,100,10);
21INSERT INTO support_metrics VALUES('test','201801010030','test_app_20170907103216787-ee581870cb0bd01','platform2','en', 10000,100,10);
22INSERT INTO support_metrics VALUES('test','201801010030','test_app_20170907103216787-ee581870cb0bd01','platform3','en', 10000,100,10);
23INSERT INTO support_metrics VALUES('test','201801010030','test_app_20170907103216787-ee581870cb0bd02','platform1','en', 10000,100,10);
24INSERT INTO support_metrics VALUES('test','201801010030','test_app_20170907103216787-ee581870cb0bd02','platform2','en', 10000,100,10);
25INSERT INTO support_metrics VALUES('test','201801010030','test_app_20170907103216787-ee581870cb0bd02','platform3','en', 10000,100,10);
26INSERT INTO support_metrics VALUES('test','201801010030','test_app_20170907103216787-ee581870cb0bd02','platform3','sp', 10000,100,10);
27
28INSERT INTO support_metrics VALUES('test','201801010100','test_app_20170907103216787-ee581870cb0bd01','platform1','en', 10000,100,10);
29INSERT INTO support_metrics VALUES('test','201801010100','test_app_20170907103216787-ee581870cb0bd01','platform2','en', 10000,100,10);
30INSERT INTO support_metrics VALUES('test','201801010100','test_app_20170907103216787-ee581870cb0bd01','platform3','en', 10000,100,10);
31INSERT INTO support_metrics VALUES('test','201801010100','test_app_20170907103216787-ee581870cb0bd02','platform1','en', 10000,100,10);
32INSERT INTO support_metrics VALUES('test','201801010100','test_app_20170907103216787-ee581870cb0bd02','platform2','en', 10000,100,10);
33INSERT INTO support_metrics VALUES('test','201801010100','test_app_20170907103216787-ee581870cb0bd02','platform3','en', 10000,100,10);
34INSERT INTO support_metrics VALUES('test','201801010100','test_app_20170907103216787-ee581870cb0bd02','platform3','sp', 10000,100,10);
35
36INSERT INTO support_metrics VALUES('test','201801010130','test_app_20170907103216787-ee581870cb0bd01','platform1','en', 10000,100,10);
37INSERT INTO support_metrics VALUES('test','201801010130','test_app_20170907103216787-ee581870cb0bd01','platform2','en', 10000,100,10);
38INSERT INTO support_metrics VALUES('test','201801010130','test_app_20170907103216787-ee581870cb0bd01','platform3','en', 10000,100,10);
39INSERT INTO support_metrics VALUES('test','201801010130','test_app_20170907103216787-ee581870cb0bd02','platform1','en', 10000,100,10);
40INSERT INTO support_metrics VALUES('test','201801010130','test_app_20170907103216787-ee581870cb0bd02','platform2','en', 10000,100,10);
41INSERT INTO support_metrics VALUES('test','201801010130','test_app_20170907103216787-ee581870cb0bd02','platform3','en', 10000,100,10);
42INSERT INTO support_metrics VALUES('test','201801010130','test_app_20170907103216787-ee581870cb0bd02','platform3','sp', 10000,100,10);
43
44INSERT INTO support_metrics VALUES('test','201801010200','test_app_20170907103216787-ee581870cb0bd01','platform1','en', 10000,100,10);
45INSERT INTO support_metrics VALUES('test','201801010200','test_app_20170907103216787-ee581870cb0bd01','platform2','en', 10000,100,10);
46INSERT INTO support_metrics VALUES('test','201801010200','test_app_20170907103216787-ee581870cb0bd01','platform3','en', 10000,100,10);
47INSERT INTO support_metrics VALUES('test','201801010200','test_app_20170907103216787-ee581870cb0bd02','platform1','en', 10000,100,10);
48INSERT INTO support_metrics VALUES('test','201801010200','test_app_20170907103216787-ee581870cb0bd02','platform2','en', 10000,100,10);
49INSERT INTO support_metrics VALUES('test','201801010200','test_app_20170907103216787-ee581870cb0bd02','platform3','en', 10000,100,10);
50INSERT INTO support_metrics VALUES('test','201801010200','test_app_20170907103216787-ee581870cb0bd02','platform3','sp', 10000,100,10);
51
52INSERT INTO support_metrics VALUES('test','201801010230','test_app_20170907103216787-ee581870cb0bd01','platform1','en', 10000,100,10);
53INSERT INTO support_metrics VALUES('test','201801010230','test_app_20170907103216787-ee581870cb0bd01','platform2','en', 10000,100,10);
54INSERT INTO support_metrics VALUES('test','201801010230','test_app_20170907103216787-ee581870cb0bd01','platform3','en', 10000,100,10);
55INSERT INTO support_metrics VALUES('test','201801010230','test_app_20170907103216787-ee581870cb0bd02','platform1','en', 10000,100,10);
56INSERT INTO support_metrics VALUES('test','201801010230','test_app_20170907103216787-ee581870cb0bd02','platform2','en', 10000,100,10);
57INSERT INTO support_metrics VALUES('test','201801010230','test_app_20170907103216787-ee581870cb0bd02','platform3','en', 10000,100,10);
58INSERT INTO support_metrics VALUES('test','201801010230','test_app_20170907103216787-ee581870cb0bd02','platform3','sp', 10000,100,10);
59
60INSERT INTO support_metrics VALUES('test','201801010300','test_app_20170907103216787-ee581870cb0bd01','platform1','en', 10000,100,10);
61INSERT INTO support_metrics VALUES('test','201801010300','test_app_20170907103216787-ee581870cb0bd01','platform2','en', 10000,100,10);
62INSERT INTO support_metrics VALUES('test','201801010300','test_app_20170907103216787-ee581870cb0bd01','platform3','en', 10000,100,10);
63INSERT INTO support_metrics VALUES('test','201801010300','test_app_20170907103216787-ee581870cb0bd02','platform1','en', 10000,100,10);
64INSERT INTO support_metrics VALUES('test','201801010300','test_app_20170907103216787-ee581870cb0bd02','platform2','en', 10000,100,10);
65INSERT INTO support_metrics VALUES('test','201801010300','test_app_20170907103216787-ee581870cb0bd02','platform3','en', 10000,100,10);
66INSERT INTO support_metrics VALUES('test','201801010300','test_app_20170907103216787-ee581870cb0bd02','platform3','sp', 10000,100,10);
67
68INSERT INTO support_metrics VALUES('test','201801010330','test_app_20170907103216787-ee581870cb0bd01','platform1','en', 10000,100,10);
69INSERT INTO support_metrics VALUES('test','201801010330','test_app_20170907103216787-ee581870cb0bd01','platform2','en', 10000,100,10);
70INSERT INTO support_metrics VALUES('test','201801010330','test_app_20170907103216787-ee581870cb0bd01','platform3','en', 10000,100,10);
71INSERT INTO support_metrics VALUES('test','201801010330','test_app_20170907103216787-ee581870cb0bd02','platform1','en', 10000,100,10);
72INSERT INTO support_metrics VALUES('test','201801010330','test_app_20170907103216787-ee581870cb0bd02','platform2','en', 10000,100,10);
73INSERT INTO support_metrics VALUES('test','201801010330','test_app_20170907103216787-ee581870cb0bd02','platform3','en', 10000,100,10);
74INSERT INTO support_metrics VALUES('test','201801010330','test_app_20170907103216787-ee581870cb0bd02','platform3','sp', 10000,100,10);
75
76INSERT INTO support_metrics VALUES('test','201801010400','test_app_20170907103216787-ee581870cb0bd01','platform1','en', 10000,100,10);
77INSERT INTO support_metrics VALUES('test','201801010400','test_app_20170907103216787-ee581870cb0bd01','platform2','en', 10000,100,10);
78INSERT INTO support_metrics VALUES('test','201801010400','test_app_20170907103216787-ee581870cb0bd01','platform3','en', 10000,100,10);
79INSERT INTO support_metrics VALUES('test','201801010400','test_app_20170907103216787-ee581870cb0bd02','platform1','en', 10000,100,10);
80INSERT INTO support_metrics VALUES('test','201801010400','test_app_20170907103216787-ee581870cb0bd02','platform2','en', 10000,100,10);
81INSERT INTO support_metrics VALUES('test','201801010400','test_app_20170907103216787-ee581870cb0bd02','platform3','en', 10000,100,10);
82INSERT INTO support_metrics VALUES('test','201801010400','test_app_20170907103216787-ee581870cb0bd02','platform3','sp', 10000,100,10);
83
84INSERT INTO support_metrics VALUES('test','201801010430','test_app_20170907103216787-ee581870cb0bd01','platform1','en', 10000,100,10);
85INSERT INTO support_metrics VALUES('test','201801010430','test_app_20170907103216787-ee581870cb0bd01','platform2','en', 10000,100,10);
86INSERT INTO support_metrics VALUES('test','201801010430','test_app_20170907103216787-ee581870cb0bd01','platform3','en', 10000,100,10);
87INSERT INTO support_metrics VALUES('test','201801010430','test_app_20170907103216787-ee581870cb0bd02','platform1','en', 10000,100,10);
88INSERT INTO support_metrics VALUES('test','201801010430','test_app_20170907103216787-ee581870cb0bd02','platform2','en', 10000,100,10);
89INSERT INTO support_metrics VALUES('test','201801010430','test_app_20170907103216787-ee581870cb0bd02','platform3','en', 10000,100,10);
90INSERT INTO support_metrics VALUES('test','201801010430','test_app_20170907103216787-ee581870cb0bd02','platform3','sp', 10000,100,10);
91
92INSERT INTO support_metrics VALUES('test','201801010500','test_app_20170907103216787-ee581870cb0bd01','platform1','en', 10000,100,10);
93INSERT INTO support_metrics VALUES('test','201801010500','test_app_20170907103216787-ee581870cb0bd01','platform2','en', 10000,100,10);
94INSERT INTO support_metrics VALUES('test','201801010500','test_app_20170907103216787-ee581870cb0bd01','platform3','en', 10000,100,10);
95INSERT INTO support_metrics VALUES('test','201801010500','test_app_20170907103216787-ee581870cb0bd02','platform1','en', 10000,100,10);
96INSERT INTO support_metrics VALUES('test','201801010500','test_app_20170907103216787-ee581870cb0bd02','platform2','en', 10000,100,10);
97INSERT INTO support_metrics VALUES('test','201801010500','test_app_20170907103216787-ee581870cb0bd02','platform3','en', 10000,100,10);
98INSERT INTO support_metrics VALUES('test','201801010500','test_app_20170907103216787-ee581870cb0bd02','platform3','sp', 10000,100,10);
99
100INSERT INTO support_metrics VALUES('test','201801010530','test_app_20170907103216787-ee581870cb0bd01','platform1','en', 10000,100,10);
101INSERT INTO support_metrics VALUES('test','201801010530','test_app_20170907103216787-ee581870cb0bd01','platform2','en', 10000,100,10);
102INSERT INTO support_metrics VALUES('test','201801010530','test_app_20170907103216787-ee581870cb0bd01','platform3','en', 10000,100,10);
103INSERT INTO support_metrics VALUES('test','201801010530','test_app_20170907103216787-ee581870cb0bd02','platform1','en', 10000,100,10);
104INSERT INTO support_metrics VALUES('test','201801010530','test_app_20170907103216787-ee581870cb0bd02','platform2','en', 10000,100,10);
105INSERT INTO support_metrics VALUES('test','201801010530','test_app_20170907103216787-ee581870cb0bd02','platform3','en', 10000,100,10);
106INSERT INTO support_metrics VALUES('test','201801010530','test_app_20170907103216787-ee581870cb0bd02','platform3','sp', 10000,100,10);
107
108INSERT INTO support_metrics VALUES('test','201801010600','test_app_20170907103216787-ee581870cb0bd01','platform1','en', 10000,100,10);
109INSERT INTO support_metrics VALUES('test','201801010600','test_app_20170907103216787-ee581870cb0bd01','platform2','en', 10000,100,10);
110INSERT INTO support_metrics VALUES('test','201801010600','test_app_20170907103216787-ee581870cb0bd01','platform3','en', 10000,100,10);
111INSERT INTO support_metrics VALUES('test','201801010600','test_app_20170907103216787-ee581870cb0bd02','platform1','en', 10000,100,10);
112INSERT INTO support_metrics VALUES('test','201801010600','test_app_20170907103216787-ee581870cb0bd02','platform2','en', 10000,100,10);
113INSERT INTO support_metrics VALUES('test','201801010600','test_app_20170907103216787-ee581870cb0bd02','platform3','en', 10000,100,10);
114INSERT INTO support_metrics VALUES('test','201801010600','test_app_20170907103216787-ee581870cb0bd02','platform3','sp', 10000,100,10);