Repository: cassandra Updated Branches: refs/heads/trunk 80c51c03b -> 5f83f6c29
Fix MV doc formatting in CQL.textile Project: http://git-wip-us.apache.org/repos/asf/cassandra/repo Commit: http://git-wip-us.apache.org/repos/asf/cassandra/commit/4d0f1405 Tree: http://git-wip-us.apache.org/repos/asf/cassandra/tree/4d0f1405 Diff: http://git-wip-us.apache.org/repos/asf/cassandra/diff/4d0f1405 Branch: refs/heads/trunk Commit: 4d0f1405cb9678d56393bd1e785c755c4eab0e2b Parents: fe043b6 Author: Tyler Hobbs <[email protected]> Authored: Thu Dec 31 15:33:08 2015 -0600 Committer: Tyler Hobbs <[email protected]> Committed: Thu Dec 31 15:33:08 2015 -0600 ---------------------------------------------------------------------- doc/cql3/CQL.textile | 7 ++++--- 1 file changed, 4 insertions(+), 3 deletions(-) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/cassandra/blob/4d0f1405/doc/cql3/CQL.textile ---------------------------------------------------------------------- diff --git a/doc/cql3/CQL.textile b/doc/cql3/CQL.textile index e323768..8e043d9 100644 --- a/doc/cql3/CQL.textile +++ b/doc/cql3/CQL.textile @@ -496,23 +496,24 @@ h3(#createMVStmt). CREATE MATERIALIZED VIEW __Syntax:__ -bc(syntax).. +bc(syntax).. <create-table-stmt> ::= CREATE MATERIALIZED VIEW ( IF NOT EXISTS )? <viewname> AS SELECT ( '(' <identifier> ( ',' <identifier> ) * ')' | '*' ) FROM <tablename> WHERE ( <identifier> IS NOT NULL ( AND <identifier> IS NOT NULL )* )? PRIMARY KEY '(' <partition-key> ( ',' <identifier> )* ')' ( WITH <option> ( AND <option>)* )? +p. __Sample:__ -bc(sample).. +bc(sample).. CREATE MATERIALIZED VIEW monkeySpecies_by_population AS SELECT * FROM monkeySpecies WHERE population IS NOT NULL AND species IS NOT NULL PRIMARY KEY (population, species) WITH comment='Allow query by population instead of species'; -p. +p. The @CREATE MATERIALIZED VIEW@ statement creates a new materialized view. Each such view is a set of _rows_ which corresponds to rows which are present in the underlying, or base, table specified in the @SELECT@ statement. A materialized view cannot be directly updated, but updates to the base table will cause corresponding updates in the view. Attempting to create an already existing materialized view will return an error unless the @IF NOT EXISTS@ option is used. If it is used, the statement will be a no-op if the materialized view already exists.
