Reply
New Contributor
Posts: 2
Registered: ‎01-28-2016

Hive - Beeline Query Hangs

We are not able to execute any queries in Beeline. All of the jobs are just hanging. Even the simple "show databases; " command is hanging. Below is the result. First time use databases run properly, but second time it is hanging.


1: jdbc:hive2://xx.xxx.11.77:7183/> show databases;
+---------------------------+--+
| database_name |
+---------------------------+--+
| as_adventure |
| atscale_poc |
| default |
| mosc_dev_common |
| mosc_dev_datalake |
| mosc_dev_exctn_svis_hive |
| mosc_dev_ivis_secured |
| mosc_dev_landing |
| mosc_dev_outbound |
| mosc_dev_plng_ivis_hive |
| mosc_dev_plng_simp_hive |
| mosc_dev_plng_svis_hive |
| mosc_dev_svis |
| mosc_qa_common |
| mosc_qa_datalake |
| mosc_qa_ivis_secured |
| mosc_qa_landing |
| mosc_qa_outbound |
| mosc_qa_plng_ivis_hive |
| mosc_qa_test |
| planning_simp |
| stg_sap |
+---------------------------+--+
22 rows selected (0.159 seconds)
1: jdbc:hive2://xx.xxx.11.77:7183/>
1: jdbc:hive2://xx.xxx.11.77:7183/> show databases;

 

 

Thank you. 

Cloudera Employee
Posts: 34
Registered: ‎08-16-2016

Re: Hive - Beeline Query Hangs

Could you capture the thread stack during the hang and post the stack?
Thanks