You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@cassandra.apache.org by ty...@apache.org on 2015/12/31 22:33:19 UTC
cassandra git commit: Fix MV doc formatting in CQL.textile
Repository: cassandra
Updated Branches:
refs/heads/cassandra-3.0 fe043b631 -> 4d0f1405c
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/cassandra-3.0
Commit: 4d0f1405cb9678d56393bd1e785c755c4eab0e2b
Parents: fe043b6
Author: Tyler Hobbs <ty...@gmail.com>
Authored: Thu Dec 31 15:33:08 2015 -0600
Committer: Tyler Hobbs <ty...@gmail.com>
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.