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 message.

How to do it...

Hive 0.11.0 HCatalog is packaged with Hive binaries. Because we have already configured Hive, we could access the HCatalog command-line hcat command on shell. The script is available at the hcatalog/bin directory.