Apache Hive Cookbook

Configuring HCatalog

Assuming that Hive has been configured in the remote metastore, let's look into how to install and configure HCatalog.

Getting ready

The HCatalog CLI supports these command-line options:

Option	Usage	Description
-g	hcat -g mygrp	The HCatalog table, which needs to be created, must have the group "mygrp".
-p	hcat -p rwxrwxr-x	The HCatalog table, which needs to be created, must have permissions "rwxrwxr-x".
-f	hcat -f myscript.hcat	Tells HCatalog that myscript.hcat is a file containing DDL commands to execute.
-e	hcat -e 'create table mytable(a int);'	Treat the following string as a DDL command and execute it.
-D	hcat -Dkey=value	Pass the key-value pair to HCatalog as a Java System Property.
	Hcat	Prints a usage ...