HCatalog 2.1.0 Installation on Ubuntu 14.04

posted on Nov 20th, 2016


Apache HCatalog is a table management layer that exposes Hive metadata to other Hadoop applications. HCatalog's table abstraction presents users with a relational view of data in the Hadoop Distributed File System (HDFS) and ensures that users need not worry about where or in what format their data is stored. HCatalog displays data from RCFile format, text files, or sequence files in a tabular view. It also provides REST APIs so that external systems can access these table's metadata.

HCatalog is built on top of the Hive metastore and incorporates components from the Hive DDL. HCatalog provides read and write interfaces for Pig and MapReduce and uses Hive's command line interface for issuing data definition and metadata exploration commands. It also presents a REST interface to allow external tools access to Hive DDL (Data Definition Language) operations, such as "create table" and "describe table".

Pre Requirements

1) A machine with Ubuntu 14.04 LTS operating system installed.

2) Apache Hive 2.1.0 Pre Installed (How to Install Hive on Ubuntu 14.04)


HCatalog's merge with Hive (in March of 2013) HCatalog is now released as part of Hive. Older versions of HCatalog can still be separately downloaded. Here we are using latest version of HCatalog merged with Hive.

Step 1 - Install Apache Hive first. (How to Install Hive on Ubuntu 14.04)

Step 2 - Edit $HOME/.bashrc file by adding the hcatalog path.

$ sudo gedit $HOME/.bashrc

$HOME/.bashrc file

$ export HCAT_HOME=$HIVE_HOME/hcatalog

Step 3 - Reload your changed $HOME/.bashrc settings

$ source $HOME/.bashrc

Step 4 - Change the directory to /usr/local/hive/hcatalog/bin

$ cd $HCAT_HOME/bin

Step 5 - Hcatalog command line interface (CLI).

$ ./hcat

HCatalog Installation on Ubuntu 14.04

Please share this blog post and follow me for latest updates on

facebook             google+             twitter             feedburner

Previous Post                                                                                          Next Post

Labels : HCatalog Command Line Interface (CLI) Usage   HCatalog Creating Table   HCatalog Script   HCatalog Load Operation   HCatalog Alter Table   HCatalog Drop Table   HCatalog Creating View and Index