Creating Models › Creating a Physical Model › Columns › Defining Table Column Properties for Target Databases › Define Hive Table Column Properties

Define Hive Table Column Properties

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

Note: The options described here are the basic options available for most physical data types. These options may vary depending on the physical data type you assign to the table column. Refer to Hive documentation for more information on using these properties.

To define Hive table column properties

1. Right-click a table column in the Model Explorer and click Properties.

   The Hive Table Column Editor opens.

2. Select the table from the Table drop-down that contains the column that you want to define.
3. Select the column in the Navigation Grid that you want to define.

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

4. Click the General tab and work with the following options:

   Domain Parent

   Displays the current parent domain. Use the toolbar to sort the domain list or open the Domain Editor to work with domains.

   Physical Name

   Displays the physical column name. You can change the column name in this field using in-place editing.

   Physical Data Type

   Specifies the physical data type for the column. You can change the data type using the drop-down. The drop-down list contains the data types related to the current domain.

   Null Option

   Displays the attribute null option. Change the null option using the drop-down control. You can also click the Inheritance button to either inherit or override the attribute's null option. This button changes to provide you with a visual cue of the current inheritance setting for the attribute null option.

5. Click the Hive tab and work with the following options:

   Number of Distinct Values

   Indicates the number of distinct values that the selected column holds.

   Number of Null Values

   Indicates the number of null values that the selected column holds.

   Average Column Size

   Indicates the average length of the column with respect to the number of characters in column values.

   Physical Data Type Expression

   Specifies the expression for the data type to be applied to the selected column.

6. (Optional) Click the Link tab and work with the Link Wizard to link selected columns and to select the properties to synchronize between the linked objects.
7. (Optional) Click the Indexes tab and define the index membership details for the column.
8. (Optional) Click the Constraint tab and specify the validation rule and default value for the column.
9. (Optional) Click the Style tab and format the font and other graphical themes used in the display of the columns.
10. (Optional) Click the History tab to view the history information for the entity.
11. (Optional) Click the Comment tab and enter any comments that you want to associate with the object.
12. (Optional) Click the Where Used tab to view where the object is used within the model.
13. (Optional) Click the UDP tab to work with user-defined properties for the object.
14. (Optional) Click the Notes tab to view and edit user notes.
15. (Optional) Click the Extended Notes tab to view or edit user notes.
16. Click Close.

    The table column properties are defined and the Hive Table Column Editor closes.

For more information, refer to Hive documentation.