Relationships and Domains › Domains and Data Modeling › Domains in the Physical Model › Specifying Database-Specific Options For a Domain › Define Hive Domains

Define Hive Domains

In a model based on Hive target server, use the General tab in the Domain Editor to manage the data type, null option, and other properties for the selected domain.

Note: The options described here are the basic options available for most physical data types. There can be more options available depending on the physical data type you assign to the domain. For more information about using these properties, refer to Hive documentation.

To define a Hive domain

1. On the Model menu, click Domains.

   The Hive Domain Dictionary editor opens.

2. In the navigation grid, select the domain that you want to define and work with the following options:

   Note: Click New on the toolbar to create a domain. Use the Enter filter text box to filter a large list of domains to quickly locate the one that you want to define.

   Physical Name

   Specifies the physical name of the domain. Change the physical name of the domain in this field.

   Domain Parent

   Lets you select a domain from the list to attach it to the selected domain as a parent.

   Physical Data Type

   Lets you select a data type from the drop-down list to apply to the selected domain. If the selected data type requires a value for precision, scale, or both, enter the value inside the data type parentheses. For example, you can select the DECIMAL() data type and specify a precision of 2 and a scale of 10 inside the parentheses to assign the data type DECIMAL(2,10) to the selected domain.

   Schema

   Specifies the schema of the database to which the domain belongs. Select the schema from the drop-down list or click New to create one.

   Physical Only

   Specifies whether the domain is suppressed from a logical model and appears in a physical model only.

3. Work with other tabs in the editor to access additional domain features and click Close.

   The domain is defined and the Hive Domain Dictionary editor closes.

For more information on table properties, refer to Hive documentation.