Cassandra-如何使用cqlsh创建复合列名（非键）

Question

Entp: //CF
 //rowkey->  entp_name_xyz: 
                   {entp_full_name: "full_name_xyz",
                    some_value: 1,
                    policy: {policy_name: "default policy",
                             type: "type 1",
                             prop_1: "prop 1",
                             ...
                             },
                    rules: {rule_1:, rule_2:,rule_3:}
                   }

RowKey:- entp_name_xyz,
column_name:- policy:p1
Value:-{JSON object - {policy_name: "default policy", type: "type 1",                 prop_1: "prop 1", ...}}
column_name:- policy:p2
Value:-{JSON object - {policy_name: "default policy2", type: "type 1",                 prop_1: "prop 1", ...}}
column_name: rule:r1 where r1 is a rowkey of a Rules column family
Value: Null

插入entp(col1、col2、col3)值（“ABC”、“XYZ”、null）

谢了！

Answer 1

CREATE TABLE entp_policies (
    entp_name text,
    policy_name text,
    policy_value text,
    PRIMARY KEY (entp_name, policy_name)
);
CREATE TABLE entp_rules (
    entp_name text,
    rule_name text,
    rule_value text,
    PRIMARY KEY (entp_name, rule_name)
);

INSERT INTO entp_policies (entp_name, policy_name, policy_value)
     VALUES ('entp_name_xyz', 'p1',
             '{policy_name: "default policy", type: "type 1", ...}');

INSERT INTO entp_policies (entp_name, policy_name, policy_value)
     VALUES ('entp_name_xyz', 'p2',
             '{policy_name: "default policy2", type: "type 1", ...}');

INSERT INTO entp_rules (entp_name, rule_name) VALUES ('entp_name_xyz', 'r1');

-- Get all policies given an entp name
SELECT * FROM entp_policies WHERE entp_name = 'entp_name_xyz';

-- Get all rules given an entp
SELECT * FROM entp_rules WHERE entp_name = 'entp_name_xyz';

-- Get all columns given an entp_name (both of the above)

insert into entp (col1,col2) values ('abc','xyz');