Page History

hive.metastore.local

false

javax.jdo.option.ConnectionURL

jdbc:mysql://hostname/hivemetastoredb?createDatabaseIfNotExist=true
where hostname is the name of the machine you installed MySQL on.

javax.jdo.option.ConnectionDriverName

com.mysql.jdbc.Driver

javax.jdo.option.ConnectionUserName

hive

javax.jdo.option.ConnectionPassword

dbpassword value you used in setting up the MySQL server above.

hive.semantic.analyzer.factory.impl

org.apache.hcatalog.cli.HCatSemanticAnalyzerFactory

hive.metastore.warehouse.dir

The directory can be a URI or an absolute file path. If it is an absolute file path, it will be resolved to a URI by the metastore:
– If default hdfs was specified in core-site.xml, path resolves to HDFS location.
– Otherwise, path is resolved as local file: URI.
This setting becomes effective when creating new tables (it takes precedence over default DBS.DB_LOCATION_URI at the time of table creation).
You only need to set this if you have not yet configured Hive to run on your system.

hive.metastore.uris

thrift://hostname:portnum where hostname is the name of the machine hosting the Thrift server, and portnum is the port number used above in the installation script.

hive.metastore.execute.setugi

true

hive.metastore.sasl.enabled

Set to true if you are using Kerberos security with your Hadoop cluster, false otherwise.

hive.metastore.kerberos.keytab.file

The path to the Kerberos keytab file containing the metastore Thrift server's service principal. Only required if you set hive.metastore.sasl.enabled above to true.

hive.metastore.kerberos.principal

The service principal for the metastore Thrift server. You can reference your host as _HOST and it will be replaced with your actual hostname. Only required if you set hive.metastore.sasl.enabled above to true.