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"
Parameter | Type | Description |
|---|---|---|
| Integer | The number of concurrent workers (connections) serving requests for metadata. |
| String | Specifies the name of the MD Store used internally. |
| String | Must be the same as the name of the gateway to which the user session connects. |
| String | Specifies the password for the connection to the MD Store table. |
| String | The database to which the user session connects. |
| String | Specifies the schema name of the MD Store table. |
| String | Specifies the MD Store table name. You must create this table before installing Hyper-Q. |
| String | Specifies the work table name. |