8.3. Hive/HCat

This tab covers Hive and HCatalog settings. Here you can set properties for the Hive Metastore and database and related options. Click the name of the group to expand and collapse the display.


Table 3.10. Hive/HCat Settings: Hive Metastore


Hive Metastore host

The host that has been assigned to run the Hive Metastore

Hive Database

Check New MySQL Database to have Ambari create one for you or Existing MySQL Database to use an existing instance.

Database Type

MySQL is pre-populated

Database host

The FQDN of the host that has been assigned to run the database

Database name

The name for the database. Can be any legal name.

Database userThe username used to connect to the database

Database password

The password for accessing the Hive/HCatalog Metastore. This is a required property. You must type it in twice.


Table 3.11. Hive/HCat Settings: Advanced Settings


Hive PID dir

Directory for Hive process PID files

HCat log dir

Directory for HCatalog log files

HCat PID dir

Directory for HCatalog process PID files


Whether to connect to remove a metastore server or open a new metastore server in the Hive Client JVM

javax.jdo.option. ConnectionDriverName

Driver class name for a JDBC metastore

hive.metastore.warehouse.dirThe location of the default database for the warehouse


Comma separated list of metastore object types that should be pinned in the cache

hive.semantic.analyzer.factory.implWhich Semantic Analyzer Factory implementation class is used by CLI
hadoop.clientside.fs.operationsIf FS operations are owned by the client
hive.metastore.client.socket.timeoutMetastore client socket timeout in seconds
hive.metastore.execute.setugiIn unsecure mode, setting this property to true causes the metastore to execute DFS operations using the client's reported user and group permissions. Note : this property must be set on both the client and server sides. This is a best effort property. If client is set to true and server is set to false, the client setting is ignored.
hive.security.authorization.enabledWhether hive client authorization is enabled
hive.security.authorization.managerThe class name of the hive client authorization manager. A user defined authorization class should implement the org.apache.hadoop.hive. ql.security.authorization. HiveAuthorizationProvider interface
Custom Hive ConfigsUse this text box to enter values for hive-site.xml properties not exposed by the UI. Enter in "key=value" format, with a newline as a delimiter between pairs.

loading table of contents...