[
https://issues.apache.org/jira/browse/CASSANDRA-7814?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14368595#comment-14368595
]
Stefania commented on CASSANDRA-7814:
-------------------------------------
[~jbellis]:
\\
\\
* We can add {{DESCRIBE INDEX <table_name> <idx_name>}} which will output the
index CQL. Is this all that's required? To omit the table name would probably
require a change in the python driver as it currently attaches the index
metadata to the tables. If we speficy the table name we should be able to only
change cqlsh.
* Note that {{DESCRIBE TABLE <table_name>}} already outputs the indexes CQL, at
least in 3.0:
\\
{code}
cqlsh:test> DESCRIBE TABLE users;
CREATE TABLE test.users (
user_id text PRIMARY KEY,
age int,
first_name text,
last_name text
) WITH bloom_filter_fp_chance = 0.01
AND caching = '{"keys":"ALL", "rows_per_partition":"NONE"}'
AND comment = ''
AND compaction = {'min_threshold': '4', 'class':
'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy',
'max_threshold': '32'}
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';
CREATE INDEX age_idx ON test.users (age);
{code}
* Are you happy with the fix in 3.0 only or do you want it in 2.1 or 2.0 as
well?
> enable describe on indices
> --------------------------
>
> Key: CASSANDRA-7814
> URL: https://issues.apache.org/jira/browse/CASSANDRA-7814
> Project: Cassandra
> Issue Type: Improvement
> Components: Core
> Reporter: radha
> Assignee: Stefania
> Priority: Minor
> Fix For: 3.0
>
>
> Describe index should be supported, right now, the only way is to export the
> schema and find what it really is before updating/dropping the index.
> verified in
> [cqlsh 3.1.8 | Cassandra 1.2.18.1 | CQL spec 3.0.0 | Thrift protocol 19.36.2]
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
