[ https://issues.apache.org/jira/browse/CASSANDRA-11602?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Jeremy Hanna updated CASSANDRA-11602: ------------------------------------- Component/s: Materialized Views > Materialized View Does Not Have Static Columns > ---------------------------------------------- > > Key: CASSANDRA-11602 > URL: https://issues.apache.org/jira/browse/CASSANDRA-11602 > Project: Cassandra > Issue Type: Bug > Components: Coordination, Materialized Views > Reporter: Ravishankar Rajendran > Assignee: Carl Yeksigian > Fix For: 3.0.6, 3.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.4.14#64029) --------------------------------------------------------------------- To unsubscribe, e-mail: commits-unsubscr...@cassandra.apache.org For additional commands, e-mail: commits-h...@cassandra.apache.org