Hive CLI vs Beeline

sreeviswa_athic — Thu, 31 Aug 2017 02:01:37 GMT

Hello Team,

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

Re: Hive CLI vs Beeline

dineshc — Thu, 31 Aug 2017 02:07:37 GMT

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).