Running Hive

Let's see how to run Hive from the command-line.

Getting ready

Once you have the binaries of Hive either compiled or downloaded, you need to configure a metastore for Hive where it keeps information about different entities. Once that is configured, start Hive metastore and HiveServer2 to access the entities from different clients.

How to do it...

Follow these steps to start different components of Hive on a node:

  1. Run Hive CLI:
    $HIVE_HOME/bin/hive
  2. Run HiveServer2 and Beeline:
    $HIVE_HOME/bin/hiveserver2
$HIVE_HOME/bin/beeline -u jdbc:Hive2://$HiveServer2_HOST:$HiveServer2_PORT
  3. Run HCatalog and start up the HCatalog server:
    $HIVE_HOME/hcatalog/sbin/hcat_server.sh
  4. Run the HCatalog CLI:
    $HIVE_HOME/hcatalog/bin/hcat
  5. Run WebHCat:
    $HIVE_HOME/hcatalog/sbin/webhcat_server.sh ...

Get Apache Hive Cookbook now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial