Your question is missing a "what". What do you want to know the default of?

If you are asking for the key_validation_class of the Index CF, then it's
the column type that defines it. If you're asking about the index CF
comparator, then in that example it would use a comparator that sorts like
your partitioner (so if you say use the RandomPartitioner, the comparator
will sort by md5).

And no, none of those can be changed (it would make no sense for the
key_validation_class, as for the comparator, the 2ndary index
implementation relies pretty much by design on the ordering being the one
of the partitioner).

--
Sylvain


On Mon, Jan 28, 2013 at 11:57 AM, Alan Ristić <alan.ris...@gmail.com> wrote:

> I'm just curious for C* v1.2..
>
> a) Does automatic secondary INDEX CF defaults to primary CF
> key_validation_class<http://www.datastax.com/docs/1.2/configuration/storage_configuration#key-validation-class>
>  ('user_id' in example) or it decides by column type (varchar in 'email'
> case) what key_validation_class should be ?
> *I suppose it defaults.*
>
> example:
> CREATE TABLE users (
>   user_id uuid PRIMARY KEY,
>   created_at timestamp,
>   email varchar,
>   ...
> ) WITH
>      comment='Registered user';
>
> CREATE INDEX ON users (email);
>
> *b) And if yes can it be changed on CREATE INDEX? *
> *I suppose no.*
>
> ps: I know that sec. index in example is not optimal ;)
>
> Tnx,
> *Alan Ristić*
>
>  *t*: @alanristic <http://twitter.com/alanristic>
> *m*: 040 423 688
>

Reply via email to