Interacting with HIVE – CLI, GUI

Hive Command Line Interface (CLI) –

  • Interaction with Hive is commonly done with CLI
  • Hive CLI is started with the $HIVE_HOME/bin/hive command which is a bash script
  • Prompt for hive is  hive >
  • Using CLI , you can create tables, inspect schema and query tables
  • CLI is a thick client for Hive – it needs local copy of all Hive and Hadoop client components along with their configurations
  • It can work as a JDBC client , MapReduce client or HDFS client

Hive Graphical user Interface(GUI) Tools –

  1. Ambari – Provided by Hortonworks Distribution
  2. HUE – Provided by Cloudera Distribution
  3. QuBole
  4. Karmasphere

Share This Post

An Ambivert, music lover, enthusiast, artist, designer, coder, gamer, content writer. He is Professional Software Developer with hands-on experience in Spark, Kafka, Scala, Python, Hadoop, Hive, Sqoop, Pig, php, html,css. Know more about him at

Lost Password


24 Tutorials