Creating Models › Target Servers for Physical Models › Database Property Editors › Hive Physical Property Editors › Hive Support Summary › Define Hive Databases

Define Hive Databases

Use the Hive Database Editor for the following tasks:

• Create databases
• Define the files that are used to store an existing database
• Create a database snapshot
• Attach a database from the detached files of an existing detached database
• Define database properties in a Hive physical model

To define a database in Hive

1. In the Model Explorer, right-click Databases and click New.

   An instance of Database is created.

2. Right-click the instance and click Properties.

   The Hive Database Editor opens.

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

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

   Name

   Specifies the name of the database. Set the name of the database in this field.

   Generate

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

4. On the General tab, work with the following options:

   Location

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

   DB Properties

   Lets you specify additional user-defined table properties.

   Owner Role

   Specifies the owner of the database. Select an owner from the drop-down list or click New to create one.

   Owner User

   Specifies the user of the database. Select a user from the drop-down list or click New to create one.

5. (Optional) Click the Comment tab and enter any comments that you want to associate with the object.
6. (Optional) Click the UDP tab to work with user-defined properties for the object.
7. (Optional) Click the Notes tab to view and edit user notes.
8. (Optional) Click the Extended Notes tab to view or edit user notes.
9. Click Close.

   The database is defined and the Hive Database Editor closes.

For more information, refer to Hive documentation.