Skip to main content

Datometry Documentation

Metadata Store Configuration Parameters

The Metadata Store (MD Store) is where Hyper-Q persistently stores metadata information. This includes information about the database objects that cannot be natively stored in the target database's schema. For example, custom FORMAT strings, default column values, and SET and MULTISET semantics of a Teradata database table.

The metadata is stored in a pre-configured table, and is accessed at runtime when retrieving and updating object metadata. The metadata information is stored in the table mdstore_schema.MDSTORE_TBL for each database to which the user session connects.

"mdstore".mdstore_workers = 8
"mdstore".name = "MDSTORE"
"mdstore".gateway = "gateway"
"mdstore".user = "username"
"mdstore".password = "password"
"mdstore".database = "databasename"
"mdstore".mdstore_schema = "__DTM_MDSTORE"
"mdstore".mdstore_table = "MDSTORE_TBL"
"mdstore".mdstore_worktable = "MDSTORE_WRKTBL"
Table 8. MetaData Store Parameters

Parameter

Type

Description

mdstore_workers

Integer

The number of concurrent workers (connections) serving requests for metadata.

name

String

Specifies the name of the MD Store used internally.

gateway

String

Must be the same as the name of the gateway to which the user session connects.

password

String

Specifies the password for the connection to the MD Store table.

databasename

String

The database to which the user session connects.

mdstore_schema

String

Specifies the schema name of the MD Store table.

mdstore_table

String

Specifies the MD Store table name. You must create this table before installing Hyper-Q.

worktable

String

Specifies the work table name.