table-cyclist-alt-stats
cql
INSERT INTO cycling.cyclist_alt_stats (id, lastname, birthday, nationality, weight, w_units, height, first_race, last_race) VALUES (ed584e99-80f7-4b13-9a90-9dc5571e6821,'TSATEVICH', '1989-07-05', 'Russia', 64, 'kg', 1.69, '2006-03-15','2017-04-16');
INSERT INTO cycling.cyclist_alt_stats (id, lastname, birthday, nationality, weight, w_units, height, first_race, last_race) VALUES (a9e96714-2dd0-41f9-8bd0-557196a44ecf,'ISAYCHEV', '1986-04-21', 'Russia', 80, 'kg', 1.88,'2003-04-22','2017-03-05');
INSERT INTO cycling.cyclist_alt_stats (id, lastname, birthday, nationality, weight, w_units, height, first_race, last_race) VALUES (823ec386-2a46-45c9-be41-2425a4b7658e,'BELKOV', '1985-01-09', 'Russia', 71, 'kg', 1.84,'2002-03-22','2017-04-16');
INSERT INTO cycling.cyclist_alt_stats (id, lastname, birthday, nationality, weight, w_units, height, first_race, last_race) VALUES (e0953617-07eb-4c82-8f91-3b2757981625,'BRUTT', '1982-01-29', 'Russia', 68, 'kg', 1.78,'1998-02-15','2017-04-16');
INSERT INTO cycling.cyclist_alt_stats (id, lastname, birthday, nationality, weight, w_units, height, first_race, last_race) VALUES (078654a6-42fa-4142-ae43-cebdc67bd902,'LAGUTIN', '1981-01-14', 'Russia', 63, 'kg', 1.82,'1996-05-21','2010-10-02');
INSERT INTO cycling.cyclist_alt_stats (id, lastname, birthday, nationality, weight, w_units, height, first_race, last_race) VALUES (d74d6e70-7484-4df5-8551-f5090c37f617,'GRMAY', '1991-08-25', 'Ethiopia', 63, 'kg', 1.75, '2006-05-21','2017-04-16');
INSERT INTO cycling.cyclist_alt_stats (id, lastname, birthday, nationality, weight, w_units, height, first_race, last_race) VALUES (c09e9451-50da-483d-8108-e6bea2e827b3,'VEIKKANEN', '1981-03-29', 'Finland', 66, 'kg', 1.78,'1996-05-21','2012-10-02');
INSERT INTO cycling.cyclist_alt_stats (id, lastname, birthday, nationality, weight, w_units, height, first_race, last_race) VALUES (f1deff54-7d96-4981-b14a-b70be4da82d2,'TLEUBAYEV', null, 'Kazakhstan', null, null, null, '2003-04-22','2017-04-16');
INSERT INTO cycling.cyclist_alt_stats (id, lastname, birthday, nationality, weight, w_units, height, first_race, last_race) VALUES (1ba0417d-62da-4103-b710-de6fb227db6f,'PAULINHO', '1990-05-27', 'Portugal', null, null, null, '2006-03-15','2017-03-05');
INSERT INTO cycling.cyclist_alt_stats (id, lastname, birthday, nationality, weight, w_units, height, first_race, last_race) VALUES (4ceb495c-55ab-4f71-83b9-81117252bb13,'DUVAL', '1990-05-27','France', null, null, null, '2006-03-15','2017-04-16');
INSERT INTO cycling.cyclist_alt_stats (id, lastname, birthday, nationality, weight, w_units, height, first_race, last_race) VALUES (ed584e99-80f7-4b13-9a90-9dc5571e6821,'TSATEVICH', '1989-07-05', 'Russia', 64, 'kg', 1.69, '2006-03-15','2017-04-16');
INSERT INTO cycling.cyclist_alt_stats (id, lastname, birthday, nationality, weight, w_units, height, first_race, last_race) VALUES (a9e96714-2dd0-41f9-8bd0-557196a44ecf,'ISAYCHEV', '1986-04-21', 'Russia', 80, 'kg', 1.88,'2003-04-22','2017-03-05');
INSERT INTO cycling.cyclist_alt_stats (id, lastname, birthday, nationality, weight, w_units, height, first_race, last_race) VALUES (823ec386-2a46-45c9-be41-2425a4b7658e,'BELKOV', '1985-01-09', 'Russia', 71, 'kg', 1.84,'2002-03-22','2017-04-16');
INSERT INTO cycling.cyclist_alt_stats (id, lastname, birthday, nationality, weight, w_units, height, first_race, last_race) VALUES (e0953617-07eb-4c82-8f91-3b2757981625,'BRUTT', '1982-01-29', 'Russia', 68, 'kg', 1.78,'1998-02-15','2017-04-16');
INSERT INTO cycling.cyclist_alt_stats (id, lastname, birthday, nationality, weight, w_units, height, first_race, last_race) VALUES (078654a6-42fa-4142-ae43-cebdc67bd902,'LAGUTIN', '1981-01-14', 'Russia', 63, 'kg', 1.82,'1996-05-21','2010-10-02');
INSERT INTO cycling.cyclist_alt_stats (id, lastname, birthday, nationality, weight, w_units, height, first_race, last_race) VALUES (d74d6e70-7484-4df5-8551-f5090c37f617,'GRMAY', '1991-08-25', 'Ethiopia', 63, 'kg', 1.75, '2006-05-21','2017-04-16');
INSERT INTO cycling.cyclist_alt_stats (id, lastname, birthday, nationality, weight, w_units, height, first_race, last_race) VALUES (c09e9451-50da-483d-8108-e6bea2e827b3,'VEIKKANEN', '1981-03-29', 'Finland', 66, 'kg', 1.78,'1996-05-21','2012-10-02');
INSERT INTO cycling.cyclist_alt_stats (id, lastname, birthday, nationality, weight, w_units, height, first_race, last_race) VALUES (f1deff54-7d96-4981-b14a-b70be4da82d2,'TLEUBAYEV', null, 'Kazakhstan', null, null, null, '2003-04-22','2017-04-16');
INSERT INTO cycling.cyclist_alt_stats (id, lastname, birthday, nationality, weight, w_units, height, first_race, last_race) VALUES (1ba0417d-62da-4103-b710-de6fb227db6f,'PAULINHO', '1990-05-27', 'Portugal', null, null, null, '2006-03-15','2017-03-05');
INSERT INTO cycling.cyclist_alt_stats (id, lastname, birthday, nationality, weight, w_units, height, first_race, last_race) VALUES (4ceb495c-55ab-4f71-83b9-81117252bb13,'DUVAL', '1990-05-27','France', null, null, null, '2006-03-15','2017-04-16');
cql
INSERT INTO cycling.cyclist_alt_stats (id,first_race) VALUES (ed584e99-80f7-4b13-9a90-9dc5571e6821,'2006-03-15');
INSERT INTO cycling.cyclist_alt_stats (id,first_race) VALUES (ed584e99-80f7-4b13-9a90-9dc5571e6821,'2006-03-15');
cql
INSERT INTO cycling.cyclist_alt_stats (id,last_race) VALUES (ed584e99-80f7-4b13-9a90-9dc5571e6821,todate(now()));
INSERT INTO cycling.cyclist_alt_stats (id,last_race) VALUES (ed584e99-80f7-4b13-9a90-9dc5571e6821,todate(now()));
cql
CREATE INDEX IF NOT EXISTS birthday_idx ON cycling.cyclist_alt_stats (birthday);
cql
CREATE CUSTOM INDEX IF NOT EXISTS birthday_idx ON cycling.cyclist_alt_stats (birthday)
USING 'StorageAttachedIndex';
cql
CREATE INDEX id_idx ON cycling.cyclist_alt_stats (id);
cql
CREATE CUSTOM INDEX id_idx ON cycling.cyclist_alt_stats (id) USING 'StorageAttachedIndex';
cql
CREATE CUSTOM INDEX id_sasi_idx ON cycling.cyclist_alt_stats (id)
USING 'org.apache.cassandra.index.sasi.SASIIndex';
cql
CREATE INDEX IF NOT EXISTS nationality_idx ON cycling.cyclist_alt_stats (nationality);
cql
CREATE CUSTOM INDEX IF NOT EXISTS nationality_idx ON cycling.cyclist_alt_stats (nationality)
USING 'StorageAttachedIndex';
cql
CREATE INDEX weight_idx ON cycling.cyclist_alt_stats (weight);
cql
CREATE CUSTOM INDEX weight_idx ON cycling.cyclist_alt_stats (weight) USING 'StorageAttachedIndex';
cql
DESCRIBE INDEX birthday_idx;
cql
DESCRIBE INDEX birthday_idx;
cql
DESCRIBE INDEX id_idx;
cql
DESCRIBE INDEX id_idx;
cql
DESCRIBE INDEX id_sasi_idx;
cql
DESCRIBE INDEX nationality_idx;
cql
DESCRIBE INDEX nationality_idx;
cql
DESCRIBE INDEX weight_idx;
cql
DESCRIBE INDEX weight_idx;
cql
DROP INDEX IF EXISTS cycling.birthday_idx;
cql
DROP INDEX IF EXISTS cycling.id_idx;
cql
DROP INDEX IF EXISTS cycling.id_sasi_idx;
cql
DROP INDEX IF EXISTS cycling.nationality_idx;
cql
DROP INDEX IF EXISTS cycling.weight_idx;
cql
SELECT * FROM cycling.cyclist_alt_stats;
cql
SELECT * FROM cycling.cyclist_alt_stats;
cql
SELECT * FROM cycling.cyclist_alt_stats;
cql
SELECT * FROM cycling.cyclist_alt_stats WHERE birthday = '1982-01-29'
AND nationality = 'Russia';
cql
SELECT lastname, birthday, nationality FROM cycling.cyclist_alt_stats
WHERE birthday = '1991-08-25' AND nationality = 'Ethiopia'
ALLOW FILTERING;
SELECT lastname, birthday, nationality FROM cycling.cyclist_alt_stats
WHERE birthday = '1991-08-25' AND nationality = 'Ethiopia';
cql
SELECT lastname, birthday, nationality FROM cycling.cyclist_alt_stats
WHERE birthday = '1991-08-25' AND nationality = 'Ethiopia'
ALLOW FILTERING;
cql
SELECT lastname, birthday, nationality FROM cycling.cyclist_alt_stats
WHERE birthday = '1981-03-29';
cql
SELECT lastname, birthday, nationality FROM cycling.cyclist_alt_stats
WHERE birthday = '1981-03-29';
cql
SELECT lastname, birthday, nationality FROM cycling.cyclist_alt_stats
WHERE birthday = '1991-08-25' OR nationality = 'Ethiopia';
cql
SELECT lastname, birthday, nationality FROM cycling.cyclist_alt_stats
WHERE birthday = '1991-08-25' OR nationality = 'Ethiopia'
ALLOW FILTERING;
cql
SELECT lastname, birthday, nationality FROM cycling.cyclist_alt_stats
WHERE birthday >'1981-03-29';
cql
SELECT lastname, birthday, nationality FROM cycling.cyclist_alt_stats
WHERE birthday >'1981-03-29'
ALLOW FILTERING;
cql
SELECT id, cyclist_age AS age FROM cycling.cyclist_alt_stats LIMIT 3;
cql
SELECT lastname, nationality, weight FROM cycling.cyclist_alt_stats
WHERE weight = 66;
cql
SELECT lastname, nationality, weight FROM cycling.cyclist_alt_stats
WHERE weight = 70 ALLOW FILTERING;
cql
SELECT lastname, nationality, weight FROM cycling.cyclist_alt_stats
WHERE weight > 70;
cql
SELECT lastname, nationality, weight FROM cycling.cyclist_alt_stats
WHERE weight > 70 ALLOW FILTERING;
cql
SELECT first_race, last_race, birthday FROM cycling.cyclist_alt_stats
WHERE id = ed584e99-80f7-4b13-9a90-9dc5571e6821;
cql
SELECT first_race, last_race, birthday FROM cycling.cyclist_alt_stats
WHERE nationality = 'France';
cql
SELECT first_race, last_race, birthday FROM cycling.cyclist_alt_stats
WHERE nationality = 'France';
cql
ALTER TABLE cycling.cyclist_alt_stats ADD cyclist_age int;
cql
ALTER TABLE cycling.cyclist_alt_stats DROP cyclist_age;
cql
ALTER TABLE cycling.cyclist_alt_stats ALTER favorite_color TYPE text;
cql
ALTER TABLE cycling.cyclist_alt_stats RENAME id TO cyclist_id;
cql
CREATE TABLE IF NOT EXISTS cycling.cyclist_alt_stats (
id UUID PRIMARY KEY,
lastname text,
birthday date,
nationality text,
weight float,
w_units text,
height float,
first_race date,
last_race date
);
cql
DESCRIBE TABLE cycling.cyclist_alt_stats;
cql
DROP TABLE IF EXISTS cycling.cyclist_alt_stats;
cql
UPDATE cycling.cyclist_alt_stats SET last_race = toDate(now())
WHERE id = ed584e99-80f7-4b13-9a90-9dc5571e6821;
cql
UPDATE cycling.cyclist_alt_stats SET birthday = '1987-03-07'
WHERE id = ed584e99-80f7-4b13-9a90-9dc5571e6821;