Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Hive CLI vs Beeline

Solved Go to solution
Highlighted

Hive CLI vs Beeline

Expert Contributor

Hello Team,

Can some one please help me understand the comparison/difference between Hive CLI and beeline.

1 ACCEPTED SOLUTION

Accepted Solutions

Re: Hive CLI vs Beeline

@Viswa

Here are the 2 major aspects on which they differ:

1. Connection:

  • The Hive CLI, which connects directly to HDFS and the Hive Metastore, and can be used only on a host with access to those services.
  • Beeline, which connects to HiveServer2 and requires access to only one .jar file: hive-jdbc-<version>-standalone.jar.

2. Authentication

  • Hive CLI uses only Storage Based Authentication
  • Beeline uses SQL standard-based authorization or Ranger-based authorization. Thus greater security.

It is better to use Beeline for the above reasons than Hive CLI (I believe it will soon be deprecated).

Read here for greater understanding on beeline : https://docs.hortonworks.com/HDPDocuments/HDP2/HDP-2.6.1/bk_data-access/content/beeline-vs-hive-cli....

1 REPLY 1

Re: Hive CLI vs Beeline

@Viswa

Here are the 2 major aspects on which they differ:

1. Connection:

  • The Hive CLI, which connects directly to HDFS and the Hive Metastore, and can be used only on a host with access to those services.
  • Beeline, which connects to HiveServer2 and requires access to only one .jar file: hive-jdbc-<version>-standalone.jar.

2. Authentication

  • Hive CLI uses only Storage Based Authentication
  • Beeline uses SQL standard-based authorization or Ranger-based authorization. Thus greater security.

It is better to use Beeline for the above reasons than Hive CLI (I believe it will soon be deprecated).

Read here for greater understanding on beeline : https://docs.hortonworks.com/HDPDocuments/HDP2/HDP-2.6.1/bk_data-access/content/beeline-vs-hive-cli....

Don't have an account?
Coming from Hortonworks? Activate your account here