[jira] [Commented] (CASSANDRA-12463) Unable to create Materialized View on UDT fields saeperately

["Mohan (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/CASSANDRA-12463?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16404256#comment-16404256 ] 

Mohan commented on CASSANDRA-12463:
-----------------------------------

Any update on this request and am really in need of some solution.. My current project is expected to do something like this. 

Created the UDT and being used in a table.  

On top of it, would like to create the Materialized View with some filter based on type.  

Please advise whether this is possible in Cassandra 

Thanks in Advance

Mohan

> 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
(v7.6.3#76005)

---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@cassandra.apache.org
For additional commands, e-mail: commits-help@cassandra.apache.org