我在插入JSON并将数据更新到我的Cassandra表中很难。
我有一个具有以下结构的表:
CREATE TYPE keyspace.connected_hw (
connected_element text,
support_list frozen<list<text>>
);
CREATE TABLE keyspace.sample_table (
id text,
name text,
connected_items frozen<keyspace.connected_hw>
)
我的插入脚本看起来像这样:
INSERT INTO keyspace.sample_table JSON '
{
"id": "12345",
"name": "object 1",
"connected_items": [
{
"connected_element": "56789",
"support_list": ""
}
]
}
'
运行此操作后,我会收到以下错误:
Error decoding JSON value for connected_items: Expected a map, but got a ArrayList :
我试图首先插入没有'connected_items'列表的其他字段,然后将其更新:
INSERT INTO keyspace.sample_table JSON '
{
"id": "12345",
"name": "object 1",
}
'
这起作用,直到我尝试使用
更新'connected_items'UPDATE keyspace.sample_table
SET connected_items = [{connected_element:'56789',support_list:['type1','type2']}]
where id='12345'
运行此操作后,我会收到以下错误:
InvalidQueryException: Invalid list literal for connected_items of type frozen<connected_hw>
您将connected_items
声明为类型connected_hw
,但您将值插入为'connected_hw'的列表,而support_list
也是text
的列表,不仅是text
您要么更改插入/更新格式,如下所示:
INSERT INTO sample_table JSON '{"id": "12345", "name": "object 1", "connected_items": { "connected_element": "56789", "support_list": ["a","b"] } }' ;
和
UPDATE sample_table SET connected_items = {connected_element:'56789',support_list:['type1','type2']} where id='12345' ;
或将连接的类型更改为connected_hw
的列表ALTER TABLE sample_table DROP connected_items ;
ALTER TABLE sample_table ADD connected_items list<frozen <connected_hw>>;