Skip to main content
dv_conan
Silver ⭐️⭐️⭐️
September 21, 2021
Solved

Prevent Impala from accessing Hive

Dear all, 

 

I'm installing CDP private cloud base and i have installed Hive, Hive on Tez, Impala and Kudu services on the cluster 

But for my use case i don't want impala to see hive database because i will use impala to work with kudu and i will use hive on tez to work with hive.

 

So, how can i separate impala from hive ?

 

 

smruti
smrutiAnswer
Gold ⭐️⭐️⭐️
September 24, 2021

@dv_conan  Although in Impala docs it says, you could use a metastore db directly without using Hive metastore service, it is not recommended.

https://impala.apache.org/docs/build/html/topics/impala_prereqs.html

 

In Cloudera CDP, you could not remove the dependency between Hive and Impala. Under Impala Configuration, you will see a greyed out tick box for Hive, which means it's not optional.

 

https://docs.cloudera.com/cdp-private-cloud-base/7.1.6/installation/topics/cdpdc-service-dependencies.html

2 replies

smruti
Gold ⭐️⭐️⭐️
smrutiAnswer
Gold ⭐️⭐️⭐️
September 24, 2021

@dv_conan  Although in Impala docs it says, you could use a metastore db directly without using Hive metastore service, it is not recommended.

https://impala.apache.org/docs/build/html/topics/impala_prereqs.html

 

In Cloudera CDP, you could not remove the dependency between Hive and Impala. Under Impala Configuration, you will see a greyed out tick box for Hive, which means it's not optional.

 

https://docs.cloudera.com/cdp-private-cloud-base/7.1.6/installation/topics/cdpdc-service-dependencies.html

Translate
VidyaSargur
Community Manager
Community Manager
September 29, 2021

@dv_conan, Has the reply helped resolve your issue? If so, please mark the appropriate reply as the solution, as it will make it easier for others to find the answer in the future. 

Translate
Regards, Vidya Sargur, Community Manager Was your question answered? Make sure to mark the answer as the accepted solution. If you find a reply useful, say thanks by clicking on the thumbs up button.