cassandra-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Carl Yeksigian (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (CASSANDRA-11602) Materialized View Doest Not Have Static Columns
Date Mon, 02 May 2016 20:25:12 GMT

     [ https://issues.apache.org/jira/browse/CASSANDRA-11602?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Carl Yeksigian updated CASSANDRA-11602:
---------------------------------------
       Resolution: Fixed
         Reviewer: Sylvain Lebresne
    Fix Version/s:     (was: 3.0.x)
                       (was: 3.x)
                   3.0.6
                   3.6
           Status: Resolved  (was: Ready to Commit)

Thanks for the review, [~slebresne]. The validation has been committed in [6d725af|https://git-wip-us.apache.org/repos/asf?p=cassandra.git;a=commit;h=6d725afaef5bc8604cf775ff2498f21530c0288c],
with pulling that variable out.

> Materialized View Doest Not Have Static Columns
> -----------------------------------------------
>
>                 Key: CASSANDRA-11602
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-11602
>             Project: Cassandra
>          Issue Type: Bug
>            Reporter: Ravishankar Rajendran
>            Assignee: Carl Yeksigian
>             Fix For: 3.6, 3.0.6
>
>
> {quote}
> CREATE TABLE "team" (teamname text, manager text, location text static, PRIMARY KEY ((teamname),
manager));
> INSERT INTO team (teamname, manager, location) VALUES ('Red Bull1', 'Ricciardo11', 'Australian');
> INSERT INTO team (teamname, manager, location) VALUES ('Red Bull2', 'Ricciardo12', 'Australian');
> INSERT INTO team (teamname, manager, location) VALUES ('Red Bull2', 'Ricciardo13', 'Australian');
> select * From team;
> CREATE MATERIALIZED VIEW IF NOT EXISTS "teamMV" AS SELECT "teamname", "manager", "location"
FROM "team" WHERE "teamname" IS NOT NULL AND "manager" is NOT NULL AND "location" is NOT NULL
PRIMARY KEY("manager", "teamname");  
> select * from "teamMV";
> {quote}
> The teamMV does not have "location" column. Static columns are not getting created in
MV.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message