Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

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

Solved Go to solution
Highlighted

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
Highlighted

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

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
Highlighted

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

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

Highlighted

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

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.

Highlighted

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

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.

Don't have an account?
Coming from Hortonworks? Activate your account here