Creating Models › Creating a Physical Model › Indexes › Table Index Editor › Define Hive Table Index Properties

Define Hive Table Index Properties

Use the Hive Table Index Editor to specify properties for a table index in a physical model. For more information about these properties, see your Hive documentation.

To define Hive table index properties

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

   The Hive Table Index Editor opens.

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

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

4. Work with the following options:

   Table

   Displays the table to which the selected table index belongs.

   Previous

   Positions the editor on the previous table index in the Navigation Grid.

   Next

   Positions the editor on the next table index in the Navigation Grid.

   Sort

   Sorts the table indexes by alphabetic, reverse alphabetic, or index order. You select the method you want using the drop-down menu that opens after you click the Sort button.

   New

   Creates a new table index that becomes the current object in the editor.

   Delete

   Deletes the selected table index.

   Help

   Accesses online help for the editor.

   

   Lets you enter text to filter a large list of table index objects so you can quickly locate the one that you want.

   Show FK Indexes

   Specifies to display FK (foreign key) indexes in the Navigation Grid.

   Physical Name

   Displays the physical name of the table index.

   Type

   Displays the table index type.

   Physical Only

   Specifies whether to have the index appear in the physical model only. If you want the index to appear in the logical model as a key group, clear the check box.

   Note: This option is unavailable when a primary or foreign key index is selected.

   Generate

   Generates SQL during forward engineering. Clear the check box if you do not want to generate SQL.

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

   Index Members

   Specifies the columns for the table that have the index and are key group members. You can select any column to be a key group member. The columns can be sorted.

6. Click the Options tab and work with the following options:

   Deferred Rebuild

   Indicates that the newly created index is initially empty (regardless of whether the table contains any data).

   Index Type

   Specifies the type of index that you want to create. In other words, it specifies the Hive index class handler.

   Index Properties

   Lets you specify additional table properties.

   Index Table Name

   Hive allows you to store an index as a table. This property specifies the name of the table in which the index will be stored. If not specified, a Hive default name will be used.

   Location

   Indicates that a specific distributed file system directory must be used to store data files.

   Table Properties

   Lets you specify additional table properties.

7. Click the Storage tab and work with the following options:

   Fields Terminated By

   Specifies a delimiter for structure fields. You can include any single character, but the default is '\001'.

   Fields Escaped By

   Specifies the escape sequence.

   Collection Items Terminated By

   Specifies a delimiter for array items. You can include any single character, but the default is '\002'.

   Map Keys Terminated By

   Specifies a delimiter for map keys. You can include any single character, but the default is '\003'.

   Lines Terminated By

   Specifies a delimiter for map keys. You can include any single character, but the default is '\n'.

   Null Defined As

   Specifies a custom NULL format apart from the Stored As options mentioned above.

   Serde Handler Class

   Specifies the name of a Java class that implements the Hive SerDe interface.

   Stored As

   Specifies the type of file in which data is to be stored. The file can be a TEXTFILE, SEQUENCEFILE, RCFILE, or BINARY SEQUENCEFILE.

   Input Format

   Lets you specify your own Java class if you want Hive to read from a different file format. The value of this property depends on the Stored As value.

   Output Format

   Lets you specify your own Java class if you want Hive to write to a different file format. The value of this property depends on the Stored As value.

   Stored By

   Specifies the name of a Java class that implements the Hive StorageHandler interface.

   Serde Properties

   Specifies SerDe properties to be associated with the storage handler class.

8. (Optional) Click the Comment tab and enter any comments that you want to associate with the object.
9. (Optional) Click the Where Used tab to view where the object is used within the model.
10. (Optional) Click the UDP tab to work with user-defined properties for the object.
11. (Optional) Click the Notes tab to view and edit user notes.
12. (Optional) Click the Extended Notes tab to view or edit user notes.
13. Click Close.

    The Hive Table Index Editor closes.