Red Hat Training

A Red Hat training course is available for Red Hat JBoss Data Virtualization

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.
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;