Hive is not connecting

Hi Itversity Team,

I am unable to connect to Hive. Can you please check on the issue?

Practice hive on state of the art Big Data cluster -
You can sign up for our courses on Udemy using $10 coupons - Udemy Coupons - Big Data Courses

Following. Not able to use Hive metastore.

1 Like

Hi @Maninder_Singh, @Salma_Mahak,

Please go through below youtube link-

hive is slow i have run small query it has stopped…

hive> select count(*) from customers;
Query ID = salmamahak_20201013154312_b30f9756-70e3-4373-9f0a-c8f2278d523c
Total jobs = 1
Launching Job 1 out of 1
Number of reduce tasks determined at compile time: 1
In order to change the average load for a reducer (in bytes):
set hive.exec.reducers.bytes.per.reducer=
In order to limit the maximum number of reducers:
set hive.exec.reducers.max=
In order to set a constant number of reducers:
set mapreduce.job.reduces=
Starting Job = job_1602588028981_0109, Tracking URL =
Kill Command = /usr/hdp/ job -kill job_1602588028981_0109

@Salma_Mahak Issue is fixed, now you can run querys.

facing the same issue again unable to login into hive


Issue is resolved now. Please check.