You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@cassandra.apache.org by "Mulert, Bill" <bi...@kroger.com> on 2015/01/14 21:49:21 UTC

create index on column of user defined type?

Although I have not seen any documentation that says one cannot do this, version 2.1.2 is complaining about defining one.

CREATE TYPE wdm.thing (
       thing_name                 text,
                ...

CREATE TABLE wdm.ctins (
       foo_no                     text,
       item                        frozen<thing>,
       ...


CREATE INDEX foo ON wdm.gtins(item.thing_name);

Is there something I'm missing or is this truly disallowed?



________________________________

This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain information that is confidential and protected by law from unauthorized disclosure. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.

Re: create index on column of user defined type?

Posted by Michael Shuler <mi...@pbandjelly.org>.

On 01/14/2015 02:49 PM, Mulert, Bill wrote:
> Although I have not seen any documentation that says one cannot do this,
> version 2.1.2 is complaining about defining one.
>
> CREATE TYPE wdm.thing (
>
>         thing_name _text_,
>
>                  …
>
> CREATE TABLE wdm.ctins (
>
>         foo_no                     text,
>
> _item_                        frozen_<thing>_,
>
>         ...
>
> CREATE INDEX foo ON wdm.gtins(item.thing_name);
>
> Is there something I’m missing or is this truly disallowed?

I believe this is planned for 3.0.

   https://issues.apache.org/jira/browse/CASSANDRA-6382

-- 
Michael