-
Notifications
You must be signed in to change notification settings - Fork 0
/
employee.cql
62 lines (54 loc) · 4.81 KB
/
employee.cql
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
CREATE KEYSPACE catalog WITH REPLICATION = { 'class' : 'NetworkTopologyStrategy','DC1' : 3};
use catalog;
CREATE TABLE employee (
id varchar,
first_name text,
last_name text,
sex text,
dob timestamp,
phone_number varchar,
salary double,
address text,
PRIMARY KEY((id, first_name, last_name))
);
insert into employee ("id","first_name","last_name", "sex", "dob", "phone_number", "salary", "address") VALUES ('1', 'An', 'Nguyen Van', 'male', '2000-11-11 08:05+0000', '0123333333', 5000000.0, 'Ho Chi Minh City');
insert into employee ("id","first_name","last_name", "sex", "dob", "phone_number", "salary", "address") VALUES ('2', 'Chau', 'Nguyen Thi', 'female', '2001-11-5 08:05+0000', '0123333444', 9600000.0, 'Ha Noi City');
insert into employee ("id","first_name","last_name", "sex", "dob", "phone_number", "salary", "address") VALUES ('3', 'Hoang', 'Tran Van', 'male', '2000-4-11 08:05+0000', '0123333555', 7200000.0, 'Da Nang City');
insert into employee ("id","first_name","last_name", "sex", "dob", "phone_number", "salary", "address") VALUES ('4', 'Dat', 'Hoang Chi', 'male', '2001-3-12 08:05+0000', '0123333666', 4800000.0, 'Thanh Hoa');
insert into employee ("id","first_name","last_name", "sex", "dob", "phone_number", "salary", "address") VALUES ('5', 'Long', 'Vo Nam', 'male', '2000-9-11 08:05+0000', '0123333777', 7200000.0, 'Hue');
insert into employee ("id","first_name","last_name", "sex", "dob", "phone_number", "salary", "address") VALUES ('6', 'Trang', 'Tran Thu', 'female', '2000-9-11 08:05+0000', '0123333888', 7200000.0, 'Hue');
CREATE KEYSPACE tracking WITH REPLICATION = { 'class' : 'NetworkTopologyStrategy','DC1' : 3};
use tracking;
CREATE TABLE tracking_salary (
id varchar,
first_name text,
last_name text,
timestamp timestamp,
salary double,
primary key((id, first_name, last_name), timestamp)
)
WITH CLUSTERING ORDER BY (timestamp DESC)
AND COMPACTION =
{
'class': 'DateTieredCompactionStrategy',
'base_time_seconds': 3600,
'max_sstable_age_days': 1
};
INSERT INTO tracking.tracking_salary ("id","first_name","last_name","timestamp","salary") VALUES ('6','Trang','Tran Thu','2017-11-11 08:05+0000',5000000) ;
INSERT INTO tracking.tracking_salary ("id","first_name","last_name","timestamp","salary") VALUES ('6','Trang','Tran Thu','2017-11-11 09:05+0000',5200000) ;
INSERT INTO tracking.tracking_salary ("id","first_name","last_name","timestamp","salary") VALUES ('6','Trang','Tran Thu','2017-11-11 10:05+0000',5400000) ;
INSERT INTO tracking.tracking_salary ("id","first_name","last_name","timestamp","salary") VALUES ('6','Trang','Tran Thu','2017-11-11 10:22+0000',6200000) ;
INSERT INTO tracking.tracking_salary ("id","first_name","last_name","timestamp","salary") VALUES ('6','Trang','Tran Thu','2017-11-11 11:05+0000',8000000) ;
INSERT INTO tracking.tracking_salary ("id","first_name","last_name","timestamp","salary") VALUES ('6','Trang','Tran Thu','2017-11-11 12:05+0000',11000000) ;
INSERT INTO tracking.tracking_salary ("id","first_name","last_name","timestamp","salary") VALUES ('1','An','Nguyen Van','2017-11-11 08:05+0000',5000000) ;
INSERT INTO tracking.tracking_salary ("id","first_name","last_name","timestamp","salary") VALUES ('1','An','Nguyen Van','2017-11-11 09:05+0000',7000000) ;
INSERT INTO tracking.tracking_salary ("id","first_name","last_name","timestamp","salary") VALUES ('1','An','Nguyen Van','2017-11-11 10:05+0000',7500000) ;
INSERT INTO tracking.tracking_salary ("id","first_name","last_name","timestamp","salary") VALUES ('1','An','Nguyen Van','2017-11-11 10:22+0000',8200000) ;
INSERT INTO tracking.tracking_salary ("id","first_name","last_name","timestamp","salary") VALUES ('1','An','Nguyen Van','2017-11-11 11:05+0000',1200000) ;
INSERT INTO tracking.tracking_salary ("id","first_name","last_name","timestamp","salary") VALUES ('1','An','Nguyen Van','2017-11-11 12:05+0000',15000000) ;
INSERT INTO tracking.tracking_salary ("id","first_name","last_name","timestamp","salary") VALUES ('2','Chau','Nguyen Thi','2017-11-11 08:05+0000',5000000) ;
INSERT INTO tracking.tracking_salary ("id","first_name","last_name","timestamp","salary") VALUES ('2','Chau','Nguyen Thi','2017-11-11 09:05+0000',7000000) ;
INSERT INTO tracking.tracking_salary ("id","first_name","last_name","timestamp","salary") VALUES ('2','Chau','Nguyen Thi','2017-11-11 10:05+0000',7500000) ;
INSERT INTO tracking.tracking_salary ("id","first_name","last_name","timestamp","salary") VALUES ('2','Chau','Nguyen Thi','2017-11-11 10:22+0000',8000000) ;
INSERT INTO tracking.tracking_salary ("id","first_name","last_name","timestamp","salary") VALUES ('2','Chau','Nguyen Thi','2017-11-11 11:05+0000',1100000) ;
INSERT INTO tracking.tracking_salary ("id","first_name","last_name","timestamp","salary") VALUES ('2','Chau','Nguyen Thi','2017-11-11 12:05+0000',13000000) ;