Create Index on UDT

[SathishKumar Alwar]

Hi,

I am new to C*, i am unable to create index on the fields in UDT (User Defined Type). While googling i came across it is not possible to create index on UDT fields individually and there were suggestions to create Materialized Views for these UDT individually. 

Table Schema

Employee

name text,

age int

Project project

UDT Schema

Project

code text,

name text,

startDate timestamp,

endDate timestamp

I want to create index on Project.code to retrieve employees based on Project code.

I tried creating Materialized Views and had no success. Could you please help me in achieving it.

create materialized view emp_view as select name,age,project.code,project.name  from employee primary key(name,project.code);

Thanks and Regards

A.SathishKumar

[Kevin Gallardo]

Hi, 

Indeed indexing on a UDT's single field is not supported in C* yet, please see https://issues.apache.org/jira/browse/CASSANDRA-6382 for more information.

Concerning MVs I just tried this : 

CREATE TYPE mytype (

    id int,

    value text

)

CREATE TABLE mytable (

    key int PRIMARY KEY,

    mytype frozen<mytype>,

    val text

)

And then creating a materialized view with the UDT (similar to what you've tried) : 

CREATE MATERIALIZED VIEW mv AS SELECT key, val, mytype.id, mytype.value FROM mytable WHERE key IS NOT NULL AND mytype IS NOT NULL PRIMARY KEY (key, mytype);

The error I get is the following :

[Invalid query] message="Cannot select out a part of type when defining a materialized view"

To me it seems that it is explicitly not supported as well in C*. Then it might be worth, if you prefer using a MV, to open a ticket on the Cassandra JIRA and check with the Cassandra team if that is possible.

Cheers.

--
You received this message because you are subscribed to the Google Groups "DataStax Java Driver for Apache Cassandra User Mailing List" group.
To unsubscribe from this group and stop receiving emails from it, send an email to java-driver-user+unsubscribe@lists.datastax.com.

--

Kévin Gallardo.

kgdo.me

Software Engineer in Drivers and Tools Team at DataStax.

 

[SathishKumar Alwar]

Hi Kevin,

Thanks for the prompt response. I have created

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

Thanks and Regards

A.SathishKumar