CQL
b>
Keyspace: not selected
b>
CL.ONE
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
CREATE KEYSPACE IF NOT EXISTS real_estate
WITH REPLICATION = { 'class': 'SimpleStrategy',
'replication_factor': 1 }
AND DURABLE_WRITES = true;
USE real_estate;
/*-----------------*/
CREATE TYPE IF NOT EXISTS address(
street text,
city text,
state text,
zip_code text
);
CREATE TYPE IF NOT EXISTS listing_standard(
street text,
zip_code text,
asking_price int,
thumbnail blob
);
CREATE TABLE IF NOT EXISTS listings_by_realtor(
// primary key with uniqueness
realtor_co_name text, // partition column
state_name text, // search
city_name text, // search
listing_id uuid, // uniqueness
realtor_co_address address STATIC,
// regular columns
asking_price int,
city_id uuid,
city_population int,
city_rating float,
listing_detail listing_standard,
state_energy_drink text,
state_region text,
PRIMARY KEY ((realtor_co_name), state_name, city_name, listing_id)
);
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
Success - No Data Returned
Success. 0 elements returned. Duration: 0.006 s.