[ 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)