[
https://issues.apache.org/jira/browse/CASSANDRA-1709?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12975335#action_12975335
]
Eric Evans commented on CASSANDRA-1709:
---------------------------------------
bq. would there be a way to specify indexes at the time of CF creation? I'm
fine without it, but somehow it makes me think the grammar is incomplete.
I couldn't think of any that made sense to me. FWIW, the CLI handles this by
using a JSON-like dictionary to specify column metadata (including indexes),
which feels wrong to me.
So far, we've gone to a lot of trouble to be as SQLish as possible, so it's
worth pointing out that you can't create an index and table in one-shot either
(and I think this is OK).
bq. I'd prefer something more descriptive than "ADD" to specify adding an
index. "ADD INDEX" maybe? I suppose it depends on if we foresee the need to
'add' things other than indexes to a column family in the future (unicorns
maybe).
Sticking with the theme of being as SQL-like as reasonable, {{CREATE INDEX
...}} would the way to go, and I almost suggested that. What made me rethink
was that we still need a way to set the other metadata (like validation_class),
and I wasn't sure it was worth special-casing indexes.
> CQL keyspace and column family management
> -----------------------------------------
>
> Key: CASSANDRA-1709
> URL: https://issues.apache.org/jira/browse/CASSANDRA-1709
> Project: Cassandra
> Issue Type: Sub-task
> Components: API
> Affects Versions: 0.8
> Reporter: Eric Evans
> Priority: Minor
> Fix For: 0.8
>
> Original Estimate: 0h
> Remaining Estimate: 0h
>
> CQL specification and implementation for schema management.
> This corresponds to the following RPC methods:
> * system_add_column_family()
> * system_add_keyspace()
> * system_drop_keyspace()
> * system_update_keyspace()
> * system_update_columnfamily()
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
