cassandra-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Ravishankar Rajendran (JIRA)" <j...@apache.org>
Subject [jira] [Created] (CASSANDRA-11602) Materialized View Doest Not have Static Columns
Date Tue, 19 Apr 2016 03:11:25 GMT
Ravishankar Rajendran created CASSANDRA-11602:
-------------------------------------------------

             Summary: 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
             Fix For: 3.4


{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