Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Our 2.1 cqlsh [cqlsh 5.0.1 | Cassandra 3.0.8 | CQL spec 3.3.1 | Native protocol v4] does not have ALTER MV in tab completion #58

Open
tomer-sandler opened this issue Mar 14, 2018 · 0 comments

Comments

@tomer-sandler
Copy link

Installation details
Scylla version (or git commit hash): 2.1
Cluster size: 3
OS (RHEL/CentOS/Ubuntu/AWS AMI): AWS AMI

Relates to ticket #3283

[centos@ip-172-16-0-62 ~]$ cqlsh `hostname -i`
Connected to  at 172.16.0.62:9042.
[cqlsh 5.0.1 | Cassandra 3.0.8 | CQL spec 3.3.1 | Native protocol v4]
Use HELP for help.
cqlsh> ALTER
   ...
cqlsh> ALTER [tab completion]
COLUMNFAMILY  KEYSPACE      ROLE          SCHEMA        TABLE         TYPE          USER

User can still manually insert the ALTER MV statement (for the 2i) and it works OK.

cqlsh> ALTER MATERIALIZED VIEW direct_ts.data_points_curr_epoch_idx_index WITH compaction = {'class': 'TimeWindowCompactionStrategy', 'compaction_window_size': '60', 'compaction_window_unit': 'MINUTES'} ;
cqlsh> DESC SCHEMA

CREATE KEYSPACE direct_ts WITH replication = {'class': 'SimpleStrategy', 'replication_factor': '3'}  AND durable_writes = true;

CREATE TABLE direct_ts.data_points (
    rack_id text,
    sensor_id text,
    curr_epoch timestamp,
    value int,
    PRIMARY KEY ((rack_id, sensor_id), curr_epoch)
) WITH CLUSTERING ORDER BY (curr_epoch DESC)
    AND bloom_filter_fp_chance = 0.01
    AND caching = {'keys': 'ALL', 'rows_per_partition': 'ALL'}
    AND comment = ''
    AND compaction = {'class': 'TimeWindowCompactionStrategy', 'compaction_window_size': '60', 'compaction_window_unit': 'MINUTES'}
    AND compression = {'sstable_compression': 'org.apache.cassandra.io.compress.LZ4Compressor'}
    AND crc_check_chance = 1.0
    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';
CREATE INDEX data_points_curr_epoch_idx ON direct_ts.data_points (curr_epoch);

CREATE MATERIALIZED VIEW direct_ts.data_points_curr_epoch_idx_index AS
    SELECT curr_epoch, rack_id, sensor_id
    FROM direct_ts.data_points
    WHERE curr_epoch IS NOT NULL
    PRIMARY KEY (curr_epoch, rack_id, sensor_id)
    WITH CLUSTERING ORDER BY (rack_id ASC, sensor_id ASC)
    AND bloom_filter_fp_chance = 0.01
    AND caching = {'keys': 'ALL', 'rows_per_partition': 'ALL'}
    AND comment = ''
    AND compaction = {'class': 'TimeWindowCompactionStrategy', 'compaction_window_size': '60', 'compaction_window_unit': 'MINUTES'}
    AND compression = {'sstable_compression': 'org.apache.cassandra.io.compress.LZ4Compressor'}
    AND crc_check_chance = 1.0
    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';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant