hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Prasad Mujumdar <>
Subject Re: CLI, HiveServer2, Beeline
Date Fri, 28 Mar 2014 15:47:25 GMT
Hello Uber,

   Please see the comments inline.


On Fri, Mar 28, 2014 at 8:28 AM, Uber Slacker <> wrote:

> Hi folks. I'm trying to wrap my head around the latest Hive architecture
> (as of 0.12 at least). From what I've gathered:
> - HiveServer2 is the new Thrift based Hive server.
> - We can use Thrift, JDBC, and ODBC tools to connect to HiveServer2.
> - Beeline is an included CLI that connects to HiveServer2 via JDBC
> - HiveServer1 sounds like it is deprecated, though it's still available to
> run if you want.
> Are those understandings correct?
That's correct. Note that JDBC driver for HiveServer2 is part of Apache
Hive distribution. The ODBC is not. There are some third party ODBC driver
available that work with HiveServer2. You can find more details of clients
for HiveServer2 on the at

> Some questions I have:
> What about the original CLI? I was playing with a distribution and I'm
> still able to use the CLI.Will this be deprecated in favor of Beeline? Or
> will both be available going forward?
The original CLI is still available. In the last contributor meetup, there
was a discussion about deprecating both old HiveServer and CLI. It might
get deprecating in some future release, we are not sure.

> When would you use the CLI vs Beeline?

> Does the CLI require HiveServer1 to operate? My understanding is that it
> doesn't and that the CLI only works in embedded mode.
CLI can work in both embedded mode as well as a client to old HiveServer1.
Beeline has pretty much at feature parity of CLI. Beeline can also work as
an embedded Hive or as a thin client to HiveServer2.
At this point you should be able to use Beeline as a command line tool for
all Hive use cases.

> Thanks much for any info!

View raw message