cassandra - CQL 查询中的语法错误] message="第 1:7 行在输入“MATERIALIZED”处没有可行的替代方案([CREATE] MATERIALIZED
问题描述
任何线索为什么我从该主题中得到错误。贝娄我粘贴了重现错误的所有步骤。
我发现有人面临同样的问题,我尝试了提出的解决方案,但我确实遇到了完全相同的问题。
我尝试通过创建表 all_orders 并遵循 @halfer 解决方案来关注Cassandra 中的物化视图错误,但我得到了完全相同的错误消息。
整个日志:
C:\Program Files\DataStax Community\apache-cassandra\bin>set JAVA_HOME=C:\Program Files\Java\jre1.8.0_171
C:\Program Files\DataStax Community\apache-cassandra\bin>cqlsh
Connected to Test Cluster at 127.0.0.1:9042.
[cqlsh 5.0.1 | Cassandra 2.2.3 | CQL spec 3.3.1 | Native protocol v4]
Use HELP for help.
WARNING: pyreadline dependency missing. Install to enable tab completion.
cqlsh> CREATE KEYSPACE IF NOT EXISTS sample WITH replication = {'class':'SimpleStrategy', 'replication_factor':1};
cqlsh> use sample;
cqlsh:sample> CREATE TABLE IF NOT EXISTS sample.hotels (
... id UUID,
... name varchar,
... address varchar,
... state varchar,
... zip varchar,
... primary key(id)
... );
cqlsh:sample>
cqlsh:sample> CREATE TABLE IF NOT EXISTS sample.hotels_by_letter (
... first_letter varchar,
... hotel_name varchar,
... hotel_id UUID,
... address varchar,
... state varchar,
... zip varchar,
... primary key((first_letter), hotel_name, hotel_id)
... );
cqlsh:sample> CREATE MATERIALIZED VIEW sample.hotels_by_state AS
... SELECT id, name, address, state, zip FROM hotels
... WHERE state IS NOT NULL AND id IS NOT NULL AND name IS NOT NULL
... PRIMARY KEY ((state), id)
... WITH CLUSTERING ORDER BY (name DESC)
... ;
SyntaxException: <ErrorMessage code=2000 [Syntax error in CQL query] message="line 1:7 no viable alternative at input 'MATERIALIZED' ([CREATE] MATERIALIZED...)">
*** 添加
我尝试了https://www.datastax.com/dev/blog/new-in-cassandra-3-0-materialized-views中提供的确切示例,我遇到了同样的问题(证据如下)。
cqlsh:sample> CREATE TABLE scores
... (
... user TEXT,
... game TEXT,
... year INT,
... month INT,
... day INT,
... score INT,
... PRIMARY KEY (user, game, year, month, day)
... );
cqlsh:sample> CREATE MATERIALIZED VIEW alltimehigh AS
... SELECT user FROM scores
... WHERE game IS NOT NULL AND score IS NOT NULL AND user IS NOT NULL AND year IS NOT NULL AND month IS NOT NULL AND day IS NOT NULL
... PRIMARY KEY (game, score, user, year, month, day)
... WITH CLUSTERING ORDER BY (score desc);
SyntaxException: <ErrorMessage code=2000 [Syntax error in CQL query] message="line 1:7 no viable alternative at input 'MATERIALIZED' ([CREATE] MATERIALIZED...)">
cqlsh:sample>
解决方案
我不认为这是 Cassandra 2.X 中的一个选项。我认为这是一个 3.X 规范(我们跳到 3.11,它工作得很好)。
推荐阅读
- haskell - 这是一个有效的单子实例吗?
- python - 不使用 map 方法将列表列表从字符串转换为整数
- flutter - 如何使用 Flutter 从 IP 地址流式传输实时视频?
- time-series - 在时间序列分类问题中规范化数据 - 递归神经网络
- splunk - Stats UI 和 Splunk API 不匹配
- python - Tkinter 缩小小部件之间的差距
- javascript - 内存已满时删除最旧的 chrome.storage.sync?
- javascript - 如何将对象数组传递给 Handlebars 中的 partialo?
- python - 如何在通过变量搜索时从一个表中选择 user_ID 并插入到另一个表中?Python 我的 SQL
- javascript - 使用 iFrame 中的父文档触发和关闭窗口