-
Language:
English
-
Language:
English
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;