Cannot use Hive 2 connection using beeline

[#1]

Hi all,

I'm trying to connect to HiveServer2 using beeline and using the information from Ambari:

Connected to: Apache Hive (version 1.2.1000.2.6.2.14-5)
Driver: Hive JDBC (version 1.2.1000.2.6.2.14-5)
Transaction isolation: TRANSACTION_REPEATABLE_READ
Beeline version 1.2.1000.2.6.2.14-5 by Apache Hive

Why is still using Hive version 1.2 ?

Many thanks in advance,

Jorge.

[#2 · Accepted solution]

@Jorge Florencio

We used Hive 2 currently for LLAP functionality, and Hive 1 for Hive on Tez. If you enable "Interactive Query" in the Configs tab you'll see the following output when you connect via Beeline.

Let me know if there is a particular reason you want to use Hive 2.

Connected to: Apache Hive (version 2.1.0.2.6.4.0-91)
Driver: Hive JDBC (version 1.2.1000.2.6.4.0-91)
Transaction isolation: TRANSACTION_REPEATABLE_READ

[#3]

Hi @anarasimham,

after enabling interactive query we can use Hive 2.1.

Hive users were asking for this feature because they needed to use Hive 2.1 syntax in their queries.

Many thanks for your help,

Jorge.