[ https://issues.apache.org/jira/browse/CASSANDRA-12463?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16129050#comment-16129050 ]
Ravi Pillala commented on CASSANDRA-12463: ------------------------------------------ Any update on this request? > Unable to create Materialized View on UDT fields saeperately > ------------------------------------------------------------ > > Key: CASSANDRA-12463 > URL: https://issues.apache.org/jira/browse/CASSANDRA-12463 > Project: Cassandra > Issue Type: Improvement > Components: Materialized Views > Reporter: SathishKumar Alwar > Priority: Minor > > We are unable to create index on UDT fields individually and there were > suggestions/recommendations to create Materialized Views for these UDT > individually. Unfortunately we are unable to create Materialized Views by > providing part of UDT fields. > It would be better if indexing is supported on UDT fields, if not possible > providing support in Materialized View will be helpful. We want support on > non frozen as well as frozen UDT. > Example: > 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 > 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" -- This message was sent by Atlassian JIRA (v6.4.14#64029) --------------------------------------------------------------------- To unsubscribe, e-mail: commits-unsubscr...@cassandra.apache.org For additional commands, e-mail: commits-h...@cassandra.apache.org