Support Questions
Find answers, ask questions, and share your expertise

why do we need to configure seperate DB for hive, flume, and others.

Explorer

Hi All,

I had setup HDP cluster using ambari UI.

Here I'm using postgres DB and would need to know why the DB to be configured for particular services only like hive, oozie and so on.

Please experts clarify more.

Thanks in advance.

1 ACCEPTED SOLUTION

Accepted Solutions

Cloudera Employee

Some of the services such as HIVE, OOZIE, Ranger need a back end database to store Meta-data, you can pick one DB such as mariadb/mysql for all these metadata stores and configure through ambari.

View solution in original post

3 REPLIES 3

Cloudera Employee

Some of the services such as HIVE, OOZIE, Ranger need a back end database to store Meta-data, you can pick one DB such as mariadb/mysql for all these metadata stores and configure through ambari.

View solution in original post

Explorer

@adash thanks for your comment. Why these particular services are getting connected with DB. pls could you explain in detail like what happens exactly when we are using Hive, Oozie, and Ranger.

Cloudera Employee

HIVE needs to store meta data such as Table structures, OOZIE needs to store Job details etc. you can go into the db schemas of each product and see what they store. Its a persistent mechanism for storing meta data, please look at the internal architecture of each component, it will be clear.