SELECT (View)

Get record(s) from the specified view. The fields to get have to be already in the view. It produces static record(s) and costs little time.

Synopsis

SELECT <* | column_name [AS field_alias] [, ...]>
  FROM view_name
  [ WHERE search_condition ];

Notes

Selecting from a view is a very fast operation that takes advantage of the concept of a view. So it has a more restricted syntax than selecting from a stream:

• The most important difference between SELECT from a stream and from a view is that the former has an EMIT CHANGES clause and the latter does not.
• SELECT clause can only contain * or column names with/without aliases. Other ones such as constants, arithmetical expressions, aggregate/scalar functions, etc. are not allowed. And the column names should be in the SELECT clause of the query when creating the corresponding view. If a column name contains function names, use the raw column name by back quotes (`). See Special Characters.
• FROM clause can only contain ONE view name.

Examples

// Assume that this query has been executed successfully before
// CREATE VIEW my_view AS SELECT a, b, SUM(a), COUNT(*) AS cnt FROM foo GROUP BY b EMIT CHANGES;

SELECT `SUM(a)`, cnt, a FROM my_view WHERE b = 1;