cassandra-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Darwin Airola (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (CASSANDRA-12463) Unable to create Materialized View on UDT fields saeperately
Date Fri, 21 Oct 2016 02:20:58 GMT

    [ 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)

Mime
View raw message