DataStax
Studio
Schema
My First Connection
Connection
Schema
  • real_estateCQL Keyspace
    • Tables
    • User Defined Types
    • User Defined Functions
    • User Defined Aggregates
    • Materialized Views
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
indexrating 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.