question Cannot use Hive 2 connection using beeline in Archives of Support Questions (Read Only)

Cannot use Hive 2 connection using beeline

jorge_florencio — Sun, 18 Aug 2019 08:09:15 GMT

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.

Re: Cannot use Hive 2 connection using beeline

anarasimham — Fri, 11 May 2018 19:31:52 GMT

@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

Re: Cannot use Hive 2 connection using beeline

jorge_florencio — Thu, 17 May 2018 22:00:10 GMT

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.