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 - https://labs.itversity.com
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-

https://www.youtube.com/watch?v=N_uz0gcQCIc

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 = http://rm01.itversity.com:19088/proxy/application_1602588028981_0109/
Kill Command = /usr/hdp/2.6.5.0-292/hadoop/bin/hadoop job -kill job_1602588028981_0109

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