Hive session not responding

Lab Support
#1

Hi,
When I execute below command, the entire session becomes unresponsive.

Connected to: Apache Hive (version 1.2.1000.2.6.5.0-292)
Driver: Hive JDBC (version 1.2.1000.2.6.5.0-292)
Transaction isolation: TRANSACTION_REPEATABLE_READ
0: jdbc:hive2://> set hive.exec.dynamic.partition=true;
No rows affected (0.048 seconds)

#2

For me this seems to be working fine for me.

#3

Hi Admins,

Can you please help here !!

#4

Hi @sayandeepde89,

Can you please let me know what problem are you facing in Hive?

#5

Hi @abhinavsingh ,

After I login to hive using !connect jdbc:hive2:// , if I set any hive property in the current session , for eg
0: jdbc:hive2:// > set hive.exec.dynamic.partition=true;

It shows No rows affected (0.048 seconds) , and then I do not get any prompt (0: jdbc:hive2:// >) to submit queries.

#7

In CloudXLab can we connect to Hive2 using JDBC?

#8

Yes. you can connect using JDBC driver to Hive2.

#9

it is happening for me as well
beeline> !connect jdbc:hive2://

Connecting to jdbc:hive2://

Enter username for jdbc:hive2://: ****

Enter password for jdbc:hive2://: ********

Connected to: Apache Hive (version 1.2.1000.2.6.5.0-292)

Driver: Hive JDBC (version 1.2.1000.2.6.5.0-292)

Transaction isolation: TRANSACTION_REPEATABLE_READ

0: jdbc:hive2://> set hive.execution.engine=tez;

No rows affected (0.056 seconds)