...
Now you need to edit your hive_home/conf/hive-site.xml
file. If there is no such file in the hive conf directory, copy hcat_home/etc/hcatalog/proto-hive-site.xml
and rename it hive-site.xml
in hive_home/conf/
. Open this file in your favorite text editor. The following table shows the values you need to configure. (For more information about Hive configuration parameters, see Configuring Hive and Hive Configuration Properties.)
Parameter | Value to Set It To |
---|---|
hive.metastore.local | false |
javax.jdo.option.ConnectionURL | jdbc:mysql://hostname/hivemetastoredb?createDatabaseIfNotExist=true |
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: |
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. |
...
Panel | ||||||
---|---|---|---|---|---|---|
| ||||||
Previous: Using HCatalog Hive documents: Configuring Hive, Hive Configuration Properties General: HCatalog Manual – WebHCat Manual – Hive Wiki Home – Hive Project Site |