[
https://issues.apache.org/jira/browse/CASSANDRA-12463?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15593711#comment-15593711
]
Darwin Airola commented on CASSANDRA-12463:
-------------------------------------------
It would also be really nice to have something like these:
CREATE TYPE xtype (
id timeuuid,
v1 double,
v2 double);
CREATE TABLE thetable (
id timeuuid PRIMARY KEY,
val text,
xtype xtype);
and be able to create a materialized view like this:
CREATE MATERIALIZED VIEW mv AS SELECT id, xtype.v1, xtype.v2 FROM thetable
WHERE id IS NOT NULL AND xtype.v1 IS NOT NULL AND xtype.v2 IS NOT NULL PRIMARY
KEY (id, v1, v2);
Might that ever be an option?
> 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
> 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.3.4#6332)
