Rocco Varela created CASSANDRA-15908:
----------------------------------------
Summary: Improve messaging on indexing frozen collections
Key: CASSANDRA-15908
URL: https://issues.apache.org/jira/browse/CASSANDRA-15908
Project: Cassandra
Issue Type: Improvement
Components: CQL/Semantics
Reporter: Rocco Varela
Assignee: Rocco Varela
When attempting to create an index on a frozen collection the error message
produced can be improved to provide more detail about the problem and possible
workarounds. Currently, a user will receive a message indicating "...Frozen
collections only support full() indexes" which is not immediately clear for
users new to Cassandra indexing and datatype compatibility.
Here is an example:
{code}
cqlsh> CREATE KEYSPACE test WITH replication = \{'class': 'SimpleStrategy',
'replication_factor': 1};
cqlsh> CREATE TABLE test.mytable ( id int primary key, addresses
frozen<set<text>> );
cqlsh> CREATE INDEX mytable_addresses_idx on test.mytable (addresses);
InvalidRequest: Error from server: code=2200 [Invalid query] message="Cannot
create values() index on frozen column addresses. Frozen collections only
support full() indexes"\{code}
I'm proposing possibly enhancing the messaging to something like this.
{quote}
Cannot create values() index on frozen column addresses. Frozen collections
only support indexes on the entire data structure due to immutability
constraints of being frozen, wrap your frozen column with the full() target
type to index properly.
{quote}
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@cassandra.apache.org
For additional commands, e-mail: commits-h...@cassandra.apache.org
