Support Questions

Find answers, ask questions, and share your expertise

Cannot use Hive 2 connection using beeline

avatar
Contributor

Hi all,

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

73439-hive2-ambari.jpg

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.

1 ACCEPTED SOLUTION

avatar
Super Collaborator
@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

View solution in original post

2 REPLIES 2

avatar
Super Collaborator
@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

avatar
Contributor

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.