[ https://issues.apache.org/jira/browse/CASSANDRA-12463?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Joshua McKenzie updated CASSANDRA-12463: ---------------------------------------- Issue Type: Improvement (was: Bug) > 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 > Reporter: SathishKumar Alwar > > 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.3.4#6332)