我正在尝试向表中插入一个简单的行。有人能指出这里发生了什么吗?
CREATE TABLE recommendation_engine_poc.user_by_category (
game_category text,
customer_id text,
amount double,
game_date timestamp,
PRIMARY KEY (game_category, customer_id)
) WITH CLUSTERING ORDER BY (customer_id ASC)
AND bloom_filter_fp_chance = 0.01
AND caching = '{"keys":"ALL", "rows_per_partition":"NONE"}'
AND comment = ''
AND compaction = {'class': 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy'}
AND compression = {'sstable_compression': 'org.apache.cassandra.io.compress.LZ4Compressor'}
AND dclocal_read_repair_chance = 0.1
AND default_time_to_live = 0
AND gc_grace_seconds = 864000
AND max_index_interval = 2048
AND memtable_flush_period_in_ms = 0
AND min_index_interval = 128
AND read_repair_chance = 0.0
AND speculative_retry = '99.0PERCENTILE';
cqlsh:recommendation_engine_poc> insert into user_by_category ('game_category','customer_id') VALUES ('Goku','12') ;
SyntaxException:
发布于 2021-02-28 15:14:12
这个问题有两个原因:
双引号(“)而不是单引号(‘)
在in命令中的值之后输入密钥
字符编码
所以当使用像IN命令这样的过滤器时
从数据库where column中选择列
_
name IN('xyz','yzx')
在单行命令中
它应该在一行中,而不是
从数据库where column中选择列
_
姓名(‘xyz’,
‘'yzx')
多行输入命令
https://stackoverflow.com/questions/32117170
复制相似问题