[
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: [email protected]
For additional commands, e-mail: [email protected]
