Low Description
When creating a secondary index on a map type, for keys, the DESC TABLE output does not create correct DDL (it omits the keys part). So if someone uses describe to recreate a schema they could end up with a values index instead of a keys index.
First, create a table and add an index:
CREATE TABLE test.foo (
id1 text,
id2 text,
categories map<text, text>,
PRIMARY KEY (id1, id2));
create index on foo(keys(categories));|
Now DESC TABLE and you'll see the incomplete index DDL:
CREATE TABLE test.foo (
id1 text,
id2 text,
categories map<text, text>,
PRIMARY KEY (id1, id2)
) WITH CLUSTERING ORDER BY (id2 ASC)
.......................snip..............................................
CREATE INDEX foo_categories_idx ON test.foo (categories);