Show TOC

Hadoop HiveLocate this document in the navigation structure

To create a PDM with support for features specific to the Hadoop Hive DBMS family, select the appropriate version in the DBMS field of the New Model dialog. To view these extensions to the PowerDesigner metamodel in the Resource Editor, select Start of the navigation path Database Next navigation step Edit Current DBMS End of the navigation path and expand the Profile node.

Note When working with PowerDesigner and Hadoop Hive, please bear in mind the following limitations:
  • Since Hadoop Hive is not a relational database, and does not support such concepts as primary and foreign keys, many of PowerDesigner's typical modeling features have no relevance when modeling Hive databases.
  • Hive has no system catalog, which limits PowerDesigner's reverse-engineering possibilities to the capabilities of your ODBC driver, and round-trip reverse-engineering and generation may not be possible.
Abstract Data Types

The following extensions are available on the General tab when you select Map in the Type box:

Name

Description

Value Data Type

Specifies the data type of the mapped value.

Scripting name: MappedDttpAttr
Columns

The following extensions are available on the General tab:

Name

Description

Partitioning column

Specifies if the column defines a partition.

Scripting name: PartitionColumn
Users (Databases)

The following extensions are available on the General tab:

Name

Description

HdfsPath

Specifies the path of database files.

Scripting name: HdfsPath

Database properties

Specifies the database properties.

Scripting name: DatabaseOptions
Views

The following extensions are available on the General tab:

Name

Description

Scope

Specifies if the view is available for all or only local session. Note: The local and global keywords are present for SQL standard compatibility, but have no effect in the database.

Scripting name: TemporaryScope

View properties

[N/A for Table As view] Specifies the view properties.

Scripting name: VTblProperties

The following extensions are available on the Options tab if you select the <<Table As>> stereotype on the General tab:

Name

Description

Block size

Specifies the size, in bytes, for each block in a table. The value must be between 8192 and 2097152 bytes, and be a multiple of 8192.

Scripting name: BlockSize

Append only

Specifies if the table must be created as an append-only table (TRUE) or as a regular heap-storage table (FALSE).

Scripting name: AppendOnly

OIDs

Specifies whether to assign object identifiers to rows. This box is unchecked by default.

Scripting name: OIds

Fill factor

Specifies the percentage that determines how full the index method will try to pack index pages.

Scripting name: FillFactor

Compression type

Specifies ZLIB (default) or QUICKLZ compression type.

Scripting name: CompressType

Level

For zlib compression of append-only tables, specifies a value between 1 (fastest compression) to 9 (highest compression ratio).

Scripting name: CompressLevel

Orientation

Set to column for column-oriented storage, or row (the default) for row-oriented storage.

Scripting name: Orientation

On commit

Specifies the behavior of temporary tables at the end of a transaction block.

Scripting name: OnCommit

Distributed by

Specifies the distribution policy for a table.

Scripting name: DistributedByColumns

In this section: