HCatalog Alter Table This post descibes, how to alter the attributes of a table such as changing its table name, changing column names, adding columns, and deleting or replacing columns. Step 1 – Open a new terminal (CTRL + ALT + T) and Change the directory to /usr/local/hive/hcatalog/bin

Step… Continue Reading HCatalog Alter Table

HCatalog Script This post descibes how to create hcatalog script and execute it. HCatalog scripts are having .hcatalog extension Step 1 – Open a new terminal (CTRL + ALT + T) and Change the directory to /usr/local/hive/hcatalog/bin

Step 2 – Create a new myscript.hcatalog hcatalog script. The extension of… Continue Reading HCatalog Script

Creating Table in HCatalog This post describes, how to create a table. Step 1 – Open a new terminal (CTRL + ALT + T) and Change the directory to /usr/local/hive/hcatalog/bin

Step 2 – Creating a new employee table

Step 3 – Check whether it is created or not.… Continue Reading HCatalog Creating Table

HCatalog Command Line Interface (CLI) Usage HCatalog Command Line Interface (CLI) can be invoked from the command $HIVE_HOME/HCatalog/bin/hcat where $HIVE_HOME is the home directory of Hive. hcat is a command used to initialize the HCatalog server. Step 1 – Open a new terminal (CTRL + ALT + T) and Change… Continue Reading HCatalog Command Line Interface (CLI) Usage

Pre Requirements 1) A machine with Ubuntu 14.04 LTS operating system installed. 2) Apache Hive 2.1.0 Pre Installed NOTE 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… Continue Reading HCatalog Installation

< HBase Client java API This post describes the java client API for HBase that is used to perform CRUD operations on HBase tables Step 1 – Edit $HOME/.bashrc file by adding the java and hadoop path.

$HOME/.bashrc file. Add the following line

Step 2 Reload your changed… Continue Reading HBase Client java API

HBase Admin Java API HBase is written in java, therefore it provides java API to communicate with HBase. Java API is the fastest way to communicate with HBase. Step 1 – Edit $HOME/.bashrc file by adding the java and hadoop path.

$HOME/.bashrc file. Add the following line

Step… Continue Reading HBase Admin Java API

HBase Create, Retreive, Update, Delete (CRUD) operation Step 1 – Change the directory to /usr/local/hbase

Step 2 – To start up the initial HBase cluster.

Creating Table

Inserting Data into Table

View or Scan

Update

Verify or Scan

Retrieve

Delete

Continue Reading HBase Create, Retreive, Update, Delete (CRUD) operation