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
CREATE KEYSPACE IF NOT EXISTS industries
WITH REPLICATION = { 'class': 'SimpleStrategy', 'replication_factor': 1 };
use industries;
drop table if exists productline_by_industry_manufacturer;
drop table if exists manufacturer_by_industry;
drop table if exists productline_by_manufacturer;
CREATE TABLE IF NOT EXISTS productline_by_industry_manufacturer(
industry text,
industry_associations set<text> STATIC,
manufacturer text,
manufacturer_hdqtrs text, // regular column
product_line text,
product_rating float, // regular column
/* ((I)MP) */
PRIMARY KEY( (industry), manufacturer, product_line ) );
CREATE TABLE IF NOT EXISTS manufacturer_by_industry(
industry text,
industry_associations set<text> STATIC,
manufacturer text,
manufacturer_hdqtrs text, // regular column
/* ((I)M) */
PRIMARY KEY( (industry), manufacturer ) );
CREATE TABLE IF NOT EXISTS productline_by_manufacturer(
manufacturer text,
manufacturer_hdqtrs text STATIC,
product_line text,
product_rating float, // regular column
/* ((M)P) */
PRIMARY KEY( (manufacturer), product_line ) );
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
Success - No Data Returned
Success. 0 elements returned. Duration: 12.233 s.