12.4. Table Options

You can use the following options when creating a table or view. See "create table body" in Section A.7, “Productions”. Any others properties defined will be considered as extension metadata.

Expand

Property	Data Type or Allowed Values	Description
UUID	string	Unique identifier for View
MATERIALIZED	'TRUE'\|'FALSE'	Defines if a table is materialized
MATERIALIZED_TABLE	'table.name'	If this view is being materialized to a external database, this defines the name of the table that is being materialized to
CARDINALITY	int	Costing information. Number of rows in the table. Used for planning purposes
UPDATABLE	'TRUE'\|'FALSE'	Defines if the view is allowed to update or not
ANNOTATION	string	Description of the view

Example 12.3. Example:Create View Table(Created on VIRTUAL model)

CREATE VIEW CustomerOrders (name varchar(50),  saledate date, amount decimal) OPTIONS (CARDINALITY 100, ANNOTATION 'Example')
  AS
  SELECT concat(c.firstname, c.lastname) as name, o.saledate as saledate, o.amount as amount FROM Customer C JOIN Order o ON c.id = o.customerid;

CREATE VIEW CustomerOrders (name varchar(50),  saledate date, amount decimal) OPTIONS (CARDINALITY 100, ANNOTATION 'Example')
  AS
  SELECT concat(c.firstname, c.lastname) as name, o.saledate as saledate, o.amount as amount FROM Customer C JOIN Order o ON c.id = o.customerid;

Copy to Clipboard

Toggle word wrap

トップに戻る

このコンテンツは選択した言語では利用できません。

12.4. Table Options

詳細情報

試用、購入および販売

コミュニティー

Red Hat ドキュメントについて

多様性を受け入れるオープンソースの強化

会社概要

Theme

Red Hat legal and privacy links

Red Hat legal and privacy links