CQL
b>
Keyspace: not selected
b>
CL.ONE
DROP KEYSPACE IF EXISTS redundancy;
CREATE KEYSPACE IF NOT EXISTS redundancy
WITH REPLICATION = { 'class': 'SimpleStrategy', 'replication_factor': 1 };
USE redundancy;
CREATE TABLE IF NOT EXISTS city_by_rating(
rating float,
state text,
city text,
state_region text,
city_population int,
PRIMARY KEY( (rating), state, city )
);
INSERT INTO city_by_rating(rating,state,city,state_region,city_population)
VALUES
(3.7,'Alaska','Anchorage','Pacific',291538);
INSERT INTO city_by_rating(rating,state,city,state_region,city_population)
VALUES
(3.7,'Alaska','Juneau','Pacific',32113);
-- incorrect value on separate partition
INSERT INTO city_by_rating(rating,state,city,state_region,city_population)
VALUES
(3.6,'Alaska','Juneau','Mountain',2113);
select * from city_by_rating;
/*-----------------------------------------------*/
CREATE TABLE IF NOT EXISTS city_by_rating_type(
rating float,
rating_type text,
state text,
city text,
state_region text,
city_population int,
PRIMARY KEY( (rating), rating_type, state, city )
);
-- inserts to violate FDs on same partition
INSERT INTO city_by_rating_type(rating,rating_type,state,city,state_region,city_population)
VALUES
(3.7,'living_cost','Alaska','Anchorage','Pacific',291538);
INSERT INTO city_by_rating_type(rating,rating_type,state,city,state_region,city_population)
VALUES
(3.7,'desirability','Alaska','Anchorage','Mid-Atlantic',91538);
select * from city_by_rating_type;
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
index | rating | rating_type | state | city | city_population | state_region |
---|---|---|---|---|---|---|
0 | 3.7 | desirability | Alaska | Anchorage | 91538 | Mid-Atlantic |
1 | 3.7 | living_cost | Alaska | Anchorage | 291538 | Pacific |
1
Displaying 1 - 2 of 2 results for the last statement
Success. 2 elements returned. Duration: 8.936 s.